Project

General

Profile

« Previous | Next » 

Revision 9759

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.TNRS/schema.sql: added MatchedTaxon view, which now just renames the columns but does not filter the results, and use it in ValidMatchedTaxon

View differences:

inputs/.TNRS/schema.sql
91 91 
  EXECUTE PROCEDURE tnrs_populate_fields();
92 92 

  		




  93
  93
  
    

  		




  94
  
  
    
CREATE OR REPLACE VIEW "ValidMatchedTaxon" AS


  		




  
  94
  
    
CREATE OR REPLACE VIEW "MatchedTaxon" AS


  		




  95
  95
  
    
SELECT


  		




  96
  96
  
    
  "Time_submitted" AS "*Name_matched.Time_submitted"


  		




  97
  97
  
    
, "Name_submitted" AS "concatenatedScientificName"


  		




  ......




  125
  125
  
    
, "Accepted_scientific_name" AS "acceptedScientificName"


  		




  126
  126
  
    
, "Max_score" AS "matchedTaxonConfidence_fraction"


  		




  127
  127
  
    
FROM tnrs


  		




  128
  
  
    
WHERE score_ok("Max_score")


  		




  129
  128
  
    
;


  		




  130
  129
  
    

  		




  
  130
  
    

  		




  
  131
  
    
CREATE OR REPLACE VIEW "ValidMatchedTaxon" AS


  		




  
  132
  
    
SELECT *


  		




  
  133
  
    
FROM "MatchedTaxon"


  		




  
  134
  
    
WHERE score_ok("matchedTaxonConfidence_fraction")


  		




  
  135
  
    
;


  		




  
  136
  
    

  		




  131
  137
  
    
CREATE OR REPLACE VIEW "AcceptedTaxon" AS


  		




  132
  138
  
    
SELECT


  		




  133
  139
  
    
  "Time_submitted" AS "*Accepted_name.Time_submitted"


  		












Also available in:  Unified diff