Project

General

Profile

« Previous | Next » 

Revision 12890

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql: removed input-query-specific comments

View differences:

trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
66 66 
-- -------------------------------
67 67 
-- 10. Count number of records by institution
68 68 
-- Check: should return 6 rows
69 
-- Note: Majority should be from 'NY'; these are standard herbarium acronyms
70 69 
-- -------------------------------
71 70 
CREATE OR REPLACE VIEW _specimens_10_count_number_of_records_by_institution AS
72 71 

  		




  ......




  108
  107
  
    
-- -------------------------------


  		




  109
  108
  
    
-- 16. List distinct non-null specimen descriptions


  		




  110
  109
  
    
-- Check: should return 158460 records


  		




  111
  
  
    
-- Note: specimens descriptions in nybg extract is in column PlantFungusDescription


  		




  112
  110
  
    
-- -------------------------------


  		




  113
  111
  
    
CREATE OR REPLACE VIEW _specimens_16_list_distinct_specimen_descriptions AS


  		












Also available in:  Unified diff