<html>
<head>
</head>
<body class='hmmessage'><div dir='ltr'>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
<div dir="ltr">Hi there, <p>Ok I managed to get this outputted...but under the [name] and [type] I need to get these fields populated from the query of the mjrroads...<p> <table border="1">
<tbody><tr><th>ID</th><th>Name</th><th>Type</th></tr><!--<IMG src="http://localhost/cgi-bin/mapserv.exe?mode=INDEXQUERY&qformat=png24&qlayer=mjrroads&shapeindex=1164&shpext=-81.880943+42.990267+-81.627012+42.992695&mapext=shape&map=/wwwroot/M_Mirrlees_Assign3/global.map">--><tr><td>1164</td><td>[name]</td><td>[type]</td></tr></tbody>
</table><p> <p>Code from mjrroadsquery.html<p><!-- MapServer Template --><br><!--<IMG src="<a href="http://[host]/cgi-bin/mapserv.exe?mode=INDEXQUERY&qformat=png24&qlayer=mjrroads&shapeindex=[shpidx]&shpext=[shpext_esc]&mapext=shape&map=[map">http://[host]/cgi-bin/mapserv.exe?mode=INDEXQUERY&qformat=png24&qlayer=mjrroads&shapeindex=[shpidx]&shpext=[shpext_esc]&mapext=shape&map=[map</a>]">--><br><tr><br> <td>[shpidx]</td><br> <td>[name]</td><br> <td>[type]</td><br></tr><p> <p>Now if I change the [name] to [map] in the mjrroadsquery.html I get the following...<table border="1">
<tbody>
<tr>
<th>ID</th>
<th>Name</th>
<th>Type</th></tr><!--<IMG src="http://localhost/cgi-bin/mapserv.exe?mode=INDEXQUERY&qformat=png24&qlayer=mjrroads&shapeindex=1164&shpext=-81.880943+42.990267+-81.627012+42.992695&mapext=shape&map=/wwwroot/M_Mirrlees_Assign3/global.map">-->
<tr>
<td>1164</td>
<td>/wwwroot/M_Mirrlees_Assign3/global.map</td>
<td>[type]</td></tr></tbody></table><p> <p>Code from mjrroads.html<p> <p><!-- MapServer Template --><br><h3><b>Layer: Major Roads</b></h3><br><br><br><INPUT NAME="img" TYPE="image" SRC="[img]" width=500 height=500 border=0 ALT="Map Image"><br><table border=1><br><tr> </td><br> <th>ID</th><br> <th>Name</th><br> <th>Type</th><br></tr><p> <p>All i'm trying to do is get the Name and Type fields to be showing the name of the road, and the type of the road.<p> <p>Thanks,<p>Mark<br><BR><br> <br><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">From: Steve.Lime@state.mn.us<br>To: mmirrlees@hotmail.com; mapserver-users@lists.osgeo.org<br>Subject: RE: [mapserver-users] query creation issues<br>Date: Wed, 20 Mar 2013 18:41:52 +0000<br><br>
<style><!--
.ExternalClass .ecxshape
{;}
--></style><style><!--
.ExternalClass p.ecxMsoNormal, .ExternalClass li.ecxMsoNormal, .ExternalClass div.ecxMsoNormal
{font-size:12.0pt;font-family:"Times New Roman","serif";}
.ExternalClass a:link, .ExternalClass span.ecxMsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.ecxMsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass p
{font-size:12.0pt;font-family:"Times New Roman","serif";}
.ExternalClass p.ecxMsoAcetate, .ExternalClass li.ecxMsoAcetate, .ExternalClass div.ecxMsoAcetate
{font-size:8.0pt;font-family:"Tahoma","sans-serif";}
.ExternalClass p.ecxecxmsonormal, .ExternalClass li.ecxecxmsonormal, .ExternalClass div.ecxecxmsonormal
{font-size:12.0pt;font-family:"Times New Roman","serif";}
.ExternalClass p.ecxecxmsoacetate, .ExternalClass li.ecxecxmsoacetate, .ExternalClass div.ecxecxmsoacetate
{font-size:12.0pt;font-family:"Times New Roman","serif";}
.ExternalClass p.ecxecxmsochpdefault, .ExternalClass li.ecxecxmsochpdefault, .ExternalClass div.ecxecxmsochpdefault
{font-size:12.0pt;font-family:"Times New Roman","serif";}
.ExternalClass span.ecxecxmsohyperlink
{;}
.ExternalClass span.ecxecxmsohyperlinkfollowed
{;}
.ExternalClass span.ecxecxballoontextchar
{;}
.ExternalClass span.ecxecxemailstyle20
{;}
.ExternalClass p.ecxecxmsonormal1, .ExternalClass li.ecxecxmsonormal1, .ExternalClass div.ecxecxmsonormal1
{font-size:12.0pt;font-family:"Times New Roman","serif";}
.ExternalClass span.ecxecxmsohyperlink1
{color:blue;text-decoration:underline;}
.ExternalClass span.ecxecxmsohyperlinkfollowed1
{color:purple;text-decoration:underline;}
.ExternalClass p.ecxecxmsoacetate1, .ExternalClass li.ecxecxmsoacetate1, .ExternalClass div.ecxecxmsoacetate1
{font-size:8.0pt;font-family:"Tahoma","sans-serif";}
.ExternalClass span.ecxecxballoontextchar1
{font-family:"Tahoma","sans-serif";}
.ExternalClass span.ecxecxemailstyle201
{font-family:"Calibri","sans-serif";color:#1F497D;}
.ExternalClass p.ecxecxmsochpdefault1, .ExternalClass li.ecxecxmsochpdefault1, .ExternalClass div.ecxecxmsochpdefault1
{font-size:10.0pt;font-family:"Times New Roman","serif";}
.ExternalClass span.ecxBalloonTextChar
{font-family:"Tahoma","sans-serif";}
.ExternalClass span.ecxEmailStyle34
{font-family:"Calibri","sans-serif";color:#1F497D;}
.ExternalClass .ecxMsoChpDefault
{font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;}
.ExternalClass div.ecxWordSection1
{page:WordSection1;}
--></style>
<div class="ecxWordSection1">
<p class="ecxMsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>Straight item tags like that ARE case sensitive. Try [item name=”name”] and [item name=”type”] instead.</span></p>
<p class="ecxMsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'> </span></p>
<div>
<div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) currentColor currentColor; padding: 3pt 0in 0in;">
<p class="ecxMsoNormal"><b><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'>From:</span></b><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'> Mark Mirrlees [mailto:mmirrlees@hotmail.com]
<br>
<b>Sent:</b> Wednesday, March 20, 2013 1:33 PM<br>
<b>To:</b> Lime, Steve D (MNIT); mapserver-users@lists.osgeo.org<br>
<b>Subject:</b> RE: [mapserver-users] query creation issues</span></p>
</div>
</div>
<p class="ecxMsoNormal"> </p>
<div>
<p class="ecxMsoNormal"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'>Hi Steve,</span></p>
<p class="ecxMsoNormal"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'> </span></p>
<p class="ecxMsoNormal"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'>Unfortunately that didn't work! But I did manage to get the ID chracteristic outputted as I forgot to include that previously. As when I went to edit the query.html page it
shows this</span></p>
<p class="ecxMsoNormal"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'> </span></p>
<div>
<table class="ecxMsoNormalTable" border="1" cellPadding="0">
<tbody>
<tr>
<td style="padding: 0.75pt;">
<p style="text-align: center;" class="ecxMsoNormal" align="center"><b>ID</b></p>
</td>
<td style="padding: 0.75pt;">
<p style="text-align: center;" class="ecxMsoNormal" align="center"><b>Name</b></p>
</td>
<td style="padding: 0.75pt;">
<p style="text-align: center;" class="ecxMsoNormal" align="center"><b>Type</b></p>
</td>
</tr>
<tr>
<td style="padding: 0.75pt;">
<p class="ecxMsoNormal">1275</p>
</td>
<td style="padding: 0.75pt; border: currentColor;"></td>
<td style="padding: 0.75pt; border: currentColor;"></td>
</tr>
<tr>
<td style="padding: 0.75pt;">
<p class="ecxMsoNormal">[name]</p>
</td>
<td style="padding: 0.75pt; border: currentColor;"></td>
<td style="padding: 0.75pt; border: currentColor;"></td>
</tr>
<tr>
<td style="padding: 0.75pt;">
<p class="ecxMsoNormal">[type]</p>
</td>
<td style="padding: 0.75pt; border: currentColor;"></td>
<td style="padding: 0.75pt; border: currentColor;"></td>
</tr>
</tbody>
</table>
<p class="ecxMsoNormal"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'> <br>
Here is the code that is causing issues for me...<br>
<br>
<!-- MapServer Template --><br>
<!--<IMG src="<a target="_blank">http://[host]/cgi-bin/mapserv.exe?mode=INDEXQUERY&qformat=png24&qlayer=mjrroads&shapeindex=[shpidx]&shpext=[shpext_esc]&mapext=shape&map=[map</a>]">--><br>
<tr><br>
<td>[shpidx]</td><br>
<tr><td>[name]</td></tr><br>
<tr><td>[type]</td></tr><br>
</tr><br>
<br>
While this is the code for the header...<br>
<br>
<!-- MapServer Template --><br>
<h3><b>Layer: Major Roads</b></h3><br>
<br><br>
<INPUT NAME="img" TYPE="image" SRC="[img]" width=500 height=500 border=0 ALT="Map Image"><br>
<table border=1><br>
<tr> </td><br>
<th>ID</th><br>
<th>Name</th><br>
<th>Type</th><br>
</tr><br>
<br>
As what i'm trying to do is get the name (name of road outputted) and the type (either expressway or major road)<br>
<br>
Thanks,<br>
Mark</span></p>
</div>
<p class="ecxMsoNormal"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'> </span></p>
<div>
<div style="text-align: center;" class="ecxMsoNormal" align="center"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'>
<hr id="ecxstopSpelling" align="center" SIZE="2" width="100%">
</span></div>
<p class="ecxMsoNormal"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'>From:
<a href="mailto:Steve.Lime@state.mn.us">Steve.Lime@state.mn.us</a><br>
To: <a href="mailto:mmirrlees@hotmail.com">mmirrlees@hotmail.com</a>; <a href="mailto:mapserver-users@lists.osgeo.org">
mapserver-users@lists.osgeo.org</a><br>
Subject: RE: [mapserver-users] query creation issues<br>
Date: Wed, 20 Mar 2013 18:22:29 +0000</span></p>
<div>
<p class="ecxMsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>You need to refer to the attributes next…</span><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'></span></p>
<p class="ecxMsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'> </span><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'></span></p>
<p class="ecxMsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><tr><td>[NAME]</td><td>[TYPE]</td></tr></span><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'></span></p>
<p class="ecxMsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'> </span><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'></span></p>
<p class="ecxMsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>Steve</span><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'></span></p>
<p class="ecxMsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'> </span><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'></span></p>
<div>
<div style="border-width: 1pt medium medium; border-style: solid none none; border-color: currentColor; padding: 3pt 0in 0in;">
<p class="ecxMsoNormal"><b><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'>From:</span></b><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'> Mark Mirrlees [<a href="mailto:mmirrlees@hotmail.com">mailto:mmirrlees@hotmail.com</a>]
<br>
<b>Sent:</b> Wednesday, March 20, 2013 12:16 PM<br>
<b>To:</b> Lime, Steve D (MNIT); <a href="mailto:mapserver-users@lists.osgeo.org">
mapserver-users@lists.osgeo.org</a><br>
<b>Subject:</b> RE: [mapserver-users] query creation issues</span></p>
</div>
</div>
<p class="ecxMsoNormal"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'> </span></p>
<div>
<p class="ecxMsoNormal"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'><br>
Hi Steve,<br>
<br>
Thanks for your help. I've managed to get the query outputted. I have a couple of additional questions...after creating my query I need the footer to show the "name" and the "type" (based on the shapefile information), as based on the footer.html below<br>
<br>
<!-- MapServer Template --><br>
<h3><b>Layer: Major Roads</b></h3><br>
<br><br>
<INPUT NAME="img" TYPE="image" SRC="[img]" width=500 height=500 border=0 ALT="Map Image"><br>
<table border=1><br>
<tr> </td><br>
<th>Name</th><br>
<th>Type</th><br>
</tr></span></p>
<div>
<p class="ecxMsoNormal"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'> As when I launch my query it only shows...<br>
</span></p>
<table class="ecxMsoNormalTable" border="1" cellPadding="0">
<tbody>
<tr>
<td style="padding: 0.75pt;">
<p style="text-align: center;" class="ecxMsoNormal" align="center"><b>Name</b></p>
</td>
<td style="padding: 0.75pt;">
<p style="text-align: center;" class="ecxMsoNormal" align="center"><b>Type</b></p>
</td>
</tr>
<tr>
<td style="padding: 0.75pt;"></td>
<td style="padding: 0.75pt;"></td>
</tr>
</tbody>
</table>
</div>
<p class="ecxMsoNormal"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'><br>
<br>
Based on readings from the mapserver website, it looks like I have to edit the query.html to make this populated...but not sure where (global.map file?) I can get this information that is supposed to go between the <td> and </td> tags.<br>
<br>
<!-- MapServer Template --><br>
<!--<IMG src="<a target="_blank">http://[host]/cgi-bin/mapserv.exe?mode=INDEXQUERY&qformat=png24&qlayer=mjrroads&shapeindex=[shpidx]&shpext=[shpext_esc]&mapext=shape&map=[map]</a>">--><br>
<tr><br>
<td> </td><br>
<td></td><br>
</tr><br>
<br>
Thanks,<br>
Mark</span></p>
<div>
<p class="ecxMsoNormal"><span style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'>> From:
<a href="mailto:Steve.Lime@state.mn.us">Steve.Lime@state.mn.us</a><br>
> To: <a href="mailto:mmirrlees@hotmail.com">mmirrlees@hotmail.com</a>; <a href="mailto:mapserver-users@lists.osgeo.org">
mapserver-users@lists.osgeo.org</a><br>
> Subject: RE: [mapserver-users] query creation issues<br>
> Date: Wed, 20 Mar 2013 17:00:47 +0000<br>
> <br>
> Hi Mark: Personally I'd steer you to the simplified query templates as described here:<br>
> <br>
> <a href="http://mapserver.org/development/rfc/ms-rfc-36.html" target="_blank">http://mapserver.org/development/rfc/ms-rfc-36.html</a><br>
> <br>
> This allows you to put everything in one place and better separates data from presentation. No more header/footer's. Plus you can have multiple presentations for the same layer.
<br>
> <br>
> That said, the mapfile below doesn't have any queryable layers. There is no TEMPLATE defined for the one layer that is present.<br>
> <br>
> If you want to use the new style templating you'd do something like this:<br>
> <br>
> 1- Define an output format:<br>
> <br>
> OUTPUTFORMAT<br>
> NAME 'my-template'<br>
> DRIVER 'TEMPLATE'<br>
> MIMETYPE 'text/html; subtype=compass'<br>
> FORMATOPTION "FILE=templates/my-template.html"<br>
> END<br>
> <br>
> 2- Optionally make it the default query format (otherwise you need to use qformat CGI parameter):<br>
> <br>
> WEB<br>
> QUERYFORMAT 'my-template'<br>
> ...<br>
> END<br>
> <br>
> 3- Make layers queryable by adding something like:<br>
> <br>
> TEMPLATE 'void'<br>
> <br>
> 4- Write your template, for example my-template.html might look like:<br>
> <br>
> --- snip ---<br>
> <!-- MapServer Template --><br>
> This is my template:<br/><br>
> <br>
> [resultset layer="mjrroads"]<br>
> [feature]<b>Type</b>: [TYPE][/feature]<br>
> [/resultset]<br>
> <br>
> Done presenting layers.<br>
> --- snip ---<br>
> <br>
> Steve<br>
> <br>
> From: <a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a> [<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</a>] On Behalf Of Mark Mirrlees<br>
> Sent: Wednesday, March 20, 2013 10:45 AM<br>
> To: <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
> Subject: [mapserver-users] query creation issues<br>
> <br>
> Hello everyone,<br>
> <br>
> I'm trying to create a query so I can query the roads/expressways from the map. I'm pretty sure I have created the headers and footers correctly but not sure...regardless i'm not entirely too sure where to stick the particular code in my .map file (shown
below). I have bolded the code that I'm trying to incorporate into the .map file but not sure why it's not working. Thanks Mark<br>
> <br>
> # Map file created from QGIS project file C:/wwwroot/M_Mirrlees_Assign3/markassign3.qgs<br>
> # Edit this file to customize for your map interface<br>
> # (Created with PyQgis MapServer Export plugin)<br>
> MAP<br>
> NAME "QGIS-MAP"<br>
> # Map image size<br>
> SIZE 500 500<br>
> UNITS meters<br>
> EXTENT -2400000 -900000 3100000 4000000<br>
> FONTSET "/wwwroot/fonts/fontset.txt"<br>
> SYMBOLSET "/wwwroot/symbols/symbols.sty"<br>
> PROJECTION<br>
> "proj=lcc"<br>
> "ellps=GRS80"<br>
> "lat_0=49"<br>
> "lon_0=-95"<br>
> "lat_1=49"<br>
> "lat_2=77"<br>
> "datum=NAD83"<br>
> "units=m"<br>
> "no_defs"<br>
> END<br>
> # Background color for the map canvas -- change as desired<br>
> IMAGECOLOR 0 100 250<br>
> IMAGEQUALITY 95<br>
> IMAGETYPE agg<br>
> OUTPUTFORMAT<br>
> NAME agg<br>
> DRIVER AGG/PNG<br>
> IMAGEMODE RGB<br>
> END<br>
> # Legend<br>
> LEGEND<br>
> IMAGECOLOR 255 255 255<br>
> STATUS ON<br>
> KEYSIZE 18 12<br>
> LABEL<br>
> TYPE BITMAP<br>
> SIZE MEDIUM<br>
> COLOR 0 0 89<br>
> END<br>
> END<br>
> # Web interface definition. Only the template parameter<br>
> # is required to display a map. See MapServer documentation<br>
> WEB<br>
> # Set IMAGEPATH to the path where MapServer should<br>
> # write its output.<br>
> IMAGEPATH "/ms4w/tmp/ms_tmp/"<br>
> # Set IMAGEURL to the url that points to IMAGEPATH<br>
> # as defined in your web server configuration<br>
> IMAGEURL "/ms_tmp/"<br>
> # WMS server settings<br>
> METADATA<br>
> 'ows_title' 'QGIS-MAP'<br>
> 'ows_onlineresource' 'localhost.com/cgi-bin/mapserv.exe?map=C:/wwwroot/M_Mirrlees_Assign3/global.map'<br>
> 'ows_srs' 'EPSG:4326'<br>
> END<br>
> #Scale range at which web interface will operate<br>
> # Template and header/footer settings<br>
> # Only the template parameter is required to display a map. See MapServer documentation<br>
> TEMPLATE 'C:/wwwroot/M_Mirrlees_Assign3/global.html'<br>
> END<br>
> <br>
> SCALEBAR<br>
> STATUS EMBED<br>
> UNITS KILOMETERS<br>
> INTERVALS 3<br>
> TRANSPARENT TRUE<br>
> OUTLINECOLOR 0 0 0<br>
> END # End for scalebar<br>
> <br>
> QUERYMAP<br>
> STATUS ON # sets the map to be queryable<br>
> STYLE HILITE # the selected object is highligthed<br>
> END # End for QueryMap<br>
> <br>
> WEB<br>
> TEMPLATE global.html<br>
> IMAGEPATH "/ms4w/tmp/ms_tmp/"<br>
> IMAGEURL "/ms_tmp/"<br>
> HEADER "/maps/M_Mirrlees_assign3/header.html"<br>
> FOOTER "maps/M_Mirrlees_assign3/footer.html"<br>
> EMPTY "/maps/M_Mirrlees_Assign3/blank.html"<br>
> END #End for WEB<br>
> <br>
> <br>
> LAYER<br>
> NAME 'mjrroads'<br>
> TYPE LINE<br>
> DUMP false<br>
> EXTENT -143.210462 39.001401 -50.461045 85.911094<br>
> DATA '../data/mjrroads.shp'<br>
> METADATA<br>
> 'ows_title' 'mjrroads'<br>
> END<br>
> STATUS default<br>
> TRANSPARENCY 100<br>
> PROJECTION<br>
> 'proj=longlat'<br>
> 'datum=WGS84'<br>
> 'no_defs'<br>
> END<br>
> <br>
> CLASSITEM 'TYPE'<br>
> CLASS<br>
> NAME "default"<br>
> EXPRESSION "" <br>
> STYLE<br>
> WIDTH 0.91 <br>
> COLOR 201 157 32<br>
> END<br>
> END<br>
> CLASS<br>
> NAME "TYPE = Expressway" <br>
> EXPRESSION "Expressway" <br>
> STYLE<br>
> WIDTH 2.0 <br>
> COLOR 255 0 0<br>
> END<br>
> END<br>
> CLASS<br>
> NAME "TYPE = Primary Highway" <br>
> EXPRESSION "Primary Highway" <br>
> MAXSCALEDENOM 2500000<br>
> STYLE<br>
> WIDTH 1.0 <br>
> COLOR 0 0 0<br>
> END<br>
> END<br>
> END<br>
> </span></p>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
</div></body>
</html>