The second error is probably the reason<br><br>is it possible that when you imported the shapefile into PostGIS that PostGIS was unaware of the projection? because if it is a different projection than your overall map, then the BBOX being passed is likely not picking up any records (because PostGIS doesn't know what space it is in).<br>
<br>Tanya<br><br><div class="gmail_quote">On Wed, Feb 22, 2012 at 12:43 PM, Bistrais, Bob <span dir="ltr"><<a href="mailto:Bob.Bistrais@maine.gov">Bob.Bistrais@maine.gov</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><font color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">A few more details on this- here’s
what I found on the error log:<u></u><u></u></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">[Wed Feb 22 15:42:<a href="tel:11%202012%5D.984000" value="+12012984000" target="_blank">11 2012].984000</a>
getSymbol(): Symbol definition error. Parsing error near (geo_lot):(line 266)<u></u><u></u></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">[Wed Feb 22 15:42:12 <a href="tel:2012%5D.140000" value="+12012140000" target="_blank">2012].140000</a>
msQueryByRect(): Search returned no results. No matching record(s) found.<u></u><u></u></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">[Wed Feb 22 15:42:12 <a href="tel:2012%5D.500000" value="+12012500000" target="_blank">2012].500000</a>
msDrawMap(): Layer 0 (parcelspostgis), 0.344s<u></u><u></u></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">-But I don’t know why it isn’t
returning any results, when a corresponding shapefile of the same data will.<u></u><u></u></span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"><u></u> <u></u></span></font></p>
<div>
<div class="MsoNormal" style="text-align:center" align="center"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">
<hr size="2" width="100%" align="center">
</span></font></div>
<p class="MsoNormal"><b><font face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma;font-weight:bold">From:</span></font></b><font face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma"> Bistrais, Bob <br>
<b><span style="font-weight:bold">Sent:</span></b> Tuesday, February 21, 2012
4:25 PM<br>
<b><span style="font-weight:bold">To:</span></b> <a href="mailto:Geomoose-users@lists.osgeo.org" target="_blank">Geomoose-users@lists.osgeo.org</a><br>
<b><span style="font-weight:bold">Subject:</span></b> query service with
PostGis layer</span></font><u></u><u></u></p>
</div><div><div class="h5">
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font face="Arial"><span style="font-size:10.0pt;font-family:Arial">Now that I’ve gotten some PostGIS layers to display in
GeoMoose, the next thing I’m trying to do is work with attribute
queries. I am attempting this through query services and using
query_custom.php.<u></u><u></u></span></font></p>
<p class="MsoNormal"><font face="Arial"><span style="font-size:10.0pt;font-family:Arial"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font face="Arial"><span style="font-size:10.0pt;font-family:Arial">So far, I am getting 0 results, when the same query would
have worked with a shapefile. I’m thinking it’s a format
issue, maybe some quotes or something out of place? Here is an echo of my
query string:<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">geo_lot = '11190_010-011'<u></u><u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt">Does this look right? What else could I check for?</span></font><font face="Arial"><span style="font-size:10.0pt;font-family:Arial"><u></u><u></u></span></font></p>
</div></div></div>
</div>
<br>_______________________________________________<br>
Geomoose-users mailing list<br>
<a href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/geomoose-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a><br>
<br></blockquote></div><br>