[Qgis-user] Visualisation of point data in a MS Access .mdb or ODBC database
Dear all, We have a large MS Access database that contains X & Y of measurement locations of traffic intensity. We have previously exported the data to CSV and used the QGIS Delimited Text import to plot the locations. We now would like to be plot this dat a directly in QGIS by connecting to the MS Access mdb. 1. We have tried "Add Vector layer / database / odbc" which gives the tables, but needs additionally the route Processing / Toolbox / Geoprocessing / create vector layer to create a map. 2. As an alternative the Evis plugin connects fine and enables you to predefine queries which show the results on the map. In bot h solutions the problem is that after the project is saved and re-opened the database connection has to be established again and all queries need to be reloaded manually. Also see this similar discussion on: http://gis.stackexchange.com/questions/9462/can-qgis-read-an-odbc-connection /73160#73160 Our questions are: 1. Can it be "live linked" to the ODBC connection so that when a project is re-opened, the layer "replots" all old and newly added locations dynamically (as opposed to exporting to shapefile, which would create a snapshot in time)? 2. Or in other words: Is there a way when re-opening the qqs project to load the one of t he two solutions automatically (odbc>create vectorlayer or the Evis plugin with the database connections and loading of all predefined queries). We appreciate all the help in advance! Regards, Coen ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] dataPlotly plugin
Hi, I recently tested the DataPlotly ( very impressive work!) plugin and I have a question. One of the great things of this plug-in is that when you select items in a layer the plot is updated with the data of the selection. A problem occurs when you do this using subplots (multiple plots) besides each other, because a new selection only gives one plot instead of the (multiple) subplots. It occurs at the scatterplots, but I notice it also for the other graphics. Do I something wrong, or is it a bug. I would be grateful for any suggestion. I use 3.7.1. of the plug-in, QGIS 3.20.2 on Windows. Regards, Coen van Tooren ___ 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