Project

General

Profile

« Previous | Next » 

Revision 9982

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.TNRS/schema.sql: tnrs_populate_fields(): never_homonym: use Author_score threshold to exclude matches that are too fuzzy to confirm the presence of a plant name author

View differences:

schema.sql
81 81 
            THEN true
82 82 
        ELSE NULL -- ambiguous
83 83 
        END);
84 
    never_homonym boolean = new."Author_matched" IS NOT NULL; -- author disambiguates
84 
    never_homonym boolean = COALESCE(new."Author_score" >= 0.6, false); -- author disambiguates
85 85 
    family_is_homonym boolean = NOT never_homonym AND EXISTS(SELECT * FROM "IRMNG".family_homonym_epithet WHERE "taxonNameOrEpithet" = new."Family_matched");
86 86 
    genus_is_homonym  boolean = NOT never_homonym AND EXISTS(SELECT * FROM "IRMNG".genus_homonym_epithet  WHERE "taxonNameOrEpithet" = new."Genus_matched");
87 87 
BEGIN

Also available in: Unified diff