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

Find more posts tagged with

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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