Skip to content
Kharita Challenges

Learning paths

Each path is an ordered sequence with a stated outcome — something you will be able to do, not a topic you will have covered.

Track
Spatial Analysis3 pathsPostGIS / SQL1 pathPython1 pathRemote Sensing1 pathCartography2 pathsData Management2 paths

3 of 10 paths

  1. Coverage, from a live feed to a policy number

    Spatial Analysis

    Take a live point feed and an administrative boundary layer and produce a defensible coverage report against a policy target: supply per area, walk-distance coverage per unit, the projection choices that make those numbers true, the indexed query that keeps the app responsive, and the tile budget that takes the map offline.

    One transport authority's question — is the cycle-hire scheme where people are? — worked from a live docking-station feed to a coverage figure a minister can quote, with the projection mistakes met on the way.

    6 steps · ~3 h · 1,110 XP

    Begins with Which boroughs is the cycle-hire scheme actually in?

    Start: Which boroughs is the cycle-hire scheme actually in?
    Show the 6 steps
    1. Which boroughs is the cycle-hire scheme actually in?beginnerDifficulty: beginner~25 min
    2. Docks and bikes per borough, in one querybeginnerDifficulty: beginner~25 min
    3. How much of Inner London is a five-minute walk from a dock?intermediateDifficulty: intermediate~45 min
    4. The buffer that shrank on the way to the mapintermediateDifficulty: intermediate~30 min
    5. Redirect the rider at an empty dockintermediateDifficulty: intermediate~40 min
    6. How many tiles does an offline London need?beginnerDifficulty: beginner~25 min

  2. From spatial evidence to response

    Spatial Analysis

    Build an auditable response briefing from heterogeneous GIS evidence: reject unsuitable inputs, produce a map of what the data actually measures, retrieve candidate facilities with indexed spatial SQL, retain condition history in PostGIS and explain which access decisions still need direct verification.

    A multi-technology response workflow: validate a raster, measure hazard context, screen global event data, query nearby facilities and design a database that keeps condition checks traceable.

    7 steps · ~7.5 h · 2,590 XP

    Begins with Accept the rasters, or send them back

    Start: Accept the rasters, or send them back
    Show the 7 steps
    1. Accept the rasters, or send them backintermediateDifficulty: intermediate~35 min
    2. How much of each borough lies below ten metres?intermediateDifficulty: intermediate~40 min
    3. Build the global seismic reconnaissance watchlistintermediateDifficulty: intermediate~40 min
    4. Which airfields should the response desk check?intermediateDifficulty: intermediate~45 min
    5. Model event and airfield condition checksadvancedDifficulty: advanced~85 min
    6. Build an earthquake contact reconnaissance queueadvancedDifficulty: advanced~95 min
    7. Screen capital access exceptionsadvancedDifficulty: advanced~100 min

  3. Operations analytics on a live feed

    Spatial Analysis

    Turn a live point feed into operational figures and a plan: per-area supply and utilisation in SQL and in a script, walk-distance coverage against a target, an indexed nearest-available query, and a nightly rebalancing plan sized from the data.

    One live transport feed worked end to end — supply, aggregates, utilisation, coverage, nearest-available and a rebalancing plan — the way an operations analyst does it every day.

    6 steps · ~4.5 h · 1,560 XP

    Begins with Which boroughs is the cycle-hire scheme actually in?

    Start: Which boroughs is the cycle-hire scheme actually in?
    Show the 6 steps
    1. Which boroughs is the cycle-hire scheme actually in?beginnerDifficulty: beginner~25 min
    2. Docks and bikes per borough, in one querybeginnerDifficulty: beginner~25 min
    3. Where are the bikes, as a share of the docks?intermediateDifficulty: intermediate~35 min
    4. How much of Inner London is a five-minute walk from a dock?intermediateDifficulty: intermediate~45 min
    5. Redirect the rider at an empty dockintermediateDifficulty: intermediate~40 min
    6. Plan a cycle redistribution shiftadvancedDifficulty: advanced~100 min