Skip to content
Kharita Challenges

Problems

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

1 of 59 problems

Pick one for me
Track
Spatial Analysis0 problemsPostGIS / SQL1 problemPython0 problemsRemote Sensing0 problemsCartography0 problemsWeb GIS0 problemsData Management1 problemGIS Architecture0 problems
Level
Beginner3 problemsIntermediate1 problemAdvanced3 problemsExpert0 problems
Hand in
SQL1 problemPython0 problemsGeoJSON0 problemsAnswers0 problemsSchema0 problemsDecisions0 problemsDataset file0 problems
Category
Data preparation1 problemData quality4 problemsSpatial analysis0 problemsRaster analysis0 problemsCartography0 problemsDecision support4 problemsGeospatial systems0 problemsWeb delivery0 problems
Sign in to track progress
Data ManagementIntermediateData preparationClear 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