[postgis-users] Discovering where roads cross rivers

[Dave Potts]

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 at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Thank you, worked a treat!

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/20070916/c12f0157/attachment.vcf>