Select to view content in your preferred language

ST_Length units?

1252
3
04-08-2020 09:34 AM
VincentLaunstorfer
Frequent Contributor

Hi,

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.

0 Kudos
3 Replies
George_Thompson
Esri Notable Contributor

Adding a broader audience: Geodatabase

--- George T.
0 Kudos
VincentLaunstorfer
Frequent Contributor

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

0 Kudos
George_Thompson
Esri Notable Contributor

At this point, it may be easier to re-post the question in the Community.

--- George T.
0 Kudos