is there another projection in play at the top of the map file?<br><br><div class="gmail_quote">On Thu, Feb 23, 2012 at 7:08 AM, Bistrais, Bob <span dir="ltr"><<a href="mailto:Bob.Bistrais@maine.gov">Bob.Bistrais@maine.gov</a>></span> wrote:<br>
<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div link="blue" vlink="blue" lang="EN-US">
<div>
<p class="MsoNormal"><font color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">I think that might be the problem.
Having trouble deciphering this one. I added a getExtent and printed it
to screen. Here’s what it’s showing for my extent, not what I
was expecting to see:<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 face="Times New Roman" size="3"><span style="font-size:12.0pt">ms_rect_obj Object ( [_handle_] => Resource id #40 [minx] =>
-3.40282346639E+38 [miny] => -3.40282346639E+38 [maxx] =>
3.40282346639E+38 [maxy] => 3.40282346639E+38 )<u></u><u></u></span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"><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">…First of all, not cords that I’m
used to seeing, second, they are all the same value, maybe indicating a point
location, but I attempted to select a polygon.<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">We should be in EPSG: 26919. Looking
on the database side, that appears to be correct, and in the map file for that
layer, we are also using SRID=26919.<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">Does this make sense?</span></font><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"><u></u> <u></u></span></font></p>
<div>
<div class="MsoNormal" style="text-align:center" align="center"><font face="Times New Roman" size="3"><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"> TC Haddad
[mailto:<a href="mailto:tchaddad@gmail.com" target="_blank">tchaddad@gmail.com</a>] <br>
<b><span style="font-weight:bold">Sent:</span></b> Wednesday, February 22, 2012
3:51 PM<br>
<b><span style="font-weight:bold">To:</span></b> Bistrais, Bob<br>
<b><span style="font-weight:bold">Cc:</span></b> <u></u><a href="mailto:Geomoose-users@lists.osgeo.org" target="_blank">Geomoose-users@lists.osgeo.org</a><u></u><br>
<b><span style="font-weight:bold">Subject:</span></b> Re: [Geomoose-users] RE:
query service with PostGis layer</span></font><u></u><u></u></p>
</div><div><div class="h5">
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">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<u></u><u></u></span></font></p>
<div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">On Wed, Feb 22, 2012 at 12:43 PM, Bistrais, Bob <<a href="mailto:Bob.Bistrais@maine.gov" target="_blank">Bob.Bistrais@maine.gov</a>> wrote:<u></u><u></u></span></font></p>
<div link="blue" vlink="purple">
<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:</span></font><u></u><u></u></p>
<p class="MsoNormal"><font color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><u></u><u></u></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)</span></font><u></u><u></u></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.</span></font><u></u><u></u></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</span></font><u></u><u></u></p>
<p class="MsoNormal"><font color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><u></u><u></u></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.</span></font><u></u><u></u></p>
<p class="MsoNormal"><font color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy"> </span></font><u></u><u></u></p>
<div>
<div class="MsoNormal" style="text-align:center" align="center"><font face="Times New Roman" size="3"><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>
<p class="MsoNormal"><font face="Times New Roman" size="3"><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.</span></font><u></u><u></u></p>
<p class="MsoNormal"><font face="Arial"><span style="font-size:10.0pt;font-family:Arial"> </span></font><u></u><u></u></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:</span></font><u></u><u></u></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">geo_lot =
'11190_010-011'<u></u><u></u></span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"> <u></u><u></u></span></font></p>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt">Does this look
right? What else could I check for?<u></u><u></u></span></font></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"><br>
_______________________________________________<br>
Geomoose-users mailing list<br>
<a href="mailto:Geomoose-users@lists.osgeo.org" target="_blank">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><u></u><u></u></span></font></p>
</div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:12.0pt"><u></u> <u></u></span></font></p>
</div></div></div>
</div>
</blockquote></div><br>