About this Dataset

Department Of Building Inspection Complaints (All Divisions)

These are complaints from Housing, Building, Electrical, Plumbing, and Code Enforcement divisions within the Department of Building Inspection. Routine and non-routine inspections from the housing division are tracked using complaints only if violations are found during the inspections. The NOVTYPE field can be used to determine the source of the complaint.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:34.630344

Tables

Table 1

@usgov.city_of_san_francisco_department_of_building_inspectio_fda427e1.table_1

35.97 MB
314,153 rows
38 columns

CREATE TABLE table_1 (
  "complaint_number" VARCHAR,
  "date_filed" VARCHAR,
  "date_1st_nov_issued" VARCHAR,
  "date_2nd_nov_issued" VARCHAR,
  "date_final_warning_letter_issued" VARCHAR,
  "date_referred_to_city_attorney" VARCHAR,
  "director_hearing_date" VARCHAR,
  "last_inspection_date" VARCHAR,
  "date_abated" VARCHAR,
  "closed_date" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "parcel_number" VARCHAR,
  "street_number" BIGINT,
  "street_name" VARCHAR,
  "street_suffix" VARCHAR,
  "unit" DOUBLE,
  "zip_code" DOUBLE,
  "complaint_description" VARCHAR,
  "status" VARCHAR,
  "nov_type" VARCHAR,
  "receiving_division" VARCHAR,
  "assigned_division" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "point" VARCHAR,
  "point_source" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "analysis_neighborhoods" DOUBLE,
  "delete_supervisor_districts" DOUBLE  -- DELETE - Supervisor Districts,
  "delete_fire_prevention_districts" DOUBLE  -- DELETE - Fire Prevention Districts,
  "delete_current_police_districts" DOUBLE  -- DELETE - Current Police Districts,
  "delete_zip_codes" DOUBLE  -- DELETE - Zip Codes,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE
);