govstory

Project Info

govstory thumbnail

Project Description


A collection depot has million of trash and some of them already had an object detection technology to filtering but they haven't used that data to make an application for the community yet.
The more precisely people trash in, the less effort for delivering and collection depots also.

Imagine that we have thousands of waste which are considered bottles such as juice
bottle, water bottle, and sports water bottle. A question arises is whether all bottles can be recycled, while the information
about recycling on trash bin is so limited. Technologies we have used are 3D scanning and AR. Firstly, Environment Protection Authorities can scan numbers
of waste and upload to server then the mobile app downloads that data. While a user is confused about their trash, they open
the camera in the mobile app to scan that object. The result will appear as a sticker on that object to indicate its type and the correct bin to put in.

We make a mobile application that not only educates people living in Australia about waste filtering but help them with detecting trash types to throw in the correct bin also.
Moreover, we encourage everyone to keep their city and neighbourhood clean by recording their correct trashing. At the end of the day, they will get some small rewards for good conduct.

alt text
alt text
alt text
alt text
alt text


Data Story


We use the data of landfill waste, green waste and recycling waste in the city of Ballarat, we combined these 3 data sets into 1 table and sum up daily data into monthly data. We made descriptive analysis to show the amount of waste in the 3 categories in the past 3 years, then we use ARIMA model to make prediction of the amount of waste will be generated in the coming years. We found the recycling waste in the future will be unstable like it is now, we conclude that one possible reason is people are not using the recycling bins correctly. Thus we came up with the idea of making an mobile APP to help people to know what kind of waste should go to recycling bin. In the APP, it also reward people who collect more recycling waste, we believe this APP will help to solve the problem of the recycling waste not being put in the right spot.

1.Clean Data

select c.date,a.greenwaste,b.landfillwaste,c.recyclewaste from
(select date,count(vehicle) green
count, sum(weight) greenwaste from [kerbside-green-waste] group by date) a right outer join
(select date,count(vehicle) landfill
count, sum(weight) landfillwaste from [kerbside-landfill] group by date)b on a.date=b.date right outer join
(select date,count(vehicle) recycle
count, sum(weight) recycle_waste from [kerbside-recycling] group by date)c on a.date=c.date WHERE C.DATE BETWEEN '2016-07-03' AND '2019-06-30' ORDER BY 1;
alt text

This table combines the original 3 datasets
Ballarat Kerbside Recycling waste Deliveries
Ballarat Kerbside Green waste Deliveries
Ballarat Kerbside Landfill Deliveries
We combined 3 tables into 1 table and sum up daily data into monthly data.

2.Data Statistical description
This shows the average monthly waste in 3 categories, min, max and std deviation.
alt text

Line charts give a brief idea about the amount of waste (unit: ton) generated in the recent 3 years.

3.The monthly deviation plot with Recycling Waste
alt text
alt text

4.Apply Seasonal ARIMA model to forcast the data
alt text

5.Forecast of Recycling Waste in the city of Ballarat
alt text


Evidence of Work

Video

Homepage

High-Res Image

Team DataSets

Ballarat Garbage Collection

Description of Use: Will use this data set to look up the collection schedule

Data Set

Ballarat Kerbside Recycling waste Deliveries

Description of Use: https://data.gov.au/data/dataset/d563bdd5-cc19-4b93-a558-044545b3ff0f/resource/bf63bada-b058-4d75-84da-015d50fa8abc/download/kerbside-green-waste.csv

Data Set

Ballarat Kerbside Green waste Deliveries

Description of Use: we will combine the landfill, recycling and green waste table together, and make analysis

Data Set

Ballarat Kerbside Landfill Deliveries

Description of Use: we will combine the landfill, recycling and green waste table together, and make analysis

Data Set

Challenges

🌟 Community “Clean, Green and Lean” Rewards

Region: Northern Territory

Challenge

🌟 Creating a clean city

Region: Victoria

Challenge

Back to Projects