Changeset 118 for trunk/data/konvert/postnas_0.6/atkis_rp_rendering/processing/sql/stehendesgewaesser_prep.sql

Timestamp:

11/02/11 16:21:26 (12 years ago)

Author:

tobias.dick

Message:

Bugfixes

File:

• trunk/data/konvert/postnas_0.6/atkis_rp_rendering/processing/sql/stehendesgewaesser_prep.sql (modified) (1 diff)

trunk/data/konvert/postnas_0.6/atkis_rp_rendering/processing/sql/stehendesgewaesser_prep.sql

@@ -5 +5 @@
 SELECT 
 wkb_geometry,
-NULL::text AS widmung
+widmung
 INTO map_stehendesgewaesser_g0 
 
 FROM (
-        SELECT (ST_Dump( ST_Union( ax_stehendesgewaesser.wkb_geometry ))).geom AS wkb_geometry
-        FROM ax_stehendesgewaesser
+        SELECT (ST_Dump( ST_Union( ax_stehendesgewaesser.wkb_geometry ))).geom AS wkb_geometry, unverschluesselt as widmung 
+        FROM ax_stehendesgewaesser GROUP BY widmung 
 ) AS wrapper; 
 --