From a 500-row sample across 11 columns.
boroughinsptn_ops_detailinspecting_unit_code+3boroughboroughbbllatitude+1Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| insptn_typ_cd_fk | inspecting_unit_code | borough | insptn_ops_detail | insp_inspect_dt_fk | bldg_current_bin | latitude | longitude | communitydistrict | citycouncildistrict | bbl |
|---|---|---|---|---|---|---|---|---|---|---|
| STRUC_INT_6 | E261 | QN | 8044995 | 2018-01-31T00:00:00.000 | 4548708 | — | — | — | — | — |
| CONSTR | E232 | BK |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
insptn_typ_cd_fk | text | Type of Inspection | 0% | CONSTRCOM_OCPCYALT |
inspecting_unit_code | text | Inspecting Unit | 0% | E261E036E017 |
borough | categorical | Borough | 0% | BKMNQNof 5 |
latitude | float | Latitude of Building | 20% | 40.86388740.67613540.863903 |
longitude | float |
GET /api/datasets/kfgh-h6re GET /api/datasets/kfgh-h6re/quality GET /api/datasets/kfgh-h6re/related GET /api/columns?dataset=kfgh-h6re
latitudelongitudeboroughbblcommunitydistrict+1borough| 8045019 |
| 2018-01-31T00:00:00.000 |
| 3414034 |
| 40.648566 |
| -73.954124 |
| 317 |
| 40 |
| 3051100024 |
| CONSTR | E270 | BK | 8037862 | 2018-01-31T00:00:00.000 | 3397461 | — | — | — | — | — |
| FORTH | E258 | QN | 8040589 | 2018-01-31T00:00:00.000 | 4003484 | 40.747691 | -73.939242 | 402 | 26 | 4002650013 |
| STRUC_INT_1 | E261 | QN | 8044998 | 2018-01-31T00:00:00.000 | 4146337 | 40.739745 | -73.811061 | 407 | 20 | 4067350019 |
| ALT | E270 | BK | 8037779 | 2018-01-31T00:00:00.000 | 3079903 | 40.685413 | -73.909402 | 304 | 37 | 3034390016 |
| ALT | E036 | MN | 8045053 | 2018-01-31T00:00:00.000 | 1043061 | 40.771748 | -73.961702 | 108 | 4 | 1014080059 |
| ALT | E270 | BK | 8045028 | 2018-01-31T00:00:00.000 | 3039841 | 40.686093 | -73.923122 | 303 | 41 | 3014870007 |
| CONSTR | E041 | MN | 8045015 | 2018-01-31T00:00:00.000 | 1807480 | — | — | — | — | — |
| CONSTR | E212 | BK | 8045055 | 2018-01-31T00:00:00.000 | 3817791 | — | — | — | — | — |
| Longitude of Building |
| 20% |
-73.827208-73.773084-73.827353 |
communitydistrict | integer | Community Board District of Building | 21% | 102105301 |
citycouncildistrict | integer | City Council District of Building | 21% | 134 |
insptn_ops_detail | integer | Inspection ID | 0% | 712813941834985233680 |
insp_inspect_dt_fk | datetime | Date inspection was completed | 0% | 2015-08-19T00:00:00.0002015-08-20T00:00:00.0002015-08-21T00:00:00.000 |
bldg_current_bin | integer | Building Identification Number | 0% | 212009833488491088112 |
bbl | integer | Building Block Lot | 17% | 412495000220514100064065170001 |