From a 500-row sample across 28 columns.
the_geomstatusshape_lengthe_geomstatusshape_lengthe_geomstatusshape_lengthe_geomstatusshape_lengHas borough codes (`borocode`) — joinable, but needs boundary shapes to draw.
| the_geom | physicalid | l_low_hn | l_high_hn | r_low_hn | r_high_hn | l_zip | r_zip | l_blkfc_id | r_blkfc_id | st_label | status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiLineString","coordinates":[[[-74.01793061274537,40.70617486563979],[-74.01786933958108,40.70634871855227],[-74.01778897787625,40.70651868456784],[-74.01769028387064,40.70668296244674],[-74.01757437049282,40.70683986715218]]]} | 3 | 50 | 64 | 51 | 63 | 10280 | 10280 | 212262587 | 1222601917 | BATTERY PL |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | — | — | — |
physicalid | integer | — | 0% | 169321168859167082 |
l_low_hn | text | — | 30% | 012 |
l_high_hn | text | — | 30% | 099199 |
r_low_hn | text | — | 30% | 02 |
GET /api/datasets/fytp-pq92 GET /api/datasets/fytp-pq92/quality GET /api/datasets/fytp-pq92/related GET /api/columns?dataset=fytp-pq92
the_geomstatusshape_lengthe_geomstatusshape_lengthe_geomstatusshape_lengthe_geomstatusshape_leng| 2 |
| {"type":"MultiLineString","coordinates":[[[-74.01757437049282,40.70683986715218],[-74.01712051881411,40.70746253088078]]]} | 5 | 66 | 82 | 65 | 81 | 10280 | 10280 | 1222600642 | 1222604562 | BATTERY PL | 2 |
| {"type":"MultiLineString","coordinates":[[[-74.01712051881411,40.70746253088078],[-74.01662578576105,40.70813393464956]]]} | 6 | 84 | 98 | 83 | 101 | 10280 | 10280 | 1222600640 | 1222600933 | BATTERY PL | 2 |
| {"type":"MultiLineString","coordinates":[[[-74.01693786186667,40.704813986597024],[-74.01704963744208,40.70483662931336]]]} | 8 | — | — | — | — | 10280 | 10280 | 212262587 | 1222600931 | BATTERY PL | 2 |
| {"type":"MultiLineString","coordinates":[[[-74.01428922948978,40.70454907535256],[-74.01437031212745,40.70455803784475],[-74.01451712300867,40.704605675392386],[-74.01466709872304,40.70464721296995],[-74.01478059501136,40.704674113029824],[-74.01489542085365,40.70469751835281],[-74.014961252156,40.70475979724394]]]} | 14 | — | — | — | — | 10004 | 10004 | 212262587 | 212262395 | BATTERY PL | 2 |
| {"type":"MultiLineString","coordinates":[[[-74.01739796591468,40.70845740994716],[-74.01814846679568,40.70879516565625]]]} | 23 | 300 | 398 | 301 | 399 | 10280 | 10280 | 1222600637 | 1222607193 | W THAMES ST | 2 |
| {"type":"MultiLineString","coordinates":[[[-74.01662578576105,40.70813393464956],[-74.01739796591468,40.70845740994716]]]} | 24 | 200 | 298 | 201 | 299 | 10280 | 10280 | 1222600639 | 1222602788 | W THAMES ST | 2 |
| {"type":"MultiLineString","coordinates":[[[-74.01616698119132,40.707904615235336],[-74.01662578576105,40.70813393464956]]]} | 25 | 136 | 198 | 137 | 199 | 10280 | 10280 | 1222600934 | 1222602788 | W THAMES ST | 2 |
| {"type":"MultiLineString","coordinates":[[[-74.01699521616094,40.7058000436678],[-74.01793061274537,40.70617486563979]]]} | 29 | — | — | — | — | 10280 | 10280 | 1222606410 | 1222601914 | 1 PL | 2 |
| {"type":"MultiLineString","coordinates":[[[-74.01793061274537,40.70617486563979],[-74.01869417782103,40.706511760458845]]]} | 30 | — | — | — | — | 10280 | 10280 | 0 | 0 | 1 PL | 2 |
Showing 12 of 26 columns. All of them are listed below.
1r_high_hn | text | — | 30% | 09899 |
l_zip | text | — | 1% | 103141031210306 |
r_zip | text | — | 1% | 103141031210306 |
l_blkfc_id | integer | — | 0% | 0822604061322600033 |
r_blkfc_id | integer | — | 0% | 02226104882260409 |
st_label | text | — | 0% | ALLEYBROADWAYCONNECTOR |
status | categorical | — | 0% | 254of 3 |
bike_lane | categorical | — | 89% | 213of 8 |
borocode | categorical | — | 0% | 432of 5 |
st_width | integer | — | 0% | 30.00.040.0 |
created | datetime | — | 0% | 2007-11-29T00:00:00.0002009-06-16T00:00:00.0002015-12-18T00:00:00.000 |
modified | datetime | — | 0% | 2020-08-28T00:00:00.0002017-03-17T00:00:00.0002019-04-15T00:00:00.000 |
trafdir | categorical | — | 0% | TWFTTFof 4 |
rw_type | categorical | — | 0% | 162of 13 |
frm_lvl_co | categorical | — | 0% | 13179of 18 |
to_lvl_co | categorical | — | 0% | 13179of 18 |
snow_pri | categorical | — | 9% | CSHof 4 |
pre_modifi | categorical | — | 100% | OLDLITTLEof 2 |
pre_direct | categorical | — | 92% | EWNof 4 |
pre_type | categorical | — | 99% | AVEBCHALYof 7 |
post_type | text | — | 15% | AVESTRD |
post_direc | categorical | — | 99% | ESWof 4 |
post_modif | text | — | 100% | APPROACHBRIDGETRANSVERSE |
full_stree | text | — | 0% | ALLEYBROADWAYCONNECTOR |
st_name | text | — | 0% | ALLEYBROADWAY3 |
bike_trafd | categorical | — | 88% | TWFTTFof 4 |
shape_leng | float | — | 0% | 520.214339922224.635925318118.622442225 |