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. <[EMAIL PROTECTED]> wrote:
From: Kenne, Bryon K. <[EMAIL PROTECTED]>
Subject: [mapserver-users] PostGreSQL8.2/PostGIS SQL Error
To: mapserver-users@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
