Data Inventory

1. Locate and open DataInventory.xlsx in Excel or upload it to Google Sheets

The first tab, Data Themes, shows 3 themes, along with the creator, description, and update frequency

The second tab, Dataset Inventory, shows individual datasets for each of these themes, including the date created, status, date published, date retired, and filename.

The third tab, New Chicago datasets, is a list of 6 filenames with dates. These datasets are part of the Street Sweeping Theme.

2. Copy the filenames from the third tab into the bottom of the list in Dataset Inventory

3. Under Theme, use the dropdown to select "Street Sweeping" for all new records

4. Copy the Creation Date into Date Created. Change the format from Month, Day, Year to YYYY-MM-DD

5. Copy the Temporal Extent into Temporal Extent

6. Create titles based upon the Data Theme, the place, and the Temporal Extent (ex. Street Sweeping: Chicago, 2018)

7. Under Status, use the dropdown to select "Completed" for all new records

8. Under Status, use the dropdown to select "Published" for all new records

9. Under Date Published, add today's date for each new record