We started with Wyndham, Victoria local council data http://data.gov.au/dataset/wyndham-city-hard-rubbish-bookings
We found that number of request for hard rubbish collection were growing every year. We used Google BigQuery to analyse the Data and used Google DataStudio to visualize. Observation charts are available here.
https://datastudio.google.com/reporting/0ByKECVErKkmIeXlsc2ZWWDNyT1k/page/liqG https://datastudio.google.com/reporting/0ByKECVErKkmIeXlsc2ZWWDNyT1k/page/2jqG
Based on observations and looking through existing processes, we noted couple of important problems which needs to be solved to really transform local councils better manage hard waste collection.
- A better approach for residents to book a collection with councils
- Councils find efficient ways to manage and collect the hard waste from resident properties.
Solution has 2 important Parts
-
Consumer facing Facebook Page integrated with Amazon Lex Chatbot https://www.facebook.com/Wyndham-Hard-Rubbish-Collections-767130700127543/
-
Backend Website for Council Staff to view the Bookings and Find the Shortest Route. https://s3.amazonaws.com/govhack2017/WhatIsMyRoute.html
The picture below explains the components involved as part of the solution
