From a 500-row sample across 14 columns.
condo_base_bblcondo_base_blockcondo_base_boro+4| condo_base_boro | condo_base_block | condo_base_lot | condo_base_bbl | condo_number | condo_key | condo_base_bbl_key | unit_boro | unit_block | unit_lot | unit_bbl | unit_designation |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 4 | 1 | 1000040001 | 835 | 100835 | 1000040001100835 | 1 | 4 | 1001 | 1000041001 | SUB-A |
| 1 | 4 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
condo_base_boro | categorical | This is a one digit number field that identifies the borough in which the associated feature exists. | 0% | 134of 5 |
condo_base_block | integer | Block is a five digit numeric field that identifies the block on which the associated feature exists. | 0% | 1639443943 |
condo_base_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% | 1325 |
condo_base_bbl | 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. |
GET /api/datasets/eguu-7ie3 GET /api/datasets/eguu-7ie3/quality GET /api/datasets/eguu-7ie3/related GET /api/columns?dataset=eguu-7ie3
| 1 |
| 1000040001 |
| 835 |
| 100835 |
| 1000040001100835 |
| 1 |
| 4 |
| 1002 |
| 1000041002 |
| SUB-B |
| 1 | 4 | 1 | 1000040001 | 835 | 100835 | 1000040001100835 | 1 | 4 | 1003 | 1000041003 | CELLA |
| 1 | 4 | 1 | 1000040001 | 835 | 100835 | 1000040001100835 | 1 | 4 | 1004 | 1000041004 | PLA-A |
| 1 | 4 | 1 | 1000040001 | 835 | 100835 | 1000040001100835 | 1 | 4 | 1005 | 1000041005 | PLA-B |
| 1 | 4 | 1 | 1000040001 | 835 | 100835 | 1000040001100835 | 1 | 4 | 1006 | 1000041006 | 2 |
| 1 | 4 | 1 | 1000040001 | 835 | 100835 | 1000040001100835 | 1 | 4 | 1007 | 1000041007 | 3 |
| 1 | 4 | 1 | 1000040001 | 835 | 100835 | 1000040001100835 | 1 | 4 | 1008 | 1000041008 | 4 |
| 1 | 4 | 1 | 1000040001 | 835 | 100835 | 1000040001100835 | 1 | 4 | 1009 | 1000041009 | 5 |
| 1 | 4 | 1 | 1000040001 | 835 | 100835 | 1000040001100835 | 1 | 4 | 1010 | 1000041010 | 6 |
Showing 12 of 14 columns. All of them are listed below.
| 0% |
203944000320394301002039380002 |
condo_number | integer | A concatenation of the Condo Boro and Condo Number Fields in a 6-digit format | 0% | 2322589 |
condo_key | integer | A concatenation of the Condo Boro and Condo Number Fields in a 6-digit format | 0% | 200023200002102589 |
condo_base_bbl_key | text | A concatenation of the Condo_Base_BBL, Condo_Boro, and Condo_Number fields. | 0% | 203944000320000220394301002000232039380002200023 |
unit_boro | categorical | This is a one digit number field that identifies the borough in which the associated feature exists. | 0% | 134of 6 |
unit_block | integer | Block is a five digit numeric field that identifies the block on which the associated feature exists. | 0% | 1639443943 |
unit_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% | 100110021003 |
unit_bbl | 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% | 101006150210100615011010061503 |
unit_designation | text | The official unit designation for the associated feature | 2% | 213A |
floor_text | text | This field indicates on which building floor(s) the Condo Unit exists on | 95% | 32Cellar |
model | categorical | — | 0% | TDBof 3 |
geometry_type | categorical | — | 0% | TablePolygonof 2 |
effective_tax_year | text | — | 58% | 2009-20102010-20112011-2012 |