Name: Fire Violations
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Fire Violations

Information on Fire Violations issued by the Fire Department for a particular location. Key fields include Violation Number, Violation Type, Address, Fire Code Reference, Violation Date, Violation Status.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:10.929933
Tags: code-violations

Tables

Table 1

@usgov.city_of_san_francisco_fire_violations.table_1

2.78 MB
51,020 rows
35 columns

CREATE TABLE table_1 (
  "inspection_number" DOUBLE,
  "violation_id" VARCHAR,
  "address" VARCHAR,
  "battalion" VARCHAR,
  "station_area" VARCHAR,
  "fire_prevention_district" VARCHAR,
  "citation_number" VARCHAR,
  "close_date" TIMESTAMP,
  "corrective_action" VARCHAR,
  "status" VARCHAR,
  "violation_item_description" VARCHAR,
  "violation_date" TIMESTAMP,
  "violation_number" VARCHAR,
  "violation_item" VARCHAR,
  "primary" VARCHAR,
  "zipcode" DOUBLE,
  "neighborhood_district" VARCHAR,
  "supervisor_district" DOUBLE,
  "location" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "neighborhoods_from_fyvs_ahh9_2" DOUBLE,
  "supervisor_districts_2" DOUBLE,
  "fire_prevention_districts_2" DOUBLE,
  "current_police_districts_2" DOUBLE,
  "neighborhoods_analysis_boundaries_2" DOUBLE  -- Neighborhoods - Analysis Boundaries 2,
  "zip_codes_2" DOUBLE,
  "neighborhoods_old_2" DOUBLE  -- Neighborhoods (old) 2,
  "police_districts_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
);