From a 500-row sample across 25 columns.
stsendist:@computed_region_92fq_4b7q:@computed_region_sbqj_enih+14stsendist:@computed_region_92fq_4b7q:@computed_region_sbqj_enih+13stsendisthrcevacfemafldt+8Mappable — Socrata point column `the_geom`.
Open on the map →| the_geom | borocode | boroname | borocd | coundist | assemdist | stsendist | congdist | main_stree | cross_stre | barnes_dan | modified_b |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40.74134, -74.00921 | 1 | Manhattan | 102 | 3 | 66 | 47 | 10 | West St | 13 Street | — | — |
| 40.72387, -73.98208 | 1 | Manhattan |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | coordinate | Geometry column | 0% | {'coordinates': [-73.903…{'coordinates': [-73.825…{'coordinates': [-73.949… |
borocode | categorical | The numerical borough code for the exclusive pedestrian signal. | 0% | 132of 5 |
boroname | categorical | The name of the borough where the exclusive pedestrian signal was installed. | 0% | ManhattanBrooklynBronxof 5 |
borocd | text | The three digit number that represents the borough and the community district. |
GET /api/datasets/8kuj-2n3u GET /api/datasets/8kuj-2n3u/quality GET /api/datasets/8kuj-2n3u/related GET /api/columns?dataset=8kuj-2n3u
stsendisthrcevacfemafldt+9:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+2:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+2:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+2:@computed_region_92fq_4b7q:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+3| 103 |
| 2 |
| 74 |
| 27 |
| 10 |
| Avenue B |
| E 5 Street |
| — |
| — |
| 40.79190, -73.94150 | 1 | Manhattan | 111 | 8 | 68 | 29 | 13 | 2 Avenue | E 108 Street | — | — |
| 40.70873, -73.83062 | 4 | Queens | 409 | 29 | 28 | 14 | 5 | Lefferts Blvd | Grenfeel St & 83 Ave | X | — |
| 40.85843, -73.88512 | 2 | Bronx | 206 | 15 | 78 | 33 | 15 | East Fordham Rd | Arthur Avenue | X | — |
| 40.80575, -73.94275 | 1 | Manhattan | 111 | 9 | 68 | 30 | 13 | 5 Avenue | East 124 Street | — | — |
| 40.70480, -74.01495 | 1 | Manhattan | 101 | 1 | 61 | 27 | 10 | Battery Place | Greenwich Street | — | — |
| 40.84650, -73.89531 | 2 | Bronx | 206 | 15 | 86 | 32 | 15 | East Tremont Avenue | Monterey Avenue | — | — |
| 40.71527, -73.98706 | 1 | Manhattan | 103 | 1 | 65 | 27 | 10 | Clinton Street | Between E. Broadway & Grand St | — | — |
| 40.69205, -73.95190 | 3 | Brooklyn | 303 | 33 | 57 | 25 | 8 | Nostrand Ave | Pulaski St | — | — |
Showing 12 of 25 columns. All of them are listed below.
| 0% |
111101103 |
coundist | text | The Council District where the exclusive pedestrian signal was installed. | 0% | 168 |
assemdist | text | The Assembly District where the exclusive pedestrian signal was installed. | 0% | 686569 |
stsendist | text | The State Senate District where the exclusive pedestrian signal was installed. | 0% | 273028 |
congdist | categorical | The Congressional District where the exclusive pedestrian signal was installed. | 0% | 101312of 13 |
main_stree | text | The major street where the signal was installed on. This intersection has greater traffic volume, larger cross-section, and higher functional class. | 0% | Broadway5 AvenueRiverside Drive |
cross_stre | text | The minor street where the signal was installed on. This intersection is likely to have less traffic volume, a smaller cross-section and a lower functional classification than the major street. | 0% | East 113 Street71 AvenueE 11 Street |
barnes_dan | text | An intersection where car traffic halts for a pre-determined time for pedestrians to cross in all directions free of conflicts. | 0% | Xof 2 |
modified_b | text | The timing of the signals are changed/modified to allow pedestrians additional time for movement during the first phase of a signalized intersection. | 0% | Xof 2 |
mid_block_ | text | Allow pedestrians a formally designated place to cross a street when intersections are spaced too far apart to be convenient. | 0% | Xof 2 |
t_oneway_a | categorical | Exclusive pedestrian crossing applies to the signal all the time (24/7.) | 0% | XxX - 24 hr walkof 4 |
t_oneway_1 | text | Allow pedestrians to cross when all cars stop on the main (the major) street. | 0% | Xof 2 |
installati | text | The date of implementation of exclusive treatment on the intersection. | 0% | 00:00:00.000of 2 |
ntaname | text | The name of the New York City neighborhood the signal was installed. | 0% | Central ParkFinancial District-Batte…Prospect Park |
femafldz | categorical | FEMA flood zone code for the exclusive pedestrian signal intersection. | 0% | XAEof 2 |
femafldt | categorical | FEMA flood zone description for the exclusive pedestrian signal intersection. | 0% | AREA OF MINIMAL FLOOD HA…0.2 PCT ANNUAL CHANCE FL…of 3 |
hrcevac | categorical | The hurricane evacuation zone of the exclusive pedestrian signal. | 0% | X61of 7 |