[114] | 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'); |
---|