Re: [mapserver-users] REMINDER[#2] OSGeo Local Chapter (aka as TCMUG) Meeting

2020-04-08 Thread Basques, Bob (CI-StPaul)
Just sending this out again, since the venue (conferencing software) was 
changed at the last minute.

See you later today.

Bobb



From: Basques, Bob (CI-StPaul)
Sent: Tuesday, April 7, 2020 2:15 PM
To: tcmug (tc...@lists.osgeo.org) ; 
mapserver-users@lists.osgeo.org; 'geomoose-us...@lists.osgeo.org' 

Subject: REMINDER and Meeting change.

All,

I've been talked out of using ZOOM and into using Jitsi instead.  There seem to 
be some nice capabilities in it that the commercial/semi-commercial setup don't 
have.

So, switching over to Jitsi.  No PW, you can just use the link below to join 
from a desktop, and download a app for Mobile use on a phone.

bobb



You are invited to join a meeting.

See agenda here : 
Agenda

April 8th, at 4:30 PM central time.  USA

Join the meeting:
https://meet.jit.si/TCMUG

To join by phone instead, tap this: +1.512.402.2718,,3602979209#

Looking for a different dial-in number?
See meeting dial-in numbers: 
https://meet.jit.si/static/dialInInfo.html?room=TCMUG


If also dialing-in through a room phone, join without connecting to audio: 
https://meet.jit.si/TCMUG#config.startSilent=true
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] WMS-T with daterange attribute

2020-04-08 Thread pe_lord
I have a time enabled dataset containing various attributes, 3 of them are
related to time. The temporal steps between the records are not constant...

The dataset presents roads history. There is many overlap inside this
dataset.

1st attribute = start_date
2nd attribute = end_date
3rd attribute = period_valid [start_date,end_date]

Here what i've tried:

1- Generate a step constant temporal dataset (e.g. create a geometry for
each date I want to publish by wms-t, and join the geometry (and attribute)
where the step intersect the period for each records). Then my dataset pass
from 250K to 11M records..
2- Keep my original dataset and let mapserver manage the temporal
intersection between the user's provided date AND the period (period_valid).

In this ladder situation, mapserver send me this error:


PGRES_FATAL_ERROR (7)
...
Error (ERROR:  operator does not exist: daterange >= timestamp with time
zone

LINE 1: ...92 321002.819068926))',3798) and ("period_valid" between da...

 ^

HINT:  No operator matches the given name and argument type(s). You might
need to add explicit type casts.


Do you know if there is a way for Maserver to manage a daterange field (or a
start_date AND end_date) in a wms-t request?









--
Sent from: http://osgeo-org.1560.x6.nabble.com/Mapserver-User-f4226646.html
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WMS-T with daterange attribute

2020-04-08 Thread pe_lord
I've forgot a important thing in my question:


Do you know if there is a way for Mapserver to manage a daterange field (or
a
start_date AND end_date) in a wms-t request?

The request only provide a single date, not a range. 
Does Mapserver could generate a SQL like  :
select ... from table where dateRangeField contains userProvidedDate





--
Sent from: http://osgeo-org.1560.x6.nabble.com/Mapserver-User-f4226646.html
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users