0

This question already has an answer here:

What query should I use to check the SRID of the features in a feature class? The storage type of the feature class in st_geometry?

I tried the following query but no luck :

select top 1 [geomColumnName].STSrid from [schema].[feature class];

marked as duplicate by whyzar, aldo_tapia, Fezter Apr 17 '18 at 22:44

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • It's not obvious, but this is an Oracle question, while the "duplicate" is SQL Server. This is not a duplicate. – Vince Apr 17 '18 at 21:59
0

Just after posting this question I did some more research and testing. I found the query:

SELECT sde.st_srid (SHAPE) sridcol FROM schema.featureclassname;

I referred to the following link:

http://desktop.arcgis.com/en/arcmap/10.3/manage-data/using-sql-with-gdbs/st-srid.htm

  • Please edit your question to specify the Oracle version and geometry storage since SDO_GEOMETRY would be a very different query. Esri doesn't permit more than one SRID per geometry column, so you can LIMIT 1. – Vince Apr 17 '18 at 20:46
0

have you tried the following syntax

SELECT [geomColumnName].STSrid as srid, * FROM [schema].[tableName]

I got this from the following question

personally I would just use the following since the srid will be the same for all features in a feature class:

SELECT distinct [geomColumnName].STSrid as srid FROM [schema].[tableName]

Not the answer you're looking for? Browse other questions tagged or ask your own question.