Send mapserver-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.osgeo.org/mailman/listinfo/mapserver-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of mapserver-users digest..."
Today's Topics:
1. WMSgetFeatureInfo and variable substitution
([email protected])
2. Re: WMSgetFeatureInfo and variable substitution (Martin Ouellet)
3. Re: WMSgetFeatureInfo and variable substitution
(Daniel Morissette)
4. Re: php-mapscript compilation problem on OpenSuse 11.1/11.2
(Daniel Morissette)
----------------------------------------------------------------------
Message: 1
Date: Mon, 23 Nov 2009 12:44:43 -0500
From: [email protected]
Subject: [mapserver-users] WMSgetFeatureInfo and variable substitution
To: [email protected]
Message-ID:
<of439c3e0f.a471b251-on85257677.0060ee5b-85257677.00617...@ssss.gouv.qc.ca>
Content-Type: text/plain; charset="iso-8859-1"
Hi,
I already posted this problem on openlayers list, but it might be a
mapserver issue.
OpenLayers.Control.WMSGetFeatureInfo doesn't use the FILTER key in my
mapfile. This filter is define with variables like this:
FILTER "semcdc in (%SEMCDC%) and rss in (%RSS%) and ordre in (%ORDRE%)" .
The getMap request is succesfull but not the GetFeatureInfo request
Here is the request GetFeatureInfo
/cgi-bin/mapserv.exe?map=MYMAP
service=WMS&version=1.1.0&request=GetFeatureInfo&layers=ecoles&query_layers=ecoles&styles=&bbox=-8820221.560815%2C5721770.182129%2C-7587445.168853%2C6361395.234705&srs=EPSG%3A900913&feature_count=3000&x=272&y=457&height=523&width=1008&info_format=text%2Fhtml
Here is the response
<?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE ServiceExceptionReport SYSTEM "
http://schemas.opengis.net/wms/1.1.0/exception_1_1_0.dtd">
<ServiceExceptionReport version="1.1.0">
<ServiceException>
prepare_database(): Query error. Error declaring cursor: ERROR: syntax
error at or near "%"
LINE 1: ...:text from ecoles WHERE (semcdc in (%SEMCDC%) ...
^
With query string: DECLARE mycursor BINARY CURSOR FOR SELECT
"taux_abs"::text,"nouv"::text,asbinary(force_collection(force_2d(geom900913)),'NDR'),id::text
from ecoles WHERE (semcdc in (%SEMCDC%) and rss in (%RSS%) and ordre in
(%ORDRE%)) and (geom900913 && setSRID(
'BOX3D(-8493071.07981319 5795761.22549582,-8480841.15528974
5807991.15001926)'::BOX3D,900913) )
</ServiceException>
</ServiceExceptionReport>
In OL, I have a WMS layer define like this:
new OpenLayers.Layer.WMS('ecoles',
'.../cgi-bin/mapserv.exe?map=MYMAP',{layers: 'ecoles', transparent:
"true", format:"image/gif", SEMCDC:thisCDC, RSS: thisRSS, ORDRE:
thisOrdre},{isBaseLayer: false, visibility:
false,singleTile:true,transitionEffect: 'resize'});
How should I query the layer?
Thanks
Steve
Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction de la santé environnementale et de la toxicologie
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3
Tél.: (418) 650-5115 #5281
Fax.: (418) 654-3144
[email protected]
http://www.inspq.qc.ca
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.osgeo.org/pipermail/mapserver-users/attachments/20091123/423ab2c2/attachment-0001.html
------------------------------
Message: 2
Date: Mon, 23 Nov 2009 13:13:11 -0500
From: Martin Ouellet <[email protected]>
Subject: Re: [mapserver-users] WMSgetFeatureInfo and variable
substitution
To: [email protected]
Cc: [email protected]
Message-ID:
<[email protected]>
Content-Type: text/plain; charset="iso-8859-1"
One way to do it is to pass new parameters(with tha exact name of you're
mapfile variable) in the GetFeatureInfo URL so it would look something like
this:
Here is the request GetFeatureInfo
/cgi-bin/mapserv.exe?map=MYMAP
service=WMS&version=1.1.0&request=GetFeatureInfo&layers=ecoles&query_layers=ecoles&styles=&bbox=-8820221.560815%2C5721770.182129%2C-7587445.168853%2C6361395.234705&srs=EPSG%3A900913&feature_count=3000&x=272&y=457&height=523&width=1008&info_format=text%2Fhtml
*&**SEMCDC=<value>&**RSS=**<value>&**ORDRE**<value>*
MapServer will then replace the value before returning the result.
hope's this help....
MartinO
2009/11/23 <[email protected]>
Hi,
I already posted this problem on openlayers list, but it might be a
mapserver issue.
OpenLayers.Control.WMSGetFeatureInfo doesn't use the FILTER key in my
mapfile. This filter is define with variables like this:
FILTER "semcdc in (%SEMCDC%) and rss in (%RSS%) and ordre in (%ORDRE%)" .
The getMap request is succesfull but not the GetFeatureInfo request
Here is the request GetFeatureInfo
/cgi-bin/mapserv.exe?map=MYMAP
service=WMS&version=1.1.0&request=GetFeatureInfo&layers=ecoles&query_layers=ecoles&styles=&bbox=-8820221.560815%2C5721770.182129%2C-7587445.168853%2C6361395.234705&srs=EPSG%3A900913&feature_count=3000&x=272&y=457&height=523&width=1008&info_format=text%2Fhtml
Here is the response
<?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE ServiceExceptionReport SYSTEM "
http://schemas.opengis.net/wms/1.1.0/exception_1_1_0.dtd">
<ServiceExceptionReport version="1.1.0">
<ServiceException>
prepare_database(): Query error. Error declaring cursor: ERROR: syntax
error at or near "%"
LINE 1: ...:text from ecoles WHERE (semcdc in (%SEMCDC%) ...
^
With query string: DECLARE mycursor BINARY CURSOR FOR SELECT
"taux_abs"::text,"nouv"::text,asbinary(force_collection(force_2d(geom900913)),'NDR'),id::text
from ecoles WHERE (semcdc in (%SEMCDC%) and rss in (%RSS%) and ordre in
(%ORDRE%)) and (geom900913 && setSRID( 'BOX3D(-8493071.07981319
5795761.22549582,-8480841.15528974 5807991.15001926)'::BOX3D,900913) )
</ServiceException>
</ServiceExceptionReport>
In OL, I have a WMS layer define like this:
new OpenLayers.Layer.WMS('ecoles',
'.../cgi-bin/mapserv.exe?map=MYMAP',{layers: 'ecoles', transparent: "true",
format:"image/gif", SEMCDC:thisCDC, RSS: thisRSS, ORDRE:
thisOrdre},{isBaseLayer: false, visibility:
false,singleTile:true,transitionEffect: 'resize'});
How should I query the layer?
Thanks
Steve
*
Steve Toutant, M. Sc.*
Analyste en géomatique
Secteur environnement
Direction de la santé environnementale et de la toxicologie
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3
Tél.: (418) 650-5115 #5281
Fax.: (418) 654-3144*
**[email protected]* <[email protected]>*
**http://www.inspq.qc.ca* <http://www.inspq.qc.ca/>
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.osgeo.org/pipermail/mapserver-users/attachments/20091123/53823b42/attachment-0001.html
------------------------------
Message: 3
Date: Mon, 23 Nov 2009 13:14:32 -0500
From: Daniel Morissette <[email protected]>
Subject: Re: [mapserver-users] WMSgetFeatureInfo and variable
substitution
To: mapserver-users <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
I saw your post on the openlayers list, and it seems from your
description of the problem that the SEMCDC, RCC and ORDER params are
included by OpenLayers in a GetMap request but it fails to include them
in the corresponding GetFeatureInfo request. If that's the case then
that's an issue with OpenLayers, or with the way you configure your
queryable layer in OL. I'm not fluent enough in OL personally to tell
where the solution lies, but if the params are missing in the URL then
the problem is definitely on the client side and not on the server.
Daniel
[email protected] wrote:
Hi,
I already posted this problem on openlayers list, but it might be a
mapserver issue.
OpenLayers.Control.WMSGetFeatureInfo doesn't use the FILTER key in my
mapfile. This filter is define with variables like this:
FILTER "semcdc in (%SEMCDC%) and rss in (%RSS%) and ordre in (%ORDRE%)" .
The getMap request is succesfull but not the GetFeatureInfo request
Here is the request GetFeatureInfo
/cgi-bin/mapserv.exe?map=MYMAP
service=WMS&version=1.1.0&request=GetFeatureInfo&layers=ecoles&query_layers=ecoles&styles=&bbox=-8820221.560815%2C5721770.182129%2C-7587445.168853%2C6361395.234705&srs=EPSG%3A900913&feature_count=3000&x=272&y=457&height=523&width=1008&info_format=text%2Fhtml
Here is the response
<?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE ServiceExceptionReport SYSTEM
"http://schemas.opengis.net/wms/1.1.0/exception_1_1_0.dtd">
<ServiceExceptionReport version="1.1.0">
<ServiceException>
prepare_database(): Query error. Error declaring cursor: ERROR: syntax
error at or near "%"
LINE 1: ...:text from ecoles WHERE (semcdc in (%SEMCDC%) ...
^
With query string: DECLARE mycursor BINARY CURSOR FOR SELECT
"taux_abs"::text,"nouv"::text,asbinary(force_collection(force_2d(geom900913)),'NDR'),id::text
from ecoles WHERE (semcdc in (%SEMCDC%) and rss in (%RSS%) and ordre in
(%ORDRE%)) and (geom900913 && setSRID(
'BOX3D(-8493071.07981319 5795761.22549582,-8480841.15528974
5807991.15001926)'::BOX3D,900913) )
</ServiceException>
</ServiceExceptionReport>
In OL, I have a WMS layer define like this:
new OpenLayers.Layer.WMS('ecoles',
'.../cgi-bin/mapserv.exe?map=MYMAP',{layers: 'ecoles', transparent:
"true", format:"image/gif", SEMCDC:thisCDC, RSS: thisRSS, ORDRE:
thisOrdre},{isBaseLayer: false, visibility:
false,singleTile:true,transitionEffect: 'resize'});
How should I query the layer?
Thanks
Steve
/
Steve Toutant, M. Sc./
Analyste en géomatique
Secteur environnement
Direction de la santé environnementale et de la toxicologie
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3
Tél.: (418) 650-5115 #5281
Fax.: (418) 654-3144_
[email protected]_ <mailto:[email protected]>_
__http://www.inspq.qc.ca_ <http://www.inspq.qc.ca/>
------------------------------------------------------------------------
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users