Paul Ramsey wrote:
SELECT m.name from transport m, rivers r where
ST_Intersects(m.the_geom, r.the_geom);
On 15-Sep-07, at 8:03 AM, Dave Potts wrote:
I am trying to discover all the data points when a river system
crosses a road system, my data is expressed as two different
shapefiles, I had assumed that it was just a case of calling the
Intersection method
eg. select m.name from transport m , rivers r where
Intersection(r.the_geom,m.the_geom) = 't';
But I get a 'parse error- invaid geometry when I try this, is this
the correct way of doing this?
Dave.
<dave.potts.vcf>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Thank you, worked a treat!
Dave.
begin:vcard
fn:David Potts
n:Potts;David
x-mozilla-html:FALSE
version:2.1
end:vcard
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
