[postgis-users] selecting features intersecting a multipolygon

Malm Paul paul.malm at saabgroup.com
Fri Apr 24 03:37:22 PDT 2009


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/9aa72f55/attachment.html>


More information about the postgis-users mailing list