SF Building Permits
Bay Area construction intelligence, housing/development analysis, and civic monitoring.
Rows1,288,958
Freshness field
permit_creation_dateMax freshness2026-05-26T22:35:38.000
Last checked2026-05-28T06:30:47Z
Reliability checks
- okfreshness is current enough (1 days old)
- okrow count changed by 0.0%
Changes since previous run
- None
Schema columns
| # | Field | Type | Name |
|---|---|---|---|
| 1 | permit_number | text | Permit Number |
| 2 | permit_type | text | Permit Type |
| 3 | permit_type_definition | text | Permit Type Definition |
| 4 | permit_creation_date | calendar_date | Permit Creation Date |
| 5 | block | text | Block |
| 6 | lot | text | Lot |
| 7 | street_number | text | Street Number |
| 8 | street_number_suffix | text | Street Number Suffix |
| 9 | street_name | text | Street Name |
| 10 | street_suffix | text | Street Suffix |
| 11 | unit | text | Unit |
| 12 | unit_suffix | text | Unit Suffix |
| 13 | description | text | Description |
| 14 | status | text | Current Status |
| 15 | status_date | calendar_date | Current Status Date |
| 16 | filed_date | calendar_date | Filed Date |
| 17 | issued_date | calendar_date | Issued Date |
| 18 | completed_date | calendar_date | Completed Date |
| 19 | first_construction_document_date | calendar_date | First Construction Document Date |
| 20 | approved_date | calendar_date | approved_date |
| 21 | structural_notification | text | Structural Notification |
| 22 | number_of_existing_stories | text | Number of Existing Stories |
| 23 | number_of_proposed_stories | text | Number of Proposed Stories |
| 24 | voluntary_soft_story_retrofit | text | Voluntary Soft-Story Retrofit |
| 25 | fire_only_permit | text | Fire Only Permit |
| 26 | estimated_cost | text | Estimated Cost |
| 27 | revised_cost | text | Revised Cost |
| 28 | existing_use | text | Existing Use |
| 29 | existing_units | text | Existing Units |
| 30 | proposed_use | text | Proposed Use |
| 31 | proposed_units | text | Proposed Units |
| 32 | plansets | text | Plansets |
| 33 | tidf_compliance | text | TIDF Compliance |
| 34 | existing_occupancy | text | Existing Occupancy |
| 35 | proposed_occupancy | text | Proposed Occupancy |
| 36 | existing_construction_type | text | Existing Construction Type |
| 37 | existing_construction_type_description | text | Existing Construction Type Description |
| 38 | proposed_construction_type | text | Proposed Construction Type |
| 39 | proposed_construction_type_description | text | Proposed Construction Type Description |
| 40 | site_permit | text | Site Permit |
| 41 | last_permit_activity_date | calendar_date | Last Permit Activity Date |
| 42 | application_submission_method | text | Application Submission Method |
| 43 | adu | text | ADU |
| 44 | primary_address_flag | text | Primary Address Flag |
| 45 | supervisor_district | text | supervisor_district |
| 46 | neighborhoods_analysis_boundaries | text | neighborhoods_analysis_boundaries |
| 47 | zipcode | text | Zipcode |
| 48 | location | point | Location |
| 49 | point_source | text | point_source |
| 50 | reroof | text | reroof |
| 51 | record_id | text | Record ID |
| 52 | data_as_of | calendar_date | data_as_of |
| 53 | data_loaded_at | calendar_date | data_loaded_at |