Re: [Qgis-user] Model for Temporal Measurement (vector) Datasets ?
Richard and list, On Fri, Sep 2, 2022 at 4:07 AM Richard Duivenvoorde via Qgis-user < qgis-user@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 > > We've done this but clumsily by duplicating the spatial data, one for each point (ie a one-to-many join). Also with start-datetime and end-datetime which is even uglier - the overlap of datetime of occurrence vs datetime of display is really ugly, especially when you're trying to visually display "point of ignition", "bloom", "fading away" if you get my meaning. A sort of heat map but automated. Anyway, as may be obvious from the above I'm also very interested. Years ago in the IJGIS there was an article about design of spatial databases with time measures, but sad to say all my IJGIS issues have long since been recycled. Maybe someone is doing this in d3.js? Seems like a logical framework for this sort of thing... -- Chris Hermansen · clhermansen "at" gmail "dot" com C'est ma façon de parler. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] mdal / mesh simple formats
Hi Peter, woohoo, awesome, okay now I get it and it works. I thought that as the 2dm file had duplicates of the cells & nodes in the simple mesh I was looking at that it wasn't needed. Also the xdmf loads directly into paraview so I thought that QGIS would do the same thing. All I need to do is generate a 2dm file with nodes and cells like the examples and my meshes *should work, easy. Thanks again, I'll post this back to QGIS users in case anyone else hits the same issue. Matt On Fri, Sep 2, 2022 at 5:58 PM Peter Petrik wrote: > > Hi, > > 1) > on linux/docker, try to set > export LD_LIBRARY_PATH= > ./mdalinfo ... > > 2) XDMF is a dataset with values ONLY. So in that menu you need to load 2dm > file == definition of your mesh frame, and once loaded, you right-click on > the mesh layer and "add values/datasets" in the properties (XMDF) file. Some > files (e.g. netcdf) has it in one file all, but this one is different. Best > to check some online tutorials. > > Kind Regards, > Peter Petrík > CPO of Mergin Maps > LI, Mergin Maps > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] 1 Layout --> 9 Atlas
Hi, haven't done this in a long time and have no example project at hand, but get a first clue here: https://gis.stackexchange.com/a/173443 or here https://gis.stackexchange.com/a/339296 Hope others will fill the gaps. Good luck On 02.09.22 13:24, Miquel Pujol Garcia via Qgis-user wrote: *Hi QGISers,* My question is about Atlas and Layout. I have a file "polygons.shp" with 30 elements. Every element with ID. I would like to do a layout sheet with 9 elements different and when I refresh the view, and the elements change. There's someone any idea how to do this? Thanks, *Miquel Pujol Garcia* ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] 1 Layout --> 9 Atlas
*Hi QGISers,* My question is about Atlas and Layout. I have a file "polygons.shp" with 30 elements. Every element with ID. I would like to do a layout sheet with 9 elements different and when I refresh the view, and the elements change. There's someone any idea how to do this? Thanks, *Miquel Pujol Garcia* ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Model for Temporal Measurement (vector) Datasets ?
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-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] spatial selection in parent table to edit records in child table without geometry
Dear all, In Postgres, I have a parent table with geometry, and a child table without. A relationship has been defined between the two which works for the forms I'm using. I would like to be able to use the map to select features in the parent table and the corresponding records in the child table, in order to be able to edit the selected child records. I know I can create an updateable view in postgres that would achieve this. Is there a better/easier way to do it? A way to let the child layer inherit the geometry from the parent? I first thought to join the parent table to the child table, but that only joins the attributes, and doesn't make the child table spatially selectable. Using the db manager to create a virtual layer gives the correct query result, but the loaded layer is not editable (as to be expected, I think) and the attribute table is empty (maybe not expected). I have the suspicion that this should be straightforward and I am just overlooking the obvious. Any pointers/thoughts are appreciated. Thank you, Janneke ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user