I have a point feature class in an Oracle 18c GDB that is projected as NAD83 UTM 17N (SRID = 26917).
I would like to extract the X&Y coordinates from the points as WGS84 latitude & longitude decimal degrees (using SQL).
- The coordinates would be used to generate a Google Street View URL (hence the lat/long).
I think this can be done by using SDE.ST_GEOMETRY's ST_TRANSFORM function:
ST_Transform takes two-dimensional ST_Geometry data as input and returns values converted into the spatial reference specified by the spatial reference ID (SRID) you provide.
However, I'm stuck on the SRID part:
sde.st_x(sde.st_transform (shape, ??????)) as longitudex
Is there a specific SRID I should be using to convert the UTM points to WGS84 lat/long?