Database Fix Reveals 40,000 Missing Housing Units as Commission Greenlights Castro Bookstore-Bar

The San Francisco Planning Commission opened its April 23 meeting with a revelation: a deep audit of the city's land use database uncovered roughly 40,000 residential units that had never been counted. Commissioners then turned to the evening's only land use case, unanimously approving a romance bookstore with wine service in the Castro — complete with conditions negotiated by the neighborhood to protect nearby residents.

• Planning Department discovers 40,000 previously uncounted housing units after cross-referencing assessor, COSTAR, and permitting data — but the correction won't count toward state RHNA targets

• "Love Potion Library," a romance bookstore and tea room with wine service, approved 7-0 at 284 Noe Street with hour limits and noise protections brokered by the Dubose Triangle Neighborhood Association

• Board of Supervisors advances 29 landmark designations across Districts 3 and 8 and amends SB 79 legislation to incorporate Planning Commission recommendations

• Family zoning plan, design standards, and Ocean Beach Climate Change Adaptation EIR win APA awards; planner Lisa Chen earns Mid Career Planner recognition

The basics: The Planning Department's data analysis group, led by a staffer named Reza, conducted a comprehensive audit of the city's land use database — cross-referencing the assessor's tax rolls, COSTAR commercial real estate data, Department of Building Inspection permitting records, and the department's own planning permits. The team supplemented the digital review with manual fieldwork, ultimately identifying approximately 40,000 residential units that had never been captured.