[fdo-users] coordinate system bug?

[Brad Nesom]

I think with help I have discovered that the descrepincies in my sde.spatial_references table are due to problems while loading the data and getting it registered correctly with sde. I have clipped previous data and added a short piece of output showing the auth_name.
Brad
SQL> select auth_name, auth_SRID, srid from sde.spatial_references;AUTH_NAME       AUTH_SRID  SRID--------------- --------- -----                        0     1                              2                        0     3                              4                              5ORACLE000           41106    14ORACLE000           41106    15ORACLE000           41106    17ORACLE000           41106    18ORACLE000           41106    19ORACLE000           41106    20AUTH_NAME       AUTH_SRID  SRID--------------- --------- -----ORACLE000           41106    21ORACLE000           41106    25                              6ORACLE000           41106     7ORACLE000           41106     8                        0     9                             44                             45                             46                             47                             48AUTH_NAME       AUTH_SRID  SRID--------------- --------- -----                             49                             50                             61ORACLE000           41106    10ORACLE000           41106    11ORACLE000           41106    22ORACLE000           41106    23                        0    24



From: kidsmake6 at msn.comTo: fdo-users at lists.osgeo.orgSubject: RE: [fdo-users] coordinate system bug?Date: Mon, 21 Apr 2008 16:43:25 -0500


Yes I have verified that the sdelayers have the correct coordinate definition. However it was just explained to me by esri that the srid in sde is a moving target. each time sde finds any variation (not sure why it htinks there is any variation) it creates a new srid value (random) and assigns the description see below.  From esri support >>>3. As we discussed, the 3rd party software maybe should read the auth_srid to get the Oracle spatial coordinate system definition. But in general cases, if a layer is not from Oracle spatial, there may not be the auth_id value.ESRI's ID (comparable to Oracle's SRID)http://arcweb.esri.com/arcwebonline/services/pcs_alpha.htmNAD_1983_StatePlane_Oklahoma_North_FIPS_3501  32124    Oracle Database 10g Release 10.2.0.3.0 - ProductionSQL> select distinct SRID from sde.spatial_references;      SRID----------         1         2         3         4         5         6         7         8         9        10        11      SRID----------        12        13        14        15        16        17        18        19        20        21        22      
_________________________________________________________________
In a rush? Get real-time answers with Windows Live Messenger.
http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_realtime_042008
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20080423/e1cfd4e7/attachment.html