Skip to main content
Question

How do I calculate the length of a line string with points stored in Oracle Spatial SDO_GEOMETRY?


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?

2 replies

Forum|alt.badge.img+2

@saulsja You should be able to use the LengthCalculator. If your data is geographic, then try the GeographicLengthCalculator that is available form FME HUB


steveatsafe
Safer
Forum|alt.badge.img+12

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).


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings