ArctosDB / arctos

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

Add Island to Bohol, Samar and other islands #1786

Closed sharpphyl closed 5 years ago

sharpphyl commented 5 years ago

Issue Documentation is http://handbook.arctosdb.org/how_to/How-to-Use-Issues-in-Arctos.html

Is your feature request related to a problem? Please describe. Our volunteers doing data entry find it confusing when the same name is used for the province and an island within or the same as the province. Examples: Asia, Philippines, Samar, Philippine Islands, Samar Asia, Philippines, Bohol, Philippine Islands, Bohol Asia, Philippines, Siquijor, Philippine Islands, Siquijor

Describe the solution you'd like Add Island to the island name whenever it is the same as the province/state. If I do this, I will impact other museum's records. What is the procedure to approve of and make such changes?

Describe alternatives you've considered We are very inconsistent in using "Island" as part of the higher geography. The Handbook Geo_Auth_Rec . Island VARCHAR(50) null seems to say that adding Island is appropriate if it is in the name of the island. Can this be done by anyone with authority to edit Higher Geography or do all users of that higher geography have to sign on?

Additional context

bohol geography

bohol impact

Priority I would like to have this resolved by date: Whenever the geography committee meets.

dustymc commented 5 years ago

http://handbook.arctosdb.org/documentation/higher-geography.html#island

The key there is the proper name. "Bohol Island" is not a common usage; it's just "Bohol."

https://en.wikipedia.org/wiki/Bohol

"Bay Farm Island" is correct.

https://en.wikipedia.org/wiki/Bay_Farm_Island,_Alameda,_California

This change would complicate data cleanup by introducing unexpected terms in names. As long as the term is just "island" I can probably deal with that anyway, if I have to.

I think this would be a bit confusing to users as well - nobody expects 'Bohol Island.'

If the issue is in the geography pick, we could probably make that look more like...

screen shot 2018-11-07 at 9 30 07 am

... and less like ...

screen shot 2018-11-07 at 9 30 55 am

which, if I'm understanding this correctly, should address the problem without introducing confusing terminology (and ultimately tripping GBIF's flags and etc.).

And the example instructs us to do exactly the opposite of what we've been discussing in https://github.com/ArctosDB/arctos/issues/1107.

100 yds off of the beach, Bay Farm Island

sharpphyl commented 5 years ago

Yes, if you could make the Geography Pick show the levels as displayed above, that would solve the problem we have.

sharpphyl commented 5 years ago

Not sure which of the topics listed above needs discussion. Instead of adding "Island" as originally requested, I like Dusty's suggestion that he makes the Higher Geography Pick screen show the levels of each term. That would solve the problem without changing any of the terms. Does that require the approval of a specific group?

dustymc commented 5 years ago

I think it's a useful discussion.

Jegelewicz commented 5 years ago
Are we OK with a larger, harder to read pick?

I am - who says it is harder to read?

Are we OK with displaying one thing for data entry and something else for everything else?

Probably not a good idea and if you think about it, anyone unfamiliar with Arctos will wonder what the heck "Asia, Philippines, Bohol, Philippine Islands, Bohol" is supposed to mean.

Are we attempting to duct-tape over some problem with the data/structure/guidelines/whatever?

Possibly. I do feel like features, islands, and continent/ocean create inconsistencies and perhaps confusing information.

dustymc commented 5 years ago

who says it is harder to read

Me! But I'd seldom use the pick so whatever.

Also of concern: The bulkloader does (and I think always will) work with the (or a) concatenation.

what the heck "Asia, Philippines, Bohol, Philippine Islands, Bohol" is supposed to mean

Yup. Bohol Island, Bohol State Park? Bohol State-or-whatever, Bohol Island? Bohol State-or-whatever, Bohol State Park? ???

IDK, I think we've all flip-flopped a few times in various contexts, maybe tossing a " ... Island" in there IS the least evil. But that suggests we should also be doing "Continent of Australia, Country of Australia, ...." er sumthin.

Jegelewicz commented 5 years ago

Well if we display it in the "hard to read" table, it's pretty obvious.....

sharpphyl commented 5 years ago

And if you Search/Geography for Bohol, you do get the table in the hard and easy to read forms, so it's consistent with those results.

Bohol

Jegelewicz commented 5 years ago

Question - do all of those other islands have "island" in their official name? I'm guessing there might be some inconsistencies in how the island rules are being applied (no one reads the documentation...).

sharpphyl commented 5 years ago

https://en.wikipedia.org/wiki/Panglao_Island https://en.wikipedia.org/wiki/Mahanay_Island Balicasag - no wikipedia entry.

Balicasag

On the other hand, under Bohol, Wikipedia lists all these islands and the word Island doesn't appear with any of them, so I'm not sure Wikipedia is consistent either.

Bohol Islands

I'm happy to drop the word Island if the complete Higher Geography structure above is shown during data entry.

dustymc commented 5 years ago

Wikipedia is consistent

The world isn't consistent, but that doesn't mean we have to follow - lots of our rules are "ignore reality in favor of consistency, so we don't end up with duplicates." I'm not morally opposed to more of that.

Are we settled on a grid in geog pick?

Jegelewicz commented 5 years ago

I'm good with the grid.

sharpphyl commented 5 years ago

Yes, and thank you.

dustymc commented 5 years ago

The pick is all griddy now.