Kyng Chaos
“The beast is actively interested only in now, and, as it is always now and always shall be, there is an eternity of time for the accomplishment of objects.”
- the wisdom of Tarzan

Temporary GIS Images

PostGIS containment operators

ST_Overlaps() – only polygons selected where their boundaries touch the box boundary and any part of the polygon area is inside the box.

ST_Intersects() – all polygons selected where any part of the polygon (boundary and inside) are in or touch any part of the box, though it seems to have missed some from the upper-right neighboring cells.

ST_CoveredBy() – only polygons where the boundary and area are completely inside only the area of the box and not touching the box boundary.

ST_Within() – similar to st_coveredby, except that it only seems to look at the outer boundary of the polygons, and that upper-right corner polygon is actually an invalid polygon where the "outer" polygon is "hole" polygon (not visible here), thus inside and not touching the box boundary.

gallery/gis/temp/index.txt · Last modified: 2008/12/04 09:53 by kyngchaos
Copyright © 2004-2010 William Kyngesburye Driven by DokuWiki Recent changes RSS feed