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
SQL6 problemsPython5 problemsGeoJSON8 problemsAnswers8 problemsSchema1 problemDecisions2 problemsDataset file4 problems
Category
Data preparation0 problemsData quality0 problemsSpatial analysis0 problemsRaster analysis0 problemsCartography0 problemsDecision support0 problemsGeospatial systems1 problemWeb delivery0 problems
Sign in to track progress
AdvancedSchemaClear 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