Re: [QGIS-Developer] Slow downloads for LTR MSI

2022-09-04 Thread Tim Sutton via QGIS-Developer
Hi IIRC, Richard's explanation as to why we turned off the CDN is that it was trying to grab all the download archives each time it did a cache request and it was blowing our server out of the water. So the plan is to split the latest downloads and the archives to separate hosts / domains / sites

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,