Agents cannot have multiple relationships with another agent

[Jegelewicz]

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

[ewommack]

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.

[dustymc]

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

[campmlc]

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 <#3918 (comment)>, 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>.

[dustymc]

operator status

Unrelated to this issue.

[AJLinn]

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)

[Jegelewicz]

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

[dustymc]

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.

#1508 looks like it could use a poke.

[AJLinn]

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?

[dustymc]

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+-+

[Jegelewicz]

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

[AJLinn]

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?

[dustymc]

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. #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.

[Jegelewicz]

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

Done

[dustymc]

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

[Jegelewicz]

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?

[Jegelewicz]

1979 Elateridae expert

Cool to somehow connect this to taxonomy?

[Jegelewicz]

@dustymc I think what you are getting at here - #3918 (comment)
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.

[dustymc]

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....

[dustymc]

Table reindexed, data cleaned up, better checks implemented.