Michelle Koo

> ``` > select > flat.scientific_name, > p.parts > from > flat > left outer join ( > select derived_from_cat_item,string_agg(distinct part_name,', ' order by part_name) parts from specimen_part group by...

oh shoot I didnt try to ```has_tissue>0``` option... just saw that and probably/might will work?!

This is the specific kind of request we want to make easy in a dedicated relations (parasites, disease etc) portal.... I still havent made issues for this yet but will...

This easy to do now -- thanks to https://github.com/ArctosDB/arctos/issues/7695, https://github.com/ArctosDB/arctos/issues/7725 (cleaning up CT in #7752 will help with reliable results) https://arctos.database.museum/search.cfm?related_id_references=parasite%20of&related_item_taxonomy=Arthropoda&taxon_name=Sciuridae (your log in may filter your results)

I agree we have to fix probably best by island and group by group. I think I'll start with a little GIS work to identify EEZ for country vs international...

We're starting work on this at MVZ, specifically the locs with "[North Pacific Ocean, Bering Sea](https://arctos.database.museum/place.cfm?action=detail&geog_auth_rec_id=1148)" as HG. Aleutians are firmly part of US:AK so starting there by changing HG...

Thanks Aren-- looks like I have your ok to do this for locs in AK waters, so I'm going to go ahead. The shapefile will be helpful! so far most...

@dustymc I'm starting a spreadsheet for a bulk update where we can change the HG and the spec_loc. What are the minimum fields needed for that? - COLLECTING_EVENT_ID - HIGHER_GEOG...

ok that's perfect. Also, that is what I meant by spec_loc cleanup. We havent really started yet! But now that I know what the end product will be, we'll start...

@dustymc For Monday: first CSV for HG batch updating (109 rows to load). Let us know if anything needs tweaking format-wise. Kat applied some python to do overhaul but I...