From a 500-row sample across 15 columns.
shape_areathe_geomshape_areathe_geom| the_geom | bin | doitt_id | shape_area | base_bbl | objectid | construction_year | feature_code | geom_source | ground_elevation | height_roof | last_edited_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiPolygon","coordinates":[[[[-73.869957915648,40.900305259723],[-73.869953578094,40.900283350548],[-73.869946517529,40.900284155732],[-73.869936282361,40.900270382996],[-73.869932735696,40.900252472864],[-73.869937813044,40.900240195073],[-73.869944873605,40.900239389889],[-73.869941725318,40.900223493689],[-73.869936990244,40.900223397406],[-73.869932338203,40.900222715901],[-73.869927896147,40.900221466427],[-73.869923782686,40.900219684235],[-73.869920108102,40.900217414476],[-73.869916971961,40.900214720294],[-73.869914457196,40.900211674723],[-73.86991263367,40.900208357084],[-73.869911863559,40.900205875381],[-73.869911547493,40.900204857477],[-73.86991123052,40.90020127139],[-73.869911689687,40.900197693382],[-73.869912912936,40.90019422069],[-73.869914866852,40.900190946929],[-73.869917500237,40.900187958486],[-73.869920741721,40.900185337225],[-73.869924504535,40.900183152387],[-73.869928686498,40.900181464187],[-73.869933175966,40.900180316625],[-73.870020952121,40.900170310242],[-73.870024917164,40.900190335181],[-73.870030597182,40.900189687824],[-73.870040713107,40.900240778302],[-73.87005137199,40.900294605963],[-73.869957915648,40.900305259723]]]]} |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | Geometry column used for mapping | — | — |
name | text | Building name (limited to commonly known names). This field has not been actively maintained since the original creation of this dataset. | 100% | Adler Place Town HousesCooper Place Town HousesBroun Place Town Houses |
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. | 0% | 400000030000005000000 |
doitt_id | integer | Consistent unique identifier assigned by OTI (formerly DOITT). |
GET /api/datasets/5zhs-2jue GET /api/datasets/5zhs-2jue/quality GET /api/datasets/5zhs-2jue/related GET /api/columns?dataset=5zhs-2jue
bin| 2019299 |
| 353927 |
| 217.17578125 |
| 2033800084 |
| 229537 |
| 1910 |
| 2100 |
| Photogrammetric |
| 197 |
| 33.49 |
| 2017-08-22T18:57:18.000Z |
| {"type":"MultiPolygon","coordinates":[[[[-73.944297631696,40.626386164317],[-73.944363840136,40.626380395224],[-73.944370823102,40.626426916775],[-73.944304614617,40.626432684972],[-73.944297631696,40.626386164317]]]]} | 3373792 | 273343 | 50.953125 | 3076140055 | 990273 | 1925 | 5110 | Photogrammetric | 24 | 9.16 | 2017-08-17T16:16:44.000Z |
| {"type":"MultiPolygon","coordinates":[[[[-73.904306481667,40.706474946929],[-73.904316259083,40.70646537541],[-73.904279605723,40.706443694826],[-73.904269829488,40.706453266344],[-73.904183939342,40.706402458233],[-73.904246093659,40.706341609222],[-73.904330373445,40.706391464107],[-73.904319145603,40.706402457231],[-73.904357462488,40.706425122544],[-73.904368690326,40.706414130316],[-73.904443956212,40.706458652901],[-73.904381801966,40.706519502018],[-73.904306481667,40.706474946929]]]]} | 4083456 | 480499 | 295.484375 | 4034860061 | 1028988 | 1910 | 2100 | Photogrammetric | 107 | 34.76 | 2020-01-28T17:24:50.000Z |
| {"type":"MultiPolygon","coordinates":[[[[-73.910088335176,40.662852365508],[-73.910239157186,40.662829774057],[-73.910262919923,40.662921771386],[-73.910112097714,40.662944361967],[-73.910088335176,40.662852365508]]]]} | 3345332 | 30050 | 235.44140625 | 3035740001 | 271369 | 1976 | 2100 | Photogrammetric | 30 | 32.33 | 2017-08-22T15:36:25.000Z |
| {"type":"MultiPolygon","coordinates":[[[[-73.903275714256,40.83178750695],[-73.903368510996,40.831650849042],[-73.903350237704,40.831643691001],[-73.903283266765,40.831742316528],[-73.903282659644,40.831743210211],[-73.90318171928,40.831703665816],[-73.903049422295,40.831651838338],[-73.902926292942,40.831603600593],[-73.902880871423,40.83167048896],[-73.902842013236,40.831655265777],[-73.902756423384,40.831621735741],[-73.902751845009,40.831619941696],[-73.902741410975,40.831635307053],[-73.902711024882,40.831680054948],[-73.902702883897,40.831692043577],[-73.902695510384,40.831689154871],[-73.902689330979,40.831698255465],[-73.902621131632,40.831671536939],[-73.902626360548,40.831663836716],[-73.902587655272,40.831648673009],[-73.902574851467,40.831643657242],[-73.902508392806,40.831617621794],[-73.902524554824,40.831593820958],[-73.902458496723,40.831567941605],[-73.902456355651,40.831567102334],[-73.902661535155,40.831264947907],[-73.902695522252,40.831214897342],[-73.902726679661,40.831227103725],[-73.902835653665,40.831269795317],[-73.902918581872,40.831302283884],[-73.903053918571,40.831102982143],[-73.903062554859,40.831090262702],[-73.903102075112,40.83110574481],[-73.903126158849,40.831115179721],[-73.903142788632,40.83109069031],[-73.903151201233,40.831093985984],[-73.903203881905,40.831114623639],[-73.90323465309,40.831126679178],[-73.903218712426,40.831150153421],[-73.903242940752,40.831159644259],[-73.903130355446,40.831325444396],[-73.903110929386,40.8313178333],[-73.903068016331,40.831381030019],[-73.90308258559,40.831386737896],[-73.903044454588,40.831442891348],[-73.903065553728,40.83145115672],[-73.903133857297,40.831477915594],[-73.903161317905,40.831437476702],[-73.903199087134,40.831452272929],[-73.903216124495,40.831427182321],[-73.903251493016,40.831375096733],[-73.903435395925,40.831447141899],[-73.90341111007,40.831482907244],[-73.903395919072,40.831505278131],[-73.903383282472,40.831523887986],[-73.903399439533,40.831530217594],[-73.903446623952,40.83154870195],[-73.903501314324,40.831468162404],[-73.903573664334,40.831361614184],[-73.903563018178,40.831357444094],[-73.903576194089,40.831338039532],[-73.903639553237,40.831362860609],[-73.903676818765,40.831307980438],[-73.903556395856,40.831260804606],[-73.903453377785,40.831220446462],[-73.90353027322,40.831107204186],[-73.903689476896,40.831169573177],[-73.903743805487,40.831089564501],[-73.903589925666,40.831029233353],[-73.903660513134,40.830925280626],[-73.904037085856,40.831072803952],[-73.904071555182,40.83108630764],[-73.904001442229,40.831189561325],[-73.903935815251,40.831163851569],[-73.903893613389,40.831147318434],[-73.903792841646,40.831295723387],[-73.903797367893,40.831297496636],[-73.903848598628,40.831317567274],[-73.903803917217,40.831383369726],[-73.90375233098,40.831363160095],[-73.903726501733,40.831353041283],[-73.90370415978,40.831385942937],[-73.903717983805,40.831391358351],[-73.903674252687,40.831455760374],[-73.903665958504,40.831452510763],[-73.90356185794,40.831605815923],[-73.903583516462,40.831614300488],[-73.903524573869,40.831701103962],[-73.903502915326,40.831692619386],[-73.903444692548,40.831778361736],[-73.903403092368,40.831839623609],[-73.903415994619,40.831844678088],[-73.903372975773,40.831908030613],[-73.903243487604,40.831857302515],[-73.903286453075,40.831794029237],[-73.903287694645,40.831792200472],[-73.903275714256,40.83178750695]]]]} | 2004246 | 156646 | 8818.7890625 | 2026120007 | 876826 | 1927 | 2100 | Photogrammetric | 79 | 118.02 | 2017-08-22T18:08:35.000Z |
| {"type":"MultiPolygon","coordinates":[[[[-73.724877576844,40.726626018403],[-73.724895875496,40.726522242819],[-73.724972415227,40.726530053913],[-73.724950840437,40.726652419089],[-73.724901188731,40.726647352152],[-73.724904466183,40.726628762577],[-73.724877576844,40.726626018403]]]]} | 4167644 | 676231 | 147.5859375 | 4079910014 | 166350 | 1930 | 2100 | Photogrammetric | 88 | 28.71 | 2017-08-22T18:58:40.000Z |
| {"type":"MultiPolygon","coordinates":[[[[-73.792431329579,40.77114097695],[-73.792584460144,40.771124484386],[-73.792594330117,40.771177457301],[-73.792441200619,40.77119394898],[-73.792431329579,40.77114097695]]]]} | 4132837 | 210893 | 135.40234375 | 4059650052 | 197001 | 1940 | 2100 | Photogrammetric | 94 | 25.79929116 | 2017-08-22T19:39:40.000Z |
| {"type":"MultiPolygon","coordinates":[[[[-73.85500291921,40.80683267743],[-73.854995838143,40.8067951357],[-73.854985680466,40.806796241344],[-73.854979071573,40.806761197293],[-73.85498923043,40.806760091651],[-73.854981421833,40.806718689464],[-73.854985833881,40.806718208744],[-73.854982494864,40.806700508826],[-73.855041848854,40.806694045845],[-73.855045186699,40.80671174666],[-73.855053572196,40.806710833291],[-73.855075069694,40.806824821243],[-73.85500291921,40.80683267743]]]]} | 2019898 | 169561 | 160.90234375 | 2034300038 | 144468 | 1930 | 2100 | Photogrammetric | 21 | 15.4 | 2017-08-22T17:50:34.000Z |
| {"type":"MultiPolygon","coordinates":[[[[-74.012466021545,40.60438471769],[-74.012486492915,40.604361117287],[-74.012544227552,40.604390208668],[-74.012523755011,40.604413809082],[-74.012466021545,40.60438471769]]]]} | 3366656 | 904339 | 31.96484375 | 3064610188 | 42219 | 1940 | 5110 | Photogrammetric | 23 | 8.07 | 2017-08-17T16:44:56.000Z |
| {"type":"MultiPolygon","coordinates":[[[[-73.782719298367,40.707580973649],[-73.782791202597,40.707563899625],[-73.782805657212,40.707599149609],[-73.782733752947,40.707616223643],[-73.782719298367,40.707580973649]]]]} | 4590686 | 1175312 | 45.46484375 | 4103170015 | 145973 | 1920 | 5110 | Photogrammetric | 54 | 11.99 | 2017-08-17T16:26:15.000Z |
Showing 12 of 15 columns. All of them are listed below.
| 0% |
799817932369952 |
shape_area | float | Measures the enclosed area within a polygon. | 0% | 134.77734375130.8671875146.2890625 |
base_bbl | text | Borough, block, and lot number for the tax lot that the footprint is physically located within. | 0% | 416350040041635003004163400050 |
objectid | integer | — | 0% | 527545799817932 |
construction_year | integer | — | 1% | 192019301925 |
feature_code | categorical | — | 0% | 210051105100of 10 |
geom_source | categorical | — | 0% | PhotogrammetricOther (Manual)Otherof 3 |
ground_elevation | integer | — | 0% | 103028 |
height_roof | integer | — | 0% | 302728 |
last_edited_date | datetime | — | 0% | 2009-02-14T00:00:00.000Z2022-05-26T17:18:59.000Z2015-01-01T00:00:00.000Z |
last_status_type | categorical | — | 0% | ConstructedAlterationSplitof 12 |
mappluto_bbl | text | — | 0% | 416350040041635003004163400050 |
shape_length | float | — | 0% | 32.714131230834171.38722271981457459.583270392458815 |