From a 500-row sample across 23 columns.
ll_typefeat_typell_limits+20ll_typefeat_typell_limits+20the_geomfeat_typeboroughthe_geomMappable — Socrata point column `the_geom`.
Open on the map →| the_geom | borough | feat_type | official_nm | honor_name | old_name | ulurpcpnum | intro_num | intro_year | intro_month | intro_day | ll_num |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40.58414, -74.08912 | Staten Island | Intersection name | None | Vincent S. Chiara Way | None | none | 0471 | 2004 | 10 | 13 | 063 |
| 40.60670, -74.01082 | Brooklyn |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | coordinate | — | 0% | {'coordinates': [-73.861…{'coordinates': [-73.999…{'coordinates': [-73.915… |
borough | categorical | — | 0% | Staten IslandQueensBrooklynof 6 |
feat_type | categorical | — | 7% | Intersection nameCorner namePlaza nameof 8 |
official_nm | categorical | — | 0% |
GET /api/datasets/y23c-72fa GET /api/datasets/y23c-72fa/quality GET /api/datasets/y23c-72fa/related GET /api/columns?dataset=y23c-72fa
boroughthe_geomfeat_typeboroughthe_geomborough| Intersection name |
| None |
| Rita Blau Way |
| None |
| none |
| 0471 |
| 2004 |
| 10 |
| 13 |
| 063 |
| 40.77114, -73.98347 | Manhattan | Intersection name | None | Jerome Robbins Place | None | none | 0471 | 2004 | 10 | 13 | 063 |
| 40.60099, -73.95776 | Brooklyn | Intersection name | None | Luther Mook Corner | None | none | 0471 | 2004 | 10 | 13 | 063 |
| 40.62468, -74.00987 | Brooklyn | Corner name | None | Charles J. Mauro 9/11 Memorial Way | None | none | 0471 | 2004 | 10 | 13 | 063 |
| 40.60358, -74.13343 | Staten Island | Intersection name | None | Detective Frank P. Collins Street | None | none | 0471 | 2004 | 10 | 13 | 063 |
| 40.63714, -74.02547 | Brooklyn | Intersection name | None | Kathleen Hunt Casey 9/11 Memorial Way | None | none | 0471 | 2004 | 10 | 13 | 063 |
| 40.61409, -74.07254 | Staten Island | Corner name | None | John Crispino Way | None | none | 0471 | 2004 | 10 | 13 | 063 |
| 40.59631, -73.98028 | Brooklyn | Corner name | None | Constantino Tino DeCorato Way | None | none | 0471 | 2004 | 10 | 13 | 063 |
| 40.60758, -73.94155 | Brooklyn | Intersection name | None | Edward DeSimone III Corner | None | none | 0471 | 2004 | 10 | 13 | 063 |
Showing 12 of 18 columns. All of them are listed below.
NoneFranklin AvenueSt. John Baptist Church …of 17honor_name | text | — | 0% | Red Hook Lane: Heritage …Army SPC. Alex Jimenez W…Mill Street Synagogue/Se… |
old_name | categorical | — | 0% | NonenoneLafayette Streetof 9 |
ulurpcpnum | text | — | 24% | noneof 1 |
intro_num | text | — | 0% | 21879881631 |
intro_year | integer | — | 0% | 201920042003 |
intro_month | categorical | — | 0% | 6121of 13 |
intro_day | integer | — | 0% | 142330 |
ll_num | text | — | 1% | 014048034 |
ll_sec | integer | — | 0% | 14931 |
ll_type | categorical | — | 1% | HonoraryHonorary Nameof 2 |
lleffect_dt | date | — | 0% | 1/17/202107/29/201808/23/2019 |
ll_limits | text | — | 0% | At the intersection of A…At the northeast corner …At the intersection of B… |
limits_er | text | — | 98% | 163rd st and 107th ave d…East 114th St and 5th Av…Error: It's Crown Ave an… |
repealed | categorical | — | 7% | NoYesof 2 |
repeal_dt | text | — | 94% | 7/11/201112/17/20131/19/2020 |
amended | categorical | — | 7% | NoYesof 2 |
amend_dt | text | — | 100% | 2/18/2003of 1 |
amendt_txt | text | — | 100% | FF Manuel Mojica, Jr., F…of 1 |
amdyrllsec | text | — | 100% | 2003/015/28of 1 |