Project

General

Profile

« Previous | Next » 

Revision 13122

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: updated to inputs/NY/validations.sql

View differences:

trunk/validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql
32 32 
-- _specimens_04_count_of_species_binomials
33 33 
 SELECT count(DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet")) AS species_binomials
34 34 
   FROM "Ecatalog_all"
35 
  WHERE ((("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL)) AND ("Ecatalog_all".subspecies IS NOT NULL));
35 
  WHERE (("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL));
36 36 
/*
37 37 
Check: should return 1 row
38 38 
*/
......
40 40 
-- _specimens_05_list_of_species_binomials
41 41 
 SELECT DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet") AS species_binomial
42 42 
   FROM "Ecatalog_all"
43 
  WHERE ((("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL)) AND ("Ecatalog_all".subspecies IS NOT NULL));
43 
  WHERE (("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL));
44 44 
/*
45 45 
Check: should return 3335 rows
46 46 
*/
47 47 

  		




  48
  48
  
    
-- _specimens_06_count_of_unique_verb_subsp_taxa_with_author


  		




  49
  
  
    
 SELECT count(DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet", "Ecatalog_all".subspecies)) AS taxon_names_with_author


  		




  
  49
  
    
 SELECT count(DISTINCT "Ecatalog_all"."scientificName") AS taxon_names_with_author


  		




  50
  50
  
    
   FROM "Ecatalog_all"


  		




  51
  
  
    
  WHERE (("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL));


  		




  
  51
  
    
  WHERE ((("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL)) AND ("Ecatalog_all".subspecies IS NOT NULL));


  		




  52
  52
  
    
/*


  		




  53
  53
  
    
Check: should return 1 row


  		




  54
  54
  
    
*/


  		




  55
  55
  
    

  		




  56
  56
  
    
-- _specimens_07_list_of_verbatim_subspecific_taxa_with_author


  		




  57
  
  
    
 SELECT DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet") AS taxon_name_with_author


  		




  
  57
  
    
 SELECT DISTINCT "Ecatalog_all"."scientificName" AS taxon_name_with_author


  		




  58
  58
  
    
   FROM "Ecatalog_all"


  		




  59
  
  
    
  WHERE (("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL));


  		




  
  59
  
    
  WHERE ((("Ecatalog_all".genus IS NOT NULL) AND ("Ecatalog_all"."specificEpithet" IS NOT NULL)) AND ("Ecatalog_all".subspecies IS NOT NULL));


  		




  60
  60
  
    
/*


  		




  61
  61
  
    
Check: should return 40145 rows


  		




  62
  62
  
    
*/


  		












Also available in:  Unified diff