Re: [mapserver-users] [EXTERNAL] Re: MapCache Time Dimensions Problem

2015-06-10 Thread Michael Smith
Stephan,

Yes, I've even used the value I have as the Default value which does fetch
things properly. 

I suppose it could be something in the specific branch I'm using. Its the
animation branch from RFC-111
(http://mapserver.org/development/rfc/ms-rfc-111.html) and
(https://github.com/jlarouche/mapcache/tree/animated-gif).

But I tried this also with master to test it non-animated and got the same
error.

Mike

-- 
Michael Smith

Remote Sensing/GIS Center
US Army Corps of Engineers



On 6/10/15,  8:28 AM, Stephan Meißl step...@meissl.name wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Mike,

strange, did you try a time interval or simply a bigger time e.g. a
whole day like TIME=2014-03-06? Maybe you can narrow it down this way.

cu
Stephan


On 06/10/2015 01:22 PM, Michael Smith wrote:
 Stephan,
 
 Yes I did run directly on the sqlite file and its got an absolute
 path. I get all the responses back I think I should get
 
 eg:
 
 Select 
 
strftime('%Y-%m-%dT%H:%M:%SZ',start_time)||'/'||strftime('%Y-%m-%dT%H:%M:
%S

 
Z',end_time) from time where source_id='earthquakes';
 
 .. 2014-03-03T23:41:21Z/2014-03-03T23:41:21Z
 2014-03-07T23:47:22Z/2014-03-07T23:47:22Z
 2014-03-07T00:53:09Z/2014-03-07T00:53:09Z
 2014-03-06T02:51:31Z/2014-03-06T02:51:31Z ...
 
 
 and it all seems to work with default values. Its only when I try
 to pass a TIME value on the URL that I get an error.
 
 GET 
 
/gridvm1mc/mapcache/?LAYERS=earthquakesSERVICE=WMSVERSION=1.1.1REQUEST
=G

 
etMapSTYLES=SRS=EPSG%3A3857BBOX=-28119042.469324,-9960050.5336716,28119
0
 42.469324,9960050.5336716WIDTH=1437HEIGHT=509 HTTP/1.1 200
 34113 GET 
 
/gridvm1mc/mapcache/?LAYERS=earthquakesSERVICE=WMSVERSION=1.1.1REQUEST
=G

 
etMapSTYLES=SRS=EPSG%3A3857BBOX=-28119042.469324,-9960050.5336716,28119
0
 
42.469324,9960050.5336716WIDTH=1437HEIGHT=509TIME=2014-03-06T02:51:31Z

 
HTTP/1.1 404 244
 
 
 And the error is no matching entry for given TIME dimension TIME
 in tileset earthquakes
 
  Michael Smith
 
 US Army Corps Remote Sensing GIS/Center
 michael.sm...@usace.army.mil
 
 
 
 
 
 -Original Message- From: Stephan Meißl
 step...@meissl.name Date: Tuesday, June 9, 2015 at 4:37 PM To:
 mapserver-users@lists.osgeo.org
 mapserver-users@lists.osgeo.org Subject: [EXTERNAL] Re:
 [mapserver-users] MapCache Time Dimensions Problem Resent-From:
 Michael Smith michael.sm...@usace.army.mil
 
 Hi Mike,
 
 did you try running the query directly in sqlite substituting
 :tileset, :start_timestamp, and :end_timestamp with actual values?
 What schema does your sqlite database have? Is the path to the
 dbfile absolute and readable?
 
 I could send you a working example if you want. Let me know.
 
 cu Stephan
 
 
 On 06/07/2015 01:13 AM, Michael Smith wrote:
 I've created a timedimension tileset in MapCache and created
 the backend sqlite db that has the available times. The
 mapserver backend handles the WMS TIME requests without a
 problem.  And when I query mapcache without a TIME=, I get
 my the default output.
 
 However, if I specify a TIME= parameter to MapCache (as a
 WMS or WMTS request), I get
 
 no matching entry for given TIME dimension TIME in tileset
 earthquakes
 
 I don't know what I need to change to get MapCache to
 recognize the TIME parameter. From the docs on RFC-96
 (http://mapserver.org/development/rfc/ms-rfc-96.html) I don't
 see what else to specify to set MapCache to understand TIME
 requests.
 
 I can see MapCache making the backend requests to generate
 images from the time values in the sqlite DB but only with
 the default specified in the timedimension. It never
 understands new ranges passed with TIME=.
 
 My tileset looks like
 
 tileset name=earthquakes sourceearthquakes/source
 cachesqlite/cache gridGoogleMapsCompatible/grid
 formatPNG/format metatile5 5/metatile
 metabuffer10/metabuffer expires3600/expires
 timedimension type=sqlite default=2014-03-25T12Z 
 dbfile/u02/mapcache/dbtime2.db/dbfile queryselect
 
 
strftime('%Y-%m-%dT%H:%M:%SZ',start)||'/'||strftime('%Y-%m-%dT%H:%M:%S
Z',

 
end)
 from time where source_id=:tileset and
 start_timegt;=datetime(:start_timestamp,'unixepoch') and
 end_timelt;=datetime(:end_timestamp,'unixepoch') order by
 end_time /query /timedimension /tileset

-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iQIcBAEBAgAGBQJVeC17AAoJEKNQXeNWi+qtuwQQAJUF2EFcQw1m7f6OjY4Nkx+e
wy7HrtNdL0NjvFKgzXMRA88o19E4snr+KhelYLicDJY2vp26Dk5ctuuZRfEig+HK
ZUyklvSyfuG7VZPs3/7VYMcHgF+DfkbqZohhDsLXN1ZobEAl1PlxdrZulexTbmG+
O2p81d9p7qBFLgYDPT6WxW43lkLpuPIR1JYc2iT9CeBVvJ33QRF05taVVBkj+5ze
mwJQdRBAT3GcK/cJSgVN1pxvUBkq4C40p84EulAERX7XTkQWnClSFSJBuyON+B3q
KFnCWFxDip7zly2uwYyvJMJdkwLvJbp5UhJ/uYlDd82EODd+D4m1l//wAKsu5ZDZ
f+olnKtkiMHUc2s7OwjwYYTIvYSvA9bwIHDgmAMVCyQLZEk/Wr5Jbgi8sLxid45s
/A9j64nPSj/Ar9Kw9AbX+vyupT2iTiQyigKiA+OBhejX52d+rj6y4mEIS757NLTg
hnBrbry1LoWQjr7/XAmdGahusCF/wp6mmb0YoWFoQI+cuFJ39iIPvWXScIvUkLG9
Qj6iw4wj8WwZ2Fe2V4QbqPs5/kPY+iriZ3hTISaqdlNCP3ZWR4OSd/DcIIf68OEE

Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

2015-06-10 Thread Andrea Peri
Hi Michael,
thx for your hint.

I do some test.
The right final sintax is this:

PROCESSING NATIVE_FILTER=(ANNO = 2006) and (CODICE_UNIVOCO like '%idtpn%' )

Thx2all again.

Andrea.




2015-06-10 12:27 GMT+02:00 Michael Smith michael.smith.e...@gmail.com:
 Andrea,

 You can always use your existing filters with

 PROCESSING NATIVE_FILTER=WHERE (ANNO = 2006) and (CODICE_UNIVOCO like
 '%idtpn%' )

 Or you can use a MapServer expression which are documented here:
 http://mapserver.org/mapfile/expressions.html#mapserver-expressions

 Mike

 
 Michael Smith

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




 -Original Message-
 From: Andrea Peri aperi2...@gmail.com
 Date: Wednesday, June 10, 2015 at 5:41 AM
 To: Lime, Steve D (MNIT) steve.l...@state.mn.us
 Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
 Subject: Re: [mapserver-users] Incompatibility at Filter - level between
 mapserver 6.x and the last mapserver-dev ?

Hi steve,
this new sintax will allow the AND operator ?

I have a filter like this:

FILTER WHERE (ANNO = 2006) and (CODICE_UNIVOCO like '%idtpn%' )

and don't know how to transform it with the new sintax.

Is this kind of filter supported ?

Thx,

A.


2015-06-09 19:05 GMT+02:00 Lime, Steve D (MNIT) steve.l...@state.mn.us:
 As of MapServer 7.0 FILTERS must be given using MapServer syntax - this
is a regression noted in the Migration Guide, see
http://mapserver.org/MIGRATION_GUIDE.html#migration. There's an OGR
example right towards the top of that document. Basically:

   FILTER WHERE ([CODICE] = 107)
   FILTERITEM CODICE

 Becomes:

   PROCESSING 'NATIVE_FILTER=CODICE=107'

 Steve

 -Original Message-
 From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Andrea Peri
 Sent: Tuesday, June 09, 2015 3:45 AM
 To: mapserver-users@lists.osgeo.org
 Subject: [mapserver-users] Incompatibility at Filter - level between
mapserver 6.x and the last mapserver-dev ?

 Hi,
 I have just update my mapserver to the last mapserver-dev .

 After this update, I see an error on the filtering.

 In my mapfile the data configuration was originally this:

 CONNECTION /path-to-spatialite-db/zz_db_tematici.sqlite
 CONNECTIONTYPE OGR
 DATA IFT2009
 EXTENT 1554650.74 4678225.52 1771822.76 4924891.9
 FILTER WHERE ([CODICE] = 107)
 FILTERITEM CODICE
   


 The log report this error:

 [Tue Jun  9 10:39:46 2015].153296 msDrawMap(): rendering using
 outputformat named AGGA (AGG/PNG).
 [Tue Jun  9 10:39:46 2015].154698 msDrawMap(): WMS/WFS set-up and
query, 0.001s
 [Tue Jun  9 10:39:46 2015].262330 LayerDefaultTranslateFilter():
 General error message. This data driver does not implement filter
 translation support
 [Tue Jun  9 10:39:46 2015].282402 msDrawMap(): Layer 239
 (rt_ucs.idift.rt.107), 0.128s
 [Tue Jun  9 10:39:46 2015].282550 msDrawMap(): Drawing Label Cache,
0.000s

 I'm using spatialite as db.

 After this error, I read this RFC:
 http://www.mapserver.org/ru/development/rfc/ms-rfc-91.html

 And try the new settings,

 FILTER (([FILTERITEM[ = string) AND (CODICE = 107))

 but it seem don't work.

 I don't understand if this is an issue of the new settings with
 spatialite or I'm wrong something.

 Thx,


 --
 -
 Andrea Peri
 . . . . . . . . .
 qwerty àèìòù
 -
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



--
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users





-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] Re: MapCache Time Dimensions Problem

2015-06-10 Thread Stephan Meißl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Mike,

strange, did you try a time interval or simply a bigger time e.g. a
whole day like TIME=2014-03-06? Maybe you can narrow it down this way.

cu
Stephan


On 06/10/2015 01:22 PM, Michael Smith wrote:
 Stephan,
 
 Yes I did run directly on the sqlite file and its got an absolute
 path. I get all the responses back I think I should get
 
 eg:
 
 Select 
 strftime('%Y-%m-%dT%H:%M:%SZ',start_time)||'/'||strftime('%Y-%m-%dT%H:%M:%S

 
Z',end_time) from time where source_id='earthquakes';
 
 .. 2014-03-03T23:41:21Z/2014-03-03T23:41:21Z 
 2014-03-07T23:47:22Z/2014-03-07T23:47:22Z 
 2014-03-07T00:53:09Z/2014-03-07T00:53:09Z 
 2014-03-06T02:51:31Z/2014-03-06T02:51:31Z ...
 
 
 and it all seems to work with default values. Its only when I try
 to pass a TIME value on the URL that I get an error.
 
 GET 
 /gridvm1mc/mapcache/?LAYERS=earthquakesSERVICE=WMSVERSION=1.1.1REQUEST=G

 
etMapSTYLES=SRS=EPSG%3A3857BBOX=-28119042.469324,-9960050.5336716,281190
 42.469324,9960050.5336716WIDTH=1437HEIGHT=509 HTTP/1.1 200
 34113 GET 
 /gridvm1mc/mapcache/?LAYERS=earthquakesSERVICE=WMSVERSION=1.1.1REQUEST=G

 
etMapSTYLES=SRS=EPSG%3A3857BBOX=-28119042.469324,-9960050.5336716,281190
 42.469324,9960050.5336716WIDTH=1437HEIGHT=509TIME=2014-03-06T02:51:31Z

 
HTTP/1.1 404 244
 
 
 And the error is no matching entry for given TIME dimension TIME
 in tileset earthquakes
 
  Michael Smith
 
 US Army Corps Remote Sensing GIS/Center 
 michael.sm...@usace.army.mil
 
 
 
 
 
 -Original Message- From: Stephan Meißl
 step...@meissl.name Date: Tuesday, June 9, 2015 at 4:37 PM To:
 mapserver-users@lists.osgeo.org
 mapserver-users@lists.osgeo.org Subject: [EXTERNAL] Re:
 [mapserver-users] MapCache Time Dimensions Problem Resent-From:
 Michael Smith michael.sm...@usace.army.mil
 
 Hi Mike,
 
 did you try running the query directly in sqlite substituting
 :tileset, :start_timestamp, and :end_timestamp with actual values?
 What schema does your sqlite database have? Is the path to the
 dbfile absolute and readable?
 
 I could send you a working example if you want. Let me know.
 
 cu Stephan
 
 
 On 06/07/2015 01:13 AM, Michael Smith wrote:
 I've created a timedimension tileset in MapCache and created
 the backend sqlite db that has the available times. The
 mapserver backend handles the WMS TIME requests without a
 problem.  And when I query mapcache without a TIME=, I get
 my the default output.
 
 However, if I specify a TIME= parameter to MapCache (as a
 WMS or WMTS request), I get
 
 no matching entry for given TIME dimension TIME in tileset 
 earthquakes
 
 I don't know what I need to change to get MapCache to
 recognize the TIME parameter. From the docs on RFC-96 
 (http://mapserver.org/development/rfc/ms-rfc-96.html) I don't
 see what else to specify to set MapCache to understand TIME
 requests.
 
 I can see MapCache making the backend requests to generate
 images from the time values in the sqlite DB but only with
 the default specified in the timedimension. It never
 understands new ranges passed with TIME=.
 
 My tileset looks like
 
 tileset name=earthquakes sourceearthquakes/source 
 cachesqlite/cache gridGoogleMapsCompatible/grid 
 formatPNG/format metatile5 5/metatile 
 metabuffer10/metabuffer expires3600/expires 
 timedimension type=sqlite default=2014-03-25T12Z  
 dbfile/u02/mapcache/dbtime2.db/dbfile queryselect
 
 strftime('%Y-%m-%dT%H:%M:%SZ',start)||'/'||strftime('%Y-%m-%dT%H:%M:%SZ',

 
end)
 from time where source_id=:tileset and 
 start_timegt;=datetime(:start_timestamp,'unixepoch') and
 end_timelt;=datetime(:end_timestamp,'unixepoch') order by
 end_time /query /timedimension /tileset

-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iQIcBAEBAgAGBQJVeC17AAoJEKNQXeNWi+qtuwQQAJUF2EFcQw1m7f6OjY4Nkx+e
wy7HrtNdL0NjvFKgzXMRA88o19E4snr+KhelYLicDJY2vp26Dk5ctuuZRfEig+HK
ZUyklvSyfuG7VZPs3/7VYMcHgF+DfkbqZohhDsLXN1ZobEAl1PlxdrZulexTbmG+
O2p81d9p7qBFLgYDPT6WxW43lkLpuPIR1JYc2iT9CeBVvJ33QRF05taVVBkj+5ze
mwJQdRBAT3GcK/cJSgVN1pxvUBkq4C40p84EulAERX7XTkQWnClSFSJBuyON+B3q
KFnCWFxDip7zly2uwYyvJMJdkwLvJbp5UhJ/uYlDd82EODd+D4m1l//wAKsu5ZDZ
f+olnKtkiMHUc2s7OwjwYYTIvYSvA9bwIHDgmAMVCyQLZEk/Wr5Jbgi8sLxid45s
/A9j64nPSj/Ar9Kw9AbX+vyupT2iTiQyigKiA+OBhejX52d+rj6y4mEIS757NLTg
hnBrbry1LoWQjr7/XAmdGahusCF/wp6mmb0YoWFoQI+cuFJ39iIPvWXScIvUkLG9
Qj6iw4wj8WwZ2Fe2V4QbqPs5/kPY+iriZ3hTISaqdlNCP3ZWR4OSd/DcIIf68OEE
WpTq4NxDR3NKFn5RKiekPixpppUcDtU7GnwYNPwNDVkhiVLEf6tmD32bBeXSrTG6
8QZlOVjwUHAMAmxToXXP
=uGbf
-END PGP SIGNATURE-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

2015-06-10 Thread Andrea Peri
Hi steve,
this new sintax will allow the AND operator ?

I have a filter like this:

FILTER WHERE (ANNO = 2006) and (CODICE_UNIVOCO like '%idtpn%' )

and don't know how to transform it with the new sintax.

Is this kind of filter supported ?

Thx,

A.


2015-06-09 19:05 GMT+02:00 Lime, Steve D (MNIT) steve.l...@state.mn.us:
 As of MapServer 7.0 FILTERS must be given using MapServer syntax - this is a 
 regression noted in the Migration Guide, see 
 http://mapserver.org/MIGRATION_GUIDE.html#migration. There's an OGR example 
 right towards the top of that document. Basically:

   FILTER WHERE ([CODICE] = 107)
   FILTERITEM CODICE

 Becomes:

   PROCESSING 'NATIVE_FILTER=CODICE=107'

 Steve

 -Original Message-
 From: mapserver-users-boun...@lists.osgeo.org 
 [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Andrea Peri
 Sent: Tuesday, June 09, 2015 3:45 AM
 To: mapserver-users@lists.osgeo.org
 Subject: [mapserver-users] Incompatibility at Filter - level between 
 mapserver 6.x and the last mapserver-dev ?

 Hi,
 I have just update my mapserver to the last mapserver-dev .

 After this update, I see an error on the filtering.

 In my mapfile the data configuration was originally this:

 CONNECTION /path-to-spatialite-db/zz_db_tematici.sqlite
 CONNECTIONTYPE OGR
 DATA IFT2009
 EXTENT 1554650.74 4678225.52 1771822.76 4924891.9
 FILTER WHERE ([CODICE] = 107)
 FILTERITEM CODICE
   


 The log report this error:

 [Tue Jun  9 10:39:46 2015].153296 msDrawMap(): rendering using
 outputformat named AGGA (AGG/PNG).
 [Tue Jun  9 10:39:46 2015].154698 msDrawMap(): WMS/WFS set-up and query, 
 0.001s
 [Tue Jun  9 10:39:46 2015].262330 LayerDefaultTranslateFilter():
 General error message. This data driver does not implement filter
 translation support
 [Tue Jun  9 10:39:46 2015].282402 msDrawMap(): Layer 239
 (rt_ucs.idift.rt.107), 0.128s
 [Tue Jun  9 10:39:46 2015].282550 msDrawMap(): Drawing Label Cache, 0.000s

 I'm using spatialite as db.

 After this error, I read this RFC:
 http://www.mapserver.org/ru/development/rfc/ms-rfc-91.html

 And try the new settings,

 FILTER (([FILTERITEM[ = string) AND (CODICE = 107))

 but it seem don't work.

 I don't understand if this is an issue of the new settings with
 spatialite or I'm wrong something.

 Thx,


 --
 -
 Andrea Peri
 . . . . . . . . .
 qwerty àèìòù
 -
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] on the fly projection

2015-06-10 Thread Ahmet Temiz
thank you all

I was really a solution with (* powerful *) mapserver.

On Mon, Jun 8, 2015 at 3:10 PM, Jeff McKenna jmcke...@gatewaygeomatics.com
wrote:

 On 2015-06-08 6:08 AM, Ahmet Temiz wrote:

 hello

 I am wondering if a map file  enables us to on the fly projection.
 I have input raster data in epsg :4326 storing in postgis  but output
 raster
 map should be in epsg:3857 as tif.



 A nice explanation of projection use in MapServer can be found at:
 http://www.mapserver.org/mapfile/projection.html  Pay attention to the
 Important Notes section of that page, which contains very useful tips.

 -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




-- 
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

Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

2015-06-10 Thread Eichner, Andreas - SID
It seems the filter expression must not be given as string. So you should use

FILTER ([CODICE] = 107)

Otherwise MapServer will read the filter as string value to be used in 
combination with FILTERITEM.

 -Ursprüngliche Nachricht-
 Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-
 boun...@lists.osgeo.org] Im Auftrag von Andrea Peri
 Gesendet: Dienstag, 9. Juni 2015 23:40
 An: Schylberg Lars; Havard Tveite
 Cc: mapserver-users@lists.osgeo.org
 Betreff: Re: [mapserver-users] Incompatibility at Filter - level between
 mapserver 6.x and the last mapserver-dev ?
 
 Unfortunately no.
 Its only a typo in e-mail.
 
 The bracket in the mapfile was correct close.
 
 Thx
 
 
 2015-06-09 12:15 GMT+02:00 Schylberg Lars lars.schylb...@saabgroup.com:
  It seems like You have a typing error.
 
FILTER ([CODICE[ = 107)
 
  Should be:
 
FILTER ([CODICE] = 107)
 
  /Lars
 
  -Original Message-
  From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-
 boun...@lists.osgeo.org] On Behalf Of Andrea Peri
  Sent: den 9 juni 2015 11:34
  To: Eichner, Andreas - SID
  Cc: mapserver-users@lists.osgeo.org
  Subject: Re: [mapserver-users] Incompatibility at Filter - level between
 mapserver 6.x and the last mapserver-dev ?
 
  Thx for response.
 
  I try this,
  FILTER (CODICE = 107)
  and also this
  FILTER ([CODICE[ = 107)
  and removing the filteritem,
 
  but still go in error:
  :(
 
  The log report this:
 
  [Tue Jun  9 11:29:53 2015].880265 LayerDefaultTranslateFilter():
  General error message. This data driver does not implement filter
 translation support [Tue Jun  9 11:29:53 2015].955070 msEvalExpression():
 General error message. Cannot evaluate expression, no item index defined.
 
  2015-06-09 11:06 GMT+02:00 Eichner, Andreas - SID
  andreas.eich...@sid.sachsen.de:
  I think you should use
 
  FILTER ([CODICE] = 107)
 
  i.e. without using FILTERITEM and the leading WHERE
 
  -Ursprüngliche Nachricht-
  Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-
  boun...@lists.osgeo.org] Im Auftrag von Andrea Peri
  Gesendet: Dienstag, 9. Juni 2015 10:45
  An: mapserver-users@lists.osgeo.org
  Betreff: [mapserver-users] Incompatibility at Filter - level between
  mapserver 6.x and the last mapserver-dev ?
 
  Hi,
  I have just update my mapserver to the last mapserver-dev .
 
  After this update, I see an error on the filtering.
 
  In my mapfile the data configuration was originally this:
 
  CONNECTION /path-to-spatialite-db/zz_db_tematici.sqlite
  CONNECTIONTYPE OGR
  DATA IFT2009
  EXTENT 1554650.74 4678225.52 1771822.76 4924891.9
  FILTER WHERE ([CODICE] = 107)
  FILTERITEM CODICE

 
 
  The log report this error:
 
  [Tue Jun  9 10:39:46 2015].153296 msDrawMap(): rendering using
  outputformat named AGGA (AGG/PNG).
  [Tue Jun  9 10:39:46 2015].154698 msDrawMap(): WMS/WFS set-up and
  query, 0.001s [Tue Jun  9 10:39:46 2015].262330
  LayerDefaultTranslateFilter():
  General error message. This data driver does not implement filter
  translation support [Tue Jun  9 10:39:46 2015].282402 msDrawMap():
  Layer 239 (rt_ucs.idift.rt.107), 0.128s [Tue Jun  9 10:39:46
  2015].282550 msDrawMap(): Drawing Label Cache, 0.000s
 
  I'm using spatialite as db.
 
  After this error, I read this RFC:
  http://www.mapserver.org/ru/development/rfc/ms-rfc-91.html
 
  And try the new settings,
 
  FILTER (([FILTERITEM[ = string) AND (CODICE = 107))
 
  but it seem don't work.
 
  I don't understand if this is an issue of the new settings with
  spatialite or I'm wrong something.
 
  Thx,
 
 
  --
  -
  Andrea Peri
  . . . . . . . . .
  qwerty àèìòù
  -
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 
 
  --
  -
  Andrea Peri
  . . . . . . . . .
  qwerty àèìòù
  -
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 
 
 --
 -
 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

[mapserver-users] no result with getFeatureInfo text/plain

2015-06-10 Thread Jörg Thomsen
Hello,

in my WMS getFeatureInfo works fine with info_format html [1] and gml,
but I don't get a result with text/plain [2]. And I found similar a
example on mapserver.org... [3]  [4].

Why does getFeaturInfo for text/plain not work?

[1]
http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/htmlEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100;

[2]
http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/plainEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100;

[3]
http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/plainX=229Y=280

[4]
http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/htmlX=229Y=280

Jörg

and here's my mapfile:
   WEB
 IMAGEPATH '/tmp/'
 IMAGEURL '/tmp/'
 
 METADATA
   'ows_title'   'Flächennutzungsplan der Stadt Luckau und seinen 
 Ortsteilen'
   'ows_onlineresource'  
 'http://geoportal.luckau.de/ows/flaechennutzungsplaene'
   'ows_srs' 'EPSG:4326  EPSG:25832 EPSG:25833 EPSG:325833 
 EPSG:4528 EPSG:4839'
   'ows_abstract''WMS-Dienst zur Dartellung von 
 Flächennutzungspläne im Stadtgebiet Luckau mit seinen Ortsteilen'
   'ows_accessconstraints' 'none'
   'ows_fees' 'none'
   'ows_keywordlist' 'Luckau, Flächennutzungspläne, WMS'
   'ows_include_items' 'all'
   'ows_encoding' 'ISO-8859-1'
   'WMS_FEATURE_INFO_MIME_TYPE' 'text/html'
   'gml_include_items' 'all'
   include  './includes/contact_information.inc.map'
 END
   END
 
 ### Layer 
 
   LAYER
 NAME 'FNP01_Grenze'
   CLASS
NAME 'plan_grenze' 
STYLE
  SYMBOL 0 
width 3
  OUTLINECOLOR 0 0 255
  #COLOR 220 54 199
END
 END
 DATA 'raster/fnp_luckau/grenzen_umring/plan_01_grenze.shp'
 METADATA
   'ows_title' 'FNP 01 Grenze'
   'ows_abstract' 'Umring Flächennuntzungsplan Luckau, Teil 1, Kümmritz, 
 Uckro, Paserin'
 'ows_srs' 'EPSG:4326 EPSG:25833 EPSG:325833 EPSG:4528 
 EPSG:4839'
 gml_include_items all
   gml_featureid ID
   ows_enable_request *
 END
 STATUS ON
 PROJECTION
   init=epsg:325833
 END
   TYPE POLYGON
 DUMP true
 HEADER './templates/fnp_legende_header.html'
 TEMPLATE './templates/fnp_legende.html'
 FOOTER './templates/footer.html'
   END


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

[mapserver-users] db connection through Mapserver fails

2015-06-10 Thread Ahmet Temiz
hello

My postgis raster db connection through Mapserver fails.

here is the message coming from WildFly:

db connection data PG: dbname=tr22 host=localhost user=orkun
password=22 port=5432 schema=public table=o_4_trdem2where=
ST_Intersects(rast,  ST_MakeEnvelope( 29.90 , 40.42 , 31.49 , 40.99, 4326
 )) mode=2

ERROR 1: PQconnectdb failed: FATAL:  remaining connection slots are
reserved for non-replication superuser connections

Can you tell me why ?

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

Re: [mapserver-users] no result with getFeatureInfo text/plain

2015-06-10 Thread Lars Schylberg

I think You should have a

wms_include_items all

in the LAYER METADATA section.

Same comment as I had last week.

/Lars

Jörg Thomsen skrev den 2015-06-10 16:00:

Hello,

in my WMS getFeatureInfo works fine with info_format html [1] and gml,
but I don't get a result with text/plain [2]. And I found similar a
example on mapserver.org... [3]  [4].

Why does getFeaturInfo for text/plain not work?

[1]
http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/htmlEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100;

[2]
http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/plainEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100;

[3]
http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/plainX=229Y=280

[4]
http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/htmlX=229Y=280

Jörg

and here's my mapfile:

   WEB
 IMAGEPATH '/tmp/'
 IMAGEURL '/tmp/'

 METADATA
   'ows_title'   'Flächennutzungsplan der Stadt Luckau und seinen 
Ortsteilen'
   'ows_onlineresource'  
'http://geoportal.luckau.de/ows/flaechennutzungsplaene'
   'ows_srs' 'EPSG:4326  EPSG:25832 EPSG:25833 EPSG:325833 
EPSG:4528 EPSG:4839'
   'ows_abstract''WMS-Dienst zur Dartellung von 
Flächennutzungspläne im Stadtgebiet Luckau mit seinen Ortsteilen'
   'ows_accessconstraints' 'none'
   'ows_fees' 'none'
   'ows_keywordlist' 'Luckau, Flächennutzungspläne, WMS'
   'ows_include_items' 'all'
   'ows_encoding' 'ISO-8859-1'
   'WMS_FEATURE_INFO_MIME_TYPE' 'text/html'
   'gml_include_items' 'all'
   include  './includes/contact_information.inc.map'
 END
   END

### Layer 

   LAYER
 NAME 'FNP01_Grenze'
CLASS
NAME 'plan_grenze'
STYLE
  SYMBOL 0
 width 3
  OUTLINECOLOR 0 0 255
  #COLOR 220 54 199
END
 END
 DATA 'raster/fnp_luckau/grenzen_umring/plan_01_grenze.shp'
 METADATA
   'ows_title' 'FNP 01 Grenze'
   'ows_abstract' 'Umring Flächennuntzungsplan Luckau, Teil 1, Kümmritz, 
Uckro, Paserin'
  'ows_srs' 'EPSG:4326 EPSG:25833 EPSG:325833 EPSG:4528 
EPSG:4839'
  gml_include_items all
   gml_featureid ID
   ows_enable_request *
 END
 STATUS ON
 PROJECTION
init=epsg:325833
 END
TYPE POLYGON
 DUMP true
 HEADER './templates/fnp_legende_header.html'
 TEMPLATE './templates/fnp_legende.html'
 FOOTER './templates/footer.html'
   END


___
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] no result with getFeatureInfo text/plain

2015-06-10 Thread Jörg Thomsen
Am 10.06.2015 um 16:22 schrieb Lars Schylberg:
 I think You should have a
 
 wms_include_items all
 
 in the LAYER METADATA section.

yeees, thanks! I thought 'ows_include_items' 'all' in the header should
be enough.

 Same comment as I had last week.
for last weeks problem this was not the solution.

Jörg


 /Lars
 
 Jörg Thomsen skrev den 2015-06-10 16:00:
 Hello,

 in my WMS getFeatureInfo works fine with info_format html [1] and gml,
 but I don't get a result with text/plain [2]. And I found similar a
 example on mapserver.org... [3]  [4].

 Why does getFeaturInfo for text/plain not work?

 [1]
 http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/htmlEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100;


 [2]
 http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/plainEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100;


 [3]
 http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/plainX=229Y=280


 [4]
 http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/htmlX=229Y=280


 Jörg

 and here's my mapfile:
WEB
  IMAGEPATH '/tmp/'
  IMAGEURL '/tmp/'

  METADATA
'ows_title'   'Flächennutzungsplan der Stadt Luckau
 und seinen Ortsteilen'
'ows_onlineresource' 
 'http://geoportal.luckau.de/ows/flaechennutzungsplaene'
'ows_srs' 'EPSG:4326  EPSG:25832 EPSG:25833
 EPSG:325833 EPSG:4528 EPSG:4839'
'ows_abstract''WMS-Dienst zur Dartellung von
 Flächennutzungspläne im Stadtgebiet Luckau mit seinen Ortsteilen'
'ows_accessconstraints' 'none'
'ows_fees' 'none'
'ows_keywordlist' 'Luckau, Flächennutzungspläne, WMS'
'ows_include_items' 'all'
'ows_encoding' 'ISO-8859-1'
'WMS_FEATURE_INFO_MIME_TYPE' 'text/html'
'gml_include_items' 'all'
include  './includes/contact_information.inc.map'
  END
END

 ### Layer 

LAYER
  NAME 'FNP01_Grenze'
 CLASS
 NAME 'plan_grenze'
 STYLE
   SYMBOL 0
  width 3
   OUTLINECOLOR 0 0 255
   #COLOR 220 54 199
 END
  END
  DATA 'raster/fnp_luckau/grenzen_umring/plan_01_grenze.shp'
  METADATA
'ows_title' 'FNP 01 Grenze'
'ows_abstract' 'Umring Flächennuntzungsplan Luckau, Teil 1,
 Kümmritz, Uckro, Paserin'
   'ows_srs' 'EPSG:4326 EPSG:25833 EPSG:325833
 EPSG:4528 EPSG:4839'
   gml_include_items all
gml_featureid ID
ows_enable_request *
  END
  STATUS ON
  PROJECTION
 init=epsg:325833
  END
 TYPE POLYGON
  DUMP true
  HEADER './templates/fnp_legende_header.html'
  TEMPLATE './templates/fnp_legende.html'
  FOOTER './templates/footer.html'
END

 ___
 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] no result with getFeatureInfo text/plain

2015-06-10 Thread Jörg Thomsen
Hello Jukka,

it is definitely a feature. It's nice to define different outputs, all
items for text/plain an only a formatted subset in html.

But wouldn't it be nice too, if we only had to configure it in the
header with an overwrite-option in the layer-section?

Jörg

Am 10.06.2015 um 16:26 schrieb Rahkonen Jukka (MML):
 Hi,
 
 You must have either wms_include_items or ows_include_items in the 
 LAYER-METADATA. Now you have only gml_include_items at LAYER level. You do 
 have ows_include_items at MAP level but it does not have any effect there. 
 On the other hand, ows_include_items does not have any effect on the 
 text/html output but that can only be adjusted by editing the template. For 
 sending out the same information with text/plain and text/html the Mapserver 
 admin must make edits in two different places - ows_include_items and the 
 template. I am not sure if this should be considered as a bug or a feature 
 but at least it is confusing.
 
 Tested with Mapserver 7.0-beta1.
 
 -Jukka Rahkonen-
 
 Jörg Thomsen wrote:
 
 
 Hello,
 
 in my WMS getFeatureInfo works fine with info_format html [1] and gml, but I 
 don't get a result with text/plain [2]. And I found similar a example on 
 mapserver.org... [3]  [4].
 
 Why does getFeaturInfo for text/plain not work?
 
 [1]
 http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/htmlEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100;
 
 [2]
 http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/plainEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100;
 
 [3]
 http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/plainX=229Y=280
 
 [4]
 http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/htmlX=229Y=280
 
 Jörg
 
 and here's my mapfile:
   WEB
 IMAGEPATH '/tmp/'
 IMAGEURL '/tmp/'

 METADATA
   'ows_title'   'Flächennutzungsplan der Stadt Luckau und seinen 
 Ortsteilen'
   'ows_onlineresource'  
 'http://geoportal.luckau.de/ows/flaechennutzungsplaene'
   'ows_srs' 'EPSG:4326  EPSG:25832 EPSG:25833 EPSG:325833 
 EPSG:4528 EPSG:4839'
   'ows_abstract''WMS-Dienst zur Dartellung von 
 Flächennutzungspläne im Stadtgebiet Luckau mit seinen Ortsteilen'
   'ows_accessconstraints' 'none'
   'ows_fees' 'none'
   'ows_keywordlist' 'Luckau, Flächennutzungspläne, WMS'
   'ows_include_items' 'all'
   'ows_encoding' 'ISO-8859-1'
   'WMS_FEATURE_INFO_MIME_TYPE' 'text/html'
   'gml_include_items' 'all'
   include  './includes/contact_information.inc.map'
 END
   END

 ### Layer 

   LAYER
 NAME 'FNP01_Grenze'
  CLASS
NAME 'plan_grenze' 
STYLE
  SYMBOL 0 
   width 3
  OUTLINECOLOR 0 0 255
  #COLOR 220 54 199
END
 END
 DATA 'raster/fnp_luckau/grenzen_umring/plan_01_grenze.shp'
 METADATA
   'ows_title' 'FNP 01 Grenze'
   'ows_abstract' 'Umring Flächennuntzungsplan Luckau, Teil 1, Kümmritz, 
 Uckro, Paserin'
'ows_srs' 'EPSG:4326 EPSG:25833 EPSG:325833 EPSG:4528 
 EPSG:4839'
gml_include_items all
   gml_featureid ID
   ows_enable_request *
 END
 STATUS ON
 PROJECTION
  init=epsg:325833
 END
  TYPE POLYGON
 DUMP true
 HEADER './templates/fnp_legende_header.html'
 TEMPLATE './templates/fnp_legende.html'
 FOOTER './templates/footer.html'
   END
 
 
 ___
 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] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?

2015-06-10 Thread Lime, Steve D (MNIT)
Correct. Filters specified in this manner are passed directly to the underlying 
driver. My goal was to remove ambiguity with the FILTER keyword itself since it 
could take both MapServer syntax and native driver syntax - depending on 
context. --Steve

-Original Message-
From: Michael Smith [mailto:michael.smith.e...@gmail.com] 
Sent: Wednesday, June 10, 2015 5:28 AM
To: Andrea Peri; Lime, Steve D (MNIT)
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Incompatibility at Filter - level between 
mapserver 6.x and the last mapserver-dev ?

Andrea,

You can always use your existing filters with

PROCESSING NATIVE_FILTER=WHERE (ANNO = 2006) and (CODICE_UNIVOCO like
'%idtpn%' )

Or you can use a MapServer expression which are documented here:
http://mapserver.org/mapfile/expressions.html#mapserver-expressions

Mike


Michael Smith

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




-Original Message-
From: Andrea Peri aperi2...@gmail.com
Date: Wednesday, June 10, 2015 at 5:41 AM
To: Lime, Steve D (MNIT) steve.l...@state.mn.us
Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Incompatibility at Filter - level between
mapserver 6.x and the last mapserver-dev ?

Hi steve,
this new sintax will allow the AND operator ?

I have a filter like this:

FILTER WHERE (ANNO = 2006) and (CODICE_UNIVOCO like '%idtpn%' )

and don't know how to transform it with the new sintax.

Is this kind of filter supported ?

Thx,

A.


2015-06-09 19:05 GMT+02:00 Lime, Steve D (MNIT) steve.l...@state.mn.us:
 As of MapServer 7.0 FILTERS must be given using MapServer syntax - this
is a regression noted in the Migration Guide, see
http://mapserver.org/MIGRATION_GUIDE.html#migration. There's an OGR
example right towards the top of that document. Basically:

   FILTER WHERE ([CODICE] = 107)
   FILTERITEM CODICE

 Becomes:

   PROCESSING 'NATIVE_FILTER=CODICE=107'

 Steve

 -Original Message-
 From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Andrea Peri
 Sent: Tuesday, June 09, 2015 3:45 AM
 To: mapserver-users@lists.osgeo.org
 Subject: [mapserver-users] Incompatibility at Filter - level between
mapserver 6.x and the last mapserver-dev ?

 Hi,
 I have just update my mapserver to the last mapserver-dev .

 After this update, I see an error on the filtering.

 In my mapfile the data configuration was originally this:

 CONNECTION /path-to-spatialite-db/zz_db_tematici.sqlite
 CONNECTIONTYPE OGR
 DATA IFT2009
 EXTENT 1554650.74 4678225.52 1771822.76 4924891.9
 FILTER WHERE ([CODICE] = 107)
 FILTERITEM CODICE
   


 The log report this error:

 [Tue Jun  9 10:39:46 2015].153296 msDrawMap(): rendering using
 outputformat named AGGA (AGG/PNG).
 [Tue Jun  9 10:39:46 2015].154698 msDrawMap(): WMS/WFS set-up and
query, 0.001s
 [Tue Jun  9 10:39:46 2015].262330 LayerDefaultTranslateFilter():
 General error message. This data driver does not implement filter
 translation support
 [Tue Jun  9 10:39:46 2015].282402 msDrawMap(): Layer 239
 (rt_ucs.idift.rt.107), 0.128s
 [Tue Jun  9 10:39:46 2015].282550 msDrawMap(): Drawing Label Cache,
0.000s

 I'm using spatialite as db.

 After this error, I read this RFC:
 http://www.mapserver.org/ru/development/rfc/ms-rfc-91.html

 And try the new settings,

 FILTER (([FILTERITEM[ = string) AND (CODICE = 107))

 but it seem don't work.

 I don't understand if this is an issue of the new settings with
 spatialite or I'm wrong something.

 Thx,


 --
 -
 Andrea Peri
 . . . . . . . . .
 qwerty àèìòù
 -
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users



-- 
-
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


Re: [mapserver-users] db connection through Mapserver fails

2015-06-10 Thread Jörg Thomsen
hello,

I hope you did not provide your real connection params?

It is a PG-'poblem', try to close some open connections (old and still
running ms-processes, PG-Admin, ..) or increase the max_connections
configuration of your PostgreS.

Jörg




Am 10.06.2015 um 16:18 schrieb Ahmet Temiz:
 hello
 
 My postgis raster db connection through Mapserver fails.
 
 here is the message coming from WildFly:
 
 db connection data PG: dbname=tr22 host=localhost user=orkun
 password=22 port=5432 schema=public table=o_4_trdem2where=
 ST_Intersects(rast,  ST_MakeEnvelope( 29.90 , 40.42 , 31.49 , 40.99,
 4326  )) mode=2
 
 ERROR 1: PQconnectdb failed: FATAL:  remaining connection slots are
 reserved for non-replication superuser connections
 
 Can you tell me why ?
 
 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] Is this a CGI problem?

2015-06-10 Thread Gery
Hello,

I just installed MapServer 6.4.1 in Linux Mint and got this error (Opera
dragonify) after passing an url in my localhost:

url:
localhost/ms?LAYERS=Temp2014TRANSPARENT=TRUEFORMAT=image%2FpngSERVICE=WMSVERSION=1.1.1REQUEST=GetMapSTYLES=SRS=EPSG%3A900913BBOX=-10635414.142106,-2285406.7635122,-6619106.9284492,160578.14127299WIDTH=821HEIGHT=500

PNG
IHDR5ôÇÔNIDATxœíÁ1 õOm O àc{÷ˆC·IEND®B`‚

http://osgeo-org.1560.x6.nabble.com/file/n5210276/11.png 

I use gdal-1.11.2 (installed from source) and MapServer was installed with
apt-get (UbuntuGis stable). In my Synaptic Package Manager I found
'libgdal1h', not sure if this would be related. Apache version here:

ii  apache2 2.4.7-1ubuntu4.4
   
amd64Apache HTTP Server
ii  apache2-bin 2.4.7-1ubuntu4.4
   
amd64Apache HTTP Server (binary files and modules)
ii  apache2-data2.4.7-1ubuntu4.4
   
all  Apache HTTP Server (common files)
ii  apache2-utils   2.4.7-1ubuntu4.4
   
amd64Apache HTTP Server (utility programs for web servers)
ii  libapache2-mod-mapcache 1.2.1-2 
   
amd64tile caching server - Apache module
ii  libapache2-mod-perl2   
2.0.8+httpd24-r1449661-6ubuntu2 amd64Integration
of perl with the Apache2 web server
ii  libapache2-mod-php5 5.5.9+dfsg-1ubuntu4.9   
   
amd64server-side, HTML-embedded scripting language (Apache 2 module)
ii  libapr1:amd64   1.5.0-1 
   
amd64Apache Portable Runtime Library
ii  libaprutil1:amd64   1.5.3-1 
   
amd64Apache Portable Runtime Utility Library
ii  libaprutil1-dbd-sqlite3:amd64   1.5.3-1 
   
amd64Apache Portable Runtime Utility Library - SQLite3 Driver
ii  libaprutil1-ldap:amd64  1.5.3-1 
   
amd64Apache Portable Runtime Utility Library - LDAP Driver
ii  libsvn1:amd64   1.8.8-1ubuntu3.1
   
amd64Shared libraries used by Apache Subversion

Any hints are appreciated, thanks in advance,



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Is-this-a-CGI-problem-tp5210276.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] Memory leak

2015-06-10 Thread Ian Walberg
Posting to mapserver users as well as dev list.

Folks,

We have a php application which renders a new map every few seconds and with 
any of the versions with the refactored label font support we see what appears 
to be a memory leak.

When our application exits the error is 'Freetype was unable to load font 
file'. This is from fontcache.c and occurs in our case after around 130 calls 
to the msGetFontFace function.

I will look into this further but from a quick look it seems that the 
FT_New_Face is being called every time.

Our application uses only one font so our assumption is that this should not 
need to be called every time.

Any help appreciated.

Thanks

Ian

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

Re: [mapserver-users] Is this a CGI problem?

2015-06-10 Thread Gery
Btw, if I use shp2img I get an empty PNG, so this would tell me that CGI may
not be the issue, I am wondering if my postgis connection would be the
problem here, any ideas are appreciated.



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Is-this-a-CGI-problem-tp5210276p5210291.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


Re: [mapserver-users] no result with getFeatureInfo text/plain

2015-06-10 Thread Rahkonen Jukka (MML)
Hi,

Definitely, not sure about that. It can be a feature if you are both 
configuring Mapserver and building/controlling the applications which are using 
the service. If you just offer a WMS service for the public your users can't 
imagine that changing info_format in the client settings may have an effect on 
the data that is returned with GetFeatureInfo.  Consider GetMaps with image/png 
vs. image/jpeg or WFS GetFeature output as GML vs. GeoJSON.

Because attributes are different then MAP level setting could only have options 
all or none.  Current situation means practically having none as a 
default for all layers. So the advantage would be an option to set the default 
to all for every layer in the service and Mapserver admin should remember to 
think if GetFeatureInto output should be restricted somehow for the new layers. 
 That does not feel like a big saving in labour.

What could save labour would be to generate automatically a template that would 
show all the fields which are listed in the ows_include_items in a simple 
default html table. Keyword for activating it could be TEMPLATE AUTO or 
something like that. I suppose that Geoserver is doing it that way 
http://docs.geoserver.org/latest/en/user/tutorials/GetFeatureInfo/index.html

-Jukka Rahkonen-

Jörg Thomsen wrote:

 Hello Jukka,

 it is definitely a feature. It's nice to define different outputs, all items 
 for text/plain an only a formatted subset in html.

 But wouldn't it be nice too, if we only had to configure it in the header 
 with an overwrite-option in the layer-section?

Jörg

Am 10.06.2015 um 16:26 schrieb Rahkonen Jukka (MML):
 Hi,
 
 You must have either wms_include_items or ows_include_items in the 
 LAYER-METADATA. Now you have only gml_include_items at LAYER level. You do 
 have ows_include_items at MAP level but it does not have any effect there. 
 On the other hand, ows_include_items does not have any effect on the 
 text/html output but that can only be adjusted by editing the template. For 
 sending out the same information with text/plain and text/html the Mapserver 
 admin must make edits in two different places - ows_include_items and the 
 template. I am not sure if this should be considered as a bug or a feature 
 but at least it is confusing.
 
 Tested with Mapserver 7.0-beta1.
 
 -Jukka Rahkonen-
 
 Jörg Thomsen wrote:
 
 
 Hello,
 
 in my WMS getFeatureInfo works fine with info_format html [1] and gml, but I 
 don't get a result with text/plain [2]. And I found similar a example on 
 mapserver.org... [3]  [4].
 
 Why does getFeaturInfo for text/plain not work?
 
 [1]
 http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1RE
 QUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP1
 0_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.80769
 2308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=tex
 t/htmlEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT
 =100
 
 [2]
 http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1RE
 QUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP1
 0_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.80769
 2308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=tex
 t/plainEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUN
 T=100
 
 [3]
 http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUES
 T=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPS
 G:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTR
 ANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/plainX=229Y=280
 
 [4]
 http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUES
 T=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPS
 G:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTR
 ANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/htmlX=229Y=280
 
 Jörg
 
 and here's my mapfile:
   WEB
 IMAGEPATH '/tmp/'
 IMAGEURL '/tmp/'

 METADATA
   'ows_title'   'Flächennutzungsplan der Stadt Luckau und seinen 
 Ortsteilen'
   'ows_onlineresource'  
 'http://geoportal.luckau.de/ows/flaechennutzungsplaene'
   'ows_srs' 'EPSG:4326  EPSG:25832 EPSG:25833 EPSG:325833 
 EPSG:4528 EPSG:4839'
   'ows_abstract''WMS-Dienst zur Dartellung von 
 Flächennutzungspläne im Stadtgebiet Luckau mit seinen Ortsteilen'
   'ows_accessconstraints' 'none'
   'ows_fees' 'none'
   'ows_keywordlist' 'Luckau, Flächennutzungspläne, WMS'
   'ows_include_items' 'all'
   'ows_encoding' 'ISO-8859-1'
   'WMS_FEATURE_INFO_MIME_TYPE' 'text/html'
   'gml_include_items' 'all'
   include  './includes/contact_information.inc.map'
 END
   END

 ### Layer 

   LAYER
 NAME 'FNP01_Grenze'
  CLASS
NAME 'plan_grenze' 
STYLE
  SYMBOL 0 
   width 3
  OUTLINECOLOR 0 0 255
  #COLOR 220 54 199
END
 END
 DATA