WMS time question

[David William Bitner]

I've thought about capability like this for use with Aircraft Flight Tracks
as well.  Since all my data is in PostGIS, I was wondering how difficult it
would be to implement an analog to being able to use !BBOX! to capture the
bbox part of the query and to be able to put it where you want in the SQL
query and to have a !TIME! that could intercept the WMS time request and
pass it through to either your query (ie where !TIME! between MIN_DATE and
MAX_DATE -- wouldn't work if !TIME! was a time range) or into a custom
plpgsql function.

What I do currently is to just use %time% with mapserver cgi and variable
substitution, but there isn't quite a way to port that over to WMS-T.

On 7/27/06, Eijnden, Bart van den (AGI) <b.vdeijnden at agi.rws.minvenw.nl>
wrote:
>
> Hi Assefa,
>
> 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.
>
> Does this make sense?
>
> Best regards,
> Bart
>
> -----Oorspronkelijk bericht-----
> Van: UMN MapServer Users List
> [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]Namens Yewondwossen Assefa
> Verzonden: donderdag 27 juli 2006 3:35
> Aan: MAPSERVER-USERS at LISTS.UMN.EDU
> Onderwerp: Re: [UMN_MAPSERVER-USERS] WMS time question
>
>
> Bart,
>
>
> Bart van den Eijnden (OSGIS) wrote:
> > Hi list,
> >
> > looking through the Mapserver WMS time HOWTO I wondered one thing, it is
> > only possible to have 1 timeitem, a DB column which contains the
> > date/time. Ofcourse this is pretty okay for satellite images (in a
> > tileindex) which are taken every X days/months.
> >
> > But what happens to road network segments (geometries in Oracle Spatial
> > for instance) which have a minimum date and a maximum date? So you need
> to
> > specify 2 timeitems (one min and one max) for that. Was this use case
> just
> > not implemented?
> >
>
>   What would the min/max date represent : the valid time extents or
> simply 2 time fields on which we can do a query ?
> The wms request allows to  send a time value that is then compared to
> the value inside the timeitem. Would you expect to be able to compare
> the time request between the 2 timeitmes defined ?
>
> > Best regards,
> > Bart
> >
>
>
> --
> ----------------------------------------------------------------
> Assefa Yewondwossen
> Software Analyst
>
> Email: assefa at dmsolutions.ca
> http://www.dmsolutions.ca/
>
> Phone: (613) 565-5056 (ext 14)
> Fax:   (613) 565-0925
> ----------------------------------------------------------------
>
>
> Disclaimer
> ************************************************************************
> Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is
> uitsluitend bestemd voor de geadresseerde. Als u dit bericht per abuis
> hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te
> informeren. Wij adviseren u om bij twijfel over de juistheid of de
> volledigheid van de mail contact met afzender op te nemen.
>
> This message shall not constitute any rights or obligations.
> This message is intended solely for the addressee.
> If you have received this message in error, please delete it and
> notify the sender immediately. When in doubt whether this message
> is correct or complete, please contact the sender.
> ************************************************************************
>



-- 
************************************
David William Bitner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060727/fce36434/attachment.htm>