<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
All,
<div class=""><br class="">
</div>
<div class="">I have a mechanism to build these for each day of the week:</div>
<div class=""><br class="">
</div>
<div class=""><a href="https://www.dropbox.com/s/4hg38jqg0jd9otg/Wed.webm?dl=0" class="">https://www.dropbox.com/s/4hg38jqg0jd9otg/Wed.webm?dl=0</a></div>
<div class=""><br class="">
</div>
<div class="">This is out Public Works fleet GPS trails for the day.</div>
<div class=""><br class="">
</div>
<div class="">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.</div>
<div class=""><br class="">
</div>
<div class="">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?</div>
<div class=""><br class="">
</div>
<div class="">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.</div>
<div class=""><br class="">
</div>
<div class="">Thoughts?</div>
<div class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class="">
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<br class="Apple-interchange-newline">
<br class="">
</div>
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<div class="wp_quotepage_quote">The trouble with the rat race is that even if you win, you’re still a rat.</div>
<div class="wp_quotepage_author">—Lily Tomlin</div>
</div>
</div>
<br class="">
</div>
</body>
</html>