Project

General

Profile

« Previous | Next » 

Revision 9960

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/IRMNG/: added family_homonym_epithet, genus_homonym_epithet lookup tables, which use util.all_same() to filter out internal Plantae homonyms

View differences:

inputs/IRMNG/import_order.txt
1 1 
Source
2 2 
family_homonyms
3 
family_homonym_epithet
3 4 
genus_homonyms
5 
genus_homonym_epithet
4 6 
species_homonyms
inputs/IRMNG/family_homonym_epithet/create.sql
1 
SELECT "taxonNameOrEpithet"
2 
FROM family_homonyms
3 
GROUP BY "taxonNameOrEpithet"
4 
HAVING NOT util.all_same(kingdom) -- not internal Plantae homonyms
5 
;
6 

  		




  
  7
  
    
ALTER TABLE :table ADD PRIMARY KEY ("taxonNameOrEpithet");


  		












  

    
      inputs/IRMNG/family_homonym_epithet/header.csv
    
  





  
  1
  
    
taxonNameOrEpithet


  		












  

    
      inputs/IRMNG/genus_homonym_epithet/create.sql
    
  





  
  1
  
    
SELECT "taxonNameOrEpithet"


  		




  
  2
  
    
FROM genus_homonyms


  		




  
  3
  
    
GROUP BY "taxonNameOrEpithet"


  		




  
  4
  
    
HAVING NOT util.all_same(kingdom) -- not internal Plantae homonyms


  		




  
  5
  
    
;


  		




  
  6
  
    

  		




  
  7
  
    
ALTER TABLE :table ADD PRIMARY KEY ("taxonNameOrEpithet");


  		












  

    
      inputs/IRMNG/genus_homonym_epithet/header.csv
    
  





  
  1
  
    
taxonNameOrEpithet


  		












Also available in:  Unified diff