Skip to content
View petersolan's full-sized avatar
🗺️
Job Hunting
🗺️
Job Hunting
1 follower · 2 following

Block or report petersolan

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
petersolan/README.md

Hi, I'm Peter: geospatial data engineer in London, UK

I build data pipelines that turn open geospatial and demographic data into reliable, documented datasets and maps: from LiDAR and Sentinel-2 to census, postcode and network data, on Databricks, Azure and PostGIS. Open to geospatial data engineering roles.

Portfolio: petersolan.github.io · LinkedIn: linkedin.com/in/petersolan

Project What it shows Links
Demographic & Geospatial Pipelines on Databricks Medallion pipeline (PySpark, Delta, Unity Catalog, Asset Bundles): NHS/ONS postcode and boundary joins with native spatial SQL, versioned lookups, reconciliation, pseudonymisation and disclosure control; incremental monthly updates (Auto Loader + MERGE into an effective-dated history); calibrated against real NHS England registrations; AI/BI dashboard with a map, deployed as code Live demo · Code
GB Census Population Map Census population shared out to 41.6M address points across Great Britain, 10 m population grid, cloud-optimised GeoTIFF on an interactive map Live demo · Code
Green Space Indicators for Devon Geospatial lakehouse on Azure (ADLS Gen2, Delta Lake), Sentinel-2 greenness, ISO 19115 / DCAT-AP / SDMX metadata Live demo · Code
Fibre Planning Pipeline Kedro pipeline into PostGIS with Alembic, FastAPI, GeoServer and a QGIS plugin: which premises lack gigabit broadband and which roads reach them Live demo · Code
LiDAR Building Footprints Building footprints and heights from Environment Agency LiDAR for Exeter, validated against OS, Microsoft and OpenStreetMap Live demo · Code
Exeter Signal Atlas Ofcom 4G/5G drive-test data on a 100 m OS grid as an interactive 3D MapLibre map Live demo · Code

Tools I use: Python · SQL · PostGIS · DuckDB · Databricks · PySpark · Delta Lake · Azure · Kedro · FastAPI · GeoServer · QGIS / PyQGIS · GeoPandas · Xarray · MapLibre · GeoLibre · Docker · GitHub Actions

Pinned Loading

  1. GB-Demographic-Geospatial-Databricks GB-Demographic-Geospatial-Databricks Public

    Databricks pipelines joining demographic records to GB geographic reference data: NHSPD, ODS, LSOA/ICB boundaries, Census 2021; spatial joins, versioning, reconciliation, pseudonymisation, disclosu…

    Python

  2. GB-Green-Space-Indicators GB-Green-Space-Indicators Public

    Green space access and greenness indicators for Devon: geospatial lakehouse on Azure, published with SDMX, ISO 19115 and DCAT-AP

    Python

  3. GB-Census-Population-Map GB-Census-Population-Map Public

    Census 2021/2022 population shared out to every address in Great Britain (ONSUD UPRNs + OS Open Zoomstack), with 10 m population rasters and an interactive GeoLibre map

    Python

  4. GB-Fibre-Planning-Pipeline GB-Fibre-Planning-Pipeline Public

    Fibre broadband planning pipeline: Ofcom coverage + census population per address + OS Open Roads -> ranked build priorities. Kedro, PostGIS, Alembic, FastAPI, GeoServer, QGIS plugin, CI

    Python

  5. LiDAR-Building-Footprints LiDAR-Building-Footprints Public

    Building footprints and heights from EA LiDAR for Exeter, validated against OS, Microsoft, OSM and OS Open

    Python

  6. Mobile-Signal-Strength Mobile-Signal-Strength Public

    Measured 4G/5G signal strength on Exeter's roads from Ofcom drive-test open data, as an interactive MapLibre 3D map

    HTML