[Mapserver-users] PLEASE HELP...
Smith, Michael ERDC-CRREL-NH
Michael.Smith at erdc.usace.army.mil
Fri May 23 10:09:00 EDT 2003
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C32134.DB8999F0
Content-Type: text/plain
Richard,
Your layer is a lat long layer (srid of 8265) but you are setting a projection of UTM on the layer. You should have a projection block like
PROJECTION
"proj=latlong"
"ellps=GRS80"
END
This tells mapserver that the layer is latlong and the UTM in the main map tells mapserver to reproject this layer to UTM-15.
Mike
Mike Smith
email: michael.smith at erdc.usace.army.mil
RSGISC
ERDC - CRREL
Hanover, NH 03755
(603) 646-4765
-----Original Message-----
From: Becher, Richard [mailto:RichardBecher at SierraSystems.com]
Sent: Thursday, May 22, 2003 1:57 PM
To: Smith, Michael ERDC-CRREL-NH; Mapserver-users at lists.gis.umn.edu
Subject: RE: [Mapserver-users] PLEASE HELP...
If you can bear with me, I have included everything that I have set in my mapfile as well as the data in my database.
I am hoping you can spot what I am doing wrong so I can figure out how to display the data from Oracle.
MANY thanks for your help and time.
Here is a record that exists in that table:
Place_Id Version_No LATLONGPOINT.SDO_GTYPE LATLONGPOINT.SDO_SRID LATLONGPOINT.SDO_POINT.X
533 1 1 8265 44
LATLONGPOINT.SDO_POINT.Y LATLONGPOINT.SDO_POINT.Z LATLONGPOINT.SDO_ELEM_INFO
-76 <Collection>
LATLONGPOINT.SDO_ORDINATES
<Collectioin>
Where (as far as I understand) X=48 and Y=-76
Here is the start of my Map file (I may have something set wrong in this section):
# Start of tutorial.map file
#
#
NAME DEMO
STATUS ON
SIZE 400 300
SYMBOLSET ./etc/symbols.sym
EXTENT -2200000 -712631 3072800 3840000
UNITS METERS
SHAPEPATH "./data"
IMAGECOLOR 255 255 255
FONTSET ./etc/fonts.txt
IMAGETYPE PNG
Here is my Projection for the Map File (I will admit that I don't know how this should be set):
PROJECTION
"proj=utm"
"ellps=GRS80"
"zone=15"
"north"
"no_defs"
END
Here is my Web section (however, there is no log being created - using version 3.7...?):
#
# Start of web interface definition
#
WEB
MINSCALE 2000000
MAXSCALE 50000000
IMAGEPATH "/tmp/ms_tmp/"
IMAGEURL "/ms_tmp/"
LOG "/tmp/gmap.log"
END
Here is my complete Layer (Notice Expression is commented out because I don't want to exclude/filter anything):
LAYER
NAME "Historical Sites"
METADATA
"DESCRIPTION" "Historical Sites"
END
CONNECTIONTYPE oraclespatial
CONNECTION 'user/password at db'
DATA "LatLongPoint from (select Place_Id, LatLongPoint from CRHP_SPATIAL)"
TYPE POINT
STATUS ON
#LabelItem "Place_Id"
#CLASSITEM "Place_Id"
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
PROJECTION
"proj=utm"
"ellps=GRS80"
"zone=15"
"north"
"no_defs"
END
#TOLERANCE 5
END # Layer
Again, many thanks for your help and time!
Cheers,
Richard
-----Original Message-----
From: Smith, Michael ERDC-CRREL-NH [mailto:Michael.Smith at erdc.usace.army.mil]
Sent: Thursday, May 22, 2003 1:10 PM
To: Becher, Richard; Smith, Michael ERDC-CRREL-NH; Mapserver-users at lists.gis.umn.edu
Subject: RE: [Mapserver-users] PLEASE HELP...
Are you sure that the locations are correct in the sdo_geometry? e.g. are the lat longs correct.
1. do a select * from crhp_spatial where rownum=1, look at the coords and verify
2. Is there a projection defined for the layer and map.
3. Make sure there is a class defined for the layer.
4. If you are using 3.7(4.0), add a log parameter to your web section and put debug as a line in your map layer.
Hope this helps
Mike Smith
email: michael.smith at erdc.usace.army.mil
RSGISC
ERDC - CRREL
Hanover, NH 03755
(603) 646-4765
-----Original Message-----
From: Becher, Richard [mailto:RichardBecher at SierraSystems.com]
Sent: Thursday, May 22, 2003 12:57 PM
To: Smith, Michael ERDC-CRREL-NH; Mapserver-users at lists.gis.umn.edu
Subject: RE: [Mapserver-users] PLEASE HELP...
Thanks for your reply!
However, I have done all that you mentioned.
Here is the entry in my map file:
CONNECTIONTYPE oraclespatial
CONNECTION 'user/password at db'
DATA "LatLongPoint from CRHP_SPATIAL"
There is definitely data in the table. Like I said there are no errors but the data does not display on my map.
I am retrieving the whole table just to see if I can display anything right now.
Any other ideas as to why my data won't display?
Cheers,
Richard
-----Original Message-----
From: Smith, Michael ERDC-CRREL-NH [mailto:Michael.Smith at erdc.usace.army.mil]
Sent: Thursday, May 22, 2003 11:17 AM
To: Becher, Richard; Mapserver-users at lists.gis.umn.edu
Subject: RE: [Mapserver-users] PLEASE HELP...
Richard,
Mapserver needs to be compiled with the oracle libraries
i.e. --with-oraclespatial = /path/to/oracle/home
Then, in the map file use
CONNECTIONTYPE oraclespatial
CONNECTION 'user/password at tnsname' <mailto:'user/password at tnsname'>
DATA 'sdo_geometry_column FROM tablename'
I've also found that if you use this format for the DATA line, that mapserver will only select data with the extents of you map view, if you use 'sdo_geom_col from (select * from tablename)' which is also valid, on every redraw you will be retrieving the entire data table and not using a spatial index.
You do not have to use OGR to access Oracle. OGR is slower at this point but does support more features (attribute queries mainly).
Another importtant point is to increase the ARRAY_SIZE in the maporaclespatial.c code. By default, it is set at 1, but we get much, much faster performance by increasing the ARRAY_SIZE to 500 or 1000. Basically this allows mapserver to send 500 ot 1000 rows at a time.
Mike Smith
email: michael.smith at erdc.usace.army.mil
RSGISC
ERDC - CRREL
Hanover, NH 03755
(603) 646-4765
-----Original Message-----
From: Becher, Richard [mailto:RichardBecher at SierraSystems.com]
Sent: Thursday, May 22, 2003 10:17 AM
To: Mapserver-users at lists.gis.umn.edu
Subject: [Mapserver-users] PLEASE HELP...
Importance: High
I have not been able to get a response on how to display data using Mapserver from Oracle.
I have created a connection to my Oracle db and I do not get any errors.
However, the data does not display.
I was told that I can't do this direct connection to Oracle and that I have to use OGR.
Can someone please confirm this and give me any help on how to simply display data from my Oracle database using Mapserver?
Any help would be GREATLY appreciated.
Cheers,
Richard Becher
Sierra Systems
130 Slater Street, Suite 800
Ottawa, Ontario K1P 6E2
Phone: 613.236.7888, Extension: 350
Fax: 613.236.9333
Email: RichardBecher at SierraSystems.com
www.SierraSystems.com <http://www.sierrasystems.com/>
------_=_NextPart_001_01C32134.DB8999F0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word" xmlns:x =3D=20
"urn:schemas-microsoft-com:office:excel" xmlns:st1 =3D=20
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<TITLE>Message</TITLE>
<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<META content=3D"Microsoft Word 10" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml at 01C32069.FA798A30" =
rel=3DFile-List><o:SmartTagType=20
name=3D"time"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><o:SmartTagType=20
name=3D"date"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><o:SmartTagType=20
name=3D"PostalCode"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><o:SmartTagType=20
name=3D"State"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><o:SmartTagType=20
name=3D"City"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><o:SmartTagType=20
name=3D"place"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><o:SmartTagType=20
name=3D"Street"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><o:SmartTagType=20
name=3D"address"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTag=
Type><!--[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]--><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@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; =
}
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
P.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New =
Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New =
Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New =
Roman"
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
"Times New Roman"; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal; =
mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-size: =
10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; =
mso-bidi-font-family: Arial
}
SPAN.EmailStyle19 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal; =
mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-size: =
10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; =
mso-bidi-font-family: Arial
}
SPAN.EmailStyle23 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply; =
mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-size: =
10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; =
mso-bidi-font-family: Arial
}
SPAN.SpellE {
mso-style-name: ""; mso-spl-e: yes
}
SPAN.GramE {
mso-style-name: ""; mso-gram-e: yes
}
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 style=3D"tab-interval: .5in" vLink=3Dpurple =
link=3Dblue>
<DIV><SPAN class=3D255540514-23052003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Richard,</FONT></SPAN></DIV>
<DIV><SPAN class=3D255540514-23052003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D255540514-23052003> <FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Your layer is a lat long layer (srid of 8265) =
but you are=20
setting a projection of UTM on the layer. You should have a projection =
block=20
like</FONT></SPAN></DIV>
<DIV><SPAN class=3D255540514-23052003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D255540514-23052003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>PROJECTION<BR> =
"proj=3Dlatlong"<BR> =20
"ellps=3DGRS80"<BR></FONT></SPAN><SPAN class=3D255540514-23052003><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>END</FONT></SPAN></DIV>
<DIV><SPAN class=3D255540514-23052003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D255540514-23052003><FONT face=3DArial =
color=3D#0000ff size=3D2>This=20
tells mapserver that the layer is latlong and the UTM in the main map =
tells=20
mapserver to reproject this layer to UTM-15. </FONT></SPAN></DIV>
<DIV><SPAN class=3D255540514-23052003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D255540514-23052003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Mike</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV>
<P><FONT face=3DArial size=3D1>Mike Smith</FONT> <BR><FONT face=3DArial =
size=3D1>email:=20
michael.smith at erdc.usace.army.mil</FONT> <BR><FONT face=3DArial=20
size=3D1>RSGISC</FONT> <BR><FONT face=3DArial size=3D1>ERDC - CRREL =
</FONT><BR><FONT=20
face=3DArial size=3D1>Hanover, NH 03755</FONT> <BR><FONT =
face=3DArial=20
size=3D1>(603) 646-4765</FONT> </P>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B> =
Becher, Richard=20
[mailto:RichardBecher at SierraSystems.com] <BR><B>Sent:</B> Thursday, =
May 22,=20
2003 1:57 PM<BR><B>To:</B> Smith, Michael ERDC-CRREL-NH;=20
Mapserver-users at lists.gis.umn.edu<BR><B>Subject:</B> RE: =
[Mapserver-users]=20
PLEASE HELP...<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">If you can =
bear with=20
me, I have included everything that I have set in my <SPAN=20
class=3DSpellE>mapfile</SPAN> as well as the data in my=20
database.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">I am =
hoping you can=20
spot what I am doing wrong so I can figure out how to display the =
data from=20
Oracle.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">MANY =
thanks for your=20
help and time.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: =
medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 1pt; BORDER-LEFT: =
medium none; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; =
mso-border-bottom-alt: solid windowtext .75pt">
<P class=3DMsoNormal=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: =
medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: =
medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; =
mso-border-bottom-alt: solid windowtext .75pt; mso-padding-alt: 0in 0in =
1.0pt 0in"><FONT=20
face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Here is a =
record that=20
exists in that table:<o:p></o:p></SPAN></FONT></P></DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><SPAN class=3DSpellE><FONT face=3DArial =
color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">Place_Id</SPAN></FONT></SPAN><FONT=20
face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><SPAN=20
style=3D"mso-tab-count: =
1"> =20
</SPAN><SPAN class=3DSpellE>Version_No</SPAN> <SPAN=20
style=3D"mso-tab-count: 1"> =20
</SPAN>LATLONGPOINT.SDO_GTYPE<SPAN style=3D"mso-tab-count: =
1"> =20
</SPAN>LATLONGPOINT.SDO_SRID<SPAN=20
style=3D"mso-tab-count: =
1"> =20
</SPAN>LATLONGPOINT.SDO_POINT.X<SPAN style=3D"mso-tab-count: =
1"> =20
</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">533<SPAN=20
style=3D"mso-tab-count: =
2"> &nb=
sp; =20
</SPAN>1<SPAN=20
style=3D"mso-tab-count: =
2"> &nb=
sp; =20
</SPAN>1<SPAN=20
style=3D"mso-tab-count: =
4"> &nb=
sp; &nb=
sp; &nb=
sp; =20
</SPAN>8265<SPAN=20
style=3D"mso-tab-count: =
4"> &nb=
sp; &nb=
sp; &nb=
sp; =20
</SPAN>44<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">LATLONGPOINT.SDO_POINT.Y<SPAN=20
style=3D"mso-tab-count: 2"> &=
nbsp; =20
</SPAN>LATLONGPOINT.SDO_POINT.Z<SPAN=20
style=3D"mso-tab-count: =
2"> &nb=
sp; =20
</SPAN>LATLONGPOINT.SDO_ELEM_INFO<SPAN=20
style=3D"mso-tab-count: 1"> =
</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">-76<SPAN=20
style=3D"mso-tab-count: =
10"> &n=
bsp; &n=
bsp; &n=
bsp; &n=
bsp; &n=
bsp; &n=
bsp; &n=
bsp; &n=
bsp; &n=
bsp; =20
</SPAN><Collection><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">LATLONGPOINT.SDO_ORDINATES<o:p></o:p></SPAN></FONT></P>
<DIV=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: =
medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 1pt; BORDER-LEFT: =
medium none; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; =
mso-border-bottom-alt: solid windowtext .75pt">
<P class=3DMsoNormal=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: =
medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: =
medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; =
mso-border-bottom-alt: solid windowtext .75pt; mso-padding-alt: 0in 0in =
1.0pt 0in"><FONT=20
face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><<SPAN=20
class=3DSpellE>Collectioin</SPAN>><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: =
medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: =
medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; =
mso-border-bottom-alt: solid windowtext .75pt; mso-padding-alt: 0in 0in =
1.0pt 0in"><FONT=20
face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal=20
style=3D"BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: =
medium none; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: =
medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; =
mso-border-bottom-alt: solid windowtext .75pt; mso-padding-alt: 0in 0in =
1.0pt 0in"><FONT=20
face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Where (as =
far as I=20
understand) X=3D48 and Y=3D-76<o:p></o:p></SPAN></FONT></P></DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Here is =
the start of=20
my Map file (I may have something set wrong in this=20
section):<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"># Start of =
<SPAN=20
class=3DSpellE>tutorial.map</SPAN> file<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">#<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">#<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">NAME=20
DEMO<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">STATUS=20
ON<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">SIZE 400=20
300<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">SYMBOLSET =
./etc/<SPAN=20
class=3DSpellE>symbols.sym</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">EXTENT -2200000 =
-712631=20
3072800 3840000<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">UNITS=20
METERS<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">SHAPEPATH =
"<SPAN=20
class=3DGramE>./</SPAN>data"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">IMAGECOLOR 255 =
<SPAN=20
class=3DSpellE>255</SPAN> <SPAN=20
class=3DSpellE>255</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">FONTSET=20
./etc/fonts.txt<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">IMAGETYPE=20
PNG<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Here is my =
Projection=20
for the Map File (I will admit that I don't know how this should be=20
set):<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">PROJECTION<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-tab-count: 1"> =
</SPAN>"<SPAN=20
class=3DSpellE><SPAN class=3DGramE>proj</SPAN></SPAN><SPAN=20
class=3DGramE>=3D</SPAN><SPAN=20
class=3DSpellE>utm</SPAN>"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-tab-count: 1"> =
</SPAN>"<SPAN=20
class=3DSpellE><SPAN class=3DGramE>ellps</SPAN></SPAN><SPAN=20
class=3DGramE>=3D</SPAN>GRS80"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-tab-count: 1"> =
</SPAN>"<SPAN=20
class=3DGramE>zone=3D</SPAN>15"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-tab-count: 1"> =
</SPAN>"<SPAN=20
class=3DGramE>north</SPAN>"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-tab-count: 1"> =
</SPAN>"<SPAN=20
class=3DSpellE>no_defs</SPAN>"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">END</SPAN></FONT><FONT=20
face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Here is my =
Web=20
section (however, there is no log being created - using version=20
3.7...?):<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">#<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"># Start of web =
interface=20
definition<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">#<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">WEB<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>MINSCALE=20
2000000<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>MAXSCALE=20
50000000<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>IMAGEPATH "/<SPAN=20
class=3DSpellE>tmp/ms_tmp</SPAN>/" <o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>IMAGEURL "/<SPAN=20
class=3DSpellE>ms_tmp</SPAN>/" <o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>LOG "/<SPAN=20
class=3DSpellE>tmp/gmap.log</SPAN>"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">END</SPAN></FONT><FONT=20
face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Here is my =
complete=20
Layer (Notice Expression is commented out because I don't want to=20
exclude/filter anything):<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">LAYER<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>NAME "Historical=20
Sites"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =
</SPAN>METADATA<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =
</SPAN>"DESCRIPTION"<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>"Historical =
Sites"<SPAN=20
style=3D"mso-spacerun: yes"> =20
</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =
</SPAN>END<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>CONNECTIONTYPE <SPAN=20
class=3DSpellE>oraclespatial</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>CONNECTION 'user/<SPAN=20
class=3DSpellE>password at db</SPAN>'<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>DATA "<SPAN=20
class=3DSpellE>LatLongPoint</SPAN> from (select <SPAN=20
class=3DSpellE>Place_Id</SPAN>, <SPAN =
class=3DSpellE>LatLongPoint</SPAN> from=20
CRHP_SPATIAL)"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>TYPE=20
POINT<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
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"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>#<SPAN =
class=3DSpellE>LabelItem</SPAN>=20
"<SPAN class=3DSpellE>Place_Id</SPAN>"<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>#CLASSITEM "<SPAN=20
class=3DSpellE>Place_Id</SPAN>" <o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =
</SPAN>CLASS<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>NAME =
"Historical=20
Sites"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>#EXPRESSION =
/<SPAN=20
class=3DGramE>./</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>SYMBOL=20
2<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>SIZE=20
8<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>COLOR 255 0 =
<SPAN=20
class=3DSpellE>0</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =20
</SPAN>LABEL<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =
</SPAN>SIZE=20
MEDIUM<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =
</SPAN>COLOR 255 0=20
<SPAN class=3DSpellE>0</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =
</SPAN>FORCE=20
TRUE<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =
</SPAN>OFFSET 10=20
<SPAN class=3DSpellE>10</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =20
</SPAN>END<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>#TEMPLATE=20
"oraclequery.html"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =
</SPAN>END<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =20
</SPAN>PROJECTION<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-tab-count: 1"> =
</SPAN>"<SPAN=20
class=3DSpellE><SPAN class=3DGramE>proj</SPAN></SPAN><SPAN=20
class=3DGramE>=3D</SPAN><SPAN=20
class=3DSpellE>utm</SPAN>"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-tab-count: 1"> =
</SPAN>"<SPAN=20
class=3DSpellE><SPAN class=3DGramE>ellps</SPAN></SPAN><SPAN=20
class=3DGramE>=3D</SPAN>GRS80"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-tab-count: 1"> =
</SPAN>"<SPAN=20
class=3DGramE>zone=3D</SPAN>15"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-tab-count: 1"> =
</SPAN>"<SPAN=20
class=3DGramE>north</SPAN>"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-tab-count: 1"> =
</SPAN>"<SPAN=20
class=3DSpellE>no_defs</SPAN>"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> =
</SPAN>END<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>#TOLERANCE=20
5<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">END #=20
Layer<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Again, =
many thanks=20
for your help and time!<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">Cheers,<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">Richard<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DTahoma =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: bold">From:</SPAN></B> =
Smith,=20
Michael ERDC-CRREL-NH [mailto:Michael.Smith at erdc.usace.army.mil] =
<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> </SPAN></FONT><st1:date=20
style=3D"BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: =
url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"=20
Year=3D"2003" Day=3D"22" Month=3D"5"><FONT face=3DTahoma =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Thursday, May 22,=20
2003</SPAN></FONT></st1:date><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> =
</SPAN></FONT><st1:time=20
Minute=3D"10" Hour=3D"13"><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">1:10=20
PM</SPAN></FONT></st1:time><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"><BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">To:</SPAN></B> Becher, Richard; Smith, =
Michael=20
ERDC-CRREL-NH; Mapserver-users at lists.gis.umn.edu<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [Mapserver-users] =
PLEASE=20
HELP...</SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN style=3D"FONT-SIZE: =
12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">Are you=20
sure that the locations are correct in the sdo_geometry? e.g. are the =
lat=20
longs correct. </SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">1. do a=20
select * from crhp_spatial where rownum=3D1, look at the coords and=20
verify</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">2. Is=20
there a projection defined for the layer and=20
map.</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">3. Make=20
sure there is a class defined for the=20
layer.</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">4. If=20
you are using 3.7(4.0), add a log parameter to your web section and =
put debug=20
as a line in your map layer.</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">Hope=20
this helps</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<P style=3D"MARGIN-LEFT: 0.5in"><FONT face=3DArial size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">Mike =
Smith</SPAN></FONT>=20
<BR><FONT face=3DArial size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">email:=20
michael.smith at erdc.usace.army.mil</SPAN></FONT> <BR><FONT =
face=3DArial=20
size=3D1><SPAN style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: =
Arial">RSGISC</SPAN></FONT>=20
<BR><FONT face=3DArial size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">ERDC - CRREL=20
</SPAN></FONT><BR><FONT face=3DArial size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">Hanover, NH =20
03755</SPAN></FONT> <BR><FONT face=3DArial size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">(603) =
646-4765</SPAN></FONT>=20
<o:p></o:p></P>
<BLOCKQUOTE style=3D"MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; =
MARGIN-RIGHT: 0in">
<P class=3DMsoNormal=20
style=3D"MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: =
0in; mso-margin-top-alt: 0in"><FONT=20
face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">From:</SPAN></B> Becher,=20
Richard [mailto:RichardBecher at SierraSystems.com] <BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> =
</SPAN></FONT><st1:date=20
style=3D"BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: =
url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"=20
Year=3D"2003" Day=3D"22" Month=3D"5"><FONT face=3DTahoma =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Thursday, May 22,=20
2003</SPAN></FONT></st1:date><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> =
</SPAN></FONT><st1:time=20
Minute=3D"57" Hour=3D"12"><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">12:57=20
PM</SPAN></FONT></st1:time><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"><BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">To:</SPAN></B> Smith, Michael =
ERDC-CRREL-NH;=20
Mapserver-users at lists.gis.umn.edu<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: =
[Mapserver-users] PLEASE=20
HELP...</SPAN></FONT><o:p></o:p></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3DArial color=3Dnavy=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">Thanks=20
for your reply!<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3DArial color=3Dnavy=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3DArial color=3Dnavy=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">However, =
I have=20
done all that you mentioned.<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3DArial color=3Dnavy=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3DArial color=3Dnavy=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">Here=20
is the entry in my map file:<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3DArial color=3Dnavy=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 0.5in; mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">CONNECTIONTYPE=20
oraclespatial<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 0.5in; mso-layout-grid-align: none"><FONT=20
face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">CONNECTION=20
'user/password at db'<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3D"Courier New"=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">DATA=20
"LatLongPoint from CRHP_SPATIAL"<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3D"Courier New"=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3D"Courier New"=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">There is=20
definitely data in the table.<SPAN style=3D"mso-spacerun: =
yes"> =20
</SPAN>Like I said there are no errors but</SPAN></FONT><FONT =
face=3DArial=20
color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">=20
</SPAN></FONT><FONT face=3D"Courier New" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">the data does =
not=20
display on my map.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3D"Courier New"=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3D"Courier New"=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">I am=20
retrieving the whole table just to see if I can display anything =
right=20
now.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3D"Courier New"=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3D"Courier New"=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">Any other=20
ideas as to why my data won't display?<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3D"Courier New"=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3D"Courier New"=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">Cheers,<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3D"Courier New"=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3D"Courier New"=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier =
New'">Richard<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3DArial color=3Dnavy=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3DTahoma =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">From:</SPAN></B> Smith,=20
Michael ERDC-CRREL-NH [mailto:Michael.Smith at erdc.usace.army.mil]=20
<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B>=20
</SPAN></FONT><st1:date=20
style=3D"BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: =
url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"=20
Year=3D"2003" Day=3D"22" Month=3D"5"><FONT face=3DTahoma =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Thursday, May 22,=20
2003</SPAN></FONT></st1:date><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> =
</SPAN></FONT><st1:time=20
Minute=3D"17" Hour=3D"11"><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">11:17=20
AM</SPAN></FONT></st1:time><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"><BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">To:</SPAN></B> Becher, Richard;=20
Mapserver-users at lists.gis.umn.edu<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: =
[Mapserver-users] PLEASE=20
HELP...</SPAN></FONT><o:p></o:p></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN style=3D"FONT-SIZE: =
12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Richard, =
</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">Mapserver needs to=20
be compiled with the oracle =
libraries</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">i.e.=20
--with-oraclespatial =3D=20
/path/to/oracle/home</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">Then,=20
in the map file use </SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial"> CONNECTIONTYPE=20
oraclespatial<BR> CONNECTION '<A=20
=
href=3D"mailto:'user/password at tnsname'">user/password at tnsname'</A><BR>&n=
bsp;DATA=20
'sdo_geometry_column FROM =
tablename'</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">I've=20
also found that if you use this format for the DATA line, that =
mapserver=20
will only select data with the extents of you map view, if you use=20
'sdo_geom_col from (select * from tablename)' which is also valid, =
on every=20
redraw you will be retrieving the entire data table and not using a =
spatial=20
index.</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">You do=20
not have to use OGR to access Oracle. OGR is slower at this point =
but does=20
support more features (attribute queries mainly).=20
</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3DArial =
color=3Dblue=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Another =
importtant=20
point is to increase the ARRAY_SIZE in the maporaclespatial.c code. =
By=20
default, it is set at 1, but we get much, much faster performance =
by=20
increasing the ARRAY_SIZE to 500 or 1000. Basically this allows =
mapserver to=20
send 500 ot 1000 rows at a time. =
</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT face=3DArial =
size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">Mike =
Smith</SPAN></FONT>=20
<BR><FONT face=3DArial size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">email:=20
michael.smith at erdc.usace.army.mil</SPAN></FONT> <BR><FONT =
face=3DArial=20
size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">RSGISC</SPAN></FONT> =
<BR><FONT=20
face=3DArial size=3D1><SPAN style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: =
Arial">ERDC -=20
CRREL </SPAN></FONT><BR><FONT face=3DArial size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">Hanover, NH =20
03755</SPAN></FONT> <BR><FONT face=3DArial size=3D1><SPAN=20
style=3D"FONT-SIZE: 7.5pt; FONT-FAMILY: Arial">(603) =
646-4765</SPAN></FONT>=20
<o:p></o:p></P></DIV>
<BLOCKQUOTE=20
style=3D"MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: =
0in"><P=20
class=3DMsoNormal=20
style=3D"MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 1in; MARGIN-RIGHT: =
0in; mso-margin-top-alt: 0in"><FONT=20
face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">From:</SPAN></B>=20
Becher, Richard [mailto:RichardBecher at SierraSystems.com] =
<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> =
</SPAN></FONT><st1:date=20
style=3D"BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: =
url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"=20
Year=3D"2003" Day=3D"22" Month=3D"5"><FONT face=3DTahoma =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Thursday, May 22,=20
2003</SPAN></FONT></st1:date><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> =
</SPAN></FONT><st1:time=20
Minute=3D"17" Hour=3D"10"><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">10:17=20
AM</SPAN></FONT></st1:time><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"><BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">To:</SPAN></B>=20
Mapserver-users at lists.gis.umn.edu<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> [Mapserver-users] =
PLEASE=20
HELP...<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">Importance:</SPAN></B>=20
High</SPAN></FONT><o:p></o:p></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I have not been =
able to get a=20
response on how to display data using Mapserver from=20
Oracle.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I have created a =
connection to=20
my Oracle db and I do not get any =
errors.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">However, the data =
does not=20
display.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I was told that I =
can't do=20
this direct connection to Oracle and that I have to use=20
OGR.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Can someone please =
confirm=20
this and give me any help on how to simply display data from my =
Oracle=20
database using Mapserver?<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Any help would be =
GREATLY=20
appreciated.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">Cheers,<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><STRONG><B><FONT=20
face=3D"Times New Roman" color=3Dgreen size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt; COLOR: green; mso-no-proof: =
yes">Richard=20
Becher<o:p></o:p></SPAN></FONT></B></STRONG></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><EM><B><I><FONT=20
face=3D"Times New Roman" color=3Dgreen size=3D3><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 12pt; COLOR: green; =
mso-no-proof: yes">Sierra=20
Systems</SPAN></FONT></I></B></EM><B><FONT color=3Dgreen><SPAN=20
style=3D"FONT-WEIGHT: bold; COLOR: green; mso-no-proof: =
yes"><BR></SPAN></FONT></B><st1:Street><st1:address=20
style=3D"BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: =
url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"><FONT=20
color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; mso-no-proof: yes">130 =
Slater=20
Street, Suite =
800</SPAN></FONT></st1:address></st1:Street><FONT=20
color=3Dnavy><SPAN=20
style=3D"COLOR: navy; mso-no-proof: =
yes"><BR></SPAN></FONT><st1:place><st1:City><FONT=20
color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; mso-no-proof: =
yes">Ottawa</SPAN></FONT></st1:City><FONT=20
color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; mso-no-proof: yes">,=20
</SPAN></FONT><st1:State><FONT color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; mso-no-proof: =
yes">Ontario</SPAN></FONT></st1:State><FONT=20
color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; mso-no-proof: yes">=20
</SPAN></FONT><st1:PostalCode><FONT color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; mso-no-proof: yes">K1P=20
6E2</SPAN></FONT></st1:PostalCode></st1:place><FONT =
color=3Dnavy><SPAN=20
style=3D"COLOR: navy; mso-no-proof: yes"><BR></SPAN></FONT><FONT =
color=3Dnavy=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; mso-no-proof: yes">Phone:=20
613.236.7888, Extension: 350</SPAN></FONT><FONT color=3Dnavy =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy"><o:p></o:p></SPAN></FONT></=
P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3D"Times New Roman"=20
color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; mso-no-proof: yes">Fax:=20
613.236.9333</SPAN></FONT><FONT color=3Dnavy><SPAN=20
style=3D"COLOR: navy; mso-no-proof: yes"><BR></SPAN></FONT><FONT =
color=3Dnavy=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; mso-no-proof: yes">Email:=20
RichardBecher at SierraSystems.com</SPAN></FONT><FONT =
color=3Dnavy><SPAN=20
style=3D"COLOR: navy; mso-no-proof: yes"><BR></SPAN></FONT><FONT =
color=3Dnavy=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: navy; =
mso-no-proof: yes"><A=20
=
href=3D"http://www.sierrasystems.com/">www.SierraSystems.com</A></SPAN><=
/FONT><SPAN=20
style=3D"mso-no-proof: yes"><o:p></o:p></SPAN></P>
<P class=3DMsoAutoSig style=3D"MARGIN-LEFT: 1in"><FONT =
face=3D"Times New Roman"=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt; mso-no-proof: =
yes"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 1in"><FONT =
face=3D"Times New Roman"=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"><o:p> </o:p></SPAN></FONT></P></BLOCKQUOTE></BLOCKQUOTE></DIV=
></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C32134.DB8999F0--
More information about the mapserver-users
mailing list