From a 500-row sample across 5 columns.
program_categoryborodistrict+1program_categorydistrictschoolborodistrictschoolborodistrictschoolHas borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| district | bldg_id | school | boro | program_category |
|---|---|---|---|---|
| 01 | M020 | P.S. 20 | MANHATTAN | IP Surveillance Camera Installation |
| 01 | M020 | P.S. 20 | MANHATTAN | Playgrounds |
| 01 | M060 | J.H.S. 60 | MANHATTAN | Low-Voltage Electrical System |
| 01 | M060 | J.H.S. 60 | MANHATTAN |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
district | text | — | 0% | 78M2478K |
bldg_id | text | — | 0% | M115Q202M620 |
school | text | — | 0% | P.S. 115P.S. 149I.S. 202 |
boro | categorical | — | 0% | BROOKLYNQUEENSMANHATTANof 5 |
program_category | text | — |
GET /api/datasets/7xjx-2mhj GET /api/datasets/7xjx-2mhj/quality GET /api/datasets/7xjx-2mhj/related GET /api/columns?dataset=7xjx-2mhj
bldg_id| Ventilation |
| 01 | M110 | P.S. 110 | MANHATTAN | Exterior Masonry |
| 01 | M110 | P.S. 110 | MANHATTAN | Flood Elimination |
| 01 | M110 | P.S. 110 | MANHATTAN | Parapets |
| 01 | M110 | P.S. 110 | MANHATTAN | Roofs |
| 01 | M188 | P.S. 188 | MANHATTAN | IP Surveillance Camera Installation |
| 02 | M001 | P.S. 1 | MANHATTAN | IP Surveillance Camera Installation |
| 0% |
IP Surveillance Camera I…Exterior MasonryRoofs |