Notices Of Violation Issued By The Department Of Building Inspection by US Government | Demographics and Population Studies

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

50.61 MB
499031 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,
  "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,
  "zip_codes_2" DOUBLE,
  "central_market_tenderloin_boundary_2" DOUBLE,
  "central_market_tenderloin_boundary_polygon_updated_2" DOUBLE,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts_3" DOUBLE,
  "current_supervisor_districts" DOUBLE
);