About this Dataset

FY07-11 Street Evaluation Results

The Controller's Office's City Services Auditor (CSA) Division has worked with the Department of Public Works (DPW) to develop maintenance standards for streets and sidewalks and schedules and inspect for compliance since July 2004. This data file consolidates street and sidewalk inspection results FY07-FY11. Current evaluation results are also available on DataSF; however, they are not comparable to this data set because of changes in methodology.You can access the annual reports at http://sfcontroller.org/index.aspx?page=49
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:39.286107
Tags: controllers-street-evaluation-program, graffiti, grime, inspection, leaks, litter, performance, results, sidewalk, spills, street, street-evaluation, trash, tree

Tables

Table 1

@usgov.city_of_san_francisco_fy07_11_street_evaluation_results.table_1

74.6 kB
1,381 rows
39 columns

CREATE TABLE table_1 (
  "corridor_name" VARCHAR,
  "startstreetname" VARCHAR,
  "endstreetname" VARCHAR,
  "route_no" DOUBLE  -- Route No.,
  "district" BIGINT,
  "inspector" VARCHAR,
  "side_of_street" VARCHAR,
  "type_of_street" VARCHAR,
  "clean_corridor" VARCHAR,
  "fiscal_year" VARCHAR,
  "quarter_of_inspection" VARCHAR,
  "year_month" VARCHAR,
  "date_of_inspection" VARCHAR,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "sweeping_day_s" VARCHAR  -- Sweeping Day(s),
  "sweeping_time_s" VARCHAR  -- Sweeping Time(s),
  "n_1_1" DOUBLE  -- 1.1,
  "n_1_1_litter_count" VARCHAR  -- 1.1 Litter Count,
  "n_2_1" DOUBLE  -- 2.1,
  "n_2_1_litter_count" VARCHAR  -- 2.1 Litter Count,
  "n_2_2" DOUBLE  -- 2.2,
  "n_2_3" DOUBLE  -- 2.3,
  "n_2_4" VARCHAR  -- 2.4,
  "n_2_5" VARCHAR  -- 2.5,
  "n_3_1" DOUBLE  -- 3.1,
  "n_3_2" DOUBLE  -- 3.2,
  "n_3_3" DOUBLE  -- 3.3,
  "n_4_1" VARCHAR  -- 4.1,
  "n_4_2" VARCHAR  -- 4.2,
  "n_4_3" VARCHAR  -- 4.3,
  "n_4_4" VARCHAR  -- 4.4,
  "n_4_5" VARCHAR  -- 4.5,
  "n_4_6" VARCHAR  -- 4.6,
  "n_4_0_pass" VARCHAR  -- 4.0 Pass?,
  "n_5_1" DOUBLE  -- 5.1,
  "n_5_2" DOUBLE  -- 5.2,
  "n_5_3" DOUBLE  -- 5.3,
  "n_5_4" DOUBLE  -- 5.4
);