Promise Tracker GH
An accountability platform for Ghana. Residents see what their MP, Minister, MMDCE and Assembly Member promised, the evidence posted for each promise, and whether people in the area confirm or dispute it.
Stack
- Next.js 15 (App Router) on Vercel
- Supabase: Postgres with PostGIS, Auth (email links), Storage, row level security
- Leaflet with OpenStreetMap and CARTO tiles
- Boundaries: geoBoundaries Ghana ADM1 (16 regions) and ADM2 (260 districts), CC BY 4.0
Screens
| Route | What it does |
|---|
/ | Home: search, use my location, browse officials by role, latest evidence |
/my-area | Turns on location, finds the district with PostGIS, lists the area's officials on a map |
/explore | All districts on a map shaded by promises kept, search and region filter |
/officials, /officials/[id] | Directory and public profile: scorecard, promises, evidence with confirm or dispute, petitions, area map |
/promises/[id] | Promise detail with the evidence timeline and community verdict |
/official/login, /official/setup | Officials sign in, pick roles and area, upload proof of office |
/official/dashboard | Post project updates (in app camera photos are GPS stamped), petitions and new promises; answer disputes |
/admin | Verify officials and approve new promises (profiles with is_admin) |
Local development
cp .env.example .env.local
npm install
npm run dev
Making someone an admin
In the Supabase SQL editor, after they have signed in once:
update public.profiles set is_admin = true
where id = (select id from auth.users where email = '[email protected]');
Demo data
Profiles marked is_demo (Kwame Asante-Mensah, Ama Owusu-Boateng, Kojo Danso, Salamatu Dawuni) are fictional sample data. Remove them before launch:
delete from public.officials where is_demo;
delete from public.constituencies where name = 'Nkwanta Central';
delete from public.electoral_areas where name = 'Abenase';
Not yet included
- Constituency (276) and electoral area boundaries: need Electoral Commission data
- SMS sign in with Ghana Card: needs an SMS provider (Arkesel, Hubtel or Twilio)
- Resident identity verification for the "verified resident" badge
