[postgis-users] HOWTO Identify a polygon object by point??
dblasby at refractions.net
Wed Oct 30 13:42:51 PST 2002
Düster Horst wrote:
The "&&" operator will select the polygons whose bounding box intersects the
point. It indexed so its a very fast search.
If you want a better answer, use the distance() function.
SELECT number FROM parcels WHERE wkb_geometry && GeometryFromText('POINT(624000
245600)',-1) AND distance(wkb_geometry, GeometryFromText('POINT(624000
More information about the postgis-users