From a 55-row sample across 17 columns.
lotblockbin+1lotstateblock+2ntabbllongitude+5boroughMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| borough_number | building_name | building_address | borough | state | zip_code | block | lot | fy15_energy_usage_mmbtu_utility_energy_excluding_fuel_oil | latitude | longitude | community_board |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Manhattan Municipal Building | 1 Centre St | Manhattan | New York | 10007 | 121 | 1 | 92117 | 40.713001 | -74.004181 | 1 |
| 5 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough_number | categorical | # of borough in NYC Borough/Block/Lot parcel number system | 0% | 135of 5 |
building_name | text | Name of the building | 0% | Sun BuildingDOF FacilityQueens Criminal Court |
building_address | text | Street Address of the building | 0% | 45 Monroe Pl 120 Schermerhorn St 80 Centre St |
borough | categorical | Name of Borough in which the building is located | 0% | ManhattanBrooklyn |
GET /api/datasets/ubdi-jgw2 GET /api/datasets/ubdi-jgw2/quality GET /api/datasets/ubdi-jgw2/related GET /api/columns?dataset=ubdi-jgw2
lotblockntabbllongitude+7bblntalotlongitude+7| Staten Island Borough Hall |
| 10 Richmond Ter |
| Staten Island |
| New York |
| 10301 |
| 7 |
| 1 |
| 11385 |
| 40.642197 |
| -74.075201 |
| 1 |
| 1 | Manhattan Criminal Court | 100 Centre Street | Manhattan | New York | 10013 | 167 | 1 | 126511 | 40.716084 | -74.001425 | 1 |
| 1 | 100 Gold St | 100 Gold St | Manhattan | New York | 10038 | 94 | 25 | 64582 | 40.710353 | -74.004007 | 1 |
| 5 | Staten Island Family Court | 100 Richmond Ter | Staten Island | New York | 10301 | 9 | 22 | 1429 | 40.644935 | -74.07723 | 1 |
| 5 | Staten Island Village Hall | 111 Canal St | Staten Island | New York | 10304 | 523 | 1 | 932 | 40.626584 | -74.076758 | 1 |
| 1 | Manhattan Civil Court | 111 Centre St | Manhattan | New York | 10013 | 169 | 10 | 27287 | 40.716317 | -74.001277 | 1 |
| 1 | 115 Chrystie | 115 Chrystie Street | Manhattan | New York | 10002 | 423 | 22 | 1974 | 40.718647 | -73.993586 | 3 |
| 2 | Bronx Housing Court | 1118 Grand Concourse | Bronx | New York | 10456 | 2462 | 39 | 9119 | 40.832232 | -73.919655 | 4 |
| 3 | Brooklyn Criminal Court | 120 Schermerhorn St | Brooklyn | New York | 11201 | 169 | 17 | 104757 | 40.690074 | -73.988923 | 2 |
Showing 12 of 17 columns. All of them are listed below.
Staten Islandstate | text | State | 0% | New Yorkof 1 |
zip_code | integer | Zip Code | 0% | 100071120110013 |
block | integer | # of block in NYC Borough/Block/Lot parcel number system | 0% | 153122139 |
lot | integer | # of lot in NYC Borough/Block/Lot parcel number system | 0% | 12221 |
fy15_energy_usage_mmbtu_utility_energy_excluding_fuel_oil | integer | Total building energy usage in million BTU from utility energy, excluding heating fuel oil | 0% | 473572388811072 |
latitude | float | — | 11% | 40.71035340.62550940.714231 |
longitude | float | — | 11% | -73.993586-74.004181-73.808685 |
community_board | categorical | — | 11% | 1212of 9 |
council_district | categorical | — | 11% | 13349of 14 |
census_tract | integer | — | 11% | 311129 |
bin | integer | — | 13% | 107921610018355151735 |
bbl | integer | — | 13% | 500523000110015400231001530018 |
nta | categorical | — | 11% | SoHo-TriBeCa-Civic Cente…DUMBO-Vinegar Hill-Downt…West New Brighton-New Br…of 19 |