search

agrc / porter

UGRC tracks the additions, replacements, and deletions of SGID items (in the broadest sense of add, replace, or delete) through issues in this repository.
https://gis.utah.gov/documentation/policy/
MIT License
2 stars 0 forks source link

Alter Schema of SOCIETY.StateFuleSites #170

Closed rkelson closed 2 years ago

rkelson commented 2 years ago

Summary

Fleet operations has provided a spreadsheet of current Utah gas card fuel sites to replace what we currently have. They would like to filter the information in https://arcg.is/CynHm0 with new attributes they have provided.

Migration Guide

There should be minimal users affected by this schema change as the main users of the dataset are the ones requesting the additions

While this dataset currently has separate fields for Gas and Diesel I would like to remove these and add a field _FuelType. I also need to add a few other fields.

Action items

  1. Assign a person who should complete the task by replacing name with their github @name.
  2. Check [x] the box when the task is completed and add the date of completion.
  3. ~Strike~ out all items that do not apply.

~### Soft Delete~

The purpose of the soft delete is to ensure that all of our users and applications have gracefully migrated off of the dataset. Soft deletes will remain in effect for 14 days. During this time, we will have the ability to restore the dataset to its original SGID offering(s). After these 14 days, the item is then ready for a hard delete.

Note: If this dataset is being replaced, then wait until the new data is publicly available before completing these steps:

~### Hard Delete~

Hard deletes are final. It is recommended to complete the soft delete process before moving on to these steps. If you decide to skip the soft delete, note that you will need to incorporate some of those steps here.

~### Shelve/Static~

Choose one based on situation.

~Add record to table.~

:robot: Automation validation

  1. Assign yourself or someone to check the item by replacing name with their github @name.
  2. Check [x] the box and add the date of verification 2020/01/01 when the task is verified.
  3. ~Strike~ out all items that do not apply.

Are there service dependencies

Notification

Group Task Assignments

  1. Check [x] the box when you have assigned all the tasks relevant to your group.
rkelson commented 2 years ago

decided we do not need to delete fields, only add them