From a 500-row sample across 71 columns.
the_geomthe_geombctcb2020the_geomcommntydstcouncildstthe_geomthe_geomMappable — Socrata point column `the_geom`.
Open on the map →| the_geom | job_number | job_type | residflag | job_status | permityear | classainit | classaprop | classanet | hotelinit | otherbinit | boro |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40.52822, -74.18835 | 500587750 | New Building | Residential | 3. Permitted for Construction | 2003 | 0.0 | 1.0 | 1.0 | 0 | 0 | 5 |
| 40.59620, -74.06246 | 500636252 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | coordinate | Geometry field used for mapping. | 0% | {'coordinates': [-73.920…{'coordinates': [-74.070…{'coordinates': [-73.918… |
job_number | text | The DOB job application number assigned when the applicant begins the application. This is the unique identifier for the application submitted to the Department of Buildings (DOB). It may contain several work types, and more work types may be added as the application review and the work continues. It is a 9-digit number where the first digit indicates the borough where the building is located. | 0% | 102138820102151083102284172 |
job_type | categorical | DOB's type category for the job application. More information is available here. The following types are included in this database: New Building (NB): an application to build a new structure. “NB” cannot be selected if any existing building elements are to remain—for example a part of an old foundation, a portion of a façade that will be incorporated into the construction, etc. Alteration Type I (A1): a major alteration that will change the use, egress, or occupancy of the building. Demolition ( |
GET /api/datasets/br6q-ssj3 GET /api/datasets/br6q-ssj3/quality GET /api/datasets/br6q-ssj3/related GET /api/columns?dataset=br6q-ssj3
cdta2020cdtaname20the_geom:@computed_region_f5dn_yrer:@computed_region_sbqj_enih:@computed_region_92fq_4b7q+7longitudebinbbl+2| Alteration |
| Residential |
| 3. Permitted for Construction |
| 2003 |
| 2.0 |
| 1.0 |
| -1.0 |
| — |
| — |
| 5 |
| 40.58225, -74.12607 | 500646759 | Alteration | Residential | 5. Completed Construction | 2003 | 1.0 | 1.0 | 0.0 | 0 | 0 | 5 |
| 40.58727, -74.14673 | 500697310 | New Building | Residential | 5. Completed Construction | 2004 | 0.0 | 2.0 | 2.0 | 0 | 0 | 5 |
| 40.50758, -74.24890 | 500702457 | Alteration | Residential | 5. Completed Construction | 2005 | 1.0 | 1.0 | 0.0 | — | — | 5 |
| 40.50845, -74.23896 | 500740344 | Alteration | Residential | 5. Completed Construction | 2004 | 1.0 | 1.0 | 0.0 | — | — | 5 |
| 40.62631, -74.08147 | 500745410 | New Building | Residential | 5. Completed Construction | 2007 | 0.0 | 19.0 | 19.0 | 0 | 0 | 5 |
| 40.55142, -74.15181 | 500771907 | New Building | Residential | 5. Completed Construction | 2005 | 0.0 | 2.0 | 2.0 | 0 | 0 | 5 |
| 40.62188, -74.13144 | 500812150 | New Building | Residential | 3. Permitted for Construction | 2006 | 0.0 | 2.0 | 2.0 | 0 | 0 | 5 |
| 40.62634, -74.09064 | 500903686 | Alteration | Residential | 5. Completed Construction | 2007 | 1.0 | 1.0 | 0.0 | — | — | 5 |
Showing 12 of 63 columns. All of them are listed below.
| 0% |
AlterationNew BuildingDemolitionof 3 |
residflag | text | This field is used to identify jobs in buildings containing residential uses. A value of "residential" indicates that the job affects residential units in some way through new construction, alteration, or demolition. Only those jobs with a value of "residential" are included in the housing database. Manual research was conducted at DCP to help ensure that all work on buildings with residences receive this flag, though some records may remain misclassified. | 0% | Residentialof 1 |
nonresflag | text | This field is used to identify jobs in buildings containing non-residential uses. A value of "non-residential" indicates that the job affects some use type beyond residential, including commercial, industrial, or community facility uses. Mixed-use buildings will have values in both the Resid_Flag and Nonresid_Flag, since they contain both residential and nonresidential uses, but having flags in both of those columns does not necessarily mean that it is a mixed-use development since the flags | 83% | Non-Residentialof 1 |
job_status | categorical | DCP recode of DOB's status label. This describes the status of the job at the date of the data vintage. For example, a job marked as "3. Permitted" was at that status as of June 30, 2020 if using version 20Q2 of the DCP Housing Database. More details on each DOB status is available here: https://www1.nyc.gov/assets/buildings/pdf/bisjobstatus.pdf Jobs typically move through status A through X over time as they reach certain approval milestones: 1. Filed: job application is at status A - G at t | 0% | 5. Completed Constructio…3. Permitted for Constru…1. Filed Applicationof 6 |
compltyear | categorical | Year the job was completed. For new buildings and alterations, this is defined as the year of the first certificate of occupancy issuance. For demolitions, this is the year that the demolition was permitted (reached status Q). | 39% | 201020172019of 17 |
permityear | text | Year the job was permitted. For all job types, this is defined as the status Q year. | 24% | 201520172016 |
classainit | integer | Number of units that initially existed in the building at the time of the job application, as reported by the applicant. This field is edited by DCP to only count Class A units, which are units in houses or apartment buildings intended for long-term residential use (greater than 30 days), and typically do not require the use of shared kitchens and bathrooms. The definition of Class A and other unit types is available here: https://www1.nyc.gov/assets/buildings/pdf/MultipleDwellingLaw.pdf | 1% | 0.01.02.0 |
classaprop | integer | Number of units proposed in the job application after the proposed work has been completed, as reported by the applicant and edited by DCP to count only Class A units. | 0% | 2.01.00.0 |
classanet | integer | Net change in Class A unit count between the number of units existing at the time of application and the number of units proposed. | 1% | 0.01.02.0 |
hotelinit | integer | Number of hotel units that initially existed in the building at the time of the job application, as determined through DCP research. Note that hotel units are a subtype of Class B units which are typically occupied as for-profit businesses for short-term (less than 30 days), full-service lodging. | 64% | 04370 |
hotelprop | integer | Number of hotel units proposed in the job application after the proposed work has been completed, as determined through DCP research. | 82% | 03053 |
otherbinit | integer | Number of Class B units (excluding hotel units) that initially existed in building at the time of the job application, as determined through DCP research. Other Class B units include all dwellings that are not Class A units or hotels, and may include single room occupancy units, dormitories, certain kinds of supportive housing and assisted living, homeless shelters, convents and monasteries, among many other forms of temporary lodging or lodging with communal kitchens or bathrooms. The definitio | 64% | 087 |
otherbprop | integer | Number of Class B units (excluding hotel units) proposed in the job application after the proposed work has been completed, as determined through DCP research. | 82% | 012 |
units_co | integer | Number of dwelling units provided on the temporary or final certificates of occupancy. This unit count may include Class A units in addition to Class B units and hotel units. | 49% | 2.01.03.0 |
boro | categorical | The NYC borough code where the proposed work will take place. | 0% | 345of 5 |
bin | text | Building Identification Number (BIN), supplied by Geosupport, that identifies each unique building in the city. | 0% | 517530344666451813886 |
bbl | text | Borough-Block-Lot tax ID number of the parcel where the proposed work will take place. | 0% | 416350040041635003004163400050 |
addressnum | text | The house number for the building where the proposed work will take place. | 0% | 151125 |
addressst | text | The street name for the building where the proposed work will take place. | 0% | BROADWAYBEDFORD AVENUE5 AVENUE |
occ_init | text | Description of the existing occupancy type at the time of the job application. This indicates what a site was used for before the proposed job. It is a more descriptive recode of the occupancy code that the applicant submitted to DOB as the initial occupancy type of the building. Note that the applicant may only choose one occupancy code, even in a building containing multiple uses, so this code is only able to describe one of many possible uses. | 14% | Empty SiteResidential: Not Specifi…Residential: 1-2 Family … |
occ_prop | text | Description of the proposed occupancy type at the time of the job application. This indicates what a site will be used for after the proposed job is complete. It is a more descriptive recode of the occupancy code that the applicant submitted to DOB as the proposed occupancy type of the building. Note that the applicant may only choose one occupancy code, even in a building containing multiple uses, so this code is only able to describe one of many possible uses. | 18% | Residential: 1-2 Family …Residential: 3 or More U…Empty Site |
bldg_class | text | Building Class code. A code used by Department of Finance (DOF) and Department of Buildings (DOB) describing the major use of a structure. | 1% | A1OtherB2 |
job_desc | text | The general description of the work being applied for. This field is free text, and is filled out by the applicant. | 32% | DEMOLITION OF STRUCTURENEW BUILDINGTHIS JOB IS FILED FOR DE… |
datefiled | datetime | Date of job status A (pre-filing application). This is the first step in the process for all job applications. The job application # is assigned at this status. This occurs when the applicant submits any part of the application (even a single form), in person or electronically. | 0% | 2014-12-30T00:00:00.0002007-12-18T00:00:00.0002019-06-28T00:00:00.000 |
datepermit | datetime | Date of job status Q (first partial permit issuance). This is when construction work may begin. This field should be used for identifying the number of permits approved in a given year. | 24% | 2008-07-29T00:00:00.0002008-07-30T00:00:00.0002008-06-27T00:00:00.000 |
datelstupd | datetime | The date of the last update to the DOB record for the job filing. | 0% | 2026-06-24T00:00:00.0002026-06-26T00:00:00.0002026-06-25T00:00:00.000 |
datecomplt | datetime | DCP's best estimate of completion date for all jobs. For new buildings and alterations, date complete is equal to the date of the earliest certificate of occupancy. For demolitions, date complete is equal to status Q (permit issued), since demolitions do not receive certificates of occupancy. Blank indicates no certificate of occupancy has been issued. Typically, a building can be considered complete at this stage. Large buildings with many units may have units receiving certificates of occupanc | 39% | 2013-10-23T00:00:00.0002017-11-30T00:00:00.0002017-02-16T00:00:00.000 |
zoningdst1 | text | The primary zoning district of the tax lot per the applicant at time of application. For more information see http://www1.nyc.gov/site/planning/zoning/about-zoning.page. | 20% | R6R5R6B |
zoningdst2 | text | The secondary zoning district of the tax lot per the applicant at time of application. | 96% | R6R6BR5 |
zoningdst3 | text | The tertiary zoning district of the tax lot per the applicant at time of application. | 100% | R6BR6AR6 |
specldst1 | text | The primary special zoning district of the tax lot per the applicant at time of application. Other zoning designations may appear in this field, such as industrial business zones (IBZ), mandatory inclusionary housing (MIH) areas, or other zoning designations. This field is provided by the applicant, and is likely inconsistent. | 87% | SRDOPSRD - SOUTH RICHMOND DEV… |
specldst2 | text | The secondary special zoning district of the tax lot per the applicant at time of application. | 93% | MS4SRDGW |
landmark | text | Indicates that the building has been designated as a landmark building by the Landmarks Preservation Commission. | 94% | Yesof 1 |
floorsinit | integer | The existing number of stories/floors in the building, as reported by the applicant. | 30% | 2.03.01.0 |
floorsprop | integer | The number of stories/floors in the building after the work is done, as reported by the applicant. | 11% | 2.03.04.0 |
enlargemnt | categorical | This indicates if the work to be done under the application will result in a horizontal and/or vertical enlargement, as reported by the applicant. Values include: Horizontal, Vertical, Horizontal and Vertical, [blank]. | 89% | Horizontal and VerticalHorizontalVerticalof 3 |
ownership | text | This indicates whether the property is government owned, the ownership structure, and non-profit status, as reported by the applicant and recoded by DCP. | 0% | Private For-Profit: Indi…Private For-Profit: Corp…Private For-Profit: Part… |
cenblock20 | text | 2020 Census Block FIPS code. | 0% | 360471070011011360850020012001360850226021001 |
centract20 | text | 2020 Census Tract FIPS code. | 0% | 360810916033608501120336085019800 |
bctcb2020 | text | The Borough - 2020 Census Tract - Census Block code. | 0% | 310700110115002001200150226021001 |
bct2020 | text | The Borough - 2020 Census Tract code. | 0% | 409160350112035019800 |
nta2020 | text | 2020 Neighborhood Tabulation Area (NTA) code. | 0% | SI0304BK0301QN1403 |
ntaname20 | text | 2020 Neighborhood Tabulation Area (NTA) descriptive name. | 0% | Annadale-Huguenot-Prince…Bedford-Stuyvesant (West…Breezy Point-Belle Harbo… |
cdta2020 | text | 2020 Community District Tabulation Area (NTA) code. | 0% | SI03QN07SI02 |
cdtaname20 | text | 2020 Community District Tabulation Area (NTA) descriptive name. | 0% | SI03 South Shore (CD 3 A…QN07 Flushing-Murray Hil…SI02 Mid-Island (CD 2 Ap… |
commntydst | text | NYC Community District code. | 0% | 503407502 |
councildst | text | NYC City Council District code. | 0% | 505119 |
schsubdist | text | NYC School Subdistrict code. | 0% | 31_131_331_4 |
schcommnty | text | NYC Community School District code. | 0% | 310227 |
schelmntry | coordinate | NYC Elementary School Zone code. | 0% | 404.047.0502.0 |
schmiddle | coordinate | NYC Middle School Zone code. | 0% | 404.0275.0284.0 |
firecmpany | text | NYC Fire Company code. | 0% | E329E295L081 |
firebattln | text | NYC Fire Battalion code. | 0% | 235253 |
firedivsn | categorical | NYC Fire Division code. | 0% | 140811of 14 |
policepcnt | text | NYC Police Precinct code. | 0% | 122109123 |
pl_firm07 | text | A value of 1 means that some portion of the tax lot falls within the 1% annual chance floodplain as determined by FEMA’s 2007 Flood Insurance Rate Map. Note that buildings on the tax lot may or may not be in the portion of the tax lot that is within the 1% annual chance floodplain. | 93% | 1of 1 |
pl_pfirm15 | text | A value of 1 means that some portion of the tax lot falls within the 1% annual chance floodplain as determined by FEMA’s 2015 Preliminary Flood Insurance Rate Map. Note that buildings on the tax lot may or may not be in the portion of the tax lot that is within the 1% annual chance floodplain. | 90% | 1of 1 |
latitude | float | Latitude in WGS84 / SRID:4326 | 0% | 40.55688140.60622740.561655 |
longitude | float | Longitude in WGS84 / SRID:4326 | 0% | -73.920731-74.070346-73.918184 |
geomsource | categorical | Source of the geographic coordinates for the record. | 0% | BIN DOB buildingfootprin…Lat/Lon geosupportBBL DOB MapPLUTOof 6 |
dcpedited | text | List of fields that were edited by DCP. This only lists fields where original DOB source data was overwritten by DCP, and doesn't include fields where DCP recodes data as part of the standard methodology. | 90% | classa_inithotel_prop/otherb_propotherb_prop/hotel_prop |
version | text | Version of the Developments Database. | 0% | 26Q2.1of 1 |
hpdaffrdbl | integer | Affordable units associated with a given project. | 97% | 3.02.08.0 |
hpd_id | text | Unique ID assigned to a project by Housing Preservation and Development. | 96% | Multiple74145/99250045990/952434 |
hpd_jobrel | categorical | The relationship between DOB and HPD records. This relationship can be one-to-one, one-to-many, many-to-one, or many-to-many. | 96% | one-to-oneone-to-manymany-to-oneof 4 |