search

ArctosDB / arctos

Arctos is a museum collections management system
https://arctos.database.museum
60 stars 13 forks source link

migration: left gonad width #7508

Closed dustymc closed 1 week ago

dustymc commented 6 months ago

left gonad width should be migrated and removed

data

temp_lgw.csv.zip

summary


 guid_prefix | count 
-------------+-------
 MVZ:Mamm    |     1
 UNR:Mamm    |     2
 MMNH:Bird   |     4
 DMNS:Bird   |     7
 UTEP:Bird   |     1
 UWYMV:Mamm  |     1
 DMNS:Mamm   |     6
 UWBM:Mamm   |   110
 CRCM:Bird   |  5070
 OWU:Bird    |     4
 MVZ:Herp    |    62
 CHAS:Mamm   |     1
 CHAS:Teach  |     9
 APSU:Bird   |   112
 MLZ:Bird    |   218
 UMZM:Mamm   |    14
 UCM:Bird    |    49
 UMNH:Mamm   |     1
 UCSC:Mamm   |     4
 CHAS:Bird   |    39
 KSB:Mamm    |   204
 UMZM:Bird   |    36
 UMNH:Bird   |     6

contact

@ebraker @mkoo @barke042 @atrox10 @mvzhuang @cjconroy @wellerjes @jebrad @jrpletch @acdoll @jrdemboski @jessicatir @ewommack @kderieg322079 @adhornsby @droberts49

ewommack commented 6 months ago

UWYMV data is fixed

acdoll commented 5 months ago

migrated into what?

Jegelewicz commented 5 months ago

migrated into what?

gonad width with left in method.

wellerjes commented 5 months ago

Okay to migrate for CHAS collections.

jebrad commented 5 months ago

OK to migrate for UWBM:Mamm

jessicatir commented 5 months ago

CRCM:Bird left gonad width/length has been removed - will re-upload myself when the new term is available. The majority of our data were actually "side not specified" so we had to check which ones were legitimately "left."

cjconroy commented 5 months ago

MVZ mammals had only one, and I changed it to Right.

ebraker commented 5 months ago

Ok for UCM

wellerjes commented 3 months ago

CHAS specimens fixed

adhornsby commented 3 months ago

OK to migrate all MMNH and UMZM (or do you want us to do it @dustymc ?)

mkoo commented 3 months ago

Please do so for MVZ:Herp. Weirdly I dont see the MVZ:Mamm record even though it's on your query results...

jebrad commented 1 month ago

Yes, please do this for UWBM:Mamms. Thank you.

Jegelewicz commented 1 month ago

For UWBM:Mamm

  1. added gonad width attribute to UWBM:Mamm
  2. searched for all UWBM:Mamm with left gonad width attribute and used the view attribute tool to download the left gonad width attributes
  3. used the downloaded attributes to make an upload of gonad width attributes with "was left gonad width" added to attribute_method
  4. loaded new gonad width attributes
  5. used the bulk unload attribute tool to remove left gonad width attributes
  6. removed left gonad width from UWBM:Mamm

file - UWBM_Mamm gonad width change.xlsx

dustymc commented 1 week ago

merge-->https://github.com/ArctosDB/arctos/issues/7504