Tracking and Summary Tables
The Tracking and Summary Tables reflect Pittsburgh city departments’ overall compliance with the Open Data Ordinance. They summarize city-wide and departmental participation in needs assessments and brainstorming sessions, progress with data inventorying and identifying top 10 Right to Know (RTK) requests, and other key metrics of the Open Data Ordinance.
The Excel file contains four sheets each with a table: ‘City,’ ‘Department,’ ‘Data,’ and ‘Data Stewards.’ The ‘Data’ and ‘Data Steward’ tables are tracking tables, which consist of counts and tallies that are referenced by formulas in the other tables. The ‘City’ and ‘Department’ tables update automatically when the tracking tables are updated. This reduces the amount of work involved in producing summary data for reports. The only tables that need to be updated are the counts and tallies in the ‘Data’ and ‘Data Steward’ tracking tables.
The User Guide: Tracking and Summary Tables describes the structure, variables, and values of each table and which tables and values to update.
The User Guide: Newsletter provides information on interpreting the summary tables.
City
The ‘City’ table is a summary table for indicators of success for the entire city.
Department
The ‘Department’ table is a summary table for indicators of success for each department.
