[118] | 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 | -- |
---|
[114] | 6 | DROP TABLE IF EXISTS map_baeche_g0; |
---|
| 7 | -- |
---|
| 8 | SELECT (ST_Dump(ST_Linemerge(ST_Collect(ST_SimplifyPreserveTopology( wkb_geometry, 2.5 ))))).geom AS wkb_geometry, |
---|
[118] | 9 | widmung |
---|
[114] | 10 | INTO map_baeche_g0 |
---|
[118] | 11 | FROM ax_gewaesserachse_merged GROUP BY ax_gewaesserachse_merged.widmung; |
---|
[114] | 12 | -- |
---|
| 13 | DROP SEQUENCE IF EXISTS map_baeche_g0_gid_seq; |
---|
| 14 | CREATE SEQUENCE map_baeche_g0_gid_seq; |
---|
| 15 | ALTER TABLE map_baeche_g0 ADD COLUMN gid INTEGER; |
---|
| 16 | UPDATE map_baeche_g0 SET gid = nextval('map_baeche_g0_gid_seq'); |
---|
| 17 | ALTER TABLE map_baeche_g0 ALTER COLUMN gid SET DEFAULT nextval('map_baeche_g0_gid_seq'); |
---|
| 18 | CREATE INDEX map_baeche_g0_gidx ON map_baeche_g0 USING GIST ( wkb_geometry ); |
---|
| 19 | -- |
---|
| 20 | -- |
---|
| 21 | DROP TABLE IF EXISTS map_baeche_g1; |
---|
| 22 | -- |
---|
| 23 | SELECT (ST_Dump(ST_SimplifyPreserveTopology( wkb_geometry, 5 ))).geom AS wkb_geometry, widmung |
---|
| 24 | INTO map_baeche_g1 |
---|
| 25 | FROM map_baeche_g0; |
---|
| 26 | -- |
---|
| 27 | DROP SEQUENCE IF EXISTS map_baeche_g1_gid_seq; |
---|
| 28 | CREATE SEQUENCE map_baeche_g1_gid_seq; |
---|
| 29 | ALTER TABLE map_baeche_g1 ADD COLUMN gid INTEGER; |
---|
| 30 | UPDATE map_baeche_g1 SET gid = nextval('map_baeche_g1_gid_seq'); |
---|
| 31 | ALTER TABLE map_baeche_g1 ALTER COLUMN gid SET DEFAULT nextval('map_baeche_g1_gid_seq'); |
---|
| 32 | CREATE INDEX map_baeche_g1_gidx ON map_baeche_g1 USING GIST ( wkb_geometry ); |
---|
| 33 | -- |
---|
| 34 | -- |
---|
| 35 | DROP TABLE IF EXISTS map_baeche_g2; |
---|
| 36 | -- |
---|
| 37 | SELECT (ST_Dump(ST_SimplifyPreserveTopology( wkb_geometry, 15 ))).geom AS wkb_geometry, widmung |
---|
| 38 | INTO map_baeche_g2 |
---|
| 39 | FROM map_baeche_g1; |
---|
| 40 | -- |
---|
| 41 | DROP SEQUENCE IF EXISTS map_baeche_g2_gid_seq; |
---|
| 42 | CREATE SEQUENCE map_baeche_g2_gid_seq; |
---|
| 43 | ALTER TABLE map_baeche_g2 ADD COLUMN gid INTEGER; |
---|
| 44 | UPDATE map_baeche_g2 SET gid = nextval('map_baeche_g2_gid_seq'); |
---|
| 45 | ALTER TABLE map_baeche_g2 ALTER COLUMN gid SET DEFAULT nextval('map_baeche_g2_gid_seq'); |
---|
| 46 | CREATE INDEX map_baeche_g2_gidx ON map_baeche_g2 USING GIST ( wkb_geometry ); |
---|
| 47 | -- |
---|
| 48 | -- |
---|
| 49 | DROP TABLE IF EXISTS map_baeche_g3; |
---|
| 50 | -- |
---|
| 51 | SELECT (ST_Dump(ST_SimplifyPreserveTopology( wkb_geometry, 35 ))).geom AS wkb_geometry, widmung |
---|
| 52 | INTO map_baeche_g3 |
---|
| 53 | FROM map_baeche_g2; |
---|
| 54 | -- |
---|
| 55 | DROP SEQUENCE IF EXISTS map_baeche_g3_gid_seq; |
---|
| 56 | CREATE SEQUENCE map_baeche_g3_gid_seq; |
---|
| 57 | ALTER TABLE map_baeche_g3 ADD COLUMN gid INTEGER; |
---|
| 58 | UPDATE map_baeche_g3 SET gid = nextval('map_baeche_g3_gid_seq'); |
---|
| 59 | ALTER TABLE map_baeche_g3 ALTER COLUMN gid SET DEFAULT nextval('map_baeche_g3_gid_seq'); |
---|
| 60 | CREATE INDEX map_baeche_g3_gidx ON map_baeche_g3 USING GIST ( wkb_geometry ); |
---|
| 61 | -- |
---|
| 62 | -- |
---|
| 63 | DROP TABLE IF EXISTS map_baeche_g4; |
---|
| 64 | -- |
---|
| 65 | SELECT (ST_Dump(ST_SimplifyPreserveTopology( wkb_geometry, 65 ))).geom AS wkb_geometry, widmung |
---|
| 66 | INTO map_baeche_g4 |
---|
| 67 | FROM map_baeche_g3; |
---|
| 68 | -- |
---|
| 69 | DROP SEQUENCE IF EXISTS map_baeche_g4_gid_seq; |
---|
| 70 | CREATE SEQUENCE map_baeche_g4_gid_seq; |
---|
| 71 | ALTER TABLE map_baeche_g4 ADD COLUMN gid INTEGER; |
---|
| 72 | UPDATE map_baeche_g4 SET gid = nextval('map_baeche_g4_gid_seq'); |
---|
| 73 | ALTER TABLE map_baeche_g4 ALTER COLUMN gid SET DEFAULT nextval('map_baeche_g4_gid_seq'); |
---|
| 74 | CREATE INDEX map_baeche_g4_gidx ON map_baeche_g4 USING GIST ( wkb_geometry ); |
---|
| 75 | -- |
---|
| 76 | -- |
---|
| 77 | DROP TABLE IF EXISTS map_baeche_g5; |
---|
| 78 | -- |
---|
| 79 | SELECT (ST_Dump(ST_SimplifyPreserveTopology( wkb_geometry, 125 ))).geom AS wkb_geometry, widmung |
---|
| 80 | INTO map_baeche_g5 |
---|
| 81 | FROM map_baeche_g4; |
---|
| 82 | -- |
---|
| 83 | DROP SEQUENCE IF EXISTS map_baeche_g5_gid_seq; |
---|
| 84 | CREATE SEQUENCE map_baeche_g5_gid_seq; |
---|
| 85 | ALTER TABLE map_baeche_g5 ADD COLUMN gid INTEGER; |
---|
| 86 | UPDATE map_baeche_g5 SET gid = nextval('map_baeche_g5_gid_seq'); |
---|
| 87 | ALTER TABLE map_baeche_g5 ALTER COLUMN gid SET DEFAULT nextval('map_baeche_g5_gid_seq'); |
---|
| 88 | CREATE INDEX map_baeche_g5_gidx ON map_baeche_g5 USING GIST ( wkb_geometry ); |
---|
| 89 | -- |
---|
| 90 | -- |
---|
| 91 | DROP TABLE IF EXISTS map_baeche_g6; |
---|
| 92 | -- |
---|
| 93 | SELECT (ST_Dump(ST_SimplifyPreserveTopology( wkb_geometry, 250 ))).geom AS wkb_geometry, widmung |
---|
| 94 | INTO map_baeche_g6 |
---|
| 95 | FROM map_baeche_g5; |
---|
| 96 | -- |
---|
| 97 | DROP SEQUENCE IF EXISTS map_baeche_g6_gid_seq; |
---|
| 98 | CREATE SEQUENCE map_baeche_g6_gid_seq; |
---|
| 99 | ALTER TABLE map_baeche_g6 ADD COLUMN gid INTEGER; |
---|
| 100 | UPDATE map_baeche_g6 SET gid = nextval('map_baeche_g6_gid_seq'); |
---|
| 101 | ALTER TABLE map_baeche_g6 ALTER COLUMN gid SET DEFAULT nextval('map_baeche_g6_gid_seq'); |
---|
| 102 | CREATE INDEX map_baeche_g6_gidx ON map_baeche_g6 USING GIST ( wkb_geometry ); |
---|