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; } } }

XY coordinates using SQL command

User35489

Hello There,

Please let me know how to extract the X and Y coordinates from a Feature. Although, we can get it using ArcMAP, but i need it using SQL.

Thanks
-AS

Finde mehr Beiträge mit dem Tag

Accepted answers

AsrujitSengupta

I think this should get you the desired X and Y coordinates of the vertices of a feature:

ST_AsText
http://resources.arcgis.com/en/help/main/10.2/index.html#/ST_AsText/006z0000003v000000/

Example:
-----------
SELECT OBJECTID, sde.st_astext (SHAPE) SHAPE FROM featureclass_name;
----------

You need to have ST-geometry configured for that Oracle database to use the above query.

All comments

User35489

Thanks for your input Vince.
I will try ST_Point also to see the result.

-AS

It might be easier to use ST_PointN to fetch individual points inside PL/SQL
(instead of text processing on a CLOB), which is why I asked what you were
planning to do with them.

- V

VinceAngelo

It might be easier to use ST_PointN to fetch individual points inside PL/SQL
(instead of text processing on a CLOB), which is why I asked what you were
planning to do with them.

- V

AsrujitSengupta

User35489

Vince,
We are looking for all.

Thanks
-AS

Polygons have at least 3 unique vertices and a centroid -- Which X,Y value are you
trying to extract? Or do you want them all? And what are you planning to do with
it/them once you have it/them?

- V

VinceAngelo

Polygons have at least 3 unique vertices and a centroid -- Which X,Y value are you
trying to extract? Or do you want them all? And what are you planning to do with
it/them once you have it/them?

- V

User35489

Thanks Vince for correction,

ORACLE 11g R2, ST_Geometry and Polygon feature class.

Best Regards
-AS

You'll need to provide more information, including:
The RDBMS you are using
The geometry storage format
The topology class of the features (point/line/polygon)

Note that not everyone on this forum self-identifies as a "geek", so your
greeting might be considered offensive to some. I suggest you stick to
less charged terms when requesting help from folks.

- V

VinceAngelo

You'll need to provide more information, including:

The RDBMS you are using
The geometry storage format
The topology class of the features (point/line/polygon)

Note that not everyone on this forum self-identifies as a "geek", so your
greeting might be considered offensive to some. I suggest you stick to
less charged terms when requesting help from folks.

- V

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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