The case was supplied by the organization Hack the Water Crisis based in Cape Town. In cape town there is an emerging water crisis based on to little rain. The concept of Day Zero was introduced as a date for when the taps will run dry and emergency measures will be taken into action. As distributing water from the 200 water distribution points all over Cape Town.
A problem here is that not everyone will be able to get to these distribution points due to sickness, old age, isolation and other reasons.
What it does
We have build a needs identifying and action dispatching system. Our focus has been to be as inclusive as possible. The base line is to use a text messaging UI (SMS) for reporting needs. We have also implemented a mobile web page for the same information posting.
On the other end we have built a web app to get an overview and to dispatch volunteer that want to help out.
How we built it
We set up a node.js bacend communicating with a SMS gateway (twilio) for identifying needs. This data is send to a Google Spreadsheet where a translation from street to coordinates is done.
The overview-fronted fetches the data from the Google Spreadsheet and displays it in a leaflet.js slippymap with a heatmap layer.
Challenges we ran into
To authorize the backends to the google sheet. To limit the scope to something doable.
Accomplishments that we're proud of
Making every part of the system fit together.
What we learned
nodejs and how to work with the twilio and google sheets API
What's next for Help With Water