Home / Works / Community Data Platform

Community Data Platform

Volunteer · Full-Stack Web App
Confidential Data 50+ External Users Leaflet.js · Cloudflare Pages · D1 · Python

Overview

A report submission web app with admin review and diff views, where approved changes are written to a Cloudflare D1 (SQL) database with a full before/after audit changelog. Paired with a web map dashboard fed by a Python pipeline that cleans multi-municipality data and joins it to administrative boundaries. Built with Claude Code.

How it works

Approved changes update the live table and changelog; the map reads the live data.

Field agent opens abarangay report (PIN) Adds, edits or removesrecords; original kept API saves changes aspending (atomic batch) Admin reviews beforeand after (admin PIN) Approve: upsert or deleterecords in one batch Live data table Before/afterchangelog Changelog viewer,Excel / CSV exports Spreadsheets +boundary GeoPackages Python: rows to JSON byarea; boundaries to GeoJSON Dashboard loads livedata + files, joins by key Interactive map: views,filters, statistics live data Report submission and review Web map dashboard

InputStepDecision / optionData storeOutput