San Francisco Department of Building Inspection

Official Mandatory Soft Story Program dataset with one property row keyed by assessor block, lot, parcel number and address. It publishes the four programme tiers and a current programme status string, plus point geography and source/portal timestamps. It does not publish a separate engineering deficiency, retrofit permit identifier, completion date, or present-resistance certification; status values such as “Work Complete, CFC Issued” must remain authority programme statuses rather than derived safety findings. Portal metadata says weekly change and publication frequency. The live dataset contained 4,945 rows and a uniform data_as_of of 2025-07-31T01:02:58.134 when checked, so the stated weekly cadence and observed currency must both be retained.

Official San Francisco DBI monthly open dataset of changes in the count of new residential units approved for occupancy. A row identifies a building permit application and address, issuance date, document type (Initial Temporary Certificate of Occupancy, Amended TCO, or Certificate of Final Completion), and additional units certified. DBI staff compile the records from occupancy certifications. This is not a complete Certificate of Occupancy register: only certifications that change the net unit count are recorded, a CFC may be omitted when an earlier TCO already counted all units, and the schema has no block/lot, approved-use code, TCO expiration, certificate revision identifier, or current legal-occupancy status. Preserve each emitted event and do not infer present operations, present legal occupancy, or code compliance. Validate dates: although the description focuses on units made available since January 2018, a live aggregate returned dates from 2002 through an anomalous year 2205.