From a 392-row sample across 38 columns.
street_name:@computed_region_sbqj_enihtax_lot+7latitudeborocodebin+2:@computed_region_sbqj_enih:@computed_region_yeji_bk3qlatitude+5tax_lottax_blockMappable — Socrata point column `geocoded_column`.
Open on the map →| pops_number | borough_name | borocode | community_district | address_number | street_name | zip_code | building_address_with_zip | tax_block | tax_lot | building_name | building_location |
|---|---|---|---|---|---|---|---|---|---|---|---|
| M050022 | Manhattan | 1 | 5 | 1350 | SIXTH AVENUE | 10019 | 1350 SIXTH AVENUE, New York, NY 10019 | 1270 | 71 | Men's Apparel | Southeast corner of West 55th Street and Sixth Avenue |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
pops_number | text | POPS Number is the record number the Department of City Planning uses to identify a building address within the POPS Database. | 0% | K010002K010003K020001 |
borough_name | categorical | The Borough in which the public space is located. The City has 5 geographically defined boroughs. | 0% | ManhattanBrooklynQueensof 5 |
borocode | categorical | Borough Code is a single digit that represents the borough in which the public space is located. The City has 5 geographically defined boroughs. | 0% | 134of 5 |
community_district | categorical | The community district in which the public space is located. The City has 59 geographically defined community districts overseen by community boards. The community boards play a role in the City's Uniform Land Use Review Procedure (ULURP), as well as in the review of other City Planning Commission and Board of Standards and Appeals actions. |
GET /api/datasets/rvih-nhyn GET /api/datasets/rvih-nhyn/quality GET /api/datasets/rvih-nhyn/related GET /api/columns?dataset=rvih-nhyn
bbllatitudecouncil_districtbin+4community_district:@computed_region_efsh_h5xi:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+7street_name| M050065 | Manhattan | 1 | 5 | 3 | PARK AVENUE | 10016 | 3 PARK AVENUE, New York, NY 10016 | 889 | 7501 | Three Park Avenue | Full blockfront on east side of Park Avenue between East 33rd and 34th Streets |
| M050117 | Manhattan | 1 | 5 | 415 | MADISON AVENUE | 10017 | 415 MADISON AVENUE, New York, NY 10017 | 1284 | 21 | — | — |
| M080022 | Manhattan | 1 | 8 | 353 | EAST 72 STREET | 10021 | 353 EAST 72 STREET, New York, NY 10021 | 1447 | 19 | Fontaine | North side of East 72nd Street between First and Second Avenues |
| M080069 | Manhattan | 1 | 8 | 1675 | YORK AVENUE | 10128 | 1675 YORK AVENUE, New York, NY 10128 | 1568 | 21 | Andover | Full blockfront on west side of York Avenue between East 88th and 89th Streets |
| M010058 | Manhattan | 1 | 1 | 375 | PEARL STREET | 10038 | 375 PEARL STREET, New York, NY 10038 | 113 | 7501 | Verizon Building | Pearl Street bounded by Avenue of the Finest and Madison Street |
| M080080 | Manhattan | 1 | 8 | 525 | EAST 72 STREET | 10021 | 525 EAST 72 STREET, New York, NY 10021 | 1484 | 16 | One East River Place | North side of East 72nd Street between FDR Drive and York Avenue |
| M050045 | Manhattan | 1 | 5 | 280 | PARK AVENUE | 10017 | 280 PARK AVENUE, New York, NY 10017 | 1284 | 33 | — | West side of Park Avenue between East 48th and 49th Streets |
| Q070001 | Queens | 4 | 7 | 138-35 | 39 AVENUE | 11354 | 138-35 39 AVENUE, Queens, NY 11354 | 4978 | 7502 | Flushing Commons | — |
| M050006 | Manhattan | 1 | 5 | 110 | EAST 59 STREET | 10022 | 110 EAST 59 STREET, New York, NY 10022 | 1313 | 5 | — | South side of East 59th Street between Lexington and Park Avenues |
Showing 12 of 38 columns. All of them are listed below.
| 0% |
568of 13 |
address_number | text | The address number as displayed on the building's exterior or as recorded in Department of Finance records. | 0% | 2001300 |
street_name | text | The street name as displayed on the building's exterior or as recorded in Department of Finance records. | 0% | BROADWAYSIXTH AVENUETHIRD AVENUE |
zip_code | integer | The zip code in which the public space is located. | 0% | 100221001910016 |
building_address_with_zip | text | Building Address with Zip Code is the street address as displayed on the building's exterior or as recorded in Department of Finance records. | 0% | 100 UNITED NATIONS PLAZA…100 WALL STREET, New Yor…100 WILLIAM STREET, New … |
tax_block | integer | Tax Block is the block number for the development's relevant zoning lots. The block refers to a city block, within which are a number of lots. The source for this information is the Department of Finance records and published information such as the Sanborn Manhattan Land Book. | 1% | 12928891028 |
tax_lot | integer | Tax Lot is the lot number(s) for the development's relevant zoning lots. The block refers to a city block, within which are a number of lots. With condominium buildings, each condominium unity has its own lot number. The source for this information is the Department of Finance records and published information such as the Sanborn Manhattan Land Book. | 1% | 750117502 |
building_name | text | The name of the building as displayed on the building's exterior or as generally presented to the public. If there is no building name, the field is left blank. | 32% | Normandie CourtInternational Plaza1211 Avenue of the Ameri… |
building_location | text | The location of the main entrance or entrances to the building, and describes the building rather than the public space, location. | 8% | South side of West 57th …Northeast corner of Seco…Northwest corner of East… |
year_completed | text | Year Completed is the year the building was completed, according to published information and discussions with the owner. | 10% | 197419871971 |
building_constructed | categorical | Building Construction is the construction status of the building, according to published information and discussions with the owner. | 6% | CompletedUnder Constructionof 2 |
public_space_type | text | Public Space Type is the type of spaces required to be provided at the development. | 1% | PlazaResidential PlazaArcade; Plaza |
developer | text | Developer is the name of the legal entity or a person or persons participating in the legal entity that has developed the building and its public space(s). The sources for this field are varied, including legal records, published information, and discussions with the current owner." | 47% | Fisher BrothersRose AssociatesHarry Macklowe |
building_architect | text | Building Architect is the architect of the building. The sources for this field are varied, including legal records, published information, and discussions with the current owner. | 7% | Emery Roth & SonsPhilip BirnbaumSkidmore, Owings & Merri… |
principal_public_space | text | Principal Public Space Designer is the designer who designed or redesigned the public space, and frequently is the building architect. The sources for this field are varied, including legal records, published information, and discussions with the current owner. | 7% | Emery Roth & SonsPhilip BirnbaumThomas Balsley Associate… |
size_required | text | Size Required is the legally required size of the public space(s) at the development. | 9% | Through Block Connection…Through Block Connection…Additional Plaza 0.00 sf… |
hour_of_access_required | categorical | Hours of Access Required is the legally required hours that the public space(s) at the development must be open to the public. | 9% | 24 HoursRestricted Hours24 Hours; Restricted Hou…of 5 |
amenities_required | text | Amenities Required is the legally required amenities at the public space(s) at the development. | 8% | NoneBicycle Parking; Drinkin…Bicycle Parking; Drinkin… |
other_required | text | Other Required is the other legally required amenities at the public space(s) at the development. | 80% | skylightgreen screen12 lamp posts of the kin… |
permitted_amenities | categorical | Permitted Required is the permitted amenities at the public space(s) at the development. | 92% | Open Air CafeOther PermittedOpen Air Cafe; Other Per…of 3 |
physically_disabled | categorical | Physically Disabled is a description of whether or not the public spaces, taken as a whole, are wheelchair accessible to some degree to the physically disabled. Full/Partial means that the spaces are fully or partially accessible. | 5% | Full/PartialNoneUnknownof 3 |
latitude | float | The latitude of the development. | 0% | 40.7074140.5918340.700345 |
longitude | float | The longitude of the development. | 0% | -74.078641-74.015837-74.014994 |
xcoordinate | integer | X coordinate in NAD 1983 State Plane New York Long Island FIPS 3104 (US Feet) | 0% | 991544991191990213 |
ycoordinate | integer | Y coordinate in NAD 1983 State Plane New York Long Island FIPS 3104 (US Feet) | 0% | 216933197005211577 |
council_district | integer | The City Council district in which the public space is located. | 0% | 415 |
census_tract | float | The census tract in which the public space is located. | 0% | 7909 |
bin | integer | The Building Identification Number (BIN) is a unique number assigned by the Department of City Planning (DCP) and used by the Department of Buildings (DOB) for each building in NYC. This field consists of the borough code followed by six digits unique for buildings within that borough. | 1% | 100000040000001043884 |
bbl | integer | A concatenation of the borough code, tax block and tax lot. This field consists of the borough code followed by the tax block followed by the tax lot. The borough code is one numeric digit. The tax block is one to five numeric digits, preceded with leading zeros when the block is less than five digits. The tax lot is one to four digits and is preceded with leading zeros when the lot is less than four digits. | 1% | 101022004330877375011013220001 |
nta | text | The Neighborhood Tabulaton Area (NTA) in which the public space is located. NTAs were created by aggregating census tracts. NTAs were delineated with the need for both geographic specificity and statistical reliability in mind. Though NTA boundaries and their associated names roughly correspond with many neighborhoods commonly recognized by New Yorkers, NTAs are not intended to definitively represent neighborhoods, nor are they intended to be exhaustive of all possible names and understand | 100% | — |
geocoded_column | coordinate | — | 0% | {'coordinates': [-73.970…{'coordinates': [-73.982…{'coordinates': [-73.975… |