Project

General

Profile

« Previous | Next » 

Revision 9616

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.TNRS/schema.sql: MatchedTaxon: filter out rows where Max_score was not high enough to use the TNRS result as a match. removed now-duplicated filter for this in AcceptedTaxon.

View differences:

inputs/.TNRS/schema.sql
122 122 
, "Accepted_name_lsid" AS "*Name_matched.Accepted_name_lsid"
123 123 
, "Accepted_scientific_name" AS "acceptedScientificName"
124 124 
, "Max_score" AS "matchedTaxonConfidence_fraction"
125 
FROM tnrs;
125 
FROM tnrs
126 
WHERE score_ok("Max_score")
127 
;
126 128 

  		




  127
  129
  
    
CREATE OR REPLACE VIEW "AcceptedTaxon" AS


  		




  128
  130
  
    
SELECT


  		




  ......




  143
  145
  
    
SELECT *


  		




  144
  146
  
    
FROM "MatchedTaxon"


  		




  145
  147
  
    
NATURAL LEFT JOIN "AcceptedTaxon"


  		




  146
  
  
    
WHERE score_ok("matchedTaxonConfidence_fraction")


  		




  147
  148
  
    
;


  		












Also available in:  Unified diff