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 Architecture1 problem
Level
Beginner0 problemsIntermediate0 problemsAdvanced1 problemExpert0 problems
Hand in
SQL4 problemsPython1 problemGeoJSON0 problemsAnswers1 problemSchema1 problemDecisions0 problemsDataset file0 problems
Category
Data preparation0 problemsData quality0 problemsSpatial analysis0 problemsRaster analysis0 problemsCartography0 problemsDecision support0 problemsGeospatial systems1 problemWeb delivery0 problems
Sign in to track progress
PostGIS / SQLAdvancedSchemaClear 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