Changeset 118 for trunk/data
- Timestamp:
- 11/02/11 16:21:26 (12 years ago)
- Location:
- trunk/data/konvert/postnas_0.6/atkis_rp_rendering/processing/sql
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/data/konvert/postnas_0.6/atkis_rp_rendering/processing/sql/baeche_full.sql
r114 r118 1 DROP TABLE IF EXISTS ax_gewaesserachse_merged; 2 -- 3 SELECT ax_gewaesserachse.wkb_geometry, ax_wasserlauf.name_ as widmung into ax_gewaesserachse_merged from ax_wasserlauf INNER JOIN alkis_beziehungen ON (alkis_beziehungen.beziehung_zu = ax_wasserlauf.gml_id) INNER JOIN ax_gewaesserachse ON 4 (ax_gewaesserachse.gml_id=alkis_beziehungen.beziehung_von); 5 -- 1 6 DROP TABLE IF EXISTS map_baeche_g0; 2 7 -- 3 8 SELECT (ST_Dump(ST_Linemerge(ST_Collect(ST_SimplifyPreserveTopology( wkb_geometry, 2.5 ))))).geom AS wkb_geometry, 4 NULL::text ASwidmung9 widmung 5 10 INTO map_baeche_g0 6 FROM ax_gewaesserachse ;11 FROM ax_gewaesserachse_merged GROUP BY ax_gewaesserachse_merged.widmung; 7 12 -- 8 13 DROP SEQUENCE IF EXISTS map_baeche_g0_gid_seq; -
trunk/data/konvert/postnas_0.6/atkis_rp_rendering/processing/sql/stehendesgewaesser_prep.sql
r114 r118 5 5 SELECT 6 6 wkb_geometry, 7 NULL::text ASwidmung7 widmung 8 8 INTO map_stehendesgewaesser_g0 9 9 10 10 FROM ( 11 SELECT (ST_Dump( ST_Union( ax_stehendesgewaesser.wkb_geometry ))).geom AS wkb_geometry 12 FROM ax_stehendesgewaesser 11 SELECT (ST_Dump( ST_Union( ax_stehendesgewaesser.wkb_geometry ))).geom AS wkb_geometry, unverschluesselt as widmung 12 FROM ax_stehendesgewaesser GROUP BY widmung 13 13 ) AS wrapper; 14 14 --
Note: See TracChangeset
for help on using the changeset viewer.