From a 24-row sample across 17 columns.
postcodelongitudenta+6bldg_iddata_as_ofpostcodelongitudenta+6bldg_idbuilding_nameMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| jur_dist | bldg_id | building_name | building_address | no_of_tcus | enrollment | council_dist | borough | postcode | latitude | longitude | community_board |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | M965 | I.S. 349 - MANHATTAN | 549 AUDOBON AVENUE | 15 | 338 | 10 | MANHATTAN | 10040 | 40.855855 | -73.92712 | 112 |
| 8 | X948 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
jur_dist | categorical | Jurisdictional District | 0% | 782721of 14 |
bldg_id | text | Building ID | 0% | R816Q930K982 |
building_name | text | Building Name | 0% | P.S. 232 TRANSPORTABLE -…P.S. 64 TRANSPORTABLE - …P.S. 69 PORTABLE - Q |
building_address | text | Building Address | 0% | 107-25 WREN PLACE701 ST. ANNS AVENUE179-01 90TH AVENUE |
GET /api/datasets/3spy-rjpw GET /api/datasets/3spy-rjpw/quality GET /api/datasets/3spy-rjpw/related GET /api/columns?dataset=3spy-rjpw
data_as_ofborough| P.S. 71 TRANSPORTABLE - X |
| 3040 ROBERTS AVENUE |
| 3 |
| 0 |
| 13 |
| BRONX |
| 10461 |
| 40.845787 |
| -73.829829 |
| 210 |
| 9 | X924 | P.S. 64 TRANSPORTABLE - X | 1425 WALTON AVENUE | 2 | 0 | 16 | BRONX | 10452 | 40.840096 | -73.915569 | 204 |
| 11 | X906 | P.S. 175 TRANSPORTABLE - X | 200 CITY ISLAND AVENUE | 2 | 0 | 13 | BRONX | 10464 | 40.843873 | -73.785219 | 210 |
| 12 | X941 | P.S. 234 TRANSPORTABLE - X | 2055 MAPES AVE | 2 | 16 | 15 | BRONX | 10460 | 40.845878 | -73.886184 | 206 |
| 15 | K982 | P.S. 261 TRANSPORTABLE - K | 314 PACIFIC STREET | 1 | 36 | 33 | BROOKLYN | 11201 | 40.687466 | -73.988288 | 302 |
| 21 | K941 | P.S. 209 TRANSPORTABLE - K | 2609 EAST 7TH ST | 2 | 35 | 48 | BROOKLYN | 11235 | 40.586845 | -73.96198 | 313 |
| 21 | K951 | P.S. 95 TRANSPORTABLE - K | 345 VAN SICKLEN STREET | 3 | 125 | 47 | BROOKLYN | 11223 | 40.595698 | -73.97518 | 315 |
| 27 | Q727 | P.S. 106 TRANSPORTABLE - Q | 180 BEACH 35 STREET | 1 | 0 | 31 | QUEENS | 11691 | 40.593782 | -73.767199 | 414 |
| 27 | Q983 | P.S. 232 TRANSPORTABLE - Q | 153-23 83RD STRET | 2 | 80 | 32 | QUEENS | 11414 | 40.665909 | -73.851216 | 410 |
Showing 12 of 17 columns. All of them are listed below.
no_of_tcus | categorical | Number of Transportable Units onsite | 0% | 213of 6 |
enrollment | categorical | Enrollment | 0% | 08036of 9 |
council_dist | integer | City Council District | 0% | 132416 |
borough | categorical | New York City’s boroughs are five county-level administrative divisions, with each one also being a state county. (Manhattan - New York County; Bronx - Bronx County; Brooklyn - Kings County; Queens - Queens County; Staten Island - Richmond County). NYC’s boroughs have existed since the consolidation of the city in 1898 | 0% | QUEENSBRONXBROOKLYNof 5 |
postcode | integer | Zipcode where the site is located | 0% | 114321141411235 |
latitude | float | Latitude of the site's location | 0% | 40.66590940.71062440.593782 |
longitude | float | Longitude of the site's location | 0% | -73.785219-73.767199-73.851216 |
community_board | categorical | Community Boards are volunteer-run neighborhood organizations that work on all kinds of issues pertinent to their communities, often working with elected city officials in doing so. Community Board members, who can be as young as 16, are appointed by Borough Presidents and City Council representatives. They serve two-year terms. There are 59 Community Boards in NYC, each of which represents a unique geographical area, known as a Community District. Note: as a column header, “Community Board” ( | 0% | 412411410of 19 |
bin | integer | The BIN (Building Identification Number) is a unique 7-digit number assigned to every known building by the Department of City Planning (DCP), the first digit of which is the borough code. BINs allow city agencies to process and match building-related data easily and in a consistent manner. | 0% | 420903141617354441244 |
bbl | integer | The BBL (Borough, Block, and Lot) is a unique combination of three numeric codes - a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) -- designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes. | 0% | 406507000120284300404099140001 |
census_tract | integer | The Census Tract (Census 2020) field indicates the U.S. Census Tract where the site is located. Please note that as part of the geocoding process, leading and trailing zeros are dropped | 0% | 39880926602 |
nta | text | NTAs are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area.. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do not definitively represent neighborhood boundaries. | 0% | QN1201BX1003BX0102 |
data_as_of | datetime | — | 0% | 2024-01-12T00:00:00.000of 1 |