You might want to do a transform instead of setSRID. If you do a set and the coordinates arent in the correct coordinate system you will have more problems than mismatched SRIDs, but now they could be masked.
Rob From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Patricio Cifuentes Ithal Sent: Wednesday, June 20, 2007 10:19 AM To: 'PostGIS Users Discussion' Subject: RE: [postgis-users] Problem with "Different SRIDs" Set the geometry . WHERE setSRID (geometry,xxxx) && setSRID(box2d('BOX3D(-0.5 -0.302040816326531,0.5 0.302040816326531)'::box3d),29101) De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Juliano Zaban Enviado el: miércoles, 20 de junio de 2007 10:41 Para: [email protected] Asunto: [postgis-users] Problem with "Different SRIDs" Hello all! I'm trying to use PostGIS with SharpMap library to develop GIS applications. However when the PostGIS extension for SharpMap try to run the following query an error occurs: SELECT AsBinary(geometry) AS Geom FROM bairros WHERE geometry && setSRID(box2d('BOX3D(-0.5 -0.302040816326531,0.5 0.302040816326531)'::box3d),29101) ERROR: Operation on two geometries with different SRIDs SQL state: XX000 I believe the "bairros" layer is ok because I can edit it with OpenJUMP without problem... Anybody can help me with this? Thanks a lot! -- Este mensaje ha sido analizado por MailScanner <http://www.mailscanner.info/> en busca de virus y otros contenidos peligrosos, y se considera que está limpio. <http://www.siigsa.cl> www.siigsa.cl -- Este mensaje ha sido analizado por MailScanner <http://www.mailscanner.info/> en busca de virus y otros contenidos peligrosos, y se considera que está limpio. <http://www.siigsa.cl> www.siigsa.cl
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
