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
201
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
st
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
Note
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
t
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 column "startdate" and
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 experts! Visit
http://goo.gl
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]
>
> Cheers
> Andrea
There
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 neithe
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 wrot
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 it
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
11 matches
Mail list logo