Remove Transportation.BusFlexRoutes_UTA from SGID
Closed this issue · 23 comments
stdavis commented
Summary
- Internal Dataset Name: Transportation.BusFlexRoutes_UTA
- External Dataset Name: Utah UTA Bus Flex Routes
- ArcGIS Online Url: https://www.arcgis.com/home/item.html?id=e12362f46b8e4cc798807e576c0d1e88
This dataset has no metadata and no one from UGRC knows anything about it. It does not show up in the SGID Index or Stewardship spreadsheets. I emailed Sumerset from UDOT about it and she said:
This Flex Route dataset doesn’t look familiar, but I can tell it’s out of date because it has 17 routes and there are currently only 14.
Also, the flex routes are in the current route layer:
https://maps.rideuta.com/portal/apps/sites/#/uta-open-data/datasets/46e43ef851024fe5928c341071bb2e99/about
So, if you can archive it, that would be great.
Migration Guide
This dataset has been replaced by UTA Routes and Most Recent Ridership in the SGID on ArcGIS.
Action items
- Assign a person who should complete the task by replacing
namewith their github@name. - Check [x] the box when the task is completed and add the date of completion.
Strikeout 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:
- Append "(Mature Support)" to the end of the item title in the
SGID.META.AGOLItemstable (@stdavis, completed:2024/04/29) - Remove all tags other than "Deprecated" in the SDE metadata (@stdavis, completed:
2024/04/29) - Add note to SDE description noting when layer will be deleted and any replacement layer (@stdavis, completed:
2024/04/29)
- [ ] Update the SGID Index row as deprecated by pasting the related Porter issue URL in the "porterUrl" field and setting the value of the "ugrcStatus" field as "removed". Also update the "refreshCycle" field (@stdavis, completed:2024/00/00)- this dataset is not in the sgid index
- Change
Authoritativefield todinSGID.META.AGOLItemsto automatically set theDeprecatedAGOL flag. Allow thedto persist through one run of Auditor - currently, Auditor runs daily at 5:00am (@stdavis, completed:2024/04/29)- After at least one successful run of Auditor:
- Remove the row from the
SGID.META.AGOLItemstable. This will trigger the removal of this item in Open SGID (@jacobdadams, completed:2024/04/30) - Unshare the item from its SGID group, which will remove it from the SGID on ArcGIS (@stdavis, completed:
2024/05/06)
- Remove the row from the
- After at least one successful run of Auditor:
- Check if this layer in the base maps. If so, work with Zach to develop a path forward before you proceed with a Hard Delete (@ZachBeck, completed:
2024/04/29).
Hard Delete
Target Date: 2024/05/20
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.
- Manually remove data from the Internal SGID (@ZachBeck, completed:
2024/06/10)- Deprecated database layers should be backed up on Google Drive > AGRC Projects > SGID > deprecated layers > internal_db_sgid_layers (@ZachBeck, completed:
2024/06/10).
- Deprecated database layers should be backed up on Google Drive > AGRC Projects > SGID > deprecated layers > internal_db_sgid_layers (@ZachBeck, completed:
- Remove ArcGIS Online item: (@ZachBeck, completed:
2024/06/10)- Manually delete the AGOL item
- Deprecated AGOL items can be backed up on Google Drive > AGRC Projects > SGID > deprecated layers > agol_sgid_layers.
- [ ] Remove Farm from AGOL connection (name, completed:2024/00/00)
- Update the SGID Index fields: "arcGisOnline", "openSgid", "openSgidTableName"
- this dataset is not in the sgid index
- Update relevant gis.utah.gov data pages (@stdavis, completed:
2024/05/20) - Update
SGID.META.AGOLItemstable (@stdavis, completed:2024/05/28)- delete row from table
- Delete Google Drive data, if any (@ZachBeck, completed:
2024/00/00) - Remove row from
SGID.META.ChangeDetection(@stdavis, completed:2024/06/17)- it was already gone
- Remove data from forklift hashing and receiving (@stdavis, completed:
2024/06/17) - Remove row from
data/hashed/changedetection.gdb/TableHashes(@stdavis, completed:2024/06/17)
Shelve/Static
Choose one based on situation.
- [ ] Upload to UtahAGRC/AGRC_Shelved folder in AGOL (New shelved item not already in AGOL) (name, completed: 2024/00/00)
- [ ] Move existing AGOL item to AGRC_Shelved AGOL folder (shelving an item already in AGOL) (name, completed: 2024/00/00)
- [ ] Upload to appropriate UtahAGRC/{SGID Category} folder in AGOL (for static datasets) (name, completed: 2024/00/00)
Add record to table.
- [ ] Add record to AGOLItems_shelved table in ArcGIS Online with shelved or static in the CATEGORY field (name, completed: 2024/00/00)
🤖 Automation validation
- Assign yourself or someone to check the item by replacing
namewith their github@name. - Check [x] the box and add the date of verification
2020/01/01when the task is verified. Strikeout all items that do not apply.
- Remove data from Open SGID (@stdavis on
2024/06/17) - sgid-index (@steveoh on
2024/05/30) - Auditor sets appropriate
Deprecatedinformation (@jacobdadams on2024/04/30)
Are there service dependencies
- Are clients querying this data with the WebAPI? @steveoh Can you answer this question?
- Notify Don Jackson (don.jackson1 at motorolasolutions.com) if the data is in the Next-Generation 911 Motorola Aware Map? (@gregbunce on
2024/04/29) - Does any other application depend on this data? (@gregbunce on
2024/06/17)
Notification
- Twitter (@steveoh)
Group Task Assignments
- Check [x] the box when you have assigned all the tasks relevant to your group.
- Data Team (@gregbunce)
- Dev Team (@steveoh)
- Cadastre Team (@rkelson)
agrc-conductor commented
conductor results for tasks - 316
| check | status |
|---|---|
| @stdavis has completed 0 out of 12 tasks | ⛔ |
| @jacobdadams has completed 0 out of 2 tasks | ⛔ |
| @ZachBeck has completed 0 out of 1 tasks | ⛔ |
| @steveoh has completed 2 out of 3 tasks | ⛔ |
| @gregbunce has completed 0 out of 2 tasks | ⛔ |
| @rkelson has completed 0 out of 1 tasks | ⛔ |
agrc-conductor commented
conductor results for category.commuterrailroutes_uta
| check | status |
|---|---|
| internal sgid | 👍 |
| meta table | 👍 |
| stewardship | |
| - porter issue link | ⛔ |
agrc-conductor commented
conductor results for tasks - 316
| check | status |
|---|---|
| @stdavis has completed 0 out of 12 tasks | ⛔ |
| @jacobdadams has completed 0 out of 2 tasks | ⛔ |
| @ZachBeck has completed 0 out of 1 tasks | ⛔ |
| @steveoh has completed 2 out of 3 tasks | ⛔ |
| @gregbunce has completed 0 out of 2 tasks | ⛔ |
| @rkelson has completed 0 out of 1 tasks | ⛔ |
agrc-conductor commented
conductor results for category.commuterrailroutes_uta
| check | status |
|---|---|
| internal sgid | 👍 |
| meta table | 👍 |
| stewardship | |
| - porter issue link | ⛔ |
agrc-conductor commented
conductor results for tasks - 316
| check | status |
|---|---|
| @stdavis has completed 0 out of 12 tasks | ⛔ |
| @jacobdadams has completed 0 out of 2 tasks | ⛔ |
| @ZachBeck has completed 0 out of 1 tasks | ⛔ |
| @steveoh has completed 2 out of 3 tasks | ⛔ |
| @gregbunce has completed 0 out of 2 tasks | ⛔ |
| @rkelson has completed 0 out of 1 tasks | ⛔ |
agrc-conductor commented
conductor results for category.commuterrailroutes_uta
| check | status |
|---|---|
| internal sgid | 👍 |
| meta table | 👍 |
| stewardship | |
| - porter issue link | ⛔ |
agrc-conductor commented
conductor results for tasks - 316
| check | status |
|---|---|
| @stdavis has completed 4 out of 11 tasks | ⛔ |
| jacobdadams has completed 2 out of 2 tasks | 👍 |
| @ZachBeck has completed 1 out of 5 tasks | ⛔ |
| @steveoh has completed 2 out of 3 tasks | ⛔ |
| gregbunce has completed 2 out of 2 tasks | 👍 |
| @rkelson has completed 0 out of 1 tasks | ⛔ |
agrc-conductor commented
conductor results for transportation.BusFlexRoutes_UTA
| check | status |
|---|---|
| internal sgid | ⛔ |
| meta table | 👍 |
| stewardship | ⛔ Did not find transportation.BusFlexRoutes_UTA in the worksheet |
agrc-conductor commented
conductor results for tasks - 316
| check | status |
|---|---|
| @stdavis has completed 5 out of 11 tasks | ⛔ |
| jacobdadams has completed 2 out of 2 tasks | 👍 |
| @ZachBeck has completed 1 out of 5 tasks | ⛔ |
| @steveoh has completed 2 out of 3 tasks | ⛔ |
| gregbunce has completed 2 out of 2 tasks | 👍 |
| rkelson has completed 1 out of 1 tasks | 👍 |
agrc-conductor commented
conductor results for transportation.BusFlexRoutes_UTA
| check | status |
|---|---|
| internal sgid | ⛔ |
| meta table | 👍 |
| stewardship | ⛔ Did not find transportation.BusFlexRoutes_UTA in the worksheet |
agrc-conductor commented
conductor results for tasks - 316
| check | status |
|---|---|
| @stdavis has completed 5 out of 11 tasks | ⛔ |
| jacobdadams has completed 2 out of 2 tasks | 👍 |
| @ZachBeck has completed 1 out of 5 tasks | ⛔ |
| @steveoh has completed 2 out of 3 tasks | ⛔ |
| gregbunce has completed 2 out of 2 tasks | 👍 |
| rkelson has completed 1 out of 1 tasks | 👍 |
agrc-conductor commented
conductor results for transportation.BusFlexRoutes_UTA
| check | status |
|---|---|
| internal sgid | ⛔ |
| meta table | 👍 |
| stewardship | ⛔ Did not find transportation.BusFlexRoutes_UTA in the worksheet |
agrc-conductor commented
conductor results for tasks - 316
| check | status |
|---|---|
| @stdavis has completed 6 out of 11 tasks | ⛔ |
| jacobdadams has completed 2 out of 2 tasks | 👍 |
| @ZachBeck has completed 1 out of 5 tasks | ⛔ |
| @steveoh has completed 2 out of 3 tasks | ⛔ |
| gregbunce has completed 2 out of 2 tasks | 👍 |
| rkelson has completed 1 out of 1 tasks | 👍 |
agrc-conductor commented
conductor results for transportation.BusFlexRoutes_UTA
| check | status |
|---|---|
| internal sgid | ⛔ |
| meta table | 👍 |
| stewardship | ⛔ Did not find transportation.BusFlexRoutes_UTA in the worksheet |
agrc-conductor commented
conductor results for tasks - 316
| check | status |
|---|---|
| @stdavis has completed 7 out of 11 tasks | ⛔ |
| jacobdadams has completed 2 out of 2 tasks | 👍 |
| @ZachBeck has completed 1 out of 5 tasks | ⛔ |
| steveoh has completed 3 out of 3 tasks | 👍 |
| @gregbunce has completed 2 out of 3 tasks | ⛔ |
| rkelson has completed 1 out of 1 tasks | 👍 |
agrc-conductor commented
conductor results for transportation.BusFlexRoutes_UTA
| check | status |
|---|---|
| internal sgid | ⛔ |
| meta table | 👍 |
| stewardship | ⛔ Did not find transportation.BusFlexRoutes_UTA in the worksheet |
agrc-conductor commented
conductor results for tasks - 316
| check | status |
|---|---|
| @stdavis has completed 7 out of 11 tasks | ⛔ |
| jacobdadams has completed 2 out of 2 tasks | 👍 |
| @ZachBeck has completed 1 out of 5 tasks | ⛔ |
| steveoh has completed 3 out of 3 tasks | 👍 |
| @gregbunce has completed 2 out of 3 tasks | ⛔ |
| rkelson has completed 1 out of 1 tasks | 👍 |
agrc-conductor commented
conductor results for transportation.BusFlexRoutes_UTA
| check | status |
|---|---|
| internal sgid | ⛔ |
| meta table | 👍 |
| stewardship | ⛔ Did not find transportation.BusFlexRoutes_UTA in the worksheet |
stdavis commented
@ZachBeck I think that you are up next for this issue if you have some time this week. Thanks!
agrc-conductor commented
conductor results for tasks - 316
| check | status |
|---|---|
| @stdavis has completed 7 out of 11 tasks | ⛔ |
| jacobdadams has completed 2 out of 2 tasks | 👍 |
| ZachBeck has completed 5 out of 5 tasks | 👍 |
| steveoh has completed 3 out of 3 tasks | 👍 |
| @gregbunce has completed 2 out of 3 tasks | ⛔ |
| rkelson has completed 1 out of 1 tasks | 👍 |
agrc-conductor commented
conductor results for transportation.BusFlexRoutes_UTA
| check | status |
|---|---|
| internal sgid | 👍 |
| meta table | 👍 |
| stewardship | ⛔ Did not find transportation.BusFlexRoutes_UTA in the worksheet |
stdavis commented
- Does any other application depend on this data?
@gregbunce Do you know the answer to this question? Otherwise, I think that I can close out this issue.
gregbunce commented
Close it out!