[114] | 1 | DROP TABLE IF EXISTS map_bahn_g0; |
---|
| 2 | -- |
---|
| 3 | SELECT |
---|
| 4 | (ST_Dump(ST_LineMerge(ST_Collect(ST_SimplifyPreserveTopology(ax_bahnstrecke.wkb_geometry, 2.5))))).geom AS wkb_geometry, NULL::text AS widmung |
---|
| 5 | INTO map_bahn_g0 |
---|
| 6 | FROM ax_bahnstrecke; |
---|
| 7 | -- |
---|
| 8 | DROP SEQUENCE IF EXISTS map_bahn_g0_gid_seq; |
---|
| 9 | CREATE SEQUENCE map_bahn_g0_gid_seq; |
---|
| 10 | ALTER TABLE map_bahn_g0 ADD COLUMN gid INTEGER; |
---|
| 11 | UPDATE map_bahn_g0 SET gid = nextval('map_bahn_g0_gid_seq'); |
---|
| 12 | ALTER TABLE map_bahn_g0 ALTER COLUMN gid SET DEFAULT nextval('map_bahn_g0_gid_seq'); |
---|
| 13 | CREATE INDEX map_bahn_g0_gidx ON map_bahn_g0 USING GIST ( wkb_geometry ); |
---|
| 14 | CREATE INDEX map_bahn_g0_widmung_idx ON map_bahn_g0 (widmung); |
---|
| 15 | -- |
---|
| 16 | -- |
---|
| 17 | DROP TABLE IF EXISTS map_bahn_g1; |
---|
| 18 | -- |
---|
| 19 | |
---|
| 20 | SELECT ST_SimplifyPreserveTopology(wkb_geometry, 5) AS wkb_geometry, widmung |
---|
| 21 | INTO map_bahn_g1 |
---|
| 22 | FROM map_bahn_g0 |
---|
| 23 | WHERE ST_Length( wkb_geometry ) > 45; |
---|
| 24 | -- |
---|
| 25 | DROP SEQUENCE IF EXISTS map_bahn_g1_gid_seq; |
---|
| 26 | CREATE SEQUENCE map_bahn_g1_gid_seq; |
---|
| 27 | ALTER TABLE map_bahn_g1 ADD COLUMN gid INTEGER; |
---|
| 28 | UPDATE map_bahn_g1 SET gid = nextval('map_bahn_g1_gid_seq'); |
---|
| 29 | ALTER TABLE map_bahn_g1 ALTER COLUMN gid SET DEFAULT nextval('map_bahn_g1_gid_seq'); |
---|
| 30 | CREATE INDEX map_bahn_g1_gidx ON map_bahn_g1 USING GIST ( wkb_geometry ); |
---|
| 31 | CREATE INDEX map_bahn_g1_widmung_idx ON map_bahn_g1 (widmung); |
---|
| 32 | -- |
---|
| 33 | -- |
---|
| 34 | DROP TABLE IF EXISTS map_bahn_g2; |
---|
| 35 | -- |
---|
| 36 | SELECT ST_SimplifyPreserveTopology(wkb_geometry, 25) AS wkb_geometry, widmung |
---|
| 37 | INTO map_bahn_g2 |
---|
| 38 | FROM map_bahn_g1 |
---|
| 39 | WHERE ST_Length( wkb_geometry ) > 90; |
---|
| 40 | -- |
---|
| 41 | DROP SEQUENCE IF EXISTS map_bahn_g2_gid_seq; |
---|
| 42 | CREATE SEQUENCE map_bahn_g2_gid_seq; |
---|
| 43 | ALTER TABLE map_bahn_g2 ADD COLUMN gid INTEGER; |
---|
| 44 | UPDATE map_bahn_g2 SET gid = nextval('map_bahn_g2_gid_seq'); |
---|
| 45 | ALTER TABLE map_bahn_g2 ALTER COLUMN gid SET DEFAULT nextval('map_bahn_g2_gid_seq'); |
---|
| 46 | CREATE INDEX map_bahn_g2_gidx ON map_bahn_g2 USING GIST ( wkb_geometry ); |
---|
| 47 | CREATE INDEX map_bahn_g2_widmung_idx ON map_bahn_g2 (widmung); |
---|
| 48 | -- |
---|
| 49 | -- |
---|
| 50 | DROP TABLE IF EXISTS map_bahn_g3; |
---|
| 51 | -- |
---|
| 52 | SELECT ST_SimplifyPreserveTopology(wkb_geometry, 50) AS wkb_geometry, widmung |
---|
| 53 | INTO map_bahn_g3 |
---|
| 54 | FROM map_bahn_g2 |
---|
| 55 | WHERE ST_Length( wkb_geometry ) > 90; |
---|
| 56 | -- |
---|
| 57 | DROP SEQUENCE IF EXISTS map_bahn_g3_gid_seq; |
---|
| 58 | CREATE SEQUENCE map_bahn_g3_gid_seq; |
---|
| 59 | ALTER TABLE map_bahn_g3 ADD COLUMN gid INTEGER; |
---|
| 60 | UPDATE map_bahn_g3 SET gid = nextval('map_bahn_g3_gid_seq'); |
---|
| 61 | ALTER TABLE map_bahn_g3 ALTER COLUMN gid SET DEFAULT nextval('map_bahn_g3_gid_seq'); |
---|
| 62 | CREATE INDEX map_bahn_g3_gidx ON map_bahn_g3 USING GIST ( wkb_geometry ); |
---|
| 63 | CREATE INDEX map_bahn_g3_widmung_idx ON map_bahn_g3 (widmung); |
---|
| 64 | -- |
---|
| 65 | -- |
---|
| 66 | DROP TABLE IF EXISTS map_bahn_g4; |
---|
| 67 | -- |
---|
| 68 | SELECT ST_SimplifyPreserveTopology(wkb_geometry, 150) AS wkb_geometry, widmung |
---|
| 69 | INTO map_bahn_g4 |
---|
| 70 | FROM map_bahn_g3 |
---|
| 71 | WHERE ST_Length( wkb_geometry ) > 90; |
---|
| 72 | -- |
---|
| 73 | DROP SEQUENCE IF EXISTS map_bahn_g4_gid_seq; |
---|
| 74 | CREATE SEQUENCE map_bahn_g4_gid_seq; |
---|
| 75 | ALTER TABLE map_bahn_g4 ADD COLUMN gid INTEGER; |
---|
| 76 | UPDATE map_bahn_g4 SET gid = nextval('map_bahn_g4_gid_seq'); |
---|
| 77 | ALTER TABLE map_bahn_g4 ALTER COLUMN gid SET DEFAULT nextval('map_bahn_g4_gid_seq'); |
---|
| 78 | CREATE INDEX map_bahn_g4_gidx ON map_bahn_g4 USING GIST ( wkb_geometry ); |
---|
| 79 | CREATE INDEX map_bahn_g4_widmung_idx ON map_bahn_g4 (widmung); |
---|