Skip to main content
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Skip to content
This is a Non-Federal dataset covered by different Terms of Use than Data.gov.

Housing Production - 2005-present

Metadata Updated: April 12, 2025

A. SUMMARY This dataset includes completed and partially completed building permits that have resulted in the addition or loss of residential units since 2005, through construction of new units, demolition of existing units, or alteration of existing residential structures. This dataset also includes the number of affordable (below market rate) units by their affordability levels.

B. HOW THE DATASET IS CREATED This data is primarily based on unit-changing permits in DBI’s permit tracking system (PTS). It also includes occasional records related to housing developments that don’t fall under DBI’s purview (e.g. developments on State lands). The completion of permits is determined in different ways: 1) DBI’s data on the issuance of Certificate of Final Completion (CFC) or Temporary Certificate of Occupancy (TCO), which covers the majority of housing unit completions since 2018 2) Permit complete status in DBI’s Permit Tracking System, 3) manual review of Planning Department’s legacy Housing Inventory data going back to 2005. Data on the affordability of units is primarily obtained from MOHCD’s Affordable Pipeline and Affordable Portfolio. When exact data on AMI levels is not available, but the total number of affordable units is known, the AMI levels are estimated based on similar projects. This data is maintained in Planning Department’s Housing Information System.

C. UPDATE PROCESS The Planning Department’s Data and Analytics Group (DAG) updates this dataset annually on April 1. The underlying data for this dataset is maintained and updated in Planning Department’s Housing Information System, which is updated through automated data pipelines every day.

D. HOW TO USE THIS DATASET This dataset can be used to track housing production trends in San Francisco. Note that the first and latest completion dates are often the same because, for most permits, all units are deemed complete at the same time. But if units of a permit are completed at different times (through multiple TCOs/CFC) these dates show the first TCO date and the latest TCO, CFC, or PTS completion date. The latest completion date is not necessarily the same as the final completion date, as the permit may be partially completed, and more units could be expected to be completed in the future.

E. RELATED DATASETS Dwelling Unit Completion Counts by Building Permit
Affordable Housing Pipeline Mayor's Office of Housing and Community Development Affordable Housing Portfolio

Access & Use Information

Public: This dataset is intended for public access and use. Non-Federal: This dataset is covered by different Terms of Use than Data.gov. License: See this page for license information.

Downloads & Resources

Dates

Metadata Created Date December 9, 2023
Metadata Updated Date April 12, 2025

Metadata Source

Harvested from SFO JSON

Additional Metadata

Resource Type Dataset
Metadata Created Date December 9, 2023
Metadata Updated Date April 12, 2025
Publisher data.sfgov.org
Maintainer
Identifier https://data.sfgov.org/api/views/xdht-4php
Data First Published 2024-05-02
Data Last Modified 2025-04-07
Category Housing and Buildings
Public Access Level public
Metadata Context https://project-open-data.cio.gov/v1.1/schema/catalog.jsonld
Metadata Catalog ID https://data.sfgov.org/data.json
Schema Version https://project-open-data.cio.gov/v1.1/schema
Catalog Describedby https://project-open-data.cio.gov/v1.1/schema/catalog.json
Harvest Object Id 64dd3d36-65bf-4f30-975b-ffcb1137c558
Harvest Source Id 8507fa43-f429-4095-b732-2177330ce485
Harvest Source Title SFO JSON
Homepage URL https://data.sfgov.org/d/xdht-4php
License https://www.usa.gov/government-works
Source Datajson Identifier True
Source Hash 8003e112446198673e0a38be5ca06494759f00875398ea81a7eb2c68e64d1ccb
Source Schema Version 1.1

Didn't find what you're looking for? Suggest a dataset here.