In Oracle, I am trying to calclulate length for lines stored as ST_Geometry in SRID 4326 (WGS84).
Unfortunately, the ST_Length function calculates in the units of the SRID and it is not usable neither meaningful. Looking at the SDE documentation, I am surprised it does not look possible to select an output unit in geodesic meter, kilometer, miles... as in the ST_Distance function.
ST_Length—Help | Documentation
Is there any workaround? It look like there is a possibility with the ST_Transform on the fly. However, as soon as you transform geodesic data into planar data, there will be some sort of errors introduced because my dataset is global.
Any help will be appreciated.
Hi George, a while ago, you managed to forward my question above to a broader audience... How to you do that? Is there topic completely transferred to the more targeted community that way? Thanks
At this point, it may be easier to re-post the question in the Community.