<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:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (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]-->
<title>[mapguide-users] Experiences with Oracle Spatial</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EstiloCorreo18
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EstiloCorreo19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
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=ES link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Hi Everyone:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>I have successfully tried
Oracle Spatial with MGEnterprise 2007, you must realize that the only certified
combination is Oracle DB 10g R1 10.1.0.2 (I recommend 10.1.0.4 or later because
of the bugs and fixes provided by Oracle that are related with Spatial Data) and
yes there is some issues like MGE can not determine the type of geometry from
the table (Point, Polygon, Polyline) , because as you know that information is
stored into Oracle Spatial Metadata, but that’s is not mandatory as same
as the SRID (where the coordinate system is stored) , there is also some
flexible issues in the Oracle Spatial Architecture that makes difficult validating
the feature tables (in the past Adsk Map 3D generates his own metadata info
that was read by MapGuide 6.5), further information is provided by Oracle Spatial
Documentation and Courses.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>But you must know that
the only necessary things you must have to work fine with Oracle is an Oracle
DB Server 9.2.0.5 or 10.1.0.3 with the Spatial Option Enabled, and for the
computer running MGE you need an Oracle Client 10g 10.1.0.2 or later (I had got
problems with Oracle Instant Client), and the Autodesk FDO Provider for Oracle
(installed when you install MG Enterprise). <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Also you must configure
TNS Names in order to communicate MGE with the Oracle Server; further
information is provided by Oracle Documentation.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Best Regards<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div>
<p class=MsoNormal><font size=2 color=navy face=Verdana><span lang=EN-US
style='font-size:10.0pt;font-family:Verdana;color:navy'>CSE. Francisco Javier
Rojas Durán <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Verdana><span lang=EN-US
style='font-size:10.0pt;font-family:Verdana;color:navy'>IT Manager - Oracle
Specialist<br>
<i><span style='font-style:italic'>Grupo DaSoft S.A. de C.V.</span></i> </span></font><font
color=navy><span lang=EN-US style='color:navy'><o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:black'>Joel:</span></font><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>I can't get the Oracle Spatial data to appear at
all? Have you been able to get the data to appear? If so, what
coordinate system are you using? It seems I can't get any of the
Oracle stuff to work.</span></font><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>I second your experience on slowness. I takes a
very long time just to start to edit the layer. I did end up
creating a seperate MGE user for those layers I want to display in <st1:City
w:st="on"><st1:place w:st="on">Enterprise</st1:place></st1:City>. This
way it doesn't have to go through every single table in the main schema. This
seems to have helped, but I can't get the layers to appear in the map.</span></font><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:black'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:black'>Juan Butler - Senior
Programmer/Analyst<br>
GIS Applications<br>
<st1:place w:st="on"><st1:PlaceName w:st="on">Pinellas</st1:PlaceName> <st1:PlaceType
w:st="on">County</st1:PlaceType></st1:place> Information Systems<br>
jpbutler@pinellascounty.org<br>
<br>
</span></font><font size=1 color=black face=Arial><span lang=EN-US
style='font-size:7.5pt;font-family:Arial;color:black'>Please note: All mail
sent to and from Pinellas County Government is subject to the Public Records
Law of Florida.</span></font><font size=2 color=black face=Arial><span
lang=EN-US style='font-size:10.0pt;font-family:Arial;color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:black'>Another note on this is
the way <st1:place w:st="on"><st1:City w:st="on">Enterprise</st1:City></st1:place>
gets the new schema information back to you in Studio. I created a new
spatial table and it took quite sometime just to get the table to
appear. I had to go out and come back in and then create a whole new
layer from scratch. Same goes for adding new columns. I had
to totally re-create a layer just to get a new column to show up.</span></font><span
lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:black'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:black'>Juan Butler - Senior
Programmer/Analyst<br>
GIS Applications<br>
<st1:place w:st="on"><st1:PlaceName w:st="on">Pinellas</st1:PlaceName> <st1:PlaceType
w:st="on">County</st1:PlaceType></st1:place> Information Systems<br>
jpbutler@pinellascounty.org<br>
<br>
</span></font><font size=1 color=black face=Arial><span lang=EN-US
style='font-size:7.5pt;font-family:Arial;color:black'>Please note: All mail
sent to and from Pinellas County Government is subject to the Public Records
Law of Florida.</span></font><font size=2 color=black face=Arial><span
lang=EN-US style='font-size:10.0pt;font-family:Arial;color:black'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>De:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Robert Bray
[mailto:robert.bray@autodesk.com] <br>
<b><span style='font-weight:bold'>Enviado el:</span></b> Viernes, 04 de Agosto
de 2006 12:04 a.m.<br>
<b><span style='font-weight:bold'>Para:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Asunto:</span></b> RE: [mapguide-users]
Experiences with Oracle Spatial</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Wow, I never expected to
be providing commercial product support on an open source user forum </span></font><font
size=2 color=navy face=Wingdings><span lang=EN-US style='font-size:10.0pt;
font-family:Wingdings;color:navy'>J</span></font><font size=2 color=navy
face=Arial><span lang=EN-US style='font-size:10.0pt;font-family:Arial;
color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Out of curiosity what
version of the Oracle Database Server are you running? Rest assured we are very
aware of the performance issues with Oracle data sources and are aggressively
working on them. These other issues mentioned here however we have not seen in
house so I would like to try and get to the bottom of them as well.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Thanks,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'>Bob<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
Butler, Juan P [mailto:jpbutler@co.pinellas.fl.us] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, August 03, 2006
4:39 PM<br>
<b><span style='font-weight:bold'>To:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users]
Experiences with Oracle Spatial</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<div id=idOWAReplyText48943>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:black'>Another observation of
Oracle Spatial data....</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>Have you noticed the symbolization on Oracle Spatial
data? It shows a point, line, and polygon. I'm assuming it's
because <st1:place w:st="on"><st1:City w:st="on">Enterprise</st1:City></st1:place>
can't determine the feature type? Not sure why it can't since it is
contained in the geometry of the feature. Even Mapguide 6.x was
able to figure this out. </span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial'>Or maybe I'm doing something wrong, because I can't
even get <st1:place w:st="on"><st1:City w:st="on">Enterprise</st1:City></st1:place>
to display any of my Oracle Spatial data.</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
</div>
<div id=idSignature43514>
<div>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:black'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=black face=Arial><span lang=EN-US
style='font-size:10.0pt;font-family:Arial;color:black'>Juan Butler - Senior
Programmer/Analyst<br>
GIS Applications<br>
<st1:place w:st="on"><st1:PlaceName w:st="on">Pinellas</st1:PlaceName> <st1:PlaceType
w:st="on">County</st1:PlaceType></st1:place> Information Systems<br>
jpbutler@pinellascounty.org<br>
<br>
</span></font><font size=1 color=black face=Arial><span lang=EN-US
style='font-size:7.5pt;font-family:Arial;color:black'>Please note: All mail
sent to and from Pinellas County Government is subject to the Public Records
Law of Florida.</span></font><font size=2 color=black face=Arial><span
lang=EN-US style='font-size:10.0pt;font-family:Arial;color:black'><o:p></o:p></span></font></p>
</div>
</div>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
lang=EN-US style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
Joel Carranza [mailto:jec@gatekeeper.com]<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thu 8/3/2006 4:50 PM<br>
<b><span style='font-weight:bold'>To:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> [mapguide-users]
Experiences with Oracle Spatial</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-US
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p style='margin-bottom:12.0pt'><font size=2 face="Times New Roman"><span
lang=EN-US style='font-size:10.0pt'>Can anyone provide some feedback to me on
their experiences with the Oracle<br>
Spatial FDO from the <st1:place w:st="on"><st1:City w:st="on">Enterprise</st1:City></st1:place>
edition? Has anyone gotten it to work in a<br>
satisfactory manner? Are you seeing stability/performance issues? What is<br>
your setup?<br>
<br>
Our experiences aren't great. Some of our data displays but is quite
slow.<br>
Creating a layer from an Oracle Spatial source is extremely slow (over a<br>
minute just to start editing). I suspect this is related to the reading of<br>
the schema metadata, but I don't really know.<br>
<br>
You can see my original (as yet unanswered) post here regarding one of my<br>
specific problems here:<br>
<a href="http://discussion.autodesk.com/thread.jspa?threadID=486000">http://discussion.autodesk.com/thread.jspa?threadID=486000</a><br>
<br>
Even a simple yes or no would be helpful at this point.<br>
<br>
Thanks,<br>
<br>
Joel Carranza<br>
Gatekeeper Systems<br>
--<br>
View this message in context: <a
href="http://www.nabble.com/Experiences-with-Oracle-Spatial-tf2047988.html#a5640473">http://www.nabble.com/Experiences-with-Oracle-Spatial-tf2047988.html#a5640473</a><br>
Sent from the OSGeo MapGuide forum at Nabble.com.<br>
<br>
<br>
---------------------------------------------------------------------<br>
To unsubscribe, e-mail: users-unsubscribe@mapguide.osgeo.org<br>
For additional commands, e-mail: users-help@mapguide.osgeo.org</span></font><span
lang=EN-US><o:p></o:p></span></p>
</div>
</div>
</body>
</html>