Remove UTA Commuter Rail Stations from SGID

[gregbunce]

Summary

• Internal Dataset Name: Transportation.CommuterRailStations_UTA
• External Dataset Name: Utah UTA Commuter Rail Stations
• ArcGIS Online Url: https://utah.maps.arcgis.com/home/item.html?id=6fd39acf47884e1dbe6c303e40f1367a

UTA now has its own ArcGIS Enterprise Portal and is hosting this layer and sharing it with UGRC's SGID (SGID on ArcGIS) via Distributed Collaboration in UGRC's AGOL.

Migration Guide

The goal is to direct our users to UTA's web service, via the SGID Index and the SGID on ArcGIS.

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.AGOLItems table (@gregbunce, completed: 2024/07/30)
• Remove all tags other than "Deprecated" in the SDE metadata (@gregbunce, completed: 2024/07/30)
• Add note to SDE description noting when layer will be deleted and any replacement layer (@gregbunce, completed: 2024/07/30)
• Update the SGID Index row to point to UTA's hosted data (@gregbunce, completed: 2024/07/30)
• Change Authoritative field to d in SGID.META.AGOLItems to automatically set the Deprecated AGOL flag. Allow the d to persist through one run of Auditor - currently, Auditor runs daily at 5:00am (@gregbunce, completed: 2024/07/30)
  • After at least one successful run of Auditor:
    • Remove the row from the SGID.META.AGOLItems table. This will trigger the removal of this item in Open SGID (@gregbunce, completed: 2024/08/01)
    • Unshare the item from its SGID group, which will remove it from the SGID on ArcGIS (@gregbunce, completed: 2024/07/30)
• 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/08/12).

Hard Delete

Target Date: 2024/08/15

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/08/15)
  • Deprecated database layers should be backed up on Google Drive > AGRC Projects > SGID > deprecated layers > internal_db_sgid_layers (@ZachBeck, completed: 2024/08/15).
• Remove ArcGIS Online item: (@ZachBeck, completed: 2024/08/24)
  • 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 (@stdavis, completed: 2024/00/00)
• Update the SGID Index (@gregbunce, completed: 2024/08/15)
• Remove/delete the relevant gis.utah.gov data page (including downloadMetadata.ts) (@ZachBeck, completed: 2024/08/15)
• Update SGID.META.AGOLItems table, remove row (@ZachBeck, completed: 2024/08/15)
• Remove row from SGID.META.ChangeDetection (@stdavis, completed: 2024/08/26)
• Remove data from forklift hashing and receiving (@stdavis, completed: 2024/08/26)
• Remove row from data/hashed/changedetection.gdb/TableHashes (@stdavis, completed: 2024/08/26)

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

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.

• Remove data from Open SGID (@steveoh, on 2024/09/02)
• sgid-index (@steveoh on 2024/09/02)
• Auditor sets appropriate shelved/static/Deprecated information (@jacobdadams on 2024/07/31)

Are there service dependencies

• Are clients querying this data with the WebAPI?
• Update NG911 client maps with latest data sources (@gregbunce on 2024/08/15)
• Does any other application depend on this data?
  • Remove from locate pallet and repoint app at UTA service (@stdavis, completed: 2024/08/19)

Notification

• Twitter (@steveoh)

Group Task Assignments

1. 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]

conductor results for tasks - 332

check	status
@gregbunce has completed 1 out of 10 tasks	⛔
@ZachBeck has completed 0 out of 6 tasks	⛔
@stdavis has completed 0 out of 4 tasks	⛔
@steveoh has completed 0 out of 4 tasks	⛔
@jacobdadams has completed 0 out of 1 tasks	⛔
@rkelson has completed 0 out of 1 tasks	⛔

[agrc-conductor]

conductor results for Transportation.CommuterRailStations_UTA

check	status
internal sgid	⛔
meta table	⛔
open sgid	⛔
open data	⛔
arcgis online	⛔
stewardship
- porter issue link	⛔

[agrc-conductor]

conductor results for tasks - 332

check	status
@gregbunce has completed 8 out of 10 tasks	⛔
@ZachBeck has completed 0 out of 6 tasks	⛔
@stdavis has completed 0 out of 4 tasks	⛔
@steveoh has completed 0 out of 4 tasks	⛔
jacobdadams has completed 1 out of 1 tasks	👍
@rkelson has completed 0 out of 1 tasks	⛔

[agrc-conductor]

conductor results for Transportation.CommuterRailStations_UTA

check	status
internal sgid	⛔
meta table	👍
stewardship
- porter issue link	⛔

[agrc-conductor]

conductor results for tasks - 332

check	status
@gregbunce has completed 8 out of 10 tasks	⛔
@ZachBeck has completed 0 out of 6 tasks	⛔
@stdavis has completed 0 out of 4 tasks	⛔
@steveoh has completed 0 out of 4 tasks	⛔
jacobdadams has completed 1 out of 1 tasks	👍
@rkelson has completed 0 out of 1 tasks	⛔

[agrc-conductor]

conductor results for Transportation.CommuterRailStations_UTA

check	status
internal sgid	⛔
meta table	👍
stewardship
- porter issue link	⛔

[agrc-conductor]

conductor results for tasks - 332

check	status
gregbunce has completed 10 out of 10 tasks	👍
@ZachBeck has completed 5 out of 6 tasks	⛔
@stdavis has completed 0 out of 5 tasks	⛔
@steveoh has completed 0 out of 4 tasks	⛔
jacobdadams has completed 1 out of 1 tasks	👍
@rkelson has completed 0 out of 1 tasks	⛔

[agrc-conductor]

conductor results for Transportation.CommuterRailStations_UTA

check	status
internal sgid	👍
meta table	👍
stewardship
- porter issue link	⛔

[agrc-conductor]

conductor results for tasks - 332

check	status
gregbunce has completed 10 out of 10 tasks	👍
@ZachBeck has completed 5 out of 6 tasks	⛔
@stdavis has completed 1 out of 5 tasks	⛔
@steveoh has completed 2 out of 4 tasks	⛔
jacobdadams has completed 1 out of 1 tasks	👍
@rkelson has completed 0 out of 1 tasks	⛔

[agrc-conductor]

conductor results for Transportation.CommuterRailStations_UTA

check	status
internal sgid	👍
meta table	👍
stewardship
- porter issue link	👍

[agrc-conductor]

conductor results for tasks - 332

check	status
gregbunce has completed 10 out of 10 tasks	👍
ZachBeck has completed 6 out of 6 tasks	👍
stdavis has completed 4 out of 4 tasks	👍
@steveoh has completed 2 out of 4 tasks	⛔
jacobdadams has completed 1 out of 1 tasks	👍
@rkelson has completed 0 out of 1 tasks	⛔

[agrc-conductor]

conductor results for Transportation.CommuterRailStations_UTA

check	status
internal sgid	👍
meta table	👍
stewardship
- porter issue link	👍

[agrc-conductor]

conductor results for tasks - 332

check	status
gregbunce has completed 10 out of 10 tasks	👍
ZachBeck has completed 6 out of 6 tasks	👍
stdavis has completed 4 out of 4 tasks	👍
steveoh has completed 4 out of 4 tasks	👍
jacobdadams has completed 1 out of 1 tasks	👍
@rkelson has completed 0 out of 1 tasks	⛔

[agrc-conductor]

conductor results for Transportation.CommuterRailStations_UTA

check	status
internal sgid	👍
meta table	👍
stewardship
- porter issue link	👍

[agrc-conductor]

conductor results for tasks - 332

check	status
gregbunce has completed 10 out of 10 tasks	👍
ZachBeck has completed 6 out of 6 tasks	👍
stdavis has completed 4 out of 4 tasks	👍
steveoh has completed 4 out of 4 tasks	👍
jacobdadams has completed 1 out of 1 tasks	👍
@rkelson has completed 0 out of 1 tasks	⛔

[agrc-conductor]

conductor results for Transportation.CommuterRailStations_UTA

check	status
internal sgid	👍
meta table	👍
stewardship
- porter issue link	👍