<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4943.400" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=891521321-27042005><FONT face=Arial color=#0000ff size=2>As an
update, this is the OVF file that I was using:</FONT></SPAN></DIV>
<DIV><SPAN class=891521321-27042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=891521321-27042005><FONT face=Arial color=#0000ff
size=2><OGRVRTDataSource><BR> <OGRVRTLayer
name="facilities"><BR>
<SrcDataSource>ODBC:myname/mypass@mydsn</SrcDataSource><BR>
<SrcSQL>SELECT FClass, UTMX, UTMY, NameShort FROM tlkpDestFac WHERE FClass
=
1</SrcSQL><BR> <LayerSRS>epsg:32615</LayerSRS></FONT></SPAN></DIV>
<DIV><SPAN class=891521321-27042005><FONT face=Arial color=#0000ff
size=2>
<GeometryType>wkbPoint</GeometryType><BR>
<GeometryField encoding="pointFromColumns" x="UTMX"
y="UTMY"/><BR>
</OGRVRTLayer><BR></OGRVRTDataSource></FONT></SPAN></DIV>
<DIV><SPAN class=891521321-27042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=891521321-27042005><FONT face=Arial color=#0000ff size=2>After
removing the line </FONT></SPAN></DIV>
<DIV><SPAN class=891521321-27042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=891521321-27042005><FONT face=Arial color=#0000ff
size=2><LayerSRS>epsg:32615</LayerSRS></FONT></SPAN></DIV>
<DIV><SPAN class=891521321-27042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=891521321-27042005><FONT face=Arial color=#0000ff size=2>It
works. Fortunately, for this application, I don't need to project the
data. </FONT></SPAN></DIV>
<DIV><SPAN class=891521321-27042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=891521321-27042005><FONT face=Arial color=#0000ff
size=2>David.</FONT></SPAN></DIV>
<P><FONT face=Arial size=2>David Fawcett</FONT> <BR><FONT face=Arial
size=2>Minnesota Office of Environmental Assistance</FONT> <BR><FONT face=Arial
size=2>david.fawcett@moea.state.mn.us</FONT> <BR><FONT face=Arial
size=2>651.215.0200</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> UMN MapServer Users List
[mailto:MAPSERVER-USERS@LISTS.UMN.EDU]<B>On Behalf Of </B>Fawcett,
David<BR><B>Sent:</B> Wednesday, April 27, 2005 4:00 PM<BR><B>To:</B>
MAPSERVER-USERS@LISTS.UMN.EDU<BR><B>Subject:</B> [UMN_MAPSERVER-USERS] SQL
WHERE in OGR VRT<BR><BR></FONT></DIV>
<DIV><SPAN class=656184920-27042005><FONT face=Arial color=#0000ff size=2>What
is the lowest MapServer Version where SQL WHERE is supported in ORG
VRT's? </FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=656184920-27042005><FONT face=Arial color=#0000ff size=2>I am
playing with a virtual layer that connects to an Access database using
OGR. The layer works great when I use
<SrcLayer>tlkpDestFac</SrcLayer> and call up all of the elements
in the file. </FONT></SPAN></DIV>
<DIV><SPAN class=656184920-27042005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=656184920-27042005><FONT face=Arial color=#0000ff size=2>I
attempted to filter the layer by using <SrcSQL>SELECT FClass, UTMX,
UTMY, NameShort FROM tlkpDestFac WHERE FClass = 1</SrcSQL> in
place of <SrcLayer> . Using the MapServer 4.4.1 binary
from MapTools, I get the error '<FONT face="Times New Roman"
color=#000000 size=3> msDrawMap(): Image handling error. Failed to draw layer
named 'facilities'. <BR>msOGRFileOpen(): OGR error. Open failed for OGR
connection `facslf.ovf'. Failed to import LayerSRS
`epsg:32615'. ' </FONT></FONT></SPAN></DIV>
<DIV><SPAN class=656184920-27042005></SPAN> </DIV>
<DIV><SPAN class=656184920-27042005>If I hit the same .ovf file with
ogrinfo 1.2.5+ in the FW Tools package, it is read just
fine. </SPAN></DIV>
<DIV><SPAN class=656184920-27042005></SPAN> </DIV>
<DIV><SPAN class=656184920-27042005>Thanks, </SPAN></DIV>
<DIV><SPAN class=656184920-27042005></SPAN> </DIV>
<DIV><SPAN class=656184920-27042005>David. </SPAN></DIV>
<P><FONT face=Arial size=2>David Fawcett</FONT> <BR><FONT face=Arial
size=2>Minnesota Office of Environmental Assistance</FONT> <BR><FONT
face=Arial size=2>david.fawcett@moea.state.mn.us</FONT> <BR><FONT face=Arial
size=2>651.215.0200</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Tahoma
size=2></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>