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 Analysis1 problemPostGIS / SQL1 problemPython1 problemRemote Sensing0 problemsCartography0 problemsWeb GIS0 problemsData Management3 problemsGIS Architecture0 problems
Level
Beginner1 problemIntermediate1 problemAdvanced0 problemsExpert0 problems
Hand in
SQL1 problemPython0 problemsGeoJSON0 problemsAnswers0 problemsSchema0 problemsDecisions0 problemsDataset file0 problems
Category
Data preparation1 problemData quality0 problemsSpatial analysis2 problemsRaster analysis0 problemsCartography0 problemsDecision support0 problemsGeospatial systems0 problemsWeb delivery0 problems
Sign in to track progress
PostGIS / SQLBeginnerData preparationClear 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