topic Re: XY coordinates using SQL command in Data Management Questions

XY coordinates using SQL command

User35489 — Tue, 20 May 2014 09:54:59 GMT

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

Re: XY coordinates using SQL command

VinceAngelo — Tue, 20 May 2014 12:02:18 GMT

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

Re: XY coordinates using SQL command

User35489 — Tue, 20 May 2014 12:04:44 GMT

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

Re: XY coordinates using SQL command

VinceAngelo — Tue, 20 May 2014 12:23:33 GMT

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

Re: XY coordinates using SQL command

User35489 — Wed, 21 May 2014 03:26:48 GMT

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

Re: XY coordinates using SQL command

AsrujitSengupta — Wed, 21 May 2014 11:43:08 GMT

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.

Re: XY coordinates using SQL command

VinceAngelo — Thu, 22 May 2014 12:30:54 GMT

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

Re: XY coordinates using SQL command

User35489 — Mon, 26 May 2014 04:04:08 GMT

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