Skip to content
Kharita Challenges

Problems

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

2 of 59 problems

Pick one for me
Track
Spatial Analysis2 problemsPostGIS / SQL5 problemsPython0 problemsRemote Sensing0 problemsCartography2 problemsWeb GIS0 problemsData Management2 problemsGIS Architecture0 problems
Level
Beginner1 problemIntermediate2 problemsAdvanced4 problemsExpert0 problems
Hand in
SQL2 problemsPython3 problemsGeoJSON1 problemAnswers3 problemsSchema0 problemsDecisions0 problemsDataset file0 problems
Category
Data preparation1 problemData quality0 problemsSpatial analysis0 problemsRaster analysis0 problemsCartography0 problemsDecision support1 problemGeospatial systems0 problemsWeb delivery0 problems
Sign in to track progress
Data ManagementIntermediateSQLClear all
  1. 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
  2. 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