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

Remove "Utah Retail Culinary Water Service Areas" AGOL Item #130

Closed stdavis closed 3 years ago

stdavis commented 3 years ago

Summary

A short summary of the situation.

SGID.Utilities.CulinaryWaterServiceAreas has grown stale. Water Resources (DNR) now hosts this data in AGOL and has already shared this data with our org. I propose that we remove our duplicate AGOL item and wire up forklift to farm the data from the DNR AGOL service into internal SGID.

I've compared the schemas between the DNR AGOL item and internal and the only difference is the COLOR4 field which shows up in internal but it's been all nulls for as long as @rkelson's hair. The only other difference that I could find was that the DNR AGOL item doesn't have the field aliases that we have which don't translate to open SGID anyways.

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

The migration guide is to use the DNR feature layer in arcgis online. If there was a dependency on color4 that will be a breaking change. The open sgid layer and everything else should continue to be the same except it will now be updated from the steward.

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 recommend 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.

Not that we want to shelve this data. Probably none? @jacobdadams any thoughts?

Add record to table.

~- [ ] Add record to AGOLItems_shelved table in ArcGIS Online with shelved or static in the CATEGORY field (name, completed: 2021/00/00)~

: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

Other Tasks

Notification

Group Task Assignments

  1. Check [x] the box when you have assigned all the tasks relevant to your group.
agrc-conductor commented 3 years ago

conductor results for tasks - 130

check status
@stdavis has completed 2 out of 3 tasks :no_entry:
@steveoh has completed 1 out of 2 tasks :no_entry:
@gregbunce has completed 0 out of 1 tasks :no_entry:
@rkelson has completed 0 out of 1 tasks :no_entry:
jacobdadams commented 3 years ago

Auditor has labeled this deprecated as of this morning.

agrc-conductor commented 3 years ago

conductor results for tasks - 130

check status
@gregbunce has completed 7 out of 8 tasks :no_entry:
stdavis has completed 3 out of 3 tasks :+1:
@steveoh has completed 1 out of 2 tasks :no_entry:
@rkelson has completed 0 out of 1 tasks :no_entry:
gregbunce commented 3 years ago

this data is scheduled to be deleted from agol on 5/10/2021

gregbunce commented 3 years ago

From what I can tell, this issue can now be closed. Can someone double-check me on that? A few thumbs up and I'll click the button (or feel free to do the honors).

steveoh commented 3 years ago

https://opendata.gis.utah.gov/datasets/utahDNR::culinarywaterserviceareas

steveoh commented 3 years ago

The website needs updating on https://gis.utah.gov/data/utilities/retail-culinary-water-suppliers/ and I don't see it in the sgid index which means it's missing a record.

steveoh commented 3 years ago

This should not have been marked as deprecated in the stewardship sheet since it was a replacement.

agrc-conductor commented 3 years ago

conductor results for tasks - 130

check status
gregbunce has completed 8 out of 8 tasks :+1:
stdavis has completed 3 out of 3 tasks :+1:
steveoh has completed 2 out of 2 tasks :+1:
rkelson has completed 1 out of 1 tasks :+1:
stdavis commented 2 years ago

I think that we screwed this deprecation up a little bit. I shouldn't have included this task: image

That removed the table from open sgid. I found out today because DEQ is attempting to query that table via our web API. I've added the row back into the meta table.

I also noticed that there is a version of this data in SGID called SGID.UTILITIES.RetailCulinaryWaterServiceAreas. Should that have been removed? I've verified that forklift is updating SGID.UTILITIES.CulinaryWaterServiceAreas. Can we just trash SGID.UTILITIES.RetailCulinaryWaterServiceAreas or should we open a new porter issue?

stdavis commented 2 years ago

@ZachBeck Was able to delete SGID.UTILITIES.RetailCulinaryWaterServiceAreas today so I think that everything should be wrapped up now.

steveoh commented 2 years ago

/remind me tomorrow to look for culinary water service areas in the open sgid

stdavis commented 2 years ago

Looks good. image