US Tech Automations

Construction records Metro File 413 changed permits

San Francisco, California: the Metro File

The San Francisco, California portal already publishes its permit table free.

Price
Not on sale
Built for
Expediters, lenders and data teams who need every status change on a named metro's permits, not the full board dump and not a ranking
Read
One-time snapshot
Newest sealed read
2026-08-25

Email a questionNot on sale right now.

Newest sealed read: 2026-08-25. San Francisco, California window 2026-06-07 to 2026-08-25. 74 sealed dates, 6 named holes.

San Francisco moved issued into complete — and into suspend413 changed permits · newest sealed read 2026-08-25

San Francisco, California is the second-largest Metro File. 413 permits changed status, 429 transitions, 142,998 snapshot rows. The city's own status words in this extract are lowercase: issued, complete, suspend, reinstated, cancelled, approved, filed. 373 transitions are issued to complete. 20 are issued to suspend. 14 suspend to reinstated. 8 issued to cancelled. That is a different shape from Austin's Active-to-Final file, on purpose.

  • 413 permits with more than one distinct status inside San Francisco, California.
  • 429 status transitions (one row per old-to-new move).
  • 2,878 distinct permits in the extract for this metro, out of 142,998 snapshot rows.
  • Sealed dates from 2026-06-07 to 2026-08-25: 74 present, 6 holes.
  • This is not the full board CSV at San Francisco, California city permit board file. That product is the published table. This product is the change record.
  • This is not Metro issued-permit changes, which is Not for sale.

Complete is the common ending. Suspend is the one that costs a job.

A lender who only bought 'issued' from today's portal would miss the 20 suspends and the 8 cancels. That is the whole point of a change record.

Status pairs counted off the extract for San Francisco, California as of 2026-08-25
Old statusNew statusTransitions
issuedcomplete373
issuedsuspend20
suspendreinstated14
issuedcancelled8
issuedreinstated4
issuedapproved4
reinstatedcomplete2
approvedissued2
completesuspend1
filedissued1

Ten real change rows from San Francisco, California

They are not a dump of the city's full board and they are not a ranking. Person-name columns are not in this extract.

10 of 429 transitions for San Francisco, California sealed 2026-06-07 to 2026-08-25
PermitOld statusNew statusOld first sealedNew first sealedClassZip
san-francisco:202605271984approvedissued2026-07-232026-07-29low_intent94132
san-francisco:202606233725reinstatedcomplete2026-07-262026-08-09low_intent94127
san-francisco:202607245557issuedcancelled2026-07-262026-08-09low_intent94132
san-francisco:202608046030issuedreinstated2026-08-062026-08-13low_intent94118
san-francisco:202608066180suspendreinstated2026-08-142026-08-21low_intent94131
san-francisco:202512313057issuedsuspend2026-08-092026-08-23low_intent94114
san-francisco:202607305817issuedcomplete2026-08-012026-08-23low_intent94134
san-francisco:202608106353issuedcomplete2026-08-162026-08-23low_intent94114
san-francisco:202608146639issuedsuspend2026-08-162026-08-23low_intent94112
san-francisco:202608206929issuedcomplete2026-08-222026-08-23low_intent94110

Coverage holes we will not paper over

A hole is a calendar day between 2026-06-07 and 2026-08-25 with no sealed copy in the extract. It is not a claim the city published nothing that day.

  • 2026-06-19 — no sealed copy on this calendar day.
  • 2026-06-20 — no sealed copy on this calendar day.
  • 2026-06-21 — no sealed copy on this calendar day.
  • 2026-07-04 — no sealed copy on this calendar day.
  • 2026-07-15 — no sealed copy on this calendar day.
  • 2026-08-08 — no sealed copy on this calendar day.

Who published the data on this page

  • Every permit in this file was published by San Francisco, California, not by us. Source: DataSF / City of San Francisco.
  • We sealed dated snapshots ourselves. The change record is counted off those snapshots (table permit_prediction_snapshots, extract of 2026-08-25, 533,569 rows across six cleared boards).
  • DataSF makes this data available under the Public Domain Dedication and License v1.0 except where a file says otherwise.

What this page cannot tell you

  • San Francisco's board file is the published table (the metadata fetch for that product did not even give an exact row count). This Metro File is 413 changed permits, not that table.
  • filed and approved exist in the snapshots; approved to issued happened twice. filed produced no transition.
  • permit_class in this extract is our intent label (low_intent / high_intent), not the city's own type word.

See the file

You do not have to take our word for what is in the file. Here are real change rows, carrying the same columns as the full CSV, cut out of the dated copies we sealed ourselves. Nothing in it is made up and nothing in it is tidied up.

  • Open the sample as a CSVA plain spreadsheet file. It saves to your machine rather than painting itself into a browser tab, and it opens in Excel, Numbers or Google Sheets.
  • The same rows as JSONThe same rows again, laid out for reading with code.

Not on sale right now

Not on sale right now. Each file is currently sent by hand, so we have taken the pay button down. It comes back on sale when delivery is automatic.

Email a question

No payment is taken on this page.

More from this feed