From a 500-row sample across 6 columns.
oftcodeboroughcodthe_geomoftcodeonstreetnatostreetna+2| the_geom | oftcode | boroughcod | onstreetna | fromstreet | tostreetna |
|---|---|---|---|---|---|
| {"type":"MultiLineString","coordinates":[[[-73.98843048074278,40.723259837999635],[-73.98859501475532,40.72299697862671],[-73.98863862792096,40.72293371945398]]]} | 110010111610117010 | M | 1 AVENUE | ALLEN STREET | EAST 1 STREET |
| {"type":"MultiLineString","coordinates":[[[-73.98843048074278,40.723259837999635],[-73.98797056968542,40.723914885263326]]]} | 110010117010117030 | M | 1 AVENUE | EAST 1 STREET | EAST 2 STREET |
| {"type":"MultiLineString","coordinates":[[[-73.98797056968542,40.723914885263326],[-73.98749104757336,40.72457376287186]]]} |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | Geometry column | — | — |
oftcode | text | A unique numerical 18 digit code for the On street- From street- To street of the block to match in LION StreetCode field. | 0% | 113610137750137790456490467990468490110010117350131720 |
boroughcod | categorical | The borough of the street segment in one letter format. | 0% | MQBof 6 |
onstreetna | text | The name of the street where the construction embargo is taking place. | 0% | BROADWAYNORTHERN BOULEVARD5 AVENUE |
GET /api/datasets/4te8-9n3p GET /api/datasets/4te8-9n3p/quality GET /api/datasets/4te8-9n3p/related GET /api/columns?dataset=4te8-9n3p
the_geomthe_geom| 110010117030117050 |
| M |
| 1 AVENUE |
| EAST 2 STREET |
| EAST 3 STREET |
| {"type":"MultiLineString","coordinates":[[[-73.98749104757336,40.72457376287186],[-73.98704399194158,40.72519130151169]]]} | 110010117050117070 | M | 1 AVENUE | EAST 3 STREET | EAST 4 STREET |
| {"type":"MultiLineString","coordinates":[[[-73.98704399194158,40.72519130151169],[-73.98660321952282,40.72577807680722]]]} | 110010117070117090 | M | 1 AVENUE | EAST 4 STREET | EAST 5 STREET |
| {"type":"MultiLineString","coordinates":[[[-73.98660321952282,40.72577807680722],[-73.98616358058572,40.726398231472096]]]} | 110010117090117110 | M | 1 AVENUE | EAST 5 STREET | EAST 6 STREET |
| {"type":"MultiLineString","coordinates":[[[-73.98616358058572,40.726398231472096],[-73.9857384194535,40.72697455933437]]]} | 110010117110117130 | M | 1 AVENUE | EAST 6 STREET | EAST 7 STREET |
| {"type":"MultiLineString","coordinates":[[[-73.9857384194535,40.72697455933437],[-73.98529382893115,40.72759283780792]]]} | 110010117130131090 | M | 1 AVENUE | EAST 7 STREET | ST MARKS PLACE |
| {"type":"MultiLineString","coordinates":[[[-73.984857631691,40.728176833250224],[-73.98443161455366,40.72876843766956]]]} | 110010117170117190 | M | 1 AVENUE | EAST 9 STREET | EAST 10 STREET |
| {"type":"MultiLineString","coordinates":[[[-73.98529382893115,40.72759283780792],[-73.984857631691,40.728176833250224]]]} | 110010117170131090 | M | 1 AVENUE | EAST 9 STREET | ST MARKS PLACE |
fromstreet |
| text |
| The closest intersection to the on street in one direction. |
| 0% |
BENDBROADWAY6 AVENUE |
tostreetna | text | The closest intersection to the on street in the opposite direction. | 0% | BENDNYCTA SUBWAYBROADWAY |