Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

collections as agents #5327

Closed
dustymc opened this issue Dec 2, 2022 · 22 comments
Closed

collections as agents #5327

dustymc opened this issue Dec 2, 2022 · 22 comments
Labels
Help wanted I have a question on how to use Arctos Priority - Wildfire Potential ignore this at everyone's peril, may smolder for now ...

Comments

@dustymc
Copy link
Contributor

dustymc commented Dec 2, 2022

GBIF's GUM model treats collections as agents (yay, I think...) and the idea has come up a few times locally (eg for printing loan forms). There's no decent connection between those things in Arctos, and there needs to be if we're going to make hard links between them.

https://arctos.database.museum/agent/21334582 (and it alone) includes the collection identifier, but as a url. I can PROBABLY make the connection with that, but there's lots of potential for confusion (eg, people might use the same identifier for their employer). I think we need a new focused address type. For just my immediate needs that could be "collectionID" and constrained to starting with https://arctos.database.museum/collection/, but that also seems somewhat likely to lead to an unmanageable proliferation of identifiers. Is there any reason to make that a bit more general, or somehow shaped differently, or ?????

I was going to ask @lkvoong to create these as part of collection setup, but I think many (maybe most) will already exist, but not in forms that will be easy to detect, so I think this, if we adopt it, will need to be a part of come manual setup process. Eg https://arctos.database.museum/agent/21334675 is probably https://arctos.database.museum/collection/MVZ:Herp but I don't see anything at all that would let machines make that connection.

Help!

@dustymc dustymc added Function-ExternalLinks Help wanted I have a question on how to use Arctos labels Dec 2, 2022
@dustymc dustymc added this to the Needs Discussion milestone Dec 2, 2022
@mkoo
Copy link
Member

mkoo commented Dec 2, 2022

I see a dedicated addresstype that only Arctos can access and use upon collection creation as a necessary part of this equation. I hesitate to mention (because it's not the answer to everything) but this is a case where an external resolver like DOI would be appropriate for each collection -- so you can have your https://arctos.database.museum/collection/ and local https://arctos.database.museum/agent/21334675 too

I'm still a lot unclear how the GBIF GUM handles these collection agents if not just as Institution_cde?

@dustymc
Copy link
Contributor Author

dustymc commented Dec 2, 2022

how the GBIF GUM

https://github.com/gbif/model-material/blob/master/schema.sql

"collection_id TEXT PRIMARY KEY REFERENCES agent"==="these are agents with weird metadata for some reason"


-- Collection (see Latimer Core)
--   A subtype of Agent
--   An organizational agent that maintains Entities.
--   Exactly one Global Registry of Science Collections (GRSciColl) identifier.

CREATE TABLE collection (
  collection_id TEXT PRIMARY KEY REFERENCES agent ON DELETE CASCADE,
  collection_type TEXT,
  collection_code TEXT, -- also on MaterialEntity
  institution_code TEXT, -- also on MaterialEntity
  grscicoll_id UUID NOT NULL
);

@mkoo
Copy link
Member

mkoo commented Dec 2, 2022

ahh, so is there anything we should be storing from GRSciColl? Maybe that's our key too? yea and it's too early for me to look at sql... (MOUs or bust for me)

@dustymc
Copy link
Contributor Author

dustymc commented Dec 2, 2022

storing from GRSciColl?

That still seems like me refusing to call you Michelle and insisting I mint and use my own identifier for you (hi @generateUUID()!), but we seem to keep getting kicked in that direction so probably. And I still don't know what grscicoll can possibly DO (I'd change my mind if they'd get NCBI to adopt them and read data - of course including our identifiers - from our EML files) so I'm not seeing much reason we'd care, but there seems to be some sort of JUST BECAUSE view so again maybe-probably.

Ugh.

@campmlc
Copy link

campmlc commented Dec 2, 2022 via email

@campmlc
Copy link

campmlc commented Dec 2, 2022

And yes, I agree with adding whatever GRSciColl assigns as an alternate id or address.

@Jegelewicz
Copy link
Member

will need to be a part of come manual setup process.

It is currently part of the new collection creation process, but I will check to make sure it is formal and includes the addition of whatever identifier we decide upon. I think using the GRSciColl ID makes sense - MVZ:herp = https://registry.gbif.org/collection/dc806805-f05c-4a09-9d58-78743a9e8cd6

@Jegelewicz
Copy link
Member

Also, currently, iDigBio gets their collection info from GRSciColl. Baby steps

@dustymc
Copy link
Contributor Author

dustymc commented Dec 3, 2022

using the GRSciColl ID makes sense

I just need to get from Arctos Agents to Arctos Collections.....

@Jegelewicz
Copy link
Member

There are some Arctos collections that are NOT in GRSciColl - that is part of what I plan to remedy with them and this reconciliation.

@dustymc
Copy link
Contributor Author

dustymc commented Dec 14, 2022

I probably should have brought this up at the agents meeting, but I didn't.

I need these data.

I don't want our intro to the GUM to involve a big gap on the thing that EVERYTHING else touches, so I don't really want to fake it.

I don't want to create a few hundred duplicates, at at least some of these exist.

I still don't have the slightest inkling of a clue how this is related to GRSciColl (and I'm hoping to be pleasantly surprised?).

I guess I'll create address_type collectionID and spend however long it takes to round up all existing collection-agents and add some new address type?

@dustymc dustymc added the Priority - Wildfire Potential ignore this at everyone's peril, may smolder for now ... label Dec 14, 2022
@Jegelewicz
Copy link
Member

Jegelewicz commented Dec 14, 2022

I just started working on this (creating agents for all collections) so I can work it up, wipe out dupes, and add the new identifier. Can I have tomorrow to get it done?

@dustymc
Copy link
Contributor Author

dustymc commented Dec 15, 2022

That would be fabulous and way faster than I had any hope of doing anything. I made collectionID and will try to get it trigger-protected before anything interesting happens.

@Jegelewicz
Copy link
Member

I made collectionID

Because there can be multiple kinds of IDs, should we make this one specific (GRSciColl ID), or is identifying it in the remark good enough? Eventually, this is going to get caught up in #5172.

While I am at this, I could very easily add GBIF Publisher ID and Arctos ID

@campmlc
Copy link

campmlc commented Dec 15, 2022 via email

@dustymc
Copy link
Contributor Author

dustymc commented Dec 15, 2022

make this one specific

Yes.

GRSciColl ID

Now I'm lost again. Can you type real slow, use small words, and explain to me what that has to do with anything and why it seems to be effectively blocking this?

If I'm somehow being unclear - well, see the documentation, I need things like https://arctos.database.museum/collection/MVZ:Herp, because I need to join to that and pull some data into an agent-object.

very easily add GBIF Publisher ID

Address should work for that.

and Arctos ID

And we're lost again....

@Jegelewicz
Copy link
Member

I need things like https://arctos.database.museum/collection/MVZ:Herp

That's the Arctos ID

Can you type real slow, use small words, and explain to me what that has to do with anything and why it seems to be effectively blocking this?

Every collection has lots of identifiers. Some are aka (like MVZ:Mamm) and now we are adding "collection ID" - which is really the Arctos collection ID as an address.

But this particular collection has a couple of other known identifiers:

Museum of Vertebrate Zoology Mammal Collection
Museum of Vertebrate Zoology Mammal specimens
MVZ:Mamm
https://arctos.database.museum/collection/MVZ:Herp
https://registry.gbif.org/collection/cd251b9b-bfa1-40be-b303-d89e54a2513d
https://www.gbif.org/dataset/0daed095-478a-4af6-abf5-18acb790fbb2

My point is, I can add what you need, but I can also add the other while I'm in there. Should these bottom two also be collectionID with the appropriate remark or should I have new address types for them. I see from the definition that you are expecting an Arctos url, so I guess that answers my question - BUT I feel like this could use a little more thought and discussion because as we are constantly putting out "wildfires", I fear we just create future messes.

@ArctosDB/arctos-code-table-administrators

@dustymc
Copy link
Contributor Author

dustymc commented Dec 15, 2022

Should these bottom two also be collectionID with the appropriate remark

I dropped what I was doing and added the promised constraint so they can't be.

Should these bottom two

As far as I know those don't do anything so url seems a more than adequate home for them.

I feel like this could use a little more thought and discussion

Not sure how, there are a bunch of reasons (this, pulling addresses to print loans, etc.) to make the connection and a fairly-obvious way to do so. If the mechanism is wrong then it's still functional and we can use it to do whatever needs done. I'll be fairly surprised if this turns out to be some sort of problem.

If you're talking about the other stuff, I'm still not sure why that got drug in here.

@Jegelewicz
Copy link
Member

I think I have added agents with a collectionID for all collections. BUT I am pretty sure some are missing because they have 0 records. @dustymc please write some SQL that will get me a list of all agents with a collectionID, then I can see if any are missing.

@dustymc
Copy link
Contributor Author

dustymc commented Dec 15, 2022

select guid_prefix,address,getPreferredAgentName(address.agent_id) from collection left outer join address on guid_prefix=replace(address,'https://arctos.database.museum/collection/','') and address_type='collectionID' order by guid_prefix;

  guid_prefix  |                         address                         |                                         getpreferredagentname                                         
---------------+---------------------------------------------------------+-------------------------------------------------------------------------------------------------------
 ACUNHC:Bird   | https://arctos.database.museum/collection/ACUNHC:Bird   | Abilene Christian University Bird Collection
 ACUNHC:Ento   | https://arctos.database.museum/collection/ACUNHC:Ento   | Abilene Christian University Insect Collection
 ACUNHC:Fish   | https://arctos.database.museum/collection/ACUNHC:Fish   | Abilene Christian University Fish Collection
 ACUNHC:Herp   | https://arctos.database.museum/collection/ACUNHC:Herp   | Abilene Christian University Amphibian and Reptile Collection
 ACUNHC:Inv    | https://arctos.database.museum/collection/ACUNHC:Inv    | Abilene Christian University Marine Invertebrate Collection
 ACUNHC:Mamm   | https://arctos.database.museum/collection/ACUNHC:Mamm   | Abilene Christian University Mammal Collection
 ACUNHC:Paleo  | https://arctos.database.museum/collection/ACUNHC:Paleo  | Abilene Christian University Fossil Collection
 ALMNH:Anc     | https://arctos.database.museum/collection/ALMNH:Anc     | Alabama Museum of Natural History Ancillary Collection
 ALMNH:Arc     | https://arctos.database.museum/collection/ALMNH:Arc     | Alabama Museum of Natural History Archaeology Collection
 ALMNH:Bird    | https://arctos.database.museum/collection/ALMNH:Bird    | Alabama Museum of Natural History Bird Collection
 ALMNH:EH      | https://arctos.database.museum/collection/ALMNH:EH      | Alabama Museum of Natural History History and Ethnology Collection
 ALMNH:Ento    | https://arctos.database.museum/collection/ALMNH:Ento    | Alabama Museum of Natural History Insect Collection
 ALMNH:ES      |                                                         | 
 ALMNH:Geo     | https://arctos.database.museum/collection/ALMNH:Geo     | Alabama Museum of Natural History Geology Collection
 ALMNH:Herp    | https://arctos.database.museum/collection/ALMNH:Herp    | Alabama Museum of Natural History Amphibian and Reptile Collection
 ALMNH:Inv     | https://arctos.database.museum/collection/ALMNH:Inv     | Alabama Museum of Natural History Invertebrate Zoology Collection
 ALMNH:Mamm    | https://arctos.database.museum/collection/ALMNH:Mamm    | Alabama Museum of Natural History Mammal Collection
 ALMNH:Paleo   | https://arctos.database.museum/collection/ALMNH:Paleo   | Alabama Museum of Natural History Paleontology Collection
 APSU:Bird     | https://arctos.database.museum/collection/APSU:Bird     | Austin Peay State University Bird Collection
 APSU:Fish     | https://arctos.database.museum/collection/APSU:Fish     | Austin Peay State University Fish Collection
 APSU:Herp     | https://arctos.database.museum/collection/APSU:Herp     | Austin Peay State University Amphibian and Reptile Collection
 APSU:Mamm     | https://arctos.database.museum/collection/APSU:Mamm     | Austin Peay State University Mammal Collection
 Arctos:Entity | https://arctos.database.museum/collection/Arctos:Entity | Arctos Entity Collection
 ASNHC:Bird    | https://arctos.database.museum/collection/ASNHC:Bird    | Angelo State Natural History Collections Bird Collection
 ASNHC:Herb    |                                                         | 
 ASNHC:Herp    | https://arctos.database.museum/collection/ASNHC:Herp    | Angelo State Natural History Collections Amphibian and Reptile Collection
 ASNHC:Mamm    | https://arctos.database.museum/collection/ASNHC:Mamm    | Angelo State Natural History Collections Mammal Collection
 ASNHC:Para    | https://arctos.database.museum/collection/ASNHC:Para    | Angelo State Natural History Collections Parasite Collection
 ASUMZ:Bird    | https://arctos.database.museum/collection/ASUMZ:Bird    | Arkansas Center for Biodiversity Collections Bird Collection
 ASUMZ:Bivalve | https://arctos.database.museum/collection/ASUMZ:Bivalve | Arkansas Center for Biodiversity Collections Bivalve Collection
 ASUMZ:Ento    | https://arctos.database.museum/collection/ASUMZ:Ento    | Arkansas Center for Biodiversity Collections Insect Collection
 ASUMZ:Fish    | https://arctos.database.museum/collection/ASUMZ:Fish    | Arkansas Center for Biodiversity Collections Fish Collection
 ASUMZ:Herp    | https://arctos.database.museum/collection/ASUMZ:Herp    | Arkansas Center for Biodiversity Collections Amphibian and Reptile Collection
 ASUMZ:Invert  | https://arctos.database.museum/collection/ASUMZ:Invert  | Arkansas Center for Biodiversity Collections Aquatic Macroinvertebrate Collection
 ASUMZ:Mamm    | https://arctos.database.museum/collection/ASUMZ:Mamm    | Arkansas Center for Biodiversity Collections Mammal Collection
 BYU:Bird      | https://arctos.database.museum/collection/BYU:Bird      | Brigham Young University Life Science Museum Bird Collection
 BYU:Edu       |                                                         | 
 BYU:Fish      | https://arctos.database.museum/collection/BYU:Fish      | Brigham Young University Life Science Museum Fish Collection
 BYU:Herp      | https://arctos.database.museum/collection/BYU:Herp      | Brigham Young University Life Science Museum Amphibian and Reptile Collection
 BYU:Mamm      | https://arctos.database.museum/collection/BYU:Mamm      | Brigham Young University Life Science Museum Mammal Collection
 BYUObs:Bird   | https://arctos.database.museum/collection/BYUObs:Bird   | Brigham Young University Life Science Museum Bird Observations Collection
 BYUObs:Herp   | https://arctos.database.museum/collection/BYUObs:Herp   | Brigham Young University Life Science Museum Amphibian and Reptile Observations Collection
 BYUObs:Mamm   | https://arctos.database.museum/collection/BYUObs:Mamm   | Brigham Young University Life Science Museum Mammal Observations Collection
 BYU:Teach     | https://arctos.database.museum/collection/BYU:Teach     | Brigham Young University Life Science Museum Teaching Collection
 CDSC:Arch     | https://arctos.database.museum/collection/CDSC:Arch     | California Desert Studies Center Archaeology Collection
 CDSC:Bird     | https://arctos.database.museum/collection/CDSC:Bird     | California Desert Studies Center Bird Collection
 CDSC:Ento     | https://arctos.database.museum/collection/CDSC:Ento     | California Desert Studies Center Insect Collection
 CDSC:Geol     | https://arctos.database.museum/collection/CDSC:Geol     | California Desert Studies Center Geology Collection
 CDSC:Herb     | https://arctos.database.museum/collection/CDSC:Herb     | California Desert Studies Center Herbarium
 CDSC:Herp     | https://arctos.database.museum/collection/CDSC:Herp     | California Desert Studies Center Amphibian and Reptile Collection
 CDSC:Inv      | https://arctos.database.museum/collection/CDSC:Inv      | California Desert Studies Center Invertebrate Collection
 CDSC:Mamm     | https://arctos.database.museum/collection/CDSC:Mamm     | California Desert Studies Center Mammal Collection
 CHAS:Art      | https://arctos.database.museum/collection/CHAS:Art      | Chicago Academy of Sciences Art Collection
 CHAS:Bird     | https://arctos.database.museum/collection/CHAS:Bird     | Chicago Academy of Sciences Bird Collection
 CHAS:Egg      | https://arctos.database.museum/collection/CHAS:Egg      | Chicago Academy of Sciences Bird Eggs Collection
 CHAS:EH       | https://arctos.database.museum/collection/CHAS:EH       | Chicago Academy of Sciences Ethnology and History Artifacts Collection
 CHAS:Ento     | https://arctos.database.museum/collection/CHAS:Ento     | Chicago Academy of Sciences Insect Collection
 CHAS:ES       | https://arctos.database.museum/collection/CHAS:ES       | Chicago Academy of Sciences Earth Science Collection
 CHAS:Fish     | https://arctos.database.museum/collection/CHAS:Fish     | Chicago Academy of Sciences Fish Collection
 CHAS:Herb     | https://arctos.database.museum/collection/CHAS:Herb     | Chicago Academy of Sciences Plant Collection
 CHAS:Herp     | https://arctos.database.museum/collection/CHAS:Herp     | Chicago Academy of Sciences Amphibian and Reptile Collection
 CHAS:Inv      | https://arctos.database.museum/collection/CHAS:Inv      | Chicago Academy of Sciences Mollusc Collection
 CHAS:Mamm     | https://arctos.database.museum/collection/CHAS:Mamm     | Chicago Academy of Sciences Mammal Collection
 CHAS:Teach    | https://arctos.database.museum/collection/CHAS:Teach    | Chicago Academy of Sciences Teaching Collection
 COA:Bird      | https://arctos.database.museum/collection/COA:Bird      | College of the Atlantic, George B. Dorr Museum of Natural History Bird Collection
 COA:Egg       | https://arctos.database.museum/collection/COA:Egg       | College of the Atlantic, George B. Dorr Museum of Natural History Bird Eggs Collection
 COA:Ento      | https://arctos.database.museum/collection/COA:Ento      | College of the Atlantic, George B. Dorr Museum of Natural History Insect Collection
 COA:Herp      | https://arctos.database.museum/collection/COA:Herp      | College of the Atlantic, George B. Dorr Museum of Natural History Amphibian and Reptile Collection
 COA:Mamm      | https://arctos.database.museum/collection/COA:Mamm      | College of the Atlantic, George B. Dorr Museum of Natural History Mammal Collection
 COA:Rept      |                                                         | 
 CRCM:Bird     | https://arctos.database.museum/collection/CRCM:Bird     | Charles R. Conner Museum Bird Collection
 CRCM:Fish     | https://arctos.database.museum/collection/CRCM:Fish     | Charles R. Conner Museum Fish Collection
 CRCM:Herp     | https://arctos.database.museum/collection/CRCM:Herp     | Charles R. Conner Museum Amphibian and Reptile Collection
 CRCM:Mamm     | https://arctos.database.museum/collection/CRCM:Mamm     | Charles R. Conner Museum Mammal Collection
 CRCM:Paleo    | https://arctos.database.museum/collection/CRCM:Paleo    | Charles R. Conner Museum Fossil Collection
 CRCM:Teach    | https://arctos.database.museum/collection/CRCM:Teach    | Charles R. Conner Museum Teaching Collection
 CSULB:Bird    | https://arctos.database.museum/collection/CSULB:Bird    | California State University, Long Beach Bird Collection
 CSULB:Fish    | https://arctos.database.museum/collection/CSULB:Fish    | California State University, Long Beach Fish Collection
 CSULB:Herp    | https://arctos.database.museum/collection/CSULB:Herp    | California State University, Long Beach Amphibian and Reptile Collection
 CSULB:Mamm    | https://arctos.database.museum/collection/CSULB:Mamm    | California State University, Long Beach Mammal Collection
 DGR:Bird      |                                                         | 
 DGR:Ento      |                                                         | 
 DGR:Mamm      |                                                         | 
 DMNS:Bird     | https://arctos.database.museum/collection/DMNS:Bird     | Denver Museum of Nature and Science Bird Collection
 DMNS:Egg      | https://arctos.database.museum/collection/DMNS:Egg      | Denver Museum of Nature and Science Bird Eggs/Nests Collection
 DMNS:Herp     | https://arctos.database.museum/collection/DMNS:Herp     | Denver Museum of Nature and Science Amphibian and Reptile Collection
 DMNS:Inv      | https://arctos.database.museum/collection/DMNS:Inv      | Denver Museum of Nature and Science Marine Invertebrate Collection
 DMNS:Mamm     | https://arctos.database.museum/collection/DMNS:Mamm     | Denver Museum of Nature and Science Mammal Collection
 DMNS:Para     | https://arctos.database.museum/collection/DMNS:Para     | Denver Museum of Nature and Science Parasite Collection
 HMCM:Arthro   | https://arctos.database.museum/collection/HMCM:Arthro   | Huron Mountain Club Museum Invertebrate Collection
 HMCM:Bird     | https://arctos.database.museum/collection/HMCM:Bird     | Huron Mountain Club Museum Bird Collection
 HMCM:Geo      | https://arctos.database.museum/collection/HMCM:Geo      | Huron Mountain Club Museum Geology Collection
 HMCM:Herb     | https://arctos.database.museum/collection/HMCM:Herb     | Huron Mountain Club Museum Herbarium Collection
 HMCM:Herp     | https://arctos.database.museum/collection/HMCM:Herp     | Huron Mountain Club Museum Amphibian and Reptile Collection
 HMCM:Mamm     | https://arctos.database.museum/collection/HMCM:Mamm     | Huron Mountain Club Museum Mammal Collection
 HSUVM:Amph    | https://arctos.database.museum/collection/HSUVM:Amph    | Cal Poly Humboldt Vertebrate Museum Amphibian Collection
 HSUVM:Mamm    | https://arctos.database.museum/collection/HSUVM:Mamm    | Cal Poly Humboldt Vertebrate Museum Mammal Collection
 HSUVM:Rept    | https://arctos.database.museum/collection/HSUVM:Rept    | Cal Poly Humboldt Vertebrate Museum Reptile Collection
 HWML:Para     | https://arctos.database.museum/collection/HWML:Para     | University of Nebraska State Museum, Howard Manter Parasite Laboratory
 JFBM:Fish     | https://arctos.database.museum/collection/JFBM:Fish     | Bell Museum of Natural History Fish Collection
 JFBM:Herp     | https://arctos.database.museum/collection/JFBM:Herp     | Bell Museum of Natural History Amphibian and Reptile Collection
 JFBM:Inv      | https://arctos.database.museum/collection/JFBM:Inv      | Bell Museum of Natural History Invertebrate Collection
 JSNM:Egg      | https://arctos.database.museum/collection/JSNM:Egg      | Jurica-Suchy Nature Museum at Benedictine University Egg Collection
 JSNM:Herb     |                                                         | 
 JSNM:Paleo    | https://arctos.database.museum/collection/JSNM:Paleo    | Jurica-Suchy Nature Museum at Benedictine University Fossil Collection
 KNWR:Ento     | https://arctos.database.museum/collection/KNWR:Ento     | Kenai National Wildlife Refuge, Alaska Insect Collection
 KNWR:Env      | https://arctos.database.museum/collection/KNWR:Env      | Kenai National Wildlife Refuge, Alaska Environmental Samples Collection
 KNWR:Herb     | https://arctos.database.museum/collection/KNWR:Herb     | Kenai National Wildlife Refuge, Alaska Plant Collection
 KNWR:Inv      | https://arctos.database.museum/collection/KNWR:Inv      | Kenai National Wildlife Refuge, Alaska Invertebrate Collection
 KNWRObs:Bird  | https://arctos.database.museum/collection/KNWRObs:Bird  | Kenai National Wildlife Refuge, Alaska Bird Observations Collection
 KNWRObs:Fish  | https://arctos.database.museum/collection/KNWRObs:Fish  | Kenai National Wildlife Refuge, Alaska Fish observations Collection
 KNWRObs:Herb  | https://arctos.database.museum/collection/KNWRObs:Herb  | Kenai National Wildlife Refuge, Alaska Plant Observations Collection
 KNWRObs:Mamm  |                                                         | 
 KWP:Ento      | https://arctos.database.museum/collection/KWP:Ento      | Kenelm W. Philip Lepidoptera Collection
 LINGU:Herp    | https://arctos.database.museum/collection/LINGU:Herp    | Lingnan University Amphibian and Reptile Collection
 MLZ:Bird      | https://arctos.database.museum/collection/MLZ:Bird      | Moore Laboratory of Zoology Bird Collection
 MLZ:Egg       | https://arctos.database.museum/collection/MLZ:Egg       | Moore Laboratory of Zoology Bird Eggs/Nests Collection
 MLZ:Fish      | https://arctos.database.museum/collection/MLZ:Fish      | Moore Laboratory of Zoology Fish Collection
 MLZ:Herb      | https://arctos.database.museum/collection/MLZ:Herb      | Moore Laboratory of Zoology Plant Collection
 MLZ:Inv       |                                                         | 
 MLZ:Mamm      | https://arctos.database.museum/collection/MLZ:Mamm      | Moore Laboratory of Zoology Mammal Collection
 MLZObs:Fish   | https://arctos.database.museum/collection/MLZObs:Fish   | Moore Laboratory of Zoology Fish Observations Collection
 MMNH:Bird     | https://arctos.database.museum/collection/MMNH:Bird     | Bell Museum of Natural History Bird Collection
 MMNH:Mamm     | https://arctos.database.museum/collection/MMNH:Mamm     | Bell Museum of Natural History Mammal Collection
 MSB:Bird      | https://arctos.database.museum/collection/MSB:Bird      | Museum of Southwestern Biology, Divison of Birds
 MSB:Fish      | https://arctos.database.museum/collection/MSB:Fish      | Museum of Southwestern Biology, Division of Fishes
 MSB:Herp      | https://arctos.database.museum/collection/MSB:Herp      | Museum of Southwestern Biology, Division of Amphibians and Reptiles
 MSB:Host      | https://arctos.database.museum/collection/MSB:Host      | Museum of Southwestern Biology Host (of parasite) Collection
 MSB:Inv       | https://arctos.database.museum/collection/MSB:Inv       | Museum of Southwestern Biology Invertebrate Collection
 MSB:Mamm      | https://arctos.database.museum/collection/MSB:Mamm      | Museum of Southwestern Biology, Division of Mammals
 MSBObs:Herp   |                                                         | 
 MSBObs:Mamm   | https://arctos.database.museum/collection/MSBObs:Mamm   | Museum of Southwestern Biology Mammal observations Collection
 MSB:Para      | https://arctos.database.museum/collection/MSB:Para      | Museum of Southwestern Biology, Division of Parasites
 MVZ:Arch      |                                                         | 
 MVZ:Bird      | https://arctos.database.museum/collection/MVZ:Bird      | Museum of Vertebrate Zoology Bird Collection
 MVZ:Egg       | https://arctos.database.museum/collection/MVZ:Egg       | Museum of Vertebrate Zoology Eggs and Nests Collection
 MVZ:Fish      | https://arctos.database.museum/collection/MVZ:Fish      | Museum of Vertebrate Zoology Fish Collection
 MVZ:Herp      | https://arctos.database.museum/collection/MVZ:Herp      | Museum of Vertebrate Zoology Amphibian and Reptile Collection
 MVZ:Hild      | https://arctos.database.museum/collection/MVZ:Hild      | Museum of Vertebrate Zoology Anatomical Preparations Collection
 MVZ:Img       |                                                         | 
 MVZ:Mamm      | https://arctos.database.museum/collection/MVZ:Mamm      | Museum of Vertebrate Zoology Mammal Collection
 MVZObs:Bird   | https://arctos.database.museum/collection/MVZObs:Bird   | Museum of Vertebrate Zoology Bird Observations Collection
 MVZObs:Fish   |                                                         | 
 MVZObs:Herp   |                                                         | 
 MVZObs:Mamm   | https://arctos.database.museum/collection/MVZObs:Mamm   | Museum of Vertebrate Zoology Mammal Observations Collection
 NBSB:Bird     | https://arctos.database.museum/collection/NBSB:Bird     | U. S. National Biomonitoring Specimen Bank Bird Collection
 NCWRC:Bird    | https://arctos.database.museum/collection/NCWRC:Bird    | North Carolina Wildlife Resources Commission Bird Collection
 NCWRC:Bivalve | https://arctos.database.museum/collection/NCWRC:Bivalve | North Carolina Wildlife Resources Commission Bivalve Collection
 NCWRC:Crust   | https://arctos.database.museum/collection/NCWRC:Crust   | North Carolina Wildlife Resources Commission Crustacean Collection
 NCWRC:Ento    | https://arctos.database.museum/collection/NCWRC:Ento    | North Carolina Wildlife Resources Commission Insect Collection
 NCWRC:Fish    | https://arctos.database.museum/collection/NCWRC:Fish    | North Carolina Wildlife Resources Commission Fish Collection
 NCWRC:Gastro  | https://arctos.database.museum/collection/NCWRC:Gastro  | North Carolina Wildlife Resources Commission Gastropod Collection
 NCWRC:Herp    | https://arctos.database.museum/collection/NCWRC:Herp    | North Carolina Wildlife Resources Commission Amphibian and Reptile Collection
 NCWRC:Mamm    | https://arctos.database.museum/collection/NCWRC:Mamm    | North Carolina Wildlife Resources Commission Mammal Collection
 NHSM:Arc      | https://arctos.database.museum/collection/NHSM:Arc      | Natural History Society of Maryland Archaeology Collection
 NHSM:Bird     | https://arctos.database.museum/collection/NHSM:Bird     | Natural History Society of Maryland Bird Collection
 NHSM:Ento     | https://arctos.database.museum/collection/NHSM:Ento     | Natural History Society of Maryland Insect Collection
 NHSM:Geol     | https://arctos.database.museum/collection/NHSM:Geol     | Natural History Society of Maryland Geology Collection
 NHSM:Herb     | https://arctos.database.museum/collection/NHSM:Herb     | Natural History Society of Maryland Herbarium
 NHSM:Herp     | https://arctos.database.museum/collection/NHSM:Herp     | Natural History Society of Maryland Amphibian and Reptile Collection
 NHSM:Inv      | https://arctos.database.museum/collection/NHSM:Inv      | Natural History Society of Maryland Invertebrate Collection
 NHSM:Mamm     | https://arctos.database.museum/collection/NHSM:Mamm     | Natural History Society of Maryland Mammal Collection
 NHSM:Paleo    | https://arctos.database.museum/collection/NHSM:Paleo    | Natural History Society of Maryland Fossil Collection
 NMMNH:Bird    | https://arctos.database.museum/collection/NMMNH:Bird    | New Mexico Museum of Natural History and Science Bird Collection
 NMMNH:Ento    | https://arctos.database.museum/collection/NMMNH:Ento    | New Mexico Museum of Natural History and Science Insect Collection
 NMMNH:Fish    | https://arctos.database.museum/collection/NMMNH:Fish    | New Mexico Museum of Natural History and Science Fish Collection
 NMMNH:Geol    | https://arctos.database.museum/collection/NMMNH:Geol    | New Mexico Museum of Natural History and Science Geology Collection
 NMMNH:Herb    | https://arctos.database.museum/collection/NMMNH:Herb    | New Mexico Museum of Natural History and Science Herbarium Collection
 NMMNH:Herp    | https://arctos.database.museum/collection/NMMNH:Herp    | New Mexico Museum of Natural History and Science Amphibian and Reptile Collection
 NMMNH:Inv     | https://arctos.database.museum/collection/NMMNH:Inv     | New Mexico Museum of Natural History and Science Invertebrate Collection
 NMMNH:Mamm    | https://arctos.database.museum/collection/NMMNH:Mamm    | New Mexico Museum of Natural History and Science Mammal Collection
 NMMNH:Paleo   | https://arctos.database.museum/collection/NMMNH:Paleo   | New Mexico Museum of Natural History and Science Paleontology Collection
 NMU:Bird      | https://arctos.database.museum/collection/NMU:Bird      | Northern Michigan University Bird Collection
 NMU:Ento      | https://arctos.database.museum/collection/NMU:Ento      | Northern Michigan University Insect Collection
 NMU:Fish      | https://arctos.database.museum/collection/NMU:Fish      | Northern Michigan University Fish Collection
 NMU:Herb      | https://arctos.database.museum/collection/NMU:Herb      | Northern Michigan University Herbarium
 NMU:Herp      | https://arctos.database.museum/collection/NMU:Herp      | Northern Michigan University Amphibian and Reptile Collection
 NMU:Mamm      | https://arctos.database.museum/collection/NMU:Mamm      | Northern Michigan University Mammal Collection
 NMU:Para      | https://arctos.database.museum/collection/NMU:Para      | Northern Michigan University Parasite Collection
 OWU:Amph      | https://arctos.database.museum/collection/OWU:Amph      | Ohio Wesleyan University Amphibian Collection
 OWU:Bird      | https://arctos.database.museum/collection/OWU:Bird      | Ohio Wesleyan University Bird Collection
 OWU:EH        | https://arctos.database.museum/collection/OWU:EH        | Ohio Wesleyan University Ethnology Collection
 OWU:Ento      | https://arctos.database.museum/collection/OWU:Ento      | Ohio Wesleyan University Entomology Collection
 OWU:ES        | https://arctos.database.museum/collection/OWU:ES        | Ohio Wesleyan University Paleontology Collection
 OWU:Fish      | https://arctos.database.museum/collection/OWU:Fish      | Ohio Wesleyan University Fish Collection
 OWU:Geol      | https://arctos.database.museum/collection/OWU:Geol      | Ohio Wesleyan University Geology Collection
 OWU:Herb      | https://arctos.database.museum/collection/OWU:Herb      | Ohio Wesleyan University Herbarium Collection
 OWU:Inv       | https://arctos.database.museum/collection/OWU:Inv       | Ohio Wesleyan University Invertebrate Collection
 OWU:Mamm      | https://arctos.database.museum/collection/OWU:Mamm      | Ohio Wesleyan University Mammal Collection
 OWU:Para      | https://arctos.database.museum/collection/OWU:Para      | Ohio Wesleyan University Parasite Collection
 OWU:Rept      | https://arctos.database.museum/collection/OWU:Rept      | Ohio Wesleyan University Reptile Collection
 PSU:Mamm      |                                                         | 
 STAR:Alg      | https://arctos.database.museum/collection/STAR:Alg      | Arkansas Center for Biodiversity Collections Algae Collection
 STAR:Herb     | https://arctos.database.museum/collection/STAR:Herb     | Arkansas Center for Biodiversity Collections Herbarium Collection
 TMCC:Bird     | https://arctos.database.museum/collection/TMCC:Bird     | Truckee Meadows Community College Bird Collection
 TMCC:Ento     | https://arctos.database.museum/collection/TMCC:Ento     | Truckee Meadows Community College Insect Collection
 TMCC:Fish     | https://arctos.database.museum/collection/TMCC:Fish     | Truckee Meadows Community College Fish Collection
 TMCC:Herb     | https://arctos.database.museum/collection/TMCC:Herb     | Truckee Meadows Community College Herbarium
 TMCC:Herp     | https://arctos.database.museum/collection/TMCC:Herp     | Truckee Meadows Community College Amphibian and Reptile Collection
 TMCC:Inv      | https://arctos.database.museum/collection/TMCC:Inv      | Truckee Meadows Community College Invertebrate Collection
 TMCC:Mamm     | https://arctos.database.museum/collection/TMCC:Mamm     | Truckee Meadows Community College Mammal Collection
 TMCC:Teach    | https://arctos.database.museum/collection/TMCC:Teach    | Truckee Meadows Community College Teaching Collection
 UAF:Zooarch   | https://arctos.database.museum/collection/UAF:Zooarch   | University of Alaska Fairbanks Zooarchaeology Collection
 UAM:Alg       | https://arctos.database.museum/collection/UAM:Alg       | University of Alaska Museum Algae (ALA) Collection
 UAM:Arc       | https://arctos.database.museum/collection/UAM:Arc       | University of Alaska Museum Archeology Collection
 UAM:Art       | https://arctos.database.museum/collection/UAM:Art       | University of Alaska Museum of the North Fine Arts Department
 UAMb:Herb     | https://arctos.database.museum/collection/UAMb:Herb     | University of Alaska Museum Cryptogam (ALA) Collection
 UAM:Bird      | https://arctos.database.museum/collection/UAM:Bird      | University of Alaska Museum Bird Collection
 UAM:EH        | https://arctos.database.museum/collection/UAM:EH        | University of Alaska Museum of the North Ethnology and History Department
 UAM:Ento      | https://arctos.database.museum/collection/UAM:Ento      | University of Alaska Museum Insect Collection
 UAM:Env       | https://arctos.database.museum/collection/UAM:Env       | University of Alaska Museum Environmental samples Collection
 UAM:ES        | https://arctos.database.museum/collection/UAM:ES        | University of Alaska Museum Earth Science Collection
 UAM:Fish      | https://arctos.database.museum/collection/UAM:Fish      | University of Alaska Museum Fish Collection
 UAM:Herb      | https://arctos.database.museum/collection/UAM:Herb      | University of Alaska Museum Herbaruim
 UAM:Herp      | https://arctos.database.museum/collection/UAM:Herp      | University of Alaska Museum Amphibian and Reptile Collection
 UAM:Inv       | https://arctos.database.museum/collection/UAM:Inv       | University of Alaska Museum Invertebrate Collection
 UAM:Mamm      | https://arctos.database.museum/collection/UAM:Mamm      | University of Alaska Museum Mammal Collection
 UAMObs:Bird   | https://arctos.database.museum/collection/UAMObs:Bird   | University of Alaska Museum Bird Observations Collection
 UAMObs:EH     |                                                         | 
 UAMObs:Ento   |                                                         | 
 UAMObs:Fish   | https://arctos.database.museum/collection/UAMObs:Fish   | University of Alaska Museum Fish observations Collection
 UAMObs:Mamm   | https://arctos.database.museum/collection/UAMObs:Mamm   | University of Alaska Museum Mammal observations Collection
 UA:Paleo      | https://arctos.database.museum/collection/UA:Paleo      | University of Antananarivo Paleontology Collection
 UCM:Bird      | https://arctos.database.museum/collection/UCM:Bird      | University of Colorado Museum of Natural History Bird Collection
 UCM:Egg       | https://arctos.database.museum/collection/UCM:Egg       | University of Colorado Museum of Natural History Bird eggs/nests Collection
 UCM:Fish      | https://arctos.database.museum/collection/UCM:Fish      | University of Colorado Museum of Natural History Fish Collection
 UCM:Herp      | https://arctos.database.museum/collection/UCM:Herp      | University of Colorado Museum of Natural History Amphibian and Reptile Collection
 UCM:Mamm      | https://arctos.database.museum/collection/UCM:Mamm      | University of Colorado Museum of Natural History Mammal Collection
 UCM:Obs       | https://arctos.database.museum/collection/UCM:Obs       | University of Colorado Museum of Natural History Vertebrate observations Collection
 UCM:Para      |                                                         | 
 UCONN:Bird    | https://arctos.database.museum/collection/UCONN:Bird    | University of Connecticut Biodiversity Research Collections Bird Collection
 UCONN:Egg     | https://arctos.database.museum/collection/UCONN:Egg     | University of Connecticut Biodiversity Research Collections Egg and nest Collection
 UCSC:Bird     | https://arctos.database.museum/collection/UCSC:Bird     | Kenneth S. Norris Center for Natural History Bird Collection
 UCSC:Fish     | https://arctos.database.museum/collection/UCSC:Fish     | Kenneth S. Norris Center for Natural History Fish Collection
 UC-SCFS:Bird  | https://arctos.database.museum/collection/UC-SCFS:Bird  | University of California Sagehen Creek Field Station Bird Collection
 UC-SCFS:Mamm  | https://arctos.database.museum/collection/UC-SCFS:Mamm  | University of California Sagehen Creek Field Station Mammal Collection
 UCSC:Herp     | https://arctos.database.museum/collection/UCSC:Herp     | Kenneth S. Norris Center for Natural History Amphibian and Reptile Collection
 UCSC:Mamm     | https://arctos.database.museum/collection/UCSC:Mamm     | Kenneth S. Norris Center for Natural History Mammal Collection
 UMNH:Bird     | https://arctos.database.museum/collection/UMNH:Bird     | Natural History Museum of Utah Bird Collection
 UMNH:Ento     |                                                         | 
 UMNH:Herp     | https://arctos.database.museum/collection/UMNH:Herp     | Natural History Museum of Utah Amphibian and Reptile Collection
 UMNH:Host     |                                                         | 
 UMNH:Mala     |                                                         | 
 UMNH:Mamm     | https://arctos.database.museum/collection/UMNH:Mamm     | Natural History Museum of Utah Mammal Collection
 UMNHObs:Mamm  | https://arctos.database.museum/collection/UMNHObs:Mamm  | Natural History Museum of Utah Mammal observations Collection
 UMNH:Para     |                                                         | 
 UMNH:Teach    | https://arctos.database.museum/collection/UMNH:Teach    | Natural History Museum of Utah Teaching and Education Collection
 UMZM:Bird     | https://arctos.database.museum/collection/UMZM:Bird     | University of Montana Philip L. Wright Zoological Museum Bird Collection
 UMZM:Mamm     | https://arctos.database.museum/collection/UMZM:Mamm     | University of Montana Philip L. Wright Zoological Museum Mammal Collection
 UMZM:Para     | https://arctos.database.museum/collection/UMZM:Para     | University of Montana Philip L. Wright Zoological Museum Parasite Collection
 UNCG:Mamm     | https://arctos.database.museum/collection/UNCG:Mamm     | University of North Carolina Greensboro Mammal Collection
 UNCG:Para     | https://arctos.database.museum/collection/UNCG:Para     | University of North Carolina Greensboro Parasite Collection
 UNM:MET       | https://arctos.database.museum/collection/UNM:MET       | University of New Mexico, Institute of Meteoritics
 UNM:MIN       | https://arctos.database.museum/collection/UNM:MIN       | University of New Mexico Geology Collection
 UNM:Paleo     | https://arctos.database.museum/collection/UNM:Paleo     | University of New Mexico Fossil Collection
 UNR:Bird      | https://arctos.database.museum/collection/UNR:Bird      | University of Nevada, Reno Bird Collection
 UNR:Egg       | https://arctos.database.museum/collection/UNR:Egg       | University of Nevada, Reno Bird eggs/nests Collection
 UNR:Fish      | https://arctos.database.museum/collection/UNR:Fish      | University of Nevada, Reno Fish Collection
 UNR:Herp      | https://arctos.database.museum/collection/UNR:Herp      | University of Nevada, Reno Amphibian and Reptile Collection
 UNR:Mamm      | https://arctos.database.museum/collection/UNR:Mamm      | University of Nevada, Reno Mammal Collection
 USNPC:Para    | https://arctos.database.museum/collection/USNPC:Para    | U. S. National Parasite Collection
 UTEP:Arc      | https://arctos.database.museum/collection/UTEP:Arc      | University of Texas at El Paso Biodiversity Collections Archeology Collection
 UTEP:Bird     | https://arctos.database.museum/collection/UTEP:Bird     | University of Texas at El Paso Biodiversity Collections Bird Collection
 UTEP:Ento     | https://arctos.database.museum/collection/UTEP:Ento     | University of Texas at El Paso Biodiversity Collections Insect Collection
 UTEP:ES       | https://arctos.database.museum/collection/UTEP:ES       | University of Texas at El Paso Biodiversity Collections Earth Science Collection
 UTEP:Fish     | https://arctos.database.museum/collection/UTEP:Fish     | University of Texas at El Paso Biodiversity Collections Fish Collection
 UTEP:Herb     | https://arctos.database.museum/collection/UTEP:Herb     | University of Texas at El Paso Biodiversity Collections Herbarium
 UTEP:Herp     | https://arctos.database.museum/collection/UTEP:Herp     | University of Texas at El Paso Biodiversity Collections Amphibian and Reptile Collection
 UTEP:HerpOS   | https://arctos.database.museum/collection/UTEP:HerpOS   | University of Texas at El Paso Biodiversity Collections Amphibian and reptile osteology Collection
 UTEP:Inv      | https://arctos.database.museum/collection/UTEP:Inv      | University of Texas at El Paso Biodiversity Collections Invertebrate Collection
 UTEP:Mamm     | https://arctos.database.museum/collection/UTEP:Mamm     | University of Texas at El Paso Biodiversity Collections Mammal Collection
 UTEPObs:Bird  |                                                         | 
 UTEPObs:Ento  | https://arctos.database.museum/collection/UTEPObs:Ento  | University of Texas at El Paso Biodiversity Collections Insect observations Collection
 UTEPObs:Herb  |                                                         | 
 UTEPObs:Herp  | https://arctos.database.museum/collection/UTEPObs:Herp  | University of Texas at El Paso Biodiversity Collections Amphibian and reptile observations Collection
 UTEP:Teach    | https://arctos.database.museum/collection/UTEP:Teach    | University of Texas at El Paso Biodiversity Collections Teaching Collection
 UTEP:Zoo      | https://arctos.database.museum/collection/UTEP:Zoo      | University of Texas at El Paso Biodiversity Collections Zooplankton Collection
 UWBM:Herp     | https://arctos.database.museum/collection/UWBM:Herp     | Burke Museum of Natural History and Culture Amphibian and Reptile Collection
 UWBM:Mamm     | https://arctos.database.museum/collection/UWBM:Mamm     | Burke Museum of Natural History and Culture Mammal Collection
 UWYMV:Bird    | https://arctos.database.museum/collection/UWYMV:Bird    | University of Wyoming Museum of Vertebrates Bird Collection
 UWYMV:Egg     | https://arctos.database.museum/collection/UWYMV:Egg     | University of Wyoming Museum of Vertebrates Bird eggs/nests Collection
 UWYMV:Fish    | https://arctos.database.museum/collection/UWYMV:Fish    | University of Wyoming Museum of Vertebrates Fish Collection
 UWYMV:Herp    | https://arctos.database.museum/collection/UWYMV:Herp    | University of Wyoming Museum of Vertebrates Amphibian and Reptile Collection
 UWYMV:Mamm    | https://arctos.database.museum/collection/UWYMV:Mamm    | University of Wyoming Museum of Vertebrates Mammal Collection
 UWZM:Bird     | https://arctos.database.museum/collection/UWZM:Bird     | University of Wisconsin Zoological Museum Bird Collection
 UWZM:EH       | https://arctos.database.museum/collection/UWZM:EH       | University of Wisconsin Zoological Museum Ethnology Collection
 UWZM:Fish     | https://arctos.database.museum/collection/UWZM:Fish     | University of Wisconsin Zoological Museum Fish Collection
 UWZM:Herp     | https://arctos.database.museum/collection/UWZM:Herp     | University of Wisconsin Zoological Museum Amphibian and Reptile Collection
 UWZM:Inv      | https://arctos.database.museum/collection/UWZM:Inv      | University of Wisconsin Zoological Museum Invertebrate Collection
 UWZM:Mamm     | https://arctos.database.museum/collection/UWZM:Mamm     | University of Wisconsin Zoological Museum Mammal Collection
 UWZM:Osteo    | https://arctos.database.museum/collection/UWZM:Osteo    | University of Wisconsin Zoological Museum Osteology Collection
 UWZM:Paleo    | https://arctos.database.museum/collection/UWZM:Paleo    | University of Wisconsin Zoological Museum Fossil Collection
 UWZM:Teach    | https://arctos.database.museum/collection/UWZM:Teach    | University of Wisconsin Zoological Museum Teaching Collection
 WNMU:Bird     | https://arctos.database.museum/collection/WNMU:Bird     | Western New Mexico University Bird Collection
 WNMU:Fish     | https://arctos.database.museum/collection/WNMU:Fish     | Western New Mexico University Fish Collection
 WNMU:Mamm     | https://arctos.database.museum/collection/WNMU:Mamm     | Western New Mexico University Mammal Collection
(296 rows)

@Jegelewicz
Copy link
Member

PSU:Mamm see https://github.com/ArctosDB/internal/issues/209

ALMNH:ES all redirected to ALMNH:Paleo how do you recommend we handle this? Add both collectionIDs to one agent? Create the second agent and relate them somehow?

DGR - I didn't bother creating these because they need to go?

Otherwise, I think it's done.

@dustymc
Copy link
Contributor Author

dustymc commented Dec 16, 2022

Add both collectionIDs to one agent?

That would break my scripts/expectations. I think ignoring the orphans and GP weirdness is fine, at least for now.

Thanks!

@dustymc dustymc closed this as completed Dec 16, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Help wanted I have a question on how to use Arctos Priority - Wildfire Potential ignore this at everyone's peril, may smolder for now ...
Projects
None yet
Development

No branches or pull requests

4 participants