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 | -- |
---|
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, |
---|
9 | widmung |
---|
10 | INTO map_baeche_g0 |
---|
11 | FROM ax_gewaesserachse_merged GROUP BY ax_gewaesserachse_merged.widmung; |
---|
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 ); |
---|