SRID / AUTH SRID?

runegullstrom — Tue, 18 Jun 2013 00:58:14 GMT

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)

Re: SRID / AUTH SRID?

VinceAngelo — Tue, 18 Jun 2013 10:16:57 GMT

It's both, as you've explained. One is for sdelayer execution, the other is for SQL.
They are not interchangable.

- V

topic SRID / AUTH SRID? in Data Management Questions

SRID / AUTH SRID?

Re: SRID / AUTH SRID?