2026-08-30 –, 603
This workshop is aimed at helping experienced QGIS users discover PostGIS. You’ll become familiar with using database connections, tables & views, relational modeling, spatial SQL, and dynamic views to build smarter, faster, and more scalable GIS workflows directly within the familiar QGIS interface.
We will bridge the gap between traditional desktop GIS and enterprise data management by turning your PostGIS database into the engine of your QGIS projects. The session skips the basic "how to add a layer" and dives straight into the features that matter for optimised workflows.
Some topics we’ll cover:
- Create and edit tables directly from the QGIS interface
- Write views, "magic layers" that join multiple tables, spatially transform/analyse/aggregate your raw data, and automatically update from upstream tables
- Store projects and styles directly in the database for a seamless experience
- Relational tables: setting up 1:N and M:N relationships at the database level and using them in QGIS
- Data integrity and validation: use constraints and schemas to keep your data valid, clean, and organized
This is an introductory PostGIS workshop for users looking for a learning journey from a QGIS perspective. We’ll use the DB Manager and Browser to interact with SQL, ensuring that the database feels like a natural extension of your existing workspace rather than an intimidating command-line tool. Participants will leave with a solid idea for building optimised high-performance GIS environments.
Required: QGIS installed prior to workshop.
No need to install PostGIS/PostgreSQL, we'll use an online instance. We will get in touch in advance to provide you with database credentials.
What skills do participants require to have?:Ideally, participants will be at least generally familiar with the QGIS interface.
PhD student in Applied Geomatics at the Department of Civil and Environmental Engineering of Politecnico di Milano (Italy). Her main research interest is 2D and 3D data integration in web-based geospatial environments to support decision making for built and natural environment applications.
Passionate OpenStreetMap contributor since 2016 with her group PoliMappers and OSGeo Charter Member since 2022, with activities focused on education and capacity building for the Italian student community.
I'm a consultant for Mammoth Geospatial, based in Fremantle, Australia, where I love to help organisations with QGIS, PostGIS, Mergin/QField, and web mapping. I'm a keen organiser of community groups like Geogeeks and QGIS Australia.