From a 500-row sample across 28 columns.
:@computed_region_sbqj_enih:@computed_region_92fq_4b7qthe_geom+17:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_yeji_bk3q+14:@computed_region_sbqj_enih:@computed_region_92fq_4b7qthe_geom+2Mappable — Socrata point column `the_geom`.
Open on the map →| the_geom | borocode | boroname | borocd | coundist | assemdist | stsendist | congdist | nearest_add | on_street | from_street | to_street |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40.74144, -73.88031 | 4 | Queens | 404 | 25 | 30 | 12 | 6 | 82-62 Broadway | BROADWAY | Whitney Avenue | Elmhurst Avenue |
| 40.64002, -73.90611 | 3 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | coordinate | — | 0% | {'coordinates': [-73.959…{'coordinates': [-73.897…{'coordinates': [-73.971… |
borocode | categorical | The one digit borough code number where the seating feature was installed. | 0% | 321of 5 |
boroname | categorical | The name of the borough where the seating feature was installed | 0% | BrooklynBronxManhattanof 5 |
borocd | text | The three digit number that represents the borough and the community district. | 0% |
GET /api/datasets/esmy-s8q5 GET /api/datasets/esmy-s8q5/quality GET /api/datasets/esmy-s8q5/related GET /api/columns?dataset=esmy-s8q5
borocdon_streetlongitude+10on_streetto_streetfrom_street:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_yeji_bk3q+5:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_yeji_bk3q+4| Brooklyn |
| 318 |
| 46 |
| 59 |
| 19 |
| 8 |
| 8922 Flatlands Avenue |
| Flatlands Avenue |
| E 89 Street |
| Remsen Avenue |
| 40.81000, -73.87654 | 2 | Bronx | 202 | 17 | 84 | 29 | 14 | 170 Food Center Drive | Food Center Drive | Avenue P | Halleck Street |
| 40.68326, -73.91126 | 3 | Brooklyn | 316 | 37 | 55 | 25 | 8 | 1738 Broadway | BROADWAY | Rockaway Avenue | Chauncey Street |
| 40.67684, -73.97390 | 3 | Brooklyn | 306 | 39 | 52 | 20 | 10 | 28 7 Avenue | 7 Avenue | Sterling Place | St. Johns Place |
| 40.71573, -73.85282 | 4 | Queens | 406 | 29 | 28 | 15 | 6 | 69-05 Juno Street | 69 Avenue | Juno Street | Ingram Street |
| 40.88803, -73.90735 | 2 | Bronx | 208 | 11 | 81 | 33 | 15 | 3820 Riverdale Avenue | Riverdale Avenue | W 238 Street | Henry Hudson Parkway E |
| 40.90044, -73.83985 | — | — | — | — | — | — | — | 150 W 5 Street | Mundy Ln | W Sanford Boulevard | W 5 Street |
| 40.70694, -73.95392 | 3 | Brooklyn | 301 | 34 | 50 | 18 | 7 | 402 Broadway | Broadway | Hooper Street | Hewes Street |
| 40.86637, -73.92853 | 1 | Manhattan | 112 | 10 | 71 | 31 | 13 | 250 Dyckman Street | Dyckman Street | Payson Avenue | Seaman Avenue |
Showing 12 of 28 columns. All of them are listed below.
205112107 |
coundist | text | The Council District where the seating feature was installed | 0% | 151317 |
assemdist | text | The Assembly District where the seating feature was installed | 0% | 867952 |
stsendist | text | The State Senate District where the seating feature was installed. | 0% | 322633 |
congdist | categorical | The Congressional District where the seating feature was installed | 0% | 15138of 13 |
category | text | Type of facility near the seating feature | 100% | — |
nearest_add | text | Nearest address of the seating feature, including house number, where available | 0% | 103-12 Roosevelt AvenueBUS SHELTER - Williamsbu…141 E 25 Street |
on_street | text | Street on which the feature is located, without house number | 0% | Broadway3 AvenueHillside Avenue |
from_street | text | Nearest cross streets from the seating feature | 0% | Broadway3 AvenueFulton Street |
to_street | text | The other nearest cross street from the seating feature. | 0% | Lexington Avenue3 AvenueS 5 Street |
side_of_st | categorical | The compass direction where the seating is facing on the sidewalk. | 9% | WENof 8 |
installation_date | datetime | Date of installation for the seating feature | 0% | 2022-11-01T00:00:00.0002025-05-31T00:00:00.0002019-05-30T00:00:00.000 |
asset_id | text | Unique identifier assigned to each of the installed seat. | 1% | Color: Black ()Color: Leaning Bar ()Color: Silver () |
asset_subtype | categorical | The type of the seating feature if it is backed or not-backed and the version number. | 0% | BACKLESS 2.0BACKED 1.0BACKED 2.0of 7 |
latitude | float | The geographic coordinate of the seating feature in decimal degrees. | 0% | 40.7091483440.60329340.583924 |
longitude | float | The geographic coordinate of the seating feature in decimal degrees. | 0% | -73.95909361-73.901172-73.897777 |
siteid | text | Unique identifier assigned to the installation site | 0% | SEAT.2016.0050SEAT.2023.0393SEAT.2017.0229 |
ntaname | text | Neighborhood Tabulation Area, the name of the New York City neighborhood the seating feature is located in. | 0% | Far Rockaway-BayswaterBedford-Stuyvesant (East…Bay Ridge |
femafldz | categorical | FEMA flood zone code for the seating feature | 0% | XAEAof 3 |
femafldt | categorical | FEMA flood zone description for the seating feature | 3% | AREA OF MINIMAL FLOOD HA…0.2 PCT ANNUAL CHANCE FL…FLOODWAYof 3 |
hrcevac | categorical | The hurricane evacuation zone of the seating feature | 0% | X61of 7 |