Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 14466

In set theory, the union (denoted by ∪) of a collection of sets is the set of all distinct elements in the collection. It is one of the fundamental operations through which sets can be combined and related to each other.

4 votes

Merge polygons in postgis

However, if polygon and sliver polygon only have one point in common, then union of these two geometries would not be valid. (or it will be MultiPolygon). …
Rauni's user avatar
  • 344
7 votes
Accepted

Merge polygons in postgis

SQL: UPDATE coverage SET the_geom = ST_Union( (SELECT the_geom FROM coverage WHERE id = :polygon_id), (SELECT the_geom FROM coverage WHERE id = :sliver_id) ) WHERE id = :polygon_id; Is that what Yo …
Rauni's user avatar
  • 344
4 votes

PostGIS algorithm to unite points of two geometries that are within specified radius

I will try to document things, that I already have tried. Maybe this will help others to provide good ideas. I read manual about ST_Buffer function: ST_Buffer There are interesting options about how …
Rauni's user avatar
  • 344