From a 500-row sample across 14 columns.
boroughintroduced_by_council_memberscoordinates+10boroughcategoryboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| coordinates | intro_number | enactment_date | enactment_year | enactment_number | category | borough | new_name | present_name | limits | zip_code | introduced_by_council_members |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiLineString","coordinates":[[[-73.99423593999995,40.74606458300008],[-73.98748526499998,40.755317251000065]]]} | Int. No. 930 | 1973-08-08T00:00:00.000 | 1973-10-16T00:00:00.000 | 1973/035 | Street | Manhattan | 7th Avenue-Fashion Avenue | 7th Avenue | 26th Street to 41st Street | 10018.0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
coordinates | unknown | Set of x, y coordinates on the map to generate a line | — | — |
intro_number | text | Introduction to the designated number for proposed legislation in the City Council | 0% | Int. No. 318-AInt. No. 252-AInt. No. 437-A |
enactment_date | datetime | The date the City Council approves the bill to rename. | 0% | 2002-09-27T00:00:00.0002003-01-07T00:00:00.0002003-06-03T00:00:00.000 |
enactment_year | datetime | The year the City Council approves the bill to rename. | 0% | 2003-01-01T00:00:00.0002004-01-01T00:00:00.000 |
GET /api/datasets/xesp-yqsx GET /api/datasets/xesp-yqsx/quality GET /api/datasets/xesp-yqsx/related GET /api/columns?dataset=xesp-yqsx
boroughzip_code| Greitzer |
| {"type":"MultiLineString","coordinates":[[[-74.00350632699997,40.713584672000025],[-74.00319638299999,40.71342654500006],[-74.00306376299994,40.713320374000034],[-74.00296243499997,40.71310125400004]]]} | Int. No. 1271 | 1973-08-08T00:00:00.000 | 1973-10-16T00:00:00.000 | 1973/047 | Street | Manhattan | Saint Andrews Plaza | Duane Street | The area of Duane Street between Centre Street and Cardinal Hayes Place. | 10007.0 | Cuite and Sharison |
| {"type":"MultiLineString","coordinates":[[[-73.85230084399996,40.87619074100007],[-73.85298972499999,40.87493940000007]]]} | Int. No. 1223 | 1973-10-12T00:00:00.000 | 1973-10-16T00:00:00.000 | 1973/054 | Street | Bronx | Msgr. Cahill Place | Elwood Place | Between East 212th Street and East 214th Street | 10469.0 | Mercorella |
| {"type":"MultiLineString","coordinates":[[[-73.92023237499996,40.86279257600006],[-73.91996951899995,40.86314756200005]]]} | Int. No. 366 | 1970-12-03T00:00:00.000 | 1970-10-20T00:00:00.000 | 1970/062 | Street | Manhattan | Monsignor Francis J. Kett Plaza | 10th Avenue | 10th Avenue north of 204th Street and south of 205th Street | 10034.0 | Friedland |
| {"type":"MultiLineString","coordinates":[[[-73.83752104499996,40.88536265100004],[-73.83637912099994,40.88488283600003],[-73.83478655999994,40.884239000000036]]]} | Int. No. 706 | 1969-01-15T00:00:00.000 | 1969-10-20T00:00:00.000 | 1969/003 | Street | Bronx | Marolla Place | Eden Terrace | Bounded on the east by Harper Avenue, on the west by Crawford Avenue, running along the southeasterly side of Seton Falls Park. | 10466.0 | Curry, Cuite, Friedland, Katzman, Modugno, Ryan, Smith, Weiss, Rosen, and Ward |
| {"type":"MultiLineString","coordinates":[[[-73.98092885999995,40.71585559700003],[-73.98160108899998,40.71455828200004]]]} | Int. No. 760 | 1969-05-15T00:00:00.000 | 1969-10-20T00:00:00.000 | 1969/024 | Street | Manhattan | Abraham E. Kazan Street | Columbia Street | The area bounded on the south by Grand Street, on the north by Delancey Street. | 10002.0 | Lindsay, Corso, Katzman, Modugno, Ryan, Smith, Thompson, Rosen, and Weiss |
| {"type":"MultiLineString","coordinates":[[[-73.88382299399996,40.876790698000036],[-73.88340591099995,40.87661324100003],[-73.88312427899996,40.876469248000035],[-73.88268573799996,40.87632322600007],[-73.88239190799999,40.87622538900007],[-73.88218818799999,40.87619647100007],[-73.88185291199994,40.876170106000075],[-73.88157798499998,40.87616402200007]]]} | Int. No. 608 | 1996-01-12T00:00:00.000 | 1996-01-01T00:00:00.000 | 1996/004 | Street | Bronx | Jerold Windman Path | Van Cortlandt Avenue East | Between East Mosholu Parkway North and East Mosholue Parkway South | 10458.0 | Eisland Foster, Linares, DeMarco, Rivera, Cruz, Ruiz, Warden, Rosado, O'Donovan |
| {"type":"MultiLineString","coordinates":[[[-73.92644151199994,40.75198039500003],[-73.92648928899996,40.75176768100005]]]} | Int. No. 815 | 1969-06-16T00:00:00.000 | 1969-10-20T00:00:00.000 | 1969/040 | Street | Queens | Standard Lane | 37th Street | An existing street; beginning at a point on the southerly side of Northern Boulevard, distant 1,447.13 feet. Easterly of the southeast corner of Honeywell Street and Northern Boulevard, running thence southerly 62.40 feet, thence easterly 60 feet thence | 11101.0 | Lindsay, Corso, Katzman, Modugno, Ryan, Smith, Thompson, Rosen, and Weiss |
| {"type":"MultiLineString","coordinates":[[[-74.01477587599999,40.70743151900007],[-74.01539993699998,40.70767279700004]]]} | Int. No. 183 | 1967-01-20T00:00:00.000 | 1967-10-21T00:00:00.000 | 1967/007 | Street | Manhattan | Joseph P. Ward Street | — | A new street running east and west, 246 feet, plus or minus, south of Rector Street, between West Street and Washington Street | 10006.0 | Cuite, Katzman, Modugno, Ruggieri, Santucci, Sharison, Smith, Troy Jr., and Weiss |
| {"type":"MultiLineString","coordinates":[[[-73.99740662099998,40.72989935900006],[-73.99981725699996,40.72706412900004]]]} | Int. No. 451 | 1967-09-25T00:00:00.000 | 1967-10-21T00:00:00.000 | 1967/061 | Street | Manhattan | LaGuardia Place | West Broadway | Between Houston Street and Washington Square South | 10012.0 | Curtis, Cuite, Gelfand, Katzman, Modugno, Ryan, Smith, Troy Jr., and Rosen |
Showing 12 of 13 columns. All of them are listed below.
2002-08-01T00:00:00.000enactment_number | text | The Local Law number of the introduction once passed by the City Council | 0% | 2003/0062002/0282003/034 |
category | categorical | The type of change | 0% | StreetStructureParkof 6 |
borough | categorical | The borough in street renaming falls under | 0% | BrooklynQueensManhattanof 5 |
new_name | text | New name assigned to honor the specific recipient | 0% | Bernice Singletary Squar…Mother Gaston BoulevardDr. Wesly McDonald Holde… |
present_name | text | The current name of the street | 3% | BroadwayWashington AvenueProspect Avenue |
limits | text | Map location | 0% | In its entiretyBetween 4th Avenue and 5…Between Second Avenue an… |
zip_code | integer | Zip code under which street renaming falls under | 0% | 10312.011201.011385.0 |
introduced_by_council_members | text | The name of the Council member(s) introducing the renaming | 0% | Addabbo, Jr., Avella, Fi…Addabbo, Avella, Clarke,…Addabbo Jr., Miller, Ave… |
biographic | text | Biographical information about the honoree | 0% | Awaiting Biographical In…Awaiting Biographical In…This legislation renames… |
notes | categorical | Additional information if any, possibly for corrections | 100% | This information is loca…This information is loca…This information is loca…of 4 |