From a 500-row sample across 9 columns.
mgp_percentdsny_diversion_summaryaggregate_percent+3mgp_percentdsny_diversion_summaryaggregate_percent+3mgp_percentdsny_diversion_summaryaggregate_percent+3| material | aggregate_percent | refuse_percent | mgp_percent | paper_percent | organic_percent | material_group | dsny_diversion_summary | loacation |
|---|---|---|---|---|---|---|---|---|
| Newspaper | 0.019 | 0.011 | 0.005 | 0.098 | 0.0 | Paper | Designated Paper | Citywide |
| Plain OCC/Kraft Paper | 0.057 | 0.014 | 0.01 | 0.472 | 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% | Compressed Gas Cylinders…#1 PET BottlesBulk/Rigid Plastic |
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/k3ks-jzek GET /api/datasets/k3ks-jzek/quality GET /api/datasets/k3ks-jzek/related GET /api/columns?dataset=k3ks-jzek
| Designated Paper |
| Citywide |
| High Grade Paper | 0.007 | 0.005 | 0.001 | 0.026 | 0.0 | Paper | Designated Paper | Citywide |
| Mixed Low Grade Paper | 0.087 | 0.068 | 0.024 | 0.314 | 0.009 | Paper | Designated Paper | Citywide |
| Paper: Compostable/Soiled/Waxed OCC/Kraft | 0.081 | 0.098 | 0.007 | 0.014 | 0.02 | Paper | Organics Suitable for Composting | Citywide |
| Other Nonrecyclable Paper | 0.01 | 0.011 | 0.007 | 0.006 | 0.004 | Paper | Other | Citywide |
| Paper Beverage Cartons/Aseptic Boxes | 0.004 | 0.003 | 0.014 | 0.003 | 0.0 | Paper | Designated MGP | Citywide |
| #1 PET Bottles | 0.013 | 0.009 | 0.062 | 0.002 | 0.001 | Plastic | Designated MGP | Citywide |
| #2 HDPE Natural Bottles | 0.005 | 0.002 | 0.033 | 0.0 | 0.0 | Plastic | Designated MGP | Citywide |
| #2 HDPE Pigmented Bottles | 0.005 | 0.003 | 0.034 | 0.0 | 0.001 | Plastic | Designated MGP | 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% | PlasticSpecial WasteOrganicof 9 |
dsny_diversion_summary | categorical | Groupings of material categories based on how the material is collected and diverted, according to DSNY designations. | 0% | Designated MGPHHWOtherof 9 |
loacation | 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% | SchoolsNYCHABrooklynof 8 |