Snapshot of San Francisco Development Pipeline. Tracking of construction and entitlement activity based on data from Dept of Building Inspection's Permit Tracking and the Planning Department's Case Tracking enterprise databases, processed quarterly.
Publishing Department: Planning
Dataset Link: https://data.sfgov.org/d/b2bw-u33d
| Field Name (opt. alias) | Field Definition | API Key |
|---|---|---|
| Best Date | The date of the most recent action leading to the best known status value, i.e. a project's current pipeline status. For example, would be the date building permit application is filed if the best known status is equal to BP Filed) | best_date |
| Best Stat (Best Status) | This is the best known status of the project, it can be one of the following: BP Approved - DBI approved building permit BP Issued - Project sponsor has picked up approved building permit (proxy measure for under construction) BP Reinstated - DBI reinstates a lapsed building permit (lapses after 1 year with no activity) BP Filed - Application for building permit filed with DBI PL Approved - All Planning actions approved PL Filed - Project application filed with the Planning Department Construction - Project is under construction | best_stat |
| Block Lot (Assessor Parcel Number) | An asessor's parcel number, or APN, is a number assigned to parcels of real property by the Office of the Assessor Recorder for purposes of identification and record-keeping. It is sometimes referred to as the blocklot in City data. It is made up of two parts, the Assessor Block Number and the Assessor Lot Number. You can find a map of the lots here: https://data.sfgov.org/d/45et-ht7c | block_lot |
| Cult, Inst, Educ | cult_inst_educ | |
| DBI Filed | dbi_filed | |
| DBI Permit | dbi_permit | |
| DBI Project Description | dbi_project_description | |
| EntitlementStatus (Entitlement Status) | entitlementstatus | |
| FirstFiled (First Filed) | firstfiled | |
| HEIGHTLIMIT | heightlimit | |
| LANDUSE | landuse | |
| Location 1 (Geometry) | Contains the geometry of the record in Well Known Text (WKT) format. | location_1 |
| Medical | medical | |
| Net Added SF | net_added_sf | |
| Net Added Units (Net Units) | Net dwelling units. The total number of units less any unit removals. | net_added_units |
| Net Cult, Inst, Educ | net_cult_inst_educ | |
| Net Medical | net_medical | |
| Net Office | net_office | |
| Net Prod, Dist, Rep | net_prod_dist_rep | |
| Net Ret, Ent | net_ret_ent | |
| Net Visitor | net_visitor | |
| Office | office | |
| Planning Filed | planning_filed | |
| Planning ID (Planning Case Number) | The unique case number used to identify projects moving through the Planning Department. | planning_id |
| Planning Neighborhood (Neighborhoods - Planning Boundaries) | planning_neighborhood | |
| Planning Project Description | planning_project_description | |
| Prod, Dist, Rep | prod_dist_rep | |
| Ret, Ent | ret_ent | |
| TAZ | taz | |
| Total GSF (Commercial) | total_gsf_commercial | |
| Units | units | |
| Visitor | visitor | |
| ZONING (Zoning Use District) | Zoning regulations govern how land can be used in various geographic areas of San Francisco called "zoning use districts" (also known as "zoning," "zones" or "use districts"). For example, zoning regulations might: govern sizes and shapes of buildings; limit the number of units or apartments that can exists on a property; require the accommodation of car parking off of the street; set controls on planting street trees under certain circumstances; specify how late a business can remain open at night. For each use of land (also known as "land uses" or "uses") in any given zone, zoning regulations are specified in detail in a legislative policy document called the [San Francisco Planning Code](http://library.amlegal.com/nxt/gateway.dll/California/planning/planningcode?f=templates$fn=default.htm$3.0$vid=amlegal:sanfrancisco_ca$sync=1) You can access the districts data here: https://data.sfgov.org/d/8br2-hhp3 | zoning |
| Zoning_Generalized (Zoning Generalized) | zoning_generalized | |
| Zoning_Simplified (Zoning Use District) | Zoning regulations govern how land can be used in various geographic areas of San Francisco called "zoning use districts" (also known as "zoning," "zones" or "use districts"). For example, zoning regulations might: govern sizes and shapes of buildings; limit the number of units or apartments that can exists on a property; require the accommodation of car parking off of the street; set controls on planting street trees under certain circumstances; specify how late a business can remain open at night. For each use of land (also known as "land uses" or "uses") in any given zone, zoning regulations are specified in detail in a legislative policy document called the [San Francisco Planning Code](http://library.amlegal.com/nxt/gateway.dll/California/planning/planningcode?f=templates$fn=default.htm$3.0$vid=amlegal:sanfrancisco_ca$sync=1) You can access the districts data here: https://data.sfgov.org/d/8br2-hhp3 | zoning_simplified |