[QGIS-Developer] Model for Temporal Measurement (vector) Datasets ?

[Tim Sutton]

Hi Richard

Don’t people normally use things like https://www.timescale.com/

For this? In any case some of our clients that are doing things like vehicle tracking are…

Regards 

Tim

Sent from my iPhone

> On 2 Sep 2022, at 13:07, Richard Duivenvoorde via QGIS-Developer <qgis-developer at lists.osgeo.org> wrote:
> 
> Hi All,
> 
> Anybody is aware of a model in which data owns a location, but THAT location has a (growing) set of [timestamp, value] observation data to it....
> 
> In GIS/QGIS everything is tabular (talking about vector here, I know meshes can have more shapes).
> 
> But in the IOT world the 'location' is 'just an attribute', and the 'other' data is actually more of interest (and growing in time).
> 
> Currently to view measurements, 'we' often replicate the location for every value/measurement: we create a 'Feature' for every time step (eg for example via a WFS)
> 
> The OGC has a SensorThingsApi (STA) standard, in which for given location you can request all values/observations (of filter a certain sensortype/parameter). So one geometry has a full table of data to it.
> 
> BUT to 'work' with that data in QGIS, you always have to 'flatten' it, one way or another, (I think), for every time step: create a feature with: location, time, value...
> 
> My Question:
> 
> - isn't there some model (or can we come up with one) in which a location can actually have a range of time/value data (like some table join like), and when you use the Temporal Controller, you style your layer by RE-using the one location, but getting the value for current Timestamp (in the TimeController). Some sort of indirect filtering....?
> 
> - or is this the mesh model (I know netcdf's in which you have often predefined meshes/location and the data/time vector is growing)?
> And would a solution be to have some kind of in memory vector -> mesh loader or so???
> 
> I hope this makes sense to others. Any input appreciated.
> 
> Regards,
> 
> Richard Duivenvoorde
> 
> PS, if you want to play with SensorThingsApi:
> - install: https://github.com/AirBreak-UIA/SensorThingsAPI_QGIS-plugin
> - connect it to: https://airquality-frost.k8s.ilt-dmz.iosb.fraunhofer.de/v1.1/Locations
> (around 5000 location and 500-million 'observations')
> - load all locations in one layer, and click on a location
> My point: the data is then viewable/selectable by table and graph, but NOT loadable in a sense way (yet) in QGIS...
> _______________________________________________
> QGIS-Developer mailing list
> QGIS-Developer at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20220904/5ef88e6b/attachment.htm>