Spatial SQL — Associate

Six problems on real tables — an aggregate that keeps its empty rows, a proximity join in metres, a nearest-neighbour the index can answer, a containment audit, an overlay measured on geography, and an identifier audit — so that a pass means the holder writes spatial SQL that is correct and stays fast.

90 minutesPass at 70/100

Sections

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

Spatial joins and aggregates
PostGIS / SQL3 problems
40%
Nearest, containment and overlay
PostGIS / SQL2 problems
40%
Data before the query
Data Management1 problem
20%

Conditions

Sit it alone. Documentation is allowed; AI assistants and help from anyone else are not.
Any database client may be used; the query is graded, not the tool.
The PostGIS reference documentation 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 Spatial SQL (Associate)

Attests that the holder can write spatial SQL against real tables that is correct — outer joins that keep the rows a report is about, NULL-safe comparisons, distances in metres on geography — and that stays fast, using the predicates and the LATERAL forms a GiST index can answer.

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