<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt"><div>Try changing "COUNTYNAME" to the lowercase, "countyname".<br></div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Paul Senne <paul.senne@gis.leg.mn><br><b><span style="font-weight: bold;">To:</span></b> "geomoose-users@lists.sourceforge.net" <geomoose-users@lists.sourceforge.net><br><b><span style="font-weight: bold;">Sent:</span></b> Friday, October 24, 2008 12:30:38 PM<br><b><span style="font-weight: bold;">Subject:</span></b> [Geomoose-users] zoomto.php with PostGIS?<br></font><br>
<style>
<!--
_filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
span.EmailStyle17
{font-family:"Calibri", "sans-serif";color:windowtext;}
.MsoChpDefault
{}
_filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{}
-->
</style>
<div class="Section1">
<p class="MsoNormal">I’m setting up a geomoose page that we will want to
link to specific areas of a feature layer such as a specific county and have
geomoose zoom directly to those when a user follows said link. I set up
the service and call it with the qitem and the qstring in the URL as follows:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">…./moose/geomoose.html?call=zoom&qstring=Hennepin&qitem=COUNTYNAME
where ‘COUNTYNAME’ is the table column, ‘Hennepin’ is
the county from the table I want to zoom to and ‘zoom’ is the name I
gave the service. When using a shapefile, this works flawlessly.
However, when using POSTGIS and adjusting the qstring an qitem to match (case
included) the POSTGIS setup, I get nothing.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Looking at the url geomoose is calling to retrieve the
bounding coordinates for the zoom extent, I can narrow down the problem
specifically to the DATA source in my itemquery.map mapfile. Geomoose calls
the following url for the coordinates from the zoomto.php script.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">…./moose/php/zoomto.php?map=/web/gis/geomoose/1.6/data/itemquery.map&qstring=Hennepin&qitem=COUNTYNAME</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Using shapefile, this spits out the coordinates geomoose
needs. Switching my itemquery.map layer to PostGIS instead of shapefile yields
a response with no information or error.</p>
<p class="MsoNormal">My PostGIS data layer is drawing fine and I have identify
working just fine with it. My PostGIS DATA line in the mapfiles (‘layername’.map,
identify.map & itemquery.map) are all the same:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> DATA
"the_geom from cty2000 using unique gid"</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">If my PostGIS line is altered (incorrectly), I receive an
error rather than a blank response which leads me to believe that PostGIS is
not giving the zoomto.php script what it needs to spit out coordinates. </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Has anyone successfully used PostGIS with the zoomto.php?
If so, any help would be appreciated?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">Paul
Senne</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">GIS
Specialist<br>
Legislative Coordinating Commission<br>
100 Rev. Dr. Martin Luther King Jr. Blvd. Ste 54<br>
651.296.3924</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
<p class="MsoNormal"> </p>
</div>
</div></div></div><br>
</body></html>