Name: Trash Wheel Collection Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Trash Wheel Collection Data

This dataset is from Trash Wheel Collection Data from the Mr. Trash Wheel Baltimore Healthy Harbor initiative.

Mr. Trash Wheel is a semi-autonomous trash interceptor that is placed at the end of a river, stream or other outfall. Far too lazy to chase trash around the ocean, Mr. Trash Wheel stays put and waits for the waste to flow to him. Sustainably powered and built to withstand the biggest storms, Mr. Trash Wheel uses a unique blend of solar and hydro power to pull hundreds of tons of trash out of the water each year.

The Healthy Harbor initiative has four Trash Wheels collecting trash. Mr. Trash Wheel was the first to start, and since then three more have joined the family. The Trash Wheel Family has collected more than 2,362 tons of trash. See more about how Mr. Trash Wheel works.

Data collection methodology

When crew members are on the machine during the time when a dumpster is being filled, they will manually count the number of each of the item types listed on a single conveyor paddle. This process is repeated several times during the dumpster filling process. An average is then calculated for number of each item per paddle. The average is then multiplied by the paddle rate and then by the elapsed time to fill the dumpster.

Example:

Paddle #1- 9 plastic bottles

Paddle #2- 14 plastic bottles

Paddle #3- 5 plastic bottles

Paddle #4- 12 plastic bottles

Average = 10 plastic bottles/paddle

Conveyor speed = 2.5 paddles per minute therefore an average of 25 plastic bottles are loaded each minute. If it takes 100 minutes to fill the dumpster, we estimate that there are 2,500 bottles in that dumpster.

If no crew is present during the loading, we will take random bushel size samples of the collected material and count items in these samples. A full dumpster contains approximately 325 bushels. Therefore, if an average bushel sample from a dumpster contains 3 polystyrene containers, we estimate that the dumpster contains 975 polystyrene containers.

Periodically “dumpster dives” are held where volunteers count everything in an entire dumpster. These events help validate our sampling methods and also look at what materials are dumpster. present that are not included in our sampling categories.

What type of trash is collected the most? Do the different Trash Wheels collect different sets of trash? Are there times of the year when more or less trash is collected?

Data Dictionary

`trashwheel.csv`

variable	class	description
ID	character	Short name for the Trash Wheel
Name	character	Name of the Trash Wheel
Dumpster	double	Dumpster number
Month	character	Month
Year	double	Year
Date	character	Date
Weight	double	Weight in tons
Volume	double	Volume in cubic yards
PlasticBottles	double	Number of plastic bottles
Polystyrene	double	Number of polystyrene items
CigaretteButts	double	Number of cigarette butts
GlassBottles	double	Number of glass bottles
PlasticBags	double	Number of plastic bags
Wrappers	double	Number of wrappers
SportsBalls	double	Number of sports balls
HomesPowered	double	Homes Powered - Each ton of trash equates to on average 500 kilowatts of electricity. An average household will use 30 kilowatts per day.

Tables

Trashwheel

@kaggle.joebeachcapital_trash_wheel_collection_data.trashwheel

36.37 KB
993 rows
16 columns


CREATE TABLE trashwheel (
  "id" VARCHAR,
  "name" VARCHAR,
  "dumpster" BIGINT,
  "month" VARCHAR,
  "year" BIGINT,
  "date" VARCHAR,
  "weight" DOUBLE,
  "volume" BIGINT,
  "plasticbottles" DOUBLE,
  "polystyrene" DOUBLE,
  "cigarettebutts" DOUBLE,
  "glassbottles" DOUBLE,
  "plasticbags" DOUBLE,
  "wrappers" DOUBLE,
  "sportsballs" DOUBLE,
  "homespowered" BIGINT
);