<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'><BR><BR>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. <BR><BR> From esri support >>>3. As we discussed, the 3rd party software maybe should read the auth_<FONT face="">srid</FONT> 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.<BR> <BR>ESRI's ID (comparable to Oracle's SRID)<BR><A href="http://arcweb.esri.com/arcwebonline/services/pcs_alpha.htm" target=_blank>http://arcweb.esri.com/arcwebonline/services/pcs_alpha.htm</A><BR>NAD_1983_StatePlane_Oklahoma_North_FIPS_3501 32124 <BR><BR> <BR> <BR>Oracle Database 10g Release 10.2.0.3.0 - Production<BR>SQL> select distinct SRID from <FONT face="">sde.spatial_references</FONT>;<BR> SRID<BR>----------<BR> 1<BR> 2<BR> 3<BR> 4<BR> 5<BR> 6<BR> 7<BR> 8<BR> 9<BR> 10<BR> 11<BR> SRID<BR>----------<BR> 12<BR> 13<BR> 14<BR> 15<BR> 16<BR> 17<BR> 18<BR> 19<BR> 20<BR> 21<BR> 22<BR> SRID<BR>----------<BR> 23<BR> 24<BR> 25<BR> 26<BR> 27<BR> 28<BR> 29<BR> 30<BR> 31<BR> 32<BR> 33<BR> SRID<BR>----------<BR> 34<BR> 35<BR> 36<BR> 37<BR> 38<BR> 39<BR> 40<BR> 41<BR> 42<BR> 43<BR> 44<BR> SRID<BR>----------<BR> 45<BR> 46<BR> 47<BR> 48<BR> 49<BR> 50<BR> 51<BR> 52<BR> 53<BR> 54<BR> 55<BR> SRID<BR>----------<BR> 56<BR> 57<BR> 58<BR> 59<BR> 60<BR> 61<BR> 62<BR> 63<BR> 64<BR> 65<BR> 66<BR> SRID<BR>----------<BR> 67<BR> 68<BR> 69<BR> 70<BR> 71<BR> 72<BR> 73<BR> 74<BR> 75<BR> 76<BR> 77<BR> SRID<BR>----------<BR> 78<BR> 79<BR> 80<BR> 81<BR> 82<BR> 83<BR> 84<BR> 85<BR> 86<BR> 87<BR> 88<BR> SRID<BR>----------<BR> 89<BR> 90<BR> 91<BR> 92<BR> 93<BR> 94<BR> 95<BR> 96<BR> 97<BR> 98<BR> 99<BR> SRID<BR>----------<BR> 100<BR> 101<BR> 102<BR> 103<BR> 104<BR> 105<BR> 106<BR> 107<BR> 108<BR> 109<BR> 110<BR> SRID<BR>----------<BR> 111<BR> 112<BR> 113<BR> 114<BR> 115<BR> 116<BR> 117<BR> 118<BR> 119<BR> 120<BR> 121<BR> SRID<BR>----------<BR> 122<BR> 123<BR> 124<BR> 125<BR> 126<BR> 127<BR> 128<BR> 129<BR> 130<BR> 131<BR> 132<BR> SRID<BR>----------<BR> 133<BR> 134<BR> 135<BR> 136<BR> 137<BR> 138<BR> 139<BR> 140<BR> 141<BR> 142<BR> 143<BR> SRID<BR>----------<BR> 144<BR> 145<BR> 146<BR> 147<BR> 148<BR> 149<BR> 150<BR> 151<BR> 152<BR> 153<BR> 154<BR> SRID<BR>----------<BR> 155<BR> 156<BR> 157<BR> 158<BR> 159<BR> 160<BR> 161<BR> 162<BR> 163<BR> 164<BR> 165<BR> SRID<BR>----------<BR> 166<BR> 167<BR> 168<BR> 169<BR> 170<BR> 171<BR> 172<BR> 173<BR> 174<BR> 175<BR> 176<BR> SRID<BR>----------<BR> 177<BR> 178<BR> 179<BR> 180<BR> 181<BR> 182<BR> 183<BR> 184<BR> 185<BR> 186<BR> 187<BR> SRID<BR>----------<BR> 188<BR> 189<BR> 190<BR> 191<BR> 192<BR> 193<BR> 194<BR> 195<BR> 196<BR> 197<BR> 198<BR> SRID<BR>----------<BR> 199<BR> 200<BR> 201<BR> 202<BR> 203<BR> 204<BR> 205<BR> 206<BR> 207<BR> 208<BR> 209<BR> SRID<BR>----------<BR> 210<BR> 211<BR> 212<BR> 213<BR> 214<BR> 215<BR> 216<BR> 217<BR> 218<BR> 219<BR> 220<BR> SRID<BR>----------<BR> 221<BR> 222<BR> 223<BR> 224<BR> 225<BR> 226<BR> 227<BR> 228<BR> 229<BR> 230<BR> 231<BR> SRID<BR>----------<BR> 232<BR> 233<BR> 234<BR> 235<BR> 236<BR> 237<BR> 238<BR> 239<BR> 240<BR> 241<BR> 242<BR> SRID<BR>----------<BR> 243<BR> 244<BR> 245<BR> 246<BR> 247<BR> 248<BR> 249<BR> 250<BR> 251<BR> 252<BR> 253<BR> SRID<BR>----------<BR> 254<BR> 255<BR> 256<BR> 257<BR> 258<BR> 259<BR> 260<BR> 261<BR> 262<BR> 263<BR> 264<BR> SRID<BR>----------<BR> 265<BR> 266<BR> 267<BR>267 rows selected.<BR>SQL> select description, auth_<FONT face="">srid</FONT>, SRTEXT from <FONT face="">sde.spatial_references</FONT> where SRID in (86, 180, 133);<BR>DESCRIPTION AUTH_<FONT face="">SRID</FONT><BR>---------------------------------------------------------------- ----------<BR>SRTEXT<BR>--------------------------------------------------------------------------------<BR> 41106<BR>PROJCS["NAD_1983_StatePlane_Oklahoma_North_FIPS_3501_Feet",GEOGCS["GCS_North_Ame<BR>rican_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.2572<BR>22101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["L<BR>ambert_Conformal_Conic"],PARAMETER["False_Easting",1968500.0],PARAMETER["False_N<BR>orthing",0.0],PARAMETER["Central_Meridian",-98.0],PARAMETER["Standard_Parallel_1<BR>",35.56666666666667],PARAMETER["Standard_Parallel_2",36.76666666666667],PARAMETE<BR>R["Latitude_Of_Origin",35.0],UNIT["Foot_US",0.3048006096012192]]<BR><BR>DESCRIPTION AUTH_<FONT face="">SRID</FONT><BR>---------------------------------------------------------------- ----------<BR>SRTEXT<BR>--------------------------------------------------------------------------------<BR>UNKNOWN<BR><BR>UNKNOWN<BR><BR>SQL><BR>
<BLOCKQUOTE>
<HR id=EC_stopSpelling>
From: orest.halustchak@autodesk.com<BR>To: fdo-users@lists.osgeo.org<BR>Date: Mon, 21 Apr 2008 14:25:41 -0700<BR>Subject: RE: [fdo-users] coordinate system bug?<BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<STYLE>
.ExternalClass .EC_shape
{;}
</STYLE>
<STYLE>
.ExternalClass p.EC_MsoNormal, .ExternalClass li.EC_MsoNormal, .ExternalClass div.EC_MsoNormal
{margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass a:link, .ExternalClass span.EC_MsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.EC_MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass p
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass span.EC_EmailStyle18
{font-family:'Calibri','sans-serif';color:#1F497D;}
.ExternalClass .EC_MsoChpDefault
{font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;}
.ExternalClass div.EC_Section1
{page:Section1;}
</STYLE>
<DIV class=EC_Section1>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Hi Brad,</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">The provider gets the coordinate system information from SDE. It doesn’t go directly against the Oracle metadata in this case and is independent of whether the server is Oracle, SQL Server, etc. It uses whatever the SDE api returns as the coord sys wkt. Map 2008 and 2009 include the ability to recognize either Oracle or ESRI variations of the wkt value, so it’s unclear why some of these cases end up not being recognized. I assumed that you verified that the sde layer definitions all use the identical coordinate system definition?</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Thanks,</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Orest.</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<DIV>
<DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=EC_MsoNormal><B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Brad Nesom<BR><B>Sent:</B> Monday, April 21, 2008 9:50 AM<BR><B>To:</B> FDO Users Mail List<BR><B>Subject:</B> [fdo-users] coordinate system bug?</SPAN></P></DIV></DIV>
<P class=EC_MsoNormal> </P>
<P class=EC_MsoNormal style="MARGIN-BOTTOM: 12pt"><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> <BR>I have been working on a problem with esri for quite some time. I have an oracle database storing my ArcSDE data as SDO geometry (supported on oracle 10g 2.3 and arcsde 9.2). I use several parameters in my keyword to load the data and only use esri to load. The significant parameters to this issue are the srid and the geometry type being 41106 and sdo_geometry respectively. After having scaling problems other problems with displaying units in arcmap for over 2 years esri finally blamed the problem on a bug in oracle (they would give me the bug number). Stating that the oracle wkt is not an international standard and thus has problems being recognised in the esri software. The wkt 41106 is exactly the same as the esri system NAD 1983 StatePlane Oklahoma North FIPS 3501 (Feet).prj with the exception of the name (Oklahoma 3501, Northern Zone (1983, US Survey feet))(which by the way is the same as the autodesk ok83-nf with no problems there). ESRI said this was the cause of the oracle bug. <BR>I know that sde is having a problem relating this wkt because if I build a feature dataset and assign the esri system to it, then load the data into that dataset (in esri products the dataset determines the coordinate system of all feature classes contained within), It assigns the wkt to the feature class until you go and reassign the esri system to the feature dataset (this is the workaround esri provided). All is well until something like a load, truncate or new feature class is added to the dataset.<BR>Now my question.<BR>In map 3d 2008 or 2009, when I get connected via FDO the list of coordinate systems is inconsistent (see attached jpg sdelistinmap.jpg). If I look at my oracle metadata all srids are assigned the 41106. Where does map pull the coordinate system information for the arcsde fdo data type? is it from the sde layer definition? <BR>Any help or understanding would be grand.<BR> <BR> <BR> <BR> <BR> <BR>select * from mdsys.cs_srs where srid = 41106<BR>/<BR>-------------------------------------------------------------------------------<BR>CS_BOUNDS(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES<BR>-------------------------------------------------------------------------------<BR>PROJCS["Oklahoma 3501, Northern Zone (1983, US Survey feet)", GEOGCS ["NAD 83 (<BR>ontinental US)", DATUM ["NAD 83 (Continental US)", SPHEROID ["GRS 80", 6378137,<BR>298.257222101]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01<BR>CS_NAME SRID<BR>-------------------------------------------------------------------- ----------<BR> AUTH_SRID<BR>----------<BR>AUTH_NAME<BR>-------------------------------------------------------------------------------<BR>WKTEXT<BR>-------------------------------------------------------------------------------<BR>CS_BOUNDS(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES<BR>-------------------------------------------------------------------------------<BR>45329251994330]], PROJECTION ["Lambert Conformal Conic"], PARAMETER ["Standard_<BR>arallel_1", 35.566667], PARAMETER ["Standard_Parallel_2", 36.766667], PARAMETER<BR>["Central_Meridian", -98.000000], PARAMETER ["Latitude_Of_Origin", 35.000000], <BR>CS_NAME SRID<BR>-------------------------------------------------------------------- ----------<BR> AUTH_SRID<BR>----------<BR>AUTH_NAME<BR>-------------------------------------------------------------------------------<BR>WKTEXT<BR>-------------------------------------------------------------------------------<BR>CS_BOUNDS(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SDO_ELEM_INFO, SDO_ORDINATES<BR>-------------------------------------------------------------------------------<BR>ARAMETER ["False_Easting", 1968500.0000], UNIT ["U.S. Foot", 0.3048006096012]<BR><BR></SPAN></P>
<DIV class=EC_MsoNormal style="TEXT-ALIGN: center" align=center><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">
<HR align=center width="100%" SIZE=2>
</SPAN></DIV>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">More immediate than e-mail? <A href="http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_instantaccess_042008" target=_blank>Get instant access with Windows Live Messenger.</A></SPAN></P></DIV></BLOCKQUOTE><br /><hr />Pack up or back up–use SkyDrive to transfer files or keep extra copies. <a href='http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_packup_042008' target='_new'>Learn how.</a></body>
</html>