Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update metadata files for 2.0 release #75

Open
mradamcox opened this issue Oct 2, 2023 · 6 comments
Open

Update metadata files for 2.0 release #75

mradamcox opened this issue Oct 2, 2023 · 6 comments

Comments

@mradamcox
Copy link
Collaborator

mradamcox commented Oct 2, 2023

We discussed how to approach the metadata update that is needed now that a lot of files structures and dictionaries have changed. The approach we agreed upon has two parts which are described below. Note: the new data dictionaries are in XSLX format, and can be found here: https://github.com/GeoDaCenter/opioid-policy-scan/tree/main/data_final/dictionaries. These will be helpful references for step 1 and in step 2 they will need to be updated. (These steps are more suggestion for how to go about the process, not required workflow).

This only concerns all non-geography markdown metadata files.

1 . Update all existing metadata markdown files.

The files here: https://github.com/GeoDaCenter/opioid-policy-scan/tree/main/data_final/metadata from v1 are still very much relevant after the reorganization, but they need to be updated in the following ways:

  • Update variable names where necessary
  • Update Themes where necessary
    • Match to values in the data dictionaries
    • Edit: On further inspection, these themes are handled elsewhere, outside of the markdown files. So this step will be handled in a different ticket.
  • Update author/modified like so:
    Author: <original author>
    Last Modified: <new date>
    Last Modified By: <updater>
    

2. Add Metadata Location column to the new Data Dictionaries

A new Metadata Location column will be added to each of the new XLSX data dictionaries, with a URL pointing to the GitHub-hosted location of the corresponding Markdown file for each variable row. These should be the "raw" urls referencing the main branch (we'll update to the 2.0 tag later, just before creating that release). For example:

https://raw.githubusercontent.com/GeoDaCenter/opioid-policy-scan/main/data_final/metadata/Access_FQHCs_MinDistance.md

This will also offer a good QA/QC opportunity for whether we are missing markdown files: each row must have a value for Metadata Location.

@mradamcox
Copy link
Collaborator Author

@wam0 Has noted some variables that we need to take a closer look at:

See note in #76

See swapped minute times here:
image

@mradamcox
Copy link
Collaborator Author

see also #103

@mradamcox
Copy link
Collaborator Author

see also: #117
see also: #111

@wam0
Copy link
Contributor

wam0 commented Jan 3, 2024

Here is the comment on how to update the theme.
The following part is added after the editor's information.

### Theme: 
<theme of the data>  

@wam0
Copy link
Contributor

wam0 commented Jan 24, 2024

In State scale data, the following two variables are not Pascal Case. It might need to be modified.
blkHcv
nonBlkHcv

@wam0
Copy link
Contributor

wam0 commented Jan 24, 2024

"Historical_Methadone_point.md" needs to be updated.
https://github.com/GeoDaCenter/opioid-policy-scan/blob/main/data_final/metadata/Historical_Methadone_point.md

The locational data in 1984 can be added.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants