This data set pertains to all types of structural permits. 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.
Note if you need to open permits in Excel, use one of the pre-filtered datasets:
1. Building Permits on or after January 1, 2013 https://data.sfgov.org/d/p4e4-a5a7
2. Building Permits before January 1, 2013 https://data.sfgov.org/d/4jpb-z4kk
Publishing Department: Building Inspection
Dataset Link: https://data.sfgov.org/d/i98e-djp9
| Field Name (opt. alias) | Field Definition | API Key |
|---|---|---|
| Block (Assessor Block Number) | The full assessor's parcel number is comprised of two parts, the first being the block number. Blocks are assigned by the Office of the Assessor Recorder. You can see a block map here: https://data.sfgov.org/d/ndp2-nsue Blocks are officially recorded in physical block maps. You can find PDFs of those here: https://data.sfgov.org/d/2367-5au8 | block |
| Completed Date | completed_date | |
| Current Status | Current Status | status |
| Current Status Date | status_date | |
| Description | Description | description |
| Estimated Cost | Estimated Cost | estimated_cost |
| Existing Construction Type | existing_construction_type | |
| Existing Construction Type Description | existing_construction_type_description | |
| Existing Units | Existing Units | existing_units |
| Existing Use | Existing Use | existing_use |
| Filed Date | filed_date | |
| Fire Only Permit | Fire Only Permit | fire_only_permit |
| First Construction Document Date | first_construction_document_date | |
| Issued Date | issued_date | |
| Location (Geometry) | Contains the geometry of the record in Well Known Text (WKT) format. | location |
| Lot (Assessor Lot Number) | The full assessor's parcel number is comprised of two parts, the second being the lot number. Lots are assigned by the Office of the Assessor Recorder and are captured within blocks. You can find a map of the lots here: https://data.sfgov.org/d/45et-ht7c | lot |
| Neighborhoods - Analysis Boundaries | The Department of Public Health and the Mayorâs Office of Housing and Community Development, with support from the Planning Department, created 41 neighborhoods by grouping 2010 Census tracts, using common real estate and residentsâ definitions for the purpose of providing consistency in the analysis and reporting of socio-economic, demographic, and environmental data, and data on City-funded programs and services. They are not codified in Planning Code nor Administrative Code. This boundary is produced by assigning Census tracts to neighborhoods based on existing neighborhood definitions used by Planning and MOHCD. A qualitative assessment was made to identify the appropriate neighborhood for a given tract based on understanding of population distribution and significant landmarks. Once all tracts have been assigned a neighborhood, the tracts were dissolved to produce these boundaries. You can see them at: https://data.sfgov.org/d/p5b7-5n3h | neighborhoods_analysis_boundaries |
| Number of Existing Stories | Number of Existing Stories | number_of_existing_stories |
| Number of Proposed Stories | Number of Proposed Stories | number_of_proposed_stories |
| Permit Creation Date | nan | permit_creation_date |
| Permit Expiration Date | Permit Expiration Date | permit_expiration_date |
| Permit Number | Permit Number | permit_number |
| Permit Type | Type of permit | permit_type |
| Permit Type Definition | The type of permit definition | permit_type_definition |
| Plansets | Plansets | plansets |
| Proposed Construction Type | proposed_construction_type | |
| Proposed Construction Type Description | proposed_construction_type_description | |
| Proposed Units | Proposed Units | proposed_units |
| Proposed Use | Proposed Use | proposed_use |
| Record ID | unique identifier for each record | record_id |
| Revised Cost | Revised Cost | revised_cost |
| Site Permit | site_permit | |
| Street Name | The name of the street including the type (e.g. Market St) | street_name |
| Street Number | Street Number | street_number |
| Street Number Suffix | Street Number Suffix | street_number_suffix |
| Street Suffix | Street Suffix | street_suffix |
| Structural Notification | Structural Notification | structural_notification |
| Supervisor District | There are 11 members of the Board of Supervisors in San Francisco, each representing a geographic district. These are numbered 1 through 11. See the district boundaries here: https://data.sfgov.org/d/xz9b-wyfc | supervisor_district |
| TIDF Compliance | nan | tidf_compliance |
| Unit | Unit | unit |
| Unit Suffix | Unit Suffix | unit_suffix |
| Voluntary Soft-Story Retrofit | Voluntary Soft-Story Retrofit | voluntary_soft_story_retrofit |
| Zipcode (ZIP Code) | A system used in the U.S. to facilitate the delivery of mail, consisting of a five- or nine-digit code printed directly after the address, the first five digits (initial code) indicating the state and post office or postal zone, the last four (expanded code) the box section or number, portion of a rural route, building, or other specific delivery location. This field indicates just the five-digit portion. | zipcode |