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
and MULTIPOLYGON)
Dave.
begin:vcard
fn:David Potts
n:Potts;David
x-mozilla-html:FALSE
version:2.1
end:vcard
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
