1 | DROP TABLE IF EXISTS map_wege_g0; |
---|
2 | -- |
---|
3 | SELECT |
---|
4 | (ST_Dump(ST_LineMerge(ST_Collect(ax_fahrwegachse.wkb_geometry)))).geom AS wkb_geometry, |
---|
5 | NULL::text AS widmung |
---|
6 | INTO map_wege_g0 |
---|
7 | FROM ax_fahrwegachse; |
---|
8 | -- |
---|
9 | DROP SEQUENCE IF EXISTS map_wege_g0_gid_seq; |
---|
10 | CREATE SEQUENCE map_wege_g0_gid_seq; |
---|
11 | ALTER TABLE map_wege_g0 ADD COLUMN gid INTEGER; |
---|
12 | UPDATE map_wege_g0 SET gid = nextval('map_wege_g0_gid_seq'); |
---|
13 | ALTER TABLE map_wege_g0 ALTER COLUMN gid SET DEFAULT nextval('map_wege_g0_gid_seq'); |
---|
14 | CREATE INDEX map_wege_g0_gidx ON map_wege_g0 USING GIST ( wkb_geometry ); |
---|
15 | CREATE INDEX map_wege_g0_widmung_idx ON map_wege_g0 (widmung); |
---|
16 | -- |
---|
17 | -- |
---|
18 | DROP TABLE IF EXISTS map_wege_g1; |
---|
19 | -- |
---|
20 | |
---|
21 | SELECT ST_SimplifyPreserveTopology(wkb_geometry, 5) AS wkb_geometry, widmung |
---|
22 | INTO map_wege_g1 |
---|
23 | FROM map_wege_g0 |
---|
24 | WHERE ST_Length( wkb_geometry ) > 5; |
---|
25 | -- |
---|
26 | DROP SEQUENCE IF EXISTS map_wege_g1_gid_seq; |
---|
27 | CREATE SEQUENCE map_wege_g1_gid_seq; |
---|
28 | ALTER TABLE map_wege_g1 ADD COLUMN gid INTEGER; |
---|
29 | UPDATE map_wege_g1 SET gid = nextval('map_wege_g1_gid_seq'); |
---|
30 | ALTER TABLE map_wege_g1 ALTER COLUMN gid SET DEFAULT nextval('map_wege_g1_gid_seq'); |
---|
31 | CREATE INDEX map_wege_g1_gidx ON map_wege_g1 USING GIST ( wkb_geometry ); |
---|
32 | CREATE INDEX map_wege_g1_widmung_idx ON map_wege_g1 (widmung); |
---|
33 | -- |
---|
34 | -- |
---|
35 | DROP TABLE IF EXISTS map_wege_g2; |
---|
36 | -- |
---|
37 | SELECT ST_SimplifyPreserveTopology(wkb_geometry, 15) AS wkb_geometry, widmung |
---|
38 | INTO map_wege_g2 |
---|
39 | FROM map_wege_g1 |
---|
40 | WHERE ST_Length( wkb_geometry ) > 15; |
---|
41 | -- |
---|
42 | DROP SEQUENCE IF EXISTS map_wege_g2_gid_seq; |
---|
43 | CREATE SEQUENCE map_wege_g2_gid_seq; |
---|
44 | ALTER TABLE map_wege_g2 ADD COLUMN gid INTEGER; |
---|
45 | UPDATE map_wege_g2 SET gid = nextval('map_wege_g2_gid_seq'); |
---|
46 | ALTER TABLE map_wege_g2 ALTER COLUMN gid SET DEFAULT nextval('map_wege_g2_gid_seq'); |
---|
47 | CREATE INDEX map_wege_g2_gidx ON map_wege_g2 USING GIST ( wkb_geometry ); |
---|
48 | CREATE INDEX map_wege_g2_widmung_idx ON map_wege_g2 (widmung); |
---|
49 | -- |
---|
50 | -- |
---|