From a 75-row sample across 4 columns.
Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| borough | location | cb | contract_no |
|---|---|---|---|
| Bus Pad | No Contract | — | — |
| Manhattan/Bronx | SEC E. Gun Hill Rd & Hull Ave | Complex HWP2013MX | 7(X) |
| — | Columbia St and W 9th St | — | 6 |
| — | Various Expedited locations | HWS2016Q2 | 7 |
| — | NWC 74th St & Broadway | — | 7 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | categorical | Borough | 71% | ManhattanStaten IslandQueensof 13 |
cb | text | The City contract for the work | 61% | HWS2016R2HWS2017Q1Complex HWP14MTA |
contract_no | categorical | Community District | 28% | 27(X)1of 14 |
location | text | Description of the work location | 4% | Construction has not yet…No ContractContract has not yet sta… |
GET /api/datasets/r528-jcks GET /api/datasets/r528-jcks/quality GET /api/datasets/r528-jcks/related GET /api/columns?dataset=r528-jcks
cb| — | Jamaica Ave and 125th St | — | 9 |
| — | NW/SWC 89th St. and Central Park West | — | 7 |
| — | SEC East Mosholu Pkwy N. & Webster Ave | — | 7(X) |
| — | No Work Scheduled | Complex HWP14RTA | — |
| Manhattan | Construction has not yet started | HWPR16M | — |