Open-Data Analyst — Associate

Six graded problems on real open data — a proximity join in metres, a per-area aggregate, a geodesic nearest-neighbour, a normalised choropleth, a scripted overlay and a data audit — so that a pass means the holder can turn a public dataset into a defensible number without a projection or a join silently going wrong.

90 minutesPass at 70/100

Sections

Weighted toward the skills the credential claims. The problems appear when the clock starts.

Spatial SQL
PostGIS / SQL2 problems
30%
Spatial analysis and cartography
Spatial Analysis2 problems
40%
Scripted analysis and data quality
Python2 problems
30%

Conditions

Sit it alone. Documentation is allowed; AI assistants and help from anyone else are not.
Any desktop GIS, notebook or database client may be used; the answer is graded, not the tool.
Documentation for PostGIS, GeoPandas and pyproj may be consulted. Do not consult other people during the sitting.
Each problem is submitted once; Run is unlimited and never graded.
Ninety minutes on one clock for all six problems; unanswered problems score zero.

On passing

Kharita Certified Open-Data Analyst (Associate)

Attests that the holder can take public geospatial data — a transport feed, a national boundary layer, a global registry — and produce a correct, reproducible figure from it: joins in true metres, rates instead of counts, empty rows kept, identifiers audited before they are trusted.

Valid for: 36 months
Level: associate
Verification: Public page