San Francisco Data

Author: OpenData
Description: 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, <a href="https://data.sfgov.org/Housing-and-Buildings/Building-Permits-Deduplicated-on-Primary-Address/f2jc-ivnc">click here</a>. 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 <a href="https://dbiweb02.sfgov.org/dbipts/">here</a>. A full data dictionary for this dataset is available by <a href="https://datasf.gitbook.io/datasf-dataset-explainers/dbi-building-permits-and-permit-addenda-data/building-permits-data-dictionary">clicking here.</a> 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. <a href="https://data.sfgov.org/d/p4e4-a5a7">Building Permits filed on or after January 1, 2013</a> 2. <a href="https://data.sfgov.org/d/4jpb-z4kk">Building Permits filed before January 1, 2013</a> E. RELATED DATASETS Department of Building Inspections Permits Data <a href="https://data.sfgov.org/Housing-and-Buildings/Building-Permits/i98e-djp9">Building Permits (Unique)</a> <a href="https://data.sfgov.org/Housing-and-Buildings/Department-of-Building-Inspection-Permit-Addenda-w/87xy-gk8d">Building Permit Addenda with Routing</a> <a href="https://data.sfgov.org/Housing-and-Buildings/Building-Permits-Contacts/3pee-9qhc">Building Permits Contacts</a> <a href="https://data.sfgov.org/Housing-and-Buildings/Electrical-Permits/ftty-kx6y">Electrical Permits</a> <a href="https://data.sfgov.org/Housing-and-Buildings/Plumbing-Permits/a6aw-rudh">Plumbing Permits</a> <a href="https://data.sfgov.org/Housing-and-Buildings/Boiler-Permits/5dp4-gtxk">Boiler Permits</a> <a href="https://data.sfgov.org/Housing-and-Buildings/Dwelling-Unit-Completion-Counts-by-Building-Permit/j67f-aayr">Dwelling Unit Completion Counts by Building Permit</a> Planning Department Permits <a href="https://data.sfgov.org/Housing-and-Buildings/SF-Planning-Permitting-Data/kncr-c6jw">Planning Department Permits</a> Public Works Construction Permits <a href="https://data.sfgov.org/City-Infrastructure/Street-Use-Permits/b6tj-gt35">Department of Public Works Street Use Permits</a> <a href="https://data.sfgov.org/City-Infrastructure/Large-Utility-Excavation-Permits/i926-ujnc">Department of Public Works Large Utility Excavation Permits</a> Fire Department Permits <a href="https://data.sfgov.org/Housing-and-Buildings/Fire-Permits/893e-xam6">Fire Department Permits</a> Other housing/ construction related datasets related to building permits <a href="https://data.sfgov.org/browse?q=SF%20Development%20Pipeline&sortBy=newest&utf8=%E2%9C%93">Planning Department Housing Development Pipeline Quarterly datasets</a> Mayor’s Office of Housing and Community Development: Affordable Housing Pipeline <a href="https://data.sfgov.org/Housing-and-Buildings/Affordable-Housing-Pipeline/aaxw-2cb8">Affordable Housing Pipeline</a> For even more permit datasets, <a href="https://datasf.org/opendata/">click this link</a> and search “Permits.”
Category: Housing and Buildings
Tags: construction permits, permit, permits, building safety, housing
Rating: Current value: 0 out of 5
License: Public Domain Dedication and License

Building PermitsA. 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, <a href="https://data.sfgov.org/Housing-and-Buildings/Building-Permits-Deduplicated-on-Primary-Address/f2jc-ivnc">click here</a>. 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 <a href="https://dbiweb02.sfgov.org/dbipts/">here</a>. A full data dictionary for this dataset is available by <a href="https://datasf.gitbook.io/datasf-dataset-explainers/dbi-building-permits-and-permit-addenda-data/building-permits-data-dictionary">clicking here.</a> 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. <a href="https://data.sfgov.org/d/p4e4-a5a7">Building Permits filed on or after January 1, 2013</a> 2. <a href="https://data.sfgov.org/d/4jpb-z4kk">Building Permits filed before January 1, 2013</a> E. RELATED DATASETS Department of Building Inspections Permits Data <a href="https://data.sfgov.org/Housing-and-Buildings/Building-Permits/i98e-djp9">Building Permits (Unique)</a> <a href="https://data.sfgov.org/Housing-and-Buildings/Department-of-Building-Inspection-Permit-Addenda-w/87xy-gk8d">Building Permit Addenda with Routing</a> <a href="https://data.sfgov.org/Housing-and-Buildings/Building-Permits-Contacts/3pee-9qhc">Building Permits Contacts</a> <a href="https://data.sfgov.org/Housing-and-Buildings/Electrical-Permits/ftty-kx6y">Electrical Permits</a> <a href="https://data.sfgov.org/Housing-and-Buildings/Plumbing-Permits/a6aw-rudh">Plumbing Permits</a> <a href="https://data.sfgov.org/Housing-and-Buildings/Boiler-Permits/5dp4-gtxk">Boiler Permits</a> <a href="https://data.sfgov.org/Housing-and-Buildings/Dwelling-Unit-Completion-Counts-by-Building-Permit/j67f-aayr">Dwelling Unit Completion Counts by Building Permit</a> Planning Department Permits <a href="https://data.sfgov.org/Housing-and-Buildings/SF-Planning-Permitting-Data/kncr-c6jw">Planning Department Permits</a> Public Works Construction Permits <a href="https://data.sfgov.org/City-Infrastructure/Street-Use-Permits/b6tj-gt35">Department of Public Works Street Use Permits</a> <a href="https://data.sfgov.org/City-Infrastructure/Large-Utility-Excavation-Permits/i926-ujnc">Department of Public Works Large Utility Excavation Permits</a> Fire Department Permits <a href="https://data.sfgov.org/Housing-and-Buildings/Fire-Permits/893e-xam6">Fire Department Permits</a> Other housing/ construction related datasets related to building permits <a href="https://data.sfgov.org/browse?q=SF%20Development%20Pipeline&sortBy=newest&utf8=%E2%9C%93">Planning Department Housing Development Pipeline Quarterly datasets</a> Mayor’s Office of Housing and Community Development: Affordable Housing Pipeline <a href="https://data.sfgov.org/Housing-and-Buildings/Affordable-Housing-Pipeline/aaxw-2cb8">Affordable Housing Pipeline</a> For even more permit datasets, <a href="https://datasf.org/opendata/">click this link</a> and search “Permits.”Visit the full page to view this data.

This view cannot be displayed

Embed this Dataset

      <div><iframe width="_width_px" title="Building Permits" height="_height_px" src="https://data.sfgov.org/w/i98e-djp9/ikek-yizv?cur=sQ2GmV2McNH&from=gMUpz87Z_bQ" frameborder="0"scrolling="no"><a href="https://data.sfgov.org/Housing-and-Buildings/Building-Permits/i98e-djp9" title="Building Permits" target="_blank">Building Permits</a></iframe><p><a href="http://www.socrata.com/" target="_blank">Powered by Tyler Technologies</a></p></div>

Size

500x425
760x646
950x808

Custom Size

425x425 is the minimum size

Width

Height

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Permit Number: permit_number
Permit Type: permit_type
Permit Type Definition: permit_type_definition
Permit Creation Date: permit_creation_date
Block: block
Lot: lot
Street Number: street_number
Street Number Suffix: street_number_suffix
Street Name: street_name
Street Suffix: street_suffix
Unit: unit
Unit Suffix: unit_suffix
Description: description
Current Status: status
Current Status Date: status_date
Filed Date: filed_date
Issued Date: issued_date
Completed Date: completed_date
First Construction Document Date: first_construction_document_date
Structural Notification: structural_notification
Number of Existing Stories: number_of_existing_stories
Number of Proposed Stories: number_of_proposed_stories
Voluntary Soft-Story Retrofit: voluntary_soft_story_retrofit
Fire Only Permit: fire_only_permit
Estimated Cost: estimated_cost
Revised Cost: revised_cost
Existing Use: existing_use
Existing Units: existing_units
Proposed Use: proposed_use
Proposed Units: proposed_units
Plansets: plansets
TIDF Compliance: tidf_compliance
Existing Occupancy: existing_occupancy
Proposed Occupancy: proposed_occupancy
Existing Construction Type: existing_construction_type
Existing Construction Type Description: existing_construction_type_description
Proposed Construction Type: proposed_construction_type
Proposed Construction Type Description: proposed_construction_type_description
Site Permit: site_permit
Last Permit Activity Date: last_permit_activity_date
Application Submission Method: application_submission_method
ADU: adu
Primary Address Flag: primary_address_flag
Supervisor District: supervisor_district
Neighborhoods - Analysis Boundaries: neighborhoods_analysis_boundaries
Zipcode: zipcode
Location: location
Point Source: point_source
Record ID: record_id
data_as_of: data_as_of
data_loaded_at: data_loaded_at
SF Find Neighborhoods 2: :@computed_region_6qbp_sg9q
Current Police Districts 2: :@computed_region_qgnn_b9vv
Current Supervisor Districts 2: :@computed_region_26cr_cadq
Analysis Neighborhoods 2: :@computed_region_ajp5_b2md
DELETE - Zip Codes 2: :@computed_region_bh8s_q3mv
DELETE - Fire Prevention Districts 2: :@computed_region_yftq_j783
DELETE - Supervisor Districts 2: :@computed_region_rxqg_mtj9
DELETE - Current Police Districts 2: :@computed_region_jx4q_fizf
DELETE - Supervisorial_Districts_Waterline_data_from_7pkg_wer3 2: :@computed_region_uruc_drv6
Neighborhoods: :@computed_region_jwn9_ihcz

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

San Francisco Data

API Endpoint:

Field Names:

OData V4 Endpoint:

OData V2 Endpoint:

Want to leave a comment?

You are leaving data.sfgov.org.

Notice