Remove DDW Irrigated Crop Consumptive Use Zones from SGID

[eneemann]

Summary

• Internal Dataset Name: WATER.DDWIrrigatedCropConsumptiveUseZones
• External Dataset Name: Utah DDW Irrigated Crop Consumptive Use Zones
• ArcGIS Online Url: https://utah.maps.arcgis.com/home/item.html?id=c5d8aef2d211443eb1e70c2ff0d87fc9

DEQ Division of Drinking Water (DDW) will host their own version of this layer in AGOL and will share it with the Water SGID group to expose it through our OpenData/SGID on ArcGIS Hub page.

Migration Guide

A short summary of how users affected by this deprecation can modify their workflows and projects to continue to get similar or improved functionality

This dataset has been replaced by DDW Consumptive Use Zones and users are encouraged to repoint their data to that item/service. UGRC will remove "DDW Irrigated Crop Consumptive Use Zones" from the internal SGID database and OpenSGID. The new DEQ/DDW-hosted AGOL item will be shared and exposed through our OpenData/SGID on ArcGIS Hub page.

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:

• Append "(Mature Support)" to the end of the item title in the SGID.META.AGOLItems table (@eneemann , completed: 2025/04/24)
• 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 (@eneemann, completed: 2025/04/24)
  • 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 (@eneemann, completed: 2025/04/25)
    • Unshare the item from its SGID group, which will remove it from the SGID on ArcGIS (@eneemann, completed: 2025/04/25)
      - [ ] 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 (name, completed: 2025/00/00).
• Remove all tags other than "Deprecated" in the SDE metadata (@eneemann, completed: 2025/04/24)
• Add note to SDE description noting when layer will be deleted and any replacement layer (@eneemann, completed: 2025/04/24)
• Update the SGID Index row as deprecated by pasting the related Porter issue URL in the "porterUrl" field and setting the value of the "indexStatus" field as "removed". Also update the "refreshCycle" field (@eneemann, completed: 2025/04/24)

Hard Delete

Target Date: 2025/05/09

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 (@eneemann, completed: 2025/05/09)
  • Deprecated database layers should be backed up on Google Drive > AGRC Projects > SGID > deprecated layers > internal_db_sgid_layers (@eneemann, completed: 2025/05/09).
• Remove ArcGIS Online item: (@eneemann, completed: 2025/00/00)
  • Manually delete the AGOL item
  • Deprecated AGOL items can be backed up on Google Drive > AGRC Projects > SGID > deprecated layers > agol_sgid_layers.
• Update the SGID Index fields: "arcGisOnline", "openSgid", "openSgidTableName" (@eneemann, completed: 2025/05/02)
• Update relevant gis.utah.gov product pages (including downloadMetadata.ts and public/_redirects) (@eneemann, completed: 2025/05/09)
• Remove row from SGID.META.ChangeDetection (@stdavis, completed: 2025/05/12)
• Remove data from forklift hashing and receiving (@stdavis, completed: 2025/05/12)
• Remove row from data/hashed/changedetection.gdb/TableHashes (@stdavis, completed: 2025/05/12)
• Remove data from record series with archives (@eneemann, completed: 2025/05/09)

🤖 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 2025/01/01 when the task is verified.
3. Strike out all items that do not apply.

• Remove data from Open SGID (@steveoh on 2025/05/19)
• sgid-index (@steveoh on 2025/05/19)
• Auditor sets appropriate shelved/static/Deprecated information (@jacobdadams on 2025/04/25)

Are there service dependencies

• Are clients querying this data with the UGRC API search endpoint? This dashboard may be helpful.
  - [ ] Notify Don Jackson (don.jackson1 at motorolasolutions.com) if the data is in the Next-Generation 911 Motorola Aware Map? (@mhchou on 2025/00/00)
• Does any other application depend on this data? (@stdavis on 2025/05/12)
  • DEQ Environmental Interactive Map - This app has been pointed at the DEQ AGOL item for some time now.
  • Nothing else found in GitHub org search except for the web api.

Notification

• X (@steveoh)

Group Task Assignments

1. Check [x] the box when you have assigned all the tasks relevant to your group.

• Data Team (@eneemann)
• Dev Team (@steveoh)
• Cadastre Team (@rkelson)

[agrc-conductor]

conductor results for tasks - 395

check	status
@eneemann has completed 7 out of 9 tasks	⛔
@steveoh has completed 0 out of 3 tasks	⛔
jacobdadams has completed 1 out of 1 tasks	👍
@stdavis has completed 0 out of 1 tasks	⛔
@rkelson has completed 0 out of 1 tasks	⛔

[agrc-conductor]

conductor results for tasks - 395

check	status
@eneemann has completed 9 out of 14 tasks	⛔
@steveoh has completed 2 out of 7 tasks	⛔
jacobdadams has completed 1 out of 1 tasks	👍
@stdavis has completed 0 out of 1 tasks	⛔
rkelson has completed 1 out of 1 tasks	👍

[agrc-conductor]

conductor results for WATER.DDWIrrigatedCropConsumptiveUseZones

check	status
internal sgid	⛔
meta table	👍
SGID Index	⛔ Did not find WATER.DDWIrrigatedCropConsumptiveUseZones in the worksheet

[agrc-conductor]

conductor results for tasks - 395

check	status
eneemann has completed 14 out of 14 tasks	👍
@steveoh has completed 2 out of 7 tasks	⛔
jacobdadams has completed 1 out of 1 tasks	👍
@stdavis has completed 0 out of 1 tasks	⛔
rkelson has completed 1 out of 1 tasks	👍

[agrc-conductor]

conductor results for WATER.DDWIrrigatedCropConsumptiveUseZones

check	status
internal sgid	👍
meta table	👍
SGID Index
- porter issue link	👍

[stdavis]

@steveoh Same question about the web api code cleanup for this table as well.

[agrc-conductor]

conductor results for tasks - 395

check	status
eneemann has completed 14 out of 14 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 1 out of 1 tasks	👍

[agrc-conductor]

conductor results for WATER.DDWIrrigatedCropConsumptiveUseZones

check	status
internal sgid	👍
meta table	👍
SGID Index
- porter issue link	👍

[steveoh]

This is ready for closure. @eneemann you have the honors.

[eneemann]

Closing as completed 🎉