ArctosDB / arctos

Arctos is a museum collections management system
https://arctos.database.museum
60 stars 13 forks source link

[external CONTACT] Place Terms search question #6065

Closed ccicero closed 9 months ago

ccicero commented 1 year ago

@dustymc @mkoo I did a search of all MVZ:Bird with part name like 'ectoparasite' and got 51 results. Here is the saved search. Then I tried to limit it to just California by selecting state_prov in the Place Terms field and got only 3 returns:

image

Next I tried putting 'California' in the Any Geographic Element field. That gave me 42 entries which is correct (new saved search).

Why does the Place Terms search not include all of the records with state_prov of California?

dustymc commented 1 year ago

Short version: https://github.com/ArctosDB/internal/issues/222

Hopeful solution: https://github.com/ArctosDB/arctos/issues/5597

https://github.com/ArctosDB/arctos/issues/5654 is making Arctos geography comprehensive, but processing that is slow. Once that's complete, search by familiar Arctos terms should be comprehensive (as the cache catches up). In the meantime there's still a bunch of old data from various services hanging around, but at least the rank components aren't very predictable. (At least "GADM1" and "STATE" mean about what state_prov does, for example.)

https://arctos.database.museum/search.cfm?guid_prefix=MVZ%3ABird&customoidoper=BETWEEN&part_search=ectoparasite&geog_shape=United%20States%2C%20California is basically the above but live, and explicit in the intersection - that's 'contains', I can't get 'intersects' to work at the moment (which is why there's all this complication about caching, it would be AWESOME to skip all that nonsense and deal with shapes, but here we are).

https://arctos.database.museum/search.cfm?guid_prefix=MVZ%3ABird&customoidoper=BETWEEN&part_search=ectoparasite&state_prov=California is "as asserted by you" - things that you claim to be in CA but which don't map there will be included. I think your practices support this and BM suggests the data aren't crazy, so that might be the easy choice. (There's also some 'chosen event' complexity that would make this a poor choice for some uses - eg cultural collections or those with lots of opinions via automation or etc - but that can generally all be ignored for your data too, I think.)

ccicero commented 1 year ago

now I'm just trying to search on MVZ:Bird for taxon 'Zenaida macroura' for Any Geographic Element 'California' but am getting 0 returns. There are definitely specimens from California. Shouldn't that work at least?

image

dustymc commented 1 year ago

https://arctos.database.museum/search.cfm?guid_prefix=MVZ%3ABird&customoidoper=BETWEEN&taxon_name=Zenaida%20macroura&any_geog=California

finds 180 records for me. Please use links, otherwise we're all guessing.

ccicero commented 1 year ago

How do I use a link if I don't get any returns?

dustymc commented 1 year ago
Screenshot 2023-04-03 at 4 17 15 PM Screenshot 2023-04-03 at 4 17 26 PM Screenshot 2023-04-03 at 4 17 43 PM

https://arctos.database.museum/search.cfm?cat_num=afasdfasfasfasdas&customoidoper=BETWEEN

ccicero commented 1 year ago

Ah, ok. Will try again. Not sure why I was getting 0 returns. Maybe something cached?