[postgis-users] Difference in area calculation pg vs. ora

[Gheorghiu, Mihai]

I loaded shapes from a .shp file in both oracle and pgis.
I compared them in OpenJump and no differences were found between the shapes in the two systems.
However when  calculate the areas (ST_Area & SDO_AREA) and I compare them shape by shape I encounter some significant differences (>5%).
Has anyone experienced that?

Thank you very much.

Michael


The information contained in this transmission is to be considered CONFIDENTIAL and PROPRIETARY to Consortium Health Plans, Inc. and intended for the use of the Individual or Entity named above.  If the reader of this message is not the Intended Recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is Strictly Prohibited.  If you have received this transmission in error, please notify us immediately by telephone at 410-772-2900 or return email to sender immediately.  Thank You.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110822/07098694/attachment.html>