Re: [mapserver-users] Mapserver filter/expression by DATE

Hi Jeff, after experimenting a bit with the queries I ended up using the EXTRACT function and make a filter based on that. Giving it some second thought, made me realize this is actually much easier: FILTER ("startdate" <= '2016-01-01' AND "enddate" >= '2016-12-31') For the time being I think

Re: [mapserver-users] Mapserver filter/expression by DATE

Hello, I just sent a PR to remove uk flag and translation. As Jeff said in the ticket, there is no translated string for Ukraine. Thanks Jeff and Ian. Y. On Tuesday, August 09, 2016 13:48:08 Jeff McKenna wrote: > Good catch Ian, I can see inside the docs source paths of > "translated/uk", so

Re: [mapserver-users] Mapserver filter/expression by DATE

Good catch Ian, I can see inside the docs source paths of "translated/uk", so it is on our side. I've created a ticket for this, and I will now attempt to change that to the proper "ua" country code. https://github.com/mapserver/docs/issues/150 -jeff On 2016-08-09 11:04 AM, Ian Turton

Re: [mapserver-users] Mapserver filter/expression by DATE

I have http://mapserver.org/uk/ogc/wms_dimension.html as my dimension, which seems wrong as ususally I would be GB or en_gb in this context. However I believe that the 2 letter Ukrainian code is 'UA' not UK for exactly this reason (see https://en.wikipedia.org/wiki/ISO_3166-2:UA) - I think

Re: [mapserver-users] Mapserver filter/expression by DATE

On Tuesday, August 09, 2016 15:27:41 Andrea Aime wrote: > On Tue, Aug 9, 2016 at 3:21 PM, Ian Turton wrote: > > PS does anyone know why the MapServer site thinks I'd like cyrillic > > characters in the headings? > > Happens to me as well :-) > > [image: Inline image 1] > >

Re: [mapserver-users] Mapserver filter/expression by DATE

On Tue, Aug 9, 2016 at 3:21 PM, Ian Turton wrote: > PS does anyone know why the MapServer site thinks I'd like cyrillic > characters in the headings? > Happens to me as well :-) [image: Inline image 1] Cheers Andrea -- == GeoServer Professional Services from the

Re: [mapserver-users] Mapserver filter/expression by DATE

Could you use the WMS dimension support? http://mapserver.org/uk/ogc/wms_dimension.html Ian PS does anyone know why the MapServer site thinks I'd like cyrillic characters in the headings? On 9 August 2016 at 12:56, drobins wrote: > I have a PostGIS database and I have a

Re: [mapserver-users] Mapserver filter/expression by DATE

Hi Daniel, I think for the thousands of readers on this mailing list, you really need to give examples of your psql queries that you are trying (people in these open communities find editing your mistakes much easier than suggesting new solutions). So, dive into the commandline :) Do some

Re: [mapserver-users] Mapserver filter/expression by DATE

Hi jeff, does this apply also if I have different projects from different start/enddates? Lets say I have 3 projects: Project A: 2016-01-01 till 2019-01-01 Project B: 2017-02-02 till 2022-01-01 Project C: 2018-03-03 till 2025-05-01 When I check YR2017 I want to see Project A and B but not C

Re: [mapserver-users] Mapserver filter/expression by DATE

Hello, You can create your query through the commandline tool 'psql', and once you have that working you can test through the 'ogrinfo' commandline tool, using its '-sql' switch. Then you can test through MapServer with the 'shp2img' commandline tool, by setting that query within the DATA

[mapserver-users] Mapserver filter/expression by DATE

I have a PostGIS database and I have a column "startdate" and "enddate" in my database (-MM-DD format). What I want to do is make a filter/expression that checks if a certain selected date falls between those 2 dates. Example: I have a checkbox for enable/disable the following layers: 2016