Problems

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

Find a learning path

Data Management SQL Clear all

Not started, Can the cycle parking feed report real capacity?Data preparationSQL
Clean a Berlin cycle parking staging table for an operations map and capacity rollup.
Data ManagementbeginnerDifficulty: beginner130 XP~25 min7 checksData ManagementbeginnerDifficulty: beginner13025m7
You hand in a spatial SQL query.
Dataset
Berlin bicycle parking capacity staging · Point · 27 features · EPSG:4326
What you’ll do
Resolve source precedence before casting.
Keep unknown capacity distinct from zero.
Return geometry for the operational map.
data-preparationberlinsqlAlso trains PostGIS / SQL
Open problem
Not started, Protect the bus stop key during the loadData preparationSQL
Recover zero-padded stop identifiers before a transport timetable join.
Data ManagementintermediateDifficulty: intermediate210 XP~40 min7 checksData ManagementintermediateDifficulty: intermediate21040m7
You hand in a spatial SQL query.
Dataset
Singapore bus stop code staging · Point · 31 features · EPSG:4326
What you’ll do
Preserve identifier semantics through SQL casting.
Resolve repeated source rows deterministically.
Return a clean point layer for the timetable join.
data-preparationsingaporesqlAlso trains PostGIS / SQL
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, Are these country polygons fit to assign cities to?Data qualitySQL
A point-in-polygon audit that exposes what 1:50m generalisation does to a coastline — and which places the attribute and the geometry disagree about.
PostGIS / SQLadvancedDifficulty: advanced300 XP~45 min5 checksPostGIS / SQLadvancedDifficulty: advanced30045m5
You hand in a spatial SQL query.
Datasets
Populated places · Point · 1,251 features · EPSG:4326
Countries · MultiPolygon · 241 features · EPSG:4326
What you’ll do
Join points to the polygon containing them with an outer join
Compare an attribute to a derived value with NULL-safe semantics
Return the disagreement list, including the points nothing contains
ST_Containsouter joinIS DISTINCT FROMgeneralisationdata qualityAlso trains Data Management
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, 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