Problems

Real geospatial problems, graded automatically. Choose a track, a level and what you want to hand in.

Find a learning path

Spatial Analysis SQL Clear all

Not started, Docks and bikes per borough, in one querySpatial analysisSQL
A point-in-polygon join with GROUP BY — and the outer join that keeps the boroughs with nothing to count.
PostGIS / SQLbeginnerDifficulty: beginner150 XP~25 min4 checksPostGIS / SQLbeginnerDifficulty: beginner15025m4
You hand in a spatial SQL query.
Datasets
London boroughs · Polygon · 33 features · EPSG:4326
Santander Cycles docking stations (live snapshot) · Point · 799 features · EPSG:4326
What you’ll do
Join stations to boroughs with a spatial predicate
Aggregate per borough
Keep every borough, including the ones outside the scheme
ST_ContainsGROUP BYouter jointransportLondonAlso trains Spatial Analysis
Open problem
Not started, Where should a waterway survey start?Decision supportSQL
Screen large global urban footprints for mapped river contact while keeping scale limitations explicit.
Spatial AnalysisintermediateDifficulty: intermediate320 XP~50 min9 checksSpatial AnalysisintermediateDifficulty: intermediate32050m9
You hand in a spatial SQL query.
Datasets
Urban areas · Polygon · 2,143 features · EPSG:4326
Rivers and lake centrelines · LineString · 461 features · EPSG:4326
What you’ll do
Apply a spatial join to real river and urban geometry
Keep zero-contact footprints in the inventory
Distinguish map-scale contact classes for survey planning
Natural Earthurban waterPostGISspatial screeningcategorical mapglobalAlso trains PostGIS / SQL, Cartography, Data Management
Open problem
Not started, Which airfields should the response desk check?Decision supportSQL
Use a metre-based spatial join to identify civil airfields near strong, shallow earthquake epicentres, with the facilities drawn on the map.
PostGIS / SQLintermediateDifficulty: intermediate260 XP~45 min6 checksPostGIS / SQLintermediateDifficulty: intermediate26045m6
You hand in a spatial SQL query.
Datasets
Global M5.5+ earthquakes, Jan–Mar 2025 · Point · 86 features · EPSG:4326
World airports · Point · 893 features · EPSG:4326
What you’ll do
Filter events by magnitude and depth
Join the selected events to civil airfields within 250 km in metres
Return traceable, mapped airport points and measured distances
PostGISearthquake responseairportsgeographyglobalAlso trains Spatial Analysis, Cartography
Open problem
Not started, Build an earthquake contact reconnaissance queueProjectDecision support3 steps
Screen strong shallow events, quantify airfield and settlement proximity, and hand over a traceable contact map.
Spatial AnalysisadvancedDifficulty: advanced550 XP~95 min12 checksSpatial AnalysisadvancedDifficulty: advanced55095m12
Worked in 3 steps, each checked before the next one opens.
Select the event queue · SQL
Measure contact gaps · Answers
Hand over the access map · Python
Datasets
Global M5.5+ earthquakes, Jan–Mar 2025 · Point · 86 features · EPSG:4326
World airports · Point · 893 features · EPSG:4326
Populated places · Point · 1,251 features · EPSG:4326
What you’ll do
Select a reproducible event queue in SQL
Measure two independent global proximity indicators
Deliver an auditable access map with an explicit contact-gap distinction
projectUSGSnearest neighbourlogisticsglobalAlso trains Python, Data Management, Cartography
Open project
Not started, Plan a cycle redistribution shiftProjectDecision support3 steps
Classify the dock snapshot, propose bounded bike moves, and size the resulting shift with its unserved stations visible.
Spatial AnalysisadvancedDifficulty: advanced600 XP~100 min11 checksSpatial AnalysisadvancedDifficulty: advanced600100m11
Worked in 3 steps, each checked before the next one opens.
Classify the snapshot · SQL
Map feasible transfers · GeoJSON
Size the preliminary shift · Answers
Dataset
Santander Cycles docking stations (live snapshot) · Point · 799 features · EPSG:4326
What you’ll do
Classify full and empty active stations in SQL
Build a bounded nearest-source transfer map
Size a shift and report unserved empties from the same rules
nearest neighbouroperationscapacityCRStransportLondonAlso trains Data Management, GIS Architecture
Open project
Not started, Urban share of each state, in SQLSpatial analysisSQL
ST_Intersection for the pieces and ST_Area on geography for the metres — the overlay-and-measure pattern inside the database.
PostGIS / SQLadvancedDifficulty: advanced300 XP~45 min5 checksPostGIS / SQLadvancedDifficulty: advanced30045m5
You hand in a spatial SQL query.
Datasets
United States states · Polygon · 51 features · EPSG:4326
Urban areas · Polygon · 2,143 features · EPSG:4326
What you’ll do
Overlay polygons with ST_Intersection
Measure the pieces on geography rather than in degrees
Aggregate per state, keeping the states with nothing
ST_IntersectiongeographyoverlayGROUP BYland useAlso trains Spatial Analysis
Open problem
Not started, Which neighborhoods merit a service follow-up?Decision supportSQL
Join geocoded service requests to neighborhood polygons and map a review share only where the sample supports it.
PostGIS / SQLadvancedDifficulty: advanced390 XP~65 min8 checksPostGIS / SQLadvancedDifficulty: advanced39065m8
You hand in a spatial SQL query.
Datasets
2020 Neighborhood Tabulation Areas · MultiPolygon · 262 features · EPSG:4326
NYC 311 sewer requests, 1–7 June 2025 · Point · 408 features · EPSG:4326
What you’ll do
Join incident locations to neighborhoods with a boundary-inclusive predicate
Compute elapsed-time review share with a clear denominator
Suppress very small denominator areas before mapping percentages
NYC 311PostGISspatial joinservice operationsgraduated mapAlso trains Spatial Analysis, Cartography, Data Management
Open problem