MariaDB to QGIS
Plugin ID: 3450
Fetches longitude (x) and latitude (y) data from MariaDB and writes it to a Shapefile or GeoPackage and adds it to your map.
(3) votes
Download latest
This plugin enables users to connect to a MariaDB, select a specific table, and identify the spatial data columns for longitude (x) and latitude (y). Users can then export the data as Shapefiles or GeoPackages. The records with no longitude (x) and latitude (y) will show in QGIS as comma-separated values (CSV), which are stored in the specified directory, or table which is stored in the GeoPackage. The plugin streamlines the process of transferring spatial data from a selected MariaDB table into QGIS for enhanced analysis and visualization. With support for multiple data formats, it facilitates seamless integration of database information into QGIS projects. The default coordinate system in this plugin is EPSG:4326.
Ensure you have the python mariadb, sqlalchemy, pandas and geopandas module installed! On windows this can be installed using the OSGeo4W Shell. The plugin may give an error message if this is not installed.
