genophenoenvo / terraref-datasets

Repository for code and small datasets derived from the TERRA REF program
MIT License
0 stars 3 forks source link

Create list of all cultivars across MAC Seasons 4 and 6 & KSU Data #54

Closed MagicMilly closed 4 years ago

MagicMilly commented 4 years ago

Additionally, identify duplicate cultivars and remove underscores from cultivar names if needed.

dlebauer commented 4 years ago

create script that uses function in https://github.com/PecanProject/bety/issues/185#issuecomment-71534163 to remove duplicates, e.g. functions like:

update_refs_from_to('cultivars', 
   select id from cultivars where name = 'PI_foobar', 
   select id from cultivars where name = 'PIfoobar')
MagicMilly commented 4 years ago

Have shared simple cultivar lists in the group's google drive and notified Arun and Ishita on Slack. They are going to review it and most likely ask for more specific queries (i.e. cultivars available in all seasons, all cultivars associated with certain traits).