From a 45-row sample across 29 columns.
community_boardlocationyear+9borocdcommunity_boardborocode+16community_boardMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| year | borocode | borocd | assemdist | stsendist | congdist | location | address | borough | postcode | on_street | to_street |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2021 | 3 | 302 | 57 | 25 | 8 | BRIC | 647 Fulton Street | Brooklyn | 11217 | Rockwell Place | Fulton St |
| 2021 | 3 | 314 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
year | categorical | The year of the program participation. | 0% | 20212022of 2 |
borocode | categorical | The Council District for the location of the street seat. | 0% | 312of 3 |
borocd | categorical | The three digit code representing the borough code and community district code of the street seat. | 0% | 302310314of 19 |
assemdist | integer | The Assembly District for the location of the street seat. | 0% | 575243 |
GET /api/datasets/5ar6-qxhs GET /api/datasets/5ar6-qxhs/quality GET /api/datasets/5ar6-qxhs/related GET /api/columns?dataset=5ar6-qxhs
boroughntato_streetstatuslocation+3boroughntalongitude+4to_streetboroughfrom_street+1| 43 |
| 21 |
| 9 |
| Flatbush Library |
| 22 Linden Blvd |
| Brooklyn |
| 11226 |
| Linden Blvd |
| Flatbush Ave |
| 2021 | 3 | 306 | 51 | 25 | 7 | Redhook Library | 7 Wolcott Street | Brooklyn | 11231 | Wolcott Street | Dwight St |
| 2021 | 3 | 310 | 64 | 22 | 11 | Bay RidgePBranch Library | 7223 Ridge Blvd | Brooklyn | 11209 | Ridge Blvd | 72nd St |
| 2021 | 3 | 313 | 46 | 23 | 8 | Brighton BeachcLibrary | 16 Brighton First Rd | Brooklyn | 11235 | Brighton First Road | Brighton Beach Ave |
| 2021 | 3 | 316 | 55 | 20 | 8 | BrownsvillebBranch Library | 61 Glenmore Ave | Brooklyn | 11212 | Glenmore Ave | Watkins St |
| 2021 | 3 | 301 | 53 | 18 | 7 | Bushwick Library | 340 Bushwick Avenue | Brooklyn | 11206 | Bushwick Avenue | Seigel St |
| 2021 | 3 | 318 | 59 | 19 | 8 | Canarsie Branch Library | 1580 Rockaway Pkwy | Brooklyn | 11236 | Rockaway Parkway | Avenue J |
| 2021 | 3 | 302 | 57 | 25 | 8 | Clinton HilllBranch Library | 380 Washington Avenue | Brooklyn | 11238 | Washington Ave | Greene Ave |
| 2021 | 3 | 313 | 46 | 23 | 8 | Coney IslandlBranch Library | 1901 Mermaid Avenue | Brooklyn | 11224 | Mermaid Ave | W 19th St |
Showing 12 of 28 columns. All of them are listed below.
stsendist | categorical | The State Senate District for the location of the street seat. | 0% | 252219of 12 |
congdist | categorical | The Congressional District for the location of the street seat. | 0% | 8911of 8 |
location | text | The name of the business or commercial property for the street seats. | 0% | Essex MarketTemple SquareJerome Ave |
address | text | The building address number and street name of the seating location. | 0% | 220 Broome Street560 New York Avenue3494 Jerome Ave |
borough | categorical | The name of the borough where the street seat was installed. | 0% | BrooklynManhattanBronxof 3 |
postcode | text | Zipcode where the street seat is located | 2% | 112171121810467 |
on_street | text | The street closest to the seating location. | 0% | New York AveSaint Edwards StJerome Ave |
to_street | text | The closest cross street to the street seat. | 0% | Fulton StMaple StAuburn Pl |
from_street | text | The second closest cross street to the street seat. | 2% | Park AveNorfolkE. 3rd St |
type | categorical | A description of the seating type installed. | 0% | Sidewalk SeatingCurbsideCurbside + Sidewalk Seat…of 4 |
partner | categorical | The name of the managing partner for the street seats. | 0% | Brooklyn Public LibraryDowntown Brooklyn Partne…Lower East Side Partners…of 7 |
status | categorical | The status of the installation of the street seat. | 84% | InstalledPermanentof 2 |
xcoordin | integer | Geographic coordinates in decimal degrees | 0% | 990352998740991031 |
ycoordin | integer | Geographic coordinates in decimal degrees | 0% | 192303169347200699 |
femafldz | categorical | FEMA flood zone code for the street seat. | 0% | XAEof 2 |
femafldt | categorical | FEMA flood zone description for the street seat. | 4% | AREA OF MINIMAL FLOOD HA…0.2 PCT ANNUAL CHANCE FL…of 2 |
hrcevac | categorical | The hurricane evacuation zone of the street seat. | 67% | 315of 4 |
latitude | float | Latitude coordinate of the street seat. | 2% | 40.69450240.68823640.661116 |
longitude | float | Longitude coordinate of the street seat. | 2% | -73.979212-73.881633-73.988308 |
community_board | integer | Community Board where the street seat is located | 2% | 215302 |
council_district | categorical | Council District where the street seat is located | 0% | 354333of 17 |
census_tract | integer | Census Tract where the street seat is located | 4% | 80448018 |
bin | integer | Building identification number for the address the street seat is located | 4% | 310650530585973058036 |
bbl | integer | Boro-Block-Lot number for the address the street seat is located | 4% | 305416001410035275013020950001 |
nta | text | The neighborhood tabulation area where the street seat is located | 4% | BK0203BK0202BK1402 |