<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=218073410-15112006><FONT face=Arial
color=#0000ff size=2>Hi Max,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=218073410-15112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=218073410-15112006><FONT face=Arial
color=#0000ff size=2>I think data is displayed but you need to zoom into
area of interest.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=218073410-15112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=218073410-15112006><FONT face=Arial
color=#0000ff size=2>King.Oracle provider reads extent of data from spatial
index for non-geodetic SRID. In case of geodetic coordinate system (as in your
case) it will read from SDO_GEOM_METDATA.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=218073410-15112006><FONT face=Arial
color=#0000ff size=2>I suppose you have -180 180 -90 90 for extents. You can
check that using Fdo2Fdo tool "Oracle Toolbox - SDO
Metadata".</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=218073410-15112006><FONT face=Arial
color=#0000ff size=2>You can than use Fdo2Fdo to recalculate extent "Recalculate
Extent" button and write it into SDO_GEOM_METADATA. Then when provider reads
again that schema (you need to restart studio) it will use correct extent and in
preview it will be automatically zoomed in that area.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=218073410-15112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=218073410-15112006><FONT face=Arial
color=#0000ff size=2>Also y</FONT></SPAN><SPAN class=218073410-15112006><FONT
face=Arial color=#0000ff size=2>ou can create a Map in Studio and manually set
extents for that Map.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=218073410-15112006></SPAN><SPAN
class=218073410-15112006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=218073410-15112006><FONT face=Arial
color=#0000ff size=2>Haris</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Rahul [mailto:unicorn_admirer@yahoo.com]
<BR><B>Sent:</B> Wednesday, November 15, 2006 8:27 AM<BR><B>To:</B>
users@mapguide.osgeo.org<BR><B>Subject:</B> [mapguide-users] King.Oracle
0.4.4<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hi,</DIV>
<DIV> I tried to load the shapefile
into the oracle 10gR2 using the<STRONG> fdo2fdo</STRONG> tool and after
sucessfully loading the shapfile ,i tried to connect the Spatial Table with the
Autodesk MapStudio 2007 using the the <STRONG>King.Oracle 0.4.4.0</STRONG>
provider ,i sucessfully able to connect to the oracle database and able to get
related attributes in the Layer Editior but unable to view the Layer in the
layer preview window,.</DIV>
<DIV> </DIV>
<DIV>Please refer to the attached pdf file for the details and any kind of help
will be highly appreciated.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Max</DIV>
<DIV> </DIV>
<DIV><BR><B><I>Haris Kurtagic <haris@sl-king.com></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"></o:SmartTagType><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"></o:SmartTagType><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"></o:SmartTagType><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"></o:SmartTagType><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"></o:SmartTagType>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<STYLE>@font-face {
font-family: Verdana;
}
@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in
1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
OL {
MARGIN-BOTTOM: 0in
}
UL {
MARGIN-BOTTOM: 0in
}
</STYLE>
<DIV dir=ltr align=left><SPAN class=015393508-14112006><FONT face=Arial
color=#0000ff size=2>Hi Juan,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015393508-14112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015393508-14112006><FONT face=Arial
color=#0000ff size=2>Great, I would like to see the sites you
created.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=015393508-14112006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=015393508-14112006><FONT face=Arial
color=#0000ff size=2>Haris</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Butler, Juan P
[mailto:jpbutler@co.pinellas.fl.us] <BR><B>Sent:</B> Monday, November 13, 2006
5:56 PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] King.Oracle 0.3.3<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Great…I will get this
loaded and tested.<o:p></o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">It’s be going really
well lately (in terms of performance) and I’m about ready to release some
sites to the Public. The anti-Microsoft crowd should be pleased with the
<st1:City w:st="on"><st1:place w:st="on">AJAX</st1:place></st1:City>
viewer.<o:p></o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Verdana size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">Juan Butler - Senior
Programmer/Analyst<BR><st1:PersonName w:st="on">GIS</st1:PersonName>
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><A
href="mailto:jpbutler@pinellascounty.org">jpbutler@pinellascounty.org</A><FONT
color=navy><SPAN
style="COLOR: navy"><o:p></o:p></SPAN></FONT></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Verdana color=#333333 size=1><SPAN
style="FONT-SIZE: 8pt; COLOR: #333333; FONT-FAMILY: Verdana">Please note: All
mail sent to and from Pinellas County Government is subject to the Public
Records Law of Florida.</SPAN></FONT><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<DIV class=MsoNormal><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> Haris
Kurtagic [mailto:haris@sl-king.com] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Friday, November 10, 2006 9:23
AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> <st1:PersonName
w:st="on">users@mapguide.osgeo.org</st1:PersonName><BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [mapguide-users] King.Oracle
0.3.3</SPAN></FONT><o:p></o:p></DIV></DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">I have found a issue
with provider not closing all statements (started in version 0.3.2) , so
this could lead to increase of memory usage.</SPAN></FONT><o:p></o:p></DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">I fix it in
0.4.4 version of provider.</SPAN></FONT><o:p></o:p></DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">It would be great if
you can try that and tell me if it is working for you
now.</SPAN></FONT><o:p></o:p></DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Haris</SPAN></FONT><o:p></o:p></DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<DIV class=MsoNormal style="MARGIN-BOTTOM: 12pt"><B><FONT face=Tahoma
size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> Butler,
Juan P [mailto:jpbutler@co.pinellas.fl.us] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, October 24, 2006 7:52
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> <st1:PersonName
w:st="on">users@mapguide.osgeo.org</st1:PersonName><BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [mapguide-users] King.Oracle
0.3.3</SPAN></FONT><o:p></o:p></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Haris:<o:p></o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">I’m testing this now
and it seems that your provider is pulling up the spatial data much
faster. The only problem that I’m running into is the server process is
eating up memory at a large clip when adding more layers from Oracle.
It’s gotten up to over a GIG. I’ve had to shutdown Mapguide server
completely and then restart it. The memory usage will go back up as I
interact with more Oracle spatial layers. Not sure if it’s more on the
Mapguide server side or the provider.<o:p></o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">I just wish I could
use this for non Oracle Spatial tables with coordinate fields. The ODBC
provider will not show tables for me.<o:p></o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Verdana size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">Juan Butler - Senior
Programmer/Analyst<BR><st1:PersonName w:st="on">GIS</st1:PersonName>
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><A
href="mailto:jpbutler@pinellascounty.org">jpbutler@pinellascounty.org</A><FONT
color=navy><SPAN
style="COLOR: navy"><o:p></o:p></SPAN></FONT></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Verdana color=#333333 size=1><SPAN
style="FONT-SIZE: 8pt; COLOR: #333333; FONT-FAMILY: Verdana">Please note: All
mail sent to and from Pinellas County Government is subject to the Public
Records Law of Florida.</SPAN></FONT><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<DIV class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></DIV>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<DIV class=MsoNormal><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> Haris
Kurtagic [mailto:haris@sl-king.com] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, October 24, 2006 7:17
AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> <st1:PersonName
w:st="on">users@mapguide.osgeo.org</st1:PersonName><BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> [mapguide-users] King.Oracle
0.3.3</SPAN></FONT><o:p></o:p></DIV></DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></DIV>
<DIV>
<DIV class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi,</SPAN></FONT><o:p></o:p></DIV></DIV>
<DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV></DIV>
<DIV>
<DIV class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">newer version of King.Oracle 0.3.3
provider:</SPAN></FONT><o:p></o:p></DIV></DIV>
<UL type=disc>
<LI class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1"><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Support for
Spatial Views<BR>It will display views based on spatial tables. Views needs
to be added into sdo_geom_metadata for provider to find them.
<o:p></o:p></SPAN></FONT></LI></UL>
<DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Get it here: <A
href="http://www.sl-king.com/fdooracle">www.sl-king.com/fdooracle</A><o:p></o:p></SPAN></FONT></DIV></DIV>
<DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV></DIV>
<DIV>
<DIV class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Haris</SPAN></FONT><o:p></o:p></DIV></DIV>
<DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV></DIV>
<DIV>
<DIV class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></DIV></DIV></DIV></BLOCKQUOTE><BR>
<P><FONT color=#666666><FONT size=2>
<HR SIZE=1>
Sponsored Link</FONT></FONT><BR><BR><A
href="http://www.classesusa.com/clickcount.cfm?id=607556&goto=http%3A%2F%2Fwww.classesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplovr%3D607555">Don't
quit your job</A> - take classes online and <A
href="http://www.classesusa.com/clickcount.cfm?id=607556&goto=http%3A%2F%2Fwww.classesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplovr%3D607555">earn
your degree in 1 year. Start Today</A></BODY></HTML>