Project

General

Profile

« Previous | Next » 

Revision 9960

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