A. SUMMARY
The dataset includes details of all building permit applications filed with the Department of Building Inspection. Permit numbers and associated information may be repeated in multiple rows if there are multiple addresses associated with the permit. To view the deduplicated building permits dataset with just the primary address, click here. Data is uploaded nightly by DBI. Users can view associated addenda, routing, and inspection information for each permit in the dataset online through DBI’s Permit Tracking System here.

B. HOW THE DATASET IS CREATED
The dataset is created by extracting permit characteristics and key dates (including permit filing, issuance, and completion dates) from DBI’s Permit Tracking System.

C. UPDATE PROCESS
The process that builds this dataset will run nightly and include all permits entered into the system up to the time of the refresh (see the “data as of” column in the dataset).

D. HOW TO USE THIS DATASET
Users can use this dataset to search for all permits associated with a specific address or parcel number and view characteristics like addresses, permit descriptions of work, unit counts, valuations, etc. If the analytical objective is to measure permitting trends for all addresses, we recommend using the primary address building permits dataset.

Note: if you need to open this dataset in Excel, use one of the pre-filtered datasets. Opening the main dataset in Excel will cause some data to be lost as there are more than one million rows in the full dataset.

1. Building Permits filed on or after January 1, 2013
2. Building Permits filed before January 1, 2013

E. RELATED DATASETS
Department of Building Inspections Permits Data
Building Permits (Unique)
Building Permit Addenda with Routing
Building Permits Contacts
Electrical Permits
Plumbing Permits
Boiler Permits
Dwelling Unit Completion Counts by Building Permit

Planning Department Permits
Planning Department Permits

Public Works Construction Permits
Department of Public Works Street Use Permits
Department of Public Works Large Utility Excavation Permits

Fire Department Permits
Fire Department Permits

Other housing/ construction related datasets related to building permits

This data set pertains to contacts associated with building permits. Data includes application/permit numbers, contact name, address, and license numbers. Data is uploaded weekly by DBI. This data set is intended to be joined to the Building Permits data set. Users can access permit information online through DBI’s Permit Tracking System which is 24/7 at www.sfdbi.org/dbipts.

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

This data set pertains to all permits to operate boilers. Data includes details on application/permit numbers, job addresses, supervisorial districts, and the current status of the applications. Data is uploaded weekly by DBI. Users can access permit information online through DBI’s Permit Tracking System which is 24/7 at www.sfdbi.org/dbipts.

Contacts of contractors for Electrical Permits

San Francisco Campaign and Governmental Conduct Code section 3.610 requires City elective officers and members of certain boards and commissions to file behested payment reports (Form SFEC-3610(b)) with the Ethics Commission.

Effective September 24, 2020, Mayoral Executive Directive 20-02 requires Department Heads to file behested payment Form SFEC-3610(b) and to comply with the City’s behested payment requirements that apply to City elected officials and members of boards and commissions that are contained in Article III, Chapter 6 of the Campaign and Governmental Conduct Code.

An officer must file Form SFEC-3610(b) any time a behested payment of $1,000 or more is made at his or her behest by an interested party. An “interested party” is a person who is a party, participant or agent of a party or participant to certain types of proceedings before the official in question. Those proceedings are limited to administrative enforcement proceedings and proceedings regarding permits, licenses, or other entitlements for use. A party to such a proceeding is someone who files an application for a license, permit, or entitlement for use or is the subject of the administrative enforcement. A participant in such a proceeding is someone who is not a party to the proceeding but who actively supports or opposes a particular decision in the proceeding and has a financial interest in the decision. An agent is someone who represents a party or a participant in such a proceeding.

The filing deadline for Form SFEC-3610(b) depends on the circumstances under which the behested payment was made.

If the behested payment was made while the proceeding involving the interested party is pending before the official, then the form must be filed within thirty days of the payment being made. If there is a series of behested payments, the form is due within 30 days of the payment that makes the total $1,000 or more.

If the behested payment was made within six months following the date on which a final decision was made in the proceeding involving the interested party, then the form must be filed within thirty days of the payment. If there is a series of behested payments, the form is due within 30 days of the payment that makes the total $1,000 or more.

Finally, if the behested payment was made in the 12 months prior to the commencement of the proceeding involving the interested party, the form is due within 30 days of the date the official knew or should have known that the source of the behested payment became an interested party.

Each row in this dataset represents information about payors reported in the "Payors Information" sub-table of a Form SFEC-3610(b) filed with the Ethics Commission. The parent filing and form data is available in a separate dataset: "SFEC Form 3610b - City Officer Behested Payment - Filings" at https://data.sfgov.org/City-Management-and-Ethics/SFEC-Form-3610b-City-Officer-Behested-Payment-Fili/7vmk-cq9e. Join this dataset with the sub-table using the DocuSignID.