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
Beginner0 problemsIntermediate0 problemsAdvanced1 problemExpert0 problems
Hand in
SQL1 problemPython0 problemsGeoJSON1 problemAnswers0 problemsSchema0 problemsDecisions0 problemsDataset file0 problems
Category
Data preparation0 problemsData quality1 problemSpatial analysis1 problemRaster analysis0 problemsCartography0 problemsDecision support3 problemsGeospatial systems0 problemsWeb delivery1 problem
Sign in to track progress
AdvancedData qualitySQLClear all
  1. Not started, Are these country polygons fit to assign cities to?Data qualitySQL

    A point-in-polygon audit that exposes what 1:50m generalisation does to a coastline — and which places the attribute and the geometry disagree about.

    PostGIS / SQLadvancedDifficulty: advanced300 XP~45 min5 checks

    You hand in a spatial SQL query.

    Datasets

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

    What you’ll do

    • Join points to the polygon containing them with an outer join
    • Compare an attribute to a derived value with NULL-safe semantics
    • Return the disagreement list, including the points nothing contains
    ST_Containsouter joinIS DISTINCT FROMgeneralisationdata qualityAlso trains Data Management
    Open problem