[Mapserver-users] PLEASE HELP...

Smith, Michael ERDC-CRREL-NH Michael.Smith@erdc.usace.army.mil
Thu, 22 May 2003 13:09:31 -0400 

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_01C32084.E8DC9D10
Content-Type: text/plain

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@erdc.usace.army.mil 
RSGISC 
ERDC - CRREL 
Hanover, NH  03755 
(603) 646-4765 
-----Original Message-----
From: Becher, Richard [mailto:RichardBecher@SierraSystems.com] 
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!
 
However, I have done all that you mentioned.  
 
Here is the entry in my map file:
 
CONNECTIONTYPE oraclespatial
CONNECTION 'user/password@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@erdc.usace.army.mil] 
Sent: Thursday, May 22, 2003 11:17 AM
To: Becher, Richard; Mapserver-users@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@tnsname' <mailto:'user/password@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@erdc.usace.army.mil 
RSGISC 
ERDC - CRREL 
Hanover, NH  03755 
(603) 646-4765 
-----Original Message-----
From: Becher, Richard [mailto:RichardBecher@SierraSystems.com] 
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.
 
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@SierraSystems.com
www.SierraSystems.com <http://www.sierrasystems.com/> 
 
 

------_=_NextPart_001_01C32084.E8DC9D10
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: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@01C32061.9D56BDD0" =
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"
}
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.EmailStyle21 {
	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
}
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=3D763570317-22052003><FONT face=3DArial =
color=3D#0000ff size=3D2>Are=20
you sure that the locations are correct in the sdo_geometry? e.g. are =
the lat=20
longs correct. </FONT></SPAN></DIV>
<DIV><SPAN class=3D763570317-22052003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D763570317-22052003><FONT face=3DArial =
color=3D#0000ff size=3D2>1. do=20
a select * from crhp_spatial where rownum=3D1, look at the coords and=20
verify</FONT></SPAN></DIV>
<DIV><SPAN class=3D763570317-22052003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D763570317-22052003><FONT face=3DArial =
color=3D#0000ff size=3D2>2. Is=20
there a projection defined for the layer and map.</FONT></SPAN></DIV>
<DIV><SPAN class=3D763570317-22052003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D763570317-22052003><FONT face=3DArial =
color=3D#0000ff size=3D2>3.=20
Make sure there is a class defined for the layer.</FONT></SPAN></DIV>
<DIV><SPAN class=3D763570317-22052003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D763570317-22052003><FONT face=3DArial =
color=3D#0000ff size=3D2>4. If=20
you are using 3.7(4.0), add a log parameter to your web section and put =
debug as=20
a line in your map layer.</FONT></SPAN></DIV>
<DIV><SPAN class=3D763570317-22052003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D763570317-22052003><FONT face=3DArial =
color=3D#0000ff size=3D2>Hope=20
this helps</FONT></SPAN></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<P><FONT face=3DArial size=3D1>Mike Smith</FONT> <BR><FONT face=3DArial =
size=3D1>email:=20
michael.smith@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&nbsp; 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@SierraSystems.com] <BR><B>Sent:</B> Thursday, =
May 22,=20
  2003 12:57 PM<BR><B>To:</B> Smith, Michael ERDC-CRREL-NH;=20
  Mapserver-users@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">Thanks for =
your=20
  reply!<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>&nbsp;</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">However, I =
have done=20
  all that you mentioned.<SPAN style=3D"mso-spacerun: yes">&nbsp;=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"><o:p>&nbsp;</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 entry in=20
  my map file:<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>&nbsp;</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'">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'">CONNECTION =
'user/<SPAN=20
  class=3DSpellE>password@db</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'">DATA "<SPAN=20
  class=3DSpellE>LatLongPoint</SPAN> from=20
  CRHP_SPATIAL"<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>&nbsp;</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'">There is =
definitely data=20
  in the table.<SPAN style=3D"mso-spacerun: yes">&nbsp; </SPAN>Like I =
said there=20
  are no errors but</SPAN></FONT><FONT face=3DArial color=3Dnavy =
size=3D2><SPAN=20
  style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> =
</SPAN></FONT><FONT=20
  face=3D"Courier New" size=3D2><SPAN=20
  style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">the data does =
not display=20
  on my map.<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>&nbsp;</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'">I am retrieving =
the whole=20
  table just to see if I can display anything right=20
  now.<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>&nbsp;</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'">Any other ideas =
as to why=20
  my data won't display?<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>&nbsp;</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'">Cheers,<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>&nbsp;</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'">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>&nbsp;</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@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"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@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>&nbsp;</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">Richard,=20
  </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">&nbsp;<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=20
  style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Mapserver =
needs to be=20
  compiled with the oracle libraries</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">&nbsp;<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">i.e.=20
  --with-oraclespatial =3D =
/path/to/oracle/home</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">&nbsp;<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">Then, in=20
  the map file use </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">&nbsp;<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=20
  style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">&nbsp;CONNECTIONTYPE=20
  oraclespatial<BR>&nbsp;CONNECTION '<A=20
  =
href=3D"mailto:'user/password@tnsname'">user/password@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: 0.5in"><FONT face=3D"Times =
New Roman"=20
  size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">&nbsp;<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">I've=20
  also found that if you use this format for the DATA line, that =
mapserver will=20
  only select data with the extents of you map view, if you use =
'sdo_geom_col=20
  from (select * from tablename)' which is also valid, on every redraw =
you will=20
  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: 0.5in"><FONT face=3D"Times =
New Roman"=20
  size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">&nbsp;<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">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: 0.5in"><FONT face=3D"Times =
New Roman"=20
  size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">&nbsp;<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">Another=20
  importtant point is to increase the ARRAY_SIZE in the =
maporaclespatial.c code.=20
  By 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: 0.5in"><FONT face=3D"Times =
New Roman"=20
  size=3D3><SPAN style=3D"FONT-SIZE: =
12pt">&nbsp;<o:p></o:p></SPAN></FONT></P></DIV>
  <DIV>
  <P class=3DMsoNormal 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@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&nbsp;=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 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@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@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: 0.5in"><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: 0.5in"><FONT =
face=3DArial size=3D2><SPAN=20
    style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><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: 0.5in"><FONT =
face=3DArial size=3D2><SPAN=20
    style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><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: 0.5in"><FONT =
face=3DArial size=3D2><SPAN=20
    style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3DArial size=3D2><SPAN=20
    style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I was told that I =
can't do this=20
    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: 0.5in"><FONT =
face=3DArial size=3D2><SPAN=20
    style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3DArial size=3D2><SPAN=20
    style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Can someone please =
confirm this=20
    and give me any help on how to simply display data from my Oracle =
database=20
    using Mapserver?<o:p></o:p></SPAN></FONT></P>
    <P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3DArial size=3D2><SPAN=20
    style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><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: 0.5in"><FONT =
face=3DArial size=3D2><SPAN=20
    style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><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: 0.5in"><FONT =
face=3DArial size=3D2><SPAN=20
    style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><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: 0.5in"><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,&nbsp;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 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: 0.5in"><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 style=3D"FONT-SIZE: 10pt; COLOR: navy; mso-no-proof: =
yes">Email:=20
    RichardBecher@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: 0.5in"><FONT =
face=3D"Times New Roman"=20
    size=3D3><SPAN=20
    style=3D"FONT-SIZE: 12pt; mso-no-proof: =
yes"><o:p>&nbsp;</o:p></SPAN></FONT></P>
    <P class=3DMsoNormal style=3D"MARGIN-LEFT: 0.5in"><FONT =
face=3D"Times New Roman"=20
    size=3D3><SPAN=20
  style=3D"FONT-SIZE: =
12pt"><o:p>&nbsp;</o:p></SPAN></FONT></P></BLOCKQUOTE></DIV></BLOCKQUOTE=
></BODY></HTML>

------_=_NextPart_001_01C32084.E8DC9D10--
_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users