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/ugxk-ztb8
| 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 (Assessor Block Number) | The full assessor's parcel number is comprised of two parts, the first being the block number. Blocks are assigned by the Office of the Assessor Recorder. You can see a block map here: https://data.sfgov.org/d/ndp2-nsue Blocks are officially recorded in physical block maps. You can find PDFs of those here: https://data.sfgov.org/d/2367-5au8 | block |
| 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 |
| CONTACTADD (Contact Address) | contactadd | |
| CONTACTCITY (Contact City) | contactcity | |
| CONTACTPHONE (Contact Phone) | contactphone | |
| Cult, Inst, Educ | cult_inst_educ | |
| DBI Filed | dbi_filed | |
| DBI Permit ID (Building Permit Application Number) | dbi_permit_id | |
| DBI Project Description | dbi_project_description | |
| EntitlementStatus (Entitlement Status) | entitlementstatus | |
| FirstFiled (First Filed) | firstfiled | |
| FULLNAME (Contact Full Name) | fullname | |
| HEIGHTLIMIT | heightlimit | |
| LANDUSE | landuse | |
| Location 1 (Geometry) | Contains the geometry of the record in Well Known Text (WKT) format. | location_1 |
| LOT (Assessor Lot Number) | The full assessor's parcel number is comprised of two parts, the second being the lot number. Lots are assigned by the Office of the Assessor Recorder and are captured within blocks. You can find a map of the lots here: https://data.sfgov.org/d/45et-ht7c | lot |
| 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 | |
| ObjectID | The system ID generated by Esri ArcGIS software. Not an administrative ID. | objectid |
| 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 | |
| sort (Sort) | sort | |
| Sponsor Firm | sponsor_firm | |
| Sponsor Name | sponsor_name | |
| Total GSF (Commercial) | total_gsf_commercial | |
| Traffic Analysis Zone | A traffic analysis zone (TAZ) is the unit of geography most commonly used in conventional transportation planning models. The size of a zone varies, but for a typical metropolitan planning software, a zone of under 3000 people is common. See the boundaries for the region here: https://data.sfgov.org/d/j4sj-j2nf | traffic_analysis_zone |
| 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 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 |