parenthetical bits in agent names

dustymc commented 2 years ago

I just noticed this, please DO NOT add parenthetical stuff to agent names (unless you have to...) Add more names, request a new name type, use remarks, but please do not add things which are not names to names; it'll just result in less-useful data and more messes.

And 63 out of almost 100K - yay us!


arctosprod@arctos>> select preferred_agent_name,agent_name,agent_name_type,getPreferredAgentName(created_by_agent_id) creator from agent inner join agent_name on agent.agent_id=agent_name.agent_id and agent_name_type
arctos-> !='preferred'
arctos-> where agent_name like '%{%' or agent_name like '%[%' or agent_name like '%(%' ;
                         preferred_agent_name                          |                            agent_name                             | agent_name_type |         creator          
-----------------------------------------------------------------------+-------------------------------------------------------------------+-----------------+--------------------------
 Susie Bevins-Ericsen                                                  | Susie (Qimmiqsaq) Bevins-Ericsen                                  | aka             | unknown
 J. Bailey (Plants)                                                    | Bailey (Plants)                                                   | last name       | Arthur H. Harris
 Maarten(Martin) Houttuyn                                              | Maarten(Martin)                                                   | first name      | unknown
 Hans Henric(Henrik) Ringius                                           | Hans Henric(Henrik)                                               | first name      | unknown
 Daniel Abrams                                                         | (SP)                                                              | middle name     | unknown
 Shawn (Fred) Whiteman                                                 | Shawn (Fred)                                                      | first name      | unknown
 S. K. Heckscher                                                       | (SP)                                                              | middle name     | unknown
 Elizabeth Anne (Toby) Kellogg                                         | Anne (Toby)                                                       | middle name     | unknown
 Mark Egger                                                            | (John Mark)                                                       | middle name     | unknown
 Cheng (Lily) Li                                                       | (Lily)                                                            | middle name     | unknown
 William (Bill) Reisland                                               | (Bill)                                                            | middle name     | unknown
 S. K. Heckscher                                                       | S. (SP) Heckman                                                   | aka             | unknown
 M. Perry, R. Ring                                                     | M. Perry, R. Ring (AK Bird Obs)                                   | aka             | unknown
 Daniel Abrams                                                         | D. (SP) Abrams                                                    | aka             | unknown
 Frank Waskey                                                          | Neqyacagaq (Little Fishy One)                                     | aka             | unknown
 Mark Egger                                                            | Mark (John Mark) Egger                                            | aka             | unknown
 Missouri Geological Survey                                            | Division of Geological Survey [of Missouri]                       | aka             | Dusty L. McDonald
 Amelia Flanery Eby                                                    | Mengel [maiden]                                                   | last name       | Dusty L. McDonald
 J. Anderson (Fish collector - UAM)                                    | J. Anderson (Fish collector - UAM)                                | aka             | unknown
 Anna Pedersen Kummer                                                  | Pedersen [maiden name]                                            | last name       | Dusty L. McDonald
 Kevin Johnson (AK)                                                    | Johnson (AK)                                                      | last name       | Jonathan L. Dunnum
 John Harris (AK)                                                      | Harris (AK)                                                       | last name       | Jonathan L. Dunnum
 Martin W. Mutuku                                                      | Research Technologist at Kenya Medical Research Institute (KEMRI) | job title       | Sara V. Brant
 Darren E. Irwin                                                       | Professor (Associate)                                             | job title       | unknown
 Herbert L. Stoddard Jr.                                               | Sonny [nickname]                                                  | aka             | unknown
 Margie Root                                                           | Margie (Margaret A.) Root                                         | aka             | Aren M. Gunderson
 Jan (Raven) Stitt                                                     | (Raven)                                                           | middle name     | Aren M. Gunderson
 Jack Abraham                                                          | Jack (Ayap' Run) Abraham                                          | aka             | Dusty L. McDonald
 William Hedman                                                        | William (Bill)                                                    | first name      | Dusty L. McDonald
 Steve (Ted) Andrews                                                   | Steve (Ted)                                                       | first name      | Dusty L. McDonald
 James Wolf                                                            | A. [tentative]                                                    | middle name     | Dawn R. Roberts
 Henry Holmes Babcock                                                  | Homes [sic]                                                       | middle name     | Dusty L. McDonald
 J. Anderson (Botany)                                                  | Anderson (Botany)                                                 | last name       | Arthur H. Harris
 Floretta Allen Curtiss                                                | Allen [maiden]                                                    | last name       | Dusty L. McDonald
 D. Amos (Botany)                                                      | Amos (Botany)                                                     | last name       | Arthur H. Harris
 I. Abbott (Botany)                                                    | Abbott (Botany)                                                   | last name       | Arthur H. Harris
 D. Anderson (Botany)                                                  | Anderson (Botany)                                                 | last name       | Arthur H. Harris
 Piiamari R. Bowers                                                    | Bowers (Plants)                                                   | last name       | Arthur H. Harris
 Bob Smith                                                             | Smith, Bob (UTEP)                                                 | aka             | Teresa J. Mayfield-Meyer
 Marin Toderoff                                                        | Marin (Mike) Toderoff                                             | aka             | Angela Linn
 J. Brewer (Plants)                                                    | Brewer (Plants)                                                   | last name       | Arthur H. Harris
 G. Phillips (Botany)                                                  | Phillips (Botany)                                                 | last name       | Arthur H. Harris
 C. Baenitz                                                            | Karl (Carl) Gabriel Baenitz                                       | aka             | Arthur H. Harris
 A. Anderson (Botany)                                                  | Anderson (Botany)                                                 | last name       | Arthur H. Harris
 E. Brown (Botany)                                                     | Brown (Botany)                                                    | last name       | Arthur H. Harris
 L. E. Allen (Botany)                                                  | Allen (Botany)                                                    | last name       | Arthur H. Harris
 R. A. Anderson (Botany)                                               | Anderson (Botany)                                                 | last name       | Arthur H. Harris
 W. Abbott (Botany)                                                    | Abbott (Botany)                                                   | last name       | Arthur H. Harris
 J. Miller (Plants)                                                    | Miller (Plants)                                                   | last name       | Arthur H. Harris
 University of Louisiana at Monroe                                     | Northeast Louisiana University (NLU)                              | aka             | Mariel L. Campbell
 Laura Rericha-Anchor                                                  | Anchor [maiden]                                                   | last name       | Jessica Weller
 Rimo Carlo Felice Bacigalupi                                          | Ba(t)ch                                                           | aka             | unknown
 Teton Science School                                                  | Teton Science School (Debbie)                                     | aka             | Lindsey Frederick
 W. Lloyd (plants)                                                     | Lloyd (plants)                                                    | last name       | Teresa J. Mayfield-Meyer
 Paul Smith (Fauna Paraguay)                                           | Smith (Fauna Paraguay)                                            | last name       | Jonathan L. Dunnum
 Teton Science School                                                  | Teton Science School (Major, T.)                                  | aka             | Lindsey Frederick
 Teton Science School                                                  | Teton Science School (Eric)                                       | aka             | Lindsey Frederick
 Mikele Painter                                                        | South Platte Ranger District Biologist (USFS)                     | job title       | Andrew Charles Doll
 United States Geological Survey                                       | U. S. Geological Survey (USGS)                                    | aka             | unknown
 Larry Ahvakana                                                        | Lawrence (Larry) Ulaaq R. Ahvakana                                | aka             | unknown
 Nathaniel P. Hitt                                                     | Nathaniel (Than) P. Hitt                                          | aka             | Lindsey Frederick
 Lee Kong Chian Natural History Museum Zoological Reference Collection | The Zoological Reference Collections (ZRC)                        | aka             | Teresa J. Mayfield-Meyer
 University of Texas - El Paso College of Science                      | College of Science (UTEP)                                         | aka             | Mingna Zhuang
(63 rows)

ewommack commented 2 years ago

@lin-fred - we can probably clean up https://arctos.database.museum/agents.cfm?agent_id=21320380, by creating a Teton Science School and then all the people as employees.

https://www.tetonscience.org/

wellerjes commented 2 years ago

Thanks for pointing this out. I've removed "[maiden name]" from our agents and made a note in remarks.

Could we add a non-required remarks field next to the name? (similar to the agent status section):

Jegelewicz commented 2 years ago

@wellerjes "maiden" name should be listed as birth name.

lin-fred commented 2 years ago

@lin-fred - we can probably clean up https://arctos.database.museum/agents.cfm?agent_id=21320380, by creating a Teton Science School and then all the people as employees.

https://www.tetonscience.org/

Seems like no one in their current staff goes by the names of Debbie, Eric or T. Major, so I don't know if we should add the current employees? Because it probably wasn't the current ones.

Looking through their old staff, one of the Founders was a Ted Majors, but still no Debbie/Eric, so maybe they were possibly family of Ted? I will at least add Ted Major

Edit: these two https://wyofile.com/science-schools-founders/

dustymc commented 2 years ago

Are those addresses in status remarks also in addresses? That's not discoverable/usable there, just doing twice as much work all the time isn't a great plan, that's often indicative of some structural problem - should perhaps some merging of status and address be considered?

Alive in 1910, we don't know where (current status)
there, we don't know when (current address)
there in 1910 (current address+statusless-status - I suppose 'alive' is implied)
there, https://arctos.database.museum/info/ctDocumentation.cfm?table=ctagent_status -ing, in 1910 (current address+ current status)

shouldn't be overly difficult to model (maybe even fits entirely in current address model??), and might include at least one more 'state' than the current.

Yep 'birth name' is a more-inclusive 'maiden' name, and certainly no objection to more name types if they're necessary (as long as they're not arbitrary or overlapping with other stuff, same as always). I don't think we need name remarks, but it's an easy enough change if we do (thanks to good modeling!).

In any case, my concern is that I'll never figure out 'somename' and 'somename [whatever]' are duplicates and I don't think that's spelled out in the documentation - it should be. And I was fully expecting to find thousands and very pleasantly surprised not to!

lin-fred commented 2 years ago

what do I do with the Teton akas, as that is how they were put on labels and such in the collection, and that's how it was in the legacy database? I'm not so sure about getting rid of them as AKAs for that reason? Thoughts?

ewommack commented 2 years ago

I would think of Teton Science School as an actual school. I think they even have a small museum up there. They have interns, volunteers, students, seasonal staff, etc. I would assume your people listed on the tags were associated with them at some time, but they may have been there for only one summer. I would treat them as unknown members of a class or seasonal staff in a park that we do not have a ton of info for. If you have the time you could write the school and ask if they had any way of finding out who they are.

@ccicero - do I remember right that you know the Teton Science School?

lin-fred commented 2 years ago

But what would they go into otherwise? just the general remarks?

ccicero commented 2 years ago

In the car heading to the field so a quick answer without logging into Github.

Yes, I went there as a high school student in 1976. They do have a small educational museum and have permanent staff but also lots of students, interns, etc. So probably lots of folks without much info about them.

On Thu, Sep 29, 2022, 1:29 PM Elizabeth Wommack @.***> wrote:

I would think of Teton Science School as an actual school. I think they even have a small museum up there. They have interns, volunteers, students, seasonal staff, etc. I would assume your people listed on the tags were associated with them at some time, but they may have been there for only one summer. I would treat them as unknown members of a class or seasonal staff in a park that we do not have a ton of info for. If you have the time you could write the school and ask if they had any way of finding out who they are.

@ccicero https://github.com/ccicero - do I remember right that you know the Teton Science School?

— Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/5113#issuecomment-1262780476, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAHME27O5Z5TYPXYL6CCZTTWAX32PANCNFSM6AAAAAAQYG4744 . You are receiving this because you were mentioned.Message ID: @.***>

Jegelewicz commented 2 years ago

But what would they go into otherwise? just the general remarks?

verbatim agent attributes in whatever records they are used as collector, preparator, etc. They don't belong in names, maybe put them in remarks if you want.

not sure, but I feel like I'm missing something....

lin-fred commented 2 years ago

But what would they go into otherwise? just the general remarks?

verbatim agent attributes in whatever records they are used as collector, preparator, etc. They don't belong in names, maybe put them in remarks if you want.

not sure, but I feel like I'm missing something....

oh right, verbatim agents. Just keeping ya'll on your toes....

ewommack commented 2 years ago

Yeah verbatim agents!

I bet I have some Teton Science school stuff here too, but we may have missed the data...I probably need to go look at some tags.

lin-fred commented 2 years ago

Ok Teton is all good now

ArctosDB / arctos

parenthetical bits in agent names #5113