From a 500-row sample across 20 columns.
borocdboronameshape_leng+4boroshape_lengsegmentid+2the_geomHas borough codes (`boroname`) — joinable, but needs boundary shapes to draw.
| the_geom | borocode | boroname | borocd | coundist | assemdist | stsendist | congdist | street | segmentid | rank | pmp_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiLineString","coordinates":[[[-73.81665096623519,40.674537891716994],[-73.81697215697012,40.673676518346745]]]} | 4 | Queens | 410 | 28,32 | 31 | 10 | 5 | 122 STREET | 0055131 | 4 | 52434 |
| {"type":"MultiLineString","coordinates":[[[-74.25422309679644,40.506165286086755],[-74.25409843517714,40.50581010373064]]]} |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | Description of the spatial file format. | — | — |
borocode | categorical | BoroCode | 0% | 432of 9 |
boroname | categorical | The name of the borough where the exclusive pedestrian signal was installed. | 0% | QueensBrooklynBronxof 9 |
borocd | text | The three digit number that represents the borough and the community district. | 0% | 503501413 |
coundist | text | The Council District where the exclusive pedestrian signal was installed. |
GET /api/datasets/fwpa-qxaf GET /api/datasets/fwpa-qxaf/quality GET /api/datasets/fwpa-qxaf/related GET /api/columns?dataset=fwpa-qxaf
the_geom| 5 |
| Staten Island |
| 503 |
| 51 |
| 62 |
| 24 |
| 11 |
| WARDS POINT AVENUE |
| 0000016 |
| 5 |
| 79811 |
| {"type":"MultiLineString","coordinates":[[[-73.82885385076081,40.69818649304863],[-73.82857671739403,40.697619206118276]]]} | 4 | Queens | 409 | 29 | 24 | 14 | 5 | 120 STREET | 0056031 | 5 | 50784 |
| {"type":"MultiLineString","coordinates":[[[-73.78519954748839,40.718913123226834],[-73.78507988302111,40.718915276356825]]]} | 4 | Queens | 408 | 24 | 24 | 11,14 | 5 | CROYDON ROAD | 0180320 | 5 | 49677 |
| {"type":"MultiLineString","coordinates":[[[-74.15639270712379,40.63249339782305],[-74.15645094302306,40.6313680377706]]]} | 5 | Staten Island | 501 | 49 | 61 | 23 | 11 | MAPLE PARKWAY | 0008394 | 4 | 70756 |
| {"type":"MultiLineString","coordinates":[[[-73.78455804512784,40.736148344558764],[-73.78562333922295,40.73585533437124]]]} | 4 | Queens | 408 | 23 | 25 | 11 | 6 | 186 LANE | 0180353 | 4 | 49278 |
| {"type":"MultiLineString","coordinates":[[[-73.8206673493544,40.61361597166225],[-73.82111415390287,40.61341841774467]]]} | 4 | Queens | 414 | 32 | 23 | 15 | 5 | WEST 3 ROAD | 0169868 | 4 | 66285 |
| {"type":"MultiLineString","coordinates":[[[-73.82068102956953,40.70925206740384],[-73.82014669679974,40.70836596652962]]]} | 4 | Queens | 409 | 29 | 27 | 14 | 6 | VAN WYCK EXPWY SB EN 138 ST | 0056381 | 3 | 50478 |
| {"type":"MultiLineString","coordinates":[[[-73.81955280324064,40.70575498970105],[-73.81927111190532,40.705344886227955]]]} | 4 | Queens | 409 | 29 | 27 | 14 | 6 | 136 STREET | 0056520 | 4 | 50485 |
| {"type":"MultiLineString","coordinates":[[[-73.97579823470531,40.74064461681919],[-73.97441351866321,40.74007516361287]]]} | 1 | Manhattan | 106 | 4,2 | 74 | 27 | 12 | EAST 29 STREET | 0034668 | 3 | 32864 |
Showing 12 of 20 columns. All of them are listed below.
| 0% |
505119 |
assemdist | text | The Assembly District where the exclusive pedestrian signal was installed. | 0% | 626326 |
stsendist | text | The State Senate District where the exclusive pedestrian signal was installed. | 0% | 241115 |
congdist | text | The Congressional District where the exclusive pedestrian signal was installed. | 0% | 1156 |
street | text | The name of the street block. | 0% | BROADWAY3 AVENUE5 AVENUE |
segmentid | text | Unique seven digit identifier from LION. | 0% | 011842101184200080175 |
rank | categorical | The number that correlates with the category for each street block. | 0% | 543of 5 |
pmp_id | integer | Unique identifier used in creation of the sidewalk demand map. | 0% | 690402462331487 |
nta2020 | text | Neighborhood Tabulation Area Code | 0% | SI0304SI0302BX1002 |
boro | categorical | Two letter acronym for the New York City borough. | 0% | QNBKBXof 5 |
category | categorical | The street description for pedestrian mobility program. | 0% | BaselineCommunityNeighborhoodof 5 |
ntaname | text | The name of the New York City neighborhood the signal was installed. | 0% | Annadale-Huguenot-Prince…Great Kills-EltingvilleTodt Hill-Emerson Hill-L… |
femafldz | categorical | FEMA flood zone code for the exclusive pedestrian signal intersection. | 0% | XAEAE,Xof 12 |
femafldt | categorical | FEMA flood zone description for the exclusive pedestrian signal intersection. | 4% | AREA OF MINIMAL FLOOD HA…0.2 PCT ANNUAL CHANCE FL…0.2 PCT ANNUAL CHANCE FL…of 13 |
hrcevac | text | The hurricane evacuation zone of the exclusive pedestrian signal. | 52% | 615 |
shape_leng | float | The length of the line segment in inches. | 0% | 735.862763859542.120360171467.025205563 |