On 9/4/22 14:35, Tim Sutton wrote:
Hi Richard
Don’t people normally use things like https://www.timescale.com/
<https://www.timescale.com/?utm_source=timescaledb-paid&utm_medium=google-search&utm_campaign=brand-2022&utm_content=homepage&utm_term=timescale-postgres&gclid=EAIaIQobChMIspXn6JL7-QIVOpBoCR3QLQf8EAAYASAAEgL09PD_BwE>
For this? In any case some of our clients that are doing things like vehicle
tracking are…
Yes to *store* it, but my point is: given 2 points with 100 timesteps, QGIS
will create 200 features for it to be able to display it...
So to 'view' that data in (Q)GIS, you have to flatten it to a 'table' with 200
features...
While the actual interesting part is the value and the time, NOT those 2 xy
fields... (the case of moving vehicles is slightly different, there the xy
values also change)...
Maybe I'm in the wrong crowd here to tell the geoms are not so much of interest
in my case ;-)
I'm looking for a way/model (non tabular) that QGIS creates 2
geometries/features, and then will style/paint it based on the timestamps and
values
The use case here: having 5000 sensors in Europe, having 500.000.000
measurements in total, I don not want to create 500.000.000 features.
I'd preferred to create those 5000 features, and then get the
geom-id/value/timestamp for a given filter range and repaint my canvas.
Something like 'dynamic' joins: the geometries will stay the same, but the
'joined' columns/table will change based on the 'temporal filter' requested.
Sorry if I can not make myself more clear (or making it more complex that it
maybe is...) :-)
Regards,
Richard Duivenvoorde
_______________________________________________
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer