Select to view content in your preferred language

SRID / AUTH SRID?

3198
1
06-17-2013 05:58 PM
runegullstrom
Emerging Contributor
Hi,

I'm confused about which one to use, SRID or the AUTH_SRID. I want to create a feature class using a srid from another existing feature class. We use ST_GEOMETRY, so my assumption is to use the SRIDS in the ST_SPATIAL_REFERENCES table. I can also see that the existing feature class has this SRID in the ALL_ST_GEOMETRY_COLUMNS_V view. When I try to use it with "sdelayer -o add" I get the message.

Error: Spatial reference entry does not exist (-255).
Error: Error in getting spatial reference info object

I do a describe long on the feature class I try to copy the SRID from and see:
SRID .................: 10
Auth SRID.............: 33

Ok, fine, I'll use 10 instead and the layer is successfully created.
Then I'll query the layer with sde.st_intersects using SRID 10 at which point I get the message:
Parameter ST_SRID 10 does not exist in ST_SPATIAL_REFERENCES table.

Yes I know that, but I wasn't able to create it with 33. So what is it, SRID or AUTH_SRID?

regards,

Rune

Windows Server 2008, Oracle11g, SDE10 (no sp)
0 Kudos
1 Reply
VinceAngelo
Esri Esteemed Contributor
It's both, as you've explained.  One is for sdelayer execution, the other is for SQL.
They are not interchangable.

- V
0 Kudos