Skip to content
Josué Dikoma©

Case study — 2026

Registre d'actifs terrain.

Equipment inventory for a health organisation deployed nationwide, modelled on the real health hierarchy: from province down to the individual facility.

Client

Organisation de santé publique (RDC)

Role

Design & full-stack development

Duration

In production

Year

2026

R
Registre d'actifs terrain2026
Django 6PostgreSQLopenpyxldjango-anymailDockeri18n FR/EN

6

levels of geographic hierarchy

FR / EN

bilingual interface

Excel

exports generated natively

01 — The problem

Tracking equipment spread across a territory the size of the DRC means knowing not only *what*, but *where* — and "where" is not an address. It is a position in a health hierarchy: province, territory, health zone, health area, facility.

A conventional inventory with a free-text location field makes any aggregation by zone or by mission impossible, and falls apart as soon as equipment moves between operators and missions.

02 — The solution

I modelled the Congolese health hierarchy directly in the data schema: province, territory or city, site, health zone, health area and facility are linked entities, not strings.

Each asset carries a code generated from a category-specific prefix, and is tied to a mission, an operator and a responsible staff member. Lots track grouped acquisitions, and access control restricts visibility by scope.

The interface is bilingual French/English, Excel exports are produced with openpyxl, and email notifications go through a transactional service.

03 — The results

The inventory becomes queryable at any level: it can be aggregated by province, health zone, mission or operator with no post-processing.

That is the direct consequence of modelling health geography rather than storing it as free text — a choice that costs a few extra tables up front and avoids a full rewrite at the first reporting request.

Next step

A project in mind?

Let's talk about it over a free 30-minute call — no strings attached.