FY07-11 Street Evaluation Results by US Government | Demographics and Population Studies

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

72.85 KB
1381 rows
39 columns


CREATE TABLE table_1 (
  "corridor_name" VARCHAR,
  "startstreetname" VARCHAR,
  "endstreetname" VARCHAR,
  "route_no" DOUBLE,
  "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_time_s" VARCHAR,
  "n_1_1" DOUBLE,
  "n_1_1_litter_count" VARCHAR,
  "n_2_1" DOUBLE,
  "n_2_1_litter_count" VARCHAR,
  "n_2_2" DOUBLE,
  "n_2_3" DOUBLE,
  "n_2_4" VARCHAR,
  "n_2_5" VARCHAR,
  "n_3_1" DOUBLE,
  "n_3_2" DOUBLE,
  "n_3_3" DOUBLE,
  "n_4_1" VARCHAR,
  "n_4_2" VARCHAR,
  "n_4_3" VARCHAR,
  "n_4_4" VARCHAR,
  "n_4_5" VARCHAR,
  "n_4_6" VARCHAR,
  "n_4_0_pass" VARCHAR,
  "n_5_1" DOUBLE,
  "n_5_2" DOUBLE,
  "n_5_3" DOUBLE,
  "n_5_4" DOUBLE
);