From a 500-row sample across 17 columns.
cbboroughsrboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| file | closed | _311 | sr | steel_curb | sc_cut | ref_to_other | cb | on_street | i_f_o | cross_st_1 | cross_st_2 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 9497 | Yes | Yes | 311-17520928 | Yes | No | No | 2 | 46 ROAD | 5-21 | 5 STREET | VERNON BOULEVARD |
| 9495 | Yes | Yes | 311-17416968 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
file | text | — | 0% | 16522801078 |
closed | categorical | — | 0% | YesNoof 2 |
_311 | categorical | — | 0% | YesNoof 2 |
sr | text | — | 38% | PICK UPCMP CONDITIONCMP |
steel_curb | categorical | — | 0% |
GET /api/datasets/i2y3-sx2e GET /api/datasets/i2y3-sx2e/quality GET /api/datasets/i2y3-sx2e/related GET /api/columns?dataset=i2y3-sx2e
| Yes |
| Yes |
| No |
| 2 |
| 46 ROAD |
| 5-35 |
| 5 STREET |
| VERNON BOULEVARD |
| 2649 | Yes | Yes | 311-17271768 | Yes | Yes | No | 1 | HOYT AVENUE | 445 | DELAFIELD AVENUE | FOREST AVENUE |
| 9568 | Yes | Yes | 311-19186129 | Yes | No | Yes | 7 | COLLEGE POINT BOULEVARD | 31-69 | 31 AVENUE | WHITESTONE EXPRESSWAY |
| 9498 | Yes | Yes | 311-17608283 | Yes | No | No | 1 | 37 STREET | 35-58 | 35 AVENUE | 36 AVENUE |
| 9499 | Yes | Yes | 311-17591675 | Yes | Yes | Yes | 2 | 63 STREET | 41-39 | HICKS DRIVE | 43 AVENUE |
| 9582 | Yes | Yes | 311-19452517 | Yes | No | No | 2 | 43 AVENUE | 60-06 | 60 STREET | 61 STREET |
| 9592 | Yes | Yes | 311-19706815 | Yes | No | No | 2 | CENTER BOULEVARD | 45-45 | NORTH BASIN ROAD | 46 AVENUE |
| 2333 | Yes | Yes | 311-20117229 | Yes | No | No | 9 | STICKBALL BOULEVARD AND SEWARD AVENUE | — | STICKBALL BOULEVARD | SEWARD AVENUE |
| 9584 | Yes | Yes | 311-19519596 | Yes | Yes | No | 3 | 98 STREET | 35-37 | 35 AVENUE | 37 AVENUE |
Showing 12 of 17 columns. All of them are listed below.
YesNoof 2 |
sc_cut | categorical | — | 0% | NoYesof 2 |
ref_to_other | categorical | — | 0% | NoYesof 2 |
cb | text | — | 14% | 11121 |
on_street | text | — | 7% | BroadwayBROADWAY212th St. |
i_f_o | text | — | 22% | 1252 |
cross_st_1 | text | — | 7% | BendBroadway118th Ave. |
cross_st_2 | text | — | 15% | BendDead end1 AVENUE |
lin_ft | text | — | 12% | 012 |
sq_ft | text | — | 95% | 123 |
rec_d_2 | datetime | — | 30% | 2001-12-13T00:00:00.0002003-01-21T00:00:00.0002004-12-08T00:00:00.000 |
insp | datetime | — | 36% | 2006-03-29T00:00:00.0002006-05-15T00:00:00.0002001-12-18T00:00:00.000 |
borough | categorical | — | 0% | QueensBrooklynManhattanof 5 |