Add Licensed Health Care Facilities from Dept of Health

[ZachBeck]

Summary

• Proposed Readable Name: Utah Licensed Health Care Facilities
• Proposed Internal Dataset Name: SGID.HEALTH.LicensedHealthCareFacilities
• Proposed External Dataset Name: opensgid.health.licensedhealth_care_facilities
• Proposed Data Category: HEALTH
• Data Description: Licensed health care facilities in Utah
• Source Agency/Entity: Health
• Contact: None
• Update Frequency: Yearly

This will replace the existing, soon to be deprecated SGID.HEALTH.HealthCareFacilities. This data has been geocoded from licensed health providers and will have the same source as the current HealthCareFacilities but a different schema that will be easier to maintain.

The data should be available in

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

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

The data is of high quality

• Sweeper checks have run and passed (@ZachBeck 2024/07/02)
• The minimum requirements for metadata are populated (@ZachBeck 2024/07/02)
• The data complies with our domain rules (@ZachBeck 2024/07/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 2024/07/02)
• [ ] Configure forklift for Farm from AGOL (name, completed: 2022/00/00)
• Update relevant gis.utah.gov data pages (@ZachBeck, completed: 2022/00/00)
• Add a Stewardship record (@ZachBeck 2024/07/02)
• Complete a SGID.META.AGOLItems record (@ZachBeck 2024/07/02)
• [ ] Complete an AGOLItems_shelved record for any static or shelved item (name, completed: 2022/00/00)
• 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/07/08)
• ArcGIS Online via forklift (@stdavis on 2022/07/08)
• Auditor ran successfully (@jacobdadams on 2024/07/04)
• Open Data (@ZachBeck on 2024/07/08)
• gis.utah.gov data pages (@steveoh on 2024/07/08)
• sgid-index (@steveoh on 2024/00/00)

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]

It seems a little odd to me to use the same table name in the deprecation and addition since any existing references will still be correct but the schema will be completely incompatible. I'm not sure what the best advice is on the naming since the current name is ideal but it should change.

[ZachBeck]

Definitely not ideal but we have done it in the past with Soils. I haven't been able to dream up a name that's more descriptive than HealthCareFacilities.

[steveoh]

We had a similar conversion with soils and the situation was a little different. This is worth a group discussion to come up with a consistent path forward for this occurrence and all future ones.

[ZachBeck]

I added a discussion item in tomorrow's team meeting.

[ZachBeck]

@steveoh do we have any metrics on open-sgid tracking what gets used and how often? In deprecation/addition cases where the schema changes but the name stays the same we decided to add _deprecated to the feature class name as part of the soft delete process.

[steveoh]

do we have any metrics on open-sgid tracking what gets used and how often?

We sorta do but no there isn't. Everyone has access to view all the data available for the cloudsql instance. To read between the lines, there should be a consistent process independent of popularity.

In deprecation/addition cases where the schema changes but the name stays the same we decided to add _deprecated to the feature class name as part of the soft delete process.

I thought the soft delete unshared the item/deleted the table? What does renaming the table accomplish differently? Would that only work for open data/arcgis online?

The open sgid connection will break during the soft delete, like it normally would, and will look correct after the same table name is added again. How does _deprecated address this issue?

Any api search requests or open sgid layer in a project that goes unnoticed, and let's be honest, our reach for these deprecations is not great, will query the same table the entire time. The error message in the api will change from this table doesn't exist, which is correct, to this attribute doesn't exist on this table, which is confusing. I'm not sure what pro/map/qgis/etc would do. This seems like a poor solution that I can't support since it doesn't cover all of the sgid.

Suffixing the table with v2 seems like a better alternative. Or keeping the original schema and adding the new columns to not create a breaking change is an option. I really don't think there should ever be a deprecation and addition with the same name. It's not consistent enough.

[ZachBeck]

I think a deprecation/addition with the same name, though not ideal, is a fact of life. To me having intuitive naming conventions that make sense is better in the long run and make up for whatever short term disruption that a user experiences.

Adding _deprecated to the name in open-sgid is a way of letting the user realize that there has been a change in the data and discover the new version when they repair the link. Not ideal, but at least they are presented with the new vs old feature class.

I think appending new fields on to the existing schema isn't a viable solution. That leaves us either trying to maintain fields that no longer exist in the stewards data or having columns in the table that only have null values.

It sounds like this needs to be discussed at the next dev/data meeting.

[agrc-conductor]

conductor results for tasks - 257

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

[nathankota]

the strategy

[agrc-conductor]

conductor results for tasks - 257

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

[agrc-conductor]

conductor results for tasks - 257

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

[agrc-conductor]

conductor results for tasks - 257

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

[agrc-conductor]

conductor results for tasks - 257

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

[steveoh]

Adding blocked since work hasn't started on this yet.

[ZachBeck]

Waiting on updated facilities from Health.

[agrc-conductor]

conductor results for tasks - 257

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

[brigsz]

This does not yet have a record series, I will find out how to create one

[agrc-conductor]

conductor results for tasks - 257

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

[agrc-conductor]

conductor results for tasks - 257

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

[agrc-conductor]

conductor results for tasks - 257

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

[agrc-conductor]

conductor results for tasks - 257

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