[postgis-users] Discovering where roads cross rivers

Dave Potts dave.potts at pinan.co.uk
Sat Sep 15 08:03:32 PDT 2007


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.
>   

-------------- 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/20070915/a92c21e6/attachment.vcf>


More information about the postgis-users mailing list