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
  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
  2. Not started, Which big cities does the gazetteer not know?Data qualityGeoJSON

    Test one layer's completeness against another: large urban footprints with no populated place inside them at all.

    Data ManagementadvancedDifficulty: advanced300 XP~45 min5 checks

    You hand in a GeoJSON result.

    Datasets

    • Urban areas · Polygon · 2,143 features · EPSG:4326
    • Populated places · Point · 1,251 features · EPSG:4326

    What you’ll do

    • Measure footprint area in an equal-area projection and apply a size floor
    • Test each footprint for containment of any point from a second layer
    • Return the uncovered footprints with the area that says how much they matter
    completenessspatial joinequal-areagazetteerglobalAlso trains Spatial Analysis
    Open problem