From a 500-row sample across 11 columns.
oftuniqueidborough_code+6tostreetnameonstreetnamefromstreetnamethe_geomoftthe_geomHas borough codes (`borough_code`) — joinable, but needs boundary shapes to draw.
| the_geom | segmentid | oft | onstreetname | fromstreetname | tostreetname | borough_code | work_start_date | work_end_date | uniqueid | purpose |
|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiLineString","coordinates":[[[-74.16024419490465,40.62649742420574],[-74.16044585040947,40.62485408758563]]]} | 5587 | 550391529150529338 | SUMMERFIELD PLACE | FOREST AVENUE | FRANCESCA LANE | S | 2026-09-02T00:00:00.000 | 2026-10-28T00:00:00.000 | a5a11d1c5d592041e13a20de056952d2734359896cf50d78a17c1c5b1b2ea3a8 | DOT IN-HOUSE PAVING |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | geometry column | — | — |
segmentid | integer | The Segment ID is a Department of City Planning LION reference number. | 0% | 3582223223117788 |
oft | integer | A 18 digit code consisting of three 6-digit street codes representing On-From-To (OFT) streets as returned by GeoSupport functions. | 0% | 437290410740410940134290110910111010374630305280305430 |
onstreetname | text | The On Street Name as is defined in GOAT, the Department of City Planning Geographic Online Address Translator (GOAT). | 0% | BROADWAYUNION TURNPIKEROCKAWAY FREEWAY |
GET /api/datasets/i6b5-j7bu GET /api/datasets/i6b5-j7bu/quality GET /api/datasets/i6b5-j7bu/related GET /api/columns?dataset=i6b5-j7bu
the_geomthe_geomtostreetnameonstreetnamefromstreetname| {"type":"MultiLineString","coordinates":[[[-74.16745896468379,40.63718671781424],[-74.16750787661039,40.63587612807383]]]} | 5707 | 516400516410518600 | ARLINGTON AVENUE | ARLINGTON PLACE | BENJAMIN PLACE | S | 2026-09-02T00:00:00.000 | 2026-10-27T00:00:00.000 | 77eecd0f3e50e95cc694d13140d655b5ef74571fe5a637ec5f2157f273320312 | DOT IN-HOUSE PAVING |
| {"type":"MultiLineString","coordinates":[[[-74.14995311131533,40.54400039343099],[-74.15096395728875,40.54415086192787]]]} | 6097 | 533125527365536532 | HILLTOP PLACE | ELEANOR LANE | LINDENWOOD ROAD | S | 2026-09-16T00:00:00.000 | 2026-10-16T00:00:00.000 | de0ed20ec66ca8f74991e32ad460354c1022e8a7ea9220d5cc194bf3f13e4a74 | TRIBUTARY INSTALL - GAS |
| {"type":"MultiLineString","coordinates":[[[-74.1230900229341,40.57324661051512],[-74.12138815384195,40.572223667623184]]]} | 10348 | 517730515650544005 | BEACH AVENUE | AMBOY ROAD | PROSPECT PLACE | S | 2026-09-16T00:00:00.000 | 2026-10-30T00:00:00.000 | dd7e4bddfb031553f4b1e3cfaba065e2364dc36099e1283787b08a14091fe71c | DOT IN-HOUSE PAVING |
| {"type":"MultiLineString","coordinates":[[[-74.11850993861567,40.57046972157031],[-74.11778585691737,40.57006205092864]]]} | 10515 | 517730557700557710 | BEACH AVENUE | 8 STREET | 9 STREET | S | 2026-09-16T00:00:00.000 | 2026-10-30T00:00:00.000 | e83502b639a67cb669ee5108091f204eee7dcdfc2249293a28dc1b5ab32662b5 | DOT IN-HOUSE PAVING |
| {"type":"MultiLineString","coordinates":[[[-73.98123713564817,40.600836699721675],[-73.98078354032299,40.59844739496001]]]} | 19343 | 390930314530314580 | WEST 9 STREET | AVENUE S | AVENUE T | B | 2026-10-13T00:00:00.000 | 2026-10-14T00:00:00.000 | ef8e5f7d0e4e49459e0b79e99562d52b99d5aecfcb4f427496aa646dc84c9007 | DOT IN-HOUSE MILLING |
| {"type":"MultiLineString","coordinates":[[[-73.98123713564817,40.600836699721675],[-73.98078354032299,40.59844739496001]]]} | 19343 | 390930314530314580 | WEST 9 STREET | AVENUE S | AVENUE T | B | 2026-10-08T00:00:00.000 | 2026-10-12T00:00:00.000 | 9eecfe968c3fe1c0ad6efb291aaa38e19dcda6301d8228558a2f5f162ddfe947 | DOT IN-HOUSE MILLING |
| {"type":"MultiLineString","coordinates":[[[-74.01302317665764,40.608030421045804],[-74.01469487596684,40.60642428321307]]]} | 19383 | 306580315780330630 | 15 AVENUE | BATH AVENUE | CROPSEY AVENUE | B | 2026-10-08T00:00:00.000 | 2026-10-13T00:00:00.000 | 395b7fef0d3a3ea5c536e75c8c7242e6141b3bc545ad88390adb30262501a883 | DOT IN-HOUSE PAVING |
| {"type":"MultiLineString","coordinates":[[[-74.01302317665764,40.608030421045804],[-74.01469487596684,40.60642428321307]]]} | 19383 | 306580315780330630 | 15 AVENUE | BATH AVENUE | CROPSEY AVENUE | B | 2026-10-14T00:00:00.000 | 2026-10-14T00:00:00.000 | 1520340dc6781cac43e050f7c9358da2165862f0eafc2d7ca6867611039cec1f | DOT IN-HOUSE PAVING |
| {"type":"MultiLineString","coordinates":[[[-74.01127852782564,40.60970614277791],[-74.01302317665764,40.608030421045804]]]} | 19479 | 306580315780319030 | 15 AVENUE | BATH AVENUE | BENSON AVENUE | B | 2026-10-14T00:00:00.000 | 2026-10-14T00:00:00.000 | a984026d9a11a80ddc5646f5b51e234b54b378a74468b200aa356d9ef30aca21 | DOT IN-HOUSE PAVING |
fromstreetname | text | From Street Name refers to the cross street where the lowest house numbers of the on-street begins, or as defined in GOAT. | 0% | BEND9 AVENUEMADISON AVENUE |
tostreetname | text | To Street Name refers to the cross street where the highest house numbers of the on-street ends, or as defined un GOAT. | 0% | PARK AVENUEBEND10 AVENUE |
borough_code | categorical | New York City is composed of five boroughs, each borough has a code as an identifier. | 0% | QMBof 5 |
work_start_date | datetime | The Work Start Date is the date the permit holder can begin the work. | 0% | 2026-09-01T00:00:00.0002026-08-19T00:00:00.0002026-10-05T00:00:00.000 |
work_end_date | datetime | The Work End Date is the permit expiration date. | 0% | 2026-10-30T00:00:00.0002026-11-27T00:00:00.0002026-11-09T00:00:00.000 |
uniqueid | text | Unique hexadecimal identification number of each entry. | 0% | f35340dbe8461ca5e4e7ead3…6e4da9a31a465e0ba40285e9…a86d1f2364d38c57169f38e8… |
purpose | text | Type of work being done at location. | 0% | DOT IN-HOUSE PAVINGDOT IN-HOUSE MILLINGOCCUPANCY OF ROADWAY AS … |