[mapserver-users] PostGreSQL8.2/PostGIS SQL Error

[Carlos Ruiz]

You have two tables with different SRIDs specified. You must use "setsrid(the_geom, xxxx)" to be able to handle both. This problem ocurrs when you didn't specify the SRID when using shp2pgsql, it takes -1 (default) instead the one that your layer haves.



IC Carlos Ruiz

--- On Thu, 8/7/08, Kenne, Bryon K. <BKenne at iso.com> wrote:
From: Kenne, Bryon K. <BKenne at iso.com>
Subject: [mapserver-users] PostGreSQL8.2/PostGIS SQL Error
To: mapserver-users at lists.osgeo.org
Date: Thursday, August 7, 2008, 3:00 PM

Does anybody know why the following select query returns this error? - 

ERROR: Operation on two geometries with different SRIDs
SQL state: XX000


SELECT * FROM sdghaz WHERE the_geom&&'BOX3D(-117.052660 32.854340,
-117.052664 32.854353)'::box3d AND distance(the_geom,
GeomFromText('POINT(-117.052662 32.854349)',4326))<0.00001

-Bryon
This email is intended for the recipient only.  If you are not the intended
recipient please disregard, and do not use the information for any purpose.
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080807/aba27d38/attachment.htm>