[postgis-users] Comparing Geometries with Different SRIDs

Charlie Savage cfis at savagexi.com
Sat Sep 27 16:43:30 PDT 2008


> The 2 point could be spatially equal given different SRIDS and
> coordinates if they were projected to a common SRID. So should geometry
> operators silently
> Call st_transform to make the righthand match the lefthand before
> comparing? This would be quite the expensive operation.

No. You can't automatically transform between different SRID values 
Think of the case of one geometry with an SRID value of 4326 and one 
with an SRID value of -1 (no coordinate system).

So different SRID values, then the geometries are not equal.  It is up 
to the user to transform geometries to the same SRID before calling 
ST_EQUALS.

Charlie
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3237 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080927/a9036435/attachment.bin>


More information about the postgis-users mailing list