FY07-11 Street Evaluation Results

data.sfgov.org | Last Updated 6 Sep 2019

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

Tags: controller's street evaluation program, street evaluation, litter, street, sidewalk, inspection, results, performance, graffiti, trash, tree, grime, leaks, spills

This dataset has the following 39 columns:

Column NameAPI Column NameData TypeSample Values
Corridor Namecorridor_nametext
StartStreetNamestartstreetnametext
EndStreetNameendstreetnametext
Route No.route_nonumber
Districtdistrictnumber
Inspectorinspectortext
Side of Streetside_of_streettext
Type of Streettype_of_streettext
Clean Corridorclean_corridortext
Fiscal Yearfiscal_yeartext
Quarter of Inspectionquarter_of_inspectiontext
Year/Monthyear_monthtext
Date of Inspectiondate_of_inspectioncalendar_date
Start Timestart_timetext
End Timeend_timetext
Sweeping Day(s)sweeping_day_stext
Sweeping Time(s)sweeping_time_stext
1.1_1_1number
1.1 Litter Count_1_1_litter_counttext
2.1_2_1number
2.1 Litter Count_2_1_litter_counttext
2.2_2_2number
2.3_2_3number
2.4_2_4text
2.5_2_5text
3.1_3_1number
3.2_3_2number
3.3_3_3number
4.1_4_1text
4.2_4_2text
4.3_4_3text
4.4_4_4text
4.5_4_5text
4.6_4_6text
4.0 Pass?_4_0_passtext
5.1_5_1number
5.2_5_2number
5.3_5_3number
5.4_5_4number