nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to get the lat and long from feature table in Oracle DB

DRae

Hi I heard that in MS SQL, we can do the following

select shape, shape.STX as LONG, shape.STY as LAT from sde.fc

If my Geodatabase is in Oracle, and how can I get the STX and STY from the shape column. I tried the above and it return

ORA-00904: "SHAPE"."STX": invalid identifier
00904. 00000 - "%s: invalid identifier"

Encontre mais publicações marcadas com

Geodatabase

Accepted answers

George_Thompson

If you have ST_Geometry configured (https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/configure-oracle-extproc.htm) you could use ST functions to do this: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/stgeometry-oracle.htm (reference doc: https://pro.arcgis.com/en/pro-app/latest/help/data/databases/pdf/stgeometry_reference.pdf - look at p336 (ST_X / ST_Y).

That would be where I would start.

All comments

George_Thompson

That would be where I would start.

DRae

Thanks. I am able to do as below

select sde.st_x(shape) from fc

VinceAngelo

Note that you should never store user data in the SDE schema, so the "from sde.fc" part is a problem. Best practice is to create a new login to own spatial data (and a new tablespace to store the data for that login). Using the SDE login for this is akin to using SYSTEM or DBO for noodling, or web surfing the dark net as administrator -- It's not likely to end well.

- V

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.