From a 500-row sample across 12 columns.
aggregate_percentmgp_percentperiod_annual_season_1_season+7aggregate_percentmgp_percentorganics_percent+4aggregate_percentmgp_percentrefuse_percent+3| material_group | main_material_category | subcategory | dsny_diversion_summary | aggregate_percent | refuse_percent | mgp_percent | paper_percent | organics_percent | generator_aggregate | residential_strata_citywide | period_annual_season_1_season |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Paper | Newspaper | Newspaper | Designated Paper | 0.8% | - | - | - | - | Aggregate | Citywide | Annual |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
material_group | categorical | Groupings of material categories used to simplify or generalize results | 0% | PlasticGlassMetalof 9 |
main_material_category | text | The classification of materials in the waste stream based on uniquely identifying criteria | 0% | #3-#7 & Unlabeled Bottle…Other Plastics Materials…Single-Use Plastics |
subcategory | text | The classification of a main material category in the waste stream based on highly specific, uniquely identifying criteria | 0% | #1-#7 Other Rigid Contai…Cups - Paper & Plastic: …Beverage Cartons & Asept… |
GET /api/datasets/pum2-pec2 GET /api/datasets/pum2-pec2/quality GET /api/datasets/pum2-pec2/related GET /api/columns?dataset=pum2-pec2
aggregate_percentmgp_percentrefuse_percent| Paper | Plain OCC/Kraft Paper | Plain OCC/Kraft Paper | Designated Paper | 6.7% | - | - | - | - | Aggregate | Citywide | Annual |
| Paper | Plain OCC/Kraft Paper | Paper Bags: Kraft Grocery | Designated Paper | 0.2% | - | - | - | - | Aggregate | Citywide | Annual |
| Paper | Plain OCC/Kraft Paper | Paper Bags: Kraft Grocery (Labeled Compostable) | Designated Paper | 0.0% | - | - | - | - | Aggregate | Citywide | Annual |
| Paper | Plain OCC/Kraft Paper | Paper Bags: Non-food Retail | Designated Paper | 0.3% | - | - | - | - | Aggregate | Citywide | Annual |
| Paper | Plain OCC/Kraft Paper | Paper Bags: Non-food Retail (Labeled Compostable) | Designated Paper | 0.0% | - | - | - | - | Aggregate | Citywide | Annual |
| Paper | High Grade Paper | High Grade Paper | Designated Paper | 0.4% | - | - | - | - | Aggregate | Citywide | Annual |
| Paper | Mixed Low Grade Paper | Mixed Low Grade Paper | Designated Paper | 6.6% | - | - | - | - | Aggregate | Citywide | Annual |
| Paper | Mixed Low Grade Paper | Paper Bags: Food Service Take-out | Designated Paper | 0.3% | - | - | - | - | Aggregate | Citywide | Annual |
| Paper | Mixed Low Grade Paper | Paper Bags: Food Service Take-out (Labeled Compostable) | Designated Paper | 0.0% | - | - | - | - | Aggregate | Citywide | Annual |
dsny_diversion_summary| categorical |
| Groupings of material categories based on how the material is collected and diverted, according to DSNY designations |
| 0% |
Designated MGPOther (Non-Divertable)E-Wasteof 8 |
aggregate_percent | text | Percentage of a material in all combined applicable waste streams | 0% | 0.0%-0.1% |
refuse_percent | text | Percentage of a material in the refuse stream | 0% | 0.0%-0.1% |
mgp_percent | text | Percentage of a material in the metal, glass, plastic recycling stream | 0% | 0.0%-0.1% |
paper_percent | text | Percentage of a material in the paper recycling stream | 0% | 0.0%-0.1% |
organics_percent | text | Percentage of a material in the organics recycling stream | 0% | -0.0%0.1% |
generator_aggregate | categorical | Source of waste | 0% | ResidentialSchoolsLitter Basketsof 5 |
residential_strata_citywide | categorical | Stratified groups of DSNY districts based on income and housing density | 0% | CitywideLDHIMDHIof 10 |
period_annual_season_1_season | categorical | Time period for which data applies | 0% | AnnualSeason 1Season 2of 3 |