[mapserver-users] Over-riding the extents based on SQL query.

[Lime, Steve D (MNIT)]

Bob: See the “single image mapfile” thread for an example of how this might be done with a combination of query and map requests chained together. --Steve

From: mapserver-users [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Basques, Bob (CI-StPaul)
Sent: Tuesday, October 11, 2016 1:28 PM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] Over-riding the extents based on SQL query.

All,

I have a mechanism to build these for each day of the week:

https://www.dropbox.com/s/4hg38jqg0jd9otg/Wed.webm?dl=0

This is out Public Works fleet GPS trails for the day.

I build them by generating a single image each minute, and then assemble them into a video each night.  The extents is currently hardcoded into query.

If you notice at the 25 and 37 sec marks into the video that a trail goes off screen (out of the City limits) to the north and back again.  I want to be able to expand the view to include those trails that go outside of the predefined City limits and then shrink the extents back again when they come back into the City.  I can write the Query easy enough with a CASE statement and use the same predefined EXTENT, but how do I make the SQL be the primary mechanism for defining the EXTENTS of the image returned, I guess this is related to a “zoom-to" function of sorts?

I think I may need to do this as a middle step (with a wrapper) in each images creation.  I’m just looking for a way to run this with a MAPFILE only if possible.

Thoughts?

bobb



The trouble with the rat race is that even if you win, you’re still a rat.
—Lily Tomlin

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