From a 500-row sample across 28 columns.
tax_lotbbltax_block:@computed_region_sbqj_enih:@computed_region_92fq_4b7qborough+5the_geom:@computed_region_sbqj_enih:@computed_region_92fq_4b7qMappable — Socrata point column `the_geom`.
Open on the map →| borough | tax_block | tax_lot | bbl | billbbl | cd | agency | use_code | use_type | non_city_ownership | category_code | expanded_category_code |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | 8591 | 175 | 3085910175.0 | 3085910175.0 | 318 | DSBS | 1500 | NO USE | C | 3 | 8 |
| 4 | 4213 | 13 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | categorical | NYC borough - 1 (Manhattan), 2 (Bronx), 3 (Brooklyn), 4 (Queens), 5 (Staten Island) | 0% | 345of 5 |
tax_block | integer | The tax block in which the tax lot is located. Each tax block is unique within a borough. | 0% | 3404792334 |
tax_lot | integer | The number of the tax lot. Each tax lot is unique within a tax block. | 0% | 11002 |
bbl | integer | 10-digit identifier for a tax lot, consisting of the borough code followed by the tax block followed by the tax lot. The borough code is one numeric digit. The tax block is one to five numeric digits, preceded with leading zeros when the block is less than five digits. The tax lot is one to four digits and is preceded with leading zeros when the lot is less than four digits. For condominiums, this is usually the unit BBL. |
GET /api/datasets/fn4k-qyk2 GET /api/datasets/fn4k-qyk2/quality GET /api/datasets/fn4k-qyk2/related GET /api/columns?dataset=fn4k-qyk2
boroughboroughlongitudeagency+3:@computed_region_sbqj_enih:@computed_region_92fq_4b7q:@computed_region_f5dn_yrer+3| 4042130013.0 |
| 4042130013.0 |
| 407 |
| DSBS |
| 1500 |
| NO USE |
| C |
| 3 |
| 8 |
| 2 | 2606 | 200 | 2026060200 | 2026060200 | 202 | DSBS | 1530 | NO USE-WATERFRONT (ANY AGENCY) | C | 3 | 8 |
| 5 | 3762 | 43 | 5037620043.0 | 5037620043.0 | 502 | DEP | 471 | NATURAL AREA/WETLAND/WILDLIFE REFUGE | C | 1 | 3 |
| 2 | 5637 | 100 | 2056370100 | 2056370100 | 210 | DCAS | 1520 | NO USE-VACANT LAND | C | 3 | 8 |
| 3 | 5391 | 1 | 3053910001.0 | 3053910001.0 | 312 | EDUC | 212 | INTERMEDIATE SCHOOL | C | 1 | 2 |
| 5 | 5317 | 106 | 5053170106.0 | 5053170106.0 | 503 | PARKS | 440 | PARK | C | 1 | 3 |
| 1 | 1790 | 9 | 1017900009.0 | 1017900009.0 | 111 | HPD | 1520 | NO USE-VACANT LAND | C | 3 | 8 |
| 3 | 3092 | 1 | 3030920001.0 | 3030920001.0 | 301 | DEP | 1300 | MISCELLANEOUS USE | C | 1 | — |
| 3 | 5982 | 29 | 3059820029.0 | 3059820029.0 | 310 | DCAS | 1520 | NO USE-VACANT LAND | C | 3 | 8 |
Showing 12 of 26 columns. All of them are listed below.
| 0% |
4022740002.01001210001.01000670001.0 |
billbbl | integer | The mapped BBL is the BBL used to map the record. For condominium lots, the mapped BBL is the billing BBL, which is the 75nn-series record shown on the tax map and in MapPLUTO. It is generally associated with the condominium management organization. For air rights lots, the mapped BBL is the donating BBL from the Air_Rights_Lot table in the Department of Finance's Digital Tax Map. If there is more than one donating BBL, the one whose lot number most closely matches that of the air rights lot is | 0% | 4022740002.01001210001.01000670001.0 |
cd | integer | The community district or joint interest area for the tax lot. The city is divided into 59 community districts and 12 joint interest areas, which are large parks or airports that are not considered part of any community district. This field consists of three digits, the first of which is the borough code. The second and third digits are the community district or joint interest area number, whichever is applicable. | 0% | 503502414 |
house_number | text | House number | 46% | 11002 |
street_name | text | Name of the street | 4% | BROADWAYRICHMOND TERRACEUNION STREET |
address | text | House number and street name | 4% | EUGENE STREETDAMON STREETAMBOY ROAD |
parcel_name | text | Name of the parcel or facility on the lot. DCP applies some modifications to parcel names to improve readability. Some abbreviations are expanded programmatically. Other modifications are made after manual research. For the latter, DCPEDITED = "Y". | 21% | RED HOOK CONTAINER TERMI…BLUE HERON PARK PRESERVELONG POND PARK |
agency | text | Abbreviation for agency or entity using the lot. See appendix A for a list of abbreviations with their full name. | 0% | PARKSDCASEDUC |
use_code | integer | The use code indicates how the lot is being used by the agency. See Appendix B for a complete list of use codes and descriptions. | 0% | 4711520440 |
use_type | text | Description of how the lot is being used by the agency. See Appendix B for a complete list of use codes and descriptions. | 0% | NATURAL AREA/WETLAND/WIL…NO USE-VACANT LANDPARK |
non_city_ownership | categorical | Type of owner | 0% | COPof 5 |
category_code | categorical | Category classifies lots as non-residential properties with a current use, residential properties, or properties without a current use. | 0% | 132of 3 |
expanded_category_code | categorical | This categorization classifies records into broad groups based on use. Valid values are 1 - 9. | 0% | 387of 9 |
excatdesc | categorical | Descriptions for the expanded category values. See EXPANDCAT for the domain values. | 0% | CULTURAL & RECREATIONAL …PROPERTY WITH NO USEMAINTENANCE, STORAGE, & …of 9 |
leased_properties | text | A value of "L" indicates that the agency's use of the property is authorized through a lease. For questions about the lease or ownership status of specific lots, please contact DCAS at (212) 386-0622 or RESPlanning311@dcas.nyc.gov. | 95% | Lof 1 |
final_commitment | text | A value of "D" indicates potential disposition by the City. | 96% | Dof 1 |
agreement | categorical | For City-owned properties that are leased to another entity, this field indicates whether the agreement is short-term, long-term, or there are both short- and long-term agreements present. | 100% | LSMof 3 |
x_coordinate | integer | X coordinate based on the Geosupport label point for the billing BBL. Coordinate system is NAD 1983 State Plane New York Long Island FIPS 3104 Feet. | 0% | 1031933983231982037 |
y_coordinate | integer | Y coordinate based on the Geosupport label point for the billing BBL. Coordinate system is NAD 1983 State Plane New York Long Island FIPS 3104 Feet. | 0% | 199455199032197460 |
latitude | float | Latitude based on the Geosupport label point for the billing BBL. Coordinate system is NAD_1983. | 0% | 40.71400640.71297440.708659 |
longitude | float | Longitude based on the Geosupport label point for the billing BBL. Coordinate system is NAD_1983. | 0% | -73.827997-74.003676-74.007982 |
the_geom | coordinate | Point geometry type | 0% | {'coordinates': [-73.827…{'coordinates': [-74.003…{'coordinates': [-74.007… |