Mapping Marine Diversity: using QGIS to visualise and extract biodiversity data
summary
National specimens database (Specify on MySQL) contains about 300,000 jars and ~8,500 species with 140,000+ registered records; Specify stores lat/long as X/Y and caps exports at 20,000. The solution wires the live MySQL source into QGIS + GDAL VRT so layers load live, allow real‑time validation, reprojection (including polar), styling and publication maps. A workflow using QGIS geoprocessing (intersection) can extract points inside polygons and export up‑to‑date subsets successfully.
AI-written summary · about
chapters (8)
- 0:00Introduction and background
- 1:48NIWA invertebrate collection overview
- 3:36Specify database limitations
- 6:02QGIS solution for data access
- 8:11Live data visualization in QGIS
- 10:29Data analysis with QGIS tools
- 12:13Benefits of QGIS implementation
- 13:20Q&A and discussion
related talks
21mCreating a geological database using historic and contemporary information
48mSaving Gaia with jQuery Mobile and GeoDjango
21mActual trees, not b-trees: or how I found PostgreSQL through PostGIS
18mA journey in geospatial timeseries
24mActual trees, not b-trees...
40mGIS capability of PostgreSql using POSTGIS & OSM DATA
19mGeoPackage and the Related Tables Extension
54mGeoDjango