[mapserver-users] query creation issues
Mark Mirrlees
mmirrlees at hotmail.com
Wed Mar 20 11:53:57 PDT 2013
Hi there, 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...
IDNameType1164[name][type]
Code from mjrroadsquery.html<!-- MapServer Template -->
<!--<IMG src="http://[host]/cgi-bin/mapserv.exe?mode=INDEXQUERY&qformat=png24&qlayer=mjrroads&shapeindex=[shpidx]&shpext=[shpext_esc]&mapext=shape&map=[map]">-->
<tr>
<td>[shpidx]</td>
<td>[name]</td>
<td>[type]</td>
</tr> Now if I change the [name] to [map] in the mjrroadsquery.html I get the following...
ID
Name
Type
1164
/wwwroot/M_Mirrlees_Assign3/global.map
[type] Code from mjrroads.html <!-- MapServer Template -->
<h3><b>Layer: Major Roads</b></h3>
<br>
<INPUT NAME="img" TYPE="image" SRC="[img]" width=500 height=500 border=0 ALT="Map Image">
<table border=1>
<tr> </td>
<th>ID</th>
<th>Name</th>
<th>Type</th>
</tr> 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. Thanks,Mark
From: Steve.Lime at state.mn.us
To: mmirrlees at hotmail.com; mapserver-users at lists.osgeo.org
Subject: RE: [mapserver-users] query creation issues
Date: Wed, 20 Mar 2013 18:41:52 +0000
Straight item tags like that ARE case sensitive. Try [item name=”name”] and [item name=”type”] instead.
From: Mark Mirrlees [mailto:mmirrlees at hotmail.com]
Sent: Wednesday, March 20, 2013 1:33 PM
To: Lime, Steve D (MNIT); mapserver-users at lists.osgeo.org
Subject: RE: [mapserver-users] query creation issues
Hi Steve,
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
ID
Name
Type
1275
[name]
[type]
Here is the code that is causing issues for me...
<!-- MapServer Template -->
<!--<IMG src="http://[host]/cgi-bin/mapserv.exe?mode=INDEXQUERY&qformat=png24&qlayer=mjrroads&shapeindex=[shpidx]&shpext=[shpext_esc]&mapext=shape&map=[map]">-->
<tr>
<td>[shpidx]</td>
<tr><td>[name]</td></tr>
<tr><td>[type]</td></tr>
</tr>
While this is the code for the header...
<!-- MapServer Template -->
<h3><b>Layer: Major Roads</b></h3>
<br>
<INPUT NAME="img" TYPE="image" SRC="[img]" width=500 height=500 border=0 ALT="Map Image">
<table border=1>
<tr> </td>
<th>ID</th>
<th>Name</th>
<th>Type</th>
</tr>
As what i'm trying to do is get the name (name of road outputted) and the type (either expressway or major road)
Thanks,
Mark
From:
Steve.Lime at state.mn.us
To: mmirrlees at hotmail.com;
mapserver-users at lists.osgeo.org
Subject: RE: [mapserver-users] query creation issues
Date: Wed, 20 Mar 2013 18:22:29 +0000
You need to refer to the attributes next…
<tr><td>[NAME]</td><td>[TYPE]</td></tr>
Steve
From: Mark Mirrlees [mailto:mmirrlees at hotmail.com]
Sent: Wednesday, March 20, 2013 12:16 PM
To: Lime, Steve D (MNIT);
mapserver-users at lists.osgeo.org
Subject: RE: [mapserver-users] query creation issues
Hi Steve,
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
<!-- MapServer Template -->
<h3><b>Layer: Major Roads</b></h3>
<br>
<INPUT NAME="img" TYPE="image" SRC="[img]" width=500 height=500 border=0 ALT="Map Image">
<table border=1>
<tr> </td>
<th>Name</th>
<th>Type</th>
</tr>
As when I launch my query it only shows...
Name
Type
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.
<!-- MapServer Template -->
<!--<IMG src="http://[host]/cgi-bin/mapserv.exe?mode=INDEXQUERY&qformat=png24&qlayer=mjrroads&shapeindex=[shpidx]&shpext=[shpext_esc]&mapext=shape&map=[map]">-->
<tr>
<td> </td>
<td></td>
</tr>
Thanks,
Mark
> From:
Steve.Lime at state.mn.us
> To: mmirrlees at hotmail.com;
mapserver-users at lists.osgeo.org
> Subject: RE: [mapserver-users] query creation issues
> Date: Wed, 20 Mar 2013 17:00:47 +0000
>
> Hi Mark: Personally I'd steer you to the simplified query templates as described here:
>
> http://mapserver.org/development/rfc/ms-rfc-36.html
>
> 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.
>
> That said, the mapfile below doesn't have any queryable layers. There is no TEMPLATE defined for the one layer that is present.
>
> If you want to use the new style templating you'd do something like this:
>
> 1- Define an output format:
>
> OUTPUTFORMAT
> NAME 'my-template'
> DRIVER 'TEMPLATE'
> MIMETYPE 'text/html; subtype=compass'
> FORMATOPTION "FILE=templates/my-template.html"
> END
>
> 2- Optionally make it the default query format (otherwise you need to use qformat CGI parameter):
>
> WEB
> QUERYFORMAT 'my-template'
> ...
> END
>
> 3- Make layers queryable by adding something like:
>
> TEMPLATE 'void'
>
> 4- Write your template, for example my-template.html might look like:
>
> --- snip ---
> <!-- MapServer Template -->
> This is my template:<br/>
>
> [resultset layer="mjrroads"]
> [feature]<b>Type</b>: [TYPE][/feature]
> [/resultset]
>
> Done presenting layers.
> --- snip ---
>
> Steve
>
> From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Mark Mirrlees
> Sent: Wednesday, March 20, 2013 10:45 AM
> To: mapserver-users at lists.osgeo.org
> Subject: [mapserver-users] query creation issues
>
> Hello everyone,
>
> 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
>
> # Map file created from QGIS project file C:/wwwroot/M_Mirrlees_Assign3/markassign3.qgs
> # Edit this file to customize for your map interface
> # (Created with PyQgis MapServer Export plugin)
> MAP
> NAME "QGIS-MAP"
> # Map image size
> SIZE 500 500
> UNITS meters
> EXTENT -2400000 -900000 3100000 4000000
> FONTSET "/wwwroot/fonts/fontset.txt"
> SYMBOLSET "/wwwroot/symbols/symbols.sty"
> PROJECTION
> "proj=lcc"
> "ellps=GRS80"
> "lat_0=49"
> "lon_0=-95"
> "lat_1=49"
> "lat_2=77"
> "datum=NAD83"
> "units=m"
> "no_defs"
> END
> # Background color for the map canvas -- change as desired
> IMAGECOLOR 0 100 250
> IMAGEQUALITY 95
> IMAGETYPE agg
> OUTPUTFORMAT
> NAME agg
> DRIVER AGG/PNG
> IMAGEMODE RGB
> END
> # Legend
> LEGEND
> IMAGECOLOR 255 255 255
> STATUS ON
> KEYSIZE 18 12
> LABEL
> TYPE BITMAP
> SIZE MEDIUM
> COLOR 0 0 89
> END
> END
> # Web interface definition. Only the template parameter
> # is required to display a map. See MapServer documentation
> WEB
> # Set IMAGEPATH to the path where MapServer should
> # write its output.
> IMAGEPATH "/ms4w/tmp/ms_tmp/"
> # Set IMAGEURL to the url that points to IMAGEPATH
> # as defined in your web server configuration
> IMAGEURL "/ms_tmp/"
> # WMS server settings
> METADATA
> 'ows_title' 'QGIS-MAP'
> 'ows_onlineresource' 'localhost.com/cgi-bin/mapserv.exe?map=C:/wwwroot/M_Mirrlees_Assign3/global.map'
> 'ows_srs' 'EPSG:4326'
> END
> #Scale range at which web interface will operate
> # Template and header/footer settings
> # Only the template parameter is required to display a map. See MapServer documentation
> TEMPLATE 'C:/wwwroot/M_Mirrlees_Assign3/global.html'
> END
>
> SCALEBAR
> STATUS EMBED
> UNITS KILOMETERS
> INTERVALS 3
> TRANSPARENT TRUE
> OUTLINECOLOR 0 0 0
> END # End for scalebar
>
> QUERYMAP
> STATUS ON # sets the map to be queryable
> STYLE HILITE # the selected object is highligthed
> END # End for QueryMap
>
> WEB
> TEMPLATE global.html
> IMAGEPATH "/ms4w/tmp/ms_tmp/"
> IMAGEURL "/ms_tmp/"
> HEADER "/maps/M_Mirrlees_assign3/header.html"
> FOOTER "maps/M_Mirrlees_assign3/footer.html"
> EMPTY "/maps/M_Mirrlees_Assign3/blank.html"
> END #End for WEB
>
>
> LAYER
> NAME 'mjrroads'
> TYPE LINE
> DUMP false
> EXTENT -143.210462 39.001401 -50.461045 85.911094
> DATA '../data/mjrroads.shp'
> METADATA
> 'ows_title' 'mjrroads'
> END
> STATUS default
> TRANSPARENCY 100
> PROJECTION
> 'proj=longlat'
> 'datum=WGS84'
> 'no_defs'
> END
>
> CLASSITEM 'TYPE'
> CLASS
> NAME "default"
> EXPRESSION ""
> STYLE
> WIDTH 0.91
> COLOR 201 157 32
> END
> END
> CLASS
> NAME "TYPE = Expressway"
> EXPRESSION "Expressway"
> STYLE
> WIDTH 2.0
> COLOR 255 0 0
> END
> END
> CLASS
> NAME "TYPE = Primary Highway"
> EXPRESSION "Primary Highway"
> MAXSCALEDENOM 2500000
> STYLE
> WIDTH 1.0
> COLOR 0 0 0
> END
> END
> END
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130320/b64c3da4/attachment.htm>
More information about the MapServer-users
mailing list