Plugin icon

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.

Version QGIS >= QGIS <= Date
1.0.3 - 3.0.0 3.99.0 851 rubiere 2024-08-27T15:49:06.840729+00:00
1.0.2 - 3.0.0 3.99.0 89 rubiere 2024-08-23T21:12:43.561041+00:00
1.0.1 - 3.0.0 3.99.0 250 rubiere 2024-08-05T15:16:13.007157+00:00
1.0.0 - 3.0.0 3.99.0 270 rubiere 2024-07-30T22:49:20.084575+00:00

QGIS sustaining members

Flagship membership


Flagship membership


Large membership


Large membership


Large membership


Large membership


Large membership


Large membership


Large membership


Large membership