Revision 9764
Added by Aaron Marcuse-Kubitza over 11 years ago
| schema.sql | ||
|---|---|---|
| 88 | 88 |
, new."Specific_epithet_score"::double precision |
| 89 | 89 |
); |
| 90 | 90 |
new."Is_plant" = (CASE |
| 91 |
WHEN new."Family_matched" IS NOT NULL THEN true
|
|
| 91 |
WHEN new."Family_score"::double precision = 1 THEN true -- exact match
|
|
| 92 | 92 |
ELSE -- Family_matched IS NULL |
| 93 | 93 |
(CASE |
| 94 | 94 |
WHEN new."Genus_score"::double precision = 1 -- exact match |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs_populate_fields(): Is_plant: must match family as Family_score = 1 (as discussed during conference call vegpath.org/wiki/2013-05-30_conference_call#postprocess-TNRS-results-to-exclude-animals-with-genus-homonyms) instead of as Family_matched IS NOT NULL (as listed in Brad's formula at vegpath.org/wiki/Result_filtering#TNRS-results) because TNRS transforms animal to plant families via fuzzy matching, necessitating a Family_score check to ensure an exact match to a plant family that was not transformed from an animal family