search

ArctosDB / arctos

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

Code Table Request - project agent role, case #3643

Closed dustymc closed 3 years ago

dustymc commented 3 years ago

Goal

make data more consistent

Context

Authority values in Arctos are lowercase by default. https://arctos.database.museum/info/ctDocumentation.cfm?table=ctproject_agent_role Is All Proper Case For Some Reason

Table https://arctos.database.museum/info/ctDocumentation.cfm?table=ctproject_agent_role

Value

co-pi (not really see below) graduate student honors student academic advisor principal investigator sponsor volunteer research assistant post-doctoral associate undergraduate student research associate project coordinator

Definition

These need defined; existing data are bare.

sponsor==agent who can be linked with funding (pending something happening in https://github.com/ArctosDB/arctos/issues/3398)

I have no idea why the rest of these exist; help!

I dislike "co-pi" (in any case) - cryptic abbreviations are evil, and multiple principal anything is self-conflicting. Can we clean up whatever's not really necessary while we're defining?

Priority

Critical - code table inconsistencies are always high priority, I'm faced with adding to this mess or making this mess more internally inconsistent.

Jegelewicz commented 3 years ago

Authority values in Arctos are lowercase by default. https://arctos.database.museum/info/ctDocumentation.cfm?table=ctproject_agent_role Is All Proper Case For Some Reason

Because they are sorta like titles for people. I think they should stay proper case or at least they need to show up that way on the Project pages.

campmlc commented 3 years ago

co-PI is useful because in most cases we do not know who the lead PI(s) are on a project, but we have multiple names of researchers on a grant or project. Rather than denigrate one to "research associate" status, co-PI is more politically viable - especially, for example, if there are co-PIs in developing countries. We need some sort of "all these names are equally important in their efforts to contribute to this project" category.

On Sun, Jun 6, 2021 at 2:34 PM Teresa Mayfield-Meyer < @.***> wrote:

  • [EXTERNAL]*

Authority values in Arctos are lowercase by default. https://arctos.database.museum/info/ctDocumentation.cfm?table=ctproject_agent_role Is All Proper Case For Some Reason

Because they are sorta like titles for people. I think they should stay proper case or at least they need to show up that way on the Project pages.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/3643#issuecomment-855458853, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADQ7JBAJDPHTDFPDNZWV3HLTRPLVNANCNFSM46DFKFRA .

Jegelewicz commented 3 years ago

I have added definitions for all. The only one that seems extraneous to me is "Honors Student" because a participant could be both a Research Associate and an Honors Student (along with a bunch of other stuff).

dustymc commented 3 years ago

@campmlc using one term for them all does exactly what you said and is consistent with other data (eg if there's only one agent or you know all of their roles). If that's the use case, this is adding even more confusion (or taking away accessibility) than I suspected.

(along with a bunch of other stuff).

That's what I'm saying! This all looks arbitrary, we're just making sure that nobody can use these to query.

sorta like titles for people

That's not how we're displaying them nor what they are structurally, but I suppose Undergraduate Student Teresa could work with some changes....

Jegelewicz commented 3 years ago

Undergraduate Student Teresa

Nope - it's pretty much been "Volunteer Teresa"

campmlc commented 3 years ago

Yep. And what a volunteer!!

On Mon, Jun 7, 2021 at 8:50 AM Teresa Mayfield-Meyer < @.***> wrote:

  • [EXTERNAL]*

Undergraduate Student Teresa

Nope - it's pretty much been "Volunteer Teresa"

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/3643#issuecomment-856002735, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADQ7JBHKGR6ZC2T2R4SLSVTTRTMCHANCNFSM46DFKFRA .

mkoo commented 3 years ago

looking over the current list, I agree that Honors Student is anomalous-- can we remove? I suggest we change co-PI to Co-Principal Investigator too which removes the abbreviation and aligns with Principal Investigator.

dustymc commented 3 years ago

Co-Principal Investigator

Why not just Principal Investigator as many times as necessary?

can we remove?

I need a migration path.

arctosprod@arctos>> select project.project_id,project_name from project inner join project_agent on project.project_id=project_agent.project_id and project_agent_role ='Honors Student';
 project_id |                                                                     project_name                                                                      
------------+-------------------------------------------------------------------------------------------------------------------------------------------------------
    1000020 | The stable carbon and nitrogen isotopic composition of East Beringian grasses
    1000039 | Phylogeographic structure of the <i>Zapus princeps</i> complex
          7 | Age determination of <i>Ursus arctos middendorfi</i> using cranial characters.
        101 | Cranial and dental anomalies in otters.
    1000040 | Distribution of the armadillo <i>(Dasypus novemcinctus) </i>in New Mexico
    1000099 | Genetics of leaf hair production in <i>Arabidopsis kamchatica</i>.
    1000100 | Phylogenetic relationships among Alaskan poppies.
   10000321 | Phylogenetic relationships of <i>Ensatina eschscholtzii picta</i>
    1000099 | Genetics of leaf hair production in <i>Arabidopsis kamchatica</i>.
   10000835 | Climate change induced size change in Red squirrels (Tamiasciurus hudsonicus) in interior Alaska.
   10001378 | Genetic Analysis of House Mice (Mus musculus) from Alaska
   10002243 | Quantifying Variation in the Primate Hip: A Morphometric Study of the Proximal Femur & Implications for the Evolution of Primate Locomotor Adaptation
   10001164 | Microsatellite project on <i>Anniella alexanderae</i>.
(13 rows)
mkoo commented 3 years ago

Honors Student -> Undergraduate Student

If there's exceptions we can clean up.

OK, I could be convinced of getting rid of the distinction of Co-Principal Investigator; instead, we can add a remark 'lead' to denote the lead PI because there is a distinction to some, even if not regularly recognized by others

On Mon, Jun 7, 2021 at 3:48 PM dustymc @.***> wrote:

Co-Principal Investigator

Why not just Principal Investigator as many times as necessary?

can we remove?

I need a migration path.

@.***>> select project.project_id,project_name from project inner join project_agent on project.project_id=project_agent.project_id and project_agent_role ='Honors Student'; project_id | project_name ------------+------------------------------------------------------------------------------------------------------------------------------------------------------- 1000020 | The stable carbon and nitrogen isotopic composition of East Beringian grasses 1000039 | Phylogeographic structure of the Zapus princeps complex 7 | Age determination of Ursus arctos middendorfi using cranial characters. 101 | Cranial and dental anomalies in otters. 1000040 | Distribution of the armadillo (Dasypus novemcinctus) in New Mexico 1000099 | Genetics of leaf hair production in Arabidopsis kamchatica. 1000100 | Phylogenetic relationships among Alaskan poppies. 10000321 | Phylogenetic relationships of Ensatina eschscholtzii picta 1000099 | Genetics of leaf hair production in Arabidopsis kamchatica. 10000835 | Climate change induced size change in Red squirrels (Tamiasciurus hudsonicus) in interior Alaska. 10001378 | Genetic Analysis of House Mice (Mus musculus) from Alaska 10002243 | Quantifying Variation in the Primate Hip: A Morphometric Study of the Proximal Femur & Implications for the Evolution of Primate Locomotor Adaptation 10001164 | Microsatellite project on Anniella alexanderae. (13 rows)

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/3643#issuecomment-856311465, or unsubscribe https://github.com/notifications/unsubscribe-auth/AATH7UJBOC4WRC2JJSRSR4LTRVEDXANCNFSM46DFKFRA .

campmlc commented 3 years ago

I do think that "lead" is valid as an option, especially on a project like BCP where you might have half a dozen or more co-PIs. Who do you contact with questions? The lead PI.

On Mon, Jun 7, 2021 at 5:01 PM Michelle Koo @.***> wrote:

  • [EXTERNAL]*

Honors Student -> Undergraduate Student

If there's exceptions we can clean up.

OK, I could be convinced of getting rid of the distinction of Co-Principal Investigator; instead, we can add a remark 'lead' to denote the lead PI because there is a distinction to some, even if not regularly recognized by others

On Mon, Jun 7, 2021 at 3:48 PM dustymc @.***> wrote:

Co-Principal Investigator

Why not just Principal Investigator as many times as necessary?

can we remove?

I need a migration path.

@.***>> select project.project_id,project_name from project inner join project_agent on project.project_id=project_agent.project_id and project_agent_role ='Honors Student'; project_id | project_name

------------+------------------------------------------------------------------------------------------------------------------------------------------------------- 1000020 | The stable carbon and nitrogen isotopic composition of East Beringian grasses 1000039 | Phylogeographic structure of the Zapus princeps complex 7 | Age determination of Ursus arctos middendorfi using cranial characters. 101 | Cranial and dental anomalies in otters. 1000040 | Distribution of the armadillo (Dasypus novemcinctus) in New Mexico 1000099 | Genetics of leaf hair production in Arabidopsis kamchatica. 1000100 | Phylogenetic relationships among Alaskan poppies. 10000321 | Phylogenetic relationships of Ensatina eschscholtzii picta 1000099 | Genetics of leaf hair production in Arabidopsis kamchatica. 10000835 | Climate change induced size change in Red squirrels (Tamiasciurus hudsonicus) in interior Alaska. 10001378 | Genetic Analysis of House Mice (Mus musculus) from Alaska 10002243 | Quantifying Variation in the Primate Hip: A Morphometric Study of the Proximal Femur & Implications for the Evolution of Primate Locomotor Adaptation 10001164 | Microsatellite project on Anniella alexanderae. (13 rows)

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/3643#issuecomment-856311465, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AATH7UJBOC4WRC2JJSRSR4LTRVEDXANCNFSM46DFKFRA

.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/3643#issuecomment-856316157, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADQ7JBADAQJNBUESUV53EWDTRVFVDANCNFSM46DFKFRA .

dustymc commented 3 years ago

From @Jegelewicz 's much-appreciated definition:

co-investigator (Co-I) assists the principal investigator

"Co-PI"-->"Investigator"?

I'm certainly fine with retaining https://arctos.database.museum/info/ctDocumentation.cfm?table=ctproject_agent_role#principal_investigator as "The lead PI."

I'm not trying to change the world here, I'm just looking for clear vocabulary that can be used consistently. (And Proper Case is still silly but whatever...)

campmlc commented 3 years ago

a "co-principal investigator", also known as the Co-PI"

On Tue, Jun 8, 2021 at 11:56 AM dustymc @.***> wrote:

  • [EXTERNAL]*

From @Jegelewicz https://github.com/Jegelewicz 's much-appreciated definition https://arctos.database.museum/info/ctDocumentation.cfm?table=ctproject_agent_role#co_pi :

co-investigator (Co-I) assists the principal investigator

"Co-PI"-->"Investigator"?

I'm certainly fine with retaining https://arctos.database.museum/info/ctDocumentation.cfm?table=ctproject_agent_role#principal_investigator as "The lead PI."

I'm not trying to change the world here, I'm just looking for clear vocabulary that can be used consistently. (And Proper Case is still silly but whatever...)

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/3643#issuecomment-856974716, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADQ7JBEIOMFT7D5UXUSFOSLTRZKUBANCNFSM46DFKFRA .

ewommack commented 3 years ago

Having a lead designation somewhere (either as PI versus Co-PI) would help in figuring out who you should contact to ask questions, for reports, etc.

dustymc commented 3 years ago

Closing; we have definitions (thanks @Jegelewicz), I've inserted my new terms, we can revisit when/if our inconsistent vocab/usage stops someone from doing something.