From a 500-row sample across 9 columns.
location| material | aggregate_percent | refuse_percent | mgp_percent | paper_percent | organic_percent | material_group | dsny_diversion_summary | location |
|---|---|---|---|---|---|---|---|---|
| Newspaper | 0.019 | 0.011 | 0.005 | 0.098 | 0.0 | Paper | Designated Paper | Citywide |
| Plain OCC/Kraft Paper | 0.056 | 0.012 | 0.01 | 0.464 | 0.002 | Paper |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
material | text | The classification of all materials in the waste stream into categories for sorting, weighing, and counting purposes. | 0% | Compostable/Soiled Paper…Plastic Bottles: #1 PET …K-Cups: Predominanty Pla… |
aggregate_percent | float | Percentage of a material in all combined applicable streams. | 0% | 0.00.0010.002 |
refuse_percent | float | Percentage of a material in the refuse stream. | 0% | 0.00.0010.002 |
mgp_percent | float | Percentage of a material in the metal, glass, and plastic stream. | 13% |
GET /api/datasets/phkb-tkts GET /api/datasets/phkb-tkts/quality GET /api/datasets/phkb-tkts/related GET /api/columns?dataset=phkb-tkts
| Designated Paper |
| Citywide |
| Paper Bags: Kraft Grocery | 0.002 | 0.001 | 0.0 | 0.008 | 0.0 | Paper | Designated Paper | Citywide |
| Paper Bags: Non-food Retail | 0.002 | 0.002 | 0.0 | 0.008 | 0.0 | Paper | Designated Paper | Citywide |
| Paper Bags: Fast Food Bags | 0.001 | 0.002 | 0.0 | 0.001 | 0.0 | Paper | Designated Paper | Citywide |
| Paper Bags: Compostable/Soiled | 0.003 | 0.003 | 0.0 | 0.002 | 0.002 | Paper | Organics Suitable for Composting | Citywide |
| High Grade Paper | 0.007 | 0.005 | 0.001 | 0.026 | 0.0 | Paper | Designated Paper | Citywide |
| Mixed Low Grade Paper | 0.081 | 0.063 | 0.023 | 0.288 | 0.008 | Paper | Designated Paper | Citywide |
| Compostable/Soiled Paper/Waxed OCC/Kraft | 0.078 | 0.094 | 0.006 | 0.011 | 0.017 | Paper | Organics Suitable for Composting | Citywide |
| Compostable/School Plates/Trays | 0.001 | 0.001 | 0.0 | 0.0 | 0.001 | Paper | Organics Suitable for Composting | Citywide |
0.00.0010.002paper_percent | float | Percentage of a material in the paper stream. | 13% | 0.00.0010.002 |
organic_percent | float | Percentage of a material in the organics stream. | 38% | 0.00.0010.002 |
material_group | categorical | Groupings of material categories used to simplify or generalize results. | 0% | PlasticPaperSpecial Wasteof 9 |
dsny_diversion_summary | categorical | Groupings of material categories based on how the material is collected and diverted, according to DSNY designations. | 0% | Designated MGPOtherHHWof 9 |
location | categorical | Geographic indicator of a material's percentage to each waste stream. Location also includes a distinction for materials collected in schools and NYCHA citywide. | 0% | BronxBrooklynCitywideof 8 |