Project

General

Profile

« Previous | Next » 

Revision 12936

Added by Aaron Marcuse-Kubitza over 10 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql: implemented _specimens_03_list_of_verbatim_families

View differences:

trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
27 27 
;
28 28 

  		




  29
  29
  
    
CREATE VIEW _specimens_03_list_of_verbatim_families AS


  		




  
  30
  
    
SELECT DISTINCT family


  		




  
  31
  
    
FROM taxonverbatim


  		




  
  32
  
    
WHERE taxonverbatim.source_id = (SELECT source_by_shortname('NY'))


  		




  
  33
  
    
AND family IS NOT NULL


  		




  30
  34
  
    
;


  		




  31
  35
  
    

  		




  32
  36
  
    
CREATE VIEW _specimens_04_count_of_unique_verbatim_species_without_author AS


  		












Also available in:  Unified diff