[postgis-users] selecting features intersecting a multipolygon

[nicklas.aven at jordogskog.no]

Hi
 
you have to input a string to geomtfromtext
 
like this:
 
GeomFromText('MULTIPOLYGON(((-119.2 33.46, -118.7 333.46, -118.7 32.66, -119.2 33.66, -119.2 33.46))) ')

/Nicklas Avén

2009-04-24 Malm Paul wrote:

>Hi,>I´m trying this:>SELECT submapid, mapid, blob, AsText(the_geom) as the_geom >FROM submap WHERE 
>the_geom && GeomFromText(MULTIPOLYGON(((-119.2 33.46, -118.7 333.46, -118.7 32.66, -119.2 33.66, -119.2 33.46))) ) 
>>I´ve also tried this:>>SELECT submapid, mapid, blob, AsText(the_geom) as the_geom >FROM submap WHERE 
>the_geom && GeomFromText(MULTIPOLYGON(((-119.2 33.46, -118.7 333.46, -118.7 32.66, -119.2 33.66))) ) > >>
But all I'm getting is this:>
>ERROR:  syntax error at or near "33.46"
>RAD 2: the_geom && GeomFromText(MULTIPOLYGON(((-119.2 33.46, -118....
>                                                       ^>
********** Error **********>
ERROR: syntax error at or near "33.46"
>SQL state: 42601
>Character: 127>
 >
 >
I would be happy if someone could tell me what I´m doing wrong?>
 >
Kind regards,>
Paul
>>
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090424/cf3119d9/attachment.html>