Skip to content
Kharita Challenges

Problems

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

36 of 59 problems

Pick one for me
Track
Spatial Analysis36 problemsPostGIS / SQL13 problemsPython17 problemsRemote Sensing9 problemsCartography16 problemsWeb GIS8 problemsData Management36 problemsGIS Architecture6 problems
Level
Beginner7 problemsIntermediate9 problemsAdvanced18 problemsExpert2 problems
Hand in
SQL7 problemsPython10 problemsGeoJSON11 problemsAnswers10 problemsSchema1 problemDecisions2 problemsDataset file5 problems
Category
Data preparation7 problemsData quality7 problemsSpatial analysis6 problemsRaster analysis3 problemsCartography1 problemDecision support9 problemsGeospatial systems3 problemsWeb delivery0 problems
Sign in to track progress
Data ManagementClear all
  1. 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 checks

    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
  2. Not started, Make the pharmacy handover loadableData preparationPython

    Repair a field table so a Paris health directory can map its pharmacy locations reliably.

    Data ManagementbeginnerDifficulty: beginner125 XP~25 min6 checks

    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 Python
    Open problem
  3. Not started, Package one playground location per source featureData preparationDataset file

    Turn mixed playground points and areas into a projected GeoPackage site directory.

    Data ManagementbeginnerDifficulty: beginner130 XP~30 min6 checks

    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 Analysis
    Open problem
  4. Not started, What is Greater London made of?Raster analysisAnswers

    A class histogram on a 10 m land-cover raster: the shares a planning document quotes, and the reason a pixel count is not quite an area.

    Remote SensingbeginnerDifficulty: beginner140 XP~25 min5 checks

    You hand in your answers as values.

    Dataset

    • Greater London land cover 2021 (ESA WorldCover 10 m) · Raster · EPSG:4326

    What you’ll do

    • Read a categorical raster and count pixels per class
    • Express classes as shares of the valid pixels
    • State what the number is and is not
    land coverWorldCoverhistogramrasterLondonAlso trains Data Management
    Open problem
  5. Not started, Which airport codes will break the schedule join?Data qualityAnswers

    Audit a registry's identifiers before they become a join key: missing, malformed and duplicated codes, and positions that are only approximate.

    Data ManagementbeginnerDifficulty: beginner130 XP~25 min5 checks

    You hand in your answers as values.

    Dataset

    • World airports · Point · 893 features · EPSG:4326

    What you’ll do

    • Find nulls, duplicates and malformed values in an identifier column
    • Distinguish a key defect from a position defect
    • Report counts the integration can be sized against
    data qualityidentifiersjoin keysaviationAlso trains Python
    Open problem
  6. Not started, Which airports sit inside a city?Spatial analysisGeoJSON

    Point-in-polygon screening: the airports whose point falls inside a built-up footprint, for a noise-exposure programme.

    Spatial AnalysisbeginnerDifficulty: beginner130 XP~20 min5 checks

    You hand in a GeoJSON result.

    Datasets

    • World airports · Point · 893 features · EPSG:4326
    • Urban areas · Polygon · 2,143 features · EPSG:4326

    What you’ll do

    • Test each point for containment in any polygon of a second layer
    • Return the qualifying points once each, with their attributes
    point-in-polygonspatial joinscreeningaviationglobalAlso trains Data Management
    Open problem
  7. Not started, Which boroughs is the cycle-hire scheme actually in?Spatial analysisGeoJSON

    Join 799 docking stations to 33 boroughs and rank them by docks per square kilometre.

    Spatial AnalysisbeginnerDifficulty: beginner130 XP~25 min6 checks

    You hand in a GeoJSON result.

    Datasets

    • London boroughs · Polygon · 33 features · EPSG:4326
    • Santander Cycles docking stations (live snapshot) · Point · 799 features · EPSG:4326

    What you’ll do

    • Spatially join docking stations to the borough that contains them
    • Sum docking points per borough without dropping the boroughs that have none
    • Measure borough area in a metric CRS and compute docks per km²
    spatial joinaggregationCRStransportLondonAlso trains Data Management
    Open problem
  8. Not started, Accept the rasters, or send them backData qualityAnswers

    The checks a data manager runs on delivered rasters before anyone analyses them: extent, nodata, value range, and whether the figures are plausible for the place.

    Data ManagementintermediateDifficulty: intermediate200 XP~35 min6 checks

    You hand in your answers as values.

    Datasets

    • Greater London elevation (Copernicus DEM GLO-30) · Raster · EPSG:4326
    • Greater London land cover 2021 (ESA WorldCover 10 m) · Raster · EPSG:4326
    • Greater London, Sentinel-2 red and NIR, 11 July 2025 · Raster · EPSG:32630

    What you’ll do

    • Read raster metadata and full-resolution statistics
    • Distinguish nodata from valid extremes
    • Record facts a later dispute can start from
    raster QAnodatametadataacceptanceLondonAlso trains Remote Sensing
    Open problem
  9. Not started, Build the global seismic reconnaissance watchlistDecision supportPython

    Turn a fixed USGS event feed into a mapped, reproducible shallow strong-event watchlist for requesting impact products.

    Spatial AnalysisintermediateDifficulty: intermediate240 XP~40 min5 checks

    You hand in a Python script.

    Dataset

    • Global M5.5+ earthquakes, Jan–Mar 2025 · Point · 86 features · EPSG:4326

    What you’ll do

    • Apply two inclusive, unit-aware filters to the frozen event snapshot
    • Carry stable event identifiers and response metadata into a point GeoDataFrame
    • Map event magnitude as a proportional point result without claiming it is impact
    USGSearthquakesGeoPandasemergency screeningglobalAlso trains Python, Data Management, Cartography
    Open problem
  10. 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 checks

    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
  11. Not started, When the attributes and the geometry disagreeData qualityAnswers

    A reference gazetteer carries a latitude and a longitude column beside its geometry. Audit how far apart they are, and what else does not add up.

    Data ManagementintermediateDifficulty: intermediate200 XP~35 min5 checks

    You hand in your answers as values.

    Dataset

    • Populated places · Point · 1,251 features · EPSG:4326

    What you’ll do

    • Compare each feature's geometry to the coordinate attributes it carries
    • Count the disagreements at two thresholds and identify the worst
    • Find keys the downstream spreadsheet cannot distinguish
    data qualitygazetteerhaversineduplicatesglobalAlso trains Python
    Open problem
  12. 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 checks

    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
Show 12 more problems

12 of 36 problems shown