<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:Z="urn:schemas-microsoft-com:" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Brad,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>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?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Thanks,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Orest.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;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?<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt;
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>
<o:p></o:p></span></p>
<div class=MsoNormal align=center style='text-align:center'><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal><span style='font-size:10.0pt;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="_new">Get instant access with Windows Live Messenger.</a><o:p></o:p></span></p>
</div>
</body>
</html>