Experience 003 · The Ubuntu Town Operating System · Blueprint is portfolio authority · Supabase is operational truth · nothing fabricated
UTUbuntu Town OS

Geography OS · province

FREE STATE

What is happening in this province? Every number below is derived from child records — nothing is invented at province level.

8 Blueprint roster towns (strategic)13 canonical database rows6 founding-flagged (ratification pending)6 with field intelligence

How this was calculated

COMPUTED
Database rows in province:
13 = count of uto.towns rows where province = "Free State" (live read).
Founding-flagged:
6 = rows where is_founding = true (source: Founding-50 reconciliation migration 20260707002039). Flag ≠ ratified roster.
Field intelligence:
6 = towns with a town pack in the v1 field-intelligence exports.
Operational coverage:
not computed — requires protected deployment/role records (RECORDS NOT ACCESSIBLE).

Regional work pulse — public truth

ZERO (EVIDENCED)

PUBLISHED WORK

0

public truth · RLS-visible

VISIBLE ROWS

0

all statuses the public read exposes

TOWNS ACTIVE

0

of 13 database rows

INITIATIVES VISIBLE

0

distinct initiative values (raw)

How this was calculated: uto.community_work rows, filtered by row-level security to what the public may see (published + public/national visibility), joined to this province through its towns. ZERO VISIBLE is not "no work exists" — private, internal and in-review work is filtered by RLS by design. This is the honest public lower bound.

Towns in this province

People · work · proof · economics

People

RECORDS NOT ACCESSIBLE — role and person records for this province are protected. Leadership coverage is never inferred from town counts.

Work · proof

RECORDS NOT ACCESSIBLE — operational records are protected. PROOF GAP where standards exist without captured evidence.

Economics

NOT YET MEASURED — no economic records accessible at province level. Province economics would be aggregated from child records only.

Risks · opportunities · learning

Insufficient evidence at province level beyond what child towns record (see town pages for field intelligence). Nothing is aggregated without child support.

CHIEF OF STAFF

operating intelligence · Province · Free State

What is happening?

Free State contains 13 of the 81 canonical database rows; 6 carry the founding flag; 6 carry field intelligence.

COMPUTED
Why?

Evidence: uto.towns (live read) · field-intelligence packs

Reasoning: Counts derived from child records only.

Limitation: Database rows ≠ Blueprint cohort membership. Operational coverage is not computed.

Next moves