About this Dataset

Section 604 Affidavit

A. SUMMARY This dataset is from Section 604 Affidavits received from the public and submitted to Department of Building Inspection. All wood and metal decks, balconies, landings, exit corridors, stairway systems, guard rails, hand rails, fire escapes, or any parts thereof in weather-exposed areas of apartment buildings and hotels shall be inspected by a licensed general contractor, or a structural pest control licensee, or a licensed professional architect or engineer, verifying that the exit system, corridor, balcony, deck or any part thereof is in general safe condition, in adequate working order, and free from hazardous dry rot, fungus, deterioration, decay, or improper alteration. Property owners shall provide proof of compliance with this section by submitting an affidavit form (provided by the Department) signed by the responsible inspector to the Housing Inspection Services Division every five years. B. HOW THE DATASET IS CREATED This dataset is an extract from Microsoft access, the system of record for Section 604 Affidavits. C. UPDATE PROCESS This dataset will be updated yearly. D. HOW TO USE THIS DATASET This dataset can be used to check when Section 604 Affidavits were filled out or check for historical information on Affidavits.
Organization: City of San Francisco
Last updated: 2025-03-29T16:49:00.823827

Tables

Table 1

@usgov.city_of_san_francisco_section_604_affidavit.table_1

69.77 KB
3119 rows
11 columns


CREATE TABLE table_1 (
  "item" BIGINT,
  "street_number_low" VARCHAR,
  "street_number_high" DOUBLE,
  "street_name" VARCHAR,
  "street_suffix" VARCHAR,
  "unit" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "inspection_date" TIMESTAMP,
  "comments" VARCHAR,
  "field1" VARCHAR
);