Cameron Poolecpoole.dev
/capabilities

Capabilities & Technical Stack

A structured overview of technical architecture principles, core engineering pillars, and production tools applied across spatial data engineering, desktop automation, and web platforms.

Core Engineering Pillars

01 — 03
01. Spatial & Data Engineering

FOSS Geospatial Architecture & Earth Observation Pipelines

Designing spatial data infrastructure built on open standards and cloud-native formats, avoiding vendor lock-in while ensuring long-term auditability, reproducibility, and high-performance raster/vector processing.

Cloud-Native Formats

Standardising on Cloud-Optimised GeoTIFFs (COGs), PMTiles, and GeoParquet. Enables serverless streaming directly from cloud storage (AWS S3) via HTTP range requests without requiring expensive GIS server middleware.

Open-Source Library Foundation

Direct use of GDAL/OGR, PROJ, GEOS, and PostGIS. Algorithms remain auditable down to the source code, eliminating breaking changes forced by proprietary vendor deprecation cycles.

Auditable Data Provenance

Generating cryptographic checksums (SHA-256) and structured metadata for every intermediate processing layer, ensuring all delivered spatial layers can be reliably traced back to raw source inputs.

Open Data Engineering & Stewardship

Sourcing, validating, and conflating multi-source open vectors (OpenStreetMap, Overture Maps, and government portals). Enforcing schema normalisation, identifying machine-learning false positives, and contributing corrections back upstream to the community.

Primary Stack
  • Python
  • GDAL / OGR
  • PostGIS
  • Rasterio
  • xarray
  • Sentinel-1/2
  • NASA GEDI
  • OpenStreetMap
  • Overture Maps
  • COGs
  • GeoParquet
  • QGIS
02. Software Systems & Automation

Software Systems Architecture & CAD/BIM Automation (.NET 8 / C#)

Developing engineering desktop software and custom automations, pairing modern .NET runtimes with decoupled calculation engines, test-driven validation, and deterministic Windows installer packaging.

Decoupled Vector Math & Calculation Engines

Isolating structural setout, member spacing, and reference plane vector calculations from host application SDKs, enabling fast, isolated unit test execution with NUnit outside of host CAD/BIM processes.

Multi-Version SDK Integration

Architecting solutions with shared codebases linked across version-specific targets (such as Revit 2025/2026 under .NET 8), ensuring clean migration across host runtime upgrades and API shifts.

Deterministic Windows Packaging

Building signed, deterministic Windows installers (.msi) via WiX Toolset v5 and WiX heat harvesting, ensuring enterprise-grade workstation deployment without manual file manipulation.

Primary Stack
  • C# / .NET 8
  • Autodesk Revit API
  • WPF / MVVM
  • SQLite
  • WiX Toolset v5
  • NUnit
  • Moq
  • PyInstaller
03. Web Applications & Platforms

Full-Stack Web Applications, Analytical Platforms & High-Performance Websites

Architecting full-stack web applications, analytical platforms, APIs, and high-performance static websites built around maintainable frontend and backend architectures.

Decoupled Multi-Tier Architecture

Separating interactive frontend clients from backend data services. Integrating React, Preact, and Astro user interfaces with containerised Python application services (Django, FastAPI) and relational/spatial datastores.

Spatial REST APIs & Analytical Querying

Designing structured RESTful APIs and PostGIS analytical queries to power interactive data platforms, demographic catchment analysis, and automated export workflows.

Static Performance & Scoped Hydration

Delivering content-focused platforms with zero client-side JavaScript by default using Astro and Jamstack architectures, hydrating interactive islands (Preact, MapLibre GL) only when visible.

Primary Stack
  • React
  • Preact
  • Astro
  • TypeScript
  • Tailwind CSS
  • Django
  • FastAPI
  • PostgreSQL / PostGIS
  • REST APIs
  • MapLibre GL

Capability & Architecture Evidence Matrix

Concrete Implementations

Framework and infrastructure claims substantiated by production implementations. This portfolio maintains a strict distinction between web libraries and runtimes (such as React in dedicated web applications versus Preact in selectively hydrated static islands).

CapabilityCanonical Reference
Python / GDAL / Raster & Vector AnalysisTasmania Wildfire Index — Statewide Data Engineering

Led statewide input preparation, large-scale analysis and delivery QA for Geoneon’s published 2026 Index, covering 450,356 assessed building footprints across 29 LGAs.

DjangoSpatial Data & Document Portal — YMAC

Internal spatial portal managing 12+ years of historical Native Title and legal tenure records with RBAC.

FastAPIInternal Geospatial Microservices & Querying APIs

High-throughput microservices querying raster datasets and vector features across Mammoth and consulting projects.

FlaskMarket Analytics Web Application — Seer Analytics

Original PMA application built entirely in Flask, supporting interactive market-area and facility catchment analysis.

SQLAlchemyMarket Analytics Web Application — Seer Analytics

Relational data access in the Seer Analytics project, recorded alongside Flask and PostGIS in Mammoth’s published stack.

GeoServerMarket Analytics Web Application — Seer Analytics

Spatial data services in Mammoth’s published PMA project stack.

Preactcpoole.dev Interactive MapLibre Islands

Lightweight client islands for interactive career cartography, selectively hydrated without full React bundle overhead.

Astrocpoole.dev & GRIP Sport Australia

Zero-JS static generation by default, content collections with Zod schema validation, and edge deployment.

PostgreSQL / PostGISMarket Analytics Web Application — Seer Analytics

Relational and spatial data supporting PMA market-area, facility catchment, and demographic analysis.

REST APIsGLA Datastore & Mammoth Systems

Production API design for open municipal data publishing and spatial layer discovery.

MapLibre GLcpoole.dev Interactive Work Map & Web GIS Interfaces

Interactive vector tile rendering, custom GeoJSON point clustering, keyboard accessibility, and fallback states.

Agentic EngineeringAgentic Software Systems & LLM Governance

Specification-driven agent workflows, AGENTS.md repository governance, and deterministic test harnesses across spatial and web deliverables.

Open Data & StewardshipOpen Data Engineering, OSM & Building Footprint QA

Conflating Overture and Microsoft ML footprints with OpenStreetMap and municipal cadastres; active OSM mapping and validation.

Production Toolset & Libraries

Specialised Technologies
Earth Observation & Providers

Commercial Providers & Earth Observation Ingestion

Programmatic acquisition, cloud STAC cataloguing, and pre-processing across commercial high-resolution constellations and public space agency archives.

Maxar / Vantor

Sub-30cm commercial optical & multispectral tasking

Ingesting high-resolution WorldView-2/3 and WorldView Legion imagery down to 30cm panchromatic, 8-band VNIR, and 8-band SWIR for fine-grained vegetation stress and canopy mapping.

UP42 Platform & Python SDK

Aggregated commercial marketplace & STAC orchestration

Programmatic search, tasking, ordering, and cloud pre-processing across commercial constellations (Maxar, Airbus, Planet) connecting STAC metadata directly into Python ETL pipelines.

NASA Earthdata & EMIT

Open imaging spectroscopy & spaceborne LiDAR

Automated data harvesting via CMR and STAC APIs for Landsat 8/9, GEDI spaceborne LiDAR canopy metrics, and EMIT 285-band hyperspectral cubes.

ESA Copernicus (CDSE)

European open Earth observation data hub

Automating scene harvesting and processing across Sentinel-1 (SAR) and Sentinel-2 (multispectral) via the Copernicus Data Space Ecosystem API with QA cloud masking.

Open Spatial Ecosystems & Stewardship

Open Spatial Ecosystems, Open Data Portals & Community Stewardship

Ingestion, validation, schema conflation, and upstream community contribution across open geospatial ecosystems and public sector data portals.

OpenStreetMap (OSM) & HOTOSM

Community-driven vector data & humanitarian mapping

Active contributor (CPoole, 150+ changesets) executing field/aerial validation, geometry hygiene, and feature reclassification to correct machine-learning false positives upstream.

Overture Maps Foundation

Global open map data & GeoParquet distribution

Sourcing and partitioning multi-gigabyte building and transportation themes via GeoParquet, evaluating ML footprint extraction artefacts, and conflating against authoritative municipal layers.

Government Open Data Portals

Public-sector cadastre & municipal infrastructure publishing

Ingesting state spatial cadastres (e.g., LIST Tasmania) and publishing verified municipal data feeds directly to the London Datastore for public policy and civic web platforms.

STAC & Cloud-Native Catalogues

SpatioTemporal Asset Catalogs for reproducible ingestion

Querying and indexing cloud-native spatial assets across Earth observation archives (Copernicus, Landsat, NASA Earthdata) with deterministic metadata manifests and SHA-256 provenance tracking.

Raster & Remote Sensing

Raster Processing & Terrain Modelling

Handling multi-gigabyte digital elevation models, satellite multi-spectral bands, and terrain matrices within strict memory bounds.

GDAL / OGR

Format translation, warping, and VRT building

Used for reprojection between Australian Geodetic Datums (GDA94 to GDA2020), virtual raster (VRT) composition across LiDAR tiles, and high-performance clipping.

Rasterio

Idiomatic Python raster manipulation & windowed reads

Block-by-block processing of high-resolution digital surface models, keeping memory usage bounded during nationwide array calculations.

Cloud-Optimised GeoTIFFs (COG)

Standardised cloud-native raster storage

Internally tiled rasters with embedded overviews, allowing web applications to stream raw raster windows via HTTP range requests without dedicated server software.

xarray & rioxarray

Multi-dimensional temporal and spatial array analytics

Used for stacking multi-temporal Sentinel-2 vegetation index time series and calculating seasonal anomaly statistics.

Vector & Spatial Databases

Vector Analysis & Spatial Databases

Topological cleaning, spatial indexing, and high-volume relational spatial queries.

PostgreSQL & PostGIS

Production spatial database & topological analytics

Managing cadastral fabrics, municipal building footprints, and topological network graph calculations with GiST spatial indexing and ST_Snap/ST_Split geometry operations.

GeoPandas & Shapely

In-memory geospatial analysis and batch operations

Performing spatial joins, convex hull generation, and coordinate reference system transformations in automated Python pipelines.

QGIS Desktop & Python Plugins

Desktop verification, cartographic QA, and custom plugins

Visual inspection of model outputs, authoring automated PyQGIS processing scripts, and delivering customised municipal styling packages.

Desktop Automation & Systems

Systems Engineering & Desktop Automation

Engineering add-ins, native Windows utilities, and automated installer packaging.

C# / .NET 8

Modern host-process runtime for CAD/BIM automation

Compiling high-performance add-ins using modern language features, asynchronous task execution, and strongly typed domain modelling.

Autodesk Revit API SDK

Programmatic building information modelling (BIM)

Direct element creation, family instance placement, parametric constraint binding, and transactional commit management for structural steel frames.

WPF & MVVM CommunityToolkit

Responsive enterprise desktop interfaces

Two-way data binding, property validation, asynchronous commands, and UI persistence decoupled from business logic.

WiX Toolset v5

Enterprise Windows Installer (.msi) authoring

Automated directory harvesting, registry integration, version upgrade tables, and silent deployment support for enterprise IT rollouts.

Verification & CI/CD

Verification, Testing & DevOps

Ensuring analytical reproducibility, data integrity, and automated pipeline execution.

PyTest & pytest-cov

Automated Python unit testing & code coverage

Testing algorithmic edge cases, coordinate transformations, and data validation rules with parameterised test fixtures.

NUnit & Moq

.NET unit testing and dependency mocking

Executing isolated tests for structural calculation engines and geometry validation without requiring a live CAD/BIM process.

GitHub Actions & GitLab CI

Automated testing, linting, and build verification

Automating type checks (`tsc --noEmit`), Astro verification (`astro check`), unit tests, and production build artefact validation.

Docker & Podman

Containerised GIS execution environments

Standardising GDAL and Python dependencies across development, testing, and production servers to eliminate environment discrepancies.

Agentic Runtimes & LLM Governance

Specification-driven coding agents & repository governance

Applying autonomous coding tools (Codex, Claude, Cursor) through strict AGENTS.md rules, scoped issues, deterministic test fixtures, and mandatory human diff review.