[fdo-users] coordinate system bug?

Brad Nesom kidsmake6 at msn.com
Wed Apr 23 16:26:54 EDT 2008


Another note Even after populating the correct auth_name and auth_srid values in this table map still does notreturn the corrected values.
Is the a cache that holds these value?
 
 
 

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. 
_________________________________________________________________
Spell a grand slam in this game where word skill meets World Series. Get in the game.
http://club.live.com/word_slugger.aspx?icid=word_slugger_wlhm_admod_april08
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20080423/44ea4a63/attachment.html


More information about the fdo-users mailing list