[postgis-users] performing an intersection: syntax issue
Steven De Vriendt
gisaalter at gmail.com
Wed Mar 12 13:26:26 PDT 2008
Hi list,
I'm trying to perform an intersection on 2 datasets.
I'm trying to base my syntax as provided by bostongis.com
http://www.bostongis.com/postgis_intersection_intersects.snippet
So I have a dataset of state boundaries and major higways in that state.
I want to achieve a query where I want to select all major highways
that cross a state based on the name of that state
this is my syntax:
select tbl_refgem_2006.the_geom, tbl_majhwys_lam72.the_geom FROM
tbl_refgem_2006 INNER JOIN majhwys_lam72 ON
ST_Intersection(tbl_refgem_2006.the_geom, tbl_majhwys_lam72.the_geom)
WHERE tbl_refgem="Aalter";
I get the error message:
ERROR: missing FROM-clause entry for table "tbl_majhwys_lam72"
LINE 1: ...am72 ON ST_Intersection(tbl_refgem_2006.the_geom, tbl_majhwy...
Can anyone help me out building this query ?
Thanks
Steven
More information about the postgis-users
mailing list