<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt"><div>I'm starting to think this might be a problem with PHP Mapscript. I'm going to have to try and setup a postgis db on my test machine and see if I can recreate the problem.<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> Dan Little <danlittle@yahoo.com>; "geomoose-users@lists.sourceforge.net" <geomoose-users@lists.sourceforge.net><br><b><span style="font-weight: bold;">Sent:</span></b> Friday, October 24, 2008 3:54:55 PM<br><b><span style="font-weight: bold;">Subject:</span></b> RE:
[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;}
span.EmailStyle18
{font-family:"Calibri", "sans-serif";color:#1F497D;}
.MsoChpDefault
{font-size:10.0pt;}
_filtered {margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">“COUNTYNAME” is the
column name in the shapefile provided with geomoose and when I get zoomto.php
to work with the shapefile that is the qitem I use. </span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">My postgis county layer’s
column for the county name is ‘name’ all lowercase, which is what
use when I call my PostGIS data. So instead of the qstring/qitem used for
shapefile for PostGIS it is:</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal">…./moose/php/zoomto.php?map=/web/gis/geomoose/1.6/data/itemquery.map&qstring=Hennepin&qitem=name</p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">My qstring (i.e. Hennepin) is
also matching the case and spelling of ‘Hennepin’ in the PostGIS
column ‘name’. Other ideas?</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p>
<div>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: rgb(31, 73, 125);">Paul Senne</span></p>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: rgb(31, 73, 125);">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"; color: rgb(31, 73, 125);"></span></p>
</div>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">From:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";"> Dan Little
[mailto:danlittle@yahoo.com] <br>
<b>Sent:</b> Friday, October 24, 2008 3:41 PM<br>
<b>To:</b> Paul Senne; geomoose-users@lists.sourceforge.net<br>
<b>Subject:</b> Re: [Geomoose-users] zoomto.php with PostGIS?</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<div>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Arial","sans-serif";">Try
changing "COUNTYNAME" to the lowercase, "countyname".</span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Arial","sans-serif";"> </span></p>
<div>
<div class="MsoNormal" style="text-align: center;" align="center"><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">
<hr align="center" size="1" width="100%">
</span></div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">From:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";"> Paul Senne <paul.senne@gis.leg.mn><br>
<b>To:</b> "geomoose-users@lists.sourceforge.net"
<geomoose-users@lists.sourceforge.net><br>
<b>Sent:</b> Friday, October 24, 2008 12:30:38 PM<br>
<b>Subject:</b> [Geomoose-users] zoomto.php with PostGIS?</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
<div>
<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></p>
<p class="MsoNormal"> </p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
</div>
</div></div></div><br>
</body></html>