LEFT JOIN
The order of the tables matters in a `LEFT JOIN`, because the table immediately after `FROM` is always the table whose rows are preserved
My Notes
Resume Ivan Arias
Former petroleum geologist retraining as a full-stack GIS developer — condensed one-page CV.
GIS Fundamentals — A Pre-Course Primer for QGIS
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 ...
SQL Joins Explained INNER, LEFT, RIGHT, and FULL JOIN
A practical explanation of INNER, LEFT, RIGHT, and FULL JOIN using photos and users as a simple example.
GDAL/OGR Guide
Inspecting and Loading the Wildlife Spatial Datasets
PostgreSQL Through SSH
Quick Guide Python → PostgreSQL Through SSH
PPL Routine
Evidence-based Push/Pull/Legs routine prioritizing chest, legs and core.
SQL Data Cleaning for GIS
A Beginner's Guide for GDAL + PostgreSQL/PostGIS + QGIS
PostgreSQL 18 + PostGIS on WSL2, Connected to QGIS: A Zero-to-Working Runbook
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...
Spatial SQL with PostgreSQL and PostGIS
A hands-on walkthrough of storing, querying, and analyzing spatial data directly in a database using PostgreSQL and the PostGIS extension.