Question

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

  • 18 March 2020
  • 2 replies
  • 30 views

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

Badge +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

Badge +11

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

Reply