About this Dataset

Inventory Of Citywide Enterprise Systems Of Record

A. SUMMARY In compliance with CA Government Code 6270.5 (passed via SB 272), the City must publish a catalog of enterprise systems that collect data about the public. There are certain exceptions to this detailed in the Government Code. The code is available here. B. HOW THE DATASET IS CREATED This dataset is collated through 2 ways: 1. Ongoing updates are made throughout the year to reflect new or retired systems, this process involves DataSF staff reconciling records at the request of departments 2. Annual bulk updates - departments review their inventories and identify changes and updates and submit those to DataSF for a once a year bulk update - not all departments will have changes or their changes will have been captured over the course of the prior year already as ongoing updates C. UPDATE PROCESS The dataset changes infrequently and is uploaded manually as needed by DataSF staff D. HOW TO USE THIS DATASET Companion dataset inventory dataset A companion dataset of inventoried and published datasets can be accessed online as well.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:28.807746
Tags: gov-code-6270-5, inventory, open-data, ref-inventory, sb-272, sb272, systems

Tables

Table 1

@usgov.city_of_san_francisco_inventory_of_citywide_enterprise_3ba93c55.table_1

83.11 KB
490 rows
15 columns


CREATE TABLE table_1 (
  "id" VARCHAR,
  "department_custodian" VARCHAR,
  "department_name_of_data_system" VARCHAR,
  "purpose" VARCHAR,
  "general_description_of_categories_or_types_of_data" VARCHAR,
  "vendor" VARCHAR,
  "product" VARCHAR,
  "frequency_data_collected" VARCHAR,
  "frequency_data_updated" VARCHAR,
  "data_classification_high" VARCHAR,
  "data_classification_low" VARCHAR,
  "remove" VARCHAR,
  "datasets" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);