[Mapserver-users] PLEASE HELP...
Becher, Richard
RichardBecher@SierraSystems.com
Thu, 22 May 2003 13:56:44 -0400
This is a multi-part message in MIME format.
------_=_NextPart_001_01C3208B.81A25810
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
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.
=20
I am hoping you can spot what I am doing wrong so I can figure out how
to display the data from Oracle.
=20
MANY thanks for your help and time.
=20
Here is a record that exists in that table:
=20
Place_Id Version_No LATLONGPOINT.SDO_GTYPE
LATLONGPOINT.SDO_SRID LATLONGPOINT.SDO_POINT.X =20
533 1 1
8265 44
=20
LATLONGPOINT.SDO_POINT.Y LATLONGPOINT.SDO_POINT.Z
LATLONGPOINT.SDO_ELEM_INFO =20
-76
<Collection>
=20
LATLONGPOINT.SDO_ORDINATES
<Collectioin>
=20
Where (as far as I understand) X=3D48 and Y=3D-76
=20
=20
Here is the start of my Map file (I may have something set wrong in this
section):
=20
# 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
=20
Here is my Projection for the Map File (I will admit that I don't know
how this should be set):
PROJECTION
"proj=3Dutm"
"ellps=3DGRS80"
"zone=3D15"
"north"
"no_defs"
END
=20
=20
Here is my Web section (however, there is no log being created - using
version 3.7...?):
=20
#
# Start of web interface definition
#
WEB
MINSCALE 2000000
MAXSCALE 50000000
IMAGEPATH "/tmp/ms_tmp/"=20
IMAGEURL "/ms_tmp/"=20
LOG "/tmp/gmap.log"
END
=20
=20
Here is my complete Layer (Notice Expression is commented out because I
don't want to exclude/filter anything):
=20
LAYER
NAME "Historical Sites"
METADATA
"DESCRIPTION" "Historical Sites" =20
END
CONNECTIONTYPE oraclespatial
CONNECTION 'user/password@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
PROJECTION
"proj=3Dutm"
"ellps=3DGRS80"
"zone=3D15"
"north"
"no_defs"
END
=20
#TOLERANCE 5
END # Layer
=20
Again, many thanks for your help and time!
=20
Cheers,
=20
Richard
=20
-----Original Message-----
From: Smith, Michael ERDC-CRREL-NH
[mailto:Michael.Smith@erdc.usace.army.mil]=20
Sent: Thursday, May 22, 2003 1:10 PM
To: Becher, Richard; Smith, Michael ERDC-CRREL-NH;
Mapserver-users@lists.gis.umn.edu
Subject: RE: [Mapserver-users] PLEASE HELP...
=20
Are you sure that the locations are correct in the sdo_geometry? e.g.
are the lat longs correct.=20
=20
1. do a select * from crhp_spatial where rownum=3D1, look at the coords
and verify
=20
2. Is there a projection defined for the layer and map.
=20
3. Make sure there is a class defined for the layer.
=20
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.
=20
Hope this helps
=20
=20
Mike Smith=20
email: michael.smith@erdc.usace.army.mil=20
RSGISC=20
ERDC - CRREL=20
Hanover, NH 03755=20
(603) 646-4765=20
-----Original Message-----
From: Becher, Richard [mailto:RichardBecher@SierraSystems.com]=20
Sent: Thursday, May 22, 2003 12:57 PM
To: Smith, Michael ERDC-CRREL-NH;
Mapserver-users@lists.gis.umn.edu
Subject: RE: [Mapserver-users] PLEASE HELP...
Thanks for your reply!
=20
However, I have done all that you mentioned. =20
=20
Here is the entry in my map file:
=20
CONNECTIONTYPE oraclespatial
CONNECTION 'user/password@db'
DATA "LatLongPoint from CRHP_SPATIAL"
=20
There is definitely data in the table. Like I said there are no
errors but the data does not display on my map.
=20
I am retrieving the whole table just to see if I can display
anything right now.
=20
Any other ideas as to why my data won't display?
=20
Cheers,
=20
Richard
=20
-----Original Message-----
From: Smith, Michael ERDC-CRREL-NH
[mailto:Michael.Smith@erdc.usace.army.mil]=20
Sent: Thursday, May 22, 2003 11:17 AM
To: Becher, Richard; Mapserver-users@lists.gis.umn.edu
Subject: RE: [Mapserver-users] PLEASE HELP...
=20
Richard,=20
=20
Mapserver needs to be compiled with the oracle libraries
=20
i.e. --with-oraclespatial =3D /path/to/oracle/home
=20
Then, in the map file use=20
=20
CONNECTIONTYPE oraclespatial
CONNECTION 'user/password@tnsname'
<mailto:'user/password@tnsname'>=20
DATA 'sdo_geometry_column FROM tablename'
=20
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.
=20
You do not have to use OGR to access Oracle. OGR is slower at
this point but does support more features (attribute queries mainly).=20
=20
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.=20
=20
Mike Smith=20
email: michael.smith@erdc.usace.army.mil=20
RSGISC=20
ERDC - CRREL=20
Hanover, NH 03755=20
(603) 646-4765=20
-----Original Message-----
From: Becher, Richard
[mailto:RichardBecher@SierraSystems.com]=20
Sent: Thursday, May 22, 2003 10:17 AM
To: Mapserver-users@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.
=20
I have created a connection to my Oracle db and I do not
get any errors.
=20
However, the data does not display.
=20
I was told that I can't do this direct connection to
Oracle and that I have to use OGR.
=20
Can someone please confirm this and give me any help on
how to simply display data from my Oracle database using Mapserver?
=20
Any help would be GREATLY appreciated.
=20
Cheers,
=20
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@SierraSystems.com
www.SierraSystems.com <http://www.sierrasystems.com/>=20
=20
=20
------_=_NextPart_001_01C3208B.81A25810
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
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@01C32069.FA798A30">
<title>Message</title>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"time"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"date"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PostalCode"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"State"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"Street"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"address"/>
<!--[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 Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:1627421319 -2147483648 8 0 66047 0;}
/* 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";}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal;
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.EmailStyle19
{mso-style-type:personal;
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:navy;}
span.EmailStyle23
{mso-style-type:personal-reply;
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:navy;}
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 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>If you can bear with me, I have =
included
everything that I have set in my <span class=3DSpellE>mapfile</span> as =
well as
the data in my database.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I am hoping you can spot what I am =
doing
wrong so I can figure out how to display the data from =
Oracle.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>MANY thanks for your help and =
time.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><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 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Here is
a record that exists in that table:<o:p></o:p></span></font></p>
</div>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><span class=3DSpellE><font size=3D2 color=3Dnavy =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Place_Id</span></=
font></span><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'><span =
style=3D'mso-tab-count:1'>  =
; </span><span
class=3DSpellE>Version_No</span> <span =
style=3D'mso-tab-count:1'> =
</span>LATLONGPOINT.SDO_GTYPE<span
style=3D'mso-tab-count:1'> </span>LATLONGPOINT.SDO_SRID<span
style=3D'mso-tab-count:1'>  =
; </span>LATLONGPOINT.SDO_POINT.X<span
style=3D'mso-tab-count:1'> </span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>533<span =
style=3D'mso-tab-count:2'>  =
; =
</span>1<span
style=3D'mso-tab-count:2'>  =
; =
</span>1<span
style=3D'mso-tab-count:4'>  =
; =
&=
nbsp; &n=
bsp; </span>8265<span
style=3D'mso-tab-count:4'>  =
; =
&=
nbsp; =
</span>44<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>LATLONGPOINT.SDO_POINT.Y<span
style=3D'mso-tab-count:2'>  =
; </span>LATLONGPOINT.SDO_POINT.Z<span
style=3D'mso-tab-count:2'>  =
; </span>LATLONGPOINT.SDO_ELEM_INFO<span
style=3D'mso-tab-count:1'> =
</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>-76<span =
style=3D'mso-tab-count:10'> &nbs=
p;  =
; =
&=
nbsp; &n=
bsp; &nb=
sp; &nbs=
p;  =
; =
=
</span><Collection><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>LATLONGPOINT.SDO_ORDINATES<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 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><<span
class=3DSpellE>Collectioin</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 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><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 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Where
(as far as I understand) X=3D48 and Y=3D-76<o:p></o:p></span></font></p>
</div>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Here is the start of my Map file (I =
may
have something set wrong in this section):<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><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"'>#
Start of <span class=3DSpellE>tutorial.map</span> =
file<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"'>#<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"'>#<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"'>NAME
DEMO<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"'>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"'>SIZE
400 300<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"'>SYMBOLSET
./etc/<span =
class=3DSpellE>symbols.sym</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"'>EXTENT
-2200000 -712631 3072800 3840000<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"'>UNITS
METERS<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"'>SHAPEPATH
"<span =
class=3DGramE>./</span>data"<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"'>IMAGECOLOR
255 <span class=3DSpellE>255</span> <span =
class=3DSpellE>255</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"'>FONTSET
./etc/fonts.txt<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"'>IMAGETYPE PNG<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Here is my Projection for the Map =
File (I
will admit that I don’t know how this should be =
set):<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"'>PROJECTION<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-tab-count:1'> =
</span>"<span
class=3DSpellE><span class=3DGramE>proj</span></span><span =
class=3DGramE>=3D</span><span
class=3DSpellE>utm</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-tab-count:1'> =
</span>"<span
class=3DSpellE><span class=3DGramE>ellps</span></span><span =
class=3DGramE>=3D</span>GRS80"<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-tab-count:1'> =
</span>"<span
class=3DGramE>zone=3D</span>15"<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-tab-count:1'> =
</span>"<span
class=3DGramE>north</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-tab-count:1'> =
</span>"<span
class=3DSpellE>no_defs</span>"<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"'>END</span></font><font size=3D2 color=3Dnavy =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p></o:p></span=
></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Here is my Web section (however, =
there is
no log being created – using version =
3.7…?):<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><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"'>#<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"'>#
Start of web interface definition<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"'>#<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"'>WEB<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>MINSCALE =
2000000<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>MAXSCALE =
50000000<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>IMAGEPATH "/<span =
class=3DSpellE>tmp/ms_tmp</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>IMAGEURL "/<span =
class=3DSpellE>ms_tmp</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>LOG "/<span =
class=3DSpellE>tmp/gmap.log</span>"<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"'>END</span></font><font size=3D2 color=3Dnavy =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p></o:p></span=
></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Here is my complete Layer (Notice
Expression is commented out because I don’t want to exclude/filter
anything):<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><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>password@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><span
style=3D'mso-spacerun:yes'> </span>#TEMPLATE =
"oraclequery.html"<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"'><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>PROJECTION<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-tab-count:1'> =
</span>"<span
class=3DSpellE><span class=3DGramE>proj</span></span><span =
class=3DGramE>=3D</span><span
class=3DSpellE>utm</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-tab-count:1'> =
</span>"<span
class=3DSpellE><span class=3DGramE>ellps</span></span><span =
class=3DGramE>=3D</span>GRS80"<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-tab-count:1'> =
</span>"<span
class=3DGramE>zone=3D</span>15"<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-tab-count:1'> =
</span>"<span
class=3DGramE>north</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-tab-count:1'> =
</span>"<span
class=3DSpellE>no_defs</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"'><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>#TOLERANCE =
5<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"'>END # Layer<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"'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Again, many thanks for your help =
and time!<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Cheers,<o:p></o:p></span></font></p>=
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Richard<o:p></o:p></span></font></p>=
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Smith, Michael =
ERDC-CRREL-NH
[mailto:Michael.Smith@erdc.usace.army.mil] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> =
</span></font><st1:date
Month=3D"5" Day=3D"22" Year=3D"2003"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma'>Thursday, May 22, =
2003</span></font></st1:date><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'> </span></font><st1:time
Hour=3D"13" Minute=3D"10"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'>1:10 PM</span></font></st1:time><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'><br>
<b><span style=3D'font-weight:bold'>To:</span></b> Becher, Richard; =
Smith,
Michael ERDC-CRREL-NH; Mapserver-users@lists.gis.umn.edu<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: =
[Mapserver-users]
PLEASE HELP...</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Are you sure =
that the
locations are correct in the sdo_geometry? e.g. are the lat longs =
correct. </span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>1. do a select * =
from
crhp_spatial where rownum=3D1, look at the coords and =
verify</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>2. Is there a =
projection
defined for the layer and map.</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>3. Make sure =
there is a
class defined for the layer.</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>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.</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dblue face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Hope this =
helps</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<p style=3D'margin-left:.5in'><font size=3D1 face=3DArial><span =
style=3D'font-size:
7.5pt;font-family:Arial'>Mike Smith</span></font> <br>
<font size=3D1 face=3DArial><span =
style=3D'font-size:7.5pt;font-family:Arial'>email:
michael.smith@erdc.usace.army.mil</span></font> <br>
<font size=3D1 face=3DArial><span =
style=3D'font-size:7.5pt;font-family:Arial'>RSGISC</span></font>
<br>
<font size=3D1 face=3DArial><span =
style=3D'font-size:7.5pt;font-family:Arial'>ERDC -
CRREL </span></font><br>
<font size=3D1 face=3DArial><span =
style=3D'font-size:7.5pt;font-family:Arial'>Hanover,
NH 03755</span></font> <br>
<font size=3D1 face=3DArial><span =
style=3D'font-size:7.5pt;font-family:Arial'>(603)
646-4765</span></font> <o:p></o:p></p>
<blockquote =
style=3D'margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Becher, Richard
[mailto:RichardBecher@SierraSystems.com] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> =
</span></font><st1:date
Month=3D"5" Day=3D"22" Year=3D"2003"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma'>Thursday, May 22, =
2003</span></font></st1:date><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'> </span></font><st1:time
Hour=3D"12" Minute=3D"57"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'>12:57 PM</span></font></st1:time><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'><br>
<b><span style=3D'font-weight:bold'>To:</span></b> Smith, Michael =
ERDC-CRREL-NH;
Mapserver-users@lists.gis.umn.edu<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: =
[Mapserver-users]
PLEASE HELP...</span></font><o:p></o:p></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Thanks for your =
reply!<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p>=
</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>However, I have =
done all
that you mentioned.<span style=3D'mso-spacerun:yes'> =
</span><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p>=
</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Here is the =
entry in my
map file:<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p>=
</span></font></p>
<p class=3DMsoNormal =
style=3D'margin-left:.5in;mso-layout-grid-align:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>CONNECTIONTYPE
oraclespatial<o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'margin-left:.5in;mso-layout-grid-align:none'><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>CONNECTION
'user/password@db'<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier New"'>DATA =
"LatLongPoint from
CRHP_SPATIAL"<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier New"'>There is definitely =
data in
the table.<span style=3D'mso-spacerun:yes'> </span>Like I said =
there are no
errors but</span></font><font size=3D2 color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'> =
</span></font><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New"'>the
data does not display on my map.<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier New"'>I am retrieving the =
whole
table just to see if I can display anything right =
now.<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier New"'>Any other ideas as =
to why my
data won't display?<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>Cheers,<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>Richard<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p>=
</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Smith, Michael =
ERDC-CRREL-NH
[mailto:Michael.Smith@erdc.usace.army.mil] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> =
</span></font><st1:date
Month=3D"5" Day=3D"22" Year=3D"2003"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma'>Thursday, May 22, =
2003</span></font></st1:date><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'> </span></font><st1:time
Hour=3D"11" Minute=3D"17"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'>11:17 AM</span></font></st1:time><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'><br>
<b><span style=3D'font-weight:bold'>To:</span></b> Becher, Richard;
Mapserver-users@lists.gis.umn.edu<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: =
[Mapserver-users]
PLEASE HELP...</span></font><o:p></o:p></p>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Richard,
</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Mapserver
needs to be compiled with the oracle =
libraries</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>i.e.
--with-oraclespatial =3D =
/path/to/oracle/home</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Then, in
the map file use </span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'> CONNECTIONT=
YPE
oraclespatial<br>
CONNECTION '<a =
href=3D"mailto:'user/password@tnsname'">user/password@tnsname'</a><br>
DATA 'sdo_geometry_column FROM =
tablename'</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>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.</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>You do
not have to use OGR to access Oracle. OGR is slower at this point but =
does
support more features (attribute queries mainly). =
</span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dblue
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>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. </span></font><o:p></o:p></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D1 =
face=3DArial><span
style=3D'font-size:7.5pt;font-family:Arial'>Mike Smith</span></font> =
<br>
<font size=3D1 face=3DArial><span =
style=3D'font-size:7.5pt;font-family:Arial'>email:
michael.smith@erdc.usace.army.mil</span></font> <br>
<font size=3D1 face=3DArial><span =
style=3D'font-size:7.5pt;font-family:Arial'>RSGISC</span></font>
<br>
<font size=3D1 face=3DArial><span =
style=3D'font-size:7.5pt;font-family:Arial'>ERDC -
CRREL </span></font><br>
<font size=3D1 face=3DArial><span =
style=3D'font-size:7.5pt;font-family:Arial'>Hanover,
NH 03755</span></font> <br>
<font size=3D1 face=3DArial><span =
style=3D'font-size:7.5pt;font-family:Arial'>(603)
646-4765</span></font> <o:p></o:p></p>
</div>
<blockquote =
style=3D'margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<p class=3DMsoNormal =
style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:1.0in'><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Becher, Richard
[mailto:RichardBecher@SierraSystems.com] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> =
</span></font><st1:date
Month=3D"5" Day=3D"22" Year=3D"2003"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma'>Thursday, May 22, =
2003</span></font></st1:date><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'> </span></font><st1:time
Hour=3D"10" Minute=3D"17"><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'>10:17 AM</span></font></st1:time><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'><br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
Mapserver-users@lists.gis.umn.edu<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> =
[Mapserver-users] PLEASE
HELP...<br>
<b><span style=3D'font-weight:bold'>Importance:</span></b> =
High</span></font><o:p></o:p></p>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>I have not been able to get =
a
response on how to display data using Mapserver from =
Oracle.<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:1.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'margin-left:1.0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>I have created a connection =
to my
Oracle db and I do not get any errors.<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:1.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'margin-left:1.0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>However, the data does not =
display.<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:1.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'margin-left:1.0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>I was told that I can't do =
this
direct connection to Oracle and that I have to use =
OGR.<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:1.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'margin-left:1.0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>Can someone please confirm =
this and
give me any help on how to simply display data from my Oracle database =
using
Mapserver?<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:1.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'margin-left:1.0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>Any help would be GREATLY =
appreciated.<o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:1.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'margin-left:1.0in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>Cheers,<o:p></o:p></span></f=
ont></p>
<p class=3DMsoNormal style=3D'margin-left:1.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'margin-left:1.0in'><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 style=3D'margin-left:1.0in'><em><b><i><font =
size=3D3
color=3Dgreen face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:green;
font-weight:bold;mso-no-proof:yes'>Sierra =
Systems</span></font></i></b></em><b><font
color=3Dgreen><span =
style=3D'color:green;font-weight:bold;mso-no-proof:yes'><br>
</span></font></b><st1:Street><st1:address><font size=3D2 =
color=3Dnavy><span
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'>130 Slater
Street, Suite 800</span></font></st1:address></st1:Street><font
color=3Dnavy><span style=3D'color:navy;mso-no-proof:yes'><br>
</span></font><st1:place><st1:City><font size=3D2 color=3Dnavy><span
=
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'>Ottawa</span></fon=
t></st1:City><font
size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'>,
</span></font><st1:State><font size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;
color:navy;mso-no-proof:yes'>Ontario</span></font></st1:State><font =
size=3D2
color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'> =
</span></font><st1:PostalCode><font
size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:yes'>K1P
6E2</span></font></st1:PostalCode></st1:place><font color=3Dnavy><span
style=3D'color:navy;mso-no-proof:yes'><br>
</span></font><font size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;
mso-no-proof:yes'>Phone: 613.236.7888, Extension: 350</span></font><font
size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy'><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D2 =
color=3Dnavy
face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt;color:navy;mso-no-proof:
yes'>Fax: 613.236.9333</span></font><font color=3Dnavy><span =
style=3D'color:navy;
mso-no-proof:yes'><br>
</span></font><font size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;
mso-no-proof:yes'>Email: =
RichardBecher@SierraSystems.com</span></font><font
color=3Dnavy><span style=3D'color:navy;mso-no-proof:yes'><br>
</span></font><font size=3D2 color=3Dnavy><span =
style=3D'font-size:10.0pt;color:navy;
mso-no-proof:yes'><a =
href=3D"http://www.sierrasystems.com/">www.SierraSystems.com</a></span></=
font><span
style=3D'mso-no-proof:yes'><o:p></o:p></span></p>
<p class=3DMsoAutoSig style=3D'margin-left:1.0in'><font size=3D3
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;mso-no-proof:yes'><o:p> </o:p></span></fon=
t></p>
<p class=3DMsoNormal style=3D'margin-left:1.0in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p>
</blockquote>
</blockquote>
</div>
</body>
</html>
=00
------_=_NextPart_001_01C3208B.81A25810--
_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users