<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt"><div><span><font class="Apple-style-span" size="2">Thanks for the info.. I've created a new view in Oracle, I've added the entry in user_sdo_geom_metadata (using the fdo2fdo tool) and everything works fine.</font></span></div><div><span><font class="Apple-style-span" size="2">I would like to add this entry manually (not using the tool) but the problem is that I don't know how the </font></span><font class="Apple-style-span" size="2">values in the DIMINFO column of the </font><span class="Apple-style-span" style="font-size: 13px; ">user_sdo_geom_metadata table are calculated...</span></div><div><span class="Apple-style-span" style="font-size: 13px; ">For ex. : MDSYS.SDO_DIM_ELEMENT(MDSYS.SDO_DIM_ELEMENT(X,-25.2145,73.0093,0.05),MDSYS.SDO_DIM_ELEMENT(Y,-21.2004,74.7297,0.05))</span></div><div><span
class="Apple-style-span" style="font-size: 13px; ">And also if the SRID 8307 is the corresponding value of the LL84 (WGS84) Coordinate System, which is the correpsonding SRID value for the XY-M (Arbitrary X-Y Coordinates (Meters)) </span><span class="Apple-style-span" style="font-size: 13px; ">Coordinate System?</span></div><div><span class="Apple-style-span" style="font-size: 13px; "><br></span></div><div><font class="Apple-style-span" size="2">Thank You,</font></div><div><font class="Apple-style-span" size="2">Iulia</font></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 10pt; "> </div> <div style="font-size: 10pt; font-family: 'times new roman', 'new york', times, serif; "> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> "Jonio, Dennis (Aviation)"
<DJonio@miami-airport.com><br> <b><span style="font-weight: bold;">To:</span></b> Iulia Tamas <iulia_tamas30@yahoo.com>; MapGuide Users Mail List <mapguide-users@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, November 23, 2011 4:00 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> RE: [mapguide-users] Join between an Oracle spatial table and a view <br> </font> <br>
<meta http-equiv="x-dns-prefetch-control" content="off"><div id="yiv107856576"><style><!--
#yiv107856576
_filtered #yiv107856576 {font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered #yiv107856576 {font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
#yiv107856576
#yiv107856576 p.yiv107856576MsoNormal, #yiv107856576 li.yiv107856576MsoNormal, #yiv107856576 div.yiv107856576MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"serif";}
#yiv107856576 a:link, #yiv107856576 span.yiv107856576MsoHyperlink
{
color:blue;
text-decoration:underline;}
#yiv107856576 a:visited, #yiv107856576 span.yiv107856576MsoHyperlinkFollowed
{
color:purple;
text-decoration:underline;}
#yiv107856576 p
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"serif";}
#yiv107856576 p.yiv107856576MsoListParagraph, #yiv107856576 li.yiv107856576MsoListParagraph, #yiv107856576 div.yiv107856576MsoListParagraph
{
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"serif";}
#yiv107856576 span.yiv107856576tab
{}
#yiv107856576 span.yiv107856576EmailStyle19
{
font-family:"sans-serif";
color:#1F497D;}
#yiv107856576 .yiv107856576MsoChpDefault
{
font-size:10.0pt;}
_filtered #yiv107856576 {
margin:1.0in 1.0in 1.0in 1.0in;}
#yiv107856576 div.yiv107856576WordSection1
{}
#yiv107856576
_filtered #yiv107856576 {
}
_filtered #yiv107856576 {
}
#yiv107856576 ol
{margin-bottom:0in;}
#yiv107856576 ul
{margin-bottom:0in;}
--></style><div><div class="yiv107856576WordSection1"><div class="yiv107856576MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: sans-serif; ">Iulia,</span></div><div class="yiv107856576MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: sans-serif; ">I would recommend:</span></div><div class="yiv107856576MsoListParagraph" style=""><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: sans-serif; "><span style="">1)<span style="font:7.0pt "Times New Roman";"> </span></span></span><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: sans-serif; ">Create a “normal” Oracle view w/your join</span></div><div class="yiv107856576MsoListParagraph" style=""><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: sans-serif; "><span style="">2)<span style="font:7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: sans-serif; ">Add the entry for it in user_sdo_geom_metadata. (No need for an index.)</span></div><div class="yiv107856576MsoListParagraph" style=""><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: sans-serif; "><span style="">3)<span style="font:7.0pt "Times New Roman";"> </span></span></span><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: sans-serif; ">Create a layer for the view … </span></div><div class="yiv107856576MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: sans-serif; ">Does all appear normal and as expected? </span></div><div class="yiv107856576MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: sans-serif; ">All that I am suggesting here is to gradually add complexity. No need to boil the ocean from the get-go. You
can delete/remove this stuff later. But maybe you have already done these things.. in which case I am no help.</span></div><div class="yiv107856576MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: sans-serif; ">r,</span></div><div class="yiv107856576MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125); font-family: sans-serif; ">dennis</span></div></div></div></div><meta http-equiv="x-dns-prefetch-control" content="on"><br><br> </div> </div> </div></body></html>