Ticket #1849 (new enhancement)

Opened 2 years ago

Last modified 2 years ago

[WMS TIME] Add support for for min/max timefields

Reported by: assefa Assigned to: assefa
Priority: high Milestone: FUTURE
Component: WMS Server Version: unspecified
Severity: minor Keywords:
Cc: mapserver@geochem.de, bartvde@osgis.nl, akrherz@iastate.edu

Description 

e-mail from Bart

so e.g. you would have (DD-MM-YYYY):

ROAD_SEGMENT_ID		MIN_DATE		MAX_DATE
1				01-01-2006		01-04-2006
2				01-03-2006		01-06-2006
etc.

So these represent validity, the road segment is valid/existant between MIN_DATE
and MAX_DATE.

So if I want a map with the situation of 01-05-2006, 1 would not be on it, but 2
would be.

If I would want a map with the situation of 15-03-2006 until 15-04-2006, both
would be on it.

Change History

07/27/06 12:39:16 changed by bartvde@osgis.nl

  • cc set to bartvde@xs4all.nl.
Add myself to the cc.

Assefa, btw, I currently have no funding for this, but will keep it in mind as a
possible enhancement.

07/27/06 13:06:46 changed by assefa

  • severity changed from normal to enhancement.
  • milestone set to 4.10 (5.0?) release.
The proposed solutions would be 

We could add a support by supporting "wms_timeitem_min" and "wms_timeitem_max"
(mutually exclusive with wms_timeitem) and doing the following for different
time values passed in the wms TIME parameter :

  - single time for example: ...&TIME=2004-10-12&... would give
(`[time_field_min]` <= `2004-10-12`) and  `[time_field_max]` >= `2004-10-12`)

  - multiple values (2004-10-12, 2004-10-13) would give ((`[time_field_min]` <=
`2004-10-12` and  `[time_field_max]` >= `2004-10-12`) OR (`[time_field_min]` <=
`2004-10-13`) and `[time_field_max]` >= `2004-10-13`))

  - single range : 2004-10-12/2004-10-13 transforms to ((`[time_field_min]` <=
`2004-10-12`) AND (`[time_field_max]` >= `2004-10-13`))

  - multiple ranges (2004-10-12/2004-10-13, 2004-10-15/2004-10-16) transform to
((`[time_field_min]` <= `2004-10-12`) AND (`[time_field_max]` >= `2004-10-13`))
OR ((`[time_field_min]` <= `2004-10-15`) AND (`[time_field_max]` >= `2004-10-16`))

 I will try to do it before the 4.10 release.

07/27/06 23:10:12 changed by akrherz@iastate.edu

  • cc set to akrherz@iastate.edu.
Hi,

I like this approach as well and would be happy to test a patch when the time
comes.  

thanks!
  daryl

07/28/06 02:20:03 changed by mapserver@geochem.de

  • cc set to mapserver@geochem.de.

08/25/06 11:45:53 changed by assefa

  • owner changed from mapserverbugs to assefa.
Reassigned

08/25/06 11:47:44 changed by assefa

  • milestone changed from 4.10 release to FUTURE.
Set target to future. Won't be addressed for 4.10.