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

part cleanup: carcass #4368

Closed
dustymc opened this issue Feb 23, 2022 · 38 comments
Closed

part cleanup: carcass #4368

dustymc opened this issue Feb 23, 2022 · 38 comments
Assignees
Labels
CodeTableCleanup Our bad data leads to more bad data. Fix it! Denormalizer Issue is making data less-accessible Help wanted I have a question on how to use Arctos Priority - Wildfire Potential ignore this at everyone's peril, may smolder for now ...

Comments

@dustymc
Copy link
Contributor

dustymc commented Feb 23, 2022

Is the documentation for carcass correct? If so, can we update to what's suggested? If not, what is a 'carcass'?

The decaying flesh of dead animals, including human flesh. Wikipedia Consider changing to whole organism with preservation carrion


 guid_prefix | nrecs 
-------------+-------
 ACUNHC:Mamm |     1
 DMNS:Bird   |   399
 DMNS:Herp   |     5
 DMNS:Mamm   |   232
 MSB:Bird    |    55
 MSB:Herp    |     1
 MSB:Mamm    |   525
 MVZ:Bird    |    82
 MVZ:Herp    |    16
 MVZ:Mamm    |   786
 UAM:Mamm    |  1431
 UCM:Mamm    |     2
 UCSC:Mamm   |     3
 UMNH:Mamm   |     5
 UMZM:Bird   |     1
 UMZM:Mamm   |     1
 UWYMV:Bird  |     2

@ebraker
@leet1984
@mkoo
@ewommack
@campmlc
@ccicero
@kderieg322079
@catherpes,@catherpes
@amgunderson
@atrox10
@cjconroy
@jtgiermakowski
@acdoll
@jldunnum
@jrdemboski

@dustymc dustymc added Help wanted I have a question on how to use Arctos CodeTableCleanup Our bad data leads to more bad data. Fix it! labels Feb 23, 2022
@dustymc dustymc added this to the Needs Discussion milestone Feb 23, 2022
@ewommack
Copy link

The decaying flesh of dead animals, including human flesh. Wikipedia Consider changing to whole organism with preservation carrion

No that isn't what I meant for those parts at all. I was looking for something that could represent a skinned body that was then preserved in alcohol. So not a whole organism and not a body, because it is definitely missing pieces. More like most the trunk, but including most of the neck vertebrae and some of the joints. We still do not have anything that matches that type of part in the code table for birds. I'll look around and see if I can find another part that might work for the UWYMV speciemns.

@ebraker
Copy link
Contributor

ebraker commented Feb 24, 2022

I cleaned up UCM values

@adhornsby
Copy link

UMZM only has a couple affected specimens, but we're in a similar boat as Beth with "carcass" meaning skinned but otherwise whole thorax + abdomen. The best word I can think of to describe this is "trunk," which isn't an option currently.

@Jegelewicz
Copy link
Member

Jegelewicz commented Mar 7, 2022

@adhornsby @ewommack I suggest using body with the modifier postcranial

We may want to consider the addition of a new modifier "skinless"?

@acdoll
Copy link

acdoll commented Mar 7, 2022

something that could represent a skinned body that was then preserved in alcohol

That is also one of the ways we use 'carcass'. We have used it for anything that is not a 'whole organism', but has enough connected parts to make using more specific part names (e.g. wing) not appropriate either. This applies to some roadkill, but we used it a lot for animals from the airport (e.g. the back half of a fox, or the 70% of a bird that went through an engine).

@dustymc
Copy link
Contributor Author

dustymc commented Sep 13, 2022

This seems to be stuck - help??

@ewommack
Copy link

@acdoll @adhornsby - what about partial organism
the partial body of an organism, or once living physical entity; entity or being that is or was living; an individual living or once living thing, such as one animal, plant, fungus, or bacterium

And then we could use attributes for ETOH or formalin fixed, dried, stored in envelopes etc?

@kderieg322079
Copy link

Looks like 'carcass' is used for a couple of different things in UMNH:Mamm. Some are like what @ewommack mentioned where the skin is a party (probably a study skin) and then the rest of the specimen is just in alcohol. It looks like some of the specimens with 'carcass' are just whole organism skull-less and just need to be changed to that, but some seem to be skinless and skull-less, where the study skin & skull are in the dry collection and the rest of the animal just got dunked in ethanol.

I agree with @ewommack that partial organism would be good, because even 'whole organism' with condition 'skull-less' is kind of misleading since a search for whole organisms would return the ones that have had skulls removed.

Here's a question for everyone: if a skull is removed from a whole organism later, does the skull count as a subsample? I removed a bunch of skulls from whole organisms in fluid for a loan and marked the skulls as subsamples. A skull is its own part, but I sampled it from the whole organism after fixation. Example: UMNH:Mamm:35361

@Jegelewicz
Copy link
Member

if a skull is removed from a whole organism later, does the skull count as a subsample?

My answer is YES and you can have a subsample that is a different part than the part it was sampled from. So you would have part = whole organism, subsample = skull

BUT, then you should also have subsample = "partial organism" or whatever we come up with and an appropriate disposition for the whole organism.

Caveat - you could just create the part skull, but you should also create the part "partial organism" or whatever and apply an appropriate disposition to the whole organism part to indicate that it is no longer available. Pretty much accomplishes the same thing - although the "subsample" relationship makes it more clear IMO.

@ewommack
Copy link

I think having it down as a subsample sounds right. It means that the part came after the object was prepared completely before, and then at a later date we came it and took a part out of it.

@acdoll
Copy link

acdoll commented Sep 15, 2022

Just to be contradictory, then shouldn't all parts be a subsample of whole organism? If we list the skull as a part and post-cranial skeleton as a part, should the both be subsamples of a skeleton part? While Arctos has provided the capability to handle these material hierarchies, it should be up to each institution on how they choose to use it.
It should be noted that subsamples don't (always?) get passed along to the aggregators.
I am supportive of adding the term 'partial organism' and would use it for some of our 'carcass' parts. However, I still like the term carcass for our initial entry of a somewhat unknown record (might be a whole organism, might not - its in a bag in the freezer awaiting further assessment/preparation). How about:
carcass: the body (whole or partial) of a dead animal.

@dustymc
Copy link
Contributor Author

dustymc commented Sep 15, 2022

then shouldn't all parts be a subsample of whole organism?

Absolutely - that's another link in the chain of evidence, definitely a best practice. (And one which reality stomps all over, but given infinite resources....)

subsamples don't (always?) get passed along to the aggregators

Not terribly surprising, probably a relic of when were we trying to treat things with parents as disposable (which obviously isn't the whole picture) - let me know if you have an example and I'll fix it.

term 'partial organism'

Use organism plus - uhhh, something... (Condition?) (And "whole" should be in the same place, wherever that is, #4833)

I still like the term carcass

Given a useful and non-overlapping/non-arbitrary definition, I don't object to keeping it, I just don't like what we have now (which implies neglect and I don't think is accurate).

But, I think the proposed definition entirely overlaps '[whole] organism' - and '[whole] organism' seems like a decent guess/default/starting point for unchecked things in mysterious bags in freezers.

@Jegelewicz
Copy link
Member

Just to be contradictory, then shouldn't all parts be a subsample of whole organism?

Yes - but tradition. Anyway, the timing of what @kderieg322079 described lends itself to "subsampling"

it should be up to each institution on how they choose to use it.

and it totally is - someone asked for advice and we are giving it.

subsamples don't (always?) get passed along to the aggregators.

but I think they do? We pass parts in a big blob:
image

so it's hard to say

I'll be even more contradictory - we NEVER have a whole organism. An organism exists over time and gains and loses stuff as it goes - probably all of our "whole organism" parts should be carcasses or bodies.

@ewommack
Copy link

I'll be even more contradictory - we NEVER have a whole organism. An organism exists over time and gains and loses stuff as it goes - probably all of our "whole organism" parts should be carcasses or bodies.

Sigh...true. I just used whole organism -> condition mount, for a mounted rattlesnake. It made sense to me, but really it should just be the skin and rattle -> mounted. It looks whole, but all of its insides are missing.

@acdoll
Copy link

acdoll commented Sep 20, 2022

but I think they do? We pass parts in a big blob:

I've see it both ways, I definitely looked at examples where they don't (https://arctos.database.museum/guid/DMNS:Mamm:21237). Did we set that to be conditional based on the part disposition? It would make sense to push out subsample parts with disposition of 'in collection', 'being processed', or 'on exhibit'; but maybe not for the others like 'used up' or 'discarded'.

@dustymc
Copy link
Contributor Author

dustymc commented Sep 20, 2022

Thanks, that's coming from a function which returns distinct. (I believe the intent was a high-level simple view of what might be available, but there's such a convoluted history there that I'm not sure of anything.)

Back to the high-level view, I think this is just a place where WHATEVER we do, as long as it involves cramming a bunch of complex data into a text field, will be (rightly!) hated by someone. https://github.com/ArctosDB/internal/issues/168 would change that - we'd just provide the data, if GBIF wants to pretend it's a string and your license allows such things then they can.

Here's what we're currently sending:

arctosprod@arctos>> select parts from flat where guid='DMNS:Mamm:21237';
                                                 parts                                                  
--------------------------------------------------------------------------------------------------------
 baculum; ectoparasite (ethanol); heart, kidney, muscle (frozen); liver (frozen); skeleton; skin, study

The alternative is...


arctosprod@arctos>> select partdetail from flat where guid='DMNS:Mamm:21237';


[
  {
    "id": 29539220,
    "sf": null,
    "pn": "skin, study",
    "cd": "very good",
    "lc": 1,
    "dp": "in collection",
    "rk": null,
    "bc": null,
    "cp": null,
    "pa": null
  },
  {
    "id": 29539222,
    "sf": null,
    "pn": "baculum",
    "cd": "very good",
    "lc": 1,
    "dp": "in collection",
    "rk": null,
    "bc": null,
    "cp": null,
    "pa": null
  },
  {
    "id": 29539219,
    "sf": null,
    "pn": "ectoparasite",
    "cd": "very good",
    "lc": 1,
    "dp": "in collection",
    "rk": "mites",
    "bc": null,
    "cp": null,
    "pa": [
      {
        "at": "preservation",
        "av": "ethanol",
        "au": null,
        "dd": "2021-07-01",
        "dr": null,
        "ar": "Added from original part ectoparasite (ethanol).",
        "dm": null
      }
    ]
  },
  {
    "id": 29539217,
    "sf": null,
    "pn": "liver",
    "cd": "very good",
    "lc": 1,
    "dp": "in collection",
    "rk": null,
    "bc": "DMNSZT4EBVY",
    "cp": "[ DMNSZT4EBVY ] DMNS-ZT-4EBVY (cryovial)",
    "pa": [
      {
        "at": "preservation",
        "av": "frozen",
        "au": null,
        "dd": "2021-07-01",
        "dr": null,
        "ar": "Added from original part liver (frozen).",
        "dm": null
      }
    ]
  },
  {
    "id": 29539218,
    "sf": null,
    "pn": "heart, kidney, muscle",
    "cd": "very good",
    "lc": 1,
    "dp": "in collection",
    "rk": null,
    "bc": "DMNSZT0XBB3",
    "cp": "[ DMNSZT0XBB3 ] DMNS-ZT-0XBB3 (cryovial)",
    "pa": [
      {
        "at": "preservation",
        "av": "frozen",
        "au": null,
        "dd": "2021-07-01",
        "dr": null,
        "ar": "Added from original part heart, kidney, muscle (frozen).",
        "dm": null
      }
    ]
  },
  {
    "id": 29794841,
    "sf": 29539218,
    "pn": "heart, kidney, muscle",
    "cd": "very good",
    "lc": 1,
    "dp": "subsampled",
    "rk": null,
    "bc": null,
    "cp": null,
    "pa": [
      {
        "at": "preservation",
        "av": "frozen",
        "au": null,
        "dd": "2021-07-01",
        "dr": null,
        "ar": "Added from original part heart, kidney, muscle (frozen).",
        "dm": null
      }
    ]
  },
  {
    "id": 29539221,
    "sf": null,
    "pn": "skeleton",
    "cd": "partial; very good",
    "lc": 1,
    "dp": "in collection",
    "rk": "Original part name: skeleton, partial",
    "bc": null,
    "cp": null,
    "pa": null
  }
]

I can switch things around (again, probably) but as above I'd expect someone to hate it, whatever I do.

See also #4688 - your disposition doesn't tell me anything (I can already see it's subsampled, it has a parent!) and the cleanup seems to be stuck. Any help in unsticking would be greatly appreciated....

@Jegelewicz
Copy link
Member

I think we should leave things as they are. I am hoping that in the very near future we can upgrade our data at GBIF using their new model.

@acdoll
Copy link

acdoll commented Sep 21, 2022

your disposition doesn't tell me anything

It tells you (kind of) if it is available for use. I agree to leave this (what gets pushed) as it is for now.

@dustymc
Copy link
Contributor Author

dustymc commented Sep 21, 2022

I suppose there's some argument that the only people who need to understand disposition is the people who can go dig the thing out of the collection, at least if they're willing to deal with requests for things that can't be loaned and etc.

A fair number of Arctos users would assume "... and given away for consumptive use" because that's how subsampling was used at some point.

I'm not sure why a naive user wouldn't assume you then launched it into the sun; that looks like a (not great description of a) process, not a disposition, from here.....

@dustymc dustymc added Priority - Wildfire Potential ignore this at everyone's peril, may smolder for now ... Denormalizer Issue is making data less-accessible labels May 18, 2023
@Jegelewicz
Copy link
Member

@Jegelewicz Jegelewicz self-assigned this Jul 20, 2023
@Jegelewicz
Copy link
Member

I was going to create separate forms for each since there might be different sets of users...does that make sense or should they all be in one survey?

@dustymc
Copy link
Contributor Author

dustymc commented Jul 20, 2023

I think one - I suspect people use those interchangeably (or various people use various terms to means the same thing, or...) - being forced into the context of each other seems critical.

@Jegelewicz
Copy link
Member

OK - how's this? https://docs.google.com/forms/d/e/1FAIpQLSfhJdLaJ2IH9J65B2nST3fYfdxPhLGUxQB7uJhgo-nkN20wmQ/viewform?usp=sf_link

@ccicero
Copy link

ccicero commented Jul 20, 2023

+1

@Jegelewicz
Copy link
Member

Well - since EVERYBODY uses whole organism - does this go out to the AWG?

@dustymc
Copy link
Contributor Author

dustymc commented Jul 20, 2023

EVERYBODY

drop table temp_surelynot;
create table temp_surelynot as 
select
    collection.guid_prefix,
    wo.c as whole_organism_count,
    b.c as body_count,
    c.c as carcass_count
from
    collection
    left outer join (
        select 
            cataloged_item.collection_id,
            count(*) c 
        from 
            cataloged_item 
            inner join specimen_part on cataloged_item.collection_object_id=specimen_part.derived_from_cat_item
        where specimen_part.part_name='whole organism'
        group by 
            cataloged_item.collection_id
    ) wo on collection.collection_id=wo.collection_id
    left outer join (
        select 
            cataloged_item.collection_id,
            count(*) c 
        from 
            cataloged_item 
            inner join specimen_part on cataloged_item.collection_object_id=specimen_part.derived_from_cat_item
        where specimen_part.part_name='body'
        group by 
            cataloged_item.collection_id
    ) b on collection.collection_id=b.collection_id
    left outer join (
        select 
            cataloged_item.collection_id,
            count(*) c 
        from 
            cataloged_item 
            inner join specimen_part on cataloged_item.collection_object_id=specimen_part.derived_from_cat_item
        where specimen_part.part_name='carcass'
        group by 
            cataloged_item.collection_id
    ) c on collection.collection_id=c.collection_id
;
    guid_prefix    | whole_organism_count | body_count | carcass_count 
-------------------+----------------------+------------+---------------
 UAM:Mamm          |                19752 |         13 |          1431
 UAM:Bird          |                  889 |            |              
 UAM:Herp          |                  491 |            |              
 UAM:Ento          |               395019 |            |              
 UAM:Herb          |               201887 |            |              
 NBSB:Bird         |                      |            |              
 UAM:Fish          |                 9694 |            |              
 UAM:Inv           |                20304 |            |              
 KWP:Ento          |                64843 |            |              
 UAMObs:Mamm       |                      |            |              
 MSB:Mamm          |                78574 |         16 |           530
 DGR:Ento          |                      |            |              
 DGR:Bird          |                      |            |              
 DGR:Mamm          |                    4 |            |              
 MSB:Herp          |                85139 |         16 |             1
 MSB:Fish          |               119648 |            |              
 MSB:Bird          |                  291 |          7 |            55
 UAM:ES            |                    1 |            |              
 WNMU:Bird         |                      |            |              
 WNMU:Fish         |                  379 |            |              
 WNMU:Mamm         |                   12 |            |              
 PSU:Mamm          |                      |            |              
 MSB:Para          |                33946 |            |              
 MVZ:Mamm          |                21379 |        898 |           787
 MVZ:Bird          |                 3426 |          6 |            83
 MVZ:Herp          |               279720 |          6 |            16
 MVZ:Egg           |                      |            |              
 MVZ:Hild          |                   28 |            |              
 MVZObs:Bird       |                      |            |              
 MVZObs:Herp       |                      |            |              
 MVZObs:Mamm       |                      |            |              
 UAM:Art           |                      |            |              
 UAMb:Herb         |                62498 |            |              
 MSBObs:Mamm       |                      |            |              
 UAMObs:Fish       |                    4 |            |              
 DMNS:Bird         |                 7463 |       2775 |           100
 UWBM:Herp         |                10170 |            |              
 DMNS:Mamm         |                 4382 |        468 |           227
 KNWR:Ento         |                 8811 |            |              
 KNWR:Herb         |                 2466 |            |              
 HWML:Para         |               107954 |            |              
 MSB:Host          |                 2774 |            |              
 UAMObs:Ento       |                12518 |            |              
 UWYMV:Bird        |                    1 |            |             2
 UWYMV:Mamm        |                    9 |          7 |              
 MLZ:Bird          |                  300 |            |              
 MLZ:Mamm          |                   30 |            |              
 USNPC:Para        |                  814 |            |              
 UWYMV:Herp        |                  447 |            |              
 NMU:Mamm          |                      |          2 |              
 MVZObs:Fish       |                      |            |              
 COA:Mamm          |                      |            |              
 COA:Bird          |                      |            |              
 COA:Ento          |                      |            |              
 COA:Herp          |                      |            |              
 COA:Rept          |                      |            |              
 COA:Egg           |                      |            |              
 UMNH:Mamm         |                 7617 |         80 |             5
 UMNH:Bird         |                   90 |            |              
 UMNH:Herp         |                18978 |            |              
 UMNH:Ento         |                      |            |              
 UMNH:Mala         |                      |            |              
 DMNS:Egg          |                      |            |              
 DMNS:Inv          |                  374 |            |              
 UAM:Arc           |                      |            |              
 UAM:EH            |                      |            |              
 NMU:Herb          |                   42 |            |              
 NMU:Bird          |                      |            |              
 NMU:Ento          |                      |            |              
 NMU:Fish          |                      |            |              
 UAMObs:EH         |                      |            |              
 UAMObs:Bird       |                      |            |              
 UNR:Mamm          |                      |            |              
 UNR:Bird          |                      |            |              
 UNR:Herp          |                 4200 |            |              
 UNR:Fish          |                 3738 |            |              
 UCM:Mamm          |                 1944 |          6 |              
 UCM:Bird          |                   11 |            |              
 UCM:Herp          |                67792 |         24 |              
 UCM:Fish          |                 2253 |            |              
 MLZ:Egg           |                      |            |              
 UCM:Obs           |                      |            |              
 UCM:Egg           |                      |            |              
 DMNS:Herp         |                  227 |            |             5
 UAM:Alg           |                 4640 |            |              
 UNR:Egg           |                      |            |              
 UWYMV:Fish        |                 2000 |            |              
 CHAS:Mamm         |                  325 |            |              
 CHAS:Bird         |                  305 |            |              
 CHAS:Egg          |                      |            |              
 UTEP:Bird         |                   16 |            |              
 UTEP:Ento         |                27453 |            |              
 UTEP:ES           |                    9 |            |              
 UTEP:Fish         |                  243 |            |              
 UTEP:Herb         |                84282 |            |              
 UTEP:Herp         |                21874 |          1 |              
 UTEP:Inv          |                   48 |            |              
 UTEP:Mamm         |                  538 |          2 |              
 CHAS:Herb         |                11687 |            |              
 CHAS:Fish         |                   50 |            |              
 DMNS:Para         |                 1201 |            |              
 UWBM:Mamm         |                  915 |          9 |              
 UTEP:HerpOS       |                    3 |            |              
 CHAS:Ento         |                27832 |            |              
 CHAS:Inv          |                16432 |            |              
 CHAS:EH           |                      |            |              
 UTEPObs:Herp      |                    1 |            |              
 UTEPObs:Ento      |                      |            |              
 UTEP:Zoo          |                  277 |            |              
 UTEP:Arc          |                      |            |              
 KNWR:Inv          |                  131 |            |              
 CHAS:Teach        |                 1453 |            |              
 UTEP:Teach        |                  175 |            |              
 NMU:Herp          |                   17 |            |              
 UNM:Paleo         |                      |            |              
 APSU:Herp         |                17189 |            |              
 APSU:Bird         |                   19 |            |              
 APSU:Fish         |                 6183 |            |              
 APSU:Mamm         |                      |            |              
 UAM:Env           |                      |            |              
 CHAS:Herp         |                21006 |            |              
 CHAS:ES           |                      |            |              
 ALMNH:ES          |                      |            |              
 ASNHC:Mamm        |                 2601 |         26 |              
 ASNHC:Herb        |                      |            |              
 UMZM:Bird         |                   15 |            |              
 UMZM:Mamm         |                   38 |         30 |              
 STAR:Alg          |                      |            |              
 ASUMZ:Mamm        |                      |            |              
 ASUMZ:Ento        |                 4647 |            |              
 ASUMZ:Herp        |                      |            |              
 ASUMZ:Bird        |                      |            |              
 ASUMZ:Fish        |                 2988 |            |              
 ASUMZ:Bivalve     |                 4985 |            |              
 STAR:Herb         |                      |            |              
 ASUMZ:Invert      |                29020 |            |              
 KNWRObs:Mamm      |                      |            |              
 KNWRObs:Herb      |                      |            |              
 KNWRObs:Fish      |                    8 |            |              
 OWU:Amph          |                   97 |            |              
 OWU:Bird          |                      |         27 |              
 OWU:EH            |                      |            |              
 OWU:ES            |                    1 |            |              
 OWU:Ento          |                      |            |              
 OWU:Fish          |                   69 |            |              
 OWU:Geol          |                      |            |              
 OWU:Herb          |                      |            |              
 OWU:Inv           |                   25 |            |              
 OWU:Mamm          |                    6 |            |              
 OWU:Para          |                    5 |            |              
 OWU:Rept          |                  327 |            |              
 UCSC:Bird         |                      |         50 |              
 UCSC:Fish         |                      |            |              
 UCSC:Herp         |                  746 |            |              
 UCSC:Mamm         |                      |            |             3
 NMU:Para          |                 1075 |            |              
 MLZ:Herb          |                  298 |            |              
 NMMNH:Bird        |                      |            |              
 NMMNH:Ento        |                 8110 |            |              
 NMMNH:Fish        |                      |            |              
 NMMNH:Geol        |                      |            |              
 NMMNH:Herb        |                 3380 |            |              
 NMMNH:Herp        |                   34 |            |              
 NMMNH:Inv         |                   59 |            |              
 NMMNH:Mamm        |                  226 |            |              
 NMMNH:Paleo       |                  185 |            |              
 UWYMV:Egg         |                      |            |              
 UMNH:Teach        |                      |            |              
 UMNHObs:Mamm      |                      |            |              
 BYU:Herp          |                20063 |            |              
 MVZ:Fish          |                  791 |            |              
 MLZ:Fish          |                 6206 |            |              
 ALMNH:Inv         |                 6322 |            |              
 ALMNH:Arc         |                      |            |              
 ALMNH:Ento        |                      |            |              
 ALMNH:EH          |                      |            |              
 KNWRObs:Bird      |                      |            |              
 ALMNH:Bird        |                      |            |              
 ALMNH:Herp        |                      |            |              
 ALMNH:Mamm        |                   13 |            |              
 JSNM:Egg          |                      |            |              
 JSNM:Paleo        |                      |            |              
 ASNHC:Bird        |                    6 |        152 |              
 ASNHC:Herp        |                19125 |          4 |              
 ASNHC:Para        |                      |            |              
 BYU:Mamm          |                      |            |              
 BYU:Bird          |                      |            |              
 BYU:Fish          |                65963 |            |              
 LINGU:Herp        |                  873 |            |              
 KNWR:Env          |                      |            |              
 UA:Paleo          |                      |            |              
 UCONN:Bird        |                      |            |              
 UCONN:Egg         |                      |            |              
 HMCM:Mamm         |                      |          2 |              
 HMCM:Geo          |                      |            |              
 HMCM:Herp         |                   18 |            |              
 HMCM:Arthro       |                 1153 |            |              
 HMCM:Bird         |                      |         13 |              
 HMCM:Herb         |                 1778 |            |              
 ACUNHC:Herp       |                  219 |            |              
 ACUNHC:Bird       |                    1 |            |              
 ACUNHC:Ento       |                 1268 |            |              
 ACUNHC:Paleo      |                      |            |              
 ACUNHC:Mamm       |                   57 |            |              
 ACUNHC:Inv        |                    4 |            |              
 ACUNHC:Fish       |                   75 |            |              
 BYUObs:Mamm       |                      |            |              
 BYUObs:Herp       |                      |            |              
 BYUObs:Bird       |                      |            |              
 BYU:Teach         |                    2 |            |              
 ALMNH:Paleo       |                      |            |              
 ALMNH:Geo         |                      |            |              
 UNCG:Mamm         |                  638 |            |              
 UNCG:Para         |                  409 |            |              
 MSB:Inv           |                   13 |            |              
 MLZObs:Fish       |                 2550 |            |              
 ALMNH:Anc         |                      |            |              
 UWZM:Bird         |                  143 |            |              
 CHAS:Art          |                      |            |              
 UWZM:Fish         |                      |            |              
 UWZM:Herp         |                      |            |              
 UWZM:Teach        |                      |            |              
 UWZM:EH           |                      |            |              
 UWZM:Mamm         |                 1386 |         10 |              
 UWZM:Inv          |                      |            |              
 UWZM:Paleo        |                      |            |              
 NCWRC:Mamm        |                      |            |              
 NCWRC:Bird        |                      |            |              
 NCWRC:Fish        |                      |            |              
 NCWRC:Ento        |                      |            |              
 NCWRC:Crust       |                      |            |              
 NCWRC:Herp        |                      |            |              
 NCWRC:Bivalve     |                      |            |              
 NCWRC:Gastro      |                      |            |              
 NHSM:Herp         |                      |            |              
 NHSM:Paleo        |                      |            |              
 NHSM:Bird         |                      |            |              
 NHSM:Geol         |                      |            |              
 NHSM:Mamm         |                      |            |              
 NHSM:Inv          |                      |            |              
 NHSM:Herb         |                      |            |              
 NHSM:Arc          |                      |            |              
 NHSM:Ento         |                      |            |              
 UAF:Zooarch       |                      |            |              
 UNM:MET           |                      |            |              
 MSBObs:Herp       |                    2 |            |              
 JSNM:Herb         |                 1028 |            |              
 TMCC:Herb         |                  546 |            |              
 TMCC:Ento         |                      |            |              
 TMCC:Inv          |                      |            |              
 TMCC:Fish         |                      |            |              
 TMCC:Bird         |                      |            |              
 TMCC:Herp         |                      |            |              
 TMCC:Mamm         |                      |            |              
 TMCC:Teach        |                      |            |              
 Arctos:Entity     |                    6 |            |              
 MVZ:Arch          |                      |            |              
 MVZ:Img           |                      |            |              
 JFBM:Herp         |                      |            |              
 JFBM:Fish         |                41806 |            |              
 JFBM:Inv          |                      |            |              
 MMNH:Bird         |                  156 |            |              
 MMNH:Mamm         |                  946 |            |              
 CDSC:Arch         |                      |            |              
 CDSC:Ento         |                      |            |              
 CDSC:Herb         |                      |            |              
 CDSC:Herp         |                      |            |              
 CDSC:Inv          |                      |            |              
 CDSC:Mamm         |                    1 |            |              
 CDSC:Geol         |                      |            |              
 MLZ:Inv           |                      |            |              
 UCM:Para          |                   39 |            |              
 BYU:Edu           |                  579 |            |              
 CDSC:Bird         |                      |            |              
 UMZM:Para         |                   15 |            |              
 UTEPObs:Bird      |                      |            |              
 CRCM:Bird         |                 1567 |         18 |              
 CRCM:Fish         |                 2470 |            |              
 CRCM:Herp         |                 5367 |            |              
 CRCM:Mamm         |                  172 |            |              
 CRCM:Paleo        |                    1 |            |              
 CRCM:Teach        |                      |            |              
 HSUVM:Mamm        |                      |            |              
 HSUVM:Amph        |                      |            |              
 HSUVM:Rept        |                      |            |              
 UTEPObs:Herb      |                      |            |              
 UWZM:Osteo        |                      |            |              
 CSULB:Mamm        |                  993 |            |              
 CSULB:Bird        |                   35 |            |              
 CSULB:Fish        |                 2493 |            |              
 CSULB:Herp        |                  599 |            |              
 UMNH:Host         |                      |            |              
 UMNH:Para         |                      |            |              
 TCDGM:Paleo       |                      |            |              
 TCDGM:Mineral     |                      |            |              
 TCDGM:Rock        |                      |            |              
 UNM:Geol          |                      |            |              
 UAA:Ento          |                      |            |              
 NMMNH:Obs         |                      |            |              
 MMNH:Edu          |                      |            |              
 UWBM:MINERAL      |                      |            |              
 UWBM:PB           |                      |            |              
 UWBM:MET          |                      |            |              
 UWBM:PR           |                      |            |              
 UWBM:PaleoArchive |                      |            |              
 UWBM:VP           |                      |            |              
 UWBM:IP           |                      |            |              
 KSB:Mamm          |                      |            |              
 KSB:Teach         |                      |            |              
 UAMObs:Art        |                      |            |              
 ZSFQ:Herp         |                      |            |       

temp_surelynot.csv

@Jegelewicz
Copy link
Member

Well - a lot of those "surely not's" also have no records in Arctos....

@Jegelewicz
Copy link
Member

Anyhoo - I propose that we only send the survey to users of "body" and "carcass" since they will have good reason to look at why they choose one of those over "whole organism" which is I think where we want to start?

@jtgiermakowski
Copy link

I updated parts for MSB:Herp to 'whole organism', all instances referred to an entire organism or a mummified carcass (still a whole organism).

@cjconroy
Copy link

In MVZ mammals, we use body to mean whole organism with skull removed. And carcass is what is left after removing the skin and skull.

@Jegelewicz
Copy link
Member

Sent to collections using carcass and body

Arctos Collection Manager,

The Arctos Code Table Admins are looking at some terms in the parts code table and we would like to get some feedback from users. Please complete this brief survey by 5 PM PDT on August 2nd so that we can discuss the results at our next code table meeting. It should only take ten minutes or so and your input is greatly appreciated!

Thank you in advance!

Teresa J. Mayfield-Meyer

@dustymc
Copy link
Contributor Author

dustymc commented Sep 21, 2023

Closing based on 2023-09-21 AWG Code Table Committee discussion

@dustymc dustymc closed this as completed Sep 21, 2023
@acdoll
Copy link

acdoll commented Sep 21, 2023

Is carcass staying or going away?

@Jegelewicz
Copy link
Member

no action

@acdoll
Copy link

acdoll commented Sep 21, 2023

thanks

@dustymc
Copy link
Contributor Author

dustymc commented Sep 21, 2023

https://handbook.arctosdb.org/how_to/How-To-Manage-Code-Table-Requests.html#specific-values-considerations see "Part Names (ctspecimen_part_name)" (and please fix whatever I got wrong!)

@Jegelewicz
Copy link
Member

I think that's fair.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
CodeTableCleanup Our bad data leads to more bad data. Fix it! Denormalizer Issue is making data less-accessible Help wanted I have a question on how to use Arctos Priority - Wildfire Potential ignore this at everyone's peril, may smolder for now ...
Projects
None yet
Development

No branches or pull requests

10 participants