how can i get Arcsde St_geometry into Lat long from oracle 12c

2421
7
10-16-2018 12:47 AM
shehrozesarfaraz
New Contributor

i am working on arcsde with oracle 12c can any one tell me where i can get st_geometry into lat long in Oracle 12c?? because in oracle, its shows only st_Geometry from geometry table. How do I generate a list of X,Y (projection WGS 1984) values from a geometry in Oracle / SDE?

arcgis 10.2 enterprise-geodatabase‌ arcsde oracle 12c# st_geometry‌ #latitude and longitude

0 Kudos
7 Replies
shehrozesarfaraz
New Contributor

PFA

How can i get st_Geom XY from sql developer(Oracle 12c)??

0 Kudos
George_Thompson
Esri Frequent Contributor

Have you configured the ST_Geometry function yet?

Configure the extproc to access ST_Geometry in Oracle—Help | ArcGIS Desktop 

Once you have that confirmed you can look at this: SQL functions used with ST_Geometry—Help | ArcGIS Desktop 

--- George T.
0 Kudos
shehrozesarfaraz
New Contributor

i am using sql developer for oracle 12c . in this tell me where i can get this St_geometry into XY??

0 Kudos
George_Thompson
Esri Frequent Contributor

When you run this SQL, what are the results?

select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;

--- George T.
0 Kudos
shehrozesarfaraz
New Contributor

see

0 Kudos
George_Thompson
Esri Frequent Contributor

Try logging in as the SDE user and running that query. If it does not return something like this:

SDE.ST_ASTEXT(SDE.ST_GEOMETRY('POINT(1010)',0))
--------------------------------------------------------------------------------
POINT  ( 10.00000000 10.00000000)

Then you need to get it configured correctly first, then you can use the SQL functions to extract the X/Y as needed.

How To: Check if the Oracle extproc is set up correctly for direct ST_GEOMETRY SQL queries 

--- George T.
0 Kudos