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)