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.
A practical learning plan to become a Web GIS Developer with React, FastAPI, PostGIS, Python GIS, and applied AI.
A 4-day Upper/Lower week built around getting stronger at pull-ups and dips, with every muscle trained twice a week.