This guide covers the concepts you need before starting the QGIS course: the spatial data model, storage formats, and coordinate reference systems (CRS). CRS and projections are the main source of ...

A Beginner's Guide for GDAL + PostgreSQL/PostGIS + QGIS

A complete, reproducible runbook: install PostgreSQL 18 and PostGIS inside WSL2 Ubuntu, configure it for network access, and connect QGIS running on Windows. Each step includes the reasoning behind...

A hands-on walkthrough of storing, querying, and analyzing spatial data directly in a database using PostgreSQL and the PostGIS extension.

A condensed reference for the core concepts behind spatial databases — terminology, benefits, storage internals, connections, hosting, and SQL basics.

🪨 Geologist with 14+ years in subsurface work | Applying ArcGIS/QGIS, Python, and spatial data to geo-data and GIS-adjacent roles

A practical guide to QGIS expressions — filtering, labeling, styling, field calculation, and selection — with copy-ready examples.

Four methods to count the total number of airports and summarize them by country in QGIS.

Learn how the QGIS `regexp_match()` function works, how to interpret its return value, and how to use it to filter features with practical examples.

Where regex works in QGIS, the four expression functions, and worked examples for cleaning, extracting, selecting, and labeling.