Hi,

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

http://code.google.com/p/catalogue-of-life-for-postgresql/

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.

120

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']

] );

a+

arm

_______________________________________________

Taxacom Mailing List Taxa...@mailman.nhm.ku.edu http://mailman.nhm.ku.edu/mailman/listinfo/taxacom

The Taxacom archive going back to 1992 may be searched with either of these
methods:

(1) by visiting http://taxacom.markmail.org

(2) a Google search specified as: site:mailman.nhm.ku.edu/pipermail/taxacom
your search terms here