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 Analysis3 problemsPostGIS / SQL1 problemPython2 problemsRemote Sensing0 problemsCartography1 problemWeb GIS0 problemsData Management0 problemsGIS Architecture0 problems
Level
Beginner2 problemsIntermediate1 problemAdvanced1 problemExpert0 problems
Hand in
SQL1 problemPython0 problemsGeoJSON0 problemsAnswers0 problemsSchema0 problemsDecisions0 problemsDataset file0 problems
Category
Data preparation1 problemData quality0 problemsSpatial analysis1 problemRaster analysis0 problemsCartography0 problemsDecision support3 problemsGeospatial systems0 problemsWeb delivery0 problems
Sign in to track progress
PostGIS / SQLIntermediateSpatial analysisClear all
  1. Not started, Which ports are within 25 km of a capital?Spatial analysisSQL

    ST_DWithin on geography: a proximity join in true metres that the index can still answer.

    PostGIS / SQLintermediateDifficulty: intermediate220 XP~35 min5 checks

    You hand in a spatial SQL query.

    Datasets

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

    What you’ll do

    • Write a proximity join with ST_DWithin
    • Measure in metres on SRID 4326 data by casting to geography
    • Keep the predicate in a form the GiST index can serve
    ST_DWithingeographyGiSTproximityglobal
    Open problem