[postgis-users] Problem with "Different SRIDs"

[Rob Tester]

You might want to do a transform instead of setSRID. If you do a set and the
coordinates aren’t in the correct coordinate system you will have more
problems than mismatched SRID’s, but now they could be masked.

 

Rob

 

 

 

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] En nombre de Juliano
Zaban
Enviado el: miércoles, 20 de junio de 2007 10:41
Para: postgis-users at postgis.refractions.net
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 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070620/d9a1963d/attachment.html>