[Taxacom] validation of taxon names

Armand Turpel armand.turpel.mnhn at gmail.com
Wed Feb 15 13:39:28 CST 2012


If it is from interest. The catalogue of life for postgresql is a public 
available project.


As shortly described in my first posting it is possible to compare a 
list of taxons against the col data. Currently there is only one 
function that compare the genus, species epithet and authority and gives 
for each taxon a 3 digits code back which represents the genus, species 
epithet and authority match.


0 = no match
1 = exact match
2 = fuzzy match

Here an example of the function call.

select col.validate_from_file( 'C:/test_files/input.csv', 'C:/test_files/output.csv',

         ARRAY[  ARRAY['levenshtein_genus', '1'],

                 ARRAY['levenshtein_species', '2'],

                 ARRAY['levenshtein_author', '2']

         ] );



More information about the Taxacom mailing list