Geospatial Automation & Spatial Database Developer
A QGIS-first automation pathway: Python, PyQGIS, Google Earth Engine, PostGIS and AI-assisted automation.
GIS capability model / 03
GIS development
Capability gained
Automate repeatable geospatial workflows.
Programme snapshot
Start with the essentials.
Everything you need to decide whether this is the right course to begin with.
- Entry level
- Level 1 + verified Level 2 competence
- Primary software
- QGIS + Python
- On demand
- Esri bundle (E1–E3) as an optional add-on
- Prerequisite
- Level 1 competence; eligible prior learning may exempt the Level 2 stage
The programme
Overview
Stop repeating GIS work. Level 3 teaches you to automate vector, raster, map-production and Earth Observation workflows, and to store and query the results in a spatial database.
The pathway runs from the Level 2 QGIS analysis core into a seven-module automation stage. Level 2 is a shared foundation, not a second copy inside Level 3: learners with approved Level 2 competence enter the automation stage directly.
Core software is QGIS, Python, geospatial libraries, Google Earth Engine (through Python and geemap) and PostgreSQL/PostGIS. The Esri Professional Automation Bundle — ArcGIS Pro, ArcPy and ArcGIS Online — is an optional, separately priced add-on.
Level 3 does not teach HTML/CSS/JavaScript frontend development, Leaflet, GeoServer administration, backend API development, Plotly/Streamlit application development or GeoHarness/agent engineering.
Entry profile
Who can join?
- GIS and Remote Sensing analysts
- GIS professionals
- Researchers
- Engineering and science graduates seeking practical automation and spatial-database skills
Learning domains
Focus areas
Program Focus
- Automate vector, raster, map-production and Earth Observation workflows instead of repeating them by hand.
- Build reliable scripts, QGIS processing workflows and spatial SQL.
- Use AI coding assistants for geospatial automation — with human validation, testing and credential safety.
Technical toolkit
Software & technologies
- 01QGIS
- 02Python
- 03GeoPandas
- 04Rasterio
- 05PyQGIS
- 06Google Earth Engine
- 07geemap
- 08PostgreSQL
- 09PostGIS
- 10VS Code
Practical application
What you will be able to do
- 01Build reusable Python/PyQGIS workflows and automate satellite processing with Earth Engine/geemap.
- 02Design and query spatial databases using PostgreSQL/PostGIS.
- 03Use AI coding assistants with human validation, testing and credential safety.
- 04Complete the Level 3 Automation Capstone: prepare raw spatial data, automate processing with Python/PyQGIS, store or query results in PostGIS, validate the outputs and demonstrate the complete workflow independently.
Where it can lead
Career opportunities
- GIS Automation Associate
- Geospatial Programmer
- Python GIS Associate
- Spatial Database Associate
- GIS Workflow Developer
Who teaches this course
Your trainers
The complete syllabus
Curriculum
Search the syllabus, choose a module, and review its topics without losing your place.
Modules
7
Topics
72
Module 01
Python Programming for Geospatial Automation
- Python environment and VS Code setup01
- Variables and data structures02
- Conditional logic and loops03
- Functions and reusable scripts04
- Modules, packages and virtual environments05
- File handling and geospatial project folders06
- Exception handling and basic logging07
- OOP fundamentals08
- Reading, explaining and testing an automation script09
- Basic version control and project documentation10
Module 02
Vector GIS Programming
- GeoPandas01
- Shapely02
- PyProj03
- Fiona and vector data input/output04
- Geometry operations05
- Spatial joins through code06
- Coordinate transformations07
- Batch vector processing08
- Automated data validation09
- Reusable geoprocessing functions10
Module 03
Raster & Remote-Sensing Automation
- Rasterio01
- NumPy and raster arrays02
- GDAL concepts03
- Windowed processing04
- Raster masking05
- Python reprojection06
- Batch satellite processing07
- Automated spectral-index generation08
- Raster statistics09
- Large-raster workflow considerations10
Module 04
QGIS Processing & PyQGIS Automation
- QGIS Python console and PyQGIS fundamentals01
- QGIS Processing framework02
- Loading and managing layers through code03
- Attribute and geometry operations04
- Calling processing algorithms05
- Batch processing and chained workflows06
- Automated validation of GIS outputs07
- Map and layout automation08
- Automated exports09
- Reusable QGIS processing workflows10
Module 05
Google Earth Engine Automation
- Earth Engine Python API and geemap01
- Image, ImageCollection and FeatureCollection02
- Client-side and server-side concepts03
- Mapping and reducers04
- Cloud masking05
- Temporal composites06
- Time-series processing07
- Large-area Earth Observation processing08
- Automated satellite workflows09
- Exports, assets and Python integration10
Module 06
PostgreSQL, PostGIS & Spatial SQL
- Relational database architecture01
- PostgreSQL and SQL foundations02
- Spatial database design03
- PostGIS geometry and geography04
- Spatial SQL05
- Spatial indexing06
- Geometry operations and spatial queries07
- Query-optimization fundamentals08
- Multi-user spatial database concepts09
- QGIS, Python and PostGIS integration10
Module 07
AI-Assisted Geospatial Automation
- Using an AI coding assistant in VS Code01
- OpenRouter as a configurable model-access option02
- Writing clear GIS problem statements and acceptance criteria03
- Generating and explaining Python geospatial code04
- Debugging GeoPandas, Rasterio and PyQGIS workflows05
- Drafting and reviewing SQL and PostGIS queries06
- Generating tests and checking actual outputs07
- Comparing model responses against known GIS results08
- Protecting credentials and avoiding unnecessary personal-data uploads09
- Reviewing proposed file changes and commands before execution10
- Recognizing incorrect or invented AI-generated functions11
- Documenting human verification of the final workflow12