I need to update some measurements of line strings. How do I calculate the length of a line string with points stored in Oracle Spatial SDO_GEOMETRY?
Question
How do I calculate the length of a line string with points stored in Oracle Spatial SDO_GEOMETRY?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
@saulsja You should be able to use the LengthCalculator. If your data is geographic, then try the GeographicLengthCalculator that is available form FME HUB
+13- Safer
- 422 replies
Not to turn you away from FME but this could also be done in Oracle with SQL using SDO_GEOM.SDO_LENGTH (check out Oracle's Docs for usage and parameters). This could also be called via FME's SQLCreator/Executer as well.
I'm also assuming you are referring to one geometry (that contains a line string) versus two features - and you want to calculate the distance between those two points (geometries).