About this Dataset

Notices Of Violation Issued By The Department Of Building Inspection

These records indicate the actual violations and comments by the inspector found during the inspection. The data should be sorted on the Complaint Number field and the Item Sequence Number field. The user should be able to link this file with the Department of Building Inspection Complaints dataset to get a more accurate picture of the violations.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:46.472684
Tags: code-violations

Tables

Table 1

@usgov.city_of_san_francisco_notices_of_violation_issued_by_t_582dffb6.table_1

53.07 MB
499,031 rows
39 columns

CREATE TABLE table_1 (
  "complaint_number" VARCHAR,
  "item_sequence_number" DOUBLE,
  "date_filed" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "street_number" BIGINT,
  "street_name" VARCHAR,
  "street_suffix" VARCHAR,
  "unit" DOUBLE,
  "status" VARCHAR,
  "receiving_division" VARCHAR,
  "assigned_division" VARCHAR,
  "nov_category_description" VARCHAR,
  "item" VARCHAR,
  "nov_item_description" VARCHAR,
  "neighborhoods_analysis_boundaries" VARCHAR  -- Neighborhoods - Analysis Boundaries,
  "supervisor_district" DOUBLE,
  "zipcode" DOUBLE,
  "location" VARCHAR,
  "point_source" VARCHAR,
  "work_without_permit" VARCHAR,
  "additional_work_beyond_permit" VARCHAR,
  "expired_permit" VARCHAR,
  "cancelled_permit" VARCHAR,
  "unsafe_building" VARCHAR,
  "code_violation_description" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "supervisor_districts_2" DOUBLE,
  "fire_prevention_districts_2" DOUBLE,
  "current_police_districts_2" DOUBLE,
  "neighborhoods_analysis_boundaries_2_2" DOUBLE  -- Neighborhoods - Analysis Boundaries 2–2,
  "zip_codes_2" DOUBLE,
  "central_market_tenderloin_boundary_2" DOUBLE,
  "central_market_tenderloin_boundary_polygon_updated_2" DOUBLE  -- Central Market/Tenderloin Boundary Polygon - Updated 2,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts_3" DOUBLE,
  "current_supervisor_districts" DOUBLE
);