From a 500-row sample across 20 columns.
multipolygonHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| bbl | borough | public_restroom | description | gispropnum | location | omppropid | parks_district | system | multipolygon | recreation_center | featurestatus |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5052120150 | R | true | Seaside Wildlife Nature Park-Public Restroom | R145 | corner Nelson Ave and Tennyson Dr | R145 | R-03 | R145-BLG9453 | {"type":"MultiPolygon","coordinates":[[[[-74.1432030214379,40.54092491201885],[-74.14323121455581,40.54083257361213],[-74.14316304401015,40.540817663033955],[-74.14313136064195,40.54091233904334],[-74.1432030214379,40.54092491201885]]]]} |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
alteration_year | integer | The year the building was last altered. | 95% | 201920182022 |
bbl | text | Borough, block, and lot number for the tax lot that the footprint is physically located within. | 2% | 203120002040591700012056500001 |
bin | integer | Building Identification Number. A number assigned by City Planning and used by Dept. of Buildings to reference information pertaining to an individual building. The first digit is a borough code (1 = Manhattan, 2 = The Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island). The remaining 6 digits are unique for buildings within that borough. In some cases where these 6 digits are all zeros (e.g. 1000000, 2000000, etc.) the BIN is unassigned or unknown. | 11% | 400000050000002000000 |
borough | categorical | Borough in which the structure is located. |
GET /api/datasets/n8q6-i44s GET /api/datasets/n8q6-i44s/quality GET /api/datasets/n8q6-i44s/related GET /api/columns?dataset=n8q6-i44s
| false |
| Active |
| 1017770090 | M | true | Harlem River Park-Public Restroom | M208D | Corner 3 Ave Bridge and E 128 St | M208D | M-11 | M208D-BLG1564 | {"type":"MultiPolygon","coordinates":[[[[-73.93448937927174,40.80625681739755],[-73.93455793062358,40.806157896046905],[-73.93449779863077,40.80613240750428],[-73.93442443713988,40.806234666032644],[-73.93448937927174,40.80625681739755]]]]} | false | Active |
| 1012570002 | M | false | Bryant Park-Public Restroom | M008 | W 40th St & Ave of the Americas | M008 | M-05 | M008-BLG0664 | {"type":"MultiPolygon","coordinates":[[[[-73.98410939700034,40.753414133361986],[-73.98415612628536,40.75335049026601],[-73.98412928169051,40.75333881601863],[-73.98408255229808,40.75340283551513],[-73.98410939700034,40.753414133361986]]]]} | false | Active |
| 1011110001 | M | false | Arsenal Building | M010 | 830 5th Avenue | M010-ZN01 | M-13 | M010-ZN01-BLG0707 | {"type":"MultiPolygon","coordinates":[[[[-73.97117542901643,40.76787669258329],[-73.97117991756738,40.76789406532227],[-73.97120071736586,40.76790468656092],[-73.97122530402592,40.767901015047],[-73.97123927520467,40.76788520118861],[-73.97123444491089,40.76786650822827],[-73.97132871758535,40.76773504558325],[-73.9713570816386,40.76772781348905],[-73.9713688068067,40.767709902683585],[-73.97136040561642,40.767690856743634],[-73.97139886068898,40.76763723049533],[-73.97140384521103,40.76763609169493],[-73.97142463260931,40.76763134129244],[-73.9714367399679,40.76761422661988],[-73.97142914188152,40.767595003484544],[-73.97152352518975,40.76746338311428],[-73.97154757447929,40.76745845969842],[-73.97156000008178,40.767442049285016],[-73.97155456543275,40.767426705161],[-73.97155352440367,40.7674237647593],[-73.97153194011484,40.767414317646626],[-73.97151223920667,40.7674183515363],[-73.97143734421869,40.76738730613775],[-73.97143002423256,40.767368695413296],[-73.97140753854498,40.76735947047807],[-73.97138305906239,40.76736503671756],[-73.97137092687076,40.76738213246838],[-73.97137174097327,40.76740046602606],[-73.97127363496318,40.76753727584848],[-73.97125850839858,40.76754089750395],[-73.97124756222988,40.76755686880806],[-73.97125196367419,40.76756749585005],[-73.9712065754972,40.76763078992612],[-73.97118602520214,40.76763499734488],[-73.97117359947156,40.76765140771749],[-73.97117961370836,40.76766838821919],[-73.97108266004881,40.76780359076294],[-73.97105969083877,40.76780840809337],[-73.97104831193016,40.767825148299366],[-73.97105596041713,40.76784267222146],[-73.97107785288581,40.767851753895584],[-73.97110146801104,40.76784603441884],[-73.97117542901643,40.76787669258329]]]]} | false | Active |
| 4020180500 | Q | false | Olmsted Center-Main Building | Q099 | Section C in 117-02 Roosevelt Av in Flushing Meadows Corona Park, 11368 | Q099-ZN03 | Q-04 | Q099-ZN03-BLG0395 | {"type":"MultiPolygon","coordinates":[[[[-73.84960497589873,40.751496264371646],[-73.84967271417152,40.75147268116471],[-73.84955491333609,40.75127699935492],[-73.84959610486518,40.751262658541236],[-73.8497102958796,40.75145234362511],[-73.8497191531517,40.75146705776076],[-73.84984672396347,40.75142264272264],[-73.84984703918921,40.751422533271715],[-73.84985782443785,40.751418777807665],[-73.84991723275002,40.75139809403774],[-73.84958279890044,40.750842556377734],[-73.8493807257877,40.750912909193126],[-73.84944519606478,40.75102000344644],[-73.84948828568031,40.751091582540134],[-73.84950095210624,40.751112623230966],[-73.84919989463249,40.75121743663558],[-73.84918553070786,40.75119357510202],[-73.84930085138215,40.7511534256381],[-73.84924432288679,40.75105952242377],[-73.84920098935847,40.75098753769057],[-73.84917781554408,40.750995605610626],[-73.8490499132889,40.751040134740656],[-73.84904269125909,40.75102813862514],[-73.84884069759673,40.75109846268112],[-73.84898818992507,40.75134347251703],[-73.84892653804134,40.751364937207434],[-73.84896452516831,40.751428040532154],[-73.84896511147312,40.75142901474917],[-73.84896518968687,40.7514289878365],[-73.84902832887579,40.75140700548231],[-73.84935935156874,40.75195688326309],[-73.84956077015438,40.75188676016656],[-73.8492559460126,40.7513804054402],[-73.84929318429786,40.7513674400387],[-73.84941132309974,40.75156368447269],[-73.84948432320375,40.75153826941997],[-73.84950788942615,40.751530065074334],[-73.8494902823073,40.7515008188128],[-73.8495634031891,40.75147536154386],[-73.84958100914716,40.751504608693246],[-73.84960497589873,40.751496264371646]]]]} | false | Active |
| 4008400200 | Q | true | Hoyt Playground Public Restroom | Q066F | 29 Street and Dorothy Pl | Q066F | Q-01 | Q066F-BLG5150 | {"type":"MultiPolygon","coordinates":[[[[-73.91735886683097,40.77201826613229],[-73.91733948568043,40.77200619268762],[-73.91733804929967,40.772005859371376],[-73.91733656057087,40.7720057115213],[-73.91733506094691,40.772005752769104],[-73.91733358951717,40.772005982242284],[-73.91733219011587,40.77200639366889],[-73.91733089829131,40.77200697626827],[-73.91732975196848,40.77200771295817],[-73.91732878078442,40.772008583948704],[-73.9173280131972,40.77200956494675],[-73.91732747056132,40.77201062895247],[-73.91732716712761,40.77201174625956],[-73.91732711003992,40.772012887156485],[-73.9173273040765,40.77201401922855],[-73.91732774098503,40.77201511095221],[-73.91732840895632,40.7720161335029],[-73.91732929144439,40.772017057152134],[-73.91733036242154,40.77201785666707],[-73.9173479277282,40.77202898508309],[-73.91735886683097,40.77201826613229]]]]} | false | Active |
| 4051560001 | Q | false | Kissena Corridor Park-Silent Spring Playground-Utility Building | Q300 | Colden St. & Geranium Ave. | Q300-03 | Q-07 | Q300-03-BLG0474 | {"type":"MultiPolygon","coordinates":[[[[-73.82290310092178,40.74994445062841],[-73.82293510779664,40.749925558553436],[-73.8229187040978,40.749908736163654],[-73.8228862302233,40.74992691251279],[-73.82290310092178,40.74994445062841]]]]} | false | Active |
| 4080870001 | Q | false | Alley Pond Park-Golf Center | Q001 | 232-01 Northern Boulevard | Q001 | Q-07A | Q001-BLG0320 | {"type":"MultiPolygon","coordinates":[[[[-73.74806376525481,40.764861207175386],[-73.74801604015022,40.764829789446594],[-73.74793818046945,40.76490118247841],[-73.74798823671969,40.76493096101112],[-73.74791762090855,40.76500319473845],[-73.7478517895871,40.76507799543479],[-73.74779090571812,40.76515517976149],[-73.7478860382289,40.76518969732162],[-73.74796662576517,40.76509393445146],[-73.74805477820132,40.76500210437556],[-73.74815016258513,40.76491455394488],[-73.7482524235427,40.76483161014993],[-73.74836117378345,40.7647535855034],[-73.74847600714858,40.76468077266584],[-73.74859649150137,40.76461344533115],[-73.74872217465578,40.764551856438665],[-73.74885258319505,40.76449623727045],[-73.74898722721224,40.764446796561565],[-73.74912560267859,40.76440372050521],[-73.74926718908084,40.76436717094712],[-73.74941145416159,40.76433728449548],[-73.74955785628053,40.764314174327325],[-73.74970584561147,40.764297926589144],[-73.74985486531921,40.7642886022009],[-73.74984763103012,40.76421234320205],[-73.74974568137435,40.76421385076935],[-73.74964409935463,40.764220584692],[-73.74954334459122,40.76423251535294],[-73.74944387917216,40.7642495870273],[-73.74941661940827,40.764165660747786],[-73.74928842821751,40.76418785312771],[-73.74916200439469,40.76421528926796],[-73.74903772010775,40.76424788803885],[-73.74891593810649,40.764285553883546],[-73.7487970164569,40.764328177728686],[-73.74868130381756,40.7643756333721],[-73.74869348662821,40.76446905791272],[-73.74857684080104,40.76452267899312],[-73.74846440068676,40.76458126283093],[-73.74835653058432,40.76464462112754],[-73.74825358183759,40.76471254754656],[-73.74815588808738,40.764784820404984],[-73.74806376525481,40.764861207175386]]]]} | false | Active |
| 4078500020 | Q | false | Alley Pond Adventure Center-Building | Q001 | — | Q001-ZN02 | Q-07A | Q001-ZN02-BLG0198 | {"type":"MultiPolygon","coordinates":[[[[-73.74136382666936,40.742357233501544],[-73.74140536877596,40.74248779009629],[-73.74147307665591,40.74247532774556],[-73.74143153442789,40.742344770274464],[-73.74136382666936,40.742357233501544]]]]} | false | Active |
| 4077200100 | Q | false | Douglaston Pumping Station | Q001 | Douglaston Parkway @ 67th Avenue | Q001 | Q-07A | Q001-BLG0209 | {"type":"MultiPolygon","coordinates":[[[[-73.74019009836113,40.75104065252075],[-73.74031111170439,40.751186115503565],[-73.74031665587738,40.75119278006854],[-73.7404017223174,40.751151852739326],[-73.74029528700144,40.751023913322406],[-73.7402443442063,40.750962676350056],[-73.7401950798222,40.75090345938167],[-73.74017199459011,40.750914566427475],[-73.74015431912397,40.75089331954893],[-73.74001779282187,40.750729206941564],[-73.73983692038595,40.75081622815651],[-73.74004038494361,40.75106080493436],[-73.74006225186079,40.751050284099065],[-73.74006517266965,40.75104887869101],[-73.74015927672704,40.75100360356146],[-73.74019009836113,40.75104065252075]]]]} | false | Active |
Showing 12 of 18 columns. All of them are listed below.
| 0% |
QXBof 5 |
public_restroom | boolean | Whether the structure has a public restroom | 0% | FalseTrueof 2 |
construction_year | integer | The year construction of the building was completed.Originally this column was populated using the Department of Finance Real Property Assessment Database (RPAD). Beginning in 2017 this will be the first year the completed structure is visible in available orthoimagery. Records where this is zero or NULL mean that this information was not available. | 35% | 190519311935 |
description | text | The description of the structure so that it can be identified in the field. Typically the building name | 3% | Fort Totten Park-Buildin…Bronx Park-Bronx Zoo-Bui…Pelham Bay Park-Building |
doitt_id | integer | Unique identifier assigned by DOITT. | 20% | 119783211079381238848 |
doitt_source | text | An indicator of whether the DOITT_ID is present in the historic or current DOITT Buildings feature class. | 21% | currentof 1 |
demolition_year | categorical | The year the building has been demolished. | 100% | 20222024of 2 |
gispropnum | text | Unique identification number for each park property, identified by borough/county (B = Brooklyn; M = Manhattan; Q = Queens; R = Richmond (Staten Island); X = Bronx), and followed by a number | 0% | X002Q099Q458 |
ground_elevation | integer | Lowest Elevation at the building ground level. Calculated from LiDAR or photogrammetrically. | 21% | 10811 |
height_roof | integer | Building Height is calculated as the difference from the building elevation from the Elevation point feature class and the elevation in the interpolated TIN model. This is the height of the roof above the ground elevation, NOT its height above sea level. Records where this is zero or NULL mean that this information was not available. | 21% | 111213 |
location | text | The location of the structure; typically the cross streets. | 38% | Burke Ave., E. 180 St. b…Hylan Blvd., Old Mill Rd…Forest Hill Rd., London … |
maintby | text | The party responsible for the general maintenance of the structure. | 100% | Otherof 1 |
maintbyspec | categorical | The specific party responsible for general maintenance of the structure. Only filled in if Other is selected in Maint_By | 100% | Battery Park CityBrooklyn Bridge Parkof 2 |
omppropid | text | Unique identification number for a property or portion of a property. In some cases – a standalone, smaller park for example – this number will be equivalent to the GIS Property Number. In other cases – a zone, playground or other site within a larger park – an additional designation of letters and/or numbers will be added. | 2% | X002Q458X039 |
parks_district | text | The Parks maintenance district with which the asset is maintained. Not geographically based. | 0% | X-06Q-07R-01 |
system | text | Unique Parks ID of the Structure | 0% | M010-BLG0014X182-BLG0755B100-01-BLG1116 |
multipolygon | unknown | The WKB representation of the geometry. | — | — |
recreation_center | boolean | Whether structure is a Recreation Center | 0% | FalseTrueof 2 |
featurestatus | categorical | Status of a structure | 0% | ActiveInactiveRemovedof 5 |