Project

General

Profile

« Previous | Next » 

Revision 13037

Added by Aaron Marcuse-Kubitza over 10 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql, NY/qualitative_validations_source_db_NYBG.VegCore.sql, inputs/NY/validations.sql: *_of_verbatim_subspecific_taxa_without_author, etc.: renamed to *_with_author because these now use the concatenated name, rather than the without-author name that only some specimens datasources provide

View differences:

validations.sql
106 106 

  		




  107
  107
  
    

  		




  108
  108
  
    
--


  		




  109
  
  
    
-- Name: _specimens_06_count_of_unique_verb_subsp_taxa_without_author; Type: VIEW; Schema: NY; Owner: -


  		




  
  109
  
    
-- Name: _specimens_06_count_of_unique_verb_subsp_taxa_with_author; Type: VIEW; Schema: NY; Owner: -


  		




  110
  110
  
    
--


  		




  111
  111
  
    

  		




  112
  
  
    
CREATE VIEW _specimens_06_count_of_unique_verb_subsp_taxa_without_author AS


  		




  
  112
  
    
CREATE VIEW _specimens_06_count_of_unique_verb_subsp_taxa_with_author AS


  		




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


  		




  114
  114
  
    
   FROM "Ecatalog_all"


  		




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


  		




  116
  116
  
    

  		




  117
  117
  
    

  		




  118
  118
  
    
--


  		




  119
  
  
    
-- Name: VIEW _specimens_06_count_of_unique_verb_subsp_taxa_without_author; Type: COMMENT; Schema: NY; Owner: -


  		




  
  119
  
    
-- Name: VIEW _specimens_06_count_of_unique_verb_subsp_taxa_with_author; Type: COMMENT; Schema: NY; Owner: -


  		




  120
  120
  
    
--


  		




  121
  121
  
    

  		




  122
  
  
    
COMMENT ON VIEW _specimens_06_count_of_unique_verb_subsp_taxa_without_author IS '


  		




  
  122
  
    
COMMENT ON VIEW _specimens_06_count_of_unique_verb_subsp_taxa_with_author IS '


  		




  123
  123
  
    
Check: should return 1 row


  		




  124
  124
  
    
';


  		




  125
  125
  
    

  		




  126
  126
  
    

  		




  127
  127
  
    
--


  		




  128
  
  
    
-- Name: _specimens_07_list_of_verbatim_subspecific_taxa_without_author; Type: VIEW; Schema: NY; Owner: -


  		




  
  128
  
    
-- Name: _specimens_07_list_of_verbatim_subspecific_taxa_with_author; Type: VIEW; Schema: NY; Owner: -


  		




  129
  129
  
    
--


  		




  130
  130
  
    

  		




  131
  
  
    
CREATE VIEW _specimens_07_list_of_verbatim_subspecific_taxa_without_author AS


  		




  
  131
  
    
CREATE VIEW _specimens_07_list_of_verbatim_subspecific_taxa_with_author AS


  		




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


  		




  133
  133
  
    
   FROM "Ecatalog_all"


  		




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


  		




  135
  135
  
    

  		




  136
  136
  
    

  		




  137
  137
  
    
--


  		




  138
  
  
    
-- Name: VIEW _specimens_07_list_of_verbatim_subspecific_taxa_without_author; Type: COMMENT; Schema: NY; Owner: -


  		




  
  138
  
    
-- Name: VIEW _specimens_07_list_of_verbatim_subspecific_taxa_with_author; Type: COMMENT; Schema: NY; Owner: -


  		




  139
  139
  
    
--


  		




  140
  140
  
    

  		




  141
  
  
    
COMMENT ON VIEW _specimens_07_list_of_verbatim_subspecific_taxa_without_author IS '


  		




  
  141
  
    
COMMENT ON VIEW _specimens_07_list_of_verbatim_subspecific_taxa_with_author IS '


  		




  142
  142
  
    
Check: should return 40145 rows


  		




  143
  143
  
    
';


  		




  144
  144
  
    

  		












Also available in:  Unified diff