DPW Street & Sidewalk Evaluation Results, 7-1-2013 To 6-30-2018 (FY13-FY18) by US Government | Demographics and Population Studies

About this Dataset

DPW Street & Sidewalk Evaluation Results, 7-1-2013 To 6-30-2018 (FY13-FY18)

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, as mandated by 2003 Prop. C. This data file contains street and sidewalk evaluation results from 7/1/2013 to 6/30/18 under the FY12 standards. Older evaluation results are also available on DataSF but are not comparable due to changes in the way the standards are calculated. You can also access the annual reports in PDF at "Street Maintenance" section of http://sfcontroller.org/index.aspx?page=49 or https://sf.gov/resource/2022/street-and-sidewalk-maintenance-standards
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:16.279486
Tags: controllers-street-evaluation-program, evaluation, graffiti, grime, inspection, leaks, litter, performance, results, sidewalk, spills, street, street-sweeping, trash, tree

Tables

Table 1

@usgov.city_of_san_francisco_dpw_street_sidewalk_evaluation_r_07dc8814.table_1

157.12 KB
2013 rows
61 columns


CREATE TABLE table_1 (
  "corridor" DOUBLE,
  "corridor_description" VARCHAR,
  "corridor_num_and_description" VARCHAR,
  "fy" VARCHAR,
  "clean_corridor" VARCHAR,
  "type" VARCHAR,
  "detailed_type" VARCHAR,
  "midpoint_times" VARCHAR,
  "side_of_street" VARCHAR,
  "supdistrict" BIGINT,
  "dpw_zone" VARCHAR,
  "representative_street_segment" VARCHAR,
  "cnn_route_id" BIGINT,
  "evaluation_date" VARCHAR,
  "evaluator_name" VARCHAR,
  "inspector" VARCHAR,
  "n_11_score_10_20_or_30_score" DOUBLE,
  "n_21_litter_10_20_or_30_score" DOUBLE,
  "n_22_grime_leaks_spills_of_sidewalk_w_out" DOUBLE,
  "n_24_illegal_dumping_y_n_where_y_none" DOUBLE,
  "n_251_feces_needles_condoms_y_n_where_y_none" DOUBLE,
  "n_252_broken_glass_y_n_where_y_none" DOUBLE,
  "n_26_odors_dpw" DOUBLE,
  "n_27_odors_nondpw" DOUBLE,
  "n_31_public_dpw" DOUBLE,
  "n_32_public_nondpw" DOUBLE,
  "n_33_private_please_indicate_nearest_address_on_attached_work_s" DOUBLE,
  "n_34_sidewalk_on_sidewalk_preiously_23" DOUBLE,
  "total_trash_receptacles" DOUBLE,
  "n_41_fullness" DOUBLE,
  "n_42_cleanliness_of_trash_receptacles" DOUBLE,
  "n_43_cleanliness_around_trash_receptacles" DOUBLE,
  "n_44_painting" DOUBLE,
  "n_45_structural_integrity_function" DOUBLE,
  "n_46_doors" DOUBLE,
  "total_trees" DOUBLE,
  "n_51_cleanliness" DOUBLE,
  "n_52_tree_appearance" DOUBLE,
  "n_53_weediness" DOUBLE,
  "n_54_clearance" DOUBLE,
  "n_11_pass" DOUBLE,
  "n_21_pass" DOUBLE,
  "n_22_pass" DOUBLE,
  "n_31_pass" DOUBLE,
  "n_32_pass" DOUBLE,
  "n_33_pass" DOUBLE,
  "n_34_pass" DOUBLE,
  "n_41_pass" DOUBLE,
  "n_42_pass" DOUBLE,
  "n_43_pass" DOUBLE,
  "n_44_pass" DOUBLE,
  "n_45_pass" DOUBLE,
  "n_46_pass" DOUBLE,
  "n_51_pass" DOUBLE,
  "n_52_pass" DOUBLE,
  "n_53_pass" DOUBLE,
  "n_54_pass" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR,
  "priority" VARCHAR
);