[postgis-users] Postgis FDO native driver

Dave Potts dave.potts at pinan.co.uk
Mon Aug 6 12:43:07 PDT 2007

I have a table with a list of places described as Geometry type POINT 
and a table loaded from a shape file,  which takes the form of target 
(ie several inscribed circles), each is encoded as a MULTIPOLYGON.  I am 
attempting to discover which point lie within within these circle.

I had assumed that something like

select place_name,gid,id,gridcode,area(the_geom) , 
within(the_geom,os_ngr) from shptbl,place_table wherein (the_geom,os_ngr) ;

would return every geometry ie os_ngr which is within the geometry  
boundries of the_geom.

Where place_name,os_ngr come from place_table and the_geom comes from 
the table shptbl.

Both geometry have the same sri, no errors are listed in the postgres 
log files. 

I have assume that within covers data types of different types (ie POINT 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: dave.potts.vcf
Type: text/x-vcard
Size: 85 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070806/0041deac/attachment.vcf>

More information about the postgis-users mailing list