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 Sensing1 problemCartography0 problemsWeb GIS2 problemsData Management3 problemsGIS Architecture3 problems
Level
Beginner0 problemsIntermediate0 problemsAdvanced1 problemExpert0 problems
Hand in
SQL0 problemsPython0 problemsGeoJSON0 problemsAnswers0 problemsSchema1 problemDecisions0 problemsDataset file0 problems
Category
Data preparation0 problemsData quality1 problemSpatial analysis1 problemRaster analysis0 problemsCartography0 problemsDecision support1 problemGeospatial systems1 problemWeb delivery1 problem
Sign in to track progress
PostGIS / SQLAdvancedGeospatial systemsClear all
  1. Not started, Model event and airfield condition checksGeospatial systemsSchema

    Design a PostGIS schema that keeps earthquake events, airfields and repeated condition checks traceable.

    Data ManagementadvancedDifficulty: advanced520 XP~85 min12 checks

    You hand in a database schema (DDL).

    What you’ll do

    • Model stable event and airfield identities with timestamped condition observations
    • Declare point type and WGS 84 SRID at the database boundary
    • Build spatial and chronological indexes that support the response dashboard
    projectPostGISschemadata engineeringemergency responseAlso trains PostGIS / SQL, GIS Architecture
    Open problem