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

2022-10-01 Thread Anita Graser via QGIS-Developer
Hi Richard, Hi Tim, Here's what I could come up with: https://anitagraser.com/2022/10/01/visualizing-iot-time-series-with-qgis-mobilitydb/ I think it's promising but lacks GUI support. Regards, Anita On 05.09.2022 01:34, Tim Sutton wrote: Hi Richard Thanks for clarifying your ideas. Could

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

2022-09-04 Thread Tim Sutton via QGIS-Developer
Hi Richard Thanks for clarifying your ideas. Could we not implement something similar to how WMS-T works in that we have a PostgreSQL-T provider extension for example that passes a time filter to the underlying data base request. In another system we are build for a client we have some logic to

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

2022-09-04 Thread Anita Graser via QGIS-Developer
Hi Richard, On 02.09.2022 13:07, Richard Duivenvoorde wrote: 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 MobilityDB has temporal temporal bools, ints, floats, texts, and geometries:

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

2022-09-04 Thread Richard Duivenvoorde via QGIS-Developer
On 9/4/22 15:27, Matthias Kuhn wrote: Hi Richard, It seems to me this should be possible using: 1. Two tables: - Points - Measurements (Timestamp, Measured attribute) 2.  A view (Points LEFT JOIN Measurements) What would be the actual result in your case (eg in the case of 2 points with

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

2022-09-04 Thread Matthias Kuhn via QGIS-Developer
Hi Richard, It seems to me this should be possible using: 1. Two tables: - Points - Measurements (Timestamp, Measured attribute) 2. A view (Points LEFT JOIN Measurements) Timescale as proposed by Tim can be added to the mix to optimize things if you have additional requirements for

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

2022-09-04 Thread Richard Duivenvoorde via QGIS-Developer
On 9/4/22 14:35, Tim Sutton wrote: Hi Richard Don’t people normally use things like https://www.timescale.com/

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

2022-09-04 Thread Tim Sutton via QGIS-Developer
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 > wrote: > > Hi All,

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

2022-09-02 Thread Richard Duivenvoorde via QGIS-Developer
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