Select to view content in your preferred language

How can I find the SRID value of a feature Dataset in ArcGIS10?

2909
1
05-16-2011 05:29 AM
NiallCarter
Occasional Contributor
Hi all

In previous version of ArcSDE I was able to see the SRID value of my feature dataset (stored in Oracle Spatial). I found this by querying the GDB_FEATUREDATASET system table (select name,srid from GDB_FEATUREDATASET).

Now that the system tables have been reworked and condensed how do I find the SRID value for my feature dataset?

You may all be wondering why I would like to do this? Well...
I have set the SDO_SRID value in my DBTUNE file to be 81989 and so would expect this to be used for my SRID in all created feature datasets and feature classes. The trouble is that when I copy data to my new feature dataset and then try to create a topology (or g.network) from that data I receive a lot of 'Spatial References do not match' errors. This has previously been solved by ensuring that the SRID value of the FDS and the FC are the same. The trouble is that I can no longer see if this is the case as I can't query the SRID of the FDS!

I have tried setting the SRID value in my Network and Topologies keyword but to no luck.

Any help would be much appreciated.

Regards,

Niall Carter
0 Kudos
1 Reply
VinceAngelo
Esri Esteemed Contributor
I'm not sure how you got that to work before, since the "SRID" of SDO_GEOMETRY and
"SRID" associated with ArcSDE layers refer to completely different things -- Esri SRIDs
have always been sequence-based, while Oracle SRIDs have always been lookup-table
based (Oracle's SRID is a lot closer to Esri's projection engine EPSG coordinate system
factory code, while an Esri SRID refers to the entire coordinate reference, including
coordinate system, precision, and X/Y, Z, and M false origins and offsets).

The Esri SRID associated with a feature dataset can always be determined through looking
at the SRID value in the LAYERS or GEOMETRY_COLUMNS table for the layers in that dataset.

- V
0 Kudos