Agents cannot have multiple relationships with another agent

I was just working on a person who has been employed multiple times at an organization or held multiple titles there. I cannot record anything but the first period of employment because we don't allow duplicate relationships. I think we should. People definitely have multiple periodic associations with each other and with organizations. Can we get rid of this constraint?

Someone has tried getting around this by using "status", but this is a poor substitute for multiple relationships.

See Dawn R. Roberts

I have these long running lists of jobs/positions for students in Agent Remarks. It might be nice to be able to sort through them in a more controlled fashion.

We should not allow duplicates, but we should also not consider things with different dates to be duplicates. That's probably somewhat tricky to index given the two NULLable values.

Agreed that status is a poor substitute, and remarks are worse. (~half of all recent agent remarks are misplaced addresses and/or relationships, plus some names and such!)

https://handbook.arctosdb.org/documentation/agent.html#creating--maintaining-agents

I'll see what I can figure out with the indexes, and The Community should review - well, I have no idea, how new operators are introduced to documentation or something maybe??


arctosprod@arctos>> select agent_remarks from agent where created_date > current_date - interval '6 month' group by agent_remarks order by agent_remarks;
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               agent_remarks                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 1965 Dipterist
 1979 Elateridae expert
 1 Department of Anthropology and Archaeology, Brooklyn College, City University of New York; New York Consortium in Evolutionary Primatology
 2003-2007 Graduate student assistant in UAM Ethnology & History.
 2020 graduate student, Univ. AK Fairbanks
 2021 graduate student, Ottawa, weevil systematics
 2021 - UAF - Biology - Doctoral student
 2021 - Unalakleet resident - observed and photograph a frog in the vicinity of Unalakleet
 A Brother of St. Procopius Abbey, Lisle, IL
 aka. F. Bennett
 aka. J. N. Clark
 Alaska Department of Fish and Game, Soldotna
 Albuquerque Journal photographer
 ALMNH
 A member of St. Procopius Abbey in Lisle, IL
 Anchorage, AK resident 2020
 Anchorage AK resident 2021
 Arctos intern Summer 2021
 Arctos Member Institution
 Arctos Member Institution - TMCC
 Art conservator
 art museum at UTEP
 ASNHC Bird Collector
 ASNHC Bird Prep
 ASNHC Mammal Collector
 ASNHC Mammal Prep
 Assistant Professor of Biology, TAMUCC, Texas A&M University, Corpus Christi
 Associated with Oregon Coast Aquarium
 ASUMZ bulkload agent
 Barrow, AK resident 2021
 Biodiversity and Organization of Marine Ecosystems class
 bird collection manager at UMMZ
 Boot and Shoe manufactures, No. 25 South Fourth street , Philadelphia
 Botanic Garden Meise, Belgium
 Canadian Dipterist 2021
 Chair of Digital Collections at the University of Wyoming Libraries
 chimpanzee in the Chimpanzee Species Survival Program
 Chimpanzee, Pan troglodytes, Albquerque Zoo Local ID M02024
 Cincinnati Museum Center
 Colleague of John D. McCarty Jr. 
 Collected mussels in ALMNH:Inv collection around 2005
 collections manager Mycology and Lichenology
 College of Ecology, University of Maryland
 CSU-DS contact
 curator
 Curator of UNM Metoritic Collection
 David Ray master's student Texas Tech
 Denver Museum of Nature and Science
 Department of Anthropology, The University of British Columbia
 Department of Biological Sciences, 100 Galvin Life Sciences Center, University of Notre Dame, Notre Dame, Indiana 46556 USA
 Department of Biology, 167 Castetter Hall, University of New Mexico, Albuquerque, New Mexico 87131 USA
 Department of Biology, Colgate University
 Department of Biology, McMaster University
 Department of Biology, Queen's University, Kingston, Ontario K7L 3N6, Canada
 Department of Biology, Queen's University, Kingston, Ontario K7L 3N6, Canada Present address: Canadian Museum of Nature, P.O. Box 3443, Station D, Ottawa, Ontario K1P 6P4, Canada.
 Department of Earth and Atmospheric Sciences University of Alberta
 Department of Earth and Atmospheric Sciences, University of Alberta
 Department of Earth and Environmental Sciences,  Vanderbilt University; 4  Department of Paleobiology, National Museum of Natural History, Smithsonian Institution
 Department of Earth Sciences, University of Cambridge, Downing Street, Cambridge
 Department of Natural Sciences, Tromsø University Museum, Tromsø Norway
 Department of Organismal Biology and Anatomy, University of Chicago
 Department of Wildlife Ecology and Conservation, University of Florida
 Division of Zoology, Research Centre for Biology-LIPI
 Ecology and Evolutionary Biology, State University of New York; New York State Museum
 Ecology Group, Institute of Natural Resources, Massey University
 Environment and Climate Change Canada, Wildlife Research Division
 Erotylidae expert 1956
 Film preservation, conservation, digitization service.
 First name is unknown
 Florida EPA
 Former resident of Fairbanks, AK
 From website: The Calista Elders Council (CEC) is a non-profit organization representing the 1,300 Yup'ik tradition bearers of the Yukon-Kuskokwim delta in southwest Alaska. It is the major research organization for the region, including a population of more than 20,000, and is active in documenting the traditional knowledge of the Yup'ik people. CEC was established in 1991 as a non-profit organization by Calista (the profit corporation for the Yukon-Kuskokwim delta).
 Gensis Solar Operations, a solar farm company
 grad student of David Blackburn, UF 2021-
 grad student, UNC Greensboro
 Graduate student at Oregon State University
 graduate student at UTEP 2015-
 graduate student at UTEP 2020-
 Grantová Agentura České Republiky
 Harvard University MCZ
 herbarium curator at NMSU
 herbarium volunteer at UTEP 2021-
 herp collector helping Bob Hansen
 herpetologist
 herpetologist from FL and VA, died in 2019
 https://erc.europa.eu/
 Hymenopterist, UT, 2021
 In field with Bradley, 1963
 Informatics Institute, University of Florida
 John E. Jolly's wife per APSU
 J. S. D.-Egg Collector
 Kenai, AK 2021
 KU
 Latridiidae expert 1970s-1980s
 Lichen systematics; chemotaxonomy and floristics; the genera Lecanora and Ramalina; lichen collection management
 malacologist at MCZ
 malacologist at the MCZ
 Manager of UNM Metoritic Collection
 McMaster Ancient DNA Centre, Departments of Anthropology and Biochemistry, McMaster University' 
 McMaster Ancient DNA Centre, Departments of Anthropology and Biochemistry, McMaster University; 2Department of Biology, McMaster University
 McMaster Ancient DNA Centre, Departments of Anthropology and Biochemistry, McMaster University; Department of Biochemistry, McMaster University
 MMNH contact
 MSB DGR volunteer
 MSB Division of Mammals volunteer
 MSB:Herp
 MSB:Herp  collected with Roger Conant
 MSB:Herp  collected with Roger Conant 1940's
 MSB:Herp  UNM student in 1977
 MSUMZ
 Museu de Ciencies Naturals, Catalonia, Spain
 MVZ and IB PhD student at UC Berkeley, ca. 2019-
 MVZ Curatorial Assistant, Fall 2021
 MVZ Curatorial Assistant in Herpetology 2021-  , MVZ URAP Spring 2021.
 MVZ Curatorial Assistant in Herpetology Fall 2021-
 MVZ Mammal undergrad and postbaccalaureate volunteer, 2021-present
 MVZ PhD student 2018-
 MVZ undergrad 2020-2021
 MVZ undergrad 2021-
 National Museum, MN/UFRJ, Brazil
 Natural History Museum, London, UK
 Natural History Museum, University of Oslo, Oslo, Norway
 naturalist historian?
 NCWRC contact
 NHSM bulkload agent
 NHSM contact
 NMMNHS agent
 Ohio Wesleyan University
 Ohio Wesleyan University Class of 2013
 Opened in 1959 by South African Association for Marine Biological Research (SAAMBR)
 Paleoartist
 paleontologist, Head of Museum of Natural History
 Parks Canada
 perhaps Abah G. Dorr
 Peruvian student of Pierre-Henri Fabre
 Ph.D. Student at The City University of New York & The New York Botanical Garden
 PhD Student - CIBIO - Research Centre in Biodiversity and Genetic Resources University of Porto, Instituto de Ciencias Agrarias de Vairao, Portugal
 postdoc and Chicago Field Museum
 postdoc for oVert at UF
 Postdoc, Sudmant lab, UC Berkeley, 2020-
 preparator at the Rubin Center
 Professor at National Institute for Research in the Amazon
 Professor, Department of Biodiversity, Earth & Environmental Science, Drexel University; Pilsbry Chair of Malacology, ANS
 Professor, Integrative Biology UC Berkeley. 1 July 2018 -
 Resident of Dixon, California
 Rhododendron curator at Holden Arboretum
 Royal Botanic Garden Edinburgh
 Rua de Zurique 3, 4485-790 Vila Chã, Portugal
 School of GeoSciences, University of Edinburgh, Grant Institute, Edinburgh
 Sitka, AK resident 2020
 Skunk Crew
 student of Gunther Kohler, from Costa Rica
 student of Kate Teeter at Northern Michigan University
 Texas A&M Fishes
 Texas Tech Master's student mammalogy
 The Amos Rehabilitation Keep, or ARK, rehabilitates marine turtles and marine birds from the coastal zone of Mustang Island and St. Joseph Island.
 The father of Katherine Noble-Goodman
 The Illinois Audubon Society was organized as an independent, state-wide, educational and scientific organization, incorporated April 10, 1897, by the State of Illinois.
 The Ministry of Science and Innovation, department of the Spanish Government
 The only documented individual to be struck by a meteorite and live to tell about it.
 The Richard Gilder Graduate School and Department of Ornithology, American Museum of Natural History; Department of Ecology, Evolution, and Environmental Biology, Columbia University
 This agent is created to denote any NMU student mammal preparator.
 TMCC contact
 UAB Professor Emeritus
 UAM Ethnology & History
 UAM Ethnology & History;
 UAM Ethnology & History; a shaman of Qissunaq
 UAM Ethnology & History; Chief of Nulato; assisted with William Healey Dall's expeditions for the Western Union Telegraph Expedition of 1866-1868
 UAM Ethnology & History; Conservator
 UAM Ethnology & History; Otis Ahkivgak was born in 1891 in Wainwright, Alaska, but lived along the northern Beaufort Sea coast. Typical of Inupiaq families at that time, they moved around a lot following the seasons and available food sources. Starting in 1902, after a measles epidemic, the family spent winters at Flaxman Island. Otis grew up hunting for caribou, seals, and polar bear, setting nets for fish, reindeer herding, and trapping foxes. Otis whaled with Taaqpak at Cross Island, and married his daughter, Mary. They moved to Barrow, Alaska about 1938. Otis loved to go whaling and considered Taaqpak his great teacher. From a lifetime of subsistence activity, Otis developed a great knowledge of the ice conditions both along the Beaufort Sea coastline and around Barrow. Eventually, Otis took over Taaqpak’s whaling crew as Taaqpak became too old to keep whaling. The Ahkivgak Crew continues to whale in Barrow. After Mary Ahkivgak died, Otis married Olive. Otis Ahkivgak died December 24, 1980; he was 89 years old. For more about Otis Ahkivgak, see Qiñiqtuagaksrat Utuqqanaat Iñuuniaġniŋisiqun: The Traditional Land Use Inventory for the Mid-Beaufort Sea, Volume 1. (Barrow, AK: North Slope Borough, Commission on History and Culture, 1980).
 UAM Ethnology & History; student curatorial assistant (2011-2012)
 UAM ethnology & history; tool manufacturer
 UAMN Earth Sciences Graduate Student
 undergraduate georeferencer 2021-
 undergraduate georeferencer 2021-2021
 undergraduate volunteer at UTEP Biodiversity Collections 2021-
 undergraduate volunteer for the UTEP Biodiversity Collections 2021-
 Univ. AK Museum lab tech 2021
 Univ. Alaska Anchorage undergraduate 2020
 University of Alaska Fairbanks (UAF) Zooarchaeology Laboratory Collection Manager
 University of Colorado Museum and Field Studies Graduate Assistant (Fall 2021-   ), Vertebrate Collections
 University of Kentucky Veterinary Parasitology
 , University of Miami Miller School of Medicine
 University of North Carolina Wilmington
 University of Tasmania (PhD student)
 UNM Biology Master's student
 UWZM Staff 2015-present; CU Museum & Field Studies Student 2013-2015.
 volunteer for the UTEP herpetology collections
 Wasilla, AK resident 2021
 Wildlife Conservation Society
 Zoological Institute of Russian Academy of Science, 1 Universitetskaya Emb., St. Petersburg 199034, Russia

I'm trying to wrap my head around this: We should not allow duplicates, but we should also not consider things with different dates to be duplicates. One of the issues we face is the same individual who goes in and out of operator status at different times, and has different permissions as an operator to different collections at different times. Currently we are advised to never remove operator status from an agent's permissions, which makes no sense to me under these conditions. The only alternative I see is to allow a single agent to have multiple operator logins or usernames, with different permissions granted to each. Or, we allow the same person to have multiple agent profiles, each with different operator permissions - and that defeats the purpose of having a standardized agent table, unless we can provide a way to link agents under "same individual as" relationships.

On Tue, Sep 14, 2021 at 8:38 AM dustymc @.***> wrote:

[EXTERNAL]*

We should not allow duplicates, but we should also not consider things with different dates to be duplicates. That's probably somewhat tricky to index given the two NULLable values.

Agreed that status is a poor substitute, and remarks are worse. (~half of all recent agent remarks are misplaced addresses and/or relationships, plus some names and such!)

https://handbook.arctosdb.org/documentation/agent.html#creating--maintaining-agents

I'll see what I can figure out with the indexes, and The Community should review - well, I have no idea, how new operators are introduced to documentation or something maybe??

@.***>> select agent_remarks from agent where created_date > current_date - interval '6 month' group by agent_remarks order by agent_remarks;
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           agent_remarks
1965 Dipterist

1979 Elateridae expert

1 Department of Anthropology and Archaeology, Brooklyn College, City University of New York; New York Consortium in Evolutionary Primatology

2003-2007 Graduate student assistant in UAM Ethnology & History.

2020 graduate student, Univ. AK Fairbanks

2021 graduate student, Ottawa, weevil systematics

2021 - UAF - Biology - Doctoral student

2021 - Unalakleet resident - observed and photograph a frog in the vicinity of Unalakleet

A Brother of St. Procopius Abbey, Lisle, IL

aka. F. Bennett

aka. J. N. Clark

Alaska Department of Fish and Game, Soldotna

Albuquerque Journal photographer

ALMNH

A member of St. Procopius Abbey in Lisle, IL

Anchorage, AK resident 2020

Anchorage AK resident 2021

Arctos intern Summer 2021

Arctos Member Institution

Arctos Member Institution - TMCC

Art conservator

art museum at UTEP

ASNHC Bird Collector

ASNHC Bird Prep

ASNHC Mammal Collector

ASNHC Mammal Prep

Assistant Professor of Biology, TAMUCC, Texas A&M University, Corpus Christi

Associated with Oregon Coast Aquarium

ASUMZ bulkload agent

Barrow, AK resident 2021

Biodiversity and Organization of Marine Ecosystems class

bird collection manager at UMMZ

Boot and Shoe manufactures, No. 25 South Fourth street , Philadelphia

Botanic Garden Meise, Belgium

Canadian Dipterist 2021

Chair of Digital Collections at the University of Wyoming Libraries

chimpanzee in the Chimpanzee Species Survival Program

Chimpanzee, Pan troglodytes, Albquerque Zoo Local ID M02024

Cincinnati Museum Center

Colleague of John D. McCarty Jr.

Collected mussels in ALMNH:Inv collection around 2005

collections manager Mycology and Lichenology

College of Ecology, University of Maryland

CSU-DS contact

curator

Curator of UNM Metoritic Collection

David Ray master's student Texas Tech

Denver Museum of Nature and Science

Department of Anthropology, The University of British Columbia

Department of Biological Sciences, 100 Galvin Life Sciences Center, University of Notre Dame, Notre Dame, Indiana 46556 USA

Department of Biology, 167 Castetter Hall, University of New Mexico, Albuquerque, New Mexico 87131 USA

Department of Biology, Colgate University

Department of Biology, McMaster University

Department of Biology, Queen's University, Kingston, Ontario K7L 3N6, Canada

Department of Biology, Queen's University, Kingston, Ontario K7L 3N6, Canada Present address: Canadian Museum of Nature, P.O. Box 3443, Station D, Ottawa, Ontario K1P 6P4, Canada.

Department of Earth and Atmospheric Sciences University of Alberta

Department of Earth and Atmospheric Sciences, University of Alberta

Department of Earth and Environmental Sciences, Vanderbilt University; 4 Department of Paleobiology, National Museum of Natural History, Smithsonian Institution

Department of Earth Sciences, University of Cambridge, Downing Street, Cambridge

Department of Natural Sciences, Tromsø University Museum, Tromsø Norway

Department of Organismal Biology and Anatomy, University of Chicago

Department of Wildlife Ecology and Conservation, University of Florida

Division of Zoology, Research Centre for Biology-LIPI

Ecology and Evolutionary Biology, State University of New York; New York State Museum

Ecology Group, Institute of Natural Resources, Massey University

Environment and Climate Change Canada, Wildlife Research Division

Erotylidae expert 1956

Film preservation, conservation, digitization service.

First name is unknown

Florida EPA

Former resident of Fairbanks, AK

From website: The Calista Elders Council (CEC) is a non-profit organization representing the 1,300 Yup'ik tradition bearers of the Yukon-Kuskokwim delta in southwest Alaska. It is the major research organization for the region, including a population of more than 20,000, and is active in documenting the traditional knowledge of the Yup'ik people. CEC was established in 1991 as a non-profit organization by Calista (the profit corporation for the Yukon-Kuskokwim delta).

Gensis Solar Operations, a solar farm company

grad student of David Blackburn, UF 2021-

grad student, UNC Greensboro

Graduate student at Oregon State University

graduate student at UTEP 2015-

graduate student at UTEP 2020-

Grantová Agentura České Republiky

Harvard University MCZ

herbarium curator at NMSU

herbarium volunteer at UTEP 2021-

herp collector helping Bob Hansen

herpetologist

herpetologist from FL and VA, died in 2019

https://erc.europa.eu/

Hymenopterist, UT, 2021

In field with Bradley, 1963

Informatics Institute, University of Florida

John E. Jolly's wife per APSU

J. S. D.-Egg Collector

Kenai, AK 2021

KU

Latridiidae expert 1970s-1980s

Lichen systematics; chemotaxonomy and floristics; the genera Lecanora and Ramalina; lichen collection management

malacologist at MCZ

malacologist at the MCZ

Manager of UNM Metoritic Collection

McMaster Ancient DNA Centre, Departments of Anthropology and Biochemistry, McMaster University'

McMaster Ancient DNA Centre, Departments of Anthropology and Biochemistry, McMaster University; 2Department of Biology, McMaster University

McMaster Ancient DNA Centre, Departments of Anthropology and Biochemistry, McMaster University; Department of Biochemistry, McMaster University

MMNH contact

MSB DGR volunteer

MSB Division of Mammals volunteer

MSB:Herp

MSB:Herp collected with Roger Conant

MSB:Herp collected with Roger Conant 1940's

MSB:Herp UNM student in 1977

MSUMZ

Museu de Ciencies Naturals, Catalonia, Spain

MVZ and IB PhD student at UC Berkeley, ca. 2019-

MVZ Curatorial Assistant, Fall 2021

MVZ Curatorial Assistant in Herpetology 2021- , MVZ URAP Spring 2021.

MVZ Curatorial Assistant in Herpetology Fall 2021-

MVZ Mammal undergrad and postbaccalaureate volunteer, 2021-present

MVZ PhD student 2018-

MVZ undergrad 2020-2021

MVZ undergrad 2021-

National Museum, MN/UFRJ, Brazil

Natural History Museum, London, UK

Natural History Museum, University of Oslo, Oslo, Norway

naturalist historian?

NCWRC contact

NHSM bulkload agent

NHSM contact

NMMNHS agent

Ohio Wesleyan University

Ohio Wesleyan University Class of 2013

Opened in 1959 by South African Association for Marine Biological Research (SAAMBR)

Paleoartist

paleontologist, Head of Museum of Natural History

Parks Canada

perhaps Abah G. Dorr

Peruvian student of Pierre-Henri Fabre

Ph.D. Student at The City University of New York & The New York Botanical Garden

PhD Student - CIBIO - Research Centre in Biodiversity and Genetic Resources University of Porto, Instituto de Ciencias Agrarias de Vairao, Portugal

postdoc and Chicago Field Museum

postdoc for oVert at UF

Postdoc, Sudmant lab, UC Berkeley, 2020-

preparator at the Rubin Center

Professor at National Institute for Research in the Amazon

Professor, Department of Biodiversity, Earth & Environmental Science, Drexel University; Pilsbry Chair of Malacology, ANS

Professor, Integrative Biology UC Berkeley. 1 July 2018 -

Resident of Dixon, California

Rhododendron curator at Holden Arboretum

Royal Botanic Garden Edinburgh

Rua de Zurique 3, 4485-790 Vila Chã, Portugal

School of GeoSciences, University of Edinburgh, Grant Institute, Edinburgh

Sitka, AK resident 2020

Skunk Crew

student of Gunther Kohler, from Costa Rica

student of Kate Teeter at Northern Michigan University

Texas A&M Fishes

Texas Tech Master's student mammalogy

The Amos Rehabilitation Keep, or ARK, rehabilitates marine turtles and marine birds from the coastal zone of Mustang Island and St. Joseph Island.

The father of Katherine Noble-Goodman

The Illinois Audubon Society was organized as an independent, state-wide, educational and scientific organization, incorporated April 10, 1897, by the State of Illinois.

The Ministry of Science and Innovation, department of the Spanish Government

The only documented individual to be struck by a meteorite and live to tell about it.

The Richard Gilder Graduate School and Department of Ornithology, American Museum of Natural History; Department of Ecology, Evolution, and Environmental Biology, Columbia University

This agent is created to denote any NMU student mammal preparator.

TMCC contact

UAB Professor Emeritus

UAM Ethnology & History

UAM Ethnology & History;

UAM Ethnology & History; a shaman of Qissunaq

UAM Ethnology & History; Chief of Nulato; assisted with William Healey Dall's expeditions for the Western Union Telegraph Expedition of 1866-1868

UAM Ethnology & History; Conservator

UAM Ethnology & History; Otis Ahkivgak was born in 1891 in Wainwright, Alaska, but lived along the northern Beaufort Sea coast. Typical of Inupiaq families at that time, they moved around a lot following the seasons and available food sources. Starting in 1902, after a measles epidemic, the family spent winters at Flaxman Island. Otis grew up hunting for caribou, seals, and polar bear, setting nets for fish, reindeer herding, and trapping foxes. Otis whaled with Taaqpak at Cross Island, and married his daughter, Mary. They moved to Barrow, Alaska about 1938. Otis loved to go whaling and considered Taaqpak his great teacher. From a lifetime of subsistence activity, Otis developed a great knowledge of the ice conditions both along the Beaufort Sea coastline and around Barrow. Eventually, Otis took over Taaqpak’s whaling crew as Taaqpak became too old to keep whaling. The Ahkivgak Crew continues to whale in Barrow. After Mary Ahkivgak died, Otis married Olive. Otis Ahkivgak died December 24, 1980; he was 89 years old. For more about Otis Ahkivgak, see Qiñiqtuagaksrat Utuqqanaat Iñuuniaġniŋisiqun: The Traditional Land Use Inventory for the Mid-Beaufort Sea, Volume 1. (Barrow, AK: North Slope Borough, Commission on History and Culture, 1980).

UAM Ethnology & History; student curatorial assistant (2011-2012)

UAM ethnology & history; tool manufacturer

UAMN Earth Sciences Graduate Student

undergraduate georeferencer 2021-

undergraduate georeferencer 2021-2021

undergraduate volunteer at UTEP Biodiversity Collections 2021-

undergraduate volunteer for the UTEP Biodiversity Collections 2021-

Univ. AK Museum lab tech 2021

Univ. Alaska Anchorage undergraduate 2020

University of Alaska Fairbanks (UAF) Zooarchaeology Laboratory Collection Manager

University of Colorado Museum and Field Studies Graduate Assistant (Fall 2021- ), Vertebrate Collections

University of Kentucky Veterinary Parasitology

, University of Miami Miller School of Medicine

University of North Carolina Wilmington

University of Tasmania (PhD student)

UNM Biology Master's student

UWZM Staff 2015-present; CU Museum & Field Studies Student 2013-2015.

volunteer for the UTEP herpetology collections

Wasilla, AK resident 2021

Wildlife Conservation Society

Zoological Institute of Russian Academy of Science, 1 Universitetskaya Emb., St. Petersburg 199034, Russia

— 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/3918#issuecomment-919214517, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADQ7JBCAESCK3X4ZLJUWLITUB5M4VANCNFSM5D2BCAHA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

operator status

Unrelated to this issue.

Cultural collections regularly use the remarks field to deposit biographical summaries, which might include duplicate information that is extracted and placed into relationships or other fields below, including dob & dod. It's a much nicer way to demonstrate the distinction between two individuals who might have the same name. It might be easier to list these multiple jobs, etc. if the remarks field could use mark down, like the projects summary box (particularly the paragraph function). It would allow long biographical summaries to be more easily read in the agent summary page, plus it could allow for lists of jobs under the same institution. Just a thought and something I think I've asked for in the past. (See example listed here: https://arctos.database.museum/agents.cfm?agent_id=21334327)

@AJLinn I think that deserves it's own issue!

A nice summary of duplicate info is definitely not a problem, but some of this sorta sounds like a request for UI updates??

If we ever wanted to DO anything with place-data, the "address" (Wainwright, Alaska) in status remarks would not be available. (That might even mean some structure's not quite right??)

distinction between two individuals

https://arctos.database.museum/info/ctDocumentation.cfm?table=ctagent_relationship#not_the_same_as is a completely unambiguous way to do that.

https://github.com/ArctosDB/arctos/issues/1508 looks like it could use a poke.

https://arctos.database.museum/info/ctDocumentation.cfm?table=ctagent_relationship#not_the_same_as is a completely unambiguous way to do that.

Yup, and I know I've done that on at least a handful (of course I can't find any now). Place data associated with agents is an important distinguishing element as well and I've struggled over the years on how to indicate that. "Shipping Address" or "Correspondence Address" don't seem quite right, though I've used them. And people move around so listing the locations and dates in the remarks field is the only way I've really dealt with this, other than dob/dod and adding locations. I guess I could put "alive" and the locations with dates?

don't seem quite right

Agree - https://github.com/ArctosDB/arctos/issues/new?assignees=&labels=Function-CodeTables&template=authority-request.md&title=Code+Table+Request+-+

people move around

Yea, that's what I was starting to understand above.


arctosprod@arctos>> \d address;
                                           Table "core.address"
     Column     |            Type             | Collation | Nullable |              Default               
----------------+-----------------------------+-----------+----------+------------------------------------
 ...
 valid_addr_fg  | integer                     |           | not null | 
...

might be better as


arctosprod@arctos>> \d address;
                                           Table "core.address"
     Column     |            Type             | Collation | Nullable |              Default               
----------------+-----------------------------+-----------+----------+------------------------------------
 ...
 start_date
stop_date
...

er sumthin. What we have now works just fine for "don't mail me there" but not so great for more agent history type things.

https://github.com/ArctosDB/arctos/issues/new?assignees=&labels=Enhancement&template=feature_request.md&title=Feature+Request+-+

Place data associated with agents is an important distinguishing element as well and I've struggled over the years on how to indicate that. "Shipping Address" or "Correspondence Address" don't seem quite right.

There is also a home address

None of the address fields really feel appropriate for just indicating the community/-ies an individual lived at. "Savoonga, St. Lawrence Island" is not really a mailing, personal mailing, or shipping address but does mean a lot if you're trying to discern a John Smith who is an ivory carver vs. a John Smith who carves cedar bentwood boxes (in Metlakatla).

Do those mailing/shipping addresses show up in the agent summary page for the public view?

lived at.

Sounds like "home" to me, but still no strong feelings. The docs should be updated if we go there (and maybe if we don't) - maybe that's what's pushing data towards remarks.

Metlakatla

https://www.geo-locate.org/web/WebGeoref.aspx is a good place to figure out what's useful (for machines, and that's at least part of the reason you might want to use address instead of remarks). "Metlakatla" doesn't do anything very interesting, but "Metlakatla, Alaska" does. https://github.com/ArctosDB/arctos/issues/2657 - not sure where that's going to end up, but if geolocate can figure it out then other things will probably be able to as well.

public view

Nope.

address.address_type in ('url','ORCID','Wikidata') and

https://arctos.database.museum/info/ctDocumentation.cfm?table=ctaddress_type should be updated to reflect that.

https://arctos.database.museum/guid/ALMNH:Geo:20 makes me want to include agent remarks on catalog record pages....

Instead - how about she gets highlighted on Twitter - https://arctos.database.museum/agent/21332181 or maybe gets some kind of "Hey check this out" next to her name?

1979 Elateridae expert

Cool to somehow connect this to taxonomy?

@dustymc I think what you are getting at here - https://github.com/ArctosDB/arctos/issues/3918#issuecomment-919337388 is that every address should just have a start and end date, but they can also be left NULL? I think this makes a great deal of sense.

connect this to taxonomy?

I'm guessing that's a whole lot of work for very little benefit, but I don't think it's completely off the table either. We could definitely exploit more existing connections - "made count-by-some-taxon-rank IDs" or similar should be relatively straightforward, for example.

every address should just have a start and end date, but they can also be left NULL

Something like that, although overly simple implementations would lead to fun things like inverted time and functional values "not yet" and "we refuse to say" - so probably not exactly that. Issue, should anyone want to explore....

Table reindexed, data cleaned up, better checks implemented.

ArctosDB / arctos

Agents cannot have multiple relationships with another agent #3918