Add Utah Telecom Boundaries from URTA and FCC

[ZachBeck]

Summary

• Proposed Readable Name: Utah Telecom Boundaries
• Proposed Internal Dataset Name: SGID.UTILITIES.TelecomBoundaries
• Proposed External Dataset Name: opensgid.utilities.telecom_boundaries
• Proposed Data Category: Utilities
• Data Description: Urban and rural telecom boundaries of Utah
• Source Agency/Entity: URTA / FCC
• Contact: Jim Nelson [email protected]
• Update Frequency: As needed

This data is current and will replace outdated UTILITIES.RuralTelecomBoundaries once they have been shelved

The data should be available in

1 Check [x] all the areas where you expect the data to show up.

• Internal SGID
• Open SGID
• ArcGIS Online
• Open Data

The data is of high quality

• Sweeper checks have run and passed (@ZachBeck on 2024/01/02)
• The minimum requirements for metadata are populated (@ZachBeck on 2024/01/02)
• The data complies with our domain rules (@ZachBeck on 2024/01/02)

Where is the data source

Choose one.

• Internal SGID
• Farm from AGOL (agol item url)

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.

• Add data to the Internal SGID (@ZachBeck , completed: 2024/01/02)
• [ ] Configure forklift for Farm from AGOL (name, completed: 2023/00/00)
• Update relevant gis.utah.gov data pages (@ZachBeck , completed: 2024/01/25)
• Add a Stewardship record (@ZachBeck, completed: 2024/01/02)
• Complete a SGID.META.AGOLItems record (@ZachBeck, completed: 2024/01/02)
  • AGOL_ITEM_ID will be populated by Forklift after it publishes the new AGOL item.
• Complete an AGOLItems_shelved record for any static or shelved item (@ZachBeck, completed: 2024/01/29)
  - [ ] Define a record set with archives (@brigsz, completed: 2023/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.

• Open SGID via cloudb (@steveoh on 2024/01/22)
• ArcGIS Online via forklift (@stdavis on 2024/01/08)
• Auditor ran successfully (@jacobdadams on 2024/01/05)
• Open Data (@ZachBeck on 2023/01/08)
• gis.utah.gov data pages (@ZachBeck on 2024/01/25)
• sgid-index (@steveoh on 2024/01/22)

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)

[steveoh]

Not having an update schedule and steward contact seems a bit problematic don't we think?

[ZachBeck]

Not really. It's a mash up of data from the URTA and FCC so there is no steward and the boundaries don't change very often so I don't think that it needs to be put on a schedule.

[nathankota]

Possible "stewards":
URTA:

FCC:
https://www.fcc.gov/reports-research/maps/study-area-boundaries/

[nathankota]

...the boundaries don't change very often so I don't think that it needs to be put on a schedule.

perhaps we look at the FCC posted date and check-in with URTA annually

[steveoh]

It's a mash up of data from the URTA and FCC so there is no steward

It would be ideal to have a contact from each of those places for the data they are providing that is getting mashed up.

...the boundaries don't change very often so I don't think that it needs to be put on a schedule.

I like the idea of checking the FCC date and URTA annually. As needed seems like a catch all that is ignored. It doesn't fit into the grading process greg has been working on to validate that data is still of high quality.

[agrc-conductor]

conductor results for tasks - 281

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

[gregbunce]

I believe sweeper will run on this layer once it's added to Internal. correct me if i'm wrong.

[steveoh]

It was my understanding that you run it and fix the issues prior to adding it to internal.

[agrc-conductor]

conductor results for tasks - 281

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

[agrc-conductor]

conductor results for tasks - 281

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

[agrc-conductor]

conductor results for tasks - 281

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

[agrc-conductor]

conductor results for tasks - 281

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

[agrc-conductor]

conductor results for UTILITIES.TelecomBoundaries

check	status
internal sgid	👍
meta table
- item id	👍
- item name	👍
- geometry type	👍
open sgid	👍
open data	👍
arcgis online	👍
stewardship
- Description	👍
- Data Source	👍
- Website URL	👍
- Endpoint	👍
- Data Type	👍

[agrc-conductor]

conductor results for tasks - 281

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

[agrc-conductor]

conductor results for UTILITIES.TelecomBoundaries

check	status
internal sgid	👍
meta table
- item id	👍
- item name	👍
- geometry type	👍
open sgid	👍
open data	👍
arcgis online	👍
stewardship
- Description	👍
- Data Source	👍
- Website URL	👍
- Endpoint	👍
- Data Type	👍

[agrc-conductor]

conductor results for tasks - 281

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

[agrc-conductor]

conductor results for UTILITIES.TelecomBoundaries

check	status
internal sgid	👍
meta table
- item id	👍
- item name	👍
- geometry type	👍
open sgid	👍
open data	👍
arcgis online	👍
stewardship
- Description	👍
- Data Source	👍
- Website URL	👍
- Endpoint	👍
- Data Type	👍

[ZachBeck]

Done