San Francisco Fixes Thousands of Duplicate Property Records
City Hall launches database cleanup affecting permits and property files, raising questions about how long the errors went undetected.
City Hall launches database cleanup affecting permits and property files, raising questions about how long the errors went undetected.

San Francisco's Planning Department and the Department of Building Inspection are under mounting pressure to resolve a persistent data quality problem: duplicate images embedded in the city's permit and property record systems are slowing down housing approvals, complicating environmental reviews, and frustrating contractors trying to pull permits for projects that include everything from Tenderloin SRO renovations to Mission District infill housing. The issue surfaced publicly this spring, when city staff flagged the backlog at a joint hearing of the Board of Supervisors' Land Use and Transportation Committee.
The timing matters. San Francisco is operating under a state-mandated Housing Element that requires the city to plan for roughly 82,000 new units by 2031. Every week of processing delay carries real consequences. Redundant image files — duplicate scans of inspection reports, site photos, and permit drawings attached to the same record — are forcing staff to manually review folders before issuing approvals, according to a workflow audit circulated internally at the Department of Building Inspection's Intake Counter on Duboce Avenue.
City Administrator Carmen Chu's office has described database hygiene as a priority for the broader San Francisco Digital Services modernization effort, which launched its latest phase in January 2026. The effort is coordinated through the city's Committee on Information Technology, known as COIT, which allocates technology spending across departments. COIT approved a line item earlier this year for permit system upgrades, though the specific dollar figure has not been publicly itemized in released budget documents reviewed for this story.
Planning Department staff, in written materials submitted to the Land Use Committee in April, described the duplicate image issue as a downstream consequence of a 2022 system migration that moved legacy permit records into the city's current Accela platform. During that migration, some document attachments were copied more than once, creating redundant entries that the system cannot automatically reconcile. Staff estimated the problem affects a meaningful share of open permit files, particularly for projects submitted before 2023 — though no precise percentage has been formally published.
Supervisors representing neighborhoods with high permit volumes — including District 9, which covers the Mission, and District 5, covering the Haight and parts of the Western Addition — have asked the departments to produce a remediation timeline before the Board goes into summer recess on July 17.
Outside City Hall, the conversation is drawing interest from San Francisco's civic technology community. Code for America, which maintains a San Francisco brigade and operates its national office on Market Street, has worked on government data quality projects in other jurisdictions and is in early discussions with city staff about whether volunteer technical capacity could support the deduplication effort, according to publicly available meeting notes from a May brigade session.
Real estate attorneys in the city say the practical effect on clients is already visible. Projects in the pipeline near 16th Street BART Station — one of the most active development corridors in the city right now — have seen permit issuance timelines stretch by several weeks in cases where file errors require manual resolution. The city's standard target for over-the-counter permit issuance is same-day or next-day processing for straightforward residential projects.
The Building Inspection Commission, which holds public hearings at City Hall most Wednesdays, is expected to receive a formal staff report on the deduplication timeline no later than its August meeting. Housing advocates affiliated with the Council of Community Housing Organizations, based in the Mission District, have already submitted public comment urging the departments not to let technical cleanup work stall approvals for affordable projects with funding deadlines tied to California's Affordable Housing and Sustainable Communities grants.
For anyone with a permit application currently in the system, the practical advice from department staff is to verify that all uploaded attachments are correctly labeled and not submitted in duplicate at the point of application — a simple step that, according to the April Land Use Committee materials, would help prevent new entries from compounding an existing backlog.
How does this story make you feel?
Spread the word
About this article
Published by The Daily San Francisco
Daily brief
Free, in your inbox before 7am. Weekdays.
More in News