Re: [mapserver-users] Allow request in http and https

[Steve Toutant]

Setting the default resolution at the map level in the mapfile would do 
that?
http://mapserver.org/mapfile/map.html
RESOLUTION default is 72



De :Andrea Peri 
A : "Kralidis, Tom (EC)" 
Cc :"Mapserver-Users \(mapserver-users@lists.osgeo.org\)" 

Date :  2017-05-03 01:47
Objet : Re: [mapserver-users] Allow request in http and https
Envoyé par :"mapserver-users" 




Hi Tom,

thx for hint.
I forgot totally tht the onlineresource mapffile parameter was otionally.
Removeing it , the system work as I need.
Infact the mapserver retrieve the url from the request url.

Before of all I notice that the mapserver use before the

  "wms_service_onlineresource"
and if it is not available use the
"wms_onlineresource".

So I remove both and effectivelly the mapserver produce automatically the 
url.
It is what I need to support our two kind of portals protocols (http and 
https)

I notice only one residual problem.

In the wms_onlineresource parameter we put some extra parameter:

like (for example) the
map_resolution parameter

  "wms_onlineresource"
"
http://myserver.it/wmsraster/com.rt.wms.RTmap/wms?map=wmsambamm_resolution=91;
"

we need it to increase the resolution of all the getmap request of the
qgis clients.
removing the wms_onlineresource mean that the getmap requests are all
resolved using the resolution 74dpi and this mean a lower quality
level.


The perfect solution so will be to hvae a postfix parameter to define
an append string for the urls.
Something like this:

"wms_onlineresource_postfix"  "_resolution=91&"

to have a result URL with added the string defined in the 
wms_onlineresource.

http://myserver.it/wmsraster/com.rt.wms.RTmap/wms?map=wmsambamm_resolution=91;


A.



2017-05-03 1:31 GMT+02:00 Kralidis, Tom (EC) :
> What happens when you do _not_ set ows_onlineresource?  I think 
MapServer
> will automagically determine the URL?
>
>
>
>> -Original Message-
>> From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] 
On
>> Behalf Of Andrea Peri
>> Sent: 02 May 2017 18:26
>> To: Richard Greenwood
>> Cc: Mapserver-Users (mapserver-users@lists.osgeo.org)
>> Subject: Re: [mapserver-users] Allow request in http and https
>>
>> mmm...
>>
>> Perhaps for the resource-online url could be better a setting like:
>>
>> "ows_resourceonline"  "auto"
>>
>> Where "auto" mean that the mapserver retrieve the url (and the protocol 
used)
>> from the request url of the getcapability request.
>>
>> This was the better solution.
>> Infact if the client request on an https protocol it will return a 
capability files
>> with all the request in https.
>> And if the client request using an http protocol it will return a 
capability with
>> http protocol.
>>
>>
>>
>> 2017-05-02 21:14 GMT+02:00 Richard Greenwood
>> :
>> > If you really have to have two different wms_onlineresource and if
>> > Steve's suggestion to leave out the protocol didn't work, then you
>> > could create two ows URLs and use the map file's INCLUDE directive to
>> > refer to the same map file just using different wms_onlineresource in 
the
>> two.
>> >
>> > On Tue, May 2, 2017 at 11:14 AM, Andrea Peri 
>> wrote:
>> >>
>> >> Hi Jukka,
>> >> my trouble come from a webapplication using geotools lbrary.
>> >> Seem that the geotools when try to connect to a WFS server (and I
>> >> guess also to the WMS) start with a getcapabilities request and 
remap
>> >> the getmap using it.
>> >>
>> >>
>> >> We have many portal using http.
>> >> Now there is a new portal using https, and it should access to the
>> >> same wms services.
>> >>
>> >> So I have a portal using https that is using also http protocol.
>> >> As I understand the web browser refuse to allow an http request when
>> >> the father page is coming from an https request blocking them.
>> >>
>> >> A.
>> >>
>> >>
>> >> 2017-05-02 16:50 GMT+02:00 Rahkonen Jukka (MML)
>> >> :
>> >> > Hi,
>> >> >
>> >> > Actually your Mapserver will respond both to http and https
>> >> > requests if your network let them both come through. 
OnlineResourse
>> >> > has no effect at all for Mapserver, you can set it to
>> >> > http://foo@bar if you wish. But WMS clients may have difficulties
>> >> > if they really interpret the GetMap URL and use it for further
>> >> > operations. QGIS and OpenJUMP have an override for using the same
>> >> > base URL that was used for doing GetCapabililies and that might
>> >> > suit for your case. OpenLayers, Leaflet etc. don't even parse
>> GetCapabilities and http://foo@bar is totally OK for them.
>> >> >
>> >> > -Jukka-
>> >> >
>> >> >
>> >> >
>> >> > -Alkuperäinen viesti-
>> >> > Lähettäjä: mapserver-users
>> >> > [mailto:mapserver-users-boun...@lists.osgeo.org] Puolesta Andrea
>> >> > Peri
>> >> > 

Re: [mapserver-users] Issue in using MapServer WFS Filter

[Steve Toutant]

Try adding ="EPSG:4326" as a parameter
typeName=SampleLayer=EPSG:4326



De :Kajod Sharma 
A : "mapserver-users@lists.osgeo.org" 

Date :  2017-04-26 09:43
Objet : [mapserver-users] Issue in using MapServer WFS Filter
Envoyé par :"mapserver-users" 




Hi,

Greetings!

I hope this is a right platform to discuss my query regarding FILTER 
applied on MapServer WFS.

I'm new in this area and exploring some features of MapServer. I want to 
use GetFeature request of WFS to get features applied on any location on 
map. I'm using "MapServer version 7.0.4 (MS4W 3.2.1)" and trying to apply 
filter "Contains" for it.

I can see two problems when it applies Filter query on PostGIS:

1. It looks it adds an extra default geospatial filter in it while making 
a query to PostGIS. This default spatial filter is not stopping to return 
any result from PostGIS. Is there any way to exclude this default filter?
2. It seems Contains coordinates are not transformed properly according to 
SRS of data in PostGIS.

I've tries with different projection in map file and request message with 
no success.

Supporting data to give your input on my queries:

WFS request
*
Formatted Version:

http://localhost/cgi-bin/mapserv.exe?
service=WFS&
map=C:/Data/MapServerWFSSample.map&
request=GetFeature&
version=2.0.0&
typeName=SampleLayer&
FILTER=http://www.opengis.net/ogc; xmlns:gml="
http://www.opengis.net/gml; xmlns:ms="
http://mapserver.gis.umn.edu/mapserver;>
  
wkb_Geometry

  0.112034,53.567972

  

*

PostGIS query [Could see in log file]:
*
msPostGISLayerWhichShapes query: select 
"Attribute1","Attribute2","Attribute3",encode(ST_AsBinary(ST_Force2D("wkb_geometry"),'NDR'),'hex')
 
as geom from SampleGeoDataTable where wkb_geometry && 
ST_GeomFromText('POLYGON((-0.999462804873474 
-1.00102606014116,-0.999462804873474 -1.00102606014116,-0.999462804873474 
-1.00102606014116,-0.999462804873474 -1.00102606014116,-0.999462804873474 
-1.00102606014116))',find_srid('','SampleGeoDataTable','wkb_geometry')) 
and (st_contains(wkb_geometry,ST_GeomFromText('POINT (
7853690.363183814100 -5506204.523277333000)')) = TRUE)
*

Similar WFS query to GeoServer works perfectly.

It would be very helpful if someone can help me on it. Thanks a lot in 
advance. 

Map File looks like:

**
MAP
  NAME "Sample_WMS"
  CONFIG "PROJ_LIB" "C:\ms4w\proj\nad"
  CONFIG "MS_ERRORFILE" "C:/Data/ms_tmp/ms_error.txt"
  CONFIG "CPL_DEBUG" "ON"
  CONFIG "PROJ_DEBUG" "ON"
  STATUS ON
  PROJECTION
"init=epsg:27700"
  END 
 
  WEB
   IMAGEPATH "C:/Data/ms_tmp/"
   IMAGEURL "/ms_tmp/"
   METADATA 
"wfs_enable_request" "*"
"wfs_title" "My Global Map WFS Server"
"wfs_srs"   "EPSG:4326 EPSG:900913 EPSG:27700"
"wfs_boundingbox""EPSG:27700 749.099975585938 -90036.5 660460.875 
1227306.5" 
   END
  END
 
  LAYER
   NAME "SampleLayer"
   STATUS DEFAULT
   TYPE POLYGON
   PROJECTION
"init=epsg:27700"
   END 
   CONNECTIONTYPE POSTGIS
   CONNECTION "host=localhost port=5432 dbname=SampleGeoDataTable 
user=postgres password=hahaha"
   DATA "wkb_geometry from SampleLayer"
   CLASS
 STYLE
  COLOR  0 100 255
  OUTLINECOLOR 0 0 0
 END 
   END
 
   METADATA 
"wfs_enable_request" "*"
"wfs_title" "Sample WFS"
"wfs_srs"   "EPSG:27700 EPSG:4326 EPSG:900913"
"wfs_boundingbox""EPSG:27700 749.099975585938 -90036.5 660460.875 
1227306.5"
"gml_include_items" "all"
   END 
  END 
END
**

Regards,
Kajod___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Possible application questions

[Steve . Toutant]

I don't understand what you mean by 
"-Mapserver displays the files that meet the given criteria. " and linked 
files


There is a GetFeatureInfo request in WMS spec, so yes by clicking on a 
feature that could launch a request. The fields to query are specified in 
the mapfile.

I think it is time to learn what a mapfile is and how it interacts with 
data. 
There are severals basics tutorials available so you can quickly 
understand how it works

Steve




De :Joe Hogan 
A : steve.tout...@inspq.qc.ca
Cc :mapserver-users@lists.osgeo.org
Date :  2017-02-26 23:55
Objet : Re: [mapserver-users] Possible application questions



Hello Steve
Thanks for your feedback so far.  It is slowly painting a picture for me.
Before we start the CRM DB, we need ot determine if a mapping software can 
with with the CRM DB.  You seem to say this.
We do not want to start the DB in a software, only have to export it once 
done, to a new DB software.  The Ma[pserver part wil be done once the DB 
part is done.  Why, the budget is ready for the DB part, but not yet for 
the mapserver part.
So, a simple scenario would be:

-My CRM database is populated with various data concerning projects that 
we want to map out in Map server, including longitude and latitude.  This 
coudl include: year, budget, different project paramaters, etc...
-Mapserver is configured to be able to read the CRM DB.  There will be 
various fields that will be searchable by definable fields in Mapserver.
-Mapserver is able to peruse through the CRM DB and grab the data that it 
needs to display on the map, according to defined choices in our search.
-Mapserver displays the files that meet the given criteria.
This sound right?

Those points that are displayed, are they clickable?
IF so (for my project they need to be clickable, or the people doing the 
search will not be able to see details on the files that meet the 
criteria), how to we determine what is displayed?  If it is displayed, we 
will want to display additional information that what query criteria.

Last question before I sign off.
Like I state, we are looking at  CRM to do this system.  It seems to be 
much easier than building a new interface and database.  The CRM is well 
advanced, very flexible, modifiable and a great price that fits our 
budget.  By removing a few modules, it seems to suit the project well.
When we have a project in the CRM, there are hard data typed right into 
the profile: name, year, budget, etc...
But, we also have data that is "linked" to the project, like: Companies 
and individuals.   This is different from the hard data.  Hard data has a 
field, and whether you enter something in the field or note, the full or 
empty field is displayed.  For the "linked" style, there is a heading, but 
if there are no "linked" files, nothing is displayed.  But, if there are 
things to display, the page adjusts downward to accommodate the entries.
Can we have Mapserver grab the names of these "linked" files?
Thanks!
Joseph


On 02/22/2017 09:32 AM, steve.tout...@inspq.qc.ca wrote:
WMS and WFS are ogc standards to share maps over the web, intranet ... 
https://en.wikipedia.org/wiki/Web_Map_Service 

You will not export data from the database. Mapserver will be connected to 
your mysql DB and render maps as a service. 
Those services can be viewed by gis softwares or web applications 
steve 
  



De :Joe Hogan  
A :steve.tout...@inspq.qc.ca 
Cc :mapserver-users@lists.osgeo.org 
Date :2017-02-21 11:14 
Objet :Re: [mapserver-users] Possible application questions 



Hello Steve, 
Thanks for the reassuring news.  We have found our possible solution. 
The CRM software has not yet been modified, but it will have the two 
fields for the Longitude and Latitude. 
Other fields will be used as well, and we will have to add more for those. 

When you say it has to provide wms/wfs services, what does that mean?  I 
found the 9nitials, but what does it mean? 
Is it a special format?  Like I need to export the data from the data base 
into a certain format? 
Sorry for the newbie questions, but I am learning:) 
Thanks 
Joseph 

On 02/21/2017 08:48 AM, steve.tout...@inspq.qc.ca wrote: 

hi Joseph
Yes mapserver can be used for your application by providing wms/wfs 
services
Here are some links that can help
#connect to mysql
http://mapserver.org/input/vector/mysql.html

#filters...Runtime substitution
http://mapserver.org/cgi/runsub.html

Do you have latitude/longitude data in your database, or any other 
georeference that can be used to render on a map?
Steve


-"mapserver-users"  a écrit : 
- 
A : mapserver-users@lists.osgeo.org
De : Joe Hogan 
Envoyé par : "mapserver-users" 
Date : 20/02/2017 11:12
Objet : [mapserver-users] Possible application questions

Hello,

I am writing to ask if MapServer will work for our application.

We are working on a project that will 

Re: [mapserver-users] Possible application questions

[Steve . Toutant]

WMS and WFS are ogc standards to share maps over the web, intranet ...
https://en.wikipedia.org/wiki/Web_Map_Service

You will not export data from the database. Mapserver will be connected to 
your mysql DB and render maps as a service.
Those services can be viewed by gis softwares or web applications
steve
 



De :Joe Hogan 
A : steve.tout...@inspq.qc.ca
Cc :mapserver-users@lists.osgeo.org
Date :  2017-02-21 11:14
Objet : Re: [mapserver-users] Possible application questions



Hello Steve,
Thanks for the reassuring news.  We have found our possible solution.
The CRM software has not yet been modified, but it will have the two 
fields for the Longitude and Latitude.
Other fields will be used as well, and we will have to add more for those.
When you say it has to provide wms/wfs services, what does that mean?  I 
found the 9nitials, but what does it mean?
Is it a special format?  Like I need to export the data from the data base 
into a certain format?
Sorry for the newbie questions, but I am learning:)
Thanks

Joseph

On 02/21/2017 08:48 AM, steve.tout...@inspq.qc.ca wrote:

hi Joseph
Yes mapserver can be used for your application by providing wms/wfs 
services
Here are some links that can help
#connect to mysql
http://mapserver.org/input/vector/mysql.html

#filters...Runtime substitution
http://mapserver.org/cgi/runsub.html

Do you have latitude/longitude data in your database, or any other 
georeference that can be used to render on a map?
Steve


-"mapserver-users"  a écrit : 
- 
A : mapserver-users@lists.osgeo.org
De : Joe Hogan 
Envoyé par : "mapserver-users" 
Date : 20/02/2017 11:12
Objet : [mapserver-users] Possible application questions

Hello,

I am writing to ask if MapServer will work for our application.

We are working on a project that will allow us to place on a map of our 
country various projects.  We want to be able to filter them based on 
various pieces of information, including, for example:

year of project
population
project budget
etc...

We are compiling the data in a CRM(MySQL database), and want to use the 
data from the CRM to feed the mapping software.

1 - can I map the type fo information that I need?
2 - can we use the data directly from the CRM database if we tell the 
mapping software what data to use(so t can be read on the fly, live from 
the database?), or does it need to be exported before using in the 
mapping software?
3 - It it needs to be in its own exported format, how to I get it from 
MtSQL to the correct format?


Thanks for any and all help.

Joseph

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Si vous n'êtes pas le destinataire de ce message, veuillez le détruire 
près avoir informé l'expéditeur de son erreur. Par ailleurs, il est 
interdit de copier ou de modifier ce courriel sans l'autorisation de 
l'auteur.

L'Institut national de santé publique du Québec n'assume aucune 
responsabilité à l'égard du contenu des messages personnels envoyés par 
ses employés.

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Possible application questions

[Steve . Toutant]

hi JosephYes mapserver can be used for your application by providing wms/wfs servicesHere are some links that can help#connect to mysqlhttp://mapserver.org/input/vector/mysql.html#filters...Runtime substitutionhttp://mapserver.org/cgi/runsub.htmlDo you have latitude/longitude data in your database, or any other georeference that can be used to render on a map?Steve-"mapserver-users"  a écrit : -A : mapserver-users@lists.osgeo.orgDe : Joe Hogan Envoyé par : "mapserver-users" Date : 20/02/2017 11:12Objet : [mapserver-users] Possible application questionsHello,I am writing to ask if MapServer will work for our application.We are working on a project that will allow us to place on a map of our country various projects.  We want to be able to filter them based on various pieces of information, including, for example:year of projectpopulationproject budgetetc...We are compiling the data in a CRM(MySQL database), and want to use the data from the CRM to feed the mapping software.1 - can I map the type fo information that I need?2 - can we use the data directly from the CRM database if we tell the mapping software what data to use(so t can be read on the fly, live from the database?), or does it need to be exported before using in the mapping software?3 - It it needs to be in its own exported format, how to I get it from MtSQL to the correct format?Thanks for any and all help.Joseph___mapserver-users mailing listmapserver-users@lists.osgeo.orghttps://lists.osgeo.org/mailman/listinfo/mapserver-usersSi vous n'êtes pas le destinataire de ce message, veuillez le détruire près avoir informé l'expéditeur de son erreur.  Par ailleurs, il est interdit de copier ou de modifier ce courriel sans l'autorisation de l'auteur.L'Institut national de santé publique du Québec n'assume aucune responsabilité à l'égard du contenu des messages personnels envoyés par ses employés.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapfile - filter by parameter - full scan

[Steve . Toutant]

How using (), [], "", '' is still a great mystery to me in filters. Every time I do many tries to got it rightYour _expression_ seems to be ok so I don't know why you need extra () You can try without '' and [] like thisFILTER  ((no_diag=%no_diag%) or (%no_diag% = 0)) Or try using processing instead of FILTERPROCESSING 'NATIVE_FILTER=((%no_diag% = 0 OR no_diag=%no_diag%))'Steve-"mapserver-users"  a écrit : -A : "'mapserver-users@lists.osgeo.org'" De : "Lane, Michael" Envoyé par : "mapserver-users" Date : 25/01/2017 16:13Objet : [mapserver-users] Mapfile - filter by parameter - full scanHi,
 
Experiencing something not expected with the filter condition in mapfile.
 
I add this code in my mapFile to have the possibility to void the filter if no parameter is given:
 
VALIDATION

       no_diag '^[0-9]{1,2}$'

       default_no_diag '0'

 END 
 DATA "geom_surf from LOCTS_PARC_AGRI_AN_COUR using srid 4326"

  FILTER  (([no_diag]='%no_diag%') or ('%no_diag%' = '0'))  

I compare my execution time without parameter and it’s going to an execution time of 3 seconds before filter to one of 3 minutes with the filter.
 
After debugging, I realize that the « where clause » generated by MapServe were bad with the filter and that generate a full table scan :
WHERE   ( '0' = '0' ) OR ( no_diag = '0' )  AND …
I was expecting something more like :
WHERE   (( '0' = '0' ) OR ( no_diag = '0' ))  AND …
So I had to add more parenthesis to the filter to get it correct
((('%no_diag%' = '0') or ([no_diag]='%no_diag%')))

Is it normal that I have to do that? The examples I found on the internet, have always single parenthesis. Do I code it right?
 
I use Mapserver 7 with database Oracle 12c. My parameter no_diag is a number.
 
Thanks
 
Michael Lane

Technicien en informatique

Direction des solutions d'affaires
La Financière agricole du Québec
1400, boul. Guillaume-Couture
Lévis (Québec) G6W 8K7
Tél. : 418 838-5614, poste 6034
michael.l...@fadq.qc.ca___mapserver-users mailing listmapserver-users@lists.osgeo.orghttps://lists.osgeo.org/mailman/listinfo/mapserver-usersSi vous n'êtes pas le destinataire de ce message, veuillez le détruire près avoir informé l'expéditeur de son erreur.  Par ailleurs, il est interdit de copier ou de modifier ce courriel sans l'autorisation de l'auteur.L'Institut national de santé publique du Québec n'assume aucune responsabilité à l'égard du contenu des messages personnels envoyés par ses employés.___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapfile - filter by parameter - full scan

[Steve . Toutant]

or use a subquery in the DATA statement instead of FILTER or PROCESSING-"mapserver-users"  a écrit : -A : "'mapserver-users@lists.osgeo.org'" De : "Lane, Michael" Envoyé par : "mapserver-users" Date : 25/01/2017 16:13Objet : [mapserver-users] Mapfile - filter by parameter - full scanHi,
 
Experiencing something not expected with the filter condition in mapfile.
 
I add this code in my mapFile to have the possibility to void the filter if no parameter is given:
 
VALIDATION

       no_diag '^[0-9]{1,2}$'

       default_no_diag '0'

 END 
 DATA "geom_surf from LOCTS_PARC_AGRI_AN_COUR using srid 4326"

  FILTER  (([no_diag]='%no_diag%') or ('%no_diag%' = '0'))  

I compare my execution time without parameter and it’s going to an execution time of 3 seconds before filter to one of 3 minutes with the filter.
 
After debugging, I realize that the « where clause » generated by MapServe were bad with the filter and that generate a full table scan :
WHERE   ( '0' = '0' ) OR ( no_diag = '0' )  AND …
I was expecting something more like :
WHERE   (( '0' = '0' ) OR ( no_diag = '0' ))  AND …
So I had to add more parenthesis to the filter to get it correct
((('%no_diag%' = '0') or ([no_diag]='%no_diag%')))

Is it normal that I have to do that? The examples I found on the internet, have always single parenthesis. Do I code it right?
 
I use Mapserver 7 with database Oracle 12c. My parameter no_diag is a number.
 
Thanks
 
Michael Lane

Technicien en informatique

Direction des solutions d'affaires
La Financière agricole du Québec
1400, boul. Guillaume-Couture
Lévis (Québec) G6W 8K7
Tél. : 418 838-5614, poste 6034
michael.l...@fadq.qc.ca___mapserver-users mailing listmapserver-users@lists.osgeo.orghttps://lists.osgeo.org/mailman/listinfo/mapserver-usersSi vous n'êtes pas le destinataire de ce message, veuillez le détruire près avoir informé l'expéditeur de son erreur.  Par ailleurs, il est interdit de copier ou de modifier ce courriel sans l'autorisation de l'auteur.L'Institut national de santé publique du Québec n'assume aucune responsabilité à l'égard du contenu des messages personnels envoyés par ses employés.___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Wms filter expressions with 'or'

[Steve . Toutant]

this should help if you use Ms6.4 and above
http://mapserver.org/fr/mapfile/expressions.html#list-expressions





Ahmet Temiz @lists.osgeo.org 
Envoyé par : "mapserver-users" 
2016-09-22 12:20

A
mapserver-users 
cc

Objet
[mapserver-users] Wms filter expressions with 'or'








Hi,

Using cgi runtime substitution for filtering, how can I construct 
necessary expressions that has in Jeo="a" or Jeo="b" or Jeo="c" form for 
wms and also mapserver' is filter expression.

Can you make any suggestions?

Regards


-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu




Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Union Layer

[Steve . Toutant]

At the layer metadata (this setting can also be set at the web metadata 
level)
http://mapserver.org/ogc/wms_server.html#layer-object-metadata





pe_lord @lists.osgeo.org 
Envoyé par : "mapserver-users" 
2016-06-29 08:57

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] Union Layer








I'm using Mapserver 6.4.2 on ubuntu server

I make an union layer.
The source layer share the same attributes and are based on 2 postgis
connection.

Here's my problem, or the expected behavior I expect from this feature.

I'm setting my union layer STATUS ON
I set source(s) layer STATUS OFF

I'm expecting the source(s) layer not be shown in the GetCapabilities,
however, the source(s) layer are shown? 

Is it normal? I can post my mapfile if it is a real issue.

Is it similar on Mapserver 7?




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Union-Layer-tp5273957.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Union Layer

[Steve . Toutant]

You could disabled GetCapabilities for the source layer
"wms_enable_request" "!GetCapabilities"

http://mapserver.org/ogc/wms_server.html




pe_lord @lists.osgeo.org 
Envoyé par : "mapserver-users" 
2016-06-29 08:57

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] Union Layer








I'm using Mapserver 6.4.2 on ubuntu server

I make an union layer.
The source layer share the same attributes and are based on 2 postgis
connection.

Here's my problem, or the expected behavior I expect from this feature.

I'm setting my union layer STATUS ON
I set source(s) layer STATUS OFF

I'm expecting the source(s) layer not be shown in the GetCapabilities,
however, the source(s) layer are shown? 

Is it normal? I can post my mapfile if it is a real issue.

Is it similar on Mapserver 7?




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Union-Layer-tp5273957.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE OGR csv - no field names

[Steve . Toutant]

I don't know why LABELITEM 'filed_3' would not work in your case

You can try to specify column names by using a  .csvt file
http://www.gdal.org/drv_csv.html

Example: 
https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/







Ian Walberg @lists.osgeo.org 
Envoyé par : "mapserver-users" 
2016-04-23 22:50

A
"mapserver-users@lists.osgeo.org" 
cc

Objet
[mapserver-users] OGR csv - no field names








Folks,

Can a csv file with no field names as the first row be used as an OGR 
source?

GDAL creates dummy field names, are these passed to mapserver?

OGRFeature(USA-Hilton):652
  field_1 (String) = -74.16958
  field_2 (String) =  40.73526
  field_3 (String) =  Penn Station

What do we need in the layer to make this work?

LABELITEM 'name' - this throws an error, 'field_3' does not seem to work 
either.
CONNECTIONTYPE OGR
CONNECTION 'Stations.csv'

Thanks

Ian
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Mapfile, EXPRESSION for CLASS >> NAME

[Steve . Toutant]

Perhaps you can use CLASS TITLE instead of NAME





"Basques, Bob (CI-StPaul)" @lists.osgeo.org 
Envoyé par : "mapserver-users" 
2016-03-25 16:44

A
"mapserver-users@lists.osgeo.org" 
cc

Objet
[mapserver-users] Mapfile, EXPRESSION for CLASS >> NAME








All, 

I think I?m trying to be too clever . . .

I have this MAPFILE chunk:

CLASS
COLOR 0 255 0
OUTLINECOLOR 0 0 0
  SIZE 10
  SYMBOL 'circle' 
NAME '[FOLDERTYPE]'
TEXT '[FOLDERTYPE]'
  LABEL
FORCE TRUE
COLOR 255 255 0
OUTLINECOLOR 0 0 0
POSITION ur
TYPE TRUETYPE
FONT 'arial-bold'
SIZE 11
  END
END


and I?m trying to use an Expression for the Label in the Legend graphic. 
The FOLDERTYPE and is the two later code for map labels, while the 
FOLDERDESC is the long pretty name for the Legend.



Question, is it possible??  Ideas??  Before you say a separate class for 
each one, there are 120 FOLDERTYPEs in all, that would be a big, and hard 
to maintain Mapfile.

thanks

bobb



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Mapserver 7 expression

[Steve . Toutant]

And this EXPRESSION {pluie,bruine}
will be true for this string attribute "pluie verglaçante"

It seems that there is a problem when there is a space in the string 
attribute





steve.tout...@inspq.qc.ca@lists.osgeo.org 
Envoyé par : "mapserver-users" 
2016-02-16 14:57

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] Mapserver 7 expression








Following this documentation 
http://mapserver.org/fr/mapfile/expressions.html#list-expressions 
I created the class expression 
EXPRESSION {pluie,bruine verglacante } 

My problem is that this expression return true when the string attribute 
is "pluie verglacante" 

I would expect only "pluie" and "bruine verglacante" to be catched by this 
expression... 
How does list expressions work? 
thanks 
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Mapserver 7 expression

[Steve . Toutant]

Following this documentation 
http://mapserver.org/fr/mapfile/expressions.html#list-expressions
I created the class expression
EXPRESSION {pluie,bruine verglacante }

My problem is that this expression return true when the string attribute 
is "pluie verglacante"

I would expect only "pluie" and "bruine verglacante" to be catched by this 
expression...
How does list expressions work?
thanks


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Inconsistance between display and data

[Steve . Toutant]

Maybe bad layer projection parameters ...
This railway might no be in the projection you think it is





jeansomers @lists.osgeo.org 
Envoyé par : "mapserver-users" 
2016-02-16 08:15

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] Inconsistance between display and data








Hi,
I'm one of two base map administrators for a MapServer web-based
application.

We're regularly integrating new base map data, from reception through
quality check to real integration.

A while ago, I noticed a base map inconsistance: the map displayed a 
railway
following the coast in a small peninsula.

I can tell there is no railway there, I already went to the place. That's
the beginning.

So I asked for a correction from the regional administrator, which 
delivered
me a new version of the local data.

I checked a last time and discovered that the railway was still on the
MapServer application.

I loaded the original data in QGIS,  applied the usual symbology : no
railway.
I checked the attributes: no railway values in the symbology field.

My colleague suggested it came from an overlapping data: we checked the 
tile
indexes of neighbouring data; none was overlapping on the railway tracks.

There we are, without a clue about the origin of this inconsistance.

I forgot to mention that we repeatedly deleted application and client 
caches
inbetween.

So if you have any idea where it can com from, your suggestions are
welcomed.

For your notice, here is the print screen of the issue

 



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Inconsistance-between-display-and-data-tp5250812.html

Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE compiling mapserver on ubuntu server

[Steve . Toutant]

Mapserver doc
http://mapserver.org/installation/unix.html




pedrocostaa...@sapo.pt@lists.osgeo.org 
Envoyé par : "mapserver-users" 
2016-02-04 10:11

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] compiling mapserver on ubuntu server








Hi guys,

I want install last mapserver stable release (7) on ubuntu server.
Current there are no repo with binaries right?
Can someone point to me a good tutorial for compiling?

Thanks

 ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Is EXTENT on LAYER necessary for WFS with PostGIS

[Steve . Toutant]

That happened to me,  for some reason the extent could not be computed by 
MS and it must be specified. 
But I can't tell what was the problem exactly. I have many other wfs on PG 
and the extent is well computed.
If you have several layers in your mapfile,try to identify the layer that 
causes the problem, make sure the syntax is ok.





"Lime, Steve D (MNIT)" @lists.osgeo.org 
Envoyé par : "mapserver-users" 
2015-12-30 17:42

A
Michal Seidl , "mapserver-users@lists.osgeo.org" 

cc

Objet
Re: [mapserver-users] Is EXTENT on LAYER necessary for WFS with PostGIS








It's not required, we have pg-based WFS services that run without that 
element. I believe you could see a performance boost under certain 
conditions if it doesn't have to be computed (e.g. large databases). 
--Steve

-Original Message-
From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org] On 
Behalf Of Michal Seidl
Sent: Tuesday, December 29, 2015 5:14 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Is EXTENT on LAYER necessary for WFS with 
PostGIS

Hello,
It looks like EXTENT parameter is necessary on LAYER level when trying to
get data as WFS from PostGIS with CONNECTION postgis driver. The problem 
is
that data in DB is changing and how to update mapfile?

Thanks Michal



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Is-EXTENT-on-LAYER-necessary-for-WFS-with-PostGIS-tp5243162.html

Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Cascaded WMS GetFeatureInfo

[Steve . Toutant]

Cora have you read this?
http://mapserver.org/ogc/wms_server.html#cascading-wms-request
It might help to know why a layer is not cascaded

What happen if you don't modify the style?
steve
 





"Berger, Cora" @lists.osgeo.org 
Envoyé par : "mapserver-users" 
2015-10-27 04:01

A
"'mapserver-users@lists.osgeo.org'" 
cc

Objet
[mapserver-users] Cascaded WMS GetFeatureInfo








Hello everybody,
I am building a cascaded WMS. My layers all have connectiontype WMS and 
all of them use one layer of the same WMS as source. The only thing I 
change is the style of the original WMS. 
My problem is that the GetFeatureInfo does not cascade. I am using 
Mapserver 7.0. I read that the GetFeatureInfo request supports cascading. 
All requests are enabled in the metadata. Do I have to add a special tag 
in the metatada or layer section to "pass through" the GetFeatureInfo from 
the original WMS?

Thanks for your help.

Best regards

Cora Berger
   

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] Re: ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Steve . Toutant]

Good idea we use POST, but I tried using GET and I still get 
FLTLayerApplyPlainFilterToLayer():  ([NOM_STAT] =*Anto) in the log 
(with postgis and oracle)




Michael Smith michael.smith.e...@gmail.com 
2015-07-22 12:02

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
cc

Objet
Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle








Only other thing I can think of are you doing a GET or POST? I'm doing 
GET. 

Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

On Jul 22, 2015, at 11:42 AM, steve.tout...@inspq.qc.ca wrote:

12C 



Michael Smith michael.smith.e...@gmail.com 
2015-07-22 11:36 


A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org 
Objet
Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle










What version of Oracle? Not that we have any version dependencies in the 
regexp code. 

I'm running 11.2 and 12.1. 

Michael Smith 
Remote Sensing/GIS Center 
US Army Corps of Engineers 

On Jul 22, 2015, at 11:30 AM, steve.tout...@inspq.qc.ca wrote:

oracle and postgis are on 2 differents servers physically on 2 cities, 
both has a mapserver installation made by 2 different person. One is on 
debian, and other on fedora 
There are using ms7 since other new wfs improvement made in MS7 are 
used... 



Michael Smith michael.smith.e...@gmail.com 
2015-07-22 11:22 


A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org 
Objet
Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle












Could you be hitting an old installed version?

Michael Smith 
Remote Sensing/GIS Center 
US Army Corps of Engineers 

On Jul 22, 2015, at 11:14 AM, steve.tout...@inspq.qc.ca wrote:

We are on linux as well. 
Ms7+ postgis.. it doesn't translate the query to regex, I have the same 
query than with Oracle... ([NOM_STAT] =*Anto) 


Well...I'm more confused now...It doesn't make sens that our MS doesn't 
generate the same request... 
Can it be an installation problem, an option is missing when compiling? 


Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:55 


A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org 
Objet
Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle














Just tried with latest master (sha 
f13cd8825e117b09663bb325a03854c27e9cdd39) and got correct REGEXP_LIKE sql. 
Was using rel-7-0-0-beta1 before. Both same. 

I'm running on Linux although can't see how that would change the sql 
being generated. 

 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil 


From: mapserver-users-boun...@lists.osgeo.org on behalf of 
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:44 AM
To: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org, 
mapserver-users-boun...@lists.osgeo.org 
mapserver-users-boun...@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves 
like PropertyIsLike with oracle
Resent-From: Michael Smith michael.sm...@usace.army.mil 

using MapServer version 7.0.0-beta1 

steve.tout...@inspq.qc.ca@lists.osgeo.org
Envoyé par : mapserver-users-boun...@lists.osgeo.org 
2015-07-22 09:43 


A
Michael Smith michael.smith.e...@gmail.com 
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle
















CONNECTIONTYPE oraclespatial
DATA GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR 
FROM D_DEB) = 2015) USING SRID 4326 

Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:38 


A
steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle


















Same result with 1.1.0 

Are you using an CONNECTIONTYPE oraclespatial or a CONNECTIONTYPE OGR to 
Oracle?

Mike 

 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil 



From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:34 AM
To: Michael Smith michael.smith.e...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle

Michael we are using MS7 master and WFS 1.1.0
Can you try with this wfs version instead of 2.0 t osee if you get the 
same results? 

Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:32 


A
steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle




















When I do this on my system 

Re: [mapserver-users] [EXTERNAL] Re: ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Steve . Toutant]

We are on linux as well.
Ms7+ postgis.. it doesn't translate the query to regex, I have the same 
query than with Oracle... ([NOM_STAT] =*Anto)


Well...I'm more confused now...It doesn't make sens that our MS doesn't 
generate the same request...
Can it be an installation problem, an option is missing when compiling?





Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:55

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
Objet
Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle








Just tried with latest master (sha 
f13cd8825e117b09663bb325a03854c27e9cdd39) and got correct REGEXP_LIKE sql. 
Was using rel-7-0-0-beta1 before. Both same.

I'm running on Linux although can't see how that would change the sql 
being generated.


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From: mapserver-users-boun...@lists.osgeo.org on behalf of 
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:44 AM
To: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org, 
mapserver-users-boun...@lists.osgeo.org 
mapserver-users-boun...@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves 
like PropertyIsLike with oracle
Resent-From: Michael Smith michael.sm...@usace.army.mil

using MapServer version 7.0.0-beta1 



steve.tout...@inspq.qc.ca@lists.osgeo.org
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-07-22 09:43 


A
Michael Smith michael.smith.e...@gmail.com
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle










CONNECTIONTYPE oraclespatial
DATA GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR 
FROM D_DEB) = 2015) USING SRID 4326


Michael Smith michael.smith.e...@gmail.com
2015-07-22 09:38 


A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle












Same result with 1.1.0 

Are you using an CONNECTIONTYPE oraclespatial or a CONNECTIONTYPE OGR to 
Oracle?

Mike 

 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil 



From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:34 AM
To: Michael Smith michael.smith.e...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle

Michael we are using MS7 master and WFS 1.1.0
Can you try with this wfs version instead of 2.0 t osee if you get the 
same results?

Michael Smith michael.smith.e...@gmail.com
2015-07-22 09:32 


A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle














When I do this on my system I get

request: 
service=WFSversion=2.0.0request=GetFeaturetypeNames=gridws_pointcloudFilter=FilterPropertyIsEqualto%20MatchCase=FALSEPropertyNameFILE_NAME/PropertyNameLiteraltest2.las/Literal/PropertyIsEqualTo/Filter

[Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison
[Wed Jul 22 09:26:31 2015].885676 closing RE comparison
[Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was 
called.
[Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using 
this Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME, 
DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, DOWNLOAD_URL, 
SENSOR_NAME, rownum, geom WHERE  ( REGEXP_LIKE( FILE_NAME, 'test2.las','i' 
 ) )  AND SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') 
= 'TRUE'

This shows that its translating the PropertyIsEqualTo with MatchCase false 
to a regexp_like case insensitive query with no wildcards. Not sure why 
you wouldn't get the same thing.

Mike


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:13 AM
To: Michael Smith michael.smith.e...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle

Thanks for your help, here is the log
Steve
ul 22 08:14:09 2015].892715 msOracleSpatialLayerWhichShapes. Bind values: 
srid:4326 minx:-91.320741 miny:41.948470 maxx:-45.679259 maxy:63.664769
[Wed Jul 22 08:14:09 2015].894113 msOracleSpatialLayerWhichShapes bind by 
name and object.
[Wed Jul 22 08:14:09 2015].894134 msOracleSpatialLayerWhichShapes name and 
object now bound.
[Wed Jul 22 08:14:10 2015].77889 mapserv request processing time 
(msLoadMap not incl.): 0.203s
[Wed Jul 22 08:14:10 2015].77903 msOracleSpatialLayerClose was called. 
Layer: 0x1308650, Layer name: 

Re: [mapserver-users] [EXTERNAL] Re: ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Steve . Toutant]

Maybe this can help regarding our installion option
MapServer version 7.0.0-beta1 OUTPUT=PNG OUTPUT=JPEG SUPPORTS=PROJ 
SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=CAIRO SUPPORTS=ICONV 
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER 
SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=FASTCGI SUPPORTS=GEOS 
INPUT=JPEG INPUT=POSTGIS INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL 
INPUT=SHAPEFILE 




Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:55

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
Objet
Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle








Just tried with latest master (sha 
f13cd8825e117b09663bb325a03854c27e9cdd39) and got correct REGEXP_LIKE sql. 
Was using rel-7-0-0-beta1 before. Both same.

I'm running on Linux although can't see how that would change the sql 
being generated.


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From: mapserver-users-boun...@lists.osgeo.org on behalf of 
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:44 AM
To: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org, 
mapserver-users-boun...@lists.osgeo.org 
mapserver-users-boun...@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves 
like PropertyIsLike with oracle
Resent-From: Michael Smith michael.sm...@usace.army.mil

using MapServer version 7.0.0-beta1 



steve.tout...@inspq.qc.ca@lists.osgeo.org
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-07-22 09:43 


A
Michael Smith michael.smith.e...@gmail.com
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle










CONNECTIONTYPE oraclespatial
DATA GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR 
FROM D_DEB) = 2015) USING SRID 4326


Michael Smith michael.smith.e...@gmail.com
2015-07-22 09:38 


A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle












Same result with 1.1.0 

Are you using an CONNECTIONTYPE oraclespatial or a CONNECTIONTYPE OGR to 
Oracle?

Mike 

 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil 



From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:34 AM
To: Michael Smith michael.smith.e...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle

Michael we are using MS7 master and WFS 1.1.0
Can you try with this wfs version instead of 2.0 t osee if you get the 
same results?

Michael Smith michael.smith.e...@gmail.com
2015-07-22 09:32 


A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle














When I do this on my system I get

request: 
service=WFSversion=2.0.0request=GetFeaturetypeNames=gridws_pointcloudFilter=FilterPropertyIsEqualto%20MatchCase=FALSEPropertyNameFILE_NAME/PropertyNameLiteraltest2.las/Literal/PropertyIsEqualTo/Filter

[Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison
[Wed Jul 22 09:26:31 2015].885676 closing RE comparison
[Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was 
called.
[Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using 
this Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME, 
DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, DOWNLOAD_URL, 
SENSOR_NAME, rownum, geom WHERE  ( REGEXP_LIKE( FILE_NAME, 'test2.las','i' 
 ) )  AND SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') 
= 'TRUE'

This shows that its translating the PropertyIsEqualTo with MatchCase false 
to a regexp_like case insensitive query with no wildcards. Not sure why 
you wouldn't get the same thing.

Mike


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:13 AM
To: Michael Smith michael.smith.e...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle

Thanks for your help, here is the log
Steve
ul 22 08:14:09 2015].892715 msOracleSpatialLayerWhichShapes. Bind values: 
srid:4326 minx:-91.320741 miny:41.948470 maxx:-45.679259 maxy:63.664769
[Wed Jul 22 08:14:09 2015].894113 msOracleSpatialLayerWhichShapes bind by 
name and object.
[Wed Jul 22 08:14:09 2015].894134 msOracleSpatialLayerWhichShapes name and 
object now bound.
[Wed Jul 22 08:14:10 2015].77889 mapserv request processing time 
(msLoadMap not incl.): 0.203s
[Wed Jul 22 08:14:10 

Re: [mapserver-users] [EXTERNAL] Re: ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Steve . Toutant]

oracle and postgis are on 2 differents servers physically on 2 cities, 
both has a mapserver installation made by 2 different person. One is on 
debian, and other on fedora 
There are using ms7 since other new wfs improvement made in MS7 are 
used...




Michael Smith michael.smith.e...@gmail.com 
2015-07-22 11:22

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
Objet
Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle








Could you be hitting an old installed version?

Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

On Jul 22, 2015, at 11:14 AM, steve.tout...@inspq.qc.ca wrote:

We are on linux as well. 
Ms7+ postgis.. it doesn't translate the query to regex, I have the same 
query than with Oracle... ([NOM_STAT] =*Anto) 


Well...I'm more confused now...It doesn't make sens that our MS doesn't 
generate the same request... 
Can it be an installation problem, an option is missing when compiling? 




Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:55 


A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org 
Objet
Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle










Just tried with latest master (sha 
f13cd8825e117b09663bb325a03854c27e9cdd39) and got correct REGEXP_LIKE sql. 
Was using rel-7-0-0-beta1 before. Both same. 

I'm running on Linux although can't see how that would change the sql 
being generated. 

 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil 


From: mapserver-users-boun...@lists.osgeo.org on behalf of 
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:44 AM
To: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org, 
mapserver-users-boun...@lists.osgeo.org 
mapserver-users-boun...@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves 
like PropertyIsLike with oracle
Resent-From: Michael Smith michael.sm...@usace.army.mil 

using MapServer version 7.0.0-beta1 



steve.tout...@inspq.qc.ca@lists.osgeo.org
Envoyé par : mapserver-users-boun...@lists.osgeo.org 
2015-07-22 09:43 


A
Michael Smith michael.smith.e...@gmail.com 
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle












CONNECTIONTYPE oraclespatial
DATA GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR 
FROM D_DEB) = 2015) USING SRID 4326 


Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:38 


A
steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle














Same result with 1.1.0 

Are you using an CONNECTIONTYPE oraclespatial or a CONNECTIONTYPE OGR to 
Oracle?

Mike 

 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil 



From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:34 AM
To: Michael Smith michael.smith.e...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle

Michael we are using MS7 master and WFS 1.1.0
Can you try with this wfs version instead of 2.0 t osee if you get the 
same results? 

Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:32 


A
steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle
















When I do this on my system I get

request: 
service=WFSversion=2.0.0request=GetFeaturetypeNames=gridws_pointcloudFilter=FilterPropertyIsEqualto%20MatchCase=FALSEPropertyNameFILE_NAME/PropertyNameLiteraltest2.las/Literal/PropertyIsEqualTo/Filter

[Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison
[Wed Jul 22 09:26:31 2015].885676 closing RE comparison
[Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was 
called.
[Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using 
this Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME, 
DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, DOWNLOAD_URL, 
SENSOR_NAME, rownum, geom WHERE  ( REGEXP_LIKE( FILE_NAME, 'test2.las','i' 
 ) )  AND SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') 
= 'TRUE'

This shows that its translating the PropertyIsEqualTo with MatchCase false 
to a regexp_like case insensitive query with no wildcards. Not sure why 
you wouldn't get the same thing.

Mike


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 

Re: [mapserver-users] [EXTERNAL] Re: ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Steve . Toutant]

12C




Michael Smith michael.smith.e...@gmail.com 
2015-07-22 11:36

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
Objet
Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle








What version of Oracle? Not that we have any version dependencies in the 
regexp code. 

I'm running 11.2 and 12.1. 

Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

On Jul 22, 2015, at 11:30 AM, steve.tout...@inspq.qc.ca wrote:

oracle and postgis are on 2 differents servers physically on 2 cities, 
both has a mapserver installation made by 2 different person. One is on 
debian, and other on fedora 
There are using ms7 since other new wfs improvement made in MS7 are 
used... 




Michael Smith michael.smith.e...@gmail.com 
2015-07-22 11:22 


A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org 
Objet
Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle










Could you be hitting an old installed version?

Michael Smith 
Remote Sensing/GIS Center 
US Army Corps of Engineers 

On Jul 22, 2015, at 11:14 AM, steve.tout...@inspq.qc.ca wrote:

We are on linux as well. 
Ms7+ postgis.. it doesn't translate the query to regex, I have the same 
query than with Oracle... ([NOM_STAT] =*Anto) 


Well...I'm more confused now...It doesn't make sens that our MS doesn't 
generate the same request... 
Can it be an installation problem, an option is missing when compiling? 



Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:55 


A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org 
Objet
Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle












Just tried with latest master (sha 
f13cd8825e117b09663bb325a03854c27e9cdd39) and got correct REGEXP_LIKE sql. 
Was using rel-7-0-0-beta1 before. Both same. 

I'm running on Linux although can't see how that would change the sql 
being generated. 

 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil 


From: mapserver-users-boun...@lists.osgeo.org on behalf of 
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:44 AM
To: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org, 
mapserver-users-boun...@lists.osgeo.org 
mapserver-users-boun...@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves 
like PropertyIsLike with oracle
Resent-From: Michael Smith michael.sm...@usace.army.mil 

using MapServer version 7.0.0-beta1 


steve.tout...@inspq.qc.ca@lists.osgeo.org
Envoyé par : mapserver-users-boun...@lists.osgeo.org 
2015-07-22 09:43 


A
Michael Smith michael.smith.e...@gmail.com 
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle














CONNECTIONTYPE oraclespatial
DATA GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR 
FROM D_DEB) = 2015) USING SRID 4326 

Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:38 


A
steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle
















Same result with 1.1.0 

Are you using an CONNECTIONTYPE oraclespatial or a CONNECTIONTYPE OGR to 
Oracle?

Mike 

 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil 



From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:34 AM
To: Michael Smith michael.smith.e...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle

Michael we are using MS7 master and WFS 1.1.0
Can you try with this wfs version instead of 2.0 t osee if you get the 
same results? 

Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:32 


A
steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle


















When I do this on my system I get

request: 
service=WFSversion=2.0.0request=GetFeaturetypeNames=gridws_pointcloudFilter=FilterPropertyIsEqualto%20MatchCase=FALSEPropertyNameFILE_NAME/PropertyNameLiteraltest2.las/Literal/PropertyIsEqualTo/Filter

[Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison
[Wed Jul 22 09:26:31 2015].885676 closing RE comparison
[Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was 
called.
[Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using 
this Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME, 
DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, 

Re: [mapserver-users] [EXTERNAL] Re: ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Steve . Toutant]

Sorry I only sent log with postgis.
For oracle using GET msOracleSpatialLayerTranslateFilter. String: 
 ([NOM_STAT] =*Anto) 
But the admin sent me this SQL
SELECT ID, NO_STAT_CLIM, NO_STAT_FADQ, NOM_STAT, LATI_STAT, LONG_STAT, 
ALTI_STAT, D_DEB, D_FIN, TIMB_MAJ, USAG_MAJ, rownum, GEOM_POIN FROM 
(select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB) = 2015) 
WHERE  ( REGEXP_LIKE( NOM_STAT, 'Anto','i'  ) )  AND SDO_FILTER( 
GEOM_POIN, MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') 
= 'TRUE' 

regex is there in GET and POST. 
He was confused so he retried and the SQL didn't log. Do you have this 
problem that MS logs are incomplete sometimes?
I'm sorry for that...it is translating to regex.

But he still have records when it should not
So  He launch this query directly in oracle 
select * FROM SMDVDP_STAT_METE WHERE   REGEXP_LIKE( NOM_STAT, 'Anto','i' 
 )  
And he got some records. Anto doesn't exist. The value is Antonin. This 
regex seems to be equivalent to '=', what do you think?

Now I think the problem is his oracle not MS, do you agree?




Michael Smith michael.smith.e...@gmail.com 
2015-07-22 14:13

A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
Objet
Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle








I don't get the FLTLayerApplyPlainFilterToLayer line.


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Steve . Toutant]

using MapServer version 7.0.0-beta1  





steve.tout...@inspq.qc.ca@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-07-22 09:43

A
Michael Smith michael.smith.e...@gmail.com
cc
mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle








CONNECTIONTYPE oraclespatial 
DATA GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR 
FROM D_DEB) = 2015) USING SRID 4326 



Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:38 


A
steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle










Same result with 1.1.0 

Are you using an CONNECTIONTYPE oraclespatial or a CONNECTIONTYPE OGR to 
Oracle? 

Mike 

 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil 



From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:34 AM
To: Michael Smith michael.smith.e...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle 

Michael we are using MS7 master and WFS 1.1.0
Can you try with this wfs version instead of 2.0 t osee if you get the 
same results? 


Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:32 


A
steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle












When I do this on my system I get

request: 
service=WFSversion=2.0.0request=GetFeaturetypeNames=gridws_pointcloudFilter=FilterPropertyIsEqualto%20MatchCase=FALSEPropertyNameFILE_NAME/PropertyNameLiteraltest2.las/Literal/PropertyIsEqualTo/Filter

[Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison
[Wed Jul 22 09:26:31 2015].885676 closing RE comparison
[Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was 
called.
[Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using 
this Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME, 
DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, DOWNLOAD_URL, 
SENSOR_NAME, rownum, geom WHERE  ( REGEXP_LIKE( FILE_NAME, 'test2.las','i' 
 ) )  AND SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') 
= 'TRUE'

This shows that its translating the PropertyIsEqualTo with MatchCase false 
to a regexp_like case insensitive query with no wildcards. Not sure why 
you wouldn't get the same thing.

Mike


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:13 AM
To: Michael Smith michael.smith.e...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle

Thanks for your help, here is the log
Steve
ul 22 08:14:09 2015].892715 msOracleSpatialLayerWhichShapes. Bind values: 
srid:4326 minx:-91.320741 miny:41.948470 maxx:-45.679259 maxy:63.664769
[Wed Jul 22 08:14:09 2015].894113 msOracleSpatialLayerWhichShapes bind by 
name and object.
[Wed Jul 22 08:14:09 2015].894134 msOracleSpatialLayerWhichShapes name and 
object now bound.
[Wed Jul 22 08:14:10 2015].77889 mapserv request processing time 
(msLoadMap not incl.): 0.203s
[Wed Jul 22 08:14:10 2015].77903 msOracleSpatialLayerClose was called. 
Layer: 0x1308650, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:10 2015].78084 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc,0x1481850)
[Wed Jul 22 08:14:30 2015].200042 CGI Request 38 on process 14430
[Wed Jul 22 08:14:30 2015].200197 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].200215 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc)
 
- got 0x1481850
[Wed Jul 22 08:14:30 2015].208656 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].208676 msOracleSpatialLayerGetItems was called.
[Wed Jul 22 08:14:30 2015].209323 msOracleSpatialLayerInitItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].209369 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].209374 msOracleSpatialLayerClose was called. 
Layer: 0x142bbe0, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:30 2015].209396 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc,0x1481850)
[Wed Jul 22 08:14:30 2015].210875 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].210889 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc)
 
- got 0x1481850
[Wed Jul 22 08:14:30 2015].218325 

Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Steve . Toutant]

Michael we are using MS7 master and WFS 1.1.0
Can you try with this wfs version instead of 2.0 t osee if you get the 
same results?





Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:32

A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle








When I do this on my system I get

request: 
service=WFSversion=2.0.0request=GetFeaturetypeNames=gridws_pointcloudFilter=FilterPropertyIsEqualto%20MatchCase=FALSEPropertyNameFILE_NAME/PropertyNameLiteraltest2.las/Literal/PropertyIsEqualTo/Filter

[Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison
[Wed Jul 22 09:26:31 2015].885676 closing RE comparison
[Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was 
called.
[Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using 
this Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME, 
DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, DOWNLOAD_URL, 
SENSOR_NAME, rownum, geom WHERE  ( REGEXP_LIKE( FILE_NAME, 'test2.las','i' 
 ) )  AND SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') 
= 'TRUE'

This shows that its translating the PropertyIsEqualTo with MatchCase false 
to a regexp_like case insensitive query with no wildcards. Not sure why 
you wouldn't get the same thing.

Mike


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:13 AM
To: Michael Smith michael.smith.e...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle

Thanks for your help, here is the log
Steve
 ul 22 08:14:09 2015].892715 msOracleSpatialLayerWhichShapes. Bind values: 
srid:4326 minx:-91.320741 miny:41.948470 maxx:-45.679259 maxy:63.664769
[Wed Jul 22 08:14:09 2015].894113 msOracleSpatialLayerWhichShapes bind by 
name and object.
[Wed Jul 22 08:14:09 2015].894134 msOracleSpatialLayerWhichShapes name and 
object now bound.
[Wed Jul 22 08:14:10 2015].77889 mapserv request processing time 
(msLoadMap not incl.): 0.203s
[Wed Jul 22 08:14:10 2015].77903 msOracleSpatialLayerClose was called. 
Layer: 0x1308650, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:10 2015].78084 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc,0x1481850)
[Wed Jul 22 08:14:30 2015].200042 CGI Request 38 on process 14430
[Wed Jul 22 08:14:30 2015].200197 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].200215 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc)
 
- got 0x1481850
[Wed Jul 22 08:14:30 2015].208656 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].208676 msOracleSpatialLayerGetItems was called.
[Wed Jul 22 08:14:30 2015].209323 msOracleSpatialLayerInitItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].209369 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].209374 msOracleSpatialLayerClose was called. 
Layer: 0x142bbe0, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:30 2015].209396 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc,0x1481850)
[Wed Jul 22 08:14:30 2015].210875 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].210889 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc)
 
- got 0x1481850
[Wed Jul 22 08:14:30 2015].218325 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].218345 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].218354 msOracleSpatialLayerGetItems was called.
[Wed Jul 22 08:14:30 2015].218946 msOracleSpatialLayerInitItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].218980 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].218985 msOracleSpatialLayerClose was called. 
Layer: 0x142bbe0, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:30 2015].219003 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc,0x1481850)
[Wed Jul 22 08:14:30 2015].219010 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].219018 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc)
 
- got 0x1481850
[Wed Jul 22 08:14:30 2015].225298 msOracleSpatialLayerEnablePaging was 
called.
[Wed Jul 22 08:14:30 2015].225318 

Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Steve . Toutant]

CONNECTIONTYPE oraclespatial 
DATA GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR 
FROM D_DEB) = 2015) USING SRID 4326 





Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:38

A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle








Same result with 1.1.0

Are you using an CONNECTIONTYPE oraclespatial or a CONNECTIONTYPE OGR to 
Oracle?

Mike


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil



From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:34 AM
To: Michael Smith michael.smith.e...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle

Michael we are using MS7 master and WFS 1.1.0
Can you try with this wfs version instead of 2.0 t osee if you get the 
same results?



Michael Smith michael.smith.e...@gmail.com 
2015-07-22 09:32


A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle










When I do this on my system I get

request: 
service=WFSversion=2.0.0request=GetFeaturetypeNames=gridws_pointcloudFilter=FilterPropertyIsEqualto%20MatchCase=FALSEPropertyNameFILE_NAME/PropertyNameLiteraltest2.las/Literal/PropertyIsEqualTo/Filter


[Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison
[Wed Jul 22 09:26:31 2015].885676 closing RE comparison
[Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was 
called.
[Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using 
this Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME, 
DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, DOWNLOAD_URL, 
SENSOR_NAME, rownum, geom WHERE  ( REGEXP_LIKE( FILE_NAME, 'test2.las','i' 
 ) )  AND SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') 
= 'TRUE'

This shows that its translating the PropertyIsEqualTo with MatchCase false 
to a regexp_like case insensitive query with no wildcards. Not sure why 
you wouldn't get the same thing.

Mike


Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From: steve.tout...@inspq.qc.ca
Date: Wednesday, July 22, 2015 at 9:13 AM
To: Michael Smith michael.smith.e...@gmail.com
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle

Thanks for your help, here is the log
Steve
ul 22 08:14:09 2015].892715 msOracleSpatialLayerWhichShapes. Bind values: 
srid:4326 minx:-91.320741 miny:41.948470 maxx:-45.679259 maxy:63.664769
[Wed Jul 22 08:14:09 2015].894113 msOracleSpatialLayerWhichShapes bind by 
name and object.
[Wed Jul 22 08:14:09 2015].894134 msOracleSpatialLayerWhichShapes name and 
object now bound.
[Wed Jul 22 08:14:10 2015].77889 mapserv request processing time 
(msLoadMap not incl.): 0.203s
[Wed Jul 22 08:14:10 2015].77903 msOracleSpatialLayerClose was called. 
Layer: 0x1308650, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:10 2015].78084 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc,0x1481850)
[Wed Jul 22 08:14:30 2015].200042 CGI Request 38 on process 14430
[Wed Jul 22 08:14:30 2015].200197 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].200215 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc)
 
- got 0x1481850
[Wed Jul 22 08:14:30 2015].208656 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].208676 msOracleSpatialLayerGetItems was called.
[Wed Jul 22 08:14:30 2015].209323 msOracleSpatialLayerInitItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].209369 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].209374 msOracleSpatialLayerClose was called. 
Layer: 0x142bbe0, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:30 2015].209396 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc,0x1481850)
[Wed Jul 22 08:14:30 2015].210875 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].210889 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc)
 
- got 0x1481850
[Wed Jul 22 08:14:30 2015].218325 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].218345 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].218354 msOracleSpatialLayerGetItems was called.
[Wed Jul 22 08:14:30 

Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Steve . Toutant]

Thanks for your help, here is the log
Steve
 ul 22 08:14:09 2015].892715 msOracleSpatialLayerWhichShapes. Bind values: 
srid:4326 minx:-91.320741 miny:41.948470 maxx:-45.679259 maxy:63.664769
[Wed Jul 22 08:14:09 2015].894113 msOracleSpatialLayerWhichShapes bind by 
name and object.
[Wed Jul 22 08:14:09 2015].894134 msOracleSpatialLayerWhichShapes name and 
object now bound.
[Wed Jul 22 08:14:10 2015].77889 mapserv request processing time 
(msLoadMap not incl.): 0.203s
[Wed Jul 22 08:14:10 2015].77903 msOracleSpatialLayerClose was called. 
Layer: 0x1308650, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:10 2015].78084 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc,0x1481850)
[Wed Jul 22 08:14:30 2015].200042 CGI Request 38 on process 14430
[Wed Jul 22 08:14:30 2015].200197 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].200215 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc)
 
- got 0x1481850
[Wed Jul 22 08:14:30 2015].208656 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].208676 msOracleSpatialLayerGetItems was called.
[Wed Jul 22 08:14:30 2015].209323 msOracleSpatialLayerInitItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].209369 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].209374 msOracleSpatialLayerClose was called. 
Layer: 0x142bbe0, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:30 2015].209396 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc,0x1481850)
[Wed Jul 22 08:14:30 2015].210875 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].210889 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc)
 
- got 0x1481850
[Wed Jul 22 08:14:30 2015].218325 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].218345 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].218354 msOracleSpatialLayerGetItems was called.
[Wed Jul 22 08:14:30 2015].218946 msOracleSpatialLayerInitItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].218980 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].218985 msOracleSpatialLayerClose was called. 
Layer: 0x142bbe0, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:30 2015].219003 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc,0x1481850)
[Wed Jul 22 08:14:30 2015].219010 msOracleSpatialLayerOpen called with: 
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM 
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)
[Wed Jul 22 08:14:30 2015].219018 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*@DATABASE:1521/DEV.fadq.qc)
 
- got 0x1481850
[Wed Jul 22 08:14:30 2015].225298 msOracleSpatialLayerEnablePaging was 
called.
[Wed Jul 22 08:14:30 2015].225318 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].225328 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].225334 msOracleSpatialLayerGetItems was called.
[Wed Jul 22 08:14:30 2015].225868 msOracleSpatialLayerInitItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].225892 msOracleSpatialLayerInitItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].226421 msOracleSpatialLayerTranslateFilter. 
String: ([NOM_STAT] =*Anto)
[Wed Jul 22 08:14:30 2015].226429 msOracleSpatialLayerTranslateFilter. 
There are tokens to process
[Wed Jul 22 08:14:30 2015].226435 got a IEQ comparison
[Wed Jul 22 08:14:30 2015].226440 closing RE comparison
[Wed Jul 22 08:14:30 2015].226444 msOracleSpatialLayerWhichShapes was 
called.
[Wed Jul 22 08:14:30 2015].226470 msOracleSpatialLayerWhichShapes. Us





Michael Smith michael.smith.e...@gmail.com 
2015-07-21 11:24

A
steve.tout...@inspq.qc.ca, mapserver-users@lists.osgeo.org
cc

Objet
Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike 
with oracle








Steve,

When a case insensitive exact match is used,  the code should use a 
regexp_like constructor in Oracle with the case insensitive flag and an 
exact pattern.

Can you do DEBUG 3 and show the log?

Mike

-- 
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

From: mapserver-users-boun...@lists.osgeo.org on behalf of 
steve.tout...@inspq.qc.ca
Date: Tuesday, July 21, 2015 at 10:07 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] ogc:PropertyIsEqualTo behaves like 
PropertyIsLike with oracle

Hi,
Using MS7+oracle, I apply a wfs filter PropertyIsEqualTo on a layer 
attribute (string) with a truncated string, so it should returns 0 
features, but it returns 1 feature.
The 

[mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Steve . Toutant]

Hi,
Using MS7+oracle, I apply a wfs filter PropertyIsEqualTo on a layer 
attribute (string) with a truncated string, so it should returns 0 
features, but it returns 1 feature.
The complete value is Antonin. I apply the filter using Anto


MS7+Postgis
wfs:Query typeName=feature:SMDVDP_STAT_METE 
srsName=EPSG:3857ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ogc:PropertyIsEqualTo 
matchCase=falseogc:PropertyNameNOM_STAT/ogc:PropertyNameogc:Literal
Anto/ogc:Literal/ogc:PropertyIsEqualTo/ogc:Filter/wfs:Query
numberOfFeatures=0 , that is ok.
Ms log: FLTLayerApplyPlainFilterToLayer():  ([NOM_STAT] =*Anto)

Ms7+Oracle
wfs:Query typeName=feature:SMDVDP_STAT_METE 
srsName=EPSG:32198ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ogc:PropertyIsEqualTo 
matchCase=falseogc:PropertyNameNOM_STAT/ogc:PropertyNameogc:Literal
Anto/ogc:Literal/ogc:PropertyIsEqualTo/ogc:Filter/wfs:Query
numberOfFeatures=1 , BAD
Mslog: msOracleSpatialLayerTranslateFilter. String: ([NOM_STAT] 
=*Anto) 

Is the problem MS o oracle? Should I open a Ms bug?
Regards!

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE GetFeatureInfo on an WFS-Client-Layer

[Steve . Toutant]

GetFeatureInfo is a WMS request, not WFS.
More details would help, to help..




Jörg Thomsen j...@mapmedia.de@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-06-01 11:20
Veuillez répondre à
j...@mapmedia.de


A
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] GetFeatureInfo on an WFS-Client-Layer








Hi,

I am confused, does GetFeatureInfo on an WFS-Client-Layer work?
The Capablites say the layer ist queryable, but the request-answer ist
'no object fond'.

Jörg


-- 
~~~
Aufwind durch Wissen!

Qualifizierte Open Source Schulungen bei der
http://www.foss-akademie.de/
~~~


_

MapMedia
Kartographie und raumbezogene Informationssysteme

Gillweg 3, 14193 Berlin
fon: +49 30 89 06 82-70
fax: +49 30 89 09 53-21
mail: j...@mapmedia.de
net:  www.mapmedia.de
_


Geschäftsführer: G. v. Tschirnhaus, J. Thomsen, P. Stamm
Registergericht, Berlin - Amtsgericht Charlottenburg,
HRB 89625, Umsatzsteuer-Identnummer: DE 813794062
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE GetFeatureInfo on an WFS-Client-Layer

[Steve . Toutant]

I'm confused , do you mean that you have a WFS layer that you want to 
publish as a WMS?
Could you send the layer definition of your mapfile?
Also have a look at TEMPLATE and DUMP in the layer def






Jörg Thomsen j...@mapmedia.de@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-06-02 08:51
Veuillez répondre à
j...@mapmedia.de


A
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
cc

Objet
Re: [mapserver-users] RE  GetFeatureInfo on an WFS-Client-Layer








Hello  Steve,

Am 02.06.2015 um 14:08 schrieb steve.tout...@inspq.qc.ca:
 GetFeatureInfo is a WMS request, not WFS.
 More details would help, to help..

 I am confused, does GetFeatureInfo on an WFS-Client-Layer work?
 The Capablites say the layer ist queryable, but the request-answer ist
 'no object fond'.

you are right. But my problem is a WFS-*client* Layer: My datasource is
a WFS and I want to provide a WMS. GetMap works on that wms-Layer, but
not GetFeatureInfo. GetFeatureInfo is enabled, but the answer is always
'no object found'.

I would like to know if this generally should work, because I think
mapserver only requests the gml temporarily to render the map and then
there is no geodata for answering a later featureinfo-request.

I tested with 6.4

Jörg
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Setting up many vitual hosts

[Steve . Toutant]

Jacques it is possible to create many virtual host on apache, but what do 
you mean by add my data in a new virtual host. The virtual hosts can use 
the same mapserverUnless you want to have several instance of 
mapserver...?






Mérette,Jacques (Consultant) jacques.merett...@mtq.gouv.qc.ca 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-05-26 18:11

A
'mapserver-users@lists.osgeo.org' mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] Setting up many vitual hosts








Hi, 

I?m installing Mapserver for the first time. The demo works fine on RHEL 
but I would like to add my data in a new virtual host. Is it possible to 
set up many vitual hosts on Apache/Mapserver?

Merci!
Jacques Mérette
Architecte technologique 
Division des infrastructures technologiques
Service des infrastructures technologiques appliquées aux opérations
Direction des technologies de l?information
Ministère des Transports du Québec 
Tél: 418-643-5350 # 24685
jacques.merett...@mtq.gouv.qc.ca
 
Boîte commune : architectes-technologique._c-...@mtq.gouv.qc.ca
 ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE Setting up many vitual hosts

[Steve . Toutant]

easy yes...
I suggest you read this, so you can choose your preferred method to do 
what you want
http://mapserver.org/ogc/wms_server.html#changing-the-online-resource-url

we use this method
http://mapserver.org/ogc/wms_server.html#wrapper-script-unix

But I just read that it is not recommended.




Mérette,Jacques (Consultant) jacques.merett...@mtq.gouv.qc.ca 
2015-05-27 09:47

A
'steve.tout...@inspq.qc.ca' steve.tout...@inspq.qc.ca
cc
'mapserver-users@lists.osgeo.org' mapserver-users@lists.osgeo.org, 
mapserver-users-boun...@lists.osgeo.org 
mapserver-users-boun...@lists.osgeo.org
Objet
RE: RE [mapserver-users] Setting up many vitual hosts








Bonjour Steve,
 
Excellent?.
I want to have only one instance of mapserver bit many virtual hosts on 
Apache. Each virtual host will have its own ?mapfile? (that is what I mean 
by ?add my data in a new virtual host?).  Following my understanding, it 
should be quite easy?.
 
MErci!
J.
 
From: steve.tout...@inspq.qc.ca [mailto:steve.tout...@inspq.qc.ca] 
Sent: 27 mai 2015 08:27
To: Mérette, Jacques (Consultant)
Cc: 'mapserver-users@lists.osgeo.org'; 
mapserver-users-boun...@lists.osgeo.org
Subject: RE [mapserver-users] Setting up many vitual hosts
 
Jacques it is possible to create many virtual host on apache, but what do 
you mean by add my data in a new virtual host. The virtual hosts can use 
the same mapserverUnless you want to have several instance of 
mapserver...? 



Mérette,Jacques (Consultant) jacques.merett...@mtq.gouv.qc.ca 
Envoyé par : mapserver-users-boun...@lists.osgeo.org 
2015-05-26 18:11 


A
'mapserver-users@lists.osgeo.org' mapserver-users@lists.osgeo.org 
cc

Objet
[mapserver-users] Setting up many vitual hosts
 










Hi, 

I?m installing Mapserver for the first time. The demo works fine on RHEL 
but I would like to add my data in a new virtual host. Is it possible to 
set up many vitual hosts on Apache/Mapserver?

Merci! 
Jacques Mérette 
Architecte technologique 
Division des infrastructures technologiques 
Service des infrastructures technologiques appliquées aux opérations 
Direction des technologies de l?information 
Ministère des Transports du Québec 
Tél: 418-643-5350 # 24685 
jacques.merett...@mtq.gouv.qc.ca 
  
Boîte commune : architectes-technologique._c-...@mtq.gouv.qc.ca 
 ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users 



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE Setting up many vitual hosts

[Steve . Toutant]

And if you need to do some stuff before making the request, a wrapper 
might a good solution 
http://mapserver.org/ogc/mapscript.html#php-example

it could be plain php also instead of mapscript.
And you can send the ows parameters as POST

Really there are several ways to do what you want




Mérette,Jacques (Consultant) jacques.merett...@mtq.gouv.qc.ca 
2015-05-27 09:47

A
'steve.tout...@inspq.qc.ca' steve.tout...@inspq.qc.ca
cc
'mapserver-users@lists.osgeo.org' mapserver-users@lists.osgeo.org, 
mapserver-users-boun...@lists.osgeo.org 
mapserver-users-boun...@lists.osgeo.org
Objet
RE: RE [mapserver-users] Setting up many vitual hosts








Bonjour Steve,
 
Excellent?.
I want to have only one instance of mapserver bit many virtual hosts on 
Apache. Each virtual host will have its own ?mapfile? (that is what I mean 
by ?add my data in a new virtual host?).  Following my understanding, it 
should be quite easy?.
 
MErci!
J.
 
From: steve.tout...@inspq.qc.ca [mailto:steve.tout...@inspq.qc.ca] 
Sent: 27 mai 2015 08:27
To: Mérette, Jacques (Consultant)
Cc: 'mapserver-users@lists.osgeo.org'; 
mapserver-users-boun...@lists.osgeo.org
Subject: RE [mapserver-users] Setting up many vitual hosts
 
Jacques it is possible to create many virtual host on apache, but what do 
you mean by add my data in a new virtual host. The virtual hosts can use 
the same mapserverUnless you want to have several instance of 
mapserver...? 



Mérette,Jacques (Consultant) jacques.merett...@mtq.gouv.qc.ca 
Envoyé par : mapserver-users-boun...@lists.osgeo.org 
2015-05-26 18:11 


A
'mapserver-users@lists.osgeo.org' mapserver-users@lists.osgeo.org 
cc

Objet
[mapserver-users] Setting up many vitual hosts
 










Hi, 

I?m installing Mapserver for the first time. The demo works fine on RHEL 
but I would like to add my data in a new virtual host. Is it possible to 
set up many vitual hosts on Apache/Mapserver?

Merci! 
Jacques Mérette 
Architecte technologique 
Division des infrastructures technologiques 
Service des infrastructures technologiques appliquées aux opérations 
Direction des technologies de l?information 
Ministère des Transports du Québec 
Tél: 418-643-5350 # 24685 
jacques.merett...@mtq.gouv.qc.ca 
  
Boîte commune : architectes-technologique._c-...@mtq.gouv.qc.ca 
 ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users 



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

[Steve . Toutant]

It seems to be a bug isn't?
Do you want me to open an issue?



Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil 
2015-05-19 12:24

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
cc
Rahkonen Jukka (MML) jukka.rahko...@maanmittauslaitos.fi, 
MapserverList OSGEO mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature 
with filter on numeric field






It looks like whats happening is that?s being converted into 3 Tokens and 
the oracle driver converts it into a number + comma + number. 

The tokenizer is not treating that value as a single value. 

Mike

From: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date: Tuesday, May 19, 2015 at 11:44 AM
To: Michael Smith michael.sm...@erdc.dren.mil
Cc: Rahkonen Jukka (MML) jukka.rahko...@maanmittauslaitos.fi, 
MapserverList OSGEO mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

here is the mapserver log with ogc:PropertyIsEqualTo 
matchCase=trueogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61,8031/ogc:Literal/ogc:PropertyIsEqualTo


msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: 
SELECT ID, NO_STAT_CLIM, NO_STAT_FADQ, NOM_STAT, LATI_STAT, LONG_STAT, 
ALTI_STAT, D_DEB, D_FIN, TIMB_MAJ, USAG_MAJ, rownum, GEOM_POIN FROM 
(select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB) = 2014) 
WHERE  ( LONG_STAT = -61.00,8031.00 )  AND SDO_FILTER( GEOM_POIN, 
MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') 
= 'TRUE'


The problem is 
WHERE  ( LONG_STAT = -61.00,8031.00 )
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

[Steve . Toutant]

Is there a documentation that says that it is not?
Folks from gdal list also think that it is not supported...I guess you are 
right. But as I said on the gdal list, many countries are using a comma as 
a decimal separatorwhat other people on the planet do?
Anyway the comma is another problem that I try to manage later..

For now, We have an application that generate and launch spatial queries 
on WFS, matchCase=false by default. Before modifying the code I want to 
understand what is going on
It seems,when using numeric value, that matchCase as no impact in PostGIS, 
but it is important in oracle to be set to true

gml_type = auto, returns double in postgis and oracle, so that is fine
A WFS getFeature with the operator PropertyIsEqualTo AND matchCase=false
using this value -64.225
PostGis: it works
Oracle (from mike's test): it fails...matchCase must be set to true

A WFS getFeature with the operator PropertyIsEqualTo AND matchCase=false
using this value -64,225
PotsGis: not tested 
Oracle: it fails...matchCase must be set to true

Is there a reason why, with oracle, matchCase should be set to true when 
using numeric value, or that could be fixed?
Regards
Steve





Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil 
2015-05-14 09:17

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org, thomas bonfort 
thomas.bonf...@gmail.com
Objet
Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature 
with filter on numeric field








Its not clear to me that commas as the decimal separator is supported in 
XML/GML. I can't find any documentation to indicate that it is. Can you 
point some out to me?

In any event, I didn't test with comma decimal separators. 

Mike

 

Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date: Thursday, May 14, 2015 at 8:54 AM
To: Michael Smith michael.sm...@erdc.dren.mil
Cc: MapserverList OSGEO mapserver-users@lists.osgeo.org, thomas bonfort 
thomas.bonf...@gmail.com
Subject: Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

Thanks Mike for having a look at it. 
Your decimals are separated by a comma or a dot?




Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil 
2015-05-13 18:53 


A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca, thomas bonfort 
thomas.bonf...@gmail.com
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org
Objet
Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature 
with filter on numeric field










Steve, 

I tested this out with 7.1 with numeric type fields and it works for me as 
long as I don't use matchCase=false. That seems to kick it in to a 
string comparison. matchCase=true and just PropertyIsEqualTo work fine.

In our metadata we use gml_types   auto when the database knows the 
types and explicit declarations (eg gml_attributename_type   integer) 
when it doesn't work.

The key is that the field type has to report as a numeric type or the 
backend treats it as a string comparison.

Mike 
 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil 


From: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date: Wednesday, May 13, 2015 at 10:35 AM
To: thomas bonfort thomas.bonf...@gmail.com
Cc: MapserverList OSGEO mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs 
getFeature with filter on numeric field
Resent-From: Michael Smith michael.sm...@usace.army.mil

Precision: we are using MS7.1
Removing matchcase part makes oracle, and postgis, crash.
I have this error: 

ows:ExceptionReport xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; 
xmlns:ows=http://www.opengis.net/ows; version=1.1.0 
language=en-USxsi:schemaLocation=http://www.opengis.net/ows /a
http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd;
ows:Exception exceptionCode=NoApplicableCode locator=mapserv
ows:ExceptionText
msWFSGetFeature(): WFS server error. FLTApplyFilterToLayer() failed 
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data 
statement and server logs
/ows:ExceptionText 


The problem might be the decimals? 
Here is the request 
wfs:Query typeName=feature:SMDVDP_STAT_METE srsName=EPSG:32198
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;
ogc:PropertyIsEqualTo 
ogc:PropertyNameLONG_STAT/ogc:PropertyName
ogc:Literal-61,8031/ogc:Literal
/ogc:PropertyIsEqualTo 
/ogc:Filter 
/wfs:Query 
/wfs:GetFeature 


thomas bonfort thomas.bonf...@gmail.com 
2015-05-13 05:40


A
steve.tout...@inspq.qc.ca
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on 
numeric field












can you try the same request without the matchCase part and report
back please?

On 12 May 2015 at 18:11,  steve.tout...@inspq.qc.ca wrote:
 I 

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

[Steve . Toutant]

Thanks Mike for having a look at it.
Your decimals are separated by a comma or a dot?






Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil 
2015-05-13 18:53

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca, thomas bonfort 
thomas.bonf...@gmail.com
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org
Objet
Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature 
with filter on numeric field








Steve,

I tested this out with 7.1 with numeric type fields and it works for me as 
long as I don't use matchCase=false. That seems to kick it in to a 
string comparison. matchCase=true and just PropertyIsEqualTo work fine.

In our metadata we use gml_types   auto when the database knows the 
types and explicit declarations (eg gml_attributename_type   integer) 
when it doesn't work.

The key is that the field type has to report as a numeric type or the 
backend treats it as a string comparison.

Mike

Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date: Wednesday, May 13, 2015 at 10:35 AM
To: thomas bonfort thomas.bonf...@gmail.com
Cc: MapserverList OSGEO mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs 
getFeature with filter on numeric field
Resent-From: Michael Smith michael.sm...@usace.army.mil

Precision: we are using MS7.1 
Removing matchcase part makes oracle, and postgis, crash.
I have this error: 

ows:ExceptionReport xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; 
xmlns:ows=http://www.opengis.net/ows; version=1.1.0 
language=en-USxsi:schemaLocation=http://www.opengis.net/ows /a
http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd;
ows:Exception exceptionCode=NoApplicableCode locator=mapserv
ows:ExceptionText
msWFSGetFeature(): WFS server error. FLTApplyFilterToLayer() failed 
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data 
statement and server logs
/ows:ExceptionText 


The problem might be the decimals? 
Here is the request 
wfs:Query typeName=feature:SMDVDP_STAT_METE srsName=EPSG:32198
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;
ogc:PropertyIsEqualTo 
ogc:PropertyNameLONG_STAT/ogc:PropertyName 
ogc:Literal-61,8031/ogc:Literal 
/ogc:PropertyIsEqualTo 
/ogc:Filter 
/wfs:Query 
/wfs:GetFeature 




thomas bonfort thomas.bonf...@gmail.com 
2015-05-13 05:40 


A
steve.tout...@inspq.qc.ca 
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on 
numeric field










can you try the same request without the matchCase part and report
back please?

On 12 May 2015 at 18:11,  steve.tout...@inspq.qc.ca wrote:
 I have a problem using a FILTER in a wfs getFeature request on an oracle 
DB
 with MS7
 When I launch a getFeature request with a Filter on a numeric field it
 doesn't work,
 ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ogc:PropertyIsEqualTo
 
matchCase=falseogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61/ogc:Literal/ogc:PropertyIsEqualTo/ogc:Filter
 here is the error we get in the browser
 ows:Exception exceptionCode=NoApplicableCode locator=mapserv
ows:ExceptionTextmsWFSGetFeature(): WFS server error.
 FLTApplyFilterToLayer() failed
 msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data
 statement and server logs/ows:ExceptionText

 from mapserver logs
 [Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter.
 String:  ([LONG_STAT] =*-61)

 LONG_STAT is a NUMBER in the DB
 DescribefeatureType returns
   element name=NO_STAT_CLIM minOccurs=0 type=string/
  element name=NO_STAT_FADQ minOccurs=0 type=string/
  element name=NOM_STAT minOccurs=0 type=string/
  element name=LATI_STAT minOccurs=0 type=string/
  element name=LONG_STAT minOccurs=0 type=string/
  element name=ALTI_STAT minOccurs=0 type=string/

 I tried to add gml_types auto in the mapfile, but it still returns
 string as data type
 I tried gml_LONG_STAT_type = Integer in the mapfile, 
describeFeatureType
 returns element name=LONG_STAT minOccurs=0 type=double/  but I
 still get an error in getFeature

 I'm using CONNECTIONTYPE oraclespatial in the mapfile

 I can provide more information

 Is it a known issue or can I do something about that?

 Thank you!
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users





___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

[Steve . Toutant]

And setting it to true doesn't make more sense.
I guess it is already not used when the source is postgis

Thank you very much for your help in this
Steve





Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil 
2015-05-14 09:43

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org, thomas bonfort 
thomas.bonf...@gmail.com
Objet
Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature 
with filter on numeric field








The matchCase triggers a string comparison. matchCase doesn't seem to make 
sense for a number. 

That being said, I can look into the specific case of matchCase and a 
numeric comparison and make sire that it isn't used.

Mike

Michael Smith
US Army Corps
Remote Sensing GIS/Center
michael.sm...@usace.army.mil


From: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date: Thursday, May 14, 2015 at 9:28 AM
To: Michael Smith michael.sm...@erdc.dren.mil
Cc: MapserverList OSGEO mapserver-users@lists.osgeo.org, thomas bonfort 
thomas.bonf...@gmail.com
Subject: Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

Is there a documentation that says that it is not?
Folks from gdal list also think that it is not supported...I guess you are 
right. But as I said on the gdal list, many countries are using a comma as 
a decimal separatorwhat other people on the planet do?
Anyway the comma is another problem that I try to manage later..

For now, We have an application that generate and launch spatial queries 
on WFS, matchCase=false by default. Before modifying the code I want to 
understand what is going on
It seems,when using numeric value, that matchCase as no impact in PostGIS, 
but it is important in oracle to be set to true

gml_type = auto, returns double in postgis and oracle, so that is fine
A WFS getFeature with the operator PropertyIsEqualTo AND matchCase=false
using this value -64.225 
PostGis: it works 
Oracle (from mike's test): it fails...matchCase must be set to true

A WFS getFeature with the operator PropertyIsEqualTo AND matchCase=false
using this value -64,225 
PotsGis: not tested 
Oracle: it fails...matchCase must be set to true

Is there a reason why, with oracle, matchCase should be set to true when 
using numeric value, or that could be fixed?
Regards 
Steve 



Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil 
2015-05-14 09:17 


A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org, thomas bonfort 
thomas.bonf...@gmail.com
Objet
Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature 
with filter on numeric field










Its not clear to me that commas as the decimal separator is supported in 
XML/GML. I can't find any documentation to indicate that it is. Can you 
point some out to me?

In any event, I didn't test with comma decimal separators. 

Mike 

  
 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil 


From: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date: Thursday, May 14, 2015 at 8:54 AM
To: Michael Smith michael.sm...@erdc.dren.mil
Cc: MapserverList OSGEO mapserver-users@lists.osgeo.org, thomas bonfort 
thomas.bonf...@gmail.com
Subject: Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

Thanks Mike for having a look at it.
Your decimals are separated by a comma or a dot?


Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil 
2015-05-13 18:53


A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca, thomas bonfort 
thomas.bonf...@gmail.com
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org
Objet
Re: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature 
with filter on numeric field












Steve, 

I tested this out with 7.1 with numeric type fields and it works for me as 
long as I don't use matchCase=false. That seems to kick it in to a 
string comparison. matchCase=true and just PropertyIsEqualTo work fine.

In our metadata we use gml_types   auto when the database knows the 
types and explicit declarations (eg gml_attributename_type   integer) 
when it doesn't work.

The key is that the field type has to report as a numeric type or the 
backend treats it as a string comparison.

Mike 
 
Michael Smith 
US Army Corps 
Remote Sensing GIS/Center 
michael.sm...@usace.army.mil


From: steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date: Wednesday, May 13, 2015 at 10:35 AM
To: thomas bonfort thomas.bonf...@gmail.com
Cc: MapserverList OSGEO mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] Mapserver 7+oracle - wfs 
getFeature with filter on numeric field
Resent-From: Michael Smith michael.sm...@usace.army.mil

Precision: we are using MS7.1
Removing matchcase part makes oracle, and postgis, crash.
I have this error: 

ows:ExceptionReport 

Re: [mapserver-users] RE How to use filter encoding in MapServer in a WFS query?

[Steve . Toutant]

Add  matchCase=false for the 2 operators ogc:PropertyIsEqualTo
This will work
http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.1.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ANDogc:PropertyIsEqualTo 
matchCase=falseogc:PropertyNamecomune/ogc:PropertyNameogc:LiteralCarignano/ogc:Literal/ogc:PropertyIsEqualToogc:PropertyIsEqualTo
 
matchCase=falseogc:PropertyNamenome/ogc:PropertyNameogc:LiteralVia 
Monte Grappa/ogc:Literal/ogc:PropertyIsEqualToogc:PropertyIsLike 
matchCase=false wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNamecivico/ogc:PropertyNameogc:Literal*24*/ogc:Literal/ogc:PropertyIsLike/AND/ogc:Filter
 
 

And for civico/ogc:PropertyNameogc:Literal*24*, this might return 
several values such as 124, 241, .I think, I didn't try though



cesare gerbino cesaregerb...@gmail.com 
2015-05-13 08:05

A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org, mapserver-users-boun...@lists.osgeo.org
Objet
Re: RE [mapserver-users] How to use filter encoding in MapServer in a WFS 
query?








Hi again ... My query now it's working  I've upgrated it using AND 
logical operator ...Here you're my new query ...

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.1.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ANDogc:PropertyIsLike matchCase=false wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNamecomune/ogc:PropertyNameogc:Literal*Carignano*/ogc:Literal/ogc:PropertyIsLikeogc:PropertyIsLike
 
matchCase=false wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNamenome/ogc:PropertyNameogc:Literal*Via 
Monte Grappa*/ogc:Literal/ogc:PropertyIsLikeogc:PropertyIsLike 
matchCase=false wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNamecivico/ogc:PropertyNameogc:Literal*24*/ogc:Literal/ogc:PropertyIsLike/AND/ogc:Filter

The result is 

wfs:FeatureCollection xmlns:ms=http://mapserver.gis.umn.edu/mapserver
 xmlns:gml=http://www.opengis.net/gml; xmlns:wfs=
http://www.opengis.net/wfs; xmlns:ogc=http://www.opengis.net/ogc
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance
 xsi:schemaLocation=http://mapserver.gis.umn.edu/mapserver 
http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapSERVICE=WFSVERSION=1.1.0REQUEST=DescribeFeatureTypeTYPENAME=IN.NUMERICIVICI.2012OUTPUTFORMAT=text/xml;%20subtype=gml/3.1.1
 
http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd;
gml:boundedBy
gml:Envelope srsName=EPSG:4326
gml:lowerCorner44.912717 7.672281/gml:lowerCorner
gml:upperCorner44.912717 7.672281/gml:upperCorner
/gml:Envelope
/gml:boundedBy
gml:featureMember
ms:IN.NUMERICIVICI.2012 gml:id=IN.NUMERICIVICI.2012.11979231
gml:boundedBy
gml:Envelope srsName=EPSG:4326
gml:lowerCorner44.912717 7.672281/gml:lowerCorner
gml:upperCorner44.912717 7.672281/gml:upperCorner
/gml:Envelope
/gml:boundedBy
ms:boundary
gml:Point srsName=EPSG:4326
gml:pos44.912717 7.672281/gml:pos
/gml:Point
/ms:boundary
ms:id1380050414/ms:id
ms:nomeVia Monte Grappa/ms:nome
ms:civico24/ms:civico
ms:istat01001058/ms:istat
ms:cap10041/ms:cap
ms:comuneCARIGNANO/ms:comune
ms:nome_ted/ms:nome_ted
ms:provinciaTORINO/ms:provincia
ms:regionePIEMONTE/ms:regione
/ms:IN.NUMERICIVICI.2012
/gml:featureMember
/wfs:FeatureCollection

so it seems to be right.

To refine the query I've tried to use the PropertyIsEqualTo operator 
instead of the PropertyIsLike only for those fields that are not numeric, 
so the fields comune and nome  the new query is

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.1.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ANDogc:PropertyIsEqualToogc:PropertyNamecomune/ogc:PropertyNameogc:LiteralCarignano/ogc:Literal/ogc:PropertyIsEqualToogc:PropertyIsEqualToogc:PropertyNamenome/ogc:PropertyNameogc:LiteralVia
 
Monte Grappa/ogc:Literal/ogc:PropertyIsEqualToogc:PropertyIsLike 
matchCase=false wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNamecivico/ogc:PropertyNameogc:Literal*24*/ogc:Literal/ogc:PropertyIsLike/AND/ogc:Filter
 
 

but the result is 

wfs:FeatureCollection xmlns:ms=http://mapserver.gis.umn.edu/mapserver
 xmlns:gml=http://www.opengis.net/gml; xmlns:wfs=
http://www.opengis.net/wfs; xmlns:ogc=http://www.opengis.net/ogc
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance
 xsi:schemaLocation=http://mapserver.gis.umn.edu/mapserver 
http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapSERVICE=WFSVERSION=1.1.0REQUEST=DescribeFeatureTypeTYPENAME=IN.NUMERICIVICI.2012OUTPUTFORMAT=text/xml;%20subtype=gml/3.1.1
 
http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd;
gml:boundedBy
gml:Nullmissing/gml:Null
/gml:boundedBy
/wfs:FeatureCollection

Is there something wrong somewhere or it's better continue to use the 
PropertyIsLike everywhere?

Thank you in advance 

Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric field

[Steve . Toutant]

Precision: we are using MS7.1
Removing matchcase part makes oracle, and postgis, crash.
I have this error:

ows:ExceptionReport xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance
 xmlns:ows=http://www.opengis.net/ows
 version=1.1.0 language=en-USxsi:schemaLocation=
http://www.opengis.net/ows
http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd;
ows:Exception exceptionCode=NoApplicableCode locator=mapserv
ows:ExceptionText
msWFSGetFeature(): WFS server error. FLTApplyFilterToLayer() failed 
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data 
statement and server logs
/ows:ExceptionText 


The problem might be the decimals?
Here is the request
wfs:Query typeName=feature:SMDVDP_STAT_METE srsName=EPSG:32198
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;
ogc:PropertyIsEqualTo
ogc:PropertyNameLONG_STAT/ogc:PropertyName
ogc:Literal-61,8031/ogc:Literal
/ogc:PropertyIsEqualTo
/ogc:Filter
/wfs:Query
/wfs:GetFeature






thomas bonfort thomas.bonf...@gmail.com 
2015-05-13 05:40

A
steve.tout...@inspq.qc.ca
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on 
numeric field








can you try the same request without the matchCase part and report
back please?

On 12 May 2015 at 18:11,  steve.tout...@inspq.qc.ca wrote:
 I have a problem using a FILTER in a wfs getFeature request on an oracle 
DB
 with MS7
 When I launch a getFeature request with a Filter on a numeric field it
 doesn't work,
 ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ogc:PropertyIsEqualTo
 
matchCase=falseogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61/ogc:Literal/ogc:PropertyIsEqualTo/ogc:Filter
 here is the error we get in the browser
 ows:Exception exceptionCode=NoApplicableCode locator=mapserv
ows:ExceptionTextmsWFSGetFeature(): WFS server error.
 FLTApplyFilterToLayer() failed
 msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data
 statement and server logs/ows:ExceptionText

 from mapserver logs
 [Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter.
 String:  ([LONG_STAT] =*-61)

 LONG_STAT is a NUMBER in the DB
 DescribefeatureType returns
   element name=NO_STAT_CLIM minOccurs=0 type=string/
  element name=NO_STAT_FADQ minOccurs=0 type=string/
  element name=NOM_STAT minOccurs=0 type=string/
  element name=LATI_STAT minOccurs=0 type=string/
  element name=LONG_STAT minOccurs=0 type=string/
  element name=ALTI_STAT minOccurs=0 type=string/

 I tried to add gml_types auto in the mapfile, but it still returns
 string as data type
 I tried gml_LONG_STAT_type = Integer in the mapfile, 
describeFeatureType
 returns element name=LONG_STAT minOccurs=0 type=double/  but I
 still get an error in getFeature

 I'm using CONNECTIONTYPE oraclespatial in the mapfile

 I can provide more information

 Is it a known issue or can I do something about that?

 Thank you!
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric field

[Steve . Toutant]

this works
ogc:PropertyIsLike matchCase=true wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal*-61,8031*/ogc:Literal/ogc:PropertyIsLike
 


But we want to be able to usePropertyIsEqual because are end users won't 
use PropertyIsLike...





thomas bonfort thomas.bonf...@gmail.com 
2015-05-13 05:40

A
steve.tout...@inspq.qc.ca
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on 
numeric field








can you try the same request without the matchCase part and report
back please?

On 12 May 2015 at 18:11,  steve.tout...@inspq.qc.ca wrote:
 I have a problem using a FILTER in a wfs getFeature request on an oracle 
DB
 with MS7
 When I launch a getFeature request with a Filter on a numeric field it
 doesn't work,
 ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ogc:PropertyIsEqualTo
 
matchCase=falseogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61/ogc:Literal/ogc:PropertyIsEqualTo/ogc:Filter
 here is the error we get in the browser
 ows:Exception exceptionCode=NoApplicableCode locator=mapserv
ows:ExceptionTextmsWFSGetFeature(): WFS server error.
 FLTApplyFilterToLayer() failed
 msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data
 statement and server logs/ows:ExceptionText

 from mapserver logs
 [Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter.
 String:  ([LONG_STAT] =*-61)

 LONG_STAT is a NUMBER in the DB
 DescribefeatureType returns
   element name=NO_STAT_CLIM minOccurs=0 type=string/
  element name=NO_STAT_FADQ minOccurs=0 type=string/
  element name=NOM_STAT minOccurs=0 type=string/
  element name=LATI_STAT minOccurs=0 type=string/
  element name=LONG_STAT minOccurs=0 type=string/
  element name=ALTI_STAT minOccurs=0 type=string/

 I tried to add gml_types auto in the mapfile, but it still returns
 string as data type
 I tried gml_LONG_STAT_type = Integer in the mapfile, 
describeFeatureType
 returns element name=LONG_STAT minOccurs=0 type=double/  but I
 still get an error in getFeature

 I'm using CONNECTIONTYPE oraclespatial in the mapfile

 I can provide more information

 Is it a known issue or can I do something about that?

 Thank you!
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE VS: Mapserver 7+oracle - wfs getFeature with filter on numeric field

[Steve . Toutant]

DescribeFeatureType returns string for each atributes





Rahkonen Jukka (MML) jukka.rahko...@maanmittauslaitos.fi 
2015-05-13 10:46

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org
Objet
VS: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on 
numeric field








Hi,
 
What does the schema of the feature type show if you check it with 
DescribeFeatureType? If the property is String I think you should stop 
what you do and make Mapserver to consider and announce the property as 
numeric first.
 
-Jukka Rahkonen-
 
steve.tout...@inspq.qc.ca wrote:
 
this works 
ogc:PropertyIsLike matchCase=true wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal*-61,8031*/ogc:Literal/ogc:PropertyIsLike
 


But we want to be able to usePropertyIsEqual because are end users won't 
use PropertyIsLike... 



thomas bonfort thomas.bonf...@gmail.com 
2015-05-13 05:40 


A
steve.tout...@inspq.qc.ca 
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on 
numeric field
 










can you try the same request without the matchCase part and report
back please?

On 12 May 2015 at 18:11,  steve.tout...@inspq.qc.ca wrote:
 I have a problem using a FILTER in a wfs getFeature request on an oracle 
DB
 with MS7
 When I launch a getFeature request with a Filter on a numeric field it
 doesn't work,
 ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ogc:PropertyIsEqualTo
 
matchCase=falseogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61/ogc:Literal/ogc:PropertyIsEqualTo/ogc:Filter
 here is the error we get in the browser
 ows:Exception exceptionCode=NoApplicableCode locator=mapserv
ows:ExceptionTextmsWFSGetFeature(): WFS server error.
 FLTApplyFilterToLayer() failed
 msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data
 statement and server logs/ows:ExceptionText

 from mapserver logs
 [Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter.
 String:  ([LONG_STAT] =*-61)

 LONG_STAT is a NUMBER in the DB
 DescribefeatureType returns
   element name=NO_STAT_CLIM minOccurs=0 type=string/
  element name=NO_STAT_FADQ minOccurs=0 type=string/
  element name=NOM_STAT minOccurs=0 type=string/
  element name=LATI_STAT minOccurs=0 type=string/
  element name=LONG_STAT minOccurs=0 type=string/
  element name=ALTI_STAT minOccurs=0 type=string/

 I tried to add gml_types auto in the mapfile, but it still returns
 string as data type
 I tried gml_LONG_STAT_type = Integer in the mapfile, 
describeFeatureType
 returns element name=LONG_STAT minOccurs=0 type=double/  but I
 still get an error in getFeature

 I'm using CONNECTIONTYPE oraclespatial in the mapfile

 I can provide more information

 Is it a known issue or can I do something about that?

 Thank you!
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users




___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE VS: Mapserver 7+oracle - wfs getFeature with filter on numeric field

[Steve . Toutant]

this is weird.
First, DescribeFeatureType returns string for every attributes
element name=LONG_STAT minOccurs=0 type=string/ 

Here is a getfeature response ( 
http:/x?SERVICE=WFSVERSION=1.1.0REQUEST=GetFeatureTYPENAME=feature:SMDVDP_STAT_METEmaxFeatures=5
 
) 
 ms:LONG_STAT-65,6906/ms:LONG_STAT

Using ogc:PropertyIsEqualTo matchCase=true ogc:Literal-61,
8031/ogc:Literal it crashes
Using ogc:PropertyIsEqualTo matchCase=true ogc:Literal-61.
8031/ogc:Literal it works
Using ogc:PropertyIsEqualTo matchCase=false ogc:Literal-61.
8031/ogc:Literal it crashes

So getfeature returns , as decimals separator, but getfeature with a 
filter needs a . to works, but with matchCase=false crashes in any 
case.

I'm totally confuse




Rahkonen Jukka (MML) jukka.rahko...@maanmittauslaitos.fi 
2015-05-13 10:46

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org
Objet
VS: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on 
numeric field








Hi,
 
What does the schema of the feature type show if you check it with 
DescribeFeatureType? If the property is String I think you should stop 
what you do and make Mapserver to consider and announce the property as 
numeric first.
 
-Jukka Rahkonen-
 
steve.tout...@inspq.qc.ca wrote:
 
this works 
ogc:PropertyIsLike matchCase=true wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal*-61,8031*/ogc:Literal/ogc:PropertyIsLike
 


But we want to be able to usePropertyIsEqual because are end users won't 
use PropertyIsLike... 



thomas bonfort thomas.bonf...@gmail.com 
2015-05-13 05:40 


A
steve.tout...@inspq.qc.ca 
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org 
Objet
Re: [mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on 
numeric field
 










can you try the same request without the matchCase part and report
back please?

On 12 May 2015 at 18:11,  steve.tout...@inspq.qc.ca wrote:
 I have a problem using a FILTER in a wfs getFeature request on an oracle 
DB
 with MS7
 When I launch a getFeature request with a Filter on a numeric field it
 doesn't work,
 ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ogc:PropertyIsEqualTo
 
matchCase=falseogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61/ogc:Literal/ogc:PropertyIsEqualTo/ogc:Filter
 here is the error we get in the browser
 ows:Exception exceptionCode=NoApplicableCode locator=mapserv
ows:ExceptionTextmsWFSGetFeature(): WFS server error.
 FLTApplyFilterToLayer() failed
 msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data
 statement and server logs/ows:ExceptionText

 from mapserver logs
 [Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter.
 String:  ([LONG_STAT] =*-61)

 LONG_STAT is a NUMBER in the DB
 DescribefeatureType returns
   element name=NO_STAT_CLIM minOccurs=0 type=string/
  element name=NO_STAT_FADQ minOccurs=0 type=string/
  element name=NOM_STAT minOccurs=0 type=string/
  element name=LATI_STAT minOccurs=0 type=string/
  element name=LONG_STAT minOccurs=0 type=string/
  element name=ALTI_STAT minOccurs=0 type=string/

 I tried to add gml_types auto in the mapfile, but it still returns
 string as data type
 I tried gml_LONG_STAT_type = Integer in the mapfile, 
describeFeatureType
 returns element name=LONG_STAT minOccurs=0 type=double/  but I
 still get an error in getFeature

 I'm using CONNECTIONTYPE oraclespatial in the mapfile

 I can provide more information

 Is it a known issue or can I do something about that?

 Thank you!
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users




___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Mapserver 7+oracle - wfs getFeature with filter on numeric field

[Steve . Toutant]

I have a problem using a FILTER in a wfs getFeature request on an oracle 
DB with MS7
When I launch a getFeature request with a Filter on a numeric field it 
doesn't work, 
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;ogc:PropertyIsEqualTo 
matchCase=falseogc:PropertyNameLONG_STAT/ogc:PropertyNameogc:Literal-61/ogc:Literal/ogc:PropertyIsEqualTo/ogc:Filter
 

here is the error we get in the browser
ows:Exception exceptionCode=NoApplicableCode locator=mapserv
   ows:ExceptionTextmsWFSGetFeature(): WFS server error. 
FLTApplyFilterToLayer() failed
msOracleSpatialLayerWhichShapes(): OracleSpatial error. Check your data 
statement and server logs/ows:ExceptionText 

from mapserver logs
[Tue May 12 11:59:10 2015].177992 msOracleSpatialLayerTranslateFilter. 
String:  ([LONG_STAT] =*-61)  

LONG_STAT is a NUMBER in the DB
DescribefeatureType returns
  element name=NO_STAT_CLIM minOccurs=0 type=string/
 element name=NO_STAT_FADQ minOccurs=0 type=string/
 element name=NOM_STAT minOccurs=0 type=string/
 element name=LATI_STAT minOccurs=0 type=string/
 element name=LONG_STAT minOccurs=0 type=string/
 element name=ALTI_STAT minOccurs=0 type=string/ 

I tried to add gml_types auto in the mapfile, but it still returns 
string as data type
I tried gml_LONG_STAT_type = Integer in the mapfile, 
describeFeatureType returns element name=LONG_STAT minOccurs=0 
type=double/  but I still get an error in getFeature

I'm using CONNECTIONTYPE oraclespatial in the mapfile

I can provide more information

Is it a known issue or can I do something about that?

Thank you!___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE How to use filter encoding in MapServer in a WFS query?

[Steve . Toutant]

Your syntax are good. This is an old problem with int considered as string
Using ogc:PropertyIsLike works though, here is a request

ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;ogc:PropertyIsLike 
matchCase=false wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNameid/ogc:PropertyNameogc:Literal*13800073301968*/ogc:Literal/ogc:PropertyIsLike/ogc:Filter
 


Also this wfs support version= 1.1.0, you should do your request by 
specifying this version




cesare gerbino cesaregerb...@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-05-12 15:33

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] How to use filter encoding in MapServer in a WFS query?








Hi all!

I need to query this WFS public service 

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapservice=wfsrequest=getCapabilities

The layer I need to query is this one

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapservice=wfsversion=1.0.0request=DescribeFeatureType

It's a layer with a very big number of point features.

The OGC service is done using MapServer but I don't know the version.

I need to query this layer in a no spatial way: the simplest query I need 
to do is something like this one


http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.0.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=
FilterPropertyIsEqualToPropertyNameid/PropertyNameLiteral1380050414/Literal/PropertyIsEqualTo/Filter

My final query would like to combine several clauses using the AND logical 
operator.

Unfortunately at the moment the simplest query above doesn't work: if you 
try it in the response ther will be something like 

HINT: No operator matches the given name and argument type(s). You might 
need to add explicit type casts

I've done several attempts to change it and I've tried other queries: for 
example

1) this one ...

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.0.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=%3Cogc:Filter%3E%3Cogc:PropertyIsEqualTo%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E%271380050414%27%3C/ogc:Literal%3E%3C/ogc:PropertyIsEqualTo%3E%3C/ogc:Filter%3E


returns 

gml:boundedBygml:nullmissing/gml:null/gml:boundedBy

so I think that in this case the sintax could be right but I'm not sure 
and I don0't understand because the response is null 

2) trying to do a spatial query like this one ...


http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.0.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=%3CFilter%3E%3CBBOX%3E%3CPropertyName%3EName%3ENAME%3C/PropertyName%3E%3CBox%20srsName=%27EPSG:4326%27%3E%3Ccoordinates%3E7.626630,45.029061%207.673107,45.052713%3C/coordinates%3E%3C/Box%3E%3C/BBOX%3E%3C/Filter%3E

returns a right response.

I've found on the web that probably there is a workaround ...

http://osgeo-org.1560.x6.nabble.com/WFS-filter-creates-a-query-using-a-number-instead-of-text-td5130361.html#a5190402

that suggest to use the PropertyIsLike operator instead of the 
PropertyIsEqual. I've tried to use it but it doesn't work in my case ... 

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.0.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=%3Cogc:Filter%3E%3Cogc:PropertyIsLike%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E%271380050414%27%3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E

in this case after a long time it seems that the service goes in time out 
and no data is returned  

Now I am completely blocked  :-(

Any suggestions / workaround? 

Thank you very much in advance ...

Cesare

Cesare Gerbino

http://cesaregerbino.wordpress.com/
http://www.facebook.com/cesare.gerbino
http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl

https://twitter.com/CesareGerbino
http://www.linkedin.com/pub/cesare-gerbino/56/494/77b

Questo è un account di posta personale di Cesare Gerbino: tutte le 
opinioni espresse sono personali e non riflettono necessariamente quelle 
del mio datore di lavoro

This is Cesare Gerbino mail account. Text is written by Cesare Gerbino: 
 the views expressed  are mine and not necessarily those of my employer.
.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE How to use filter encoding in MapServer in a WFS query?

[Steve . Toutant]

The link you provided works...I received 15 features

I don't know what to say, what firebug or chrome say?



cesare gerbino cesaregerb...@gmail.com 
2015-05-12 15:58

A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org, mapserver-users-boun...@lists.osgeo.org
Objet
Re: RE [mapserver-users] How to use filter encoding in MapServer in a WFS 
query?








Hi Steve,

thank you for the quckly response!!

I've just tried to change my request using you suggestion ... this is the 
new request now ..

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.1.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;ogc:PropertyIsLike 
matchCase=false wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNameid/ogc:PropertyNameogc:Literal*1380050414*/ogc:Literal/ogc:PropertyIsLike/ogc:Filter
 

or better how it's used in my browser

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.1.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=%3Cogc:Filter%20xmlns:ogc=%22http://www.opengis.net/ogc%22%3E%3Cogc:PropertyIsLike%20matchCase=%22false%22%20wildCard=%22*%22%20singleChar=%22.%22%20escapeChar=%22!%22%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E*13800073301968*%3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E

Unfortunately still doesn't work  No data received is the response 
 

Cesare

Cesare Gerbino

http://cesaregerbino.wordpress.com/
http://www.facebook.com/cesare.gerbino
http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl

https://twitter.com/CesareGerbino
http://www.linkedin.com/pub/cesare-gerbino/56/494/77b

Questo è un account di posta personale di Cesare Gerbino: tutte le 
opinioni espresse sono personali e non riflettono necessariamente quelle 
del mio datore di lavoro

This is Cesare Gerbino mail account. Text is written by Cesare Gerbino: 
 the views expressed  are mine and not necessarily those of my employer.
.


2015-05-12 21:48 GMT+02:00 steve.tout...@inspq.qc.ca:
Your syntax are good. This is an old problem with int considered as string 

Using ogc:PropertyIsLike works though, here is a request 

ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;ogc:PropertyIsLike 
matchCase=false wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNameid/ogc:PropertyNameogc:Literal*13800073301968*/ogc:Literal/ogc:PropertyIsLike/ogc:Filter
 


Also this wfs support version= 1.1.0, you should do your request by 
specifying this version 




cesare gerbino cesaregerb...@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org 
2015-05-12 15:33 


A
mapserver-users@lists.osgeo.org 
cc

Objet
[mapserver-users] How to use filter encoding in MapServer in a WFS   
 query?










Hi all! 

I need to query this WFS public service  

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapservice=wfsrequest=getCapabilities
 


The layer I need to query is this one 

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapservice=wfsversion=1.0.0request=DescribeFeatureType
 


It's a layer with a very big number of point features. 

The OGC service is done using MapServer but I don't know the version. 

I need to query this layer in a no spatial way: the simplest query I need 
to do is something like this one 


http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.0.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=
FilterPropertyIsEqualToPropertyNameid/PropertyNameLiteral1380050414/Literal/PropertyIsEqualTo/Filter
 


My final query would like to combine several clauses using the AND logical 
operator. 

Unfortunately at the moment the simplest query above doesn't work: if you 
try it in the response ther will be something like  

HINT: No operator matches the given name and argument type(s). You might 
need to add explicit type casts 

I've done several attempts to change it and I've tried other queries: for 
example 

1) this one ... 

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.0.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=%3Cogc:Filter%3E%3Cogc:PropertyIsEqualTo%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E%271380050414%27%3C/ogc:Literal%3E%3C/ogc:PropertyIsEqualTo%3E%3C/ogc:Filter%3E
 



returns  

gml:boundedBygml:nullmissing/gml:null/gml:boundedBy 

so I think that in this case the sintax could be right but I'm not sure 
and I don0't understand because the response is null  

2) trying to do a spatial query like this one ... 

Re: [mapserver-users] RE How to use filter encoding in MapServer in a WFS query?

[Steve . Toutant]

maybe there is a parameter in your browser that abort request when it is 
too long to get an answer.





cesare gerbino cesaregerb...@gmail.com 
2015-05-12 16:18

A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org, mapserver-users-boun...@lists.osgeo.org
Objet
Re: RE [mapserver-users] How to use filter encoding in MapServer in a WFS 
query?








My Firebug console, in the Net tab, All  says Aborted  tha 
same in Chrome  . 

Cesare Gerbino

http://cesaregerbino.wordpress.com/
http://www.facebook.com/cesare.gerbino
http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl

https://twitter.com/CesareGerbino
http://www.linkedin.com/pub/cesare-gerbino/56/494/77b

Questo è un account di posta personale di Cesare Gerbino: tutte le 
opinioni espresse sono personali e non riflettono necessariamente quelle 
del mio datore di lavoro

This is Cesare Gerbino mail account. Text is written by Cesare Gerbino: 
 the views expressed  are mine and not necessarily those of my employer.
.


2015-05-12 22:07 GMT+02:00 steve.tout...@inspq.qc.ca:
The link you provided works...I received 15 features 
I don't know what to say, what firebug or chrome say? 



cesare gerbino cesaregerb...@gmail.com 
2015-05-12 15:58 


A
steve.tout...@inspq.qc.ca 
cc
mapserver-users@lists.osgeo.org, mapserver-users-boun...@lists.osgeo.org 
Objet
Re: RE [mapserver-users] How to use filter encoding in MapServer in a WFS 
query?










Hi Steve, 

thank you for the quckly response!! 

I've just tried to change my request using you suggestion ... this is the 
new request now .. 

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.1.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;ogc:PropertyIsLike 
matchCase=false wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNameid/ogc:PropertyNameogc:Literal*1380050414*/ogc:Literal/ogc:PropertyIsLike/ogc:Filter
  


or better how it's used in my browser 

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.1.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=%3Cogc:Filter%20xmlns:ogc=%22http://www.opengis.net/ogc%22%3E%3Cogc:PropertyIsLike%20matchCase=%22false%22%20wildCard=%22*%22%20singleChar=%22.%22%20escapeChar=%22!%22%3E%3Cogc:PropertyName%3Eid%3C/ogc:PropertyName%3E%3Cogc:Literal%3E*13800073301968*%3C/ogc:Literal%3E%3C/ogc:PropertyIsLike%3E%3C/ogc:Filter%3E
 


Unfortunately still doesn't work  No data received is the response 
  

Cesare 

Cesare Gerbino

http://cesaregerbino.wordpress.com/
http://www.facebook.com/cesare.gerbino
http://www.facebook.com/pages/Cesare-Gerbino-GIS-Blog/246234455498174?ref=hl

https://twitter.com/CesareGerbino
http://www.linkedin.com/pub/cesare-gerbino/56/494/77b 

Questo è un account di posta personale di Cesare Gerbino: tutte le 
opinioni espresse sono personali e non riflettono necessariamente quelle 
del mio datore di lavoro 

This is Cesare Gerbino mail account. Text is written by Cesare Gerbino: 
 the views expressed  are mine and not necessarily those of my employer. 
.


2015-05-12 21:48 GMT+02:00 steve.tout...@inspq.qc.ca: 
Your syntax are good. This is an old problem with int considered as string 

Using ogc:PropertyIsLike works though, here is a request 

ogc:Filter xmlns:ogc=http://www.opengis.net/ogc;ogc:PropertyIsLike 
matchCase=false wildCard=* singleChar=. 
escapeChar=!ogc:PropertyNameid/ogc:PropertyNameogc:Literal*13800073301968*/ogc:Literal/ogc:PropertyIsLike/ogc:Filter
 


Also this wfs support version= 1.1.0, you should do your request by 
specifying this version 



cesare gerbino cesaregerb...@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org 
2015-05-12 15:33 


A
mapserver-users@lists.osgeo.org 
cc

Objet
[mapserver-users] How to use filter encoding in MapServer in a WFS   
 query?












Hi all! 

I need to query this WFS public service  

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapservice=wfsrequest=getCapabilities
 


The layer I need to query is this one 

http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapservice=wfsversion=1.0.0request=DescribeFeatureType
 


It's a layer with a very big number of point features. 

The OGC service is done using MapServer but I don't know the version. 

I need to query this layer in a no spatial way: the simplest query I need 
to do is something like this one 


http://wms.pcn.minambiente.it/ogc?map=/ms_ogc/wfs/Numeri_Civici_2012.mapVERSION=1.0.0service=wfsrequest=GetFeatureTYPENAME=IN.NUMERICIVICI.2012Filter=
FilterPropertyIsEqualToPropertyNameid/PropertyNameLiteral1380050414/Literal/PropertyIsEqualTo/Filter
 


My final query would like to combine several clauses using the AND logical 
operator. 

Unfortunately at the moment the simplest query above doesn't work: if you 
try it in the response ther will be something 

[mapserver-users] RE Mapserver 7 make error

[Steve . Toutant]

Any hint on what can I do about that Cairo error when compiling mapserv?
Thank you




Steve Toutant/INSPQ/ 
2015-05-01 15:11

A
mapserver-users@lists.osgeo.org
cc

Objet
Mapserver 7 make error







I'm compiling MS7 on Centos 6.5. I get an error running make

make

Scanning dependencies of target mapserver

[  0%] Building C object CMakeFiles/mapserver.dir/fontcache.c.o

[  1%] Building C object CMakeFiles/mapserver.dir/cgiutil.c.o

[  2%] Building C object CMakeFiles/mapserver.dir/mapgeos.c.o

[  2%] Building C object CMakeFiles/mapserver.dir/maporaclespatial.c.o

[  3%] Building C object CMakeFiles/mapserver.dir/mapsearch.c.o

[  4%] Building C object CMakeFiles/mapserver.dir/mapwms.c.o

[  4%] Building C object CMakeFiles/mapserver.dir/classobject.c.o

[  5%] Building C object CMakeFiles/mapserver.dir/mapgml.c.o

[  6%] Building C object CMakeFiles/mapserver.dir/mapoutput.c.o

[  6%] Building C object CMakeFiles/mapserver.dir/mapwmslayer.c.o

[  7%] Building C object CMakeFiles/mapserver.dir/layerobject.c.o

[  8%] Building C object CMakeFiles/mapserver.dir/mapgraticule.c.o

[  8%] Building C object CMakeFiles/mapserver.dir/mapows.c.o

[  9%] Building C object CMakeFiles/mapserver.dir/mapservutil.c.o

[ 10%] Building C object CMakeFiles/mapserver.dir/mapxbase.c.o

[ 10%] Building C object CMakeFiles/mapserver.dir/maphash.c.o

[ 11%] Building C object CMakeFiles/mapserver.dir/mapowscommon.c.o

[ 11%] Building C object CMakeFiles/mapserver.dir/mapshape.c.o

[ 12%] Building C object CMakeFiles/mapserver.dir/mapxml.c.o

[ 13%] Building C object CMakeFiles/mapserver.dir/mapbits.c.o

[ 13%] Building C object CMakeFiles/mapserver.dir/maphttp.c.o

[ 14%] Building C object CMakeFiles/mapserver.dir/mapparser.c.o

[ 15%] Building C object CMakeFiles/mapserver.dir/mapstring.c.o

[ 15%] Building C object CMakeFiles/mapserver.dir/mapxmp.c.o

[ 16%] Building C object CMakeFiles/mapserver.dir/mapcairo.c.o

/opt/geomatique/src/mapserver/mapcairo.c: In function âms2cairo_compopâ:

/opt/geomatique/src/mapserver/mapcairo.c:809: erreur: 
âCAIRO_OPERATOR_MULTIPLYâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:809: erreur: (Each undeclared 
identifier is reported only once

/opt/geomatique/src/mapserver/mapcairo.c:809: erreur: for each function it 
appears in.)

/opt/geomatique/src/mapserver/mapcairo.c:811: erreur: 
âCAIRO_OPERATOR_SCREENâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:813: erreur: 
âCAIRO_OPERATOR_OVERLAYâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:815: erreur: 
âCAIRO_OPERATOR_DARKENâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:817: erreur: 
âCAIRO_OPERATOR_LIGHTENâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:819: erreur: 
âCAIRO_OPERATOR_COLOR_DODGEâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:821: erreur: 
âCAIRO_OPERATOR_COLOR_BURNâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:823: erreur: 
âCAIRO_OPERATOR_HARD_LIGHTâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:825: erreur: 
âCAIRO_OPERATOR_SOFT_LIGHTâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:827: erreur: 
âCAIRO_OPERATOR_DIFFERENCEâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:829: erreur: 
âCAIRO_OPERATOR_EXCLUSIONâ undeclared (first use in this function)

make[2]: *** [CMakeFiles/mapserver.dir/mapcairo.c.o] Erreur 1

make[1]: *** [CMakeFiles/mapserver.dir/all] Erreur 2

make: *** [all] Erreur 2


I do have cairo and cairo-devel installed (1.8.8-3.1.el6).
How can I fix this?
Thanks you


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE Mapserver 7 make error

[Steve . Toutant]

Cairo version is 1.8 on my centos6.5 distro, and the system admin won't 
let me update it
Just not using mapserver from the distro was a hard fight






Even Rouault even.roua...@spatialys.com 
2015-05-05 09:20

A
mapserver-users@lists.osgeo.org
cc
steve.tout...@inspq.qc.ca
Objet
Re: [mapserver-users] RE Mapserver 7 make error








Le mardi 05 mai 2015 15:13:34, steve.tout...@inspq.qc.ca a écrit :
 Any hint on what can I do about that Cairo error when compiling mapserv?
 Thank you

Steve,

you need to upgrade to a more recent version of cairo. Perhaps 1.10 or 
1.12.
I think Thomas mentionned to me that it might be possible to use older 
cairo 
by using older names for the CAIRO_OPERATOR_ values. I think we 
discussed 
that in a github ticket (not sure), but can't find it anymore.

Even

 
 
 
 
 Steve Toutant/INSPQ/
 2015-05-01 15:11
 
 A
 mapserver-users@lists.osgeo.org
 cc
 
 Objet
 Mapserver 7 make error
 
 
 
 
 
 
 
 I'm compiling MS7 on Centos 6.5. I get an error running make
 
 make
 
 Scanning dependencies of target mapserver
 
 [  0%] Building C object CMakeFiles/mapserver.dir/fontcache.c.o
 
 [  1%] Building C object CMakeFiles/mapserver.dir/cgiutil.c.o
 
 [  2%] Building C object CMakeFiles/mapserver.dir/mapgeos.c.o
 
 [  2%] Building C object CMakeFiles/mapserver.dir/maporaclespatial.c.o
 
 [  3%] Building C object CMakeFiles/mapserver.dir/mapsearch.c.o
 
 [  4%] Building C object CMakeFiles/mapserver.dir/mapwms.c.o
 
 [  4%] Building C object CMakeFiles/mapserver.dir/classobject.c.o
 
 [  5%] Building C object CMakeFiles/mapserver.dir/mapgml.c.o
 
 [  6%] Building C object CMakeFiles/mapserver.dir/mapoutput.c.o
 
 [  6%] Building C object CMakeFiles/mapserver.dir/mapwmslayer.c.o
 
 [  7%] Building C object CMakeFiles/mapserver.dir/layerobject.c.o
 
 [  8%] Building C object CMakeFiles/mapserver.dir/mapgraticule.c.o
 
 [  8%] Building C object CMakeFiles/mapserver.dir/mapows.c.o
 
 [  9%] Building C object CMakeFiles/mapserver.dir/mapservutil.c.o
 
 [ 10%] Building C object CMakeFiles/mapserver.dir/mapxbase.c.o
 
 [ 10%] Building C object CMakeFiles/mapserver.dir/maphash.c.o
 
 [ 11%] Building C object CMakeFiles/mapserver.dir/mapowscommon.c.o
 
 [ 11%] Building C object CMakeFiles/mapserver.dir/mapshape.c.o
 
 [ 12%] Building C object CMakeFiles/mapserver.dir/mapxml.c.o
 
 [ 13%] Building C object CMakeFiles/mapserver.dir/mapbits.c.o
 
 [ 13%] Building C object CMakeFiles/mapserver.dir/maphttp.c.o
 
 [ 14%] Building C object CMakeFiles/mapserver.dir/mapparser.c.o
 
 [ 15%] Building C object CMakeFiles/mapserver.dir/mapstring.c.o
 
 [ 15%] Building C object CMakeFiles/mapserver.dir/mapxmp.c.o
 
 [ 16%] Building C object CMakeFiles/mapserver.dir/mapcairo.c.o
 
 /opt/geomatique/src/mapserver/mapcairo.c: In function âms2cairo_compopâ:
 
 /opt/geomatique/src/mapserver/mapcairo.c:809: erreur:
 âCAIRO_OPERATOR_MULTIPLYâ undeclared (first use in this function)
 
 /opt/geomatique/src/mapserver/mapcairo.c:809: erreur: (Each undeclared
 identifier is reported only once
 
 /opt/geomatique/src/mapserver/mapcairo.c:809: erreur: for each function 
it
 appears in.)
 
 /opt/geomatique/src/mapserver/mapcairo.c:811: erreur:
 âCAIRO_OPERATOR_SCREENâ undeclared (first use in this function)
 
 /opt/geomatique/src/mapserver/mapcairo.c:813: erreur:
 âCAIRO_OPERATOR_OVERLAYâ undeclared (first use in this function)
 
 /opt/geomatique/src/mapserver/mapcairo.c:815: erreur:
 âCAIRO_OPERATOR_DARKENâ undeclared (first use in this function)
 
 /opt/geomatique/src/mapserver/mapcairo.c:817: erreur:
 âCAIRO_OPERATOR_LIGHTENâ undeclared (first use in this function)
 
 /opt/geomatique/src/mapserver/mapcairo.c:819: erreur:
 âCAIRO_OPERATOR_COLOR_DODGEâ undeclared (first use in this function)
 
 /opt/geomatique/src/mapserver/mapcairo.c:821: erreur:
 âCAIRO_OPERATOR_COLOR_BURNâ undeclared (first use in this function)
 
 /opt/geomatique/src/mapserver/mapcairo.c:823: erreur:
 âCAIRO_OPERATOR_HARD_LIGHTâ undeclared (first use in this function)
 
 /opt/geomatique/src/mapserver/mapcairo.c:825: erreur:
 âCAIRO_OPERATOR_SOFT_LIGHTâ undeclared (first use in this function)
 
 /opt/geomatique/src/mapserver/mapcairo.c:827: erreur:
 âCAIRO_OPERATOR_DIFFERENCEâ undeclared (first use in this function)
 
 /opt/geomatique/src/mapserver/mapcairo.c:829: erreur:
 âCAIRO_OPERATOR_EXCLUSIONâ undeclared (first use in this function)
 
 make[2]: *** [CMakeFiles/mapserver.dir/mapcairo.c.o] Erreur 1
 
 make[1]: *** [CMakeFiles/mapserver.dir/all] Erreur 2
 
 make: *** [all] Erreur 2
 
 
 I do have cairo and cairo-devel installed (1.8.8-3.1.el6).
 How can I fix this?
 Thanks you

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE WFS getFeature,maxfeatures using POST

[Steve . Toutant]

ok I got it, maxfeatures goes in getFeature part...not in the query part
wfs:GetFeature xmlns:wfs=http://www.opengis.net/wfs; service=WFS 
version=1.1.0 maxFeatures=1





steve.tout...@inspq.qc.ca@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-05-05 15:25

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] WFS getFeature,maxfeatures using POST








It seems that maxFeatures=x is not used when using post request 
GET 
http://demo.mapserver.org/cgi-bin/wfs?VERSION=1.1.0SERVICE=WFSREQUEST=GetFeatureTYPENAME=citiesmaxFeatures=2
 


POST (see attached file) 
curl -X POST -d @msdemo.xml http://demo.mapserver.org/cgi-bin/wfs? 
--header Content-Type:text/xml 

I tried with MS6.4 and MS7 also. 
Is it a bug or I don't create the payload correctly? 
thanks___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] WFS getFeature,maxfeatures using POST

[Steve . Toutant]

It seems that maxFeatures=x is not used when using post request
GET
http://demo.mapserver.org/cgi-bin/wfs?VERSION=1.1.0SERVICE=WFSREQUEST=GetFeatureTYPENAME=citiesmaxFeatures=2

POST (see attached file)
curl -X POST -d @msdemo.xml http://demo.mapserver.org/cgi-bin/wfs? 
--header Content-Type:text/xml

I tried with MS6.4 and MS7 also.
Is it a bug or I don't create the payload correctly?
thanks___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Mapserver 7 make error

[Steve . Toutant]

I'm compiling MS7 on Centos 6.5. I get an error running make

make

Scanning dependencies of target mapserver

[  0%] Building C object CMakeFiles/mapserver.dir/fontcache.c.o

[  1%] Building C object CMakeFiles/mapserver.dir/cgiutil.c.o

[  2%] Building C object CMakeFiles/mapserver.dir/mapgeos.c.o

[  2%] Building C object CMakeFiles/mapserver.dir/maporaclespatial.c.o

[  3%] Building C object CMakeFiles/mapserver.dir/mapsearch.c.o

[  4%] Building C object CMakeFiles/mapserver.dir/mapwms.c.o

[  4%] Building C object CMakeFiles/mapserver.dir/classobject.c.o

[  5%] Building C object CMakeFiles/mapserver.dir/mapgml.c.o

[  6%] Building C object CMakeFiles/mapserver.dir/mapoutput.c.o

[  6%] Building C object CMakeFiles/mapserver.dir/mapwmslayer.c.o

[  7%] Building C object CMakeFiles/mapserver.dir/layerobject.c.o

[  8%] Building C object CMakeFiles/mapserver.dir/mapgraticule.c.o

[  8%] Building C object CMakeFiles/mapserver.dir/mapows.c.o

[  9%] Building C object CMakeFiles/mapserver.dir/mapservutil.c.o

[ 10%] Building C object CMakeFiles/mapserver.dir/mapxbase.c.o

[ 10%] Building C object CMakeFiles/mapserver.dir/maphash.c.o

[ 11%] Building C object CMakeFiles/mapserver.dir/mapowscommon.c.o

[ 11%] Building C object CMakeFiles/mapserver.dir/mapshape.c.o

[ 12%] Building C object CMakeFiles/mapserver.dir/mapxml.c.o

[ 13%] Building C object CMakeFiles/mapserver.dir/mapbits.c.o

[ 13%] Building C object CMakeFiles/mapserver.dir/maphttp.c.o

[ 14%] Building C object CMakeFiles/mapserver.dir/mapparser.c.o

[ 15%] Building C object CMakeFiles/mapserver.dir/mapstring.c.o

[ 15%] Building C object CMakeFiles/mapserver.dir/mapxmp.c.o

[ 16%] Building C object CMakeFiles/mapserver.dir/mapcairo.c.o

/opt/geomatique/src/mapserver/mapcairo.c: In function âms2cairo_compopâ:

/opt/geomatique/src/mapserver/mapcairo.c:809: erreur: 
âCAIRO_OPERATOR_MULTIPLYâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:809: erreur: (Each undeclared 
identifier is reported only once

/opt/geomatique/src/mapserver/mapcairo.c:809: erreur: for each function it 
appears in.)

/opt/geomatique/src/mapserver/mapcairo.c:811: erreur: 
âCAIRO_OPERATOR_SCREENâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:813: erreur: 
âCAIRO_OPERATOR_OVERLAYâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:815: erreur: 
âCAIRO_OPERATOR_DARKENâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:817: erreur: 
âCAIRO_OPERATOR_LIGHTENâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:819: erreur: 
âCAIRO_OPERATOR_COLOR_DODGEâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:821: erreur: 
âCAIRO_OPERATOR_COLOR_BURNâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:823: erreur: 
âCAIRO_OPERATOR_HARD_LIGHTâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:825: erreur: 
âCAIRO_OPERATOR_SOFT_LIGHTâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:827: erreur: 
âCAIRO_OPERATOR_DIFFERENCEâ undeclared (first use in this function)

/opt/geomatique/src/mapserver/mapcairo.c:829: erreur: 
âCAIRO_OPERATOR_EXCLUSIONâ undeclared (first use in this function)

make[2]: *** [CMakeFiles/mapserver.dir/mapcairo.c.o] Erreur 1

make[1]: *** [CMakeFiles/mapserver.dir/all] Erreur 2

make: *** [all] Erreur 2


I do have cairo and cairo-devel installed (1.8.8-3.1.el6).
How can I fix this?
Thanks you___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE MapServer on centos 7

[Steve . Toutant]

you can compile mapserver on centos, I did for centos 6.5
http://mapserver.org/installation/unix.html#compilin

You will need to install the -devel version of some packages...such as 
gdal, postgres, .




luca paganotti luca.pagano...@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-04-26 10:07

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] MapServer on centos 7









Hi all, I'm in the need of installing mapserver and pmapper on a centos 7 
box. I googled for a suitable repo, but the only one I was able to find 
was on elgis and is stucked at centos 6. Is there anybody who knows about 
a centos 7 one?

I also searched for building instructions but none of what I've found is 
targeted to centos 7. Can someone, please, direct me to right source of 
info?

I'm not so willing to downgrade to centos 6.

Thank you for any answer.___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE ows_allowed_ip_list / ows_denied_ip_list not working

[Steve . Toutant]

Anything in your mapserver log? perhaps there is another problem in your 
mapfile





Vladimiro Bellini vlasvlasv...@gmail.com 
2015-04-23 10:06

A
steve.tout...@inspq.qc.ca
cc
mapserver-users mapserver-users@lists.osgeo.org, 
mapserver-users-boun...@lists.osgeo.org
Objet
Re: RE [mapserver-users] ows_allowed_ip_list / ows_denied_ip_list not 
working








Hi, i tried all and my ip, but i got the same result.. what could it be?

here's my full metadata (header metadata of mapfile, not in layers)

METADATA
ows_denied_ip_list all 
wms_service_onlineresource 
http:///cgi-bin/mapserv6?map=//mapase.map;
ows_onlineresource 
http:///cgi-bin/mapserv6?map=//mapase.map;
wms_title Mapa 
wms_abstract Capas
wms_srs EPSG:4326 EPSG:900913 EPSG:3857 EPSG:4694 EPSG:4928 EPSG:4929 
EPSG:22181  EPSG:22182  EPSG:22183  EPSG:22184  EPSG:22185  EPSG:22186 
 EPSG:22187
wms_onlineresource 
http:///cgi-bin/mapserv6?map=//mapase.map;
wms_enable_request GetCapabilities GetMap GetLegendGraphic 
GetFeatureInfo
wfs_enable_request !*
wms_server_version 1.1.1
wms_feature_info_mime_type  text/html 
wms_include_items all
gml_include_items all
wms_contactelectronicmailaddress x...@.xxx.xx
END


and here's my layer metadata:

METADATA wms_title Concesiones de Distribuidoras electricas 
wms_extent -73,566078 -55,057765 -53,635586 -21,778191 
gml_include_items all gml_featureid gid 
wms_feature_info_mime_type text/html wms_server_version 1.1.1 
wms_include_items all wms_srs EPSG:4326 END


is there any other problem? i can still see my png when i do a GetMap 
request.. :(

thanks a lot.
Vladimiro.




Vladimiro Bellini  __
\ /| _ _|. _ . _ |__) _||. _ .

2015-04-23 10:37 GMT-03:00 steve.tout...@inspq.qc.ca:
Does this works 
ows_denied_ip_list all 

or 
ows_denied_ip_list youripaddress 




Vladimiro Bellini vlasvlasv...@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org 
2015-04-23 09:33 


A
mapserver-users@lists.osgeo.org 
cc

Objet
[mapserver-users] ows_allowed_ip_list / ows_denied_ip_list not   
 working










Hi. 
i was testing ows_denied_ip_list or allowed ip list on my 6.4.1 
mapserver and it does not work at all. 
 ./mapserv -v
MapServer version 6.4.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML 
SUPPORTS=PROJ SUPPORTS=GD SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV 
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER 
SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=GEOS 
INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE



METADATA
#inside top mapfile metadata

   ows_denied_ip_list *
#(other metadata..)
END


even blocking * (all ip's) it doesnt work, 
i always receive a GetMap response using wms
.. 
i can still see my request (cgi-bin,wms,getmap, see the full png, no 
denied at all...) why? 
:S 

Thanks, 

Vladimiro Bellini___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users 





___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE ows_allowed_ip_list / ows_denied_ip_list not working

[Steve . Toutant]

Does this works
ows_denied_ip_list all

or
ows_denied_ip_list youripaddress




Vladimiro Bellini vlasvlasv...@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-04-23 09:33

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] ows_allowed_ip_list / ows_denied_ip_list not  working








Hi.
i was testing ows_denied_ip_list or allowed ip list on my 6.4.1 
mapserver and it does not work at all.
 ./mapserv -v
MapServer version 6.4.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML 
SUPPORTS=PROJ SUPPORTS=GD SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV 
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER 
SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=GEOS 
INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE



METADATA
#inside top mapfile metadata

ows_denied_ip_list *
#(other metadata..)
END


even blocking * (all ip's) it doesnt work,
i always receive a GetMap response using wms
..
i can still see my request (cgi-bin,wms,getmap, see the full png, no 
denied at all...) why?
:S

Thanks,

Vladimiro Bellini___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE WFS from Tinyows on IExplorer: InvalidParameterValue

[Steve . Toutant]

It might be a problem with OL not tiny.
Do you have this problem using WFS version 1.0.0?






ar_gaeta riccardo...@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-04-08 11:14

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] WFS from Tinyows on IExplorer: InvalidParameterValue








Hi all,
I'm using without any problem Tinyows 1.0.0rc4 to load WFS on OpenLayers,
with browser Chrome and Firefox.
But since IExplorer 9 I'm not able anymore to see my WFS layers on map if
they come from Tinyows.

On Tinyows log I have this error:

/[Wed Apr  8 14:55:48 2015] [ERROR] Element
'{http://www.w3.org/2001/XMLSchema}import': Skipping import of schema
located at 'http://schemas.opengis.net/gml/2.1.2/feature.xsd' for the
namespace 'http://www.opengis.net/gml', since this namespace was already
imported with the schema located at
'/usr/local/share/tinyows/schema/gml/2.1.2/feature.xsd'.

[Wed Apr  8 14:55:48 2015] [ERROR] Element
'{http://www.opengis.net/wfs}Query', attribute 'typeName': The QName value
'feature:v_last_nivo' has no corresponding namespace declaration in scope.

[Wed Apr  8 14:55:48 2015] [ERROR] Element
'{http://www.opengis.net/wfs}Query', attribute 'typeName':
'feature:v_last_nivo' is not a valid value of the atomic type 'xs:QName'.

[Wed Apr  8 14:55:48 2015] [ERROR] Element
'{http://www.opengis.net/wfs}Query', attribute 'xmlns:feature': The
attribute 'xmlns:feature' is not allowed.

[Wed Apr  8 14:55:48 2015] [ERROR] XML request isn't valid/


And by Iexplorer I got this error message:

/?xml version='1.0' encoding='UTF-8'?
ows:ExceptionReport
 xmlns='http://www.opengis.net/ows'
 xmlns:ows='http://www.opengis.net/ows'
 xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
 xsi:schemaLocation='http://www.opengis.net/ows
http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd'
 version='1.1.0' language='en'
 ows:Exception exceptionCode='InvalidParameterValue' locator='request'
  ows:ExceptionTextXML request isn't valid/ows:ExceptionText
 /ows:Exception
/ows:ExceptionReport/


There is a solution to that?
Thanks very much




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/WFS-from-Tinyows-on-IExplorer-InvalidParameterValue-tp5200463.html

Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] ms7 How to use FILTER

[Steve . Toutant]

I'm confused on how to use FILTER when datasource is postgis or Oracle 
Spatial (Native Connection)

In an old thread, I was told to not use FILTER, but use a WHERE clause in 
the Data statement.
In the ms7 Mapfile-Layer-Data doc, I see for Oracle
Note that there are important performance impacts when using spatial 
subqueries however. Try using MapServer?s FILTER whenever possible 
instead.

I remember I had a bug with MS6 when using FILTER using WFS. A getfeature 
on the layer with a spatial or logical filter, the FILTEr in the mapfile 
was overwritten.
Please, how should we define/use FILTER int a mapfile with postgis and 
also oracle (using native connection, not ogr)?
THANKS!
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] ms7 How to use FILTER

[Steve . Toutant]

Thanks Steve, yes it helps!

If an SQL query is needed, would you suggest to do it in the DATA 
statement as a subquery or use PROCESSING ?native_filter=native SQL 
string?
steve



Lime, Steve D (MNIT) steve.l...@state.mn.us 
2015-03-26 10:20

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca, 
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
cc

Objet
RE: [mapserver-users] ms7 How to use FILTER








MapServer FILTERs are now only written using MapServer expression syntax 
(e.g. (?[someitem]? != ?someval?)). Drivers can support translation 
capabilities to create native SQL under the hood. This was done to 
standardize the syntax across all drivers. Prior to 7.0 the syntax varied 
by driver. In addition, FILTER values are preserved when used with WFS or 
native MapServer attribute queries.
 
With database backends there has been little reason to use FILTERs since 
you could often just extend the DATA statement. 
 
Note that if need to you can still define a native SQL independently of 
the DATA statement using the processing tag ?native_filter?, for example:
 
  PROCESSING ?native_filter=native SQL string?
 
This is also preserved with WFS. Does this help?
 
Steve
 
From: mapserver-users-boun...@lists.osgeo.org [
mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of 
steve.tout...@inspq.qc.ca
Sent: Thursday, March 26, 2015 8:20 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] ms7 How to use FILTER
 
I'm confused on how to use FILTER when datasource is postgis or Oracle 
Spatial (Native Connection) 

In an old thread, I was told to not use FILTER, but use a WHERE clause in 
the Data statement. 
In the ms7 Mapfile-Layer-Data doc, I see for Oracle 
Note that there are important performance impacts when using spatial 
subqueries however. Try using MapServer?s FILTER whenever possible 
instead. 
I remember I had a bug with MS6 when using FILTER using WFS. A getfeature 
on the layer with a spatial or logical filter, the FILTEr in the mapfile 
was overwritten. 
Please, how should we define/use FILTER int a mapfile with postgis and 
also oracle (using native connection, not ogr)? 
THANKS! 


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE display only one district

[Steve . Toutant]

Have a look at runtime variable substitution
http://mapserver.org/cgi/runsub.html





rishi rish...@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-03-20 08:43

A
jmcke...@gatewaygeomatics.com, mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] display only one district








Hi all
 
Iam using Postgres database to diasplay districts on the google map

It is working.
But now i want to display only one district instead of 50.
In my database there are 50 districts data, but i want to display only 
one.
And also i have to use the same mapfile in to 3 projects, in one project 
all the districts has to be displayed and in one project only one district 
has to be display.

How to do this
plz send me the code___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] display only one district

[Steve . Toutant]

In other threads of this list, it was suggested to use a subquery in DATA 
instead of using FILTER, when postgis is used as a datasource.
http://mapserver.org/fr/input/vector/postgis.html#data-access-connection-method

If you want to use only one mapfile than runtime variable substitution can 
be used




Carlos Ruiz boolean10...@yahoo.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-03-20 14:53
Veuillez répondre à
Carlos Ruiz boolean10...@yahoo.com


A
rishi rish...@gmail.com, jmcke...@gatewaygeomatics.com 
jmcke...@gatewaygeomatics.com, mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.org
cc

Objet
Re: [mapserver-users] display only one district








Rishi,

From a MAP file approach, you can use the FILTER tag inside of the LAYER 
section:

FILTER [string]
This parameter allows for data specific attribute filtering that is done 
at the same time spatial filtering is done, but before any CLASS 
expressions are evaluated. For OGR and shapefiles the string is simply a 
mapserver regular expression. For spatial databases the string is a SQL 
WHERE clause that is valid with respect to the underlying database.

For example: FILTER ([type]=?road? and [size]2)
In a static way, you will need to have two MAP files (one without FILTER 
and another with FILTER) and you have to configure each project to point 
to the right MAP file.

 
Mtro. Carlos Ruiz

From: rishi rish...@gmail.com
To: jmcke...@gatewaygeomatics.com; mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.org 
Sent: Friday, March 20, 2015 6:43 AM
Subject: [mapserver-users] display only one district

Hi all
 
Iam using Postgres database to diasplay districts on the google map

It is working.
But now i want to display only one district instead of 50.
In my database there are 50 districts data, but i want to display only 
one.
And also i have to use the same mapfile in to 3 projects, in one project 
all the districts has to be displayed and in one project only one district 
has to be display.

How to do this
plz send me the code

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] MS7 wfs

[Steve . Toutant]

hello
Using mapserver 7 I make this request to get the number of features in a 
WFS layer. it returns numberOfFeatures=450361 
http://localhost/cgi-bin/ms7?version=1.1.0request=getfeatureservice=wfstypename=feature:aqreseauresultType=hits

this layer is a postgis table on localhost.
This request takes 18 seconds to run with mapserver 7
in postgis select count(*) from  table takes 61ms to run
the same request using a geoserver WFS takes less than 1 second

Is there something that can be done with MS7 to improve performance?
thanks


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WFS filter creates a query using a number instead of text

[Steve . Toutant]

Mapserver 7 beta solved this issue.At least for my use cases..
with and without using  gml_[item name]_type






John Abraham j...@hbaspecto.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2015-02-27 09:05

A
Rahkonen Jukka (MML) jukka.rahko...@maanmittauslaitos.fi
cc
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org, 
bte...@gmail.com bte...@gmail.com
Objet
Re: [mapserver-users] WFS filter creates a query using a number instead of 
text









On Feb 26, 2015, at 11:55 PM, Rahkonen Jukka (MML) 
jukka.rahko...@maanmittauslaitos.fi wrote:

You can also try to add 
gml_[item name]_type into the layer metadata
I have to add gml_[item name]_type in all my map files, to make them work 
as wfs in my context. 

--
John Abraham

Sent from my iPhone, please excuse any typos.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] mapserver 7 wfs_encoding

[Steve . Toutant]

Congratulations for the huge  improve performance for WFS filtering with 
postgis and oracle...


Mapserver 7 doesn't use wfs_encoding specified in the mapfile anymore, I 
see anything in the changelog about that.

Is there something change?___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapserver 7 wfs_encoding

[Steve . Toutant]

oh!

That means that if our database or datasource is encoded iso-8859-1, we 
need to set ENCODING iso-8859-1 in all our layers, there is no parameter 
at the MAP level right?

And,
Mapfiles themselves will be expected to be UTF8-encoded. Non UTF8-encoded 
mapfiles will need to be iconv?d to utf8.

That means we cannot right any mapfile in iso-8859-1. we need to set our 
IDe to write in utf-8.


Is my understanding correct?





thomas bonfort thomas.bonf...@gmail.com 
2015-02-13 10:21

A
steve.tout...@inspq.qc.ca
cc
MapserverList OSGEO mapserver-users@lists.osgeo.org
Objet
Re: [mapserver-users] mapserver 7 wfs_encoding








http://mapserver.org/development/rfc/ms-rfc-103.html

--
thomas

On 13 February 2015 at 10:17,  steve.tout...@inspq.qc.ca wrote:
 Congratulations for the huge  improve performance for WFS filtering with
 postgis and oracle...


 Mapserver 7 doesn't use wfs_encoding specified in the mapfile anymore, I 
see
 anything in the changelog about that.

 Is there something change?
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapserver doesn't send good filter to postgis

[Steve . Toutant]

I understand the objective of rfc 91, but the most common use case would 
be to pass the supplied geometry.
If mapserver doesn't use the supplied geometry, that means that it doesn't 
support spatial filtering. 
Our data covers the whole country, not using the supplied geometry means 
we can't use mapserver as a wfs server
Is there something we can do about it? A workaround we could use?







Lime, Steve D (MNIT) steve.l...@state.mn.us 
2015-01-26 10:14

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca, 
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
cc

Objet
RE: [mapserver-users] Mapserver doesn't send good filter to postgis








It?s a limitation in older versions of MapServer where specific backend 
optimizations were scattered about the WMS/WFS code. Most of those 
optimizations address the most common use cases ? I guess this wasn?t one 
of them. It?s surprising that at worst the extent of the supplied geometry 
isn?t passed (I see a comment in the WFS code about this). The specific 
filter intersection test is applied on the MapServer side ? the results 
are correct, performance can suffer though.
 
This is being addresses in MapServer 7.0 where more complete filter 
translation functions are being supported (RFC 91).
 
Steve
 
From: mapserver-users-boun...@lists.osgeo.org [
mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of 
steve.tout...@inspq.qc.ca
Sent: Monday, January 26, 2015 8:55 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Mapserver doesn't send good filter to postgis
 
Sorry my first post was with an inapprpriate title.. 

I'm using mapserver 6.4.1 and postgis 2.1 

using OpenLayers 2.13.1 I draw a small polygon that I use for a within 
spatial filter of a WFS getfeature request. The problem is that mapserver 
is not sending this polygon to postgis, it is sending the extent of the 
mapfile as filter... 

The wfs POST Request (created and send by OpenLayers client) 
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ogc:Withinogc:PropertyNamemsGeometry/ogc:PropertyNamegml:Polygon 
xmlns:gml=http://www.opengis.net/gml; 
srsName=urn:ogc:def:crs:EPSG::3857gml:exteriorgml:LinearRinggml:posList-8081644.2511244
 
5835062.56996 -8081707.5505384 5834980.1612889 -8081638.2794815 
5834913.2788892 -8081533.1785677 5834988.5215889 -8081644.2511244 
5835062.56996/gml:posList/gml:LinearRing/gml:exterior/gml:Polygon/ogc:Within/ogc:Filter
 


In Mapserver log, I see 
FLTLayerApplyPlainFilterToLayer():  ([shape]  within  fromText('POLYGON 
((-8081644.2511243997141719 5835062.569959934435, 
-8081707.5505384001880884 5834980.1612889003008604, 
-8081638.2794815003871918 5834913.2788891997188330, 
-8081533.1785677000880241 5834988.5215889001265168, 
-8081644.2511243997141719 5835062.569959934435))')) 

Then a few lines later, I see that it is not sending the polygon received 
as filter 
select ...  where geom_p  ST_GeomFromText('POLYGON((-9239517 
5465442,-9239517 9349764,-5565974 9349764,-5565974 5465442,-9239517 
5465442))',3857); 

See the polygon definition is different, postgis receive the extent 
defined in the mapfile 
EXTENT -9239517 5465442 -5565974 9349764 


And, in postgis log I see this query, See the 
select ... where geom_p  ST_GeomFromText('POLYGON((-9239517 
5465442,-9239517 9349764,-5565974 9349764,-5565974 5465442,-9239517 
5465442))',3857); 


Why Mapserver is not sending the polygon received as filter to postgis? 


Thanks! 
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
Tél.: 418 646-6777 poste 30015
Téléc.: 418 644-4593
steve.tout...@inspq.qc.ca
http://www.inspq.qc.ca
http://www.monclimatmasante.qc.ca 
Pour me rejoindre par courrier
Service de l'infrastructure et du réseau
Direction des technologies de l'information
Ministère de la Sécurité Publique
2525 boul. Laurier, 2e étage
Tour Laurentides
Québec, G1V 2L2 


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Mapserver doesn't send good filter to postgis

[Steve . Toutant]

Sorry my first post was with an inapprpriate title..

I'm using mapserver 6.4.1 and postgis 2.1

using OpenLayers 2.13.1 I draw a small polygon that I use for a within 
spatial filter of a WFS getfeature request. The problem is that mapserver 
is not sending this polygon to postgis, it is sending the extent of the 
mapfile as filter...

The wfs POST Request (created and send by OpenLayers client)
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ogc:Withinogc:PropertyNamemsGeometry/ogc:PropertyNamegml:Polygon 
xmlns:gml=http://www.opengis.net/gml; 
srsName=urn:ogc:def:crs:EPSG::3857gml:exteriorgml:LinearRinggml:posList-8081644.2511244
 
5835062.56996 -8081707.5505384 5834980.1612889 -8081638.2794815 
5834913.2788892 -8081533.1785677 5834988.5215889 -8081644.2511244 
5835062.56996/gml:posList/gml:LinearRing/gml:exterior/gml:Polygon/ogc:Within/ogc:Filter
 


In Mapserver log, I see
FLTLayerApplyPlainFilterToLayer():  ([shape]  within  fromText('POLYGON 
((-8081644.2511243997141719 5835062.569959934435, 
-8081707.5505384001880884 5834980.1612889003008604, 
-8081638.2794815003871918 5834913.2788891997188330, 
-8081533.1785677000880241 5834988.5215889001265168, 
-8081644.2511243997141719 5835062.569959934435))'))

Then a few lines later, I see that it is not sending the polygon received 
as filter
select ...  where geom_p  ST_GeomFromText('POLYGON((-9239517 
5465442,-9239517 9349764,-5565974 9349764,-5565974 5465442,-9239517 
5465442))',3857);

See the polygon definition is different, postgis receive the extent 
defined in the mapfile
EXTENT -9239517 5465442 -5565974 9349764


And, in postgis log I see this query, See the
select ... where geom_p  ST_GeomFromText('POLYGON((-9239517 
5465442,-9239517 9349764,-5565974 9349764,-5565974 5465442,-9239517 
5465442))',3857);


Why Mapserver is not sending the polygon received as filter to postgis?


Thanks!

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
Tél.: 418 646-6777 poste 30015
Téléc.: 418 644-4593
steve.tout...@inspq.qc.ca
http://www.inspq.qc.ca
http://www.monclimatmasante.qc.ca 
Pour me rejoindre par courrier
Service de l'infrastructure et du réseau
Direction des technologies de l'information
Ministère de la Sécurité Publique
2525 boul. Laurier, 2e étage
Tour Laurentides
Québec, G1V 2L2
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapserver doesn't send good filter to postgis

[Steve . Toutant]

 
5465442))',3857); 

See the polygon definition is different, postgis receive the extent 
defined in the mapfile 
EXTENT -9239517 5465442 -5565974 9349764 


And, in postgis log I see this query, See the 
select ... where geom_p  ST_GeomFromText('POLYGON((-9239517 
5465442,-9239517 9349764,-5565974 9349764,-5565974 5465442,-9239517 
5465442))',3857); 


Why Mapserver is not sending the polygon received as filter to postgis? 


Thanks! 
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
Tél.: 418 646-6777 poste 30015
Téléc.: 418 644-4593
steve.tout...@inspq.qc.ca
http://www.inspq.qc.ca
http://www.monclimatmasante.qc.ca 
Pour me rejoindre par courrier
Service de l'infrastructure et du réseau
Direction des technologies de l'information
Ministère de la Sécurité Publique
2525 boul. Laurier, 2e étage
Tour Laurentides
Québec, G1V 2L2 



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Does WFS filter use spatial index?

[Steve . Toutant]

I'm using mapserver 6.4.1 and postgis 2.1

using OpenLayers 2.13.1 I draw a small polygon that I use for a within 
spatial filter of a WFS getfeature request. The problem is that mapserver 
is not sending this polygon to postgis, it is sending the extent of the 
mapfile as filter...

The wfs POST Request (created and send by OpenLayers client)
ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
ogc:Withinogc:PropertyNamemsGeometry/ogc:PropertyNamegml:Polygon 
xmlns:gml=http://www.opengis.net/gml; 
srsName=urn:ogc:def:crs:EPSG::3857gml:exteriorgml:LinearRinggml:posList-8081644.2511244
 
5835062.56996 -8081707.5505384 5834980.1612889 -8081638.2794815 
5834913.2788892 -8081533.1785677 5834988.5215889 -8081644.2511244 
5835062.56996/gml:posList/gml:LinearRing/gml:exterior/gml:Polygon/ogc:Within/ogc:Filter
 


In Mapserver log, I see
FLTLayerApplyPlainFilterToLayer():  ([shape]  within  fromText('POLYGON 
((-8081644.2511243997141719 5835062.569959934435, 
-8081707.5505384001880884 5834980.1612889003008604, 
-8081638.2794815003871918 5834913.2788891997188330, 
-8081533.1785677000880241 5834988.5215889001265168, 
-8081644.2511243997141719 5835062.569959934435))'))

But, in postgis log I see this query, See the
select * from msp.aq_v2_3857 where geom_p  
ST_GeomFromText('POLYGON((-9239517 5465442,-9239517 9349764,-5565974 
9349764,-5565974 5465442,-9239517 5465442))',3857);

See the polygon definition is different, postgis receive the extent 
defined in the mapfile
EXTENT -9239517 5465442 -5565974 9349764

Why Mapserver is sending this polygon to postgis?


Thanks!
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapserver doesn't send good filter to postgis

[Steve . Toutant]

-users-bounces@lists.osgeo.org_
 mailto:mapserver-users-boun...@lists.osgeo.org
 [_mailto:mapserver-users-bounces@lists.osgeo.org_] *On Behalf Of
 *_steve.tout...@inspq.qc.ca_ mailto:steve.tout...@inspq.qc.ca*
 Sent:* Monday, January 26, 2015 8:55 AM*
 To:* _mapserver-users@lists.osgeo.org_
 mailto:mapserver-users@lists.osgeo.org*
 Subject:* [mapserver-users] Mapserver doesn't send good filter to 
postgis

 Sorry my first post was with an inapprpriate title..

 I'm using mapserver 6.4.1 and postgis 2.1

 using OpenLayers 2.13.1 I draw a small polygon that I use for a within
 spatial filter of a WFS getfeature request. The problem is that
 mapserver is not sending this polygon to postgis, it is sending the
 extent of the mapfile as filter...

 The wfs POST Request (created and send by OpenLayers client)
 ogc:Filter
 
xmlns:ogc=_http://www.opengis.net/ogc_;ogc:Withinogc:PropertyNamemsGeometry/ogc:PropertyNamegml:Polygon
 xmlns:gml=_http://www.opengis.net/gml_;
 
srsName=urn:ogc:def:crs:EPSG::3857gml:exteriorgml:LinearRinggml:posList-8081644.2511244
 5835062.56996 -8081707.5505384 5834980.1612889 -8081638.2794815
 5834913.2788892 -8081533.1785677 5834988.5215889 -8081644.2511244
 
5835062.56996/gml:posList/gml:LinearRing/gml:exterior/gml:Polygon/ogc:Within/ogc:Filter


 In Mapserver log, I see
 FLTLayerApplyPlainFilterToLayer():  ([shape]  within  fromText('POLYGON
 ((-8081644.2511243997141719 5835062.569959934435,
 -8081707.5505384001880884 5834980.1612889003008604,
 -8081638.2794815003871918 5834913.2788891997188330,
 -8081533.1785677000880241 5834988.5215889001265168,
 -8081644.2511243997141719 5835062.569959934435))'))

 Then a few lines later, I see that it is not sending the polygon
 received as filter
 select ...  where geom_p  ST_GeomFromText('POLYGON((-9239517
 5465442,-9239517 9349764,-5565974 9349764,-5565974 5465442,-9239517
 5465442))',3857);

 See the polygon definition is different, postgis receive the extent
 defined in the mapfile
 EXTENT -9239517 5465442 -5565974 9349764


 And, in postgis log I see this query, See the
 select ... where geom_p  ST_GeomFromText('POLYGON((-9239517
 5465442,-9239517 9349764,-5565974 9349764,-5565974 5465442,-9239517
 5465442))',3857);


 Why Mapserver is not sending the polygon received as filter to postgis?


 Thanks!

 /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
 Tél.: 418 646-6777 poste 30015
 Téléc.: 418 644-4593_
 __steve.tout...@inspq.qc.ca_ mailto:steve.tout...@inspq.qc.ca_
 __http://www.inspq.qc.ca_ http://www.inspq.qc.ca/_
 __http://www.monclimatmasante.qc.ca_ http://www.monclimatmasante.qc.ca/


 /Pour me rejoindre par courrier/
 Service de l'infrastructure et du réseau
 Direction des technologies de l'information
 Ministère de la Sécurité Publique
 2525 boul. Laurier, 2e étage
 Tour Laurentides
 Québec, G1V 2L2





 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] WFS DescribeFeatureType returns string for all attributes

[Steve . Toutant]

Hi,
I'm using mapserv 6.4.1 as a wfs server to publish hundreds of layers. 
Most of the Layers are Postgis table or view
DescribeFeatureType on a layer returns string as data type for each 
attributes. This is an issue when we want to flter on WFS layer.

I saw that this issue was discussed years ago
https://github.com/mapserver/docs/issues/65

Before Adding gml_[item name]_type for each non string attributes of every 
layers...Is there a plan to fix this bug?

thank you
Steve


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] WFS DescribeFeatureType returns string for all attributes

[Steve . Toutant]

Yes it works!
I didn't know about this

Wow, Many thanks
Steve




Smith, Michael ERDC-RDE-CRREL-NH michael.sm...@erdc.dren.mil 
2014-10-10 12:29

A
steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca, 
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
cc

Objet
Re: [EXTERNAL] [mapserver-users] WFS DescribeFeatureType returns string 
for all attributes








Steve,

Does 

?gml_types?  ?auto

not work for you?

Mike

-- 
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers

From:  steve.tout...@inspq.qc.ca steve.tout...@inspq.qc.ca
Date:  Friday, October 10, 2014 at  12:14 PM
To:  mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
Subject:  [EXTERNAL] [mapserver-users] WFS DescribeFeatureType returns 
string for all attributes
Resent-From:  Michael Smith michael.sm...@usace.army.mil


Hi, 
I'm using mapserv 6.4.1 as a wfs server to publish hundreds of layers. 
Most of the Layers are Postgis table or view
DescribeFeatureType on a layer returns string as data type for each 
attributes. This is an issue when we want to flter on WFS layer.

I saw that this issue was discussed years ago
https://github.com/mapserver/docs/issues/65

Before Adding gml_[item name]_type for each non string attributes of every 
layers...Is there a plan to fix this bug?

thank you 
Steve 





___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Rendering OSM data with MapServer+MapCache

[Steve . Toutant]

If you can use postgis this might help
https://github.com/mapserver/mapserver/wiki/RenderingOsmDataWindows


Steve




Juanma M. R. juanma...@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-10-07 12:13

A
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] Rendering OSM data with MapServer+MapCache








Dear list,

I have managed to install and configure succesfully a server showing data 
from OSM with the MapServer+MapCache convination. I followed these 
instructions and some hacks that were necessary.

The issue is that I have migrated from a mapnik+mod_tile server because 
some requirements that it didn't acomplished but the rendering of the map 
with mapnik was the same as the one shown in the OSM server. 

I also managed to configure a mapserver (without cache feature) with a 
.map file styling OSM but it is neither the one from OSM server. 

Does anyone know how to apply this style, the one from OSM server, to this 
data being renderd by MapServer? Does anyone done the migration from the 
OSM server style to mapfile or XML format for MapServer?

Regards,
Juan Manuel Moreno Rivera. 
Sección de Teledetección y SIG / Remote Sensing  GIS group
Instituto de Desarrollo Regional / Institute for Regional Development
Universidad de Castilla-La Mancha / University of Castilla-La Mancha
Tlf: +34 967599200 (Ext: 2623)
http://www.teledeteccionysig.es/
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Rendering OSM data with MapServer+MapCache

[Steve . Toutant]

I'm sorry I just saw the link you provided that uses basemap.
I didn't read it but hopefully you'll find some answers in the link I 
provided




Juanma M. R. juanma...@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-10-07 12:13

A
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] Rendering OSM data with MapServer+MapCache








Dear list,

I have managed to install and configure succesfully a server showing data 
from OSM with the MapServer+MapCache convination. I followed these 
instructions and some hacks that were necessary.

The issue is that I have migrated from a mapnik+mod_tile server because 
some requirements that it didn't acomplished but the rendering of the map 
with mapnik was the same as the one shown in the OSM server. 

I also managed to configure a mapserver (without cache feature) with a 
.map file styling OSM but it is neither the one from OSM server. 

Does anyone know how to apply this style, the one from OSM server, to this 
data being renderd by MapServer? Does anyone done the migration from the 
OSM server style to mapfile or XML format for MapServer?

Regards,
Juan Manuel Moreno Rivera. 
Sección de Teledetección y SIG / Remote Sensing  GIS group
Instituto de Desarrollo Regional / Institute for Regional Development
Universidad de Castilla-La Mancha / University of Castilla-La Mancha
Tlf: +34 967599200 (Ext: 2623)
http://www.teledeteccionysig.es/
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] WFS getfeature returns nothing if layer srs is 4326

[Steve . Toutant]

I have a mapfile in srs 3857, using mapserv 6.1 (dev version)
In this mapfile I have 
2 layers with srs 4326
1 layer with 900913
1 layer with 32198

Since 6.0 we can have several srs in a WFS I think
All layers Data source is a postgis table


GetFeatures request don't work for the 2 layers in 4326. See The 
getCapabilities returns bad value for WGS84BoundingBox
- FeatureType
  Namecardiologie/Name 
  Titlecardiologie/Title 
  DefaultSRSurn:ogc:def:crs:EPSG::3857/DefaultSRS 
- OutputFormats
  Formattext/xml; subtype=gml/3.1.1/Format 
  /OutputFormats
- ows:WGS84BoundingBox dimensions=2
  ows:LowerCorner-2500 -2500/ows:LowerCorner 
  ows:UpperCorner2500 2500/ows:UpperCorner 
  /ows:WGS84BoundingBox
  /FeatureType

Compares with a layer in 32198. See valid values for WGS84BoundingBox
  - FeatureType
  Namechsld/Name 
  Titlechsld/Title 
  DefaultSRSurn:ogc:def:crs:EPSG::3857/DefaultSRS 
- OutputFormats
  Formattext/xml; subtype=gml/3.1.1/Format 
  /OutputFormats
- ows:WGS84BoundingBox dimensions=2
  ows:LowerCorner-178.714246078922 -66.3067843156478/ows:LowerCorner 
  ows:UpperCorner179.855210132046 -35.1587587019759/ows:UpperCorner 
  /ows:WGS84BoundingBox
  /FeatureType

I created a geometry column in 32198 for these 2 layers, and the 
everything work
Any idea on the issue here? Why coordinates are invalid when using 4326?
thank
steve___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE Dynamically extent and layer filter

[Steve . Toutant]

In your mapfile you could set FILTER id in (%ID%) .
And in the url pass a string as parameter such as id=1,4,8
That would be a simple way

Please post further question on mapserver list, so others can answer you, 
and the answers can help other people later
thanks
steve





Dedy Fuadi sampahe@gmail.com 
2014-05-30 11:28

A
steve.tout...@inspq.qc.ca
cc

Objet
Re: RE [mapserver-users] Dynamically extent and layer filter








Hi Steve,

Your advice is nicely work for me! :D

But how to select more than one data from postgis by VALIDATION block? For 
example, I have a postgis table that have 20 data, then I wanto to select 
data 1,4,8, or else to display by customizing URL parameter. I set '%id%' 
as my variable at mapfile, I just can display one data like id=1.

Please for your help.
Thank you.


On Fri, May 30, 2014 at 8:30 PM, steve.tout...@inspq.qc.ca wrote:

Hi 
What did you try and what happened? Something in the mapserver log. 
If I understand well you want to use run time substitution, if so here a 
link 
http://mapserver.org/cgi/runsub.html 

Make sure you have a VALIDATION block 
Steve 




Dedy Fuadi sampahe@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org 
2014-05-30 06:52 


A
mapserver-users@lists.osgeo.org 
cc

Objet
[mapserver-users] Dynamically extent and layer filter










Hello friends, 

I just success applying filter data for postgis database on my mapfile, 
but I met problem when I was to try use dynamic variable for filter data 
and extent map like variable at php file. 

What should I do for solving this problem? Whether mapfile can be a 
dynamically file like php? 

Thank you, 
regards.___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users 





___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE Dynamically extent and layer filter

[Steve . Toutant]

Begin with a simple validation until it works.  Is it working if you set 
VALIDATION
id '.*'
END

If yes then the problem is in your regex. Make sure that ',' are accepted.
If not the problem is the FILTER or the parameter you pass. 

Also Is your ID an integer or text in postgis? I think it matters.
('%id%') this would send a string to pg. In this case try FILTER  id in 
('%id%'), otherwise try
FILTER  id in (%id%)

It is not an easy task (in my opinion) in mapserv to use expresion and 
filter
But have a look at this. there are several examples
http://mapserver.org/fr/mapfile/expressions.html#string-expressions-that-return-a-logical-value

Also in you MAPFILE set  debug 5 in the MAP block, and also in your layer 
block. You will have more info in your mapserver log.
steve




Dedy Fuadi sampahe@gmail.com 
2014-05-30 12:17

A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org
Objet
Re: RE [mapserver-users] Dynamically extent and layer filter








This is my mapfile part :
VALIDATION
'id' '^[0-9]{1}$'
END
FILTER  (id in ('%id%'))

and as your advice I set URL parameter like id=1,4,8 but the map is not 
appears there.

When I opened debug, I found :
[Sat May 31 00:10:34 2014].758000 msEvalRegex(): Regular expression error. 
String failed expression test.
[Sat May 31 00:10:34 2014].758000 loadForm(): Web application error. 
Parameter 'id' value fails to validate.


On Fri, May 30, 2014 at 11:42 PM, steve.tout...@inspq.qc.ca wrote:

In your mapfile you could set FILTER id in (%ID%) . 
And in the url pass a string as parameter such as id=1,4,8 
That would be a simple way 

Please post further question on mapserver list, so others can answer you, 
and the answers can help other people later 
thanks 
steve




Dedy Fuadi sampahe@gmail.com 
2014-05-30 11:28 


A
steve.tout...@inspq.qc.ca 
cc

Objet
Re: RE [mapserver-users] Dynamically extent and layer filter










Hi Steve, 

Your advice is nicely work for me! :D 

But how to select more than one data from postgis by VALIDATION block? For 
example, I have a postgis table that have 20 data, then I wanto to select 
data 1,4,8, or else to display by customizing URL parameter. I set '%id%' 
as my variable at mapfile, I just can display one data like id=1. 

Please for your help. 
Thank you. 


On Fri, May 30, 2014 at 8:30 PM, steve.tout...@inspq.qc.ca wrote: 

Hi 
What did you try and what happened? Something in the mapserver log. 
If I understand well you want to use run time substitution, if so here a 
link 
http://mapserver.org/cgi/runsub.html 

Make sure you have a VALIDATION block 
Steve 



Dedy Fuadi sampahe@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org 
2014-05-30 06:52 


A
mapserver-users@lists.osgeo.org 
cc

Objet
[mapserver-users] Dynamically extent and layer filter












Hello friends, 

I just success applying filter data for postgis database on my mapfile, 
but I met problem when I was to try use dynamic variable for filter data 
and extent map like variable at php file. 

What should I do for solving this problem? Whether mapfile can be a 
dynamically file like php? 

Thank you, 
regards.___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users 








___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] About FILTER and FILTERITEM

[Steve . Toutant]

Filter is defined at the LAYER level while expression is defined at CLASS 
level.
So you could use expression for rendering filtered values

using expression without filter means that you query all the data.






Rahkonen Jukka  (Tike) jukka.rahko...@mmmtike.fi@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-05-14 09:05

A
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
cc

Objet
Re: [mapserver-users] About FILTER and FILTERITEM








Hi,

Thank you very much, Christy. By your example I made some tests and now 
filters like this work for me
FILTER (([WORKERS]2000) OR ([STATE_FIPS]=17))

The secret element was the right syntax for string attributes 
([STATE_FIPS]=17).
Now when I know how it must be used I can find corresponding examples from 
the expression page of Mapserver documentation. Could someone explain 
shortly what is the difference between filter and expression? To me they 
seem to do pretty similar work.

-Jukka Rahkonen-

Christy Nieman wrote:

 You do not need to set both FILTERITEM and FILTER.  You can just set 
FILTER to
 an expression using as many attributes as you need. e.g.
 FILTER (( [POPULATION]  50 ) AND ([DISPLAY] == 1)). Just like 
you can
 have multiple attributes in a class EXPRESSION.
 
 I think it's the section of the document that is key - the MapServer 
Expressions
 section talks about using FILTER and EXPRESSION in more complex logical
 expressions, where as the section you quoted is talking about basic 
string
 comparison.
 
 Christy
 
 On 14/05/14 08:03 AM, Rahkonen Jukka (Tike) wrote:
  Hi,
 
   From document page: http://mapserver.org/mapfile/expressions.html
  To use a string comparison for filtering a LAYER, both FILTERITEM and 
FILTER
 must be set. FILTERITEM is set to the attribute name. FILTER is set to 
the value
 for comparison. The same rule applies to CLASSITEM in the LAYER object 
and
 EXPRESSION in the CLASS object.
 
  That would mean that only one attribute from the data can be used for
 building a filter. Is this true or just old information living in the 
document?
 
  -Jukka Rahkonen-
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] About FILTER and FILTERITEM

[Steve . Toutant]

Steve, I'm using postgis and runtime variable substitution in the filter.
Should I avoid FILTER and do the runtime variable substitution in DATA?

thanks
steve



Lime, Steve D (MNIT) steve.l...@state.mn.us@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-05-14 09:25

A
Rahkonen Jukka  (Tike) jukka.rahko...@mmmtike.fi, 
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
cc

Objet
Re: [mapserver-users] About FILTER and FILTERITEM








FIlters are used primarily under the hood for certain types of query 
operations. The main differences are:

  - FILTERs are defined in the native query language of the underlying 
driver. So for PostGIS you'd actually write a little SQL snippet.
  - FILTERs are applied when data are pulled from the underlying data 
source (like a WHERE clause) and have no impact on rendering choices.

For drivers that don't have an native query capability (e.g. shapefiles) 
the syntax is identical to expressions. For drivers that do have a native 
query capability there really isn't much use for filters since you can 
just add a where clause to the data statement.

Where I have found them useful sometimes is for simplifying class 
expressions. Let's say you have a shapefile and you only want to show 
features of a certain type, and then for those features you want to draw 
things differently based on another attribute.

You could use logical expressions:

CLASS
  EXPRESSION ([type] = 1 AND '[attr]' = 'a')
  ...
END
CLASS
  EXPRESSION ([type] = 1 AND '[attr]' = 'b')
  ...
END

or you could use a combination of FILTER and EXPRESSIONS

FILTERITEM 'type'
FILTER '1'

CLASSITEM 'attr'
CLASS
  EXPRESSION 'a'
  ...
END
CLASS
  EXPRESSION 'b'
  ...
END

Personal preference I guess and the second option is a bit more 
performant, especially in older versions. I guess my recommendation would 
be avoid FILTERs unless you have a good reason to use them.

Steve


From: mapserver-users-boun...@lists.osgeo.org 
[mapserver-users-boun...@lists.osgeo.org] on behalf of Rahkonen Jukka 
(Tike) [jukka.rahko...@mmmtike.fi]
Sent: Wednesday, May 14, 2014 8:05 AM
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] About FILTER and FILTERITEM

Hi,

Thank you very much, Christy. By your example I made some tests and now 
filters like this work for me
FILTER (([WORKERS]2000) OR ([STATE_FIPS]=17))

The secret element was the right syntax for string attributes 
([STATE_FIPS]=17).
Now when I know how it must be used I can find corresponding examples from 
the expression page of Mapserver documentation. Could someone explain 
shortly what is the difference between filter and expression? To me they 
seem to do pretty similar work.

-Jukka Rahkonen-

Christy Nieman wrote:

 You do not need to set both FILTERITEM and FILTER.  You can just set 
FILTER to
 an expression using as many attributes as you need. e.g.
 FILTER (( [POPULATION]  50 ) AND ([DISPLAY] == 1)). Just like 
you can
 have multiple attributes in a class EXPRESSION.

 I think it's the section of the document that is key - the MapServer 
Expressions
 section talks about using FILTER and EXPRESSION in more complex logical
 expressions, where as the section you quoted is talking about basic 
string
 comparison.

 Christy

 On 14/05/14 08:03 AM, Rahkonen Jukka (Tike) wrote:
  Hi,
 
   From document page: http://mapserver.org/mapfile/expressions.html
  To use a string comparison for filtering a LAYER, both FILTERITEM and 
FILTER
 must be set. FILTERITEM is set to the attribute name. FILTER is set to 
the value
 for comparison. The same rule applies to CLASSITEM in the LAYER object 
and
 EXPRESSION in the CLASS object.
 
  That would mean that only one attribute from the data can be used for
 building a filter. Is this true or just old information living in the 
document?
 
  -Jukka Rahkonen-
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users

 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] MapCache and GetLegendGraphic

[Steve . Toutant]

I successfully added a forwarding rule so mapcache can send a 
getLegendGraphics request

forwarding_rule name=getLegendGraphics
   param name=REQUEST type=valuesGetLegendGraphic/param
   param name=SERVICE type=valuesWMS/param
   http
 urlhttp:///cgi-wms/mapserv.fcgi?map=wms.map/url
   /http
 /forwarding_rule

It is working for zoom level 9 - 19If I zoom out at level 8 to 0, the 
getLegendGraphics request returns this
?xml version='1.0' encoding=ISO-8859-1 standalone=no ?
!DOCTYPE ServiceExceptionReport SYSTEM 
http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd;
ServiceExceptionReport version=1.1.1
ServiceException code=LayerNotDefined
msWMSGetLegendGraphic(): WMS server error. Mandatory LAYER parameter 
missing in GetLegendGraphic request.
/ServiceException
/ServiceExceptionReport

I clearly see that LAYER parameter is there. Actually, except for SCALE 
parameter, the URL is the same as the one for zoom level 9 and +

Working url zoom level 9
...SERVICE=WMSVERSION=1.1.1REQUEST=GetLegendGraphicLAYER=temperature_surfaceSCALE=866685.8312779219FORMAT=image%2Fpng

Non Working url zoom level 8
...SERVICE=WMSVERSION=1.1.1REQUEST=GetLegendGraphicLAYER=temperature_surfaceSCALE=1733371.6625558438FORMAT=image%2Fpng

In mapcache config I don't have a restricted_extent for this layer neither 
min/max zoom parameter

I don't know what to look for anymore, any ideas?

thank you 
Steve
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] MapCache and GetLegendGraphic

[Steve . Toutant]

Thanks Jeff but it happens with 3 layers and they are not in a GROUP.
If I request the legend on the  WMS directly it works.
It seems that mapcache is not sending the LAYER parameter in some 
circumstances...





Jeff McKenna jmcke...@gatewaygeomatics.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-05-08 10:34

A
mapserver-users@lists.osgeo.org
cc

Objet
Re: [mapserver-users] MapCache and GetLegendGraphic








On 2014-05-08, 11:14 AM, steve.tout...@inspq.qc.ca wrote:
 
 It is working for zoom level 9 - 19If I zoom out at level 8 to 0,
 the getLegendGraphics request returns this
 ?xml version='1.0' encoding=ISO-8859-1 standalone=no ?
 !DOCTYPE ServiceExceptionReport SYSTEM
 http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd;
 ServiceExceptionReport version=1.1.1
 ServiceException code=LayerNotDefined
 msWMSGetLegendGraphic(): WMS server error. Mandatory LAYER parameter
 missing in GetLegendGraphic request.
 /ServiceException
 /ServiceExceptionReport
 

Ah I recently hit this same error with GetLegendGraphic requests to a
MapServer WMS layer.  I used the Nabble search in the MapServer forum,
to read how this generic error is thrown for MapServer layers that are
in a GROUP.  There are tickets and discussions about that.  Anyway, not
sure if it is related to your issue, but you could also search the
archives to see what I mean.
http://osgeo-org.1560.x6.nabble.com/MapServer-f4226623.html

-jeff




-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] MapCache and GetLegendGraphic

[Steve . Toutant]

Is it possible to make a getLegendGraphic Request via MapCache?
I Tried but can't make it work

Thanks
Steve
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Exclude one layer's class from GetLegendGraphics

[Steve . Toutant]

Perhaps you could use 
RULE - (Optional) Specify the name of the CLASS to generate the legend 
image for (as opposed to generating an icon and label for ALL classes for 
the layer).
http://mapserver.org/ogc/wms_server.html

Perhaps you can put several rule in the WMS call

I just realize that RULE is not included in the Mapserver CLASS doc

For your second question, encoding is still a mystery I'm trying to 
understand






Rahkonen Jukka  (Tike) jukka.rahko...@mmmtike.fi@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-04-10 02:13

A
gorank kirandzis...@gmail.com, mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.org
cc

Objet
Re: [mapserver-users] Exclude one layer's class from GetLegendGraphics








Hi,

For the first question I am remembering that only classes with NAME go to 
the legend. I may be wrong but you can try it easily.

-Jukka Rahkonen-


gorank wrote:
 
 Actually i have to questions:
 
 1). I have mapfile with few layers. In one layer I have 5 classes with 
expresions.
 When show legend with GetLegendGraphics always all 5 classes are shown
 although one class is empty (for instance class expression is ([2011] = 
0) and in
 the shapefile attributes there is no value 0).
 
 My question is how to exclude class from the legend. I tried with STATUS 
OFF in
 the CLASS but do not work.
 
 2). I use cyrilic font for polygon labels and for legend titles. When I 
put class title
 with unicode and save mapfile as unicode, OpenLayers app show empty map 
in
 the browser. When I put latin text and sava mapfile as ASCII the same 
map is
 shown in the browser. What i am missing.
 
 Example from the mapfile.
 CLASS
   NAME klasa_1
   EXPRESSION ([2011]  0 and [2011]  5)
   LABEL
 FONT arial
 SIZE 8
 ENCODING UTF-8
 OFFSET 0 0
 POSITION CC
 SHADOWSIZE 1 1
 TYPE TRUETYPE
   END # LABEL
   STYLE
 COLOR 255 255 128
 OUTLINECOLOR 130 130 130
 WIDTH 0.5
   END # STYLE
   TITLE 4.9 or less
 END # CLASS
 CLASS
   NAME klasa_2
   EXPRESSION ([2011] = 5 and [2011]  10)
   LABEL
 FONT arial
 SIZE 8
 ENCODING UTF-8
 OFFSET 0 0
 POSITION CC
 SHADOWSIZE 1 1
 TYPE TRUETYPE
   END # LABEL
   STYLE
 COLOR 250 209 85
 OUTLINECOLOR 130 130 130
 WIDTH 0.5
   END # STYLE
   TITLE 5.0 - 9.9
 END # CLASS
 CLASS
   NAME klasa_3
   EXPRESSION ([2011] =10 and [2011]  15)
   LABEL
 FONT arial
 SIZE 8
 ENCODING UTF-8
 OFFSET 0 0
 POSITION CC
 SHADOWSIZE 1 1
 TYPE TRUETYPE
   END # LABEL
   STYLE
 COLOR 242 167 46
 OUTLINECOLOR 130 130 130
 WIDTH 0.5
   END # STYLE
   TITLE 10.0 - 14.9
 END # CLASS
 CLASS
   NAME klasa_4
   EXPRESSION ([2011] = 15 and [2011]  20)
   LABEL
 FONT arial
 SIZE 8
 ENCODING UTF-8
 OFFSET 0 0
 POSITION CC
 SHADOWSIZE 1 1
 TYPE TRUETYPE
   END # LABEL
   STYLE
 COLOR 173 83 19
 OUTLINECOLOR 130 130 130
 WIDTH 0.5
   END # STYLE
   TITLE 15.0 - 19.9
 END # CLASS
 CLASS
   NAME klasa_5
   EXPRESSION ([2011] = 20 and [2011]  1)
   LABEL
 FONT arial
 SIZE 8
 ENCODING UTF-8
 OFFSET 0 0
 POSITION CC
 SHADOWSIZE 1 1
 TYPE TRUETYPE
   END # LABEL
   STYLE
 COLOR 107 0 0
 OUTLINECOLOR 130 130 130
 WIDTH 0.5
   END # STYLE
   TITLE 20 and more
 END # CLASS
 CLASS
   STATUS ON
   NAME klasa_0
   EXPRESSION ([2011] = 10)
   LABEL
 FONT arial
 SIZE 8
 ENCODING UTF-8
 OFFSET 0 0
 POSITION CC
 SHADOWSIZE 1 1
 TYPE TRUETYPE
   END # LABEL
   STYLE
 COLOR 100 100 100
 OUTLINECOLOR 130 130 130
 WIDTH 0.5
   END # STYLE
   TITLE no event
 END # CLASS
 CLASS
   STATUS OFF
   NAME klasa_00
   EXPRESSION ([2011] = 1)
   LABEL
 FONT arial
 SIZE 8
 ENCODING UTF-8
 OFFSET 0 0
 POSITION CC
 SHADOWSIZE 1 1
 TYPE TRUETYPE
   END # LABEL
   STYLE
 COLOR 200 200 200
 OUTLINECOLOR 130 130 130
 WIDTH 0.5
   END # STYLE
   TITLE no event1
 END # CLASS
 
 
 
 --
 View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Exclude-
 one-layer-s-class-from-GetLegendGraphics-tp5134193.html
 Sent from the Mapserver - User mailing list archive at Nabble.com.
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
___

[mapserver-users] WFS filter creates a query using a number instead of text

[Steve . Toutant]

The problem is when we send a string that represents a number, example:
Filter=FilterPropertyIsEqualToPropertyNamecode_cs
/PropertyNameLiteral864000/Literal/PropertyIsEqualTo/Filter

I get:
ERROR:  operator does not exist: character varying = integer
code_cs= 864000

DescribeFeatureType returns
element name=code_cs type=string /

In posgis, code_cs is defined as character varying(18)

My workaround is using Like instead of EqualTo
Filter=FilterPropertyIsLike wildcard='*' singleChar='.' 
escape='!'PropertyNamecode_cs/PropertyNameLiteral864000/Literal/PropertyIsLike/Filter

Is this a bug in mapserver, creating the query using a number, even if 
DescribeFeatureType returns 'string' as type?

thanks
Steve


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] update MS4W

[Steve . Toutant]

I like MS4W to quickly have a Mapserver up and running. I might be able to 
contribute to an update of MS4W with the current version of Mapserver.

Service providers, Please contact me, and let me know how much that would 
be, and when it can be done.

Others who would like to contribute? 
Thanks
Steve
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] OSM mapfile

[Steve . Toutant]

I imported osm to postgis using osm2pgsql and created the mapfile using 
this procedure.
https://github.com/mapserver/mapserver/wiki/RenderingOsmDataWindows#wiki-map-gen

I have problem loading placesX layers, I get this error:
[Thu Feb 20 08:59:32 2014].216997 msAddLabel(): General error message. 
msAddLabel error: missing style definition for layer 'places5'
[Thu Feb 20 08:59:32 2014].217065 msDrawMap(): Image handling error. 
Failed to draw layer named 'places5'.

I know that the mapfile generated is for mapserver 6.4 and I'm using 
6.1-dev. 
But the LABEL tags used in the mapfile are valid for mapserv 6.1.
LAYER
...
 LABELITEM 'name'
 CLASSITEM 'type'
 CLASS
  EXPRESSION 'country'
  LABEL
   FONT scb
   TYPE TRUETYPE
   ENCODING utf-8
   SIZE 8
   COLOR 100 100 100
   OUTLINECOLOR -1 -1 -1
   OUTLINEWIDTH 2
   WRAP ' '
   MAXLENGTH 8
   ALIGN CENTER
   BUFFER 4
   PARTIALS FALSE
   POSITION cc
  END
 END
 
Any idea why it doesn't work?

Thanks for your help
steve

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE OSM mapfile (SOLVED)

[Steve . Toutant]

SOLVEd, just found this
https://github.com/mapserver/basemaps/issues/9




steve.tout...@inspq.qc.ca@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-02-20 09:11

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] OSM mapfile









I imported osm to postgis using osm2pgsql and created the mapfile using 
this procedure. 
https://github.com/mapserver/mapserver/wiki/RenderingOsmDataWindows#wiki-map-gen
 


I have problem loading placesX layers, I get this error: 
[Thu Feb 20 08:59:32 2014].216997 msAddLabel(): General error message. 
msAddLabel error: missing style definition for layer 'places5' 
[Thu Feb 20 08:59:32 2014].217065 msDrawMap(): Image handling error. 
Failed to draw layer named 'places5'. 

I know that the mapfile generated is for mapserver 6.4 and I'm using 
6.1-dev. 
But the LABEL tags used in the mapfile are valid for mapserv 6.1. 
LAYER 
... 
 LABELITEM 'name' 
 CLASSITEM 'type' 
 CLASS 
  EXPRESSION 'country' 
  LABEL 
   FONT scb 
   TYPE TRUETYPE 
   ENCODING utf-8 
   SIZE 8 
   COLOR 100 100 100 
   OUTLINECOLOR -1 -1 -1 
   OUTLINEWIDTH 2 
   WRAP ' ' 
   MAXLENGTH 8 
   ALIGN CENTER 
   BUFFER 4 
   PARTIALS FALSE 
   POSITION cc 
  END 
 END 
  
Any idea why it doesn't work?

Thanks for your help 
steve ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE [Polluriel potentiel] Re: Problem using WMS GetFeatureInfo in OpenLayers with different projections

[Steve . Toutant]

Here are some ideas...
I would add 900913 to wms_srs. If that doesn't solve the problem keep it 
there, it has to be there.
wms_srs   EPSG:4326 EPSG:900913

Add this in the MAP section of your mapfile to make sure it read the good 
epsg file. this is an example of a path to the epsg file
CONFIG PROJ_LIB /srv/www/services/epsg/

Perhaps you need to add the definition of 900913 to proj4 used by 
OpenLayers
create epsg900913.js, with this in
Proj4js.defs[EPSG:900913]= +title= Google Mercator EPSG:900913 
+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 
+k=1.0 +units=m +nadgrids=@null +no_defs;

Make sure to add this script after loading proj4.js 





Dejan Gambin dejan.gam...@coin.hr@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-02-13 08:06

A
mapserver-users@lists.osgeo.org
cc

Objet
[Polluriel potentiel]  Re: [mapserver-users] Problem using WMS 
GetFeatureInfo in OpenLayers with different projections








Since I didn't solve this yet, do you think it could be a bug and/or 
should I try with some newer MapServer version? I am currently using 6.0.3

Thx

Dejan Gambin

On 22. sij. 2014., at 10:35, Dejan Gambin wrote:

 Sorry for being late...
 
 So, I have tested it all with browser of course. Here are some working 
and non-working requests:
 
 Mapfile part:
 
  PROJECTION
init=epsg:4326 
  END 
  METADATA
wms_srs   EPSG:4326 
wms_title  aster_dem
gml_include_items value_0
gml_value_0_alias Nadmorska_visina
  END
  TILEINDEX ../aster/aster_index  #original raster in 4326
 
 
 Working GetMap request in 900913:
 
 
http://mydomain.com/cgi-bin/mywms/?SERVICE=WMSVERSION=1.1.1REQUEST=GetMapLAYERS=aster_dem_infoSTYLES=SRS=EPSG:900913FORMAT=image/pngWIDTH=400HEIGHT=300BBOX=1496080.301904,5576310.226428,1593919.698096,5649689.773572

 
 Non-working GetFeatureInfo request in 900913:
 
 
http://mydomain.com/cgi-bin/mywms/?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoLAYERS=aster_dem_infoSTYLES=SRS=EPSG:900913FORMAT=image/pngWIDTH=400HEIGHT=300BBOX=1496080.301904,5576310.226428,1593919.698096,5649689.773572QUERY_LAYERS=aster_dem_infoINFO_FORMAT=gmlX=200Y=100

 
 Working GetMap request in 4326:
 
 
http://mydomain.com/cgi-bin/mywms/?SERVICE=WMSVERSION=1.1.1REQUEST=GetMapLAYERS=aster_dem_infoSTYLES=SRS=EPSG:4326FORMAT=image/pngWIDTH=400HEIGHT=300BBOX=13.439518,44.712096,14.318424,45.178647

 
 Working GetFeatureInfo request in 4326:
 
 
http://mydomain.com/cgi-bin/mywms/?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoLAYERS=aster_dem_infoSTYLES=SRS=EPSG:4326FORMAT=image/pngWIDTH=400HEIGHT=300BBOX=13.439518,44.712096,14.318424,45.178647QUERY_LAYERS=aster_dem_infoINFO_FORMAT=gmlX=200Y=100

 
 
 
 
 
 
 On 17. sij. 2014., at 13:52, Rahkonen Jukka (Tike) wrote:
 
 Hi,
 
 Please show us the complete GetFeatureInfo requests for both cases. 
Server urls are not interesting but all the WMS parameters. Have you 
already tried to send them from browser? Testing with OpenLayers is waste 
of time because you can't control what really happens but with hand 
written requests you are the master.
 
 -Jukka Rahkonen-
 
 
 Lars Lingner wrote:
 
 On 17.01.2014 11:10, Dejan Gambin wrote:
 What is the mywms? MapServer binary, wrapper script, ...?
 wrapper script. Something like:
 
 #! /bin/sh MS_MAPFILE=/path_to_my_map_file export MS_MAPFILE
 /usr/lib/cgi-bin/mapserv6
 
 
 AFAIK nothing wrong here.
 
 
 Did you check the actual requests? Does the bbox parameter fit to
 the srs? Could you compare a working GetFeatureInfo request in
 900913 with a failing one in 4326?
 Yes, bbox parameter fits to srs in both cases. So, if I put bbox/srs
 params in 426 everything works, if I put them in 900913 then error
 happens
 
 Does other maps work with 900913?
 
 I would check which pro4 epsg file mapserver is using, check if there 
is
 a definition for 90013 and if it looks like
 
 +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 
+y_0=0
 +k=1.0 +units=m +nadgrids=@null +wktext  +no_defs
 
 On the other hand, if GetMap ist working fine, projection definition
 should be fine too. Just thinking out loud...
 
 
 
 Raise the debug level to 3 at map level and layer level. You can
 let MapServer write its own error logfile, so your apache log stays
 clean.
 
 Could you find anything in the MapServer log file?
 
 Here I would identify a working 4326 GFI request and compare the
 corresponding log with a 900913 request. There should be a difference.
 
 
 Best wishes,
 
 Lars
 
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 

[mapserver-users] RE [Polluriel potentiel] Re: runtime variable substitution in layer class expression

[Steve . Toutant]

http://dev.openlayers.org/docs/files/OpenLayers/Layer/WMS-js.html#OpenLayers.Layer.WMS.mergeNewParams

that will add year parameter in your url
yourlayer.mergeNewParams(
{
'year': year
});

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
Tél.: 418 646-6777 poste 30015
Téléc.: 418 644-4593
steve.tout...@inspq.qc.ca
http://www.inspq.qc.ca
http://www.monclimatmasante.qc.ca 
Pour me rejoindre par courrier
Service de l'infrastructure et du réseau
Direction des technologies de l'information
Ministère de la Sécurité Publique
2525 boul. Laurier, 2è étage
Tour Laurentides
Québec, G1V 2L2



gorank kirandzis...@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-02-11 17:57

A
mapserver-users@lists.osgeo.org
cc

Objet
[Polluriel potentiel]  Re: [mapserver-users] runtime variable substitution 
in layer class expression








I follow your suggestion and I put in the map file your proposal and in my
.aspx webform with open layers javascript I added dropdownlist with ID
YEAR and Values 2010 and 2011. The open layer in the browser doesn't 
show
the map. 

Should I put in the open layer javascript some additional code to 
recognise
the aspx control selected value?

Goran



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/runtime-variable-substitution-in-layer-class-expression-tp5101318p5103269.html

Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Problem using WMS GetFeatureInfo in OpenLayers with different projections

[Steve . Toutant]

In the metadata tag of your layer try set
wms_srs   EPSG:4326 EPSG:900913





Dejan Gambin dejan.gam...@coin.hr@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-01-16 05:03

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] Problem using WMS GetFeatureInfo in OpenLayers with 
different projections








Hi,

I am trying to send WMS GetFeatureInfo request using OL WMSGetFeatureInfo 
control. My source data is in 4326 and map is displayed in 900913. I have 
something like this in mapfile:

LAYER
  NAME mylayer
  TYPE RASTER
  STATUS ON
  PROJECTION
init=epsg:4326
  END 
  METADATA
wms_srs   EPSG:4326
wms_title  whatever
gml_include_items value_0
gml_value_0_alias Value 0
gml_geometries none
  END
  OPACITY 0
  TILEINDEX mylayer_index
  TILEITEM LOCATION
  TEMPLATE void
  DUMP true
END

In OL, I am using something like:

var layer = new OpenLayers.Layer.WMS(
'mylayer',
'http://my.domain.com/cgi-bin/mywms?',
{
format:'image/png',
transparent:true,
isBaseLayer:false,
layers:'mylayer'
});

control = new OpenLayers.Control.WMSGetFeatureInfo({
url:  http://my.domain.com/cgi-bin/mywms?;,
layers: [layer],
hover: false,
infoFormat: 'gml',
maxFeatures: 1
});

wms_srs in WEB part is EPSG:900913 EPSG:4326 so it can serve data in 
both projections

The problem is - when I click to get the info I get Internal server 
error and in apache log I get Segmentation fault followed by Premature 
end of script headers: mywms

For test, I reprojected my source rasters to 900913, changed PROJECTION 
and wms_srs in LAYER to 900913 and then everything works.

Does anyone know what can be the problem? I am using MapServer 6.0.1 on 
debian os.

Thanks for any help

regards, dejan





___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE Problem using WMS GetFeatureInfo in OpenLayers with different projections

[Steve . Toutant]

Anything in mapserver logs?
add debug 5 in the layer definition AND in your MAP definition
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
Tél.: 418 646-6777 poste 30015
Téléc.: 418 644-4593
steve.tout...@inspq.qc.ca
http://www.inspq.qc.ca
http://www.monclimatmasante.qc.ca 
Pour me rejoindre par courrier
Service de l'infrastructure et du réseau
Direction des technologies de l'information
Ministère de la Sécurité Publique
2525 boul. Laurier, 2è étage
Tour Laurentides
Québec, G1V 2L2



Dejan Gambin dejan.gam...@coin.hr 
2014-01-16 09:20

A
steve.tout...@inspq.qc.ca
cc
mapserver-users@lists.osgeo.org
Objet
Re: RE [mapserver-users] Problem using WMS GetFeatureInfo in OpenLayers 
with different projections








Tried...no luck :-(

Thx anyway

On 16. sij. 2014., at 14:36, steve.tout...@inspq.qc.ca wrote:


In the metadata tag of your layer try set 
wms_srs   EPSG:4326 EPSG:900913 




Dejan Gambin dejan.gam...@coin.hr@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-01-16 05:03 


A
mapserver-users@lists.osgeo.org 
cc

Objet
[mapserver-users] Problem using WMS GetFeatureInfo in OpenLayers with 
different projections










Hi,

I am trying to send WMS GetFeatureInfo request using OL WMSGetFeatureInfo 
control. My source data is in 4326 and map is displayed in 900913. I have 
something like this in mapfile:

LAYER
 NAME mylayer
 TYPE RASTER
 STATUS ON
 PROJECTION
   init=epsg:4326
 END 
 METADATA
   wms_srs   EPSG:4326
   wms_title  whatever
   gml_include_items value_0
   gml_value_0_alias Value 0
   gml_geometries none
 END
 OPACITY 0
 TILEINDEX mylayer_index
 TILEITEM LOCATION
 TEMPLATE void
 DUMP true
END

In OL, I am using something like:

   var layer = new OpenLayers.Layer.WMS(
   'mylayer',
   'http://my.domain.com/cgi-bin/mywms?',
   {
   format:'image/png',
   transparent:true,
   isBaseLayer:false,
   layers:'mylayer'
   });

   control = new OpenLayers.Control.WMSGetFeatureInfo({
   url:  http://my.domain.com/cgi-bin/mywms?;,
   layers: [layer],
   hover: false,
   infoFormat: 'gml',
   maxFeatures: 1
   });

wms_srs in WEB part is EPSG:900913 EPSG:4326 so it can serve data in 
both projections

The problem is - when I click to get the info I get Internal server 
error and in apache log I get Segmentation fault followed by Premature 
end of script headers: mywms

For test, I reprojected my source rasters to 900913, changed PROJECTION 
and wms_srs in LAYER to 900913 and then everything works.

Does anyone know what can be the problem? I am using MapServer 6.0.1 on 
debian os.

Thanks for any help

regards, dejan





___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users






___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] How to deal with (visible) CONNECTION information in .MAP file for WMS purposes

[Steve . Toutant]

To use this url http://my_url.org/my_script
I would create a file my_script in cgi-bin per example
See here
http://mapserver.org/fr/cgi/wrapper.html

I use a mix of above and this
http://mapserver.org/fr/ogc/mapscript.html

Steve






Stefan Schwarzer stefan.schwar...@unep.org@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-01-07 05:47

A
mapserver-users@lists.osgeo.org
cc

Objet
Re: [mapserver-users] How to deal with (visible) CONNECTION information in 
.MAP file for WMS purposes








Thanks for all the valuable help!

If I place the .MAP file somewhere where only the system can read it, the 
request looks a bit awkward: ?.map=/home/include/mapfiles/my_map.map?.

Would there a possibility to juste use ?map=my_map? and have the path 
then get added/understood by some internal configuration (mod_rewrite 
perhaps?)?

For the Wrapper, I don't really understand how that one would work. I have 
multiple .MAP files. And they need to by WMS-compliant. If I understand 
correctly, the URL would call the script: http://my_url.org/my_script, 
right? H...

It says:

#!/bin/sh
MAPSERV=/path/to/my/mapserv
MS_MAPFILE=/path/to/my/mapfile.map exec ${MAPSERV}

Thanks for any help!

Stefan



On 06.01.2014, at 11:03, Siki Zoltan wrote:

Hi Stefan,

you should hide your map file using a wrapper script on the server side.
See http://mapserver.org/cgi/wrapper.html
You can find some other methods at 
http://mapserver.org/ogc/wms_server.html
look for Changing the Online Resource URL

Regards,
Zoltan

On Mon, 6 Jan 2014, Stefan Schwarzer wrote:

Hi there,

I am wondering how to deal with the CONNECTION information in the .MAP 
which is used for WMS requests. As the .MAP file must be visible and is 
readable, the CONNECTION information for my database is readable too.

   # Layers definition -
   LAYER
   NAME wilderness_areas_po
METADATA
'wcs_label'   'Wilderness Areas'
'wcs_rangeset_name'   'test'
'wcs_rangeset_label'  'test label'
END
   TYPE RASTER
   STATUS OFF
   DATA wilderness_areas_po
   CONNECTIONTYPE postgis
   CONNECTION 'user=my_username password=my_password 
dbname=my_database'
   PROJECTION
   'init=epsg:4326'
   END
END


Either I would then need to create a very simple user for that case which 
really only can read the data, or I should hide the file in a directory 
which is not readable by a webuser. But I guess that Mapserver wouldn't 
like that.

What are your recommendations?

Thanks for any hints.

Stefan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Linear (left to right) Legend . . .

[Steve . Toutant]

Never tried such thingDoes HTML legend could help?
http://mapserver.org/fr/output/html_legend.html#html-legends-with-mapserver

Steve





Basques, Bob (CI-StPaul) bob.basq...@ci.stpaul.mn.us@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2014-01-03 15:20

A
mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] Linear (left to right) Legend . . .








All,
 
 
Looking for ideas on how to possibly make a linear (Horizontal)  legend 
something that displays left to right instead of top to bottom.  I want to 
add an embedded legend along the top and/or bottom edge of a map.
 
As a side note, I?ve also had some similar thoughts related to this for 
doing the same thing along the sides of maps, but rotating the legend 90 
degs for print out purposes.
 
Failing a method already in place, can I somehow grab selected Legend 
items and place them ad-hoc on the map (from the MapFILE), or can I add 
multiple one line legends?
 
Thanks
 
Bobb
 
 ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE WMS GetLegendGraphic resolution

[Steve . Toutant]

Perhaps this will help
http://mapserver.org/fr/mapfile/map.html

search for defresolution and resolution
steve




Sylvain Lesage sev...@rednegra.net@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2013-12-08 09:50

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] WMS GetLegendGraphic resolution








Hi,

I did not find any information about default resolution (in dpi) for WMS
GetLegendGraphic request. In GeoServer, the default is ~91dpi, and a
vendor parameter allows to ask for a higher resolution (see
http://docs.geoserver.org/stable/en/user/services/wms/get_legend_graphic/legendgraphic.html#controlling-legend-appearance-with-legend-options
).
Is there a similar option in MapServer ? And if not, what is the default
resolution ?

Thanks a lot,

Sylvain Lesage

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] php mapscript with draw() calling a php wrapper

[Steve . Toutant]

I have a web service that use a php wrapper as described here,
http://mapserver.org/fr/ogc/mapscript.html#php-example
 except that there is no mapscript, just php code that makes some query to 
a database in order to add some parametes to the wms request

This wrapper ends with readfile ($url);
It works fine for all wms request.

My problem is when calling this wrapper from another php mapscript page, I 
can't get the image back
More details...
I have a php mapscript who prepare a mapobject to print the map
In this php mapscript I use $oMap-draw(); to get the image

But the layer in $oMap doesn'T have a standard url like 
/cgi-bin/mapserv?map=.
The url is something like
http://.../php/ows.php?SERVICE=WMSVeRsIoN=1.1.1Request=GetMapLAYERS=..

ows.php build the correct url  /cgi-bin/mapserv?map=.and does the 
getmap request using readfile($url)

But it seems that $oMap-draw() can't deal with what readfile returns, I 
got this error
Error in msDrawMap(): Failed to draw WMS layer named 'RSS'. This most 
likely happened because the remote WMS server returned an invalid image, 
and XML exception or another unexpected result in response to the GetMap 
request. Also check and make sure that the layer's connection URL is 
valid. 

I'm sorry It's difficult to explain, I hope I explained well enough...
Thanks
Steve___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE Can variables be used in PROCESSING?

[Steve . Toutant]

I needed that for CHARTS as well
https://github.com/mapserver/mapserver/issues/4569

See the last comment: substitutions are not yet enabled on processing 
options, but should be easy to add/implement

Dont' know if it is plan to do it
Steve





Rahkonen Jukka jukka.rahko...@mmmtike.fi@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2013-09-25 11:57

A
Mapserver-Users (mapserver-users@lists.osgeo.org) 
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] Can variables be used in PROCESSING?








Hi,

Is this list correct http://mapserver.org/cgi/runsub.html#runsub? It does 
not mention PROCESSING.

I have been thinking that it would be cool to have a WMS client which 
could adjust on-the-fly from the client side
-  PROCESSING BANDS=1,2,3 for making diffferent RGB versions of 
multi-channel images
- LUT, LUT_1, LUT_2 and LUT_3 for adjusting colours on-the-fly
- SCALE, SCALE_1, SCALE_2 and SCALE_3 for the same and especially for 
setting 16-bit DEMs or measument data into visible range for on-screen 
work.

Some clever individual could perhaps make an OpenLayers demo with cool 
controls like sliders and dragable LUT-curves.

By fiddling with RESAMPLE and OVERSAMPLE_RATIO it would also be possible 
to get images fast into screen but also with top quality if that is needed 
for printing.

-Jukka Rahkonen-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WMS server error. Invalid layer(s) given in the LAYERS parameter

[Steve . Toutant]

If it is a typo it would be in your layers definition
Is layer 'TestMap' defined in your mapfile?

If so watch for a typo at the layer above, maybe an extra END
Anything in your Web server log, and mapserver log?





Paul S paul.she...@bentley.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2013-09-23 10:21

A
mapserver-users@lists.osgeo.org
cc

Objet
Re: [mapserver-users] WMS server error. Invalid layer(s) given in the 
LAYERS parameter








Thanks Steve,

Here is the URL I am using ...

http://localhost/cgi-bin/mapserv.exe?
map=C:\ms4w\Apache\TEST_Routes.map
LAYER=TestMap
SERVICE=WMS
VERSION=1.1.1
REQUEST=GetMap

I wish/hope it is something as simple as a misspelling!  But I do not see
it.

Paul



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/WMS-server-error-Invalid-layer-s-given-in-the-LAYERS-parameter-tp5079259p5079278.html

Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] wfs filter encoding

[Steve . Toutant]

Hi,
I'm trying for the first time to query a wfs with filter encoding. It 
works but My problem is I don't know how to use the filter if I have 
several polygons.
There are examples at this page querying cities and continents
http://mapserver.org/ogc/filter_encoding.html

This example return the cities inside a polygon
http://demo.mapserver.org/cgi-bin/wfs?VERSION=1.0.0SERVICE=WFSREQUEST=GetFeatureTYPENAME=citiesFilter=FilterIntersectsPropertyNameGeometry/PropertyNamegml:Polygongml:outerBoundaryIsgml:LinearRinggml:coordinates135.5329,34.6624
 
135.4921,34.8153 135.3673,34.7815 135.3800,34.6216 135.5361,34.6210 
135.5329,34.6624/gml:coordinates/gml:LinearRing/gml:outerBoundaryIs/gml:Polygon/Intersects/Filter

Using the same wfs I would like to get the cities in Canada
This query returns all the polygons for Canada (I set maxfeatures=30 for 
the examples).
http://demo.mapserver.org/cgi-bin/wfs?VERSION=1.0.0SERVICE=WFSREQUEST=GetFeatureTYPENAME=continentsmaxfeatures=30Filter=FilterPropertyIsEqualToPropertyNameNA2DESC/PropertyNameLiteralCanada/Literal/PropertyIsEqualTo/Filter

How can I use the output of this query, so I can filter the cities inside 
all these 30 polygons?

thanks
steve___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] mapserv ERROR glibc detected

[Steve . Toutant]

We sometimes get this error in the apache error log
*** glibc detected *** /srv/www/cgi-bin/mapserv: double free or corruption 
(!prev): 0x01c99090 ***
We don't know how to reproduce this error.
Anyone had this error before? Any idea on what we could try to reproduce 
it?
Thanks
steve___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE WMS layer filtering

[Steve . Toutant]

Does runtime substitution can help?
You could post latest_observation=1 when calling the wms and 0 and 1 when 
using the wfs

the filter would be latest_observation in (%param%)




Kralidis,Tom [Ontario] tom.krali...@ec.gc.ca@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2013-06-12 08:23

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] WMS layer filtering








Hi: we have a MapServer OWS instance which we use to disseminate
observations via WMS and WFS/SOS.

One of our layers has 1 million records (PostGIS backend).  The layer
has CLASS level EXPRESSION objects for WMS visualization/classification.
We initially implemented a LAYER level FILTER, however we have use cases
to serve the same layer (with the same identifier) via WFS, in which
case we'd like all the data to be available.

Our problem happens when visualizing via WMS.  We have a Boolean column
in our PostGIS table ('latest_observation') which allows us to filter
easily to visualize latest observations, which is our desired WMS
default.

Because we have defined CLASS level filters, the WMS GetMap request is
first querying and fetching all records and _then_ applying CLASS level
filters (which all include 'latest_observation=1'.  So this ends up
hurting us performance wise.

We'd like to have this filter at the query level so that less members
are passed back from the SQL query. 

When we do a LAYER.FILTER with latest_observation=1, the result is
instant (beautiful!).  But if we put a LAYER.FILTER, this constrains the
data access from the WFS perspective against the same LAYER def.

Is there any way to apply a LAYER.FILTER type approach to work _just_ in
WMS mode? We'd like all the data in WFS mode.

I know we can duplicate the LAYER object as a workaround, but from a
data management perspective we'd rather now.

I hope I have explained this clearly enough.  Any suggestions?

Thanks

..Tom
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] RE runtime-substitution on GetFeatureInfo request

[Steve . Toutant]

What kind of trouble exactly?
Do you have a Validation block in your layer definition?





Andrea Peri aperi2...@gmail.com@lists.osgeo.org 
Envoyé par : mapserver-users-boun...@lists.osgeo.org
2013-01-21 19:26

A
mapserver-users@lists.osgeo.org
cc

Objet
[mapserver-users] runtime-substitution on GetFeatureInfo request








Hi,

I have trouble trying to apply a runtime-subistitution on a
GetFeatureInfo request for the FILTER section.
Is this possible ?



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users