Problems
Real geospatial problems, graded automatically. Choose a track, a level and what you want to hand in.
- Not started, Can the cycle parking feed report real capacity?Data preparationSQLData ManagementbeginnerDifficulty: beginner130 XP~25 min7 checksData ManagementbeginnerDifficulty: beginner
Clean a Berlin cycle parking staging table for an operations map and capacity rollup.
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 / SQLOpen problem - Not started, Make the pharmacy handover loadableData preparationPythonData ManagementbeginnerDifficulty: beginner125 XP~25 min6 checksData ManagementbeginnerDifficulty: beginner
Repair a field table so a Paris health directory can map its pharmacy locations reliably.
You hand in a Python script.
Dataset
- Raw Paris pharmacy handover · Table · 21 rows · EPSG:4326
What you’ll do
- Parse and validate coordinates before constructing point geometry.
- Preserve the first source record for each reference.
- Deliver a typed, spatially plausible point layer.
data-preparationcoordinatesquality-controlparisAlso trains PythonOpen problem - Not started, Package one playground location per source featureData preparationDataset fileData ManagementbeginnerDifficulty: beginner130 XP~30 min6 checksData ManagementbeginnerDifficulty: beginner
Turn mixed playground points and areas into a projected GeoPackage site directory.
You hand in a prepared dataset file.
Dataset
- Sydney playground mixed-geometry source · Point · 8 features · EPSG:4326
What you’ll do
- Convert mixed source geometry into a consistent site layer.
- Reproject coordinates to the receiving metric CRS.
- Package exact schema and layer name in GeoPackage.
data-preparationsydneyfileAlso trains Spatial AnalysisOpen problem