search

Bauble / bauble.classic

this is how Bauble and Ghini both started
GNU General Public License v2.0
10 stars 34 forks source link

finding common mistakes in data #223

Closed mfrasca closed 8 years ago

mfrasca commented 8 years ago

it is possible for a user to insert the following in the database, maybe because one is looking for a Genus under an other Family, because of differently up-to-date information than what in their Bauble database.

untitled

whichever the reason, it is possible to have this in a Bauble database.

now I am looking at such a database and I wonder how can I locate all these repeated or almost repeated names (in this case, they differ in white-space).

I can do using SQL select count(*) c, genus from genus group by genus having c > 1;

....

work in progress. should examine further, spaces, lack of author....

mfrasca commented 8 years ago

second thought. just do this from the interface.