About this Dataset

Citywide Service Inventory

A. SUMMARY The Citywide Service Inventory is the most comprehensive view of the services offered by the City & County of San Francisco. A public facing service is when a department provides a product or information in response to a customer request. A customer can be anyone who the City & County of San Francisco serves including residents, businesses, visitors and anyone else. B. HOW THE DATASET IS CREATED All information was validated or provided by Department leadership in September-October of 2020. C. UPDATE PROCESS As needed D. HOW TO USE THIS DATASET Data can be filtered by department, service area, service delivery and digital maturity.
Organization: City of San Francisco
Last updated: 2021-08-07T18:39:05.112907

Tables

Table 1

@usgov.city_of_san_francisco_citywide_service_inventory.table_1

213.24 kB
989 rows
45 columns

CREATE TABLE table_1 (
  "department" VARCHAR,
  "department_acronym" VARCHAR  -- Department: Acronym,
  "division" VARCHAR,
  "title" VARCHAR,
  "service_description" VARCHAR,
  "service_area" VARCHAR,
  "service_area_subcategory" VARCHAR,
  "customer_description" VARCHAR,
  "customer_detail" VARCHAR,
  "required_fees" VARCHAR,
  "required_fees_other" VARCHAR,
  "service_federally_mandated" VARCHAR,
  "service_federally_mandated_other" VARCHAR,
  "service_completed_by_department" VARCHAR,
  "service_completed_by_department_other" VARCHAR,
  "other_departments" VARCHAR,
  "delivery_method_walk_in" VARCHAR,
  "delivery_method_phone" VARCHAR,
  "delivery_method_mail" VARCHAR,
  "delivery_method_text" VARCHAR,
  "delivery_method_internet" VARCHAR,
  "delivery_method_other" VARCHAR,
  "delivery_method_other_description" VARCHAR,
  "service_url" VARCHAR,
  "service_phone" VARCHAR,
  "service_time_walk_in" DOUBLE,
  "service_time_phone" DOUBLE,
  "service_time_internet" DOUBLE,
  "service_time_other" DOUBLE,
  "weekly_customers_served_high" DOUBLE,
  "weekly_customers_served_low" DOUBLE,
  "digital_maturity" DOUBLE,
  "receive_customer_information" VARCHAR,
  "receive_custome_rinformation_other" VARCHAR,
  "application_to_record" VARCHAR,
  "technology_replacement" VARCHAR,
  "technology_replacement_detail" VARCHAR,
  "tabular_data" VARCHAR,
  "tabular_data_other" VARCHAR,
  "raw_data_made_available" VARCHAR,
  "raw_data_made_available_other" VARCHAR,
  "vulnerable_population" VARCHAR,
  "vulnerable_population_description" VARCHAR,
  "priority_service_area" VARCHAR,
  "priority_service_area_subcategory" VARCHAR
);