[postgis-users] Problem with "Different SRIDs"

[Patricio Cifuentes Ithal]

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
en busca de virus y otros contenidos peligrosos,
y se considera que está limpio.

www.siigsa.cl

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