Spreadsheet: 049289bc-fff3-4c52-8421-47a25dceaf24
Sheet: Sheet1

City & County of San Francisco | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Department of Public Works and Controller's Office
Street & Sidewalk Maintenance Standards Program
Codebook - Inspection Results
 | Target Data Users: |  | Interested users should at a minimum have a working knowledge of Microsoft Excel, data management concepts, and the operations of the City and County of San Francisco (the City).
 | Background: |  | San Francisco Charter Section F.102 (Proposition C, passed by the voters in November 2003) requires that the City establish standards for street, sidewalk, and park maintenance; the City departments engaged in street, sidewalk, and park maintenance publish their schedules on the web; and the Controller's Office conduct an annual performance audit of the City's street, sidewalk and park maintenance and cleaning operations.  Since July 2004, the Controller's Office's City Services Auditor (CSA) Division has worked with the Department of Public Works (DPW) to develop maintenance standards and schedules and inspect for compliance.  This data file consolidates street and sidewalk inspection results from FY06-07 through FY10-11.  Inspections are conducted at the midpoint of a street sweeping schedule.  Standards are evaluated on 100 foot segments of five City blocks.
 | Questions: |  | Website: [NAME], [NAME]: [EMAIL], Phone Number: [PHONE]
 | Notes:
 |  | Detailed Street and Sidewalk Maintenance Standards can be found at the following website: http://sfcontroller.org/Modules/ShowDocument.aspx?documentid=881
 |  | N/A = the standard is not applicable for a particular route.
 |  | Not Recorded = an inspection description was not recorded on the original, completed inspection form.
 |  | Inspection information and data may vary slightly from historical reports due to corrections.
 | Col. | Column Heading | Description | Type of Data
 | A | [NAME] | Name of the street that was inspected. | Text
 | B | Start Street | First cross street of the route inspected. | Text
 | C | End Street | Last cross street of the route inspected. | Text
 | D | Route No. | DPW street sweeping route number. | Text
 | E | District | San Francisco Supervisorial District. | Number
 | F | Inspector | MNC (Mission Neighborhood Center, the Department of Public Works contractor that conducts inspections) or CSA (City Service Auditor inspector). | Text
 | G | Side of Street | Directional description of the side of the street that was inspected. | Text
 | H | Type of Street | Residential or Commercial. | Text
 | I | Clean Corridor | Identified as a street section participating in the Mayor's Clean Corridor Program.  To read more, please see the following website: http://www.sfgov.org/site/sfdpw_page.asp?id=54049. | Yes/No
 | J | Fiscal Year | Fiscal Year in which the inspection was conducted.  CCSF's fiscal year begins in July and ends in June in the following calendar year. | General
 | K | Quarter of Inspection | Fiscal Quarter in which the inspection was conducted.  Q1 is July through September.  Q2 is October through December.  [NAME] is January through March.  And Q4 is April through June. | General
 | L | Year/Month | The fiscal year in which the inspection was conducted, the month number of the fiscal year (example: July is the first month of the fiscal year, so July = 1) and the month. | Date
 | M | Date of Inspection | Date on which the inspection was conducted. | Date
 | N | Start Time | The start time at which the inspection was conducted. | Time
 | O | End Time | The end time at which the inspection was conducted. | Time
 | P | Sweeping Day(s) | The mechanical street sweeping day(s) of the route being inspected as recorded by the inspector during the inspection, which corresponds to the street cleaning sign identified on the route.  "Not Recorded" means the sweeping day(s) were not originally recorded during the day and time of the actual inspection.  "Not Posted" means the sweeping day(s) were not posted on the street sweeping sign during the day and time of the actual inspection. | Day(s)
 | Q | Sweeping Time(s) | The mechanical street sweeping time(s) of the route being inspected as recorded by the inspector during the inspection, which corresponds to the street cleaning sign identified on the route.  "Not Recorded" means the sweeping day(s) were not originally recorded during the day and time of the actual inspection.  "Not Posted" means the sweeping day(s) were not posted on the street sweeping sign during the day and time of the actual inspection. | Time(s)
 | R | 1.1 | Street cleanliness standard: "Streets shall be free of litter and rated on a scale of 1.0 to 3.0."  1.0 = acceptably clean: "Less than 5 pieces of litter per 100 curb feet examined."  2.0 = not acceptably clean: "between 5-15 pieces of litter per 100 curb feet examined."  3.0 = very dirty: "over 15 pieces of litter per 100 curb feet examined."  A final rating less than 2.0 must be attained to meet the standard for the route.  Cigarette butts are excluded. | Number
 | S | 1.1 Litter Count | Starting December 2009, MNC and CSA began counting street litter on routes.  The average litter count per route. | Number
 | T | 2.1 | Sidewalk cleanliness (litter) standard: "Sidewalks shall be free of litter and rated on a scale of 1.0 to 3.0."  1.0 = acceptably clean: "Less than 5 pieces of litter per 100 curb feet examined."  2.0 = not acceptably clean: "between 5-15 pieces of litter per 100 curb feet examined."  3.0 = very dirty: "over 15 pieces of litter per 100 curb feet examined."  A final rating less than 2.0 must be attained to meet the standard for the route.  Cigarette butts are included. | Number
 | U | 2.1 Litter Count | Starting December 2009, MNC and CSA began counting sidewalk litter on routes.  The average litter count per route. | Number
 | V | 2.2 | Sidewalk cleanliness (% of sidewalk free of grime, leaks & spills) standard: "90% of sidewalks immediately adjacent to the street in the observed area are free of grime, leaks and spills."  The percent of the sidewalk immediately adjacent to the street in the observed area that is free of grime, leaks and spills. | Percent
 | W | 2.3 | Sidewalk cleanliness (graffiti) standard: "100% of sidewalks are free from graffiti (paint, pen markings, stickers).  Does not include painted utility markings."  Average graffiti count per route. | Number
 | X | 2.4 | Sidewalk cleanliness (illegal dumping) standard: "100% of sidewalks are free of illegally dumped items (furniture, appliances, car parts, etc.), except items labeled for DPW Bulk Item Collection ("BIC").  Exclude items counted under section 4.3."  The percent of the sidewalk that is free of illegally dumped items. | Yes/No
 | Y | 2.5 | Sidewalk cleanliness (feces, needles, glass, condoms) standard: "100% of sidewalks are free from feces, needles, broken glass, or open/used condoms."  The percent of the sidewalk that is free of feces, needles, broken glass, or open/used condoms. | Yes/No
 | Z | 3.1 | [NAME] (DPW) standard: "100% of DPW public property, including street surface and trash receptacles, visible from and immediately adjacent to the street are free of graffiti."  Average graffiti count per route. | Number
 | AA | 3.2 | [NAME] (Non-DPW) standard: "100% of other public agency property (Non-DPW), visible from and immediately adjacent to the street are free of graffiti."  Average graffiti count per route. | Number
 | AB | 3.3 | [NAME] (private) standard: "100% of private sidewalks, structures, and buildings visible from and immediately adjacent to the street are free of graffiti."  Average graffiti count per route. | Number
 | AC | 4.1 | Trash receptacles (fullness) standard: "Trash receptacle is not overflowing (over the top of the receptacle)."  Percent of trash receptacles not overflowing. | Percent
 | AD | 4.2 | Trash receptacles (cleanliness of trash receptacles) standard: "Trash receptacle is clean."  Percent of trash receptables that are clean. | Percent
 | AE | 4.3 | Trash receptacles (cleanliness around trash receptacles) standard: "Immediate area surrounding the trash receptacle is free of litter, debris, illegal dumping, spills, or leakage.  5 pieces of litter or more is unacceptable."  Percent of trash receptacles where the immediate area surrounding it is free of litter, debris, illegal dumping, spills, or leakage. | Percent
 | AF | 4.4 | Trash receptacles (painting) standard: "[NAME] has uniform coat of paint and is not peeling on 90% of the surface, where applicable."  Percent of trash receptacles that have a uniform coat of paint and is not peeling on 90% of the surface, where applicable. | Percent
 | AG | 4.5 | Trash receptacles (structural integrity & function) standard: "Trash receptacle is free of large cracks or damage that effect its use."  Percent of trash receptacles that are free of large cracks or damage that effect its use. | Percent
 | AH | 4.6 | Trash receptacles (doors) standard: "Doors on trash receptacles are closed and secured."  Percent of trash receptacles that are closed and secured. | Percent
 | AI | 4.0 Pass? | Trash receptacles (Summary of all elements) standard: "At least 5 out of 6 elements meet the standard."  "Yes" if at least 5 out of 6 elements meet the standard.  "No" if less than 5 of 6 elements meet the standard.  "N/A" if the trash receptacle standards are not applicable for the route. | Yes/No
 | AJ | 5.1 | Trees & landscaping (cleanliness) standard: "Trees, tree wells, and planters shall be free of litter and debris.  No more than 3 total pieces of litter or debris can be visible per tree well and planter observed, and 90% of tree wells/planters must comply to meet the standard.  The standard is not met if feces, needles, broken glass, or condoms are present in the tree well/planter."  Percent of trees, tree wells, and planters that are free of litter and debris. | Percent
 | AK | 5.2 | Trees & landscaping (tree appearance) standard: "All trees are alive, and 90% of trees have no hanging limbs and are free of damage.  The standard is not met if any tree is dead.  A tree stump or empty tree well counts as a dead tree."  Percent of trees that are alive. | Percent
 | AL | 5.3 | Trees & landscaping (weediness) standard: "90% or more of all tree wells and planters are free of weeds and vines."  Percent of tree wells and planters that are free of weeds and vines. | Percent
 | AM | 5.4 | Trees & landscaping (clearance) standard: "[NAME] and foliage are maintained with an 8-foot vertical clearance for pedestrians over the sidewalk and 14-foot vertical clearance over the street."  Percent of trees limbs and foliage that are maintained with an 8-foot verticle clearance for pedestrians over the sidewalk and 14-foot verticle clearance over the street. | Percent