Singapore Waste Management
Discover how much Singapore is saving energy per years by recycling.
@kaggle.kingabzpro_singapore_waste_management
Discover how much Singapore is saving energy per years by recycling.
@kaggle.kingabzpro_singapore_waste_management
Singapore has a new milestone of becoming a zero-waste nation as government is worried about the rising number of waste disposal. At the current pace the Semakau Landfill will run out of space by year 2035 which is an alarming situation for Singaporeans (towardszerowaste.gov.sg). Making matters worse, Singapore has limited land for building new incineration plants or landfills. The government would like to motivate citizens by sharing the total energy that the combined recycling efforts have saved every year.
Our dataset is divided between two timelines, from 2003 to 2017 and 2018 to 2020. The 2020 data was manually added using the NEA website. You can find additional energy data per material type on Greentumble .
The National Environment Agency (NEA) for providing me with annual waste management data. Green tumble for providing key values of energy generation.
CREATE TABLE n_2003_2017_waste (
"waste_type" VARCHAR,
"waste_disposed_of_tonne" BIGINT,
"total_waste_recycled_tonne" DOUBLE,
"total_waste_generated_tonne" BIGINT,
"recycling_rate" DOUBLE,
"year" BIGINT
);CREATE TABLE n_2018_2020_waste (
"waste_type" VARCHAR,
"total_generated_000_tonnes" BIGINT -- Total Generated (\u0027000 Tonnes),
"total_recycled_000_tonnes" BIGINT -- Total Recycled (\u0027000 Tonnes),
"year" BIGINT
);CREATE TABLE waste_energy_stat (
"the_gives_the_amount_of_energy_saved_in_kilowatt_hour__6b8867b2" VARCHAR -- The Table Gives The Amount Of Energy Saved In Kilowatt Hour (kWh) And The Amount Of Crude Oil (barrels) By Recycling 1 Metric Tonne (1000 Kilogram) Per Waste Type,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5
);Anyone who has the link will be able to view this.