<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Haris,<br>
<br>
One of the problems we still face with the described setup is that,
when using views, we don't really have the options of declaring spatial
indexes to define the geometry type of the layer. I don't know if you
can even create a spatial index on a view, but even if you could, we
might have a large number of views based on the same underlying table.
We don't really want to create a spatial index for each additional view.<br>
<br>
Have you given any thought to previous discussions we about a
"back-door" configuration option, which allows us to specify overrides
for primary key and geometry type for the tables in a schema?<br>
<br>
BTW, the provider is running great on our dataset. Thanks for the hard
work! <br>
<br>
Joel<br>
<br>
Haris Kurtagic wrote:
<blockquote
cite="mid689794E3063F0544ABB40771AF8BA2290A19C1@exchange2.sl-king.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.2900.2963" name="GENERATOR">
<div dir="ltr" align="left"><span class="859422413-15112006"><font
color="#0000ff" face="Arial" size="2">Hi,</font></span></div>
<div dir="ltr" align="left"><span class="859422413-15112006"></span> </div>
<div dir="ltr" align="left"><span class="859422413-15112006"><font
color="#0000ff" face="Arial" size="2">Here is document which describes
how King.Oracle provider uses Oracle Spatial.</font></span></div>
<div dir="ltr" align="left"><span class="859422413-15112006"><font
color="#0000ff" face="Arial" size="2">It is about configuring Oracle
metadata, Oracle views, spatial indexes, primary keys and sequences for
use with King.Oracle provider.</font></span></div>
<div dir="ltr" align="left"><span class="859422413-15112006"></span> </div>
<div dir="ltr" align="left"><span class="859422413-15112006"><font
color="#0000ff" face="Arial" size="2"><a
href="http://www.sl-king.com/fdooracle/KingOracleSetup.html">http://www.sl-king.com/fdooracle/KingOracleSetup.html</a></font></span></div>
<div dir="ltr" align="left"><span class="859422413-15112006"></span> </div>
<div dir="ltr" align="left"><span class="859422413-15112006"></span> </div>
<div dir="ltr" align="left"><span class="859422413-15112006"><font
color="#0000ff" face="Arial" size="2">I hope this is readable and
understandable document and sorry for probable mistakes in English, any
suggestions and corrections are welcome.</font></span></div>
<div dir="ltr" align="left"><span class="859422413-15112006"></span> </div>
<div dir="ltr" align="left"><span class="859422413-15112006"><font
color="#0000ff" face="Arial" size="2">Haris</font></span></div>
<br>
<div class="OutlookMessageHeader" dir="ltr" align="left" lang="en-us">
<hr tabindex="-1"><font face="Tahoma" size="2"><b>From:</b> Rahul
[<a class="moz-txt-link-freetext" href="mailto:unicorn_admirer@yahoo.com">mailto:unicorn_admirer@yahoo.com</a>] <br>
<b>Sent:</b> Wednesday, November 15, 2006 8:27 AM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:users@mapguide.osgeo.org">users@mapguide.osgeo.org</a><br>
<b>Subject:</b> [mapguide-users] King.Oracle 0.4.4<br>
</font><br>
</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 <a class="moz-txt-link-rfc2396E" href="mailto:haris@sl-king.com"><haris@sl-king.com></a></i></b> wrote:</div>
<blockquote class="replbq"
style="border-left: 2px solid rgb(16, 16, 255); padding-left: 5px; margin-left: 5px;">
<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
color="#0000ff" face="Arial" size="2">Hi Juan,</font></span></div>
<div dir="ltr" align="left"><span class="015393508-14112006"></span> </div>
<div dir="ltr" align="left"><span class="015393508-14112006"><font
color="#0000ff" face="Arial" size="2">Great, I would like to see the
sites you created.</font></span></div>
<div dir="ltr" align="left"><span class="015393508-14112006"></span> </div>
<div dir="ltr" align="left"><span class="015393508-14112006"><font
color="#0000ff" face="Arial" size="2">Haris</font></span></div>
<br>
<div class="OutlookMessageHeader" dir="ltr" align="left"
lang="en-us">
<hr tabindex="-1"> <font face="Tahoma" size="2"><b>From:</b>
Butler, Juan P [<a class="moz-txt-link-freetext" href="mailto:jpbutler@co.pinellas.fl.us">mailto:jpbutler@co.pinellas.fl.us</a>] <br>
<b>Sent:</b> Monday, November 13, 2006 5:56 PM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:users@mapguide.osgeo.org">users@mapguide.osgeo.org</a><br>
<b>Subject:</b> RE: [mapguide-users] King.Oracle 0.3.3<br>
</font><br>
</div>
<div class="Section1">
<div class="MsoNormal"><font color="navy" face="Arial" 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 color="navy" face="Arial" size="2"><span
style="font-size: 10pt; color: navy; font-family: Arial;"><o:p> </o:p></span></font></div>
<div class="MsoNormal"><font color="navy" face="Arial" 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 color="navy" face="Arial" 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 color="#333333" face="Verdana" size="1"><span
style="font-size: 8pt; color: rgb(51, 51, 51); 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 color="navy" face="Arial" size="2"><span
style="font-size: 10pt; color: navy; font-family: Arial;"><o:p> </o:p></span></font></div>
<div class="MsoNormal"><font color="navy" face="Arial" 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" size="2" width="100%"> </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
[<a class="moz-txt-link-freetext" href="mailto:haris@sl-king.com">mailto:haris@sl-king.com</a>] <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"><a class="moz-txt-link-abbreviated" href="mailto:users@mapguide.osgeo.org">users@mapguide.osgeo.org</a></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 color="blue" face="Arial" 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 color="blue" face="Arial" 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 color="blue" face="Arial" 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 color="blue" face="Arial" 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" size="2" width="100%"> </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
[<a class="moz-txt-link-freetext" href="mailto:jpbutler@co.pinellas.fl.us">mailto:jpbutler@co.pinellas.fl.us</a>] <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"><a class="moz-txt-link-abbreviated" href="mailto:users@mapguide.osgeo.org">users@mapguide.osgeo.org</a></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 color="navy" face="Arial" size="2"><span
style="font-size: 10pt; color: navy; font-family: Arial;">Haris:<o:p></o:p></span></font></div>
<div class="MsoNormal"><font color="navy" face="Arial" size="2"><span
style="font-size: 10pt; color: navy; font-family: Arial;"><o:p> </o:p></span></font></div>
<div class="MsoNormal"><font color="navy" face="Arial" 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 color="navy" face="Arial" size="2"><span
style="font-size: 10pt; color: navy; font-family: Arial;"><o:p> </o:p></span></font></div>
<div class="MsoNormal"><font color="navy" face="Arial" 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 color="navy" face="Arial" 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 color="#333333" face="Verdana" size="1"><span
style="font-size: 8pt; color: rgb(51, 51, 51); 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 color="navy" face="Arial" size="2"><span
style="font-size: 10pt; color: navy; font-family: Arial;"><o:p> </o:p></span></font></div>
<div class="MsoNormal"><font color="navy" face="Arial" 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" size="2" width="100%"> </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
[<a class="moz-txt-link-freetext" href="mailto:haris@sl-king.com">mailto:haris@sl-king.com</a>] <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"><a class="moz-txt-link-abbreviated" href="mailto:users@mapguide.osgeo.org">users@mapguide.osgeo.org</a></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=""><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></p>
</blockquote>
</body>
</html>