From a 500-row sample across 37 columns.
the_geomboroughshape_leng+4lotblockbblthe_geomboroughshape_leng+1boroughlotblockHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| the_geom | bin | bbl | borough | block | lot | des_addres | circa | date_low | date_high | date_combo | alt_date_1 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiPolygon","coordinates":[[[[-73.96005569077911,40.63096385064738],[-73.9601274248611,40.630957727699474],[-73.96013489308709,40.63100851328533],[-73.96006315895082,40.63101463713833],[-73.96005569077911,40.63096385064738]]]]} | 3368915 | 3066920018 | BK | 6692 | 18 | 803 East 17th Street | 1 | 1912 | 1912 | c. 1912 | 1958 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | Geometry column | — | — |
bin | integer | Department of Buildings “Building Identification Number;” Note: numbers in this field are not auto-updated and so some may be outdated; BINs here are derived using building footprint GIS shapefiles from the NYC Department of Information Technology and Telecommunication (DoITT) (2007-2009); because this file contains both building and non-building landmarks (such as monuments or vacant lots), some records display “dummy” BIN numbers; the following BIN #s serve only as “dummy” BIN #s: 1000000, 200 | 0% | 100000030000001085964 |
bbl | text | Concatenation of the borough code (1=MN, 2=BX,3=BK,4=QN,5=SI), the five digit tax map block and four digit tax map lot numbers (ex. Manhattan Tax Map Block 123 Lot 45 would appear as 1001230045); Note: numbers in this field are not auto-updated and so some may be outdated; because this file contains both building and non-building landmarks (such as monuments or vacant lots) as well as some landmarks not located on tax map lots (such as bridges), some records display “dummy” BBLs; the following B | 0% | 10000100104059170001 |
GET /api/datasets/gpmc-yuvp GET /api/datasets/gpmc-yuvp/quality GET /api/datasets/gpmc-yuvp/related GET /api/columns?dataset=gpmc-yuvp
lotbinblockboroughlotbin+1the_geomboroughshape_leng+1lotbinblock+1| {"type":"MultiPolygon","coordinates":[[[[-73.95996028425891,40.63088240239438],[-73.96002859598848,40.63087498787185],[-73.96003493598042,40.63090889283425],[-73.95996662421683,40.63091630736056],[-73.95996028425891,40.63088240239438]]]]} | 3384822 | 3066920074 | BK | 6692 | 74 | 814 East 18th Street (aka 812-814 East 18th Street) | 0 | 0 | 0 | Not determined | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.96187013631709,40.63278008941402],[-73.9618666685158,40.63275894767242],[-73.96183677111871,40.63276179420029],[-73.96182280691225,40.63267666887587],[-73.96181562218364,40.6326773526859],[-73.96180556044743,40.632616012270645],[-73.961912713036,40.632605809810634],[-73.96194020820565,40.63277341816936],[-73.96187013631709,40.63278008941402]]]]} | 3121277 | 3052370230 | BK | 5237 | 230 | 1653 Glenwood Road | 1 | 1906 | 1906 | c. 1906 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.96142687745777,40.630615495397755],[-73.96149100006868,40.6306096464053],[-73.96150852018451,40.63072113118616],[-73.96142017487723,40.63072919004264],[-73.9614188805317,40.63072930757641],[-73.96141759099638,40.63072110431143],[-73.96140328602172,40.63063008220085],[-73.96142880410325,40.63062775391596],[-73.96142687745777,40.630615495397755]]]]} | 3179065 | 3066910032 | BK | 6691 | 32 | 54 Wellington Court | 1 | 1911 | 1911 | c. 1911 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.95908690014448,40.63063746519758],[-73.95908470026392,40.63062622773191],[-73.95904879017873,40.63063030690825],[-73.95902329198574,40.63050000255099],[-73.95903240335929,40.630498967498845],[-73.9590272801633,40.6304727866693],[-73.95915547881313,40.630458224954666],[-73.95916848488962,40.63052468701673],[-73.95914649016223,40.63052718534956],[-73.95916410693921,40.63061720844213],[-73.95912824769307,40.63062128135764],[-73.9591304463995,40.63063251792157],[-73.95908690014448,40.63063746519758]]]]} | 3179111 | 3066930007 | BK | 6693 | 7 | 1809 Avenue H | 1 | 1906 | 1906 | c. 1906 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.96052516027763,40.632441223959624],[-73.96052118138567,40.63241960922834],[-73.96050999641699,40.63242080487922],[-73.96048654612622,40.63229341115422],[-73.9604956896024,40.63229243363049],[-73.9604920995445,40.63227292984885],[-73.96053475529142,40.63226837256096],[-73.96056638685569,40.63226499295828],[-73.96056981551473,40.63228362317839],[-73.96059620214758,40.6322808036928],[-73.96061219555713,40.632367687679384],[-73.96064242165714,40.63236445796106],[-73.96064590454272,40.63238338086606],[-73.96065401793365,40.63242745596083],[-73.96052516027763,40.632441223959624]]]]} | 3179095 | 3066920045 | BK | 6692 | 45 | 1704 Glenwood Road (aka 1702-1706 Glenwood Road; 739-749 East 17th Street) | 1 | 1903 | 1903 | c. 1903 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.96088933611301,40.63031256093242],[-73.96086067463301,40.63031593172973],[-73.96068032722539,40.630337141368315],[-73.96067406320937,40.630306225289914],[-73.96069806145556,40.630303403162685],[-73.96069255053173,40.630276202886314],[-73.96081865058179,40.63026137294642],[-73.96087756100457,40.63025444549826],[-73.96088933611301,40.63031256093242]]]]} | 3179070 | 3066910048 | BK | 6691 | 48 | 832 East 17th Street (aka 1617 Avenue H) | 1 | 1961 | 1961 | c. 1961 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.96044498347962,40.63299836842773],[-73.96051490087407,40.63299372957008],[-73.96052106634316,40.633047667390244],[-73.96045114889316,40.6330523053511],[-73.96044498347962,40.63299836842773]]]]} | 3357104 | 3052380011 | BK | 5238 | 11 | 725 East 17th Street | 1 | 1922 | 1922 | c. 1922 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.95816015248828,40.63103335397792],[-73.95821582421135,40.63102612684218],[-73.95822867552704,40.63108358825817],[-73.95818414024009,40.631089369614415],[-73.95814876024465,40.63109396199852],[-73.95813591017776,40.63103650057399],[-73.95816015248828,40.63103335397792]]]]} | 3368946 | 3066940016 | BK | 6694 | 16 | 807 East 19th Street | 0 | 0 | 0 | Not determined | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.9605701501075,40.633009698527594],[-73.960581461272,40.63299713746014],[-73.96061500485887,40.63299318396835],[-73.96062467061932,40.63299866783931],[-73.96062584332901,40.633004445972716],[-73.96064561532215,40.633002114993715],[-73.96064277488091,40.63298812805613],[-73.96072482637267,40.63297845751967],[-73.96074605911981,40.6330830105586],[-73.96056377850707,40.633104494909475],[-73.96055310863903,40.63305195315269],[-73.96057295275733,40.63304961410622],[-73.96056497127702,40.633010309104684],[-73.9605701501075,40.633009698527594]]]]} | 3121289 | 3052380011 | BK | 5238 | 11 | 725 East 17th Street | 1 | 1903 | 1903 | c. 1903 | 0 |
Showing 12 of 37 columns. All of them are listed below.
1011110001borough | categorical | Borough expressed as a two character abbreviation (MN=Manhattan, BX=Bronx, BK=Brooklyn, QN=Queens, and SI=Staten Island) | 0% | BKMNQNof 6 |
block | integer | The five digit tax map block number, without leading zeros (ex. tax lot 00123 appears as 123) | 0% | 111441244 |
lot | integer | The four digit tax map lot number, without leading zeros (ex. Lot 0456 appears as 456) | 0% | 11012 |
des_addres | text | The address of the building or structure as written in the designation report. | 0% | Central ParkNot determinedProspect Park |
circa | categorical | This is a yes / no field that represents whether a building’s construction date is identified as being circa. (1 = circa date, 0 = non-circa date ) | 0% | 01of 2 |
date_low | integer | The low end of the date range for the original date(s) of construction in the designation report. E.g. if the date range is 1887 – 1889 this field would be 1887. | 0% | 019091891 |
date_high | integer | The high end of the date range for the original date(s) of construction in the designation report. E.g. if the date range is 1887 – 1889 this field would be 1889. | 0% | 019091889 |
date_combo | text | Combination of both the date low and date high fields, e.g. 1887 - 1880. If construction was completed within one year the Date_Combo field is represented by a single year, e.g. 1887. If the Circa flag field is checked as one, the information in the Date_Combo field will have a "c." preceding it. If the designation report gives vague age information the Date_Combo field may be represented as "early 18th century" or "1960s". If the original dates of construction are not included the designation | 0% | Not determined18911927 |
alt_date_1 | text | If a significant alteration has been performed its date is represented here. For the purposes of this database only alterations that were noted as significant in the designation report were recorded in this field. | 0% | 019201916 |
alt_date_2 | text | This pertains to the date of a second significant alteration. If a third (or fourth) alteration has been done dates will be separated by a semicolon. | 0% | 019251927 |
arch_build | text | This field records the original architect or builder listed in the designation report. If only builder information was provided in the designation report the individual's name will be followed by builder in brackets. E.g. (builder). If this information is not included in the designation report, the field is represented as 'Not determined'. | 0% | Not determinedLouis Berger & CompanyClarence Stein & Henry W… |
own_devel | text | This field records the building or structure's original owner or developer from the designation report. If this information is not included in the designation report, the field is represented as 'Not determined'. | 0% | Not determinedCity Housing Corporation…Paul Stier |
alt_arch_1 | text | Architect or builder responsible for first significant alteration represented by field Alt_Date_1. | 0% | 0Not determinedFrancis Y. Joannes & Max… |
alt_arch_2 | text | Architect or builder responsible for a second (or third) significant alteration represented by field Alt_Date_2 | 0% | 0Not determinedSee designation report |
altered | categorical | — | 0% | 01of 2 |
style_prim | text | Primary architectural style as listed in the designation report building description. If this information was not included in the designation report, the field is represented as 'Not determined'. | 0% | Not determinedRenaissance Revivalneo-Grec |
style_sec | text | Secondary architectural style as listed in the designation report building description. | 0% | 0Romanesque RevivalRenaissance Revival |
style_oth | text | Tertiary architectural style as listed in the designation report building description. | 0% | 0Queen AnneRomanesque Revival |
mat_prim | text | Primary building material as listed in the designation report building description. | 0% | BrickBrownstoneNot determined |
mat_sec | text | Secondary building material as listed in the designation report description. | 0% | 0StoneBrownstone |
mat_third | text | Tertiary building material as listed in the designation report building description. | 0% | 0Terra CottaStone |
mat_four | text | Quaternary building material as listed in the designation report building description. | 0% | 0Metal CorniceBluestone |
mat_other | text | Additional field for building material description. | 0% | 0SlateTerra Cotta |
use_orig | text | The original use of the building or structure as designed or built. If this information was not included in the designation report, the field is represented as 'Not determined'. | 0% | ResidentialResidential, multi-famil…Residential, single-fami… |
use_other | text | Secondary use if a change has occurred over time. For example, If a building was built as a carriage house but was converted to a residence its secondary use would be listed as residential. | 0% | 0Mixed-use, commercial & …Residential, multi-famil… |
build_type | text | The original type of building or structure as designed or built. If this information was not included in the designation report, is not known the field is represented as 'Not determined'. | 0% | Row HouseFree-standing HouseGarage |
build_oth | text | Secondary building type if the building's use or purpose has changed over time. For example, If a building was built as a warehouse but was converted to apartments its secondary type would be listed as an apartment building. | 0% | 0Row House with Commercia…Apartment Building |
build_nme | text | Building name, if included in designation report. | 0% | 0Court Name: Harrison Pla…Court Name: Washington |
notes | text | Notes field used to enter additional or clarifying information about the building or structure's history, design or alterations. When a substantial change has taken place after designation, such as the construction of a new building on a vacant lot, that information is included in the “notes,” but the top level information from the designation report is still included in the fields. | 0% | 0Row House type: A'Row House type: A |
hist_dist | text | Name of designated historic district in which the building or structure is located. | 0% | Greenwich Village Histor…Park Slope Historic Dist…Upper West Side / Centra… |
lm_orig | text | Name of designated individual landmark as it appears in the designation report. | 0% | 0Historic Street Lamppost…Central Park |
lm_new | text | A.K.A. name of designated individual landmark | 0% | 0Historic Street Lamppost…Central Park |
shape_leng | float | — | 0% | 466.050256981157.172353231255.766653639 |
shape_area | float | — | 0% | 10932.3472611034.007548792551.80814419 |