DPU - Public Utilities map and data rebuild

[nathankota]

Benefit

• Critically needed data updates for several layers
• Migrate from AGOL Web AppBuilder app, which will no longer be supported by Esri after July 1, 2024

Acceptance Criteria

• Updated data sets for
  • Rural telecom
  • Natural gas service areas (approximate)
  • Electric service areas
• Instant App, ExB or similar to replace the features and functionality of the Utah Public Utilities app

[nathankota]

Q2 Sprint 1 Tasks

• [x] Meet with DPU to check on data acquisition progress
• ~[ ] Compare URTA data from Feb. 2022 with the current URTA web map, and the UGRC Rural Telecom Boundaries~
  • URTA data contact is Jim Nelson (jnelson@mscon.com, 435.623.8601)from Mid-States Consultants, Inc.
• [x] Explore Arcade intersect functionality

[ZachBeck]

Arcade intersect operation will work with polygons for popups. The size of the intersecting features should be a consideration (i.e. returning a list of culinary water service areas for a county can result in a huge list).

[nathankota]

Q2 Sprint 2

• [ ] ~Use URTA data and FCC study area boundaries to build a new Utah Telecom Boundaries data set to replace Rural Telecom Boundaries~
• [ ] Continue to work on obtaining electrical and natural gas service areas
• [ ] Check spam folder for electric co-op data request responses

[nathankota]

Q2 Sprint 2 Notes

October 17

• Sent PacifiCorp GIS data request (cc'd Jana Saba)

  October 23

• PacifiCorp data received and placed in this g-drive folder
• Individually messaged each co-op contact to see if they will provide a service area data update.

  October 24

• Electrical co-op responses are being tracked on the sheet, which include some attribute changes, and data are being added to the g-drive folder.
• Dinged Jimmy again about municipalities and Dominion Energy gas service area data.
• Jimmy confirmed that the current Dominion Energy service area is correct.

  October 30

• @ZachBeck has begun aggregating electrical service providers (co-op) data from G:
• Received the last co-op provider data (Raft River Electric)

[nathankota]

Q2 Sprint 3

• [x] Use URTA data and FCC study area boundaries to build a new Utah Telecom Boundaries data set to replace Rural Telecom Boundaries
• [x] Continue aggregating electrical co-op service provider boundaries
• [x] Continue to work on obtaining electrical and natural gas service areas
  • UMPA & UAMPS

[nathankota]

Q2 Sprint 3 Notes

The natural gas municipal system managers were harder to get in touch with. Zach reached out to the UMPA group. Still waiting for a response from Mike Squires about the UAMPS members.

[nathankota]

Q2 Sprint 4

• Continue rural telecom data set
• Follow-up on natural gas areas, and other pending electrical contacts

[nathankota]

Q2 Sprint 5

• [ ] Finish telecom data set
  • [x] Porter issues to deprecate rural telecom and introduce Utah telecom
  • [x] Create calendar reminder to check on FCC data in one year
• [ ] Natural gas: final follow-up with Hildale, Nephi
• [ ] Electrical: final follow-up on pending contacts
• [ ] Finish up map/app and send to Ron and Chris at DPU

NOTE:

• Contacted Mike Squires from UAMPS twice. The second time was a final outreach telling him we'll keep what we have, and let us know if UAMPS members want to update their data in the future.

[nathankota]

Q3 Sprint 1 Tasks

• [x] Send app for DPU feedback
• [x] Update UTILITIES.ElectricServicesAreas
• [x] Finish Telecom Porter issues

[nathankota]

Q3 Sprint 1 Notes

• 2024/01/08 - Sent new app to Chris and Ron for testing and feedback

[nathankota]

Q3 Sprint 2 Notes

• Zach organized the feedback on this doc
• We responded to each question/comment and sent it back to DPU for further clarification and direction.
• Zach is going to try to make some changes to the app to resolve the Link to utility website from county/municipality lists. request.

[ZachBeck]

Q3 Sprint 3 Notes

• Update electrical service providers in internal.
• Waiting for a response to the feedback doc.
• Still trying to figure out a way to link to websites from county/municipality utility lists.

[ZachBeck]

New url without 'template' https://experience.arcgis.com/experience/e9c56c0135084f47920317704b0d3d2c

[ZachBeck]

Considered done unless issues found by DPU

[ZachBeck]

Q3 Sprint 4

• [x] Decommission old DPU app
  • https://github.com/agrc/porter/issues/294