1 | -- map_wald_g0 [Echtdaten, zusammengefasst nach Vegetationsmerkmal] |
---|
2 | -- Laufzeit gesamt: 364" |
---|
3 | -- ST_GeometryType(): ST_Polygon |
---|
4 | -- ST_IsSimple(): WAHR |
---|
5 | -- ST_IsEmpty(): FALSE |
---|
6 | -- ST_IsValid(): WAHR |
---|
7 | -- COUNT(*): 55019 |
---|
8 | -- SUM(ST_NPoints()): 4058371 |
---|
9 | DROP TABLE IF EXISTS map_wald_g0; |
---|
10 | DROP SEQUENCE IF EXISTS map_wald_g0_gid_seq; |
---|
11 | -- |
---|
12 | SELECT (ST_Dump( ST_Union( ax_wald.wkb_geometry ))).geom AS wkb_geometry, vegetationsmerkmal AS widmung |
---|
13 | INTO map_wald_g0 |
---|
14 | FROM ax_wald |
---|
15 | GROUP BY vegetationsmerkmal; |
---|
16 | -- |
---|
17 | CREATE INDEX map_wald_g0_gidx ON map_wald_g0 USING GIST ( wkb_geometry ); |
---|
18 | CREATE SEQUENCE map_wald_g0_gid_seq; |
---|
19 | ALTER TABLE map_wald_g0 ADD COLUMN gid INTEGER; |
---|
20 | UPDATE map_wald_g0 SET gid = nextval('map_wald_g0_gid_seq'); |
---|
21 | ALTER TABLE map_wald_g0 ALTER COLUMN gid SET DEFAULT nextval('map_wald_g0_gid_seq'); |
---|
22 | -- |
---|
23 | -- |
---|
24 | DROP TABLE IF EXISTS map_wald_g1; |
---|
25 | DROP SEQUENCE IF EXISTS map_wald_g1_gid_seq; |
---|
26 | -- |
---|
27 | -- map_wald_g1 [Echtdaten, keine Differenzierung mehr nach Vegetationsart] |
---|
28 | -- Laufzeit gesamt: 563" |
---|
29 | -- ST_GeometryType(): ST_Polygon |
---|
30 | -- ST_IsSimple(): WAHR |
---|
31 | -- ST_IsEmpty(): FALSCH |
---|
32 | -- ST_IsValid(): WAHR |
---|
33 | -- COUNT(*): 19164 |
---|
34 | -- SUM(ST_NPoints()): 1958223 |
---|
35 | SELECT (ST_Dump(ST_Union( wkb_geometry ))).geom AS wkb_geometry, NULL::text AS widmung |
---|
36 | INTO map_wald_g1 |
---|
37 | FROM map_wald_g0; |
---|
38 | -- Index und Sequenz |
---|
39 | CREATE INDEX map_wald_g1_gidx ON map_wald_g1 USING GIST ( wkb_geometry ); |
---|
40 | CREATE SEQUENCE map_wald_g1_gid_seq; |
---|
41 | ALTER TABLE map_wald_g1 ADD COLUMN gid INTEGER; |
---|
42 | UPDATE map_wald_g1 SET gid = nextval('map_wald_g1_gid_seq'); |
---|
43 | ALTER TABLE map_wald_g1 ALTER COLUMN gid SET DEFAULT nextval('map_wald_g1_gid_seq'); |
---|