Project

General

Profile

« Previous | Next » 

Revision 13508

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: inputs/.TNRS/schema.sql: MatchedTaxon.taxonomicStatus: filter using map_taxonomic_status() so that the corrected value is available in the normalized DB, not just analytical_stem

View differences:

trunk/inputs/.TNRS/schema.sql
315 315 
            tnrs."Infraspecific_epithet_score" AS "*Name_matched.Infraspecific_epithet_score",
316 316 
            tnrs."Annotations" AS "identificationQualifier",
317 317 
            tnrs."Unmatched_terms" AS "morphospeciesSuffix",
318 
            tnrs."Taxonomic_status" AS "taxonomicStatus",
318 
            map_taxonomic_status(tnrs."Taxonomic_status", tnrs."Accepted_name") AS "taxonomicStatus",
319 319 
            tnrs."Accepted_name" AS accepted_taxon_name_no_author,
320 320 
            tnrs."Accepted_name_author" AS accepted_author,
321 321 
            tnrs."Accepted_name_rank" AS accepted_taxon_rank,
trunk/schemas/vegbien.sql
17120 17120 
            tnrs."Infraspecific_epithet_score" AS "*Name_matched.Infraspecific_epithet_score",
17121 17121 
            tnrs."Annotations" AS "identificationQualifier",
17122 17122 
            tnrs."Unmatched_terms" AS "morphospeciesSuffix",
17123 
            tnrs."Taxonomic_status" AS "taxonomicStatus",
17123 
            map_taxonomic_status(tnrs."Taxonomic_status", tnrs."Accepted_name") AS "taxonomicStatus",
17124 17124 
            tnrs."Accepted_name" AS accepted_taxon_name_no_author,
17125 17125 
            tnrs."Accepted_name_author" AS accepted_author,
17126 17126 
            tnrs."Accepted_name_rank" AS accepted_taxon_rank,

Also available in: Unified diff