[mapserver-users] Zoom to something and display in one shot from MapServer CGI.

[Lime, Steve D (MNIT)]

I should say that I’m assuming you’re using version 7.0, that’s where the filter normalization work was done so that you could execute the same filter (item queries are just dynamic filters) against any data source.

Oh, and your last question, your URL template can use whatever protocol you want. All you’re doing is seeding it with feature properties – an extent, centroid and/or attributes…

Steve

From: mapserver-users [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Lime, Steve D (MNIT)
Sent: Friday, July 14, 2017 11:16 AM
To: Basques, Bob (CI-StPaul) <bob.basques at ci.stpaul.mn.us<mailto:bob.basques at ci.stpaul.mn.us>>
Cc: mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>
Subject: Re: [mapserver-users] Zoom to something and display in one shot from MapServer CGI.

You don’t need to do runtime substitution with an itemquery, MapServer will extend the where clause automatically. You data statement just needs to look like:

  DATA "wkb_geometry from (select objectid, parcelid, wkb_geometry from cache.rc_parcel_poly) as subquery using unique objectid srid=200068"

Steve

From: Basques, Bob (CI-StPaul) [mailto:bob.basques at ci.stpaul.mn.us]
Sent: Thursday, July 13, 2017 10:24 AM
To: Lime, Steve D (MNIT) <steve.lime at state.mn.us<mailto:steve.lime at state.mn.us>>
Cc: Stephen Woodbridge <woodbri at swoodbridge.com<mailto:woodbri at swoodbridge.com>>; mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>
Subject: Re: [mapserver-users] Zoom to something and display in one shot from MapServer CGI.

Working on this, but not quite there yet . . .

My initial request looks like:

http://gis.ci.stpaul.mn.us/datasets/PUBLIC/LAND_OWNERSHIP/PARCELS/rc_parcels_assessment.map?
    mode=itemquery&
    qlayer=Parcels-Map-Query&
    qitem=parcelid&qstring=162823340026&
    WIDTH=1069&HEIGHT=917

I get a “no matching records” found . . . and with DEBUG 5 on the query layer . . .

    CONNECTIONTYPE PostGIS
        CONNECTION “host=localhost dbname=postgres user=mapserv password=****”

        DATA "wkb_geometry from (
            select objectid, parcelid, wkb_geometry from cache.rc_parcel_poly where parcelid = '%pin%' or parcelid = '%qstring%') as subquery using unique objectid srid=200068"

        VALIDATION
                'pin' '^[0-9]{12}$'
            'qstring' '^[0-9]{12}$'
          END

… log entries removed for brevity…

The subquery works fine from sql and returns a single record.  One thing I noticed, is that the POLYGON BBOX is way off to the west a few thousand feet.  There is no default image size in the Mapfile either so I don’t know where that number is coming from other than shpext . . . are there other parameters that need to be added to the shpext call?

the TEMPLATE link looks like:

    TEMPLATE 'http://gis.ci.stpaul.mn.us/datasets/PUBLIC/LAND_OWNERSHIP/PARCELS/rc_parcels_assessment.map?pin=162823340026&FORMAT=image%2Fpng&TRANSPARENT=TRUE&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&LAYERS=all&_OLSALT=0.7873164216111053&SRS=EPSG%3A200068&BBOX=[shpext<http://gis.ci.stpaul.mn.us/datasets/PUBLIC/LAND_OWNERSHIP/PARCELS/rc_parcels_assessment.map?pin=162823340026&FORMAT=image%2Fpng&TRANSPARENT=TRUE&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&LAYERS=all&_OLSALT=0.7873164216111053&SRS=EPSG%3A200068&BBOX=%5bshpext> format="$minx,$miny,$maxx,$maxy"]&WIDTH=1069&HEIGHT=917'

This will (should) return an image, should it be some sort of text return instead?  I’m trying to keep it WMS too . . . is this still doable??

bobb
On Jul 12, 2017, at 10:41 AM, Lime, Steve D (MNIT) <Steve.Lime at state.mn.us<mailto:Steve.Lime at state.mn.us>> wrote:

The shpext tag can re-project, format and buffer a shapes extent if that helps.

From: Basques, Bob (CI-StPaul) [mailto:bob.basques at ci.stpaul.mn.us]
Sent: Wednesday, July 12, 2017 8:37 AM
To: Lime, Steve D (MNIT) <steve.lime at state.mn.us<mailto:steve.lime at state.mn.us>>
Cc: Stephen Woodbridge <woodbri at swoodbridge.com<mailto:woodbri at swoodbridge.com>>; mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>
Subject: Re: [mapserver-users] Fwd: Zoom to something and display in one shot from MapServer CGI.

Steve (L),

That’s really close to what I was looking for.  I vaguely remembered something going on enhancement wise, related to URL requests inside of a MapServer request.

I’ll try this out and get back here with the results.

bobb




"I like nonsense; it wakes up the brain cells."
- Dr. Seuss




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20170714/c6229dff/attachment-0001.html>