Water Quality Information System – UNICEF

Riscon Solutions Limited is a global consulting company specialising in information and knowledge management. Roger from Riscon approached me to work on various projects because of my experience with MySQL and WordPress. As a consultant working with UNICEF and the communities in the south Pacific ocean, Roger wanted to build an information system that allowed users from the Governments of Vanuatu and Fiji to record and manage data regarding water quality and events such as tropical cyclones.

The system utilises the WPDatatables WordPress plugin, giving users access to tables, charts and data management. We also built a range of data input forms using the Gravity Forms WordPress plugin. These were welcomed by engineers and workers on the ground as they simplified the recording of vital water quality information throughout the region.

Another requirement was that the system needed to interface with some of the existing 3rd party data collection products such as Jotform and Integromat. This was achieved by integrating the respective products API with the MySQL database to store the data.