From a 500-row sample across 9 columns.
the_geomstname_labb5_sc+6the_geomthe_geomphysicalid| the_geom | physicalid | objectid | stname_lab | boroughcod | segmentlen | b5_sc | bphys_id | plnt_seas |
|---|---|---|---|---|---|---|---|---|
| NaN, NaN | 48 | 24 | BROAD ST | 1 | 439.18633052 | 113590 | 148 | Fall11 |
| NaN, NaN | 114 | 86 | WATER ST | 1 | 152.06586871 | 133490 | 1114 | Fall13 |
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% | 89137109581109578 |
objectid | integer | — | 0% | 2585595178112163 |
stname_lab | text | — | 0% | 4 AV3 AVBROADWAY |
boroughcod | categorical | — | 0% | 2 |
GET /api/datasets/4bae-3jps GET /api/datasets/4bae-3jps/quality GET /api/datasets/4bae-3jps/related GET /api/columns?dataset=4bae-3jps
the_geomthe_geom| NaN, NaN | 121 | 93 | WATER ST | 1 | 275.84645111 | 133490 | 1121 | Fall13 |
| NaN, NaN | 136 | 108 | RECTOR ST | 1 | 242.51978384 | 129440 | 1136 | Fall11 |
| NaN, NaN | 159 | 131 | CHURCH ST | 1 | 219.08015774 | 115350 | 1159 | Fall11 |
| NaN, NaN | 445 | 389 | WASHINGTON ST | 1 | 241.50051332 | 133390 | 1445 | Fall11 |
| NaN, NaN | 460 | 404 | GREENWICH ST | 1 | 266.00054045 | 121790 | 1460 | Spring12 |
| NaN, NaN | 461 | 405 | GREENWICH ST | 1 | 266.25285658 | 121790 | 1461 | Spring12 |
| NaN, NaN | 462 | 406 | GREENWICH ST | 1 | 264.88602114 | 121790 | 1462 | Spring12 |
| NaN, NaN | 608 | 546 | HUDSON ST | 1 | 230.774752 | 123190 | 1608 | Fall14 |
43segmentlen | float | — | 0% | 656.23583544260.7426179260.59008167 |
b5_sc | text | — | 0% | 305430236420213820 |
bphys_id | integer | — | 0% | 2100832559144258448 |
plnt_seas | text | — | 0% | Spring14Spring12Fall08 |