Snapshot of San Francisco Development Pipeline. Tracking of construction and entitlement activity based on data from Department of Building Inspection's Permit Tracking and the Planning Department's Project & Permit Tracking System, processed quarterly.

The Board of Supervisors passed Ordinance No. 53-15 requiring the San Francisco Planning Department to monitor and report bi-annually on the Housing Balance between new market rate housing and new affordable housing production.

Snapshot of San Francisco Development Pipeline. Tracking of construction and entitlement activity based on data from Department of Building Inspection's Permit Tracking and the Planning Department's Project & Permit Tracking System, processed quarterly.

A. SUMMARY

This dataset reports the number of new residential units made available for occupancy in San Francisco since January 2018. Each row in this dataset shows the change in the number of new units associated with a building permit application. Each row also includes the date those units were approved for occupancy, the type of document approving them, and their address.

Values in the column [Number of Units Certified] can be added together to produce a count of new units approved for occupancy since January 2018.

These records provide a preliminary count of new residential units. The San Francisco Planning Department issues a Housing Inventory Report each year that provides a more complete account of new residential units, and those results may vary slightly from records in this dataset. The Housing Inventory Report is an in-depth annual research project requiring extensive work to validate information about projects. By comparison, this dataset is meant to provide more timely updates about housing production based on available administrative data. The Department of Building Inspection and Planning Department will reconcile these records with future Housing Inventory Reports.

B. METHODOLOGY

At the end of each month, DBI staff manually calculate how many new units are available for occupancy for each building permit application and enters that information into this dataset. These records reflect counts for all types of residential units, including authorized accessory dwelling units. These records do not reflect units demolished or removed from the city’s available housing stock.

Multiple records may be associated with the same building permit application number, which means that new certifications or amendments were issued. Only changes to the net number of units associated with that permit application are recorded in subsequent records.

For example, Building Permit Application Number [201601010001] located at [123 1st Avenue] was issued an [Initial TCO] Temporary Certificate of Occupancy on [January 1, 2018] approving 10 units for occupancy. Then, an [Amended TCO] was issued on [June 1, 2018] approving [5] additional units for occupancy, for a total of 15 new units associated with that Building Permit Application Number. The building will appear as twice in the dataset, each row representing when new units were approved.

If additional or amended certifications are issued for a building permit application, but they do not change the number of units associated with that building permit application, those certifications are not recorded in this dataset. For example, if all new units associated with a project are certified for occupancy under an Initial TCO, then the Certificate of Final Completion (CFC) would not appear in the dataset because the CFC would not add new units to the housing stock.
See data definitions for more details.

C. UPDATE FREQUENCY

This dataset is updated monthly.

D. DOCUMENT TYPES

Several documents issued near or at project completion can certify units for occupation. They are: Initial Temporary Certificate of Occupancy (TCO), Amended TCO, and Certificate of Final Completion (CFC).

• Initial TCO is a document that allows for occupancy of a unit before final project completion is certified, conditional on if the unit can be occupied safely. The TCO is meant to be temporary and has an expiration date. This field represents the number of units certified for occupancy when the TCO is issued.
• Amended TCO is a document that is issued when the conditions of the project are changed before final project completion is certified. These records show additional new units that have become habitable since the issuance of the Initial TCO.
• Certificate of Final Completion (CFC) is a document that is issued when all work is completed according to approved plans, and the building is ready for complete occupancy. These records show additional new units that were not accounted for in the Initial o

Snapshot of San Francisco Development Pipeline. Tracking of construction and entitlement activity based on data from Department of Building Inspection's Permit Tracking and the Planning Department's Project & Permit Tracking System, processed quarterly.

Snapshot of San Francisco Development Pipeline. Tracking of construction and entitlement activity based on data from Department of Building Inspection's Permit Tracking and the Planning Department's Project & Permit Tracking System, processed quarterly.

Snapshot of San Francisco Development Pipeline. Tracking of construction and entitlement activity based on data from Department of Building Inspection's Permit Tracking and the Planning Department's Project & Permit Tracking System, processed quarterly.

Snapshot of San Francisco Development Pipeline. Tracking of construction and entitlement activity based on data from Department of Building Inspection's Permit Tracking and the Planning Department's Project & Permit Tracking System, processed quarterly.

Land Use 2020

Land use categories for every parcel in San Francisco. The land use categories are derived from a range of City and commercial databases. Where building square footages were missing from these databases they were derived from a LIDAR survey flown in 2007.

Land use categories are as follows (units are square feet):
CIE = Cultural, Institutional, Educational
MED = Medical
MIPS = Office (Management, Information, Professional Services)
MIXED = Mixed Uses (Without Residential)
MIXRES = Mixed Uses (With Residential)
PDR = Industrial (Production, Distribution, Repair)
RETAIL/ENT = Retail, Entertainment
RESIDENT = Residential
VISITOR = Hotels/Motels
VACANT = Vacant
ROW = Right-of-Way
OPENSPACE = Open Space

Other attributes are:
RESUNITS = Residential Units
BLDGSQFT = Square footage data
YRBUILT = year built
TOTAL_USES = Business points from Dun & Bradstreet were spatially aggregated to the closest parcel, and this field is the sum of the square footage fields
The subsequent fields (CIE, MED, MIPS, RETAIL, PDER & VISITOR) were derived using the NAICS codes supplied in the Dun & Bradstreet dataset, and the previous TOTAL_USES column.

PREDOMINANT LAND USES:
RESIDENTIAL:Housing--from single family to multifamily to high-rise apartment complexes.
CIE - CULTURAL, INDUSTRIAL, EDUCATIONAL:Any cultural, institutional, medical or educational place such as a museum, zoo, hospital, medical center, college, theatre, social service, or membership organization.
MIPS (generally for offices):Management, information, and professional activities such as finance, insurance, and real estate (FIRE), business, legal, and public administration.
RETAIL/ENT(Retail/Entertainment)Shopping and direct consumer services, amusement, recreation and personal services, restaurants and bars -- from neighborhood-serving to region-serving.
PDR (Production/Distribution/Repair):Wholesale trade, showrooms, manufacturing and materials processing, warehousing, repair, businesses, construction, transportation, communications, utilities.
VISITOR:Hotels and motels.PUBLIC:Publicly owned parks, recreation, and open spaces, as well as some highway right of ways.
VACANT:An empty or undeveloped lot.
MIXED USES:Combined uses, such as office and retail, industrial-retail-entertainment, or industrial and office, etc. where no one use predominates.
MIXEDRES (Residential Mixed):Mostly housing with one or more other use (office, retail, industrial)on the ground floor).

The determining factor for a parcel's LANDUSE is if the square footage of any non-residential use is 80% or more of its total uses. Otherwise it becomes MIXED.

In the case where RESIDENT use has some square footage of non-residential use, this is mainly accessory uses such as home businesses, freelancers, etc.

Last updated: 2020

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.