About this Dataset

San Francisco Development Pipeline

A. SUMMARY Snapshot of San Francisco's Development Pipeline as of the end of 2025 Q1. Tracking of construction and entitlement activity based on data from Department of Building Inspection's Permit Tracking System and the Planning Department's Project & Permit Tracking System, processed quarterly. For more information, please see http://sfplanning.org/pipeline-report B. HOW THE DATASET IS CREATED The dataset is created by combining projects data from the City Planning Department and permit data from the Building Inspection Department to create a quarterly snapshot that shows when a project is filed to construction. C. Previously Published Quarterly Pipeline Datasets As of the end of 2024 Q3, this page serves as the latest snapshot of San Francisco Development Pipeline and will be updated quarterly. All previously published quarterly snapshots currently hosted as separate datasets on the Open Data Portal, will be retired and removed from the portal. To request previous quarterly snapshots of San Francisco Development Pipeline, please contact dataset owner. D. UPDATE PROCESS The Development Pipeline is updated as a quarterly snapshot of the construction development in the City of San Francisco. E. HOW TO USE THIS DATASET Each row or record is a project or permit. They are fitted with information such as address, block lot, project case number and spatial data that allow users to find the specific project. Each row also contains project specific information such as project description and details to illustrate the scope of the project. F. DATA NOTES Reporting Update Significant data and systems improvements are underway to produce a more accurate quarterly pipeline, so the data may change at any time. Weekly and monthly data on Planning Applications and Building Permits can be accessed via the City's Open Data Portal. Change in Status Definitions The following changes have been made in status definitions since the 2022 Q1 Pipeline Report to align the Quarterly Pipeline Reports with other Housing Reports (Housing Inventory and Regional Housing Needs Allocation (RHNA) Annual Progress) (1) Construction: projects that are authorized for construction deemed to be in the construction stage. A project is considered to be authorized for construction if it has: - an issued full building permit, OR - an issued site permit with an approved first construction document Past definition: projects that had their first inspection were deemed to be in the construction stage. (2) Building Permit Issued: includes projects that have an issued site permit but don’t yet have their first construction document. Housing units for these projects are not yet counted toward RHNA progress. Past definition: included projects with any type of permit (site or full building permit) in the issued status. A data dictionary can be downloaded from the following link: https://sfplanninggis.s3.amazonaws.com/SF+Quarterly+Developement+Pipeline+Data+Definition+12212023.xlsx
Organization: City of San Francisco
Last updated: 2025-03-29T16:48:29.511294
Tags: planning-pipeline-housing-construction-permits-development-residential-commercial-building

Tables

Table 1

@usgov.city_of_san_francisco_san_francisco_development_pipeline.table_1

761.87 KB
2212 rows
66 columns


CREATE TABLE table_1 (
  "blklot" VARCHAR,
  "nameaddr" VARCHAR,
  "approved_date_planning" VARCHAR,
  "has_approved_entitlement" VARCHAR,
  "current_status" VARCHAR,
  "current_status_date" VARCHAR,
  "new_pipeline_units" BIGINT,
  "existing_units" BIGINT,
  "proposed_units" BIGINT,
  "demo_units" BIGINT,
  "net_pipeline_units" BIGINT,
  "completed_new_units" BIGINT,
  "pipeline_affordable_units" BIGINT,
  "aff_estimation_type" VARCHAR,
  "bmr_units_ex_low" BIGINT,
  "bmr_units_very_low" BIGINT,
  "bmr_units_low" BIGINT,
  "bmr_units_moderate" BIGINT,
  "affordability_type" VARCHAR,
  "tenure_type" VARCHAR,
  "case_no" VARCHAR,
  "bpa_no" DOUBLE,
  "bpa_form_no" DOUBLE,
  "is_site_permit" VARCHAR,
  "description_planning" VARCHAR,
  "description_dbi" VARCHAR,
  "non_residential_total_gsf" BIGINT,
  "non_residential_net_gsf" BIGINT,
  "cie_exist" BIGINT,
  "cie" BIGINT,
  "cienet" BIGINT,
  "med_exist" BIGINT,
  "med" BIGINT,
  "mednet" BIGINT,
  "mips_exist" BIGINT,
  "mips" BIGINT,
  "mipsnet" BIGINT,
  "pdr_exist" BIGINT,
  "pdr" BIGINT,
  "pdrnet" BIGINT,
  "ret_exist" BIGINT,
  "ret" BIGINT,
  "retnet" BIGINT,
  "visit_exist" BIGINT,
  "visit" BIGINT,
  "visitnet" BIGINT,
  "planner" VARCHAR,
  "sponsor" VARCHAR,
  "contact" VARCHAR,
  "contactph" VARCHAR,
  "da" VARCHAR,
  "legalization" VARCHAR,
  "adu" VARCHAR,
  "state_density" VARCHAR,
  "planning_district" VARCHAR,
  "sd22" BIGINT,
  "nhood37" VARCHAR,
  "nhood41" VARCHAR,
  "zoning_district" VARCHAR,
  "height_district" VARCHAR,
  "pda" VARCHAR,
  "sud" VARCHAR,
  "planning_area" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "latlong" VARCHAR
);