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
tests with the tools I mentioned, then come back here and paste in your
query syntax for the mailing list readers, I bet someone will be able to
help you then.
-jeff
--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/
On 2016-08-09 9:54 AM, drobins wrote:
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 that I find it a little difficult to really explain what I'm trying to
achieve :)
I guess easiest description would be like being able to scroll
forward/backwards and depending on where I stop, display everything that is
active on that current selected date.
Thanks
-Daniel
jmckenna wrote
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
statement of your mapfile layer. See examples at
http://www.mapserver.org/input/vector/postgis.html
-jeff
--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/
On 2016-08-09 8:56 AM, drobins wrote:
I have a PostGIS database and I have a column "startdate" and "enddate"
in my
database (YYYY-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
2017
2018
2019
2020
I have an entry in my database with:
startdate: 2016-01-01
enddate: 2019-01-01
If I check the layer 2017, I would like it to check if its between the
start/enddate and if yes, display it.
Is this possible with Mapserver/Openlayers?
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
