From a 500-row sample across 30 columns.
directionlongitudentanamelongitude:@computed_region_f5dn_yrer+6directionMappable — Socrata point column `location`.
Open on the map →| boroname | borocode | borocd | coundist | assemdist | stsendist | congdist | stopname | corner | busstopid | routes | direction |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Brooklyn | 3 | 311 | 43 | 49 | 17 | 9 | 18 AV & 62 ST | SW | 300898 | B8 | WB |
| Brooklyn | 3 | 306 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
boroname | categorical | The name of the borough where the seating feature was installed | 0% | ManhattanStaten IslandBrooklynof 5 |
borocode | categorical | The one digit borough code number where the seating feature was installed. | 0% | 153of 5 |
borocd | integer | The three digit number that represents the borough and the community district. | 0% | 501108502 |
coundist | integer | The Council District where the seating feature was installed | 0% | 49 |
GET /api/datasets/g9jx-npbk GET /api/datasets/g9jx-npbk/quality GET /api/datasets/g9jx-npbk/related GET /api/columns?dataset=g9jx-npbk
:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q:@computed_region_92fq_4b7q+1| 39 |
| 44 |
| 26 |
| 10 |
| 5 AV & 7 ST |
| NE |
| 308206 |
| B63 |
| NB |
| Staten Island | 5 | 501 | 49 | 63 | 24 | 11 | CLOVE RD & SCHOHARIE ST (SW Corner) 200612 | SW | 200612 | S53 , S66 | Eastbound |
| Manhattan | 1 | 105 | 3 | 75 | 28 | 12 | W 49 ST & 7 AV 404035 | — | 404035 | M50 | Westbound |
| Staten Island | 5 | 502 | 51 | 63 | 24 | 11 | RICHMOND HILL RD & VASSAR ST 202990 | — | 202990 | S91 LTD, S61 | Northbound / Eastbound |
| Brooklyn | 3 | 311 | 43 | 47 | 17 | 11 | BAY PKY & 67 ST | SW | 300658 | B6 LTD, B6 | WB |
| Queens | 4 | 403 | 22 | 35 | 13 | 14 | 82 ST & ASTORIA BL 550724 | — | 550724 | Q47 , Q69 | Southbound |
| Staten Island | 5 | 501 | 49 | 63 | 23 | 11 | CANAL ST & TAPPEN PARK(SW Corner)202788 | SW | 202788 | SIM30 | Northbound |
| Staten Island | 5 | 502 | 50 | 64 | 23 | 11 | NARROWS RD S (LIE) & HYLAN BL (SE Corner) 203343 | SE | 203343 | SIM35 | Eastbound / Northbound |
| Staten Island | 5 | 501 | 50 | 61 | 24 | 11 | MANOR RD & FOREST AV (SW Corner) 203049 | SW | 203049 | S54 | Southbound |
Showing 12 of 30 columns. All of them are listed below.
504assemdist | integer | The Assembly District where the seating feature was installed | 0% | 616373 |
stsendist | integer | The State Senate District where the seating feature was installed. | 0% | 232824 |
congdist | categorical | The Congressional District where the seating feature was installed | 0% | 111210of 11 |
stopname | text | The location or street intersection associated with the bus stop | 0% | 30 AV & 31 ST39 ST & 9 AVSEAGIRT BL & BEACH 17 ST |
corner | categorical | The compass direction the bus stop is facing. | 21% | SESWNEof 5 |
busstopid | integer | The six (6) digit unique identification code assigned to the bus stop by the MTA. | 0% | 550741550137550424 |
routes | text | The bus route(s) that stops at the bus stop. | 2% | M31M15B63 |
direction | categorical | The compass direction the bus travel towards. | 3% | NorthboundSouthboundEastboundof 18 |
notes | text | Comments on the status and additional location information for the RTPI installations. | 32% | --St George- |
elected_official | text | The last name of elected official who requested for the RTPI location and borough identification. | 2% | Oddo (SI)Garodnick (M)Kallos (M) |
wo | text | The work order number assigned for the RTPI sign installations. | 2% | E176E106E151 |
wireless_communication | categorical | The wireless communication company used to connect and obtain the bus time information. | 2% | AT&TNYCWiNNYCWINof 5 |
release_date | datetime | The date the Real Time Passenger Information (RTPI) sign installation was released. | 46% | 2020-03-07T00:00:00.0002019-09-17T00:00:00.0002018-04-11T00:00:00.000 |
rtpi_complete | datetime | The date the Real Time Passenger Information (RTPI) sign installation was completed | 4% | 2017-12-15T00:00:00.0002017-10-20T00:00:00.0002018-10-26T00:00:00.000 |
lat | float | The geographic coordinate of the seating feature in decimal degrees. | 0% | 40.85696340.6707540.569271 |
longitude | float | The geographic coordinate of the seating feature in decimal degrees. | 0% | -73.863805-73.986637-73.932382 |
ntaname | text | Neighborhood Tabulation Area, the name of the New York City neighborhood the seating feature is located in. | 2% | Grasmere-Arrochar-South …Upper East Side-Lenox Hi…Upper East Side-Carnegie… |
femafldz | categorical | FEMA flood zone code for the seating feature | 2% | XAEof 2 |
femafldt | categorical | FEMA flood zone description for the seating feature. | 6% | AREA OF MINIMAL FLOOD HA…0.2 PCT ANNUAL CHANCE FL…of 2 |
hrcevac | categorical | The hurricane evacuation zone of the seating feature. | 2% | X61of 7 |
location | coordinate | — | 0% | {'coordinates': [-73.863…{'coordinates': [-73.741…{'coordinates': [-73.932… |