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

160.89 kB
2,013 rows
61 columns

CREATE TABLE table_1 (
  "corridor" DOUBLE  -- Corridor #,
  "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  -- CNN (Route ID),
  "evaluation_date" VARCHAR,
  "evaluator_name" VARCHAR,
  "inspector" VARCHAR,
  "n_11_score_10_20_or_30_score" DOUBLE  -- 11 Score (10, 20, Or 30 Score),
  "n_21_litter_10_20_or_30_score" DOUBLE  -- 21 Litter (10, 20, Or 30 Score),
  "n_22_grime_leaks_spills_of_sidewalk_w_out" DOUBLE  -- 22 Grime, Leaks, Spills (% Of Sidewalk W/out),
  "n_24_illegal_dumping_y_n_where_y_none" DOUBLE  -- 24 Illegal Dumping (Y/N, Where Y=none),
  "n_251_feces_needles_condoms_y_n_where_y_none" DOUBLE  -- 251 Feces, Needles, Condoms (Y/N, Where Y=none),
  "n_252_broken_glass_y_n_where_y_none" DOUBLE  -- 252 Broken Glass (Y/N, Where Y=none),
  "n_26_odors_dpw" DOUBLE  -- 26 Odors (DPW),
  "n_27_odors_nondpw" DOUBLE  -- 27 Odors (nonDPW),
  "n_31_public_dpw" DOUBLE  -- 31 Public (DPW),
  "n_32_public_nondpw" DOUBLE  -- 32 Public (nonDPW),
  "n_33_private_please_indicate_nearest_address_on_attached_work_s" DOUBLE  -- 33 Private (Please Indicate Nearest Address On Attached Work S,
  "n_34_sidewalk_on_sidewalk_preiously_23" DOUBLE  -- 34 Sidewalk (# On Sidewalk, Preiously 23),
  "total_trash_receptacles" DOUBLE  -- Total # Trash Receptacles,
  "n_41_fullness" DOUBLE  -- 41 Fullness,
  "n_42_cleanliness_of_trash_receptacles" DOUBLE  -- 42 Cleanliness Of Trash Receptacles,
  "n_43_cleanliness_around_trash_receptacles" DOUBLE  -- 43 Cleanliness Around Trash Receptacles,
  "n_44_painting" DOUBLE  -- 44 Painting,
  "n_45_structural_integrity_function" DOUBLE  -- 45 Structural Integrity & Function,
  "n_46_doors" DOUBLE  -- 46 Doors,
  "total_trees" DOUBLE  -- Total # Trees,
  "n_51_cleanliness" DOUBLE  -- 51 Cleanliness,
  "n_52_tree_appearance" DOUBLE  -- 52 Tree Appearance,
  "n_53_weediness" DOUBLE  -- 53 Weediness,
  "n_54_clearance" DOUBLE  -- 54 Clearance,
  "n_11_pass" DOUBLE  -- 11 Pass,
  "n_21_pass" DOUBLE  -- 21 Pass,
  "n_22_pass" DOUBLE  -- 22 Pass,
  "n_31_pass" DOUBLE  -- 31 Pass,
  "n_32_pass" DOUBLE  -- 32 Pass,
  "n_33_pass" DOUBLE  -- 33 Pass,
  "n_34_pass" DOUBLE  -- 34 Pass,
  "n_41_pass" DOUBLE  -- 41 Pass,
  "n_42_pass" DOUBLE  -- 42 Pass,
  "n_43_pass" DOUBLE  -- 43 Pass,
  "n_44_pass" DOUBLE  -- 44 Pass,
  "n_45_pass" DOUBLE  -- 45 Pass,
  "n_46_pass" DOUBLE  -- 46 Pass,
  "n_51_pass" DOUBLE  -- 51 Pass,
  "n_52_pass" DOUBLE  -- 52 Pass,
  "n_53_pass" DOUBLE  -- 53 Pass,
  "n_54_pass" DOUBLE  -- 54 Pass,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR,
  "priority" VARCHAR
);