About this Dataset

Street & Sidewalk Maintenance Standards Results, Jan 2022 - Dec 2024

Since July 2004, San Francisco’s Charter has required the Controller’s Office (CON) to work with San Francisco Public Works (Public Works) to develop and implement street and sidewalk maintenance standards and report out on the City’s condition under the standards. This data file contains street and sidewalk evaluation results from 1/1/2022 to 12/31/2024. 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 past annual reports in the "Past Reports" section of https://www.sf.gov/street-and-sidewalk-maintenance-standards
Organization: City of San Francisco
Last updated: 2025-03-29T17:08:22.180910
Tags: controllers-street-evaluation-program, evaluation, graffiti, litter, sidewalk, street, street-evaluation, streets, trash

Tables

Table 1

@usgov.city_of_san_francisco_street_sidewalk_maintenance_stan_60d017dc.table_1

293.9 kB
6,016 rows
39 columns

CREATE TABLE table_1 (
  "route_id" BIGINT  -- Route ID:,
  "route_location" VARCHAR  -- Route Location:,
  "is_this_route_predominantly_residential_or_commercial__8dee9aaf" BIGINT  -- Is This Route Predominantly Residential Or Commercial/industrial/mixed Use?,
  "select_the_statement_that_best_describes_the_amount_an_286c980c" BIGINT  -- Select The Statement That Best Describes The Amount And Distribution Of Litter In The Street.,
  "objectid" BIGINT,
  "does_litter_obstruct_the_street" DOUBLE  -- Does Litter Obstruct The Street?,
  "select_the_statement_that_best_describes_the_amount_an_9d4f3412" BIGINT  -- Select The Statement That Best Describes The Amount And Distribution Of Litter On The Sidewalk.,
  "how_many_large_abandoned_items_are_present" BIGINT  -- How Many Large Abandoned Items Are Present?,
  "what_types_of_items_are_present_select_all_that_apply" DOUBLE  -- What Types Of Items Are Present? (select All That Apply),
  "other_dumped_items" VARCHAR  -- Other Dumped Items:,
  "does_illegal_dumping_obstruct_the_street" DOUBLE  -- Does Illegal Dumping Obstruct The Street?,
  "how_many_instances_of_graffiti_are_present_on_private__d7ccdaab" BIGINT  -- How Many Instances Of Graffiti Are Present On Private Property Or On The Sidewalk Or Non-painted Curb Immediately Adjacent To Private Property?,
  "how_many_instances_of_graffiti_are_present_on_sf_gov_property" BIGINT  -- How Many Instances Of Graffiti Are Present On SF Gov Property?,
  "how_many_instances_of_graffiti_are_present_on_other_property" BIGINT  -- How Many Instances Of Graffiti Are Present On Other Property?,
  "select_the_statement_that_best_describes_the_amount_an_0a92ad61" BIGINT  -- Select The Statement That Best Describes The Amount And Distribution Of Broken Glass On The Street And Sidewalk:,
  "how_many_instances_of_broken_glass_are_present_along_t_ab1014a5" DOUBLE  -- How Many Instances Of Broken Glass Are Present Along The Sidewalk And Street?,
  "how_many_instances_of_feces_are_present" BIGINT  -- How Many Instances Of Feces Are Present?,
  "how_many_abandoned_syringes_are_present" BIGINT  -- How Many Abandoned Syringes Are Present?,
  "how_many_used_or_opened_condoms_are_present" BIGINT  -- How Many Used Or Opened Condoms Are Present?,
  "how_many_dead_animals_are_present" BIGINT  -- How Many Dead Animals Are Present?,
  "does_the_route_have_one_or_more_trash_receptacles" BIGINT  -- Does The Route Have One Or More Trash Receptacles?,
  "are_any_trash_receptacles_overflowing" BIGINT  -- Are Any Trash Receptacles Overflowing?,
  "is_sidewalk_clearance_less_than_4_feet_wide_or_8_feet__0e3443e0" BIGINT  -- Is Sidewalk Clearance Less Than 4 Feet Wide Or 8 Feet High At Any Point?,
  "if_yes_identify_the_cause_select_all_that_apply" DOUBLE  -- If Yes, Identify The Cause (select All That Apply),
  "other_sidewalk_obstructions" VARCHAR  -- Other Sidewalk Obstructions:,
  "does_the_sidewalk_have_any_defects_that_have_not_been__89a5f4f1" BIGINT  -- Does The Sidewalk Have Any Defects That Have Not Been Marked For Repair?,
  "does_the_sidewalk_have_any_marked_defects_that_have_no_27e9e2e8" BIGINT  -- Does The Sidewalk Have Any Marked Defects That Have Not Been Repaired?,
  "how_severe_are_the_pavement_defects" DOUBLE  -- How Severe Are The Pavement Defects?,
  "do_you_detect_any_strong_unpleasant_or_offensive_odors_546e1a82" BIGINT  -- Do You Detect Any Strong Unpleasant Or Offensive Odors Along The Street Or Sidewalk?,
  "if_yes_is_the_odor_from_a_sewer_or_catch_basin" DOUBLE  -- If Yes, Is The Odor From A Sewer Or Catch Basin?,
  "does_the_route_have_one_or_more_transit_shelters" BIGINT  -- Does The Route Have One Or More Transit Shelters?,
  "which_of_the_following_issues_are_present_in_or_on_any_6808266b" DOUBLE  -- Which Of The Following Issues Are Present In Or On Any Of The Transit Shelters Along The Route?,
  "creationdate" VARCHAR,
  "analysis_neighborhoods" VARCHAR,
  "evaluation_period" VARCHAR,
  "does_any_graffiti_include_offensive_language_e_g_racia_dc527012" BIGINT  -- Does Any Graffiti Include Offensive Language (e.g., Racial Slurs Or Profanity)?,
  "does_any_graffiti_appear_to_be_stenciled" DOUBLE  -- Does Any Graffiti Appear To Be Stenciled?,
  "are_there_closed_unlabeled_trash_bags_grouped_together_d045f12c" DOUBLE  -- Are There Closed, Unlabeled Trash Bags Grouped Together? (July 2023-December 2024 Only),
  "is_the_pile_of_item_s_more_than_8ft_in_diameter_july_2_85f1e183" DOUBLE  -- Is The Pile Of Item(s) More Than 8ft In Diameter? (July 2023-December 2024 Only)
);