From a 500-row sample across 22 columns.
femafldt:@computed_region_efsh_h5xi:@computed_region_f5dn_yrer+14femafldtassemdistcoundist+9:@computed_region_efsh_h5xi:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+4Mappable — Socrata point column `the_geom`.
Open on the map →| the_geom | borocode | boroname | borocd | coundist | assemdist | stsendist | congdist | location | borough | date_insta | point_x |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40.63036, -74.00413 | 3 | Brooklyn | 310 | 43 | 49 | 17 | 10 | 11 Avenue and 62 Street | Brooklyn | 2023-11-03T00:00:00.000 | -74.004136 |
| 40.74377, -73.97351 | 1 |
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.838…{'coordinates': [-73.965…{'coordinates': [-73.877… |
borocode | categorical | The borough which the access pedestrian signal (APS) was located in. | 0% | 342of 5 |
boroname | categorical | The name of the borough where the accessible pedestrian signal was installed. | 0% | BrooklynQueensBronxof 5 |
borocd | text | The three digit number that represents the borough and the community district. |
GET /api/datasets/de3m-c5p4 GET /api/datasets/de3m-c5p4/quality GET /api/datasets/de3m-c5p4/related GET /api/columns?dataset=de3m-c5p4
location:@computed_region_efsh_h5xi:@computed_region_f5dn_yrer+4:@computed_region_efsh_h5xi:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+3borough| Manhattan |
| 106 |
| 4 |
| 74 |
| 59 |
| 12 |
| 1 Avenue and East 34 Street |
| Manhattan |
| 2022-06-03T00:00:00.000 |
| -73.973511 |
| 40.63366, -74.12944 | 5 | Staten Island | 501 | 49 | 61 | 23 | 11 | Castleton Avenue and Jewett Avenue | Staten Island | 2025-06-02T00:00:00.000 | -74.12944 |
| 40.62980, -74.07467 | 5 | Staten Island | 501 | 49 | 61 | 23 | 11 | Front Street and Wave Street | Staten Island | 2023-09-22T00:00:00.000 | -74.074671 |
| 40.63023, -74.10819 | 5 | Staten Island | 501 | 49 | 63 | 24 | 11 | Forest Avenue and Davis Avenue | Staten Island | 2019-08-30T00:00:00.000 | -74.108194 |
| 40.62654, -74.09158 | 5 | Staten Island | 501 | 49 | 63 | 24 | 11 | Victory Boulevard and Eddy Street | Staten Island | 2014-09-04T00:00:00.000 | -74.091582 |
| 40.56391, -74.11636 | 5 | Staten Island | 502 | 50 | 64 | 24 | 11 | Hylan Boulevard and Tysens Lane | Staten Island | 2019-10-22T00:00:00.000 | -74.116363 |
| 40.64020, -74.13668 | 5 | Staten Island | 501 | 49 | 61 | 23 | 11 | Richmond Terrace and Sharpe Avenue | Staten Island | 2015-05-18T00:00:00.000 | -74.136685 |
| 40.56978, -74.10844 | 5 | Staten Island | 502 | 50 | 64 | 24 | 11 | New Dorp Lane and Between Hylan Boulevard and Mill Road (Pedestrian Crossing) | Staten Island | 2018-10-19T00:00:00.000 | -74.10844 |
| 40.61641, -74.10351 | 5 | Staten Island | 501 | 49 | 63 | 24 | 11 | Victory Boulevard and Clove Road | Staten Island | 2018-05-01T00:00:00.000 | -74.103509 |
Showing 12 of 22 columns. All of them are listed below.
| 0% |
501502503 |
coundist | text | The Council District where the accessible pedestrian signal was installed. | 0% | 504951 |
assemdist | text | The Assembly District where the accessible pedestrian signal was installed. | 0% | 636264 |
stsendist | text | The State Senate District where the accessible pedestrian signal was installed. | 0% | 243223 |
congdist | categorical | The Congressional District where the accessible pedestrian signal was installed. | 0% | 11157of 13 |
location | text | The location of the two street intersections where the accessible pedestrian signals were installed. | 0% | Fulton Street and Troy A…East 170 Street and 150'…Beach Channel Drive and … |
borough | categorical | Same as BoroName | 0% | BrooklynQueensBronxof 5 |
date_insta | datetime | The date the accessible pedestrian signal was installed. | 0% | 2024-01-10T00:00:00.0002024-12-18T00:00:00.0002023-11-14T00:00:00.000 |
point_x | float | The geographic coordinate of the accessible pedestrian signal in decimal degrees. | 0% | -73.961093-73.950159-73.992727 |
point_y | float | The geographic coordinate of the accessible pedestrian signal in decimal degrees. | 0% | 40.81631940.81765740.757847 |
femafldz | categorical | FEMA flood zone code for the accessible pedestrian signal. | 0% | XAEAof 3 |
femafldt | categorical | FEMA flood zone description for the accessible pedestrian signal. | 3% | AREA OF MINIMAL FLOOD HA…0.2 PCT ANNUAL CHANCE FL…FLOODWAYof 3 |
hrcevac | categorical | The hurricane evacuation zone of the accessible pedestrian signal. | 63% | 654of 6 |
ntaname | text | — | 0% | South Ozone ParkNew Springville-Willowbr…Westerleigh-Castleton Co… |