Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SDO_LENGTH with geodetic data

Jonathan OwenFeb 14 2017 — edited Mar 19 2017

Hi,

I've noticed an issue/difference when calculating the length of a line string in spatial, I'm using geodetic coordinates (srid 8307). The length is different to that calculated by ArcGIS, FME, PostGIS and if I transform the data to a grid based system and use a bit of pythagoras in Excel. The 4 methods mentioned all give the same answer to within a few cm, whereas Oracle is off by 2 metres (this is for a line that is 725m long). This is a little worrying as the LRS package seems to use the same method and gets the same results, this is fine if I can back it up and replicate in the other systems - but if not then this causes a big big issue. Would someone please be able to advise on whether the Oracle results can be replicated in other systems?

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2017
Added on Feb 14 2017
24 comments
4,220 views