search

VEuPathDB / EdaLoadingIssues

0 stars 0 forks source link

PopBio - separate Study Institution variable into Institution and Tag variables #88

Closed bobular closed 10 months ago

bobular commented 10 months ago
  1. make new study "Tags" variable in popbio.owl
  2. add new empty column in EDA.ATTRIBUTES_VBP_MEGASTUDY
  3. move some values over into new column with one-off SQL, e.g. UPDATE .. SET institution_col="", tag_col="CSIRO-supported curation" WHERE institution_col="Commonwealth Scientific and Industrial Research Organisation" (will be single-valued to start with)
  4. regenerate vocabularies for both variables in EDA.ATTRIBUTEGRAPH_VBP_MEGASTUDY
  5. anything else?

Actually this might just require a regeneration of the megastudy after the popbio.yaml file is reorganised (step 1 still needed)

bobular commented 10 months ago

This was actually without SQL hacks, see https://github.com/VEuPathDB/ApiCommonData/pull/36