[Mapserver-users] Help with OracleSpatial Query...
Becher, Richard
RichardBecher@SierraSystems.com
Thu, 15 May 2003 09:17:41 -0400
This is a multi-part message in MIME format.
------_=_NextPart_001_01C31AE4.5D5FCEB2
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi there,
=20
I am now trying to query some simple point data in an Oracle database
using Mapserver.
=20
It seems I am connecting to the database properly and I do not get any
errors.
=20
However, there are no points (data) showing up on my map.
=20
My "Points" layer is the last one in the map file and I have included it
here. You will notice that I have commented out a few things (mainly
because I don't know how to properly use them) - i.e. LabelItem,
CLASSITEM, EXPRESSION, TEMPLATE.
=20
Can someone help me figure out how to properly query data in an Oracle
database (using Windows 2000, IIS, MapServer and Oracle 8i with Spatial
Cartridge)?
=20
Also, how are templates supposed to be used? In other layers (from
sample data) there is a reference to ttt_query.html as a template ---
but that file does not exist on my machine...
=20
Here is a couple of records in the referenced table:
=20
PLACE_ID 529
VERSION_NO 1
LATLONGPOINT.SDO_GTYPE 1
LATLONGPOINT.SDO_SRID 8265
LATLONGPOINT.SDO_POINT.X 51
LATLONGPOINT.SDO_POINT.Y -116
LATLONGPOINT.SDO_POINT.Z =20
LATLONGPOINT.SDO_ELEM_INFO <Collection>
LATLONGPOINT.SDO_ORDINATES <Collection>
=20
PLACE_ID 530
VERSION_NO 1
LATLONGPOINT.SDO_GTYPE 1
LATLONGPOINT.SDO_SRID 8265
LATLONGPOINT.SDO_POINT.X 48
LATLONGPOINT.SDO_POINT.Y -123
LATLONGPOINT.SDO_POINT.Z =20
LATLONGPOINT.SDO_ELEM_INFO <Collection>
LATLONGPOINT.SDO_ORDINATES <Collection>
=20
PLACE_ID 533
VERSION_NO 1
LATLONGPOINT.SDO_GTYPE 1
LATLONGPOINT.SDO_SRID 8265
LATLONGPOINT.SDO_POINT.X 44
LATLONGPOINT.SDO_POINT.Y -76
LATLONGPOINT.SDO_POINT.Z =20
LATLONGPOINT.SDO_ELEM_INFO <Collection>
LATLONGPOINT.SDO_ORDINATES <Collection>
=20
=20
And here is the layer...
=20
=20
LAYER
NAME "Historical Sites"
METADATA
"DESCRIPTION" "Historical Sites" =20
END
CONNECTIONTYPE oraclespatial
CONNECTION 'user/pw@db'
DATA "LatLongPoint from (Select Place_Id, LatLongPoint from
CRHP_SPATIAL)"
TYPE POINT
STATUS ON
#LabelItem "Place_Id" =20
#CLASSITEM "Place_Id"=20
CLASS
NAME "Historical Sites"
#EXPRESSION /./
SYMBOL 2
SIZE 8
COLOR 255 0 0
LABEL
SIZE MEDIUM
COLOR 255 0 0
FORCE TRUE
OFFSET 10 10
END
#TEMPLATE "oraclequery.html"
END
=20
=20
Many thanks in advance for your help and time!
=20
Cheers,
=20
Richard Becher
=20
------_=_NextPart_001_01C31AE4.5D5FCEB2
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C31AC2.D631EE80">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-compose;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:windowtext;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */=20
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple =
style=3D'tab-interval:.5in'>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Hi there,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I am now trying to query some simple point data in an =
Oracle
database using <span =
class=3DSpellE>Mapserver</span>.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>It seems I am connecting to the database properly and =
I do
not get any errors.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>However, there are no points (data) showing up on my =
map.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>My “Points” layer is the last one in the =
map
file and I have included it here.<span style=3D'mso-spacerun:yes'>
</span>You will notice that I have commented out a few things (mainly =
because I
don’t know how to properly use them) – i.e. <span =
class=3DSpellE>LabelItem</span>,
CLASSITEM, EXPRESSION, TEMPLATE.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Can someone help me figure out how to properly query =
data in
an Oracle database (using Windows 2000, IIS, <span =
class=3DSpellE>MapServer</span>
and Oracle 8i with Spatial Cartridge)?<o:p></o:p></span></font></p>
<div style=3D'border:none;border-bottom:solid windowtext =
1.0pt;mso-border-bottom-alt:
solid windowtext .75pt;padding:0in 0in 1.0pt 0in'>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></fo=
nt></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>Also, how are templates =
supposed to
be used?<span style=3D'mso-spacerun:yes'> </span>In other layers =
(from
sample data) there is a reference to ttt_query.html as a template --- =
but that
file does not exist on my machine…<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></fo=
nt></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>Here <span =
class=3DGramE>is</span> a
couple of records in the referenced table:<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></fo=
nt></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>PLACE_ID<span =
style=3D'mso-tab-count:
1'> =
</span>529<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>VERSION_NO<span =
style=3D'mso-tab-count:
1'> </span>1<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_GTYPE<span
style=3D'mso-tab-count:1'> =
</span>1<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_SRID<span
style=3D'mso-tab-count:1'> =
</span>8265<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_POINT.X<spa=
n
style=3D'mso-tab-count:1'> </span>51<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_POINT.Y<spa=
n
style=3D'mso-tab-count:1'> </span>-116<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_POINT.Z<spa=
n
style=3D'mso-tab-count:1'> </span><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_ELEM_INFO<s=
pan
style=3D'mso-tab-count:1'> =
</span><Collection><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_ORDINATES<s=
pan
style=3D'mso-tab-count:1'> =
</span><Collection><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></fo=
nt></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>PLACE_ID<span =
style=3D'mso-tab-count:
1'> =
</span>530<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>VERSION_NO<span =
style=3D'mso-tab-count:
1'> </span>1<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_GTYPE<span
style=3D'mso-tab-count:1'> =
</span>1<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_SRID<span
style=3D'mso-tab-count:1'> =
</span>8265<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_POINT.X<spa=
n
style=3D'mso-tab-count:1'> </span>48<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_POINT.Y<spa=
n
style=3D'mso-tab-count:1'> </span>-123<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_POINT.Z<spa=
n
style=3D'mso-tab-count:1'> </span><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_ELEM_INFO<s=
pan
style=3D'mso-tab-count:1'> =
</span><Collection><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_ORDINATES<s=
pan
style=3D'mso-tab-count:1'> =
</span><Collection><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></fo=
nt></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>PLACE_ID<span =
style=3D'mso-tab-count:
1'> =
</span>533<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>VERSION_NO<span =
style=3D'mso-tab-count:
1'> </span>1<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_GTYPE<span
style=3D'mso-tab-count:1'> =
</span>1<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_SRID<span
style=3D'mso-tab-count:1'> =
</span>8265<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_POINT.X<spa=
n
style=3D'mso-tab-count:1'> </span>44<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_POINT.Y<spa=
n
style=3D'mso-tab-count:1'> </span>-76<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_POINT.Z<spa=
n
style=3D'mso-tab-count:1'> </span><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_ELEM_INFO<s=
pan
style=3D'mso-tab-count:1'> =
</span><Collection><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>LATLONGPOINT.SDO_ORDINATES<s=
pan
style=3D'mso-tab-count:1'> =
</span><Collection><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></fo=
nt></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></fo=
nt></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>And here is the =
layer…<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></fo=
nt></p>
</div>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>LAYER<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>NAME "Historical =
Sites"<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> =
</span>METADATA<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> =
</span>"DESCRIPTION"<span
style=3D'mso-spacerun:yes'> </span>"Historical =
Sites"<span
style=3D'mso-spacerun:yes'> =
</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> =
</span>END<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>CONNECTIONTYPE <span =
class=3DSpellE>oraclespatial</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>CONNECTION 'user/<span =
class=3DSpellE>pw@db</span>'<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>DATA "<span =
class=3DSpellE>LatLongPoint</span>
from (Select <span class=3DSpellE>Place_Id</span>, <span =
class=3DSpellE>LatLongPoint</span>
from CRHP_SPATIAL)"<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>TYPE =
POINT<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>STATUS =
ON<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>#<span =
class=3DSpellE>LabelItem</span>
"<span class=3DSpellE>Place_Id</span>"<span
style=3D'mso-spacerun:yes'> </span><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>#CLASSITEM "<span =
class=3DSpellE>Place_Id</span>"
<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> =
</span>CLASS<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>NAME =
"Historical
Sites"<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>#EXPRESSION /<span
class=3DGramE>./</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>SYMBOL =
2<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>SIZE =
8<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>COLOR 255 0 <span
class=3DSpellE>0</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> =
</span>LABEL<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>SIZE =
MEDIUM<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>COLOR =
255 0 <span
class=3DSpellE>0</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>FORCE =
TRUE<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>OFFSET =
10 <span
class=3DSpellE>10</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> =
</span>END<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'><span
style=3D'mso-spacerun:yes'> </span>#TEMPLATE
"oraclequery.html"<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'><span style=3D'mso-spacerun:yes'> =
</span>END</span></font><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p=
>
<div style=3D'border:none;border-bottom:solid windowtext =
1.0pt;mso-border-bottom-alt:
solid windowtext .75pt;padding:0in 0in 1.0pt 0in'>
<p class=3DMsoNormal style=3D'border:none;mso-border-bottom-alt:solid =
windowtext .75pt;
padding:0in;mso-padding-alt:0in 0in 1.0pt 0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></fo=
nt></p>
</div>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Many thanks in advance for your help and =
time!<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Cheers,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><strong><b><font size=3D3 color=3Dgreen =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt;color:green;mso-no-proof:yes'>Richard =
Becher<o:p></o:p></span></font></b></strong></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
=00
------_=_NextPart_001_01C31AE4.5D5FCEB2--
_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users