Street & Sidewalk Maintenance Standards Results, Jan 2022 - Dec 2024 by US Government | Demographics and Population Studies

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

287.01 KB
6016 rows
39 columns


CREATE TABLE table_1 (
  "route_id" BIGINT,
  "route_location" VARCHAR,
  "is_this_route_predominantly_residential_or_commercial__8dee9aaf" BIGINT,
  "select_the_statement_that_best_describes_the_amount_an_286c980c" BIGINT,
  "objectid" BIGINT,
  "does_litter_obstruct_the_street" DOUBLE,
  "select_the_statement_that_best_describes_the_amount_an_9d4f3412" BIGINT,
  "how_many_large_abandoned_items_are_present" BIGINT,
  "what_types_of_items_are_present_select_all_that_apply" DOUBLE,
  "other_dumped_items" VARCHAR,
  "does_illegal_dumping_obstruct_the_street" DOUBLE,
  "how_many_instances_of_graffiti_are_present_on_private__d7ccdaab" BIGINT,
  "how_many_instances_of_graffiti_are_present_on_sf_gov_property" BIGINT,
  "how_many_instances_of_graffiti_are_present_on_other_property" BIGINT,
  "select_the_statement_that_best_describes_the_amount_an_0a92ad61" BIGINT,
  "how_many_instances_of_broken_glass_are_present_along_t_ab1014a5" DOUBLE,
  "how_many_instances_of_feces_are_present" BIGINT,
  "how_many_abandoned_syringes_are_present" BIGINT,
  "how_many_used_or_opened_condoms_are_present" BIGINT,
  "how_many_dead_animals_are_present" BIGINT,
  "does_the_route_have_one_or_more_trash_receptacles" BIGINT,
  "are_any_trash_receptacles_overflowing" BIGINT,
  "is_sidewalk_clearance_less_than_4_feet_wide_or_8_feet__0e3443e0" BIGINT,
  "if_yes_identify_the_cause_select_all_that_apply" DOUBLE,
  "other_sidewalk_obstructions" VARCHAR,
  "does_the_sidewalk_have_any_defects_that_have_not_been__89a5f4f1" BIGINT,
  "does_the_sidewalk_have_any_marked_defects_that_have_no_27e9e2e8" BIGINT,
  "how_severe_are_the_pavement_defects" DOUBLE,
  "do_you_detect_any_strong_unpleasant_or_offensive_odors_546e1a82" BIGINT,
  "if_yes_is_the_odor_from_a_sewer_or_catch_basin" DOUBLE,
  "does_the_route_have_one_or_more_transit_shelters" BIGINT,
  "which_of_the_following_issues_are_present_in_or_on_any_6808266b" DOUBLE,
  "creationdate" VARCHAR,
  "analysis_neighborhoods" VARCHAR,
  "evaluation_period" VARCHAR,
  "does_any_graffiti_include_offensive_language_e_g_racia_dc527012" BIGINT,
  "does_any_graffiti_appear_to_be_stenciled" DOUBLE,
  "are_there_closed_unlabeled_trash_bags_grouped_together_d045f12c" DOUBLE,
  "is_the_pile_of_item_s_more_than_8ft_in_diameter_july_2_85f1e183" DOUBLE
);