Changes between Version 2 and Version 3 of UsersWikiExamplesPolygonOverlaps


Ignore:
Timestamp:
03/10/11 05:54:53 (14 years ago)
Author:
blaggner
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • UsersWikiExamplesPolygonOverlaps

    v2 v3  
    4040$Id: pgoverlap_wiki.sql 2011-03-09 15:19Z Birgit Laggner $
    4141
    42 pgoverlap - checks table for overlapping geometries seperating 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)
     42pgoverlap - 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)
    4343
    4444schema_a:      database schema where table is located
     
    255255
    256256
    257 --Insert non-sliver polygons into seperate table:
     257--Insert non-sliver polygons into separate table:
    258258
    259259BEGIN
     
    279279'SELECT AddGeometryColumn('''||schema_a||''', '''||table_result2||''',''i_geom'',(SELECT DISTINCT ST_SRID(the_geom) FROM '||schema_a||'.'||table_a||'),''POLYGON'',2);';
    280280
    281 RAISE NOTICE 'Inserting non-sliver polygons into seperate table. ';
     281RAISE NOTICE 'Inserting non-sliver polygons into separate table. ';
    282282
    283283EXECUTE