From a 500-row sample across 9 columns.
the_geomgeoboroughdateprot_1+4the_geomthe_geomshape_stleoftcode| the_geom | oftcode | geoborough | onstreetna | fromstreet | tostreetna | dateprotec | dateprot_1 | shape_stle |
|---|---|---|---|---|---|---|---|---|
| {"type":"MultiLineString","coordinates":[[[-73.98797056968542,40.72391488526349],[-73.98813190068506,40.72368510374759],[-73.98817210480401,40.72362784179775],[-73.98843048074278,40.723259837999805]]]} | 110010117010117030 | M | 1 AVENUE | EAST 1 STREET | EAST 2 STREET | 2026-10-01T00:00:00.000 | 2031-10-01T00:00:00.000 | 270.567368669 |
| {"type":"MultiLineString","coordinates":[[[-73.98797056968542,40.72391488526349],[-73.98749104757336,40.724573762872005]]]} |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | — | — | — |
oftcode | text | A 18 digit code consisting of three 6-digit street codes representing On-From-To streets as returned by GeoSupport functions. | 0% | 451390413640413940328750344330348430412040426990463290 |
geoborough | categorical | This column contains a single letter character representing the borough code that the protected street is located in. | 0% | QBSof 5 |
onstreetna | text | The name of the street protected under this entry. | 0% | BROADWAY3 AVENUE5 AVENUE |
GET /api/datasets/wyih-3nzf GET /api/datasets/wyih-3nzf/quality GET /api/datasets/wyih-3nzf/related GET /api/columns?dataset=wyih-3nzf
| 110010117030117050 |
| M |
| 1 AVENUE |
| EAST 2 STREET |
| EAST 3 STREET |
| 2026-10-01T00:00:00.000 |
| 2031-10-01T00:00:00.000 |
| 274.389986665 |
| {"type":"MultiLineString","coordinates":[[[-73.98749104757336,40.724573762872005],[-73.98704399194158,40.725191301511835]]]} | 110010117050117070 | M | 1 AVENUE | EAST 3 STREET | EAST 4 STREET | 2026-10-02T00:00:00.000 | 2031-10-02T00:00:00.000 | 256.854816157 |
| {"type":"MultiLineString","coordinates":[[[-73.98704399194158,40.725191301511835],[-73.98660321952282,40.725778076807366]]]} | 110010117070117090 | M | 1 AVENUE | EAST 4 STREET | EAST 5 STREET | 2026-10-05T00:00:00.000 | 2031-10-05T00:00:00.000 | 246.227176416 |
| {"type":"MultiLineString","coordinates":[[[-73.98660321952282,40.725778076807366],[-73.98616358058572,40.72639823147227]]]} | 110010117090117110 | M | 1 AVENUE | EAST 5 STREET | EAST 6 STREET | 2026-10-05T00:00:00.000 | 2031-10-05T00:00:00.000 | 256.706864677 |
| {"type":"MultiLineString","coordinates":[[[-73.98616358058572,40.72639823147227],[-73.9857384194535,40.726974559334536]]]} | 110010117110117130 | M | 1 AVENUE | EAST 6 STREET | EAST 7 STREET | 2026-10-05T00:00:00.000 | 2031-10-05T00:00:00.000 | 240.781708395 |
| {"type":"MultiLineString","coordinates":[[[-73.984857631691,40.728176833250394],[-73.98443161455366,40.7287684376697]]]} | 110010117170117190 | M | 1 AVENUE | EAST 9 STREET | EAST 10 STREET | 2026-10-06T00:00:00.000 | 2031-10-06T00:00:00.000 | 245.762840638 |
| {"type":"MultiLineString","coordinates":[[[-73.98443161455366,40.7287684376697],[-73.98399733806507,40.729369684665905]]]} | 110010117190117210 | M | 1 AVENUE | EAST 10 STREET | EAST 11 STREET | 2026-10-06T00:00:00.000 | 2031-10-06T00:00:00.000 | 249.943436585 |
| {"type":"MultiLineString","coordinates":[[[-73.98399733806507,40.729369684665905],[-73.983535924959,40.730007728080885]]]} | 110010117210117230 | M | 1 AVENUE | EAST 11 STREET | EAST 12 STREET | 2026-10-06T00:00:00.000 | 2031-10-06T00:00:00.000 | 265.314082734 |
| {"type":"MultiLineString","coordinates":[[[-73.983535924959,40.730007728080885],[-73.98306946963021,40.73065522599062]]]} | 110010117230117250 | M | 1 AVENUE | EAST 12 STREET | EAST 13 STREET | 2022-09-20T00:00:00.000 | 2027-09-20T00:00:00.000 | 269.005470244 |
fromstreet |
| text |
| The closest cross-street to one end of the protected street |
| 0% |
DEAD ENDBENDBROADWAY |
tostreetna | text | The closest cross-street to the other end of the protected street | 0% | DEAD ENDBENDLINDEN BOULEVARD |
dateprotec | datetime | First date that the street is protected | 0% | 2023-09-29T00:00:00.0002024-08-20T00:00:00.0002021-11-16T00:00:00.000 |
dateprot_1 | datetime | Final date that the street is protected | 0% | 2028-09-29T00:00:00.0002029-08-20T00:00:00.0002027-10-26T00:00:00.000 |
shape_stle | float | The length of the road segment protected in this entry, in inches. | 0% | 789.476171612437.587433946717.07282428 |