From a 500-row sample across 12 columns.
bblthe_geomthe_geombblthe_geomHas borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| the_geom | boro | block | lot | bbl | bill_bbl_flag | nycmap_bldg_flag | value_reflected_out_flag |
|---|---|---|---|---|---|---|---|
| {"type":"MultiPolygon","coordinates":[[[[-73.941688701483,40.843568016266],[-73.941996712959,40.843697118916],[-73.941816324811,40.843940727946],[-73.94181100945,40.843947904894],[-73.941491169461,40.843813844213],[-73.941688701483,40.843568016266]]]]} | 1 | 2139 | 181 | 1021390181 | 0 | 1 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.986579608885,40.731727503983],[-73.986765682638,40.731472690657],[-73.986843072,40.731505379416],[-73.986656998452,40.731760192866],[-73.986646398136,40.73175571571],[-73.986579608885,40.731727503983]]]]} | 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | Geometry field used for mapping. Geometry Type: MultiPolygon | — | — |
boro | categorical | This is a one digit number field that identifies the borough in which the associated feature exists. | 0% | 435of 5 |
block | integer | Block is a five digit numeric field that identifies the block on which the associated feature exists. | 0% | 292574054452 |
lot | integer | Lot is a four digit numeric field that identifies a unique lot within a tax block. Although DOF has a set of defined limits for different types of lots, the fact that there are exceptions to these rules makes it impossible to use a domain for validity checking of the lot numbers. | 0% | 1 |
GET /api/datasets/i38t-6if2 GET /api/datasets/i38t-6if2/quality GET /api/datasets/i38t-6if2/related GET /api/columns?dataset=i38t-6if2
bbl| 468 |
| 49 |
| 1004680049 |
| 0 |
| 1 |
| 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.999703636479,40.716440247056],[-73.999621130202,40.71641120663],[-73.999777655226,40.716157703191],[-73.999860240676,40.716186614919],[-73.999703636479,40.716440247056]]]]} | 1 | 199 | 32 | 1001990032 | 0 | 1 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-74.003177199734,40.721122767428],[-74.003477698919,40.721298966482],[-74.003423176908,40.72136272593],[-74.003105960505,40.721206760939],[-74.003120447365,40.72118968103],[-74.003177199734,40.721122767428]]]]} | 1 | 229 | 12 | 1002290012 | 0 | 1 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-74.006714536518,40.732115536463],[-74.006723446415,40.732059815217],[-74.007180435857,40.732102975045],[-74.007171527259,40.732158696325],[-74.006714536518,40.732115536463]]]]} | 1 | 605 | 39 | 1006050039 | 0 | 1 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.978742470835,40.780035318909],[-73.978559960168,40.78028536964],[-73.978545322059,40.780279208167],[-73.978498968679,40.780259698114],[-73.978681479504,40.780009648181],[-73.978742470835,40.780035318909]]]]} | 1 | 1147 | 17 | 1011470017 | 0 | 1 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-74.005606636902,40.738995204146],[-74.005858730563,40.738995152946],[-74.005913996435,40.738995164173],[-74.005975359336,40.73899517576],[-74.006021652414,40.73899518459],[-74.006020217264,40.73904074703],[-74.006019179126,40.739073684114],[-74.005926051519,40.73907366646],[-74.005839421874,40.739073649808],[-74.005595833288,40.739073784169],[-74.005606636902,40.738995204146]]]]} | 1 | 627 | 13 | 1006270013 | 0 | 1 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.981072757714,40.721794952894],[-73.981123053656,40.721726035287],[-73.981170316299,40.721661274089],[-73.98121689331,40.721597452212],[-73.981262552794,40.721534887223],[-73.981376954262,40.721583126413],[-73.981313551224,40.721670004764],[-73.981343704413,40.721682719337],[-73.98121731181,40.721855908282],[-73.981072757714,40.721794952894]]]]} | 1 | 385 | 30 | 1003850030 | 0 | 0 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.993307121805,40.732142534822],[-73.993454608838,40.732205390372],[-73.993284665747,40.732427325437],[-73.993137156211,40.732364499182],[-73.993307121805,40.732142534822]]]]} | 1 | 561 | 9 | 1005610009 | 0 | 1 | 0 |
| {"type":"MultiPolygon","coordinates":[[[[-73.989544588011,40.716602479169],[-73.989615604009,40.716624648858],[-73.9895459993,40.716760160145],[-73.989474052259,40.716738310038],[-73.989544588011,40.716602479169]]]]} | 1 | 310 | 18 | 1003100018 | 0 | 1 | 0 |
2015bbl | text | BBL is a concatenation of Boro-Block-Lot and is stored with every instance of those three fields. Although the BBL value can always be determined dynamically, this field is maintained in order to simplify indexing, searching and the use of the files by other, as yet undetermined, applications. | 0% | 507055000120999989005003190001 |
condo_flag | text | The lot defines a condominium complex | 99% | Cof 1 |
reuc_flag | text | An REUC easement exists on part or all of this lot. | 99% | Rof 1 |
air_lot_flag | text | An air rights easement exists on this lot. | 100% | Aof 1 |
sub_lot_flag | text | A subterranean easement exists on part or all of this lot. | 100% | Sof 1 |
easement_flag | text | A land easement exists on part or all of this lot | 96% | Eof 1 |
lot_note | text | Notes | 100% | Add Lot faces for Block …Lot was not in COGISNo dimension has been ca… |
effective_tax_year | text | Effective Tax Year | 95% | 2007-20082008-20092006-2007 |
bill_bbl_flag | categorical | This field is used to identify the source of the Billing BBL Lot Number. | 1% | 01of 2 |
nycmap_bldg_flag | categorical | This field is used to identify those lots where a building footprint associated with that lot extends beyond the lot boundary. | 1% | 012of 3 |
conversion_exception_flag | categorical | Conversion Exception Flag | 31% | 019of 4 |
value_reflected_out_flag | categorical | This flag identifies those lots whose assessed value has been transferred to another lot. | 2% | 012of 7 |