DSNY Waste Characterization 2023 - Subsort Results
City of New York
@usgov.city_of_new_york_dsny_waste_characterization_2023_subs_f2aa421b
City of New York
@usgov.city_of_new_york_dsny_waste_characterization_2023_subs_f2aa421b
The NYC Department of Sanitation (DSNY) conducted the 2023 Waste Characterization Study in the Fall of 2022 and Spring of 2023. The 2023 Study determined the waste composition of several major sources from which DSNY collects: residential households, New York City Public Schools, the New York City Housing Authority (NYCHA), and on-street litter baskets. Waste from these generators was categorized into 96 main material categories. In addition to the 96 sort categories, certain material groups were further subsorted into 826 subsort categories which are provided in this dataset by residential strata and time period. Because not all the main material categories were subsorted, there are two separate datasets — one for the main sort results and one for the subsort results. Results for both datasets are presented in absolute terms as the quantity by weight of each material type, per stream. The quantity of each material is calculated by applying the percent composition to the total quantity of specified DSNY collections.
Organization: City of New York
Last updated: 2024-05-03T18:46:31.603643
Tags: sanitation, subsort, waste-characterization, waste-composition
CREATE TABLE table_1 (
"material_group" VARCHAR,
"main_material_category" VARCHAR,
"subcategory" VARCHAR,
"dsny_diversion_summary_category" VARCHAR,
"aggregate_percent" VARCHAR,
"refuse_percent" VARCHAR,
"mgp_metal_glass_plastic_percent" VARCHAR -- MGP (Metal, Glass, Plastic) Percent,
"paper_percent" VARCHAR,
"organics_percent" VARCHAR,
"generator_aggregate_residential_schools_nycha_litter_baskets" VARCHAR -- Generator (Aggregate, Residential, Schools, NYCHA, Litter Baskets),
"residential_strata_citywide_hdhi_hdli_hdmi_ldhi_ldli_l_f52c4608" VARCHAR -- Residential Strata (Citywide, HDHI, HDLI, HDMI, LDHI, LDLI, LDMI, MDHI, MDLI, MDMI),
"period_annual_season_1_season_2" VARCHAR -- Period (Annual, Season 1, Season 2)
);Anyone who has the link will be able to view this.