Skip to content
Kharita Challenges
All paths
Imperfect source sheets pass through attribute, geometry and coordinate checks into a clean delivery layer.

Prepare geodata for a real handover

From messy source attributes to a validated spatial file that another GIS team can load and trust.

Follows GEOG 204: Introduction to GIS syllabus · University of Northern British Columbia, GEOG 204 Introduction to GIS, 2025 syllabus: GIS data files, text-data processing, coordinate systems, vector analysis and data management.

Data Management

Steps
7
Each assumes the one before it
Time
~5.5 h
At the problems' own estimates
XP
1,930
Before hint costs and speed bonuses
Progress
0/7
Start the pathBegins with Can the cycle parking feed report real capacity?

What you will be able to do

Given mixed open-data extracts and a receiving system's rules, you can clean identifiers and attributes, validate geometry and CRS, and deliver a named, typed GeoPackage whose contents and precision survive review.

Assumed before you start

  • Basic familiarity with GIS layers, attribute tables and point versus polygon geometry.
  • Ability to run a short SQL query, Python script or desktop GIS operation with the provided starter contract.

The sequence

Each step assumes the one before it.

  1. Up nextCan the cycle parking feed report real capacity?Up nextClean a Berlin cycle parking staging table for an operations map and capacity rollup.beginnerDifficulty: beginner130 XP~25 min
  2. 2Protect the bus stop key during the loadRecover zero-padded stop identifiers before a transport timetable join.intermediateDifficulty: intermediate210 XP~40 min
  3. 3Make the pharmacy handover loadableRepair a field table so a Paris health directory can map its pharmacy locations reliably.beginnerDifficulty: beginner125 XP~25 min
  4. 4Package one playground location per source featureTurn mixed playground points and areas into a projected GeoPackage site directory.beginnerDifficulty: beginner130 XP~30 min
  5. 5Repair the park intake without losing its second partRepair an invalid park outline while preserving every valid polygon component.advancedDifficulty: advanced370 XP~55 min
  6. 6Deliver an access-safe public toilet layerClassify access honestly and deliver a typed projected GeoPackage without null locations.advancedDifficulty: advanced365 XP~55 min
  7. 7Deliver a field-ready public asset registerProjectMerge two open asset extracts into a quality-controlled GeoPackage for field inspection.advancedDifficulty: advanced600 XP~105 min

Where it leads

Data Management is examined in the Spatial SQL — Associate, which issues the Kharita Certified Spatial SQL (Associate) (KSQL-A1). The problems here are the practice; the assessment is the same kind of problem, under time.