Project

General

Profile

« Previous | Next » 

Revision 13112

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: inputs/NY/Ecatalog_all/map.csv: ScientificName: remapped to scientificName instead of taxonName as this does include the author

View differences:

validations.sql
110 110 
--
111 111 

  		




  112
  112
  
    
CREATE VIEW _specimens_06_count_of_unique_verb_subsp_taxa_with_author AS


  		




  113
  
  
    
 SELECT count(DISTINCT "Ecatalog_all"."taxonName") AS taxon_names_with_author


  		




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


  		




  114
  114
  
    
   FROM "Ecatalog_all"


  		




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


  		




  116
  116
  
    

  		




  ......




  129
  129
  
    
--


  		




  130
  130
  
    

  		




  131
  131
  
    
CREATE VIEW _specimens_07_list_of_verbatim_subspecific_taxa_with_author AS


  		




  132
  
  
    
 SELECT DISTINCT "Ecatalog_all"."taxonName" AS taxon_name_with_author


  		




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


  		




  133
  133
  
    
   FROM "Ecatalog_all"


  		




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


  		




  135
  135
  
    

  		












Also available in:  Unified diff