Tatirano's mission is to provide clean water to everyone, everywhere in Madagascar. At the core of this work is installing rainwater harvesting systems in schools, marketplaces, and other areas, increasing people's access to clean, safe water.

I built the Statirano statistics platform to show the status of all Tatirano systems, including where they are, state of repair, water cleanliness, photos and more. Overall it's a groundbreaking approach to accountability and transparency in the development sector.

Preview of the website

I built Statirano entirely from scratch, using the classic PHP/MySQL combination for the backend and API, whilst the front end uses JavaScript and a web worker to provide a slick, easy-to-use interface. I also created a custom field data collection app, Ekipa, which is a full progressive web app, and works offline with synchronisation.