AnsweredAssumed Answered

Different SRID's

Question asked by nbesli on Mar 25, 2015
Latest reply on Mar 30, 2015 by vangelo-esristaff

Hi,

Here is my case. I had 2 geodatabases. Second one is created later. And i import all tables in geodatabase-1 to geodatabase-2 by using ArcCatolog. I use srid 6 for my geodatabase 1 and its kind of a standart.  But in geodatabase 2 the tables and indexes are imported with an different srid. I have to change srid of all geometry collumns and spatial indexes to 6.

 

First i checked ST_spatial_references table for srid 6 and couldnt find it. There is srid 30002 with same content with srid 6 in geodatabase 1.

Then i create an entry in ST_Spatial_references table manually for srid 6. After that I tried to create a spatial index with following query.

 

     CREATE INDEX SDE.INDEX_NAME ON SDE.TABLE_NAME (SHAPE)

     INDEXTYPE IS SDE.ST_SPATIAL_INDEX

     PARAMETERS('st_grids=1:0:0 st_srid=6')

     NOPARALLEL;

 

and get this error. ORA-20085: Different SRID '6' do not match.

 

I need to create and srid entry with id 6 properly. And change all the tables and spatial indexes set to srid 6. Can anyone help me?

 

Note: srid 30002 and 6 has exactly same content in ST_SPATIAL_REFERENCES table except the id collumn.

 

Thank You.

Outcomes