[Geomoose-users] zoomto.php with PostGIS?

[Paul Senne]

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:

..../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.

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.

..../moose/php/zoomto.php?map=/web/gis/geomoose/1.6/data/itemquery.map&qstring=Hennepin&qitem=COUNTYNAME

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.
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:

                                DATA "the_geom from cty2000 using unique gid"

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.

Has anyone successfully used PostGIS with the zoomto.php?  If so, any help would be appreciated?

Thanks.

Paul Senne
GIS Specialist
Legislative Coordinating Commission
100 Rev. Dr. Martin Luther King Jr. Blvd. Ste 54
651.296.3924

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20081024/c41573ba/attachment.html