Add Census Urban Areas 2020 from Census Bureau

[jacobdadams]

Summary

• Proposed Readable Name: Utah Urban Areas Census 2020
• Proposed Internal Dataset Name: UrbanAreasCensus2020
• Proposed External Dataset Name: urban_areas_census_2020
• Proposed Data Category: Demographic
• Data Description: Updated census Urban Areas for 2020
• Source Agency/Entity: US Census Bureau
• Contact: N/A
• Update Frequency: Decennially

Updated Census urban areas dataset from the 2020 census.

The data should be available in

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

• [x] Internal SGID
• [x] Open SGID
• [x] ArcGIS Online
• [x] Open Data

The data is of high quality

• [x] Sweeper checks have run and passed (@jacobdadams on 2023/06/05)
• [x] The minimum requirements for metadata are populated (@jacobdadams on 2023/07/06)
• [x] The data complies with our domain rules (@jacobdadams on 2023/07/06)

Where is the data source

Choose one.

• [x] 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.

• [x] Add data to the Internal SGID (@jacobdadams, completed: 2023/07/06)
• ~[ ] Configure forklift for Farm from AGOL (name, completed: 2022/00/00)~
• [x] Update relevant gis.utah.gov data pages (@jacobdadams, completed: 2023/07/14)
• [x] Add a Stewardship record (@jacobdadams, completed: 2023/07/12)
• [x] Complete a SGID.META.AGOLItems record (@jacobdadams, completed: 2023/07/06)
• ~[ ] Complete an AGOLItems_shelved record for any static or shelved item (name, completed: 2022/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.

• [ ] Open SGID via cloudb (@steveoh on 2022/00/00)
• [x] ArcGIS Online via forklift (@jacobdadams on 2023/07/12)
• [x] Auditor ran successfully (@jacobdadams on 2023/7/12)
• [x] Open Data (@jacobdadams on 2023/07/12)
• [x] gis.utah.gov data pages (@jacobdadams on 2023/07/14)
• [ ] sgid-index (@steveoh on 2022/00/00)

Notification

• [x] Twitter (@steveoh)

Group Task Assignments

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

• ~[ ] Data Team (@gregbunce)~
• [x] Dev Team (@steveoh)
• ~[ ] Cadastre Team (@rkelson)~

[agrc-conductor]

conductor results for tasks - 238

check	status
@jacobdadams has completed 1 out of 10 tasks	:no_entry:
@steveoh has completed 2 out of 4 tasks	:no_entry:
@stdavis has completed 0 out of 1 tasks	:no_entry:
@gregbunce has completed 0 out of 1 tasks	:no_entry:
@rkelson has completed 0 out of 1 tasks	:no_entry:

[agrc-conductor]

conductor results for demographic.UrbanAreasCensus2020

check	status
internal sgid	:no_entry:
meta table
- item id	:no_entry:
- item name	:no_entry:
- geometry type	:no_entry:
stewardship	:no_entry: Did not find demographic.UrbanAreasCensus2020 in the worksheet

[agrc-conductor]

conductor results for tasks - 238

check	status
@jacobdadams has completed 1 out of 10 tasks	:no_entry:
@steveoh has completed 2 out of 4 tasks	:no_entry:
@stdavis has completed 0 out of 1 tasks	:no_entry:
@gregbunce has completed 0 out of 1 tasks	:no_entry:
@rkelson has completed 0 out of 1 tasks	:no_entry:

[agrc-conductor]

conductor results for demographic.UrbanAreasCensus2020

check	status
internal sgid	:no_entry:
meta table
- item id	:no_entry:
- item name	:no_entry:
- geometry type	:no_entry:
stewardship	:no_entry: Did not find demographic.UrbanAreasCensus2020 in the worksheet

[agrc-conductor]

conductor results for tasks - 238

check	status
@jacobdadams has completed 1 out of 10 tasks	:no_entry:
@steveoh has completed 2 out of 4 tasks	:no_entry:
@stdavis has completed 0 out of 1 tasks	:no_entry:
@gregbunce has completed 0 out of 1 tasks	:no_entry:
@rkelson has completed 0 out of 1 tasks	:no_entry:

[agrc-conductor]

conductor results for demographic.UrbanAreasCensus2020

check	status
internal sgid	:no_entry:
meta table
- item id	:no_entry:
- item name	:no_entry:
- geometry type	:no_entry:
stewardship	:no_entry: Did not find demographic.UrbanAreasCensus2020 in the worksheet

[steveoh]

Is this blocked or waiting on something @jacobdadams?

[agrc-conductor]

conductor results for tasks - 238

check	status
@jacobdadams has completed 1 out of 10 tasks	:no_entry:
@steveoh has completed 2 out of 4 tasks	:no_entry:
@stdavis has completed 0 out of 1 tasks	:no_entry:
@gregbunce has completed 0 out of 1 tasks	:no_entry:
@rkelson has completed 0 out of 1 tasks	:no_entry:

[agrc-conductor]

conductor results for demographic.UrbanAreasCensus2020

check	status
internal sgid	:no_entry:
meta table
- item id	:no_entry:
- item name	:no_entry:
- geometry type	:no_entry:
stewardship	:no_entry: Did not find demographic.UrbanAreasCensus2020 in the worksheet

[steveoh]

Adding blocked because of @jacobdadams schedule

[jacobdadams]

Ok, I got the drain snake out and unblocked this. All the data have been loaded into internal, just waiting on the magic to happen. The stewardship page and the datapage are just waiting on itemids from the AGOL publish phase.

[stdavis]

@jacobdadams I think that you need to fix the meta table entry for this layer.

DEMOGRAPHICS -> DEMOGRAPHIC

[agrc-conductor]

conductor results for tasks - 238

check	status
@jacobdadams has completed 5 out of 10 tasks	:no_entry:
@steveoh has completed 2 out of 4 tasks	:no_entry:
@stdavis has completed 0 out of 1 tasks	:no_entry:

[agrc-conductor]

conductor results for demographic.UrbanAreasCensus2020

check	status
internal sgid	:+1:
meta table
- item id	:no_entry:
- item name	:no_entry:
- geometry type	:no_entry:
stewardship	:no_entry: Did not find demographic.UrbanAreasCensus2020 in the worksheet

[jacobdadams]

Ahah, yeah. I've got that fixed.

[jacobdadams]

The data values are wonky in AGOL. I'll check the sources this afternoon.

[jacobdadams]

Ok, I've updated the values in internal, so I'm hoping change detection grabs them and forklift/clouddb update the published data. Once it's gone out to all the places, we should be good to close this.

[steveoh]

we'll find out tomorrow. let's wait until conductor runs on monday to close it out

[jacobdadams]

Ok, the data look good in open SGID and AGOL, so we'll wait for Monday's conductor and go from there.

[agrc-conductor]

conductor results for tasks - 238

check	status
jacobdadams has completed 11 out of 11 tasks	:+1:
@steveoh has completed 2 out of 4 tasks	:no_entry:

[agrc-conductor]

conductor results for demographic.UrbanAreasCensus2020

check	status
internal sgid	:+1:
meta table
- item id	:+1:
- item name	:+1:
- geometry type	:+1:
open sgid	:+1:
open data	:+1:
arcgis online	:+1:
stewardship	:no_entry: Did not find demographic.UrbanAreasCensus2020 in the worksheet

[steveoh]

I corrected the spelling error in the stewardship sheet

[agrc-conductor]

conductor results for tasks - 238

check	status
jacobdadams has completed 11 out of 11 tasks	:+1:
@steveoh has completed 2 out of 4 tasks	:no_entry:

[agrc-conductor]

conductor results for demographic.UrbanAreasCensus2020

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

[agrc-conductor]

conductor results for tasks - 238

check	status
jacobdadams has completed 11 out of 11 tasks	:+1:
@steveoh has completed 2 out of 4 tasks	:no_entry:

[agrc-conductor]

conductor results for demographic.UrbanAreasCensus2020

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