dustymc
commented
2 years ago I'm not sure I'm madly in love with this particular path, but these have needed better handling for a long time and I don't have better ideas so I support this.
While we're cleaning:
parasites found [ link ]
guid_prefix | count
-------------+-------
MSB:Host | 18734Tentatively suggest converting to endoparasite examination with verbose remarks; some will be wrong, the remarks should easily clarify.
parts examined [ link ]
guid_prefix | count
-------------+-------
MSB:Bird | 1
MSB:Host | 780
append to method of an endoparasite examination attribute, or add such attribute if necessary
tested for presence [ link ]
guid_prefix | count
-------------+-------
UAM:Env | 334should be brought closer into alignment, and this suggests 'examination' may not quite be the right word - I think these functionally differ only by vaguely-implied method (human digging around in guts vs. chemical magic). That said, I can't think of a word that encompasses 'tested' and 'examined' so ???
@campmlc @KyndallH
jldunnum
Jegelewicz
campmlc
Goal UWZM has some people interested in pathologies, but I also happen to know that there is some of this in UTEP:ES. They have pathology data that they would like to preserve and be able to search.
Pathology: Non-normal skeletal conditions that include lytic, proliferative and deformative lesions, as well as accessory bones, non- fusion anomalies and antemortem trauma.
Context This data is structured a lot like the current parasite attributes:
Table https://arctos.database.museum/info/ctDocumentation.cfm?table=ctspecpart_attribute_type
Proposed Value What if, instead of creating a bunch of "examined for" and "detected" attributes, we only have one version of these then use a code table to select the thing that was detected? Also - these should be associated with the appropriate part, so I have moved them to the part attribute table.
examined and detected examined and not detected detected not examined
Proposed Definition
examined and detected - The attribute value was detected during a systematic examination. Do not use this attribute for incidental detection.
examined and not detected - The attribute value was not detected during a systematic examination.
detected - The attribute value was detected incidentally. Do not use this attribute for detection made during a systematic examination.
not examined - No examination was made for the attribute value.
Collection type Bird, ES, Herp, Host, Mamm, Teach
Attribute data type categorical
Attribute value
ectoparasite - parasites that live on the external surface of hosts, for example fleas and lice of various terrestrial vertebrates, and Monogenea and Copepoda of freshwater and marine fishes.
endoparasite - parasites that live in the tissues and organs of their hosts, such as tapeworms, flukes, and protozoans of vertebrates.
pathology - Non-normal skeletal conditions that include lytic, proliferative and deformative lesions, as well as accessory bones, non- fusion anomalies and antemortem trauma.
Available for Public View Yes
So, instead of this
Attribute | Value | Determiner | Date | Method | Remark -- | -- | -- | -- | -- | -- ectoparasite examination | no | Troy Harrell | 1990-07-30 | | endoparasite examination | yes | Troy Harrell | 1990-07-30 | | none found endoparasites detected | no | Troy Harrell | 1990-07-30 | | you would have Attribute | Value | Determiner | Date | Method | Remark -- | -- | -- | -- | -- | -- not examined | ectoparasite | Troy Harrell | 1990-07-30 | | examined and not detected | endoparasite | Troy Harrell | 1990-07-30 | |