Josias2003/ecrm

ECRM is a GIS-powered web platform for tracking and managing educational resources across public schools in Kigali, Rwanda. It supports six distinct user roles and provides real-time geospatial visualisation, resource gap detection, teacher workload analysis, community feedback collection, and data export capabilities. # ECRM — Education Community Resource Mapping National web platform for mapping public schools, tracking educational resources, and coordinating interventions across Rwanda’s 30 districts. The system combines geospatial visualisation, role-based workflows, automated resource-gap detection, and audit-ready reporting for the Rwanda Education Board (REB), district officers, schools, field staff, and community members. **Stack:** FastAPI · SQLAlchemy · SQLite · React · Vite · Leaflet · JWT | Environment | URL | |-------------|-----| | API (dev) | `localhost` | | API docs | `localhost` | | Frontend (dev) | `localhost` | --- ## 1. Problem Statement Rwanda’s education sector lacks a single, authoritative view of school conditions nationwide. Decision-makers face fragmented data: enrollment counts, infrastructure, teacher deployment, and community complaints live in separate spreadsheets or paper records. Specific gaps include: - **No unified school registry** with GPS coordinates and facility status across all districts. - **No automated gap detection** for textbooks, desks, sanitation, teacher overload, or missing utilities. - **Weak accountability loops** between community reports, district action, and national oversight. - **Limited geospatial tooling** for field verification and regional equity analysis. - **Manual user provisioning** without self-registration, approval workflows, or support ticketing. - **No audit trail** tying data changes and officer actions to identifiable users and timestamps. ECRM addresses these by centralising school records, enforcing role-scoped access, generating alerts from live data, and providing dashboards, reports, and maps aligned to each actor’s mandate. --- ## 2. Solution Overview ECRM delivers an integrated operational system with six capability areas: | Capability | Description | |------------|-------------| | **School registry** | CRUD for schools with enrollment, infrastruc …