Project

General

Profile

« Previous | Next » 

Revision 13042

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql, NY/qualitative_validations_source_db_NYBG.VegCore.sql, inputs/NY/validations.sql: *_of_species_binomials: renamed columns to species_binomial to reflect reverted query name

View differences:

trunk/inputs/NY/validations.sql
72 72 
--
73 73 

  		




  74
  74
  
    
CREATE VIEW _specimens_04_count_of_species_binomials AS


  		




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


  		




  
  75
  
    
 SELECT count(DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet")) AS species_binomials


  		




  76
  76
  
    
   FROM "Ecatalog_all"


  		




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


  		




  78
  78
  
    

  		




  ......




  91
  91
  
    
--


  		




  92
  92
  
    

  		




  93
  93
  
    
CREATE VIEW _specimens_05_list_of_species_binomials AS


  		




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


  		




  
  94
  
    
 SELECT DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet") AS species_binomial


  		




  95
  95
  
    
   FROM "Ecatalog_all"


  		




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


  		




  97
  97
  
    

  		












  

    
      trunk/validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql
    
  





  30
  30
  
    
*/


  		




  31
  31
  
    

  		




  32
  32
  
    
-- _specimens_04_count_of_species_binomials


  		




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


  		




  
  33
  
    
 SELECT count(DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet")) AS species_binomials


  		




  34
  34
  
    
   FROM "Ecatalog_all"


  		




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


  		




  36
  36
  
    
/*


  		




  ......




  38
  38
  
    
*/


  		




  39
  39
  
    

  		




  40
  40
  
    
-- _specimens_05_list_of_species_binomials


  		




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


  		




  
  41
  
    
 SELECT DISTINCT concat_ws(' '::text, "Ecatalog_all".genus, "Ecatalog_all"."specificEpithet") AS species_binomial


  		




  42
  42
  
    
   FROM "Ecatalog_all"


  		




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


  		




  44
  44
  
    
/*


  		












  

    
      trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
    
  





  34
  34
  
    
;


  		




  35
  35
  
    

  		




  36
  36
  
    
CREATE VIEW _specimens_04_count_of_species_binomials AS


  		




  37
  
  
    
SELECT count(DISTINCT taxonlabel.taxonomicname) AS taxon_names_with_author


  		




  
  37
  
    
SELECT count(DISTINCT taxonlabel.taxonomicname) AS species_binomials


  		




  38
  38
  
    
FROM taxonlabel


  		




  39
  39
  
    
WHERE taxonlabel.source_id = (SELECT source_by_shortname('NY'))


  		




  40
  40
  
    
AND taxonlabel.taxonomicname IS NOT NULL


  		




  41
  41
  
    
;


  		




  42
  42
  
    

  		




  43
  43
  
    
CREATE VIEW _specimens_05_list_of_species_binomials AS


  		




  44
  
  
    
SELECT DISTINCT taxonlabel.taxonomicname AS taxon_name_with_author


  		




  
  44
  
    
SELECT DISTINCT taxonlabel.taxonomicname AS species_binomial


  		




  45
  45
  
    
FROM taxonlabel


  		




  46
  46
  
    
WHERE taxonlabel.source_id = (SELECT source_by_shortname('NY'))


  		




  47
  47
  
    
AND taxonlabel.taxonomicname IS NOT NULL


  		












Also available in:  Unified diff