Changes between Version 2 and Version 3 of UsersWikiExamplesPolygonOverlaps
- Timestamp:
- 03/10/11 05:54:53 (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UsersWikiExamplesPolygonOverlaps
v2 v3 40 40 $Id: pgoverlap_wiki.sql 2011-03-09 15:19Z Birgit Laggner $ 41 41 42 pgoverlap - checks table for overlapping geometries sep erating between sliver and non-sliver overlappings, returns table with non-overlapping geometries and adjusted sliver-overlapping polygons as well as table with non-sliver overlappings (for later treatment)42 pgoverlap - checks table for overlapping geometries separating between sliver and non-sliver overlappings, returns table with non-overlapping geometries and adjusted sliver-overlapping polygons as well as table with non-sliver overlappings (for later treatment) 43 43 44 44 schema_a: database schema where table is located … … 255 255 256 256 257 --Insert non-sliver polygons into sep erate table:257 --Insert non-sliver polygons into separate table: 258 258 259 259 BEGIN … … 279 279 'SELECT AddGeometryColumn('''||schema_a||''', '''||table_result2||''',''i_geom'',(SELECT DISTINCT ST_SRID(the_geom) FROM '||schema_a||'.'||table_a||'),''POLYGON'',2);'; 280 280 281 RAISE NOTICE 'Inserting non-sliver polygons into sep erate table. ';281 RAISE NOTICE 'Inserting non-sliver polygons into separate table. '; 282 282 283 283 EXECUTE