<br><div class="gmail_extra">Thanks Bob - I did not realize I could substitute the table name. That solves the problem.</div><div class="gmail_extra"><br></div><div class="gmail_extra">I'm using SELECT ST_Extent(geom) FROM mytable to get the bounding box using PostGIS, and then using the results from that with MAPEXT.</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">-David<br><br><div class="gmail_quote">On Tue, Oct 30, 2012 at 2:44 PM, Basques, Bob (CI-StPaul) <span dir="ltr"><<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.mn.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif">You can use something like this in the LAYER block for the POSTGIS connection:<u></u><u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><u></u> <u></u></span></p>
<p class="" style="text-autospace:none"><span style="font-size:11pt;font-family:'Courier New'">DATA "the_geom FROM %YourTableName% USING SRID=200068"<u></u><u></u></span></p>
<p class="" style="text-autospace:none"><span style="font-size:11pt;font-family:'Courier New'"><u></u> <u></u></span></p>
<p class="" style="text-autospace:none"><span style="font-size:11pt;font-family:'Courier New'"> FILTER " acqtime > '%time_idx1%' AND acqtime <'%time_idx2%' "<u></u><u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><u></u> <u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><u></u> <u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif">The items surrounded with “%” are populated from the same named parameters in the calling Link.<u></u><u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><u></u> <u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><a href="http://Sitename/mapserver-cgi/mapfilename.map?time_idx1=BeginTimeValue&time_idx2=EndTimeValue&YourTableName=Your_table" target="_blank">http://Sitename/mapserver-cgi/mapfilename.map?time_idx1=BeginTimeValue&time_idx2=EndTimeValue&YourTableName=Your_table</a>
. . . .<u></u><u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><u></u> <u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif">more info is here:<u></u><u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><u></u> <u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><a href="http://mapserver.org/cgi/runsub.html" target="_blank">http://mapserver.org/cgi/runsub.html</a><u></u><u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><u></u> <u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif">bobb<u></u><u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><u></u> <u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><u></u> <u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><u></u> <u></u></span></p>
<p class=""><span style="font-size:8pt;font-family:'Comic Sans MS',serif"><u></u> <u></u></span></p>
<div style="border-style:none none none solid;border-left-width:1.5pt;border-left-color:blue;padding:0in 0in 0in 4pt">
<div>
<div style="border-style:solid none none;border-top-width:1pt;border-top-color:rgb(181,196,223);padding:3pt 0in 0in">
<p class=""><b><span style="font-size:10pt;font-family:Tahoma,sans-serif">From:</span></b><span style="font-size:10pt;font-family:Tahoma,sans-serif"> David Quinn [mailto:<a href="mailto:daithiquinn@gmail.com" target="_blank">daithiquinn@gmail.com</a>]
<br>
<b>Sent:</b> Tuesday, October 30, 2012 1:41 PM<br>
<b>To:</b> Basques, Bob (CI-StPaul)<br>
<b>Subject:</b> RE: [mapserver-users] Strategies for displaying a temporary Postgres table<u></u><u></u></span></p>
</div>
</div><div><div class="h5">
<p class=""><u></u> <u></u></p>
<p class="">I do know the table name beforehand - but how do I pass that (and the extents) in as a parameter?<u></u><u></u></p>
<p class="">-David<u></u><u></u></p>
<p class=""><u></u> <u></u></p>
<p class=""><u></u> <u></u></p>
<p class="">If you know the table name beforehand, you can pass that into the Mapfile as well as an additional parameter.<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class="">Bobb<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class=""><b>From:</b> David Quinn [mailto:<a href="mailto:daithiquinn@gmail.com" target="_blank">daithiquinn@gmail.com</a>]
<br>
<b>Sent:</b> Tuesday, October 30, 2012 1:33 PM<br>
<b>To:</b> Basques, Bob (CI-StPaul)<br>
<b>Subject:</b> Re: [mapserver-users] Strategies for displaying a temporary Postgres table<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class="">Bobb,<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class="">Sorry - I don't quite follow. How do I update the table name?<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class="">Thanks,<u></u><u></u></p>
<p class="">David<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class="">On Tue, Oct 30, 2012 at 2:30 PM, Basques, Bob (CI-StPaul) <<a href="mailto:bob.basques@ci.stpaul.mn.us" target="_blank">bob.basques@ci.stpaul.mn.us</a>> wrote:<u></u><u></u></p>
<p class="">David,<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class="">You can grab the extents from the MAPFILE call and insert them into the DATA call in the mapfile.<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class="">Bobb<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class=""><b>From:</b>
<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>David Quinn<br>
<b>Sent:</b> Tuesday, October 30, 2012 1:27 PM<br>
<b>To:</b> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<b>Subject:</b> [mapserver-users] Strategies for displaying a temporary Postgres table<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class="">Hi List,<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class="">I am exploring how to show the results of a pgRouting shortest path query. One suggestion is to create a temporary table ( <a href="http://download.osgeo.org/pgrouting/forum/pgrouting.postlbs.org/wiki/MapServer.html" target="_blank">http://download.osgeo.org/pgrouting/forum/pgrouting.postlbs.org/wiki/MapServer.html</a>
).<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class="">One way I thought of doing this is to write a mapfile using php with DATA supplied with the appropriate temporary table name and EXTENT with the extent of the table. I'm not sure
if this approach is a good practice, or whether I should be using a different method.<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
<p class="">Thanks,<u></u><u></u></p>
<p class="">David<u></u><u></u></p>
<p class=""> <u></u><u></u></p>
</div></div></div>
</div>
</div>
</blockquote></div><br></div>