Project

General

Profile

« Previous | Next » 

Revision 14281

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: taxon_match: added derived columns scrubbed_*

View differences:

trunk/inputs/.TNRS/data.sql
34 34 
-- Data for Name: taxon_match; Type: TABLE DATA; Schema: TNRS; Owner: -
35 35 
--
36 36 

  		




  37
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 0, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Compositae/', NULL, NULL, 'Compositae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Accepted', 'Compositae', NULL, 'family', 'http://www.theplantlist.org/1.1/browse/A/Compositae/', NULL, NULL, 'true', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae', NULL, 'Compositae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae');


  		




  38
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 1, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, NULL, NULL, NULL, NULL, 'Compositae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Accepted', 'Compositae', NULL, 'family', NULL, NULL, NULL, 'false', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae', NULL, 'Compositae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae');


  		




  39
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 2, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, 'Giseke', 'http://www.tropicos.org/Name/50255940', NULL, NULL, 'Compositae', 1, 'Compositae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Synonym', 'Asteraceae', 'Bercht. & J. Presl', 'family', 'http://www.tropicos.org/Name/50307371', NULL, 'Asteraceae', 'false', 'tropicos', ' ', NULL, true, 'Asteraceae Bercht. & J. Presl', NULL, 'Compositae Giseke', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Asteraceae Bercht. & J. Presl');


  		




  40
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 3, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', NULL, 'Fagaceae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae');


  		




  41
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 4, 1, 'Fabaceae Boyle#6500', 0.900000000000000022, 'Fabaceae', 'family', 1, 'Lindl.', 'http://www.tropicos.org/Name/42000184', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fabaceae', 'Lindl.', 'family', 'http://www.tropicos.org/Name/42000184', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', NULL, 'Fabaceae Lindl.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae Lindl.');


  		




  42
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 5, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', NULL, 'Fagaceae Dumort.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae Dumort.');


  		




  43
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 6, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Ficaceae', 'family', 0.770000000000000018, 'Bercht. & J. Presl', 'http://www.tropicos.org/Name/100353631', NULL, NULL, 'Ficaceae', 0.75, 'Ficaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Ficaceae Bercht. & J. Presl', NULL, 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


  		




  44
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 7, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', NULL, 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


  		




  45
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 8, 1, 'Fabaceae Boyle#6500', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', NULL, 'Fabaceae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae');


  		




  46
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 9, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Accepted', 'Inga', NULL, 'genus', 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, 'Fabaceae', 'true', 'tpl;usda', ' ', NULL, true, 'Fabaceae Inga', NULL, 'Inga', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga');


  		




  47
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 10, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', NULL, 'Inga Mill.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga Mill.');


  		




  48
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 11, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', NULL, 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


  		




  49
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 12, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Accepted', 'Inga', NULL, 'genus', 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, 'Fabaceae', 'true', 'tpl;usda', ' ', NULL, true, 'Fabaceae Inga', NULL, 'Inga', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga');


  		




  50
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 13, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', NULL, 'Inga Mill.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga Mill.');


  		




  51
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 14, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', NULL, 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


  		




  52
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 15, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', NULL, 'Fagaceae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae');


  		




  53
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 16, 4, 'Fabaceae unknown #2', 0.900000000000000022, 'Fabaceae', 'family', 1, 'Lindl.', 'http://www.tropicos.org/Name/42000184', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fabaceae', 'Lindl.', 'family', 'http://www.tropicos.org/Name/42000184', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', NULL, 'Fabaceae Lindl.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae Lindl.');


  		




  54
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 17, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', NULL, 'Fagaceae Dumort.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae Dumort.');


  		




  55
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 18, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Ficaceae', 'family', 0.770000000000000018, 'Bercht. & J. Presl', 'http://www.tropicos.org/Name/100353631', NULL, NULL, 'Ficaceae', 0.75, 'Ficaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Ficaceae Bercht. & J. Presl', NULL, 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


  		




  56
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 19, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', NULL, 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


  		




  57
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 20, 4, 'Fabaceae unknown #2', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', NULL, 'Fabaceae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae');


  		




  58
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 21, 5, 'Fam_indet. Boyle#6501', 0, 'No suitable matches found.', NULL, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'true', NULL, ' ', NULL, false, NULL, NULL, 'No suitable matches found.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


  		




  59
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 22, 6, 'Poa annua', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', 'Poa annua', 'Poaceae', 'true', 'tpl;tropicos;usda', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua L.', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.');


  		




  60
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 23, 6, 'Poa annua', 1, 'Poa annua', 'species', 1, 'Cham. & Schltdl.', 'http://www.theplantlist.org/tpl1.1/record/kew-435195', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'false', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua Cham. & Schltdl.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth');


  		




  61
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 24, 7, 'Poa annua L.', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', 'L.', 1, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', 'Poa annua', 'Poaceae', 'true', 'tpl;tropicos;usda', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua L.', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.');


  		




  62
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 25, 7, 'Poa annua L.', 0.800000000000000044, 'Poa annua', 'species', 1, 'Cham. & Schltdl.', 'http://www.theplantlist.org/tpl1.1/record/kew-435195', 'Cham. & Schltdl.', 0, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'false', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua Cham. & Schltdl.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth');


  		




  63
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 26, 8, 'Poa annua fo. lanuginosa', 1, 'Poa annua fo. lanuginosa', 'fo.', 1, 'Sennen', 'http://www.theplantlist.org/tpl1.1/record/tro-50267771', NULL, NULL, NULL, NULL, NULL, 'Poa', 1, 'annua', 1, 'fo.', 'lanuginosa', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194', 'Poa annua', 'Poaceae', 'true', 'tpl', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua fo. lanuginosa Sennen', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.');


  		




  64
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 27, 8, 'Poa annua fo. lanuginosa', 1, 'Poa annua fo. lanuginosa', 'forma', 1, 'Sennen', 'http://www.tropicos.org/Name/50267771', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'fo.', 'lanuginosa', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua var. annua', NULL, 'variety', 'http://www.tropicos.org/Name/25517736', 'Poa annua', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua var. annua', 'Poa annua', 'Poa annua fo. lanuginosa Sennen', true, '{Poa,annua}', 'Poa', 'annua', 'var. annua', '{var.,annua}', 'var.', 'annua', 'Poa annua var. annua');


  		




  65
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 28, 9, 'Poa annua ssp. exilis', 1, 'Poa annua subsp. exilis', 'subspecies', 1, '(Tomm. ex Freyn) Asch. & Graebn.', 'http://www.tropicos.org/Name/50063800', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'true', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth');


  		




  66
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 29, 9, 'Poa annua ssp. exilis', 0.959999999999999964, 'Poa annua var. exilis', 'variety', 0.959999999999999964, 'Tomm. ex Freyn', 'http://www.tropicos.org/Name/25547854', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'exilis', 0.699999999999999956, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua var. exilis Tomm. ex Freyn', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth');


  		




  67
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 30, 10, 'Poa annua subsp. exilis', 1, 'Poa annua subsp. exilis', 'subsp.', 1, '(Tomm. ex Freyn.) Asch. & Graebn.', 'http://www.theplantlist.org/tpl1.1/record/kew-435202', NULL, NULL, NULL, NULL, NULL, 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'true', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn.) Asch. & Graebn.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth');


  		




  68
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 31, 10, 'Poa annua subsp. exilis', 1, 'Poa annua subsp. exilis', 'subspecies', 1, '(Tomm. ex Freyn) Asch. & Graebn.', 'http://www.tropicos.org/Name/50063800', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth');


  		




  69
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 32, 11, 'Poa annua subvar. minima', 1, 'Poa annua subvar. minima', 'subvariety', 1, '(Schur) Asch. & Graebn.', 'http://www.tropicos.org/Name/50158097', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subvar.', 'minima', 1, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua subvar. minima', '(Schur) Asch. & Graebn.', 'subvariety', 'http://www.tropicos.org/Name/50158097', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.', 'Poa annua', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', true, '{Poa,annua}', 'Poa', 'annua', 'subvar. minima', '{subvar.,minima}', 'subvar.', 'minima', 'Poa annua subvar. minima (Schur) Asch. & Graebn.');


  		




  70
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 33, 12, 'Poa annua var. eriolepis', 1, 'Poa annua var. eriolepis', 'var.', 1, '̉ۡ.Desv.', 'http://www.theplantlist.org/tpl1.1/record/kew-435206', NULL, NULL, NULL, NULL, NULL, 'Poa', 1, 'annua', 1, 'var.', 'eriolepis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194', 'Poa annua', 'Poaceae', 'true', 'tpl', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua var. eriolepis ̉ۡ.Desv.', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.');


  		




  71
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 34, 12, 'Poa annua var. eriolepis', 1, 'Poa annua var. eriolepis', 'variety', 1, 'E. Desv.', 'http://www.tropicos.org/Name/50119145', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'eriolepis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.tropicos.org/Name/25509881', 'Poa annua', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua var. eriolepis E. Desv.', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.');


  		




  72
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 35, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subsp.', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', 'Silene scouleri', 'Caryophyllaceae', 'true', 'tpl', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  73
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 36, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'false', 'tropicos', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  74
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 37, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://plants.usda.gov/java/profile?symbol=SISCP', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://plants.usda.gov/java/profile?symbol=SISCP', 'Silene scouleri', 'Caryophyllaceae', 'false', 'usda', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'ssp. pringlei', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  75
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 38, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subsp.', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', 'Silene scouleri', 'Caryophyllaceae', 'true', 'tpl', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  76
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 39, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'false', 'tropicos', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  77
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 40, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://plants.usda.gov/java/profile?symbol=SISCP', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://plants.usda.gov/java/profile?symbol=SISCP', 'Silene scouleri', 'Caryophyllaceae', 'false', 'usda', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'ssp. pringlei', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  
  37
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 0, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Compositae/', NULL, NULL, 'Compositae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Accepted', 'Compositae', NULL, 'family', 'http://www.theplantlist.org/1.1/browse/A/Compositae/', NULL, NULL, 'true', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae', NULL, 'Compositae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', NULL, 'Compositae');


  		




  
  38
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 1, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, NULL, NULL, NULL, NULL, 'Compositae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Accepted', 'Compositae', NULL, 'family', NULL, NULL, NULL, 'false', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae', NULL, 'Compositae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', NULL, 'Compositae');


  		




  
  39
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 2, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, 'Giseke', 'http://www.tropicos.org/Name/50255940', NULL, NULL, 'Compositae', 1, 'Compositae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Synonym', 'Asteraceae', 'Bercht. & J. Presl', 'family', 'http://www.tropicos.org/Name/50307371', NULL, 'Asteraceae', 'false', 'tropicos', ' ', NULL, true, 'Asteraceae Bercht. & J. Presl', NULL, 'Compositae Giseke', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Asteraceae Bercht. & J. Presl', 'family', 'Asteraceae', NULL, NULL, NULL, NULL, NULL, 'Asteraceae', 'Bercht. & J. Presl', 'Asteraceae Bercht. & J. Presl');


  		




  
  40
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 3, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', NULL, 'Fagaceae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', NULL, 'Fagaceae');


  		




  
  41
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 4, 1, 'Fabaceae Boyle#6500', 0.900000000000000022, 'Fabaceae', 'family', 1, 'Lindl.', 'http://www.tropicos.org/Name/42000184', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fabaceae', 'Lindl.', 'family', 'http://www.tropicos.org/Name/42000184', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', NULL, 'Fabaceae Lindl.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'family', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.');


  		




  
  42
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 5, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', NULL, 'Fagaceae Dumort.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'family', 'Fagaceae', NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.');


  		




  
  43
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 6, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Ficaceae', 'family', 0.770000000000000018, 'Bercht. & J. Presl', 'http://www.tropicos.org/Name/100353631', NULL, NULL, 'Ficaceae', 0.75, 'Ficaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Ficaceae Bercht. & J. Presl', NULL, 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Ficaceae', NULL, NULL, NULL, NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl');


  		




  
  44
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 7, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', NULL, 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Fucaceae', NULL, NULL, NULL, NULL, NULL, 'Fucaceae', NULL, 'Fucaceae');


  		




  
  45
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 8, 1, 'Fabaceae Boyle#6500', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', NULL, 'Fabaceae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', NULL, 'Fabaceae');


  		




  
  46
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 9, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Accepted', 'Inga', NULL, 'genus', 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, 'Fabaceae', 'true', 'tpl;usda', ' ', NULL, true, 'Fabaceae Inga', NULL, 'Inga', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', NULL, 'Inga');


  		




  
  47
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 10, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', NULL, 'Inga Mill.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga Mill.', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');


  		




  
  48
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 11, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', NULL, 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'genus', 'Fabaceae', 'Inga', NULL, NULL, NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.');


  		




  
  49
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 12, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Accepted', 'Inga', NULL, 'genus', 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, 'Fabaceae', 'true', 'tpl;usda', ' ', NULL, true, 'Fabaceae Inga', NULL, 'Inga', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', NULL, 'Inga');


  		




  
  50
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 13, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', NULL, 'Inga Mill.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga Mill.', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');


  		




  
  51
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 14, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', NULL, 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'genus', 'Fabaceae', 'Inga', NULL, NULL, NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.');


  		




  
  52
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 15, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', NULL, 'Fagaceae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', NULL, 'Fagaceae');


  		




  
  53
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 16, 4, 'Fabaceae unknown #2', 0.900000000000000022, 'Fabaceae', 'family', 1, 'Lindl.', 'http://www.tropicos.org/Name/42000184', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fabaceae', 'Lindl.', 'family', 'http://www.tropicos.org/Name/42000184', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', NULL, 'Fabaceae Lindl.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'family', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.');


  		




  
  54
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 17, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', NULL, 'Fagaceae Dumort.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'family', 'Fagaceae', NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.');


  		




  
  55
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 18, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Ficaceae', 'family', 0.770000000000000018, 'Bercht. & J. Presl', 'http://www.tropicos.org/Name/100353631', NULL, NULL, 'Ficaceae', 0.75, 'Ficaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Ficaceae Bercht. & J. Presl', NULL, 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Ficaceae', NULL, NULL, NULL, NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl');


  		




  
  56
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 19, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', NULL, 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Fucaceae', NULL, NULL, NULL, NULL, NULL, 'Fucaceae', NULL, 'Fucaceae');


  		




  
  57
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 20, 4, 'Fabaceae unknown #2', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', NULL, 'Fabaceae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', NULL, 'Fabaceae');


  		




  
  58
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 21, 5, 'Fam_indet. Boyle#6501', 0, 'No suitable matches found.', NULL, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'true', NULL, ' ', NULL, false, NULL, NULL, 'No suitable matches found.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'No suitable matches found.', NULL, 'No suitable matches found.');


  		




  
  59
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 22, 6, 'Poa annua', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', 'Poa annua', 'Poaceae', 'true', 'tpl;tropicos;usda', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua L.', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  
  60
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 23, 6, 'Poa annua', 1, 'Poa annua', 'species', 1, 'Cham. & Schltdl.', 'http://www.theplantlist.org/tpl1.1/record/kew-435195', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'false', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua Cham. & Schltdl.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  
  61
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 24, 7, 'Poa annua L.', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', 'L.', 1, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', 'Poa annua', 'Poaceae', 'true', 'tpl;tropicos;usda', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua L.', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  
  62
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 25, 7, 'Poa annua L.', 0.800000000000000044, 'Poa annua', 'species', 1, 'Cham. & Schltdl.', 'http://www.theplantlist.org/tpl1.1/record/kew-435195', 'Cham. & Schltdl.', 0, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'false', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua Cham. & Schltdl.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  
  63
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 26, 8, 'Poa annua fo. lanuginosa', 1, 'Poa annua fo. lanuginosa', 'fo.', 1, 'Sennen', 'http://www.theplantlist.org/tpl1.1/record/tro-50267771', NULL, NULL, NULL, NULL, NULL, 'Poa', 1, 'annua', 1, 'fo.', 'lanuginosa', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194', 'Poa annua', 'Poaceae', 'true', 'tpl', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua fo. lanuginosa Sennen', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  
  64
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 27, 8, 'Poa annua fo. lanuginosa', 1, 'Poa annua fo. lanuginosa', 'forma', 1, 'Sennen', 'http://www.tropicos.org/Name/50267771', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'fo.', 'lanuginosa', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua var. annua', NULL, 'variety', 'http://www.tropicos.org/Name/25517736', 'Poa annua', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua var. annua', 'Poa annua', 'Poa annua fo. lanuginosa Sennen', true, '{Poa,annua}', 'Poa', 'annua', 'var. annua', '{var.,annua}', 'var.', 'annua', 'Poa annua var. annua', 'variety', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'var.', 'annua', 'Poa annua var. annua', NULL, 'Poa annua var. annua');


  		




  
  65
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 28, 9, 'Poa annua ssp. exilis', 1, 'Poa annua subsp. exilis', 'subspecies', 1, '(Tomm. ex Freyn) Asch. & Graebn.', 'http://www.tropicos.org/Name/50063800', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'true', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  
  66
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 29, 9, 'Poa annua ssp. exilis', 0.959999999999999964, 'Poa annua var. exilis', 'variety', 0.959999999999999964, 'Tomm. ex Freyn', 'http://www.tropicos.org/Name/25547854', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'exilis', 0.699999999999999956, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua var. exilis Tomm. ex Freyn', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  
  67
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 30, 10, 'Poa annua subsp. exilis', 1, 'Poa annua subsp. exilis', 'subsp.', 1, '(Tomm. ex Freyn.) Asch. & Graebn.', 'http://www.theplantlist.org/tpl1.1/record/kew-435202', NULL, NULL, NULL, NULL, NULL, 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'true', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn.) Asch. & Graebn.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  
  68
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 31, 10, 'Poa annua subsp. exilis', 1, 'Poa annua subsp. exilis', 'subspecies', 1, '(Tomm. ex Freyn) Asch. & Graebn.', 'http://www.tropicos.org/Name/50063800', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  
  69
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 32, 11, 'Poa annua subvar. minima', 1, 'Poa annua subvar. minima', 'subvariety', 1, '(Schur) Asch. & Graebn.', 'http://www.tropicos.org/Name/50158097', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subvar.', 'minima', 1, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua subvar. minima', '(Schur) Asch. & Graebn.', 'subvariety', 'http://www.tropicos.org/Name/50158097', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.', 'Poa annua', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', true, '{Poa,annua}', 'Poa', 'annua', 'subvar. minima', '{subvar.,minima}', 'subvar.', 'minima', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', 'subvariety', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'subvar.', 'annua', 'Poa annua subvar. minima', '(Schur) Asch. & Graebn.', 'Poa annua subvar. minima (Schur) Asch. & Graebn.');


  		




  
  70
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 33, 12, 'Poa annua var. eriolepis', 1, 'Poa annua var. eriolepis', 'var.', 1, '̉ۡ.Desv.', 'http://www.theplantlist.org/tpl1.1/record/kew-435206', NULL, NULL, NULL, NULL, NULL, 'Poa', 1, 'annua', 1, 'var.', 'eriolepis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194', 'Poa annua', 'Poaceae', 'true', 'tpl', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua var. eriolepis ̉ۡ.Desv.', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  
  71
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 34, 12, 'Poa annua var. eriolepis', 1, 'Poa annua var. eriolepis', 'variety', 1, 'E. Desv.', 'http://www.tropicos.org/Name/50119145', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'eriolepis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.tropicos.org/Name/25509881', 'Poa annua', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua var. eriolepis E. Desv.', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  
  72
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 35, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subsp.', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', 'Silene scouleri', 'Caryophyllaceae', 'true', 'tpl', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  
  73
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 36, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'false', 'tropicos', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  
  74
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 37, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://plants.usda.gov/java/profile?symbol=SISCP', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://plants.usda.gov/java/profile?symbol=SISCP', 'Silene scouleri', 'Caryophyllaceae', 'false', 'usda', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'ssp. pringlei', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'ssp.', 'scouleri', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  
  75
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 38, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subsp.', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', 'Silene scouleri', 'Caryophyllaceae', 'true', 'tpl', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  
  76
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 39, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'false', 'tropicos', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  
  77
  
    
INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 40, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://plants.usda.gov/java/profile?symbol=SISCP', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://plants.usda.gov/java/profile?symbol=SISCP', 'Silene scouleri', 'Caryophyllaceae', 'false', 'usda', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'ssp. pringlei', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'ssp.', 'scouleri', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  78
  78
  
    

  		




  79
  79
  
    

  		




  80
  80
  
    
--


  		












  

    
      trunk/inputs/.TNRS/schema.sql
    
  





  195
  195
  
    
    LANGUAGE plpgsql


  		




  196
  196
  
    
    AS $$


  		




  197
  197
  
    
BEGIN


  		




  
  198
  
    
	new."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT


  		




  
  199
  
    
		("*Genus_matched" || ' '::text) || "*Specific_epithet_matched"


  		




  
  200
  
    
		FROM (SELECT new.*) new);


  		




  
  201
  
    
	


  		




  
  202
  
    
	new."[matched_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT


  		




  
  203
  
    
		"*Name_matched" || COALESCE((' '::text || "*Name_matched_author"), ''::text)


  		




  
  204
  
    
		FROM (SELECT new.*) new);


  		




  
  205
  
    
	


  		




  
  206
  
    
	new.matched_has_accepted = (SELECT


  		




  
  207
  
    
		"*Accepted_name" IS NOT NULL


  		




  
  208
  
    
		FROM (SELECT new.*) new);


  		




  
  209
  
    
	


  		




  198
  210
  
    
	new."__accepted_{genus,specific_epithet}" = (SELECT


  		




  199
  211
  
    
		regexp_split_to_array("*Accepted_name_species", ' '::text)


  		




  200
  212
  
    
		FROM (SELECT new.*) new);


  		




  ......




  223
  235
  
    
		"__accepted_infraspecific_{rank,epithet}"[2]


  		




  224
  236
  
    
		FROM (SELECT new.*) new);


  		




  225
  237
  
    
	


  		




  226
  
  
    
	new."[matched_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT


  		




  227
  
  
    
		"*Name_matched" || COALESCE((' '::text || "*Name_matched_author"), ''::text)


  		




  228
  
  
    
		FROM (SELECT new.*) new);


  		




  229
  
  
    
	


  		




  230
  238
  
    
	new."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT


  		




  231
  239
  
    
		"*Accepted_name" || COALESCE((' '::text || "*Accepted_name_author"), ''::text)


  		




  232
  240
  
    
		FROM (SELECT new.*) new);


  		




  233
  241
  
    
	


  		




  234
  
  
    
	new.matched_has_accepted = (SELECT


  		




  235
  
  
    
		"*Accepted_name" IS NOT NULL


  		




  
  242
  
    
	new."[scrubbed_]taxonRank__@DwC__@vegpath.org" = (SELECT


  		




  
  243
  
    
		CASE


  		




  
  244
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_rank"


  		




  
  245
  
    
        ELSE "*Name_matched_rank"


  		




  
  246
  
    
    END


  		




  236
  247
  
    
		FROM (SELECT new.*) new);


  		




  237
  248
  
    
	


  		




  238
  
  
    
	new."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT


  		




  239
  
  
    
		("*Genus_matched" || ' '::text) || "*Specific_epithet_matched"


  		




  
  249
  
    
	new."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT


  		




  
  250
  
    
		CASE


  		




  
  251
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_family"


  		




  
  252
  
    
        ELSE "*Name_matched_accepted_family"


  		




  
  253
  
    
    END


  		




  240
  254
  
    
		FROM (SELECT new.*) new);


  		




  241
  255
  
    
	


  		




  
  256
  
    
	new."[scrubbed_]genus__@DwC__@vegpath.org" = (SELECT


  		




  
  257
  
    
		CASE


  		




  
  258
  
    
        WHEN matched_has_accepted THEN "[accepted_]genus__@DwC__@vegpath.org"


  		




  
  259
  
    
        ELSE "*Genus_matched"


  		




  
  260
  
    
    END


  		




  
  261
  
    
		FROM (SELECT new.*) new);


  		




  
  262
  
    
	


  		




  
  263
  
    
	new."[scrubbed_]specificEpithet__@DwC__@vegpath.org" = (SELECT


  		




  
  264
  
    
		CASE


  		




  
  265
  
    
        WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"


  		




  
  266
  
    
        ELSE "*Specific_epithet_matched"


  		




  
  267
  
    
    END


  		




  
  268
  
    
		FROM (SELECT new.*) new);


  		




  
  269
  
    
	


  		




  
  270
  
    
	new."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT


  		




  
  271
  
    
		CASE


  		




  
  272
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_species"


  		




  
  273
  
    
        ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org"


  		




  
  274
  
    
    END


  		




  
  275
  
    
		FROM (SELECT new.*) new);


  		




  
  276
  
    
	


  		




  
  277
  
    
	new."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = (SELECT


  		




  
  278
  
    
		CASE


  		




  
  279
  
    
        WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"


  		




  
  280
  
    
        ELSE "*Infraspecific_rank"


  		




  
  281
  
    
    END


  		




  
  282
  
    
		FROM (SELECT new.*) new);


  		




  
  283
  
    
	


  		




  
  284
  
    
	new."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" = (SELECT


  		




  
  285
  
    
		CASE


  		




  
  286
  
    
        WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"


  		




  
  287
  
    
        ELSE "*Infraspecific_epithet_matched"


  		




  
  288
  
    
    END


  		




  
  289
  
    
		FROM (SELECT new.*) new);


  		




  
  290
  
    
	


  		




  
  291
  
    
	new."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT


  		




  
  292
  
    
		CASE


  		




  
  293
  
    
        WHEN matched_has_accepted THEN "*Accepted_name"


  		




  
  294
  
    
        ELSE "*Name_matched"


  		




  
  295
  
    
    END


  		




  
  296
  
    
		FROM (SELECT new.*) new);


  		




  
  297
  
    
	


  		




  
  298
  
    
	new."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT


  		




  
  299
  
    
		CASE


  		




  
  300
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_author"


  		




  
  301
  
    
        ELSE "*Name_matched_author"


  		




  
  302
  
    
    END


  		




  
  303
  
    
		FROM (SELECT new.*) new);


  		




  
  304
  
    
	


  		




  
  305
  
    
	new."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT


  		




  
  306
  
    
		CASE


  		




  
  307
  
    
        WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  
  308
  
    
        ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  
  309
  
    
    END


  		




  
  310
  
    
		FROM (SELECT new.*) new);


  		




  
  311
  
    
	


  		




  242
  312
  
    
	RETURN new;


  		




  243
  313
  
    
END;


  		




  244
  314
  
    
$$;


  		




  ......




  380
  450
  
    
    "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" text,


  		




  381
  451
  
    
    "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" text,


  		




  382
  452
  
    
    "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" text,


  		




  
  453
  
    
    "[scrubbed_]taxonRank__@DwC__@vegpath.org" text,


  		




  
  454
  
    
    "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" text,


  		




  
  455
  
    
    "[scrubbed_]genus__@DwC__@vegpath.org" text,


  		




  
  456
  
    
    "[scrubbed_]specificEpithet__@DwC__@vegpath.org" text,


  		




  
  457
  
    
    "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" text,


  		




  
  458
  
    
    "[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" text,


  		




  
  459
  
    
    "[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" text,


  		




  
  460
  
    
    "[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" text,


  		




  
  461
  
    
    "[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" text,


  		




  
  462
  
    
    "[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" text,


  		




  383
  463
  
    
    CONSTRAINT "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" CHECK ((NOT ("[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[1]))),


  		




  384
  464
  
    
    CONSTRAINT "[accepted_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]genus__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet}"[1]))),


  		




  385
  465
  
    
    CONSTRAINT "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]infraspecificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[2]))),


  		




  ......




  387
  467
  
    
    CONSTRAINT "[accepted_]specificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]specificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet}"[2]))),


  		




  388
  468
  
    
    CONSTRAINT "[matched_]scientificName[_with_author]__@DwC__@vegpath.org" CHECK ((NOT ("[matched_]scientificName[_with_author]__@DwC__@vegpath.org" IS DISTINCT FROM ("*Name_matched" || COALESCE((' '::text || "*Name_matched_author"), ''::text))))),


  		




  389
  469
  
    
    CONSTRAINT "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM (("*Genus_matched" || ' '::text) || "*Specific_epithet_matched")))),


  		




  
  470
  
    
    CONSTRAINT "[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS DISTINCT FROM


  		




  
  471
  
    
CASE


  		




  
  472
  
    
    WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"


  		




  
  473
  
    
    ELSE "*Infraspecific_rank"


  		




  
  474
  
    
END))),


  		




  
  475
  
    
    CONSTRAINT "[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM


  		




  
  476
  
    
CASE


  		




  
  477
  
    
    WHEN matched_has_accepted THEN "*Accepted_name_author"


  		




  
  478
  
    
    ELSE "*Name_matched_author"


  		




  
  479
  
    
END))),


  		




  
  480
  
    
    CONSTRAINT "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM


  		




  
  481
  
    
CASE


  		




  
  482
  
    
    WHEN matched_has_accepted THEN "*Accepted_name_family"


  		




  
  483
  
    
    ELSE "*Name_matched_accepted_family"


  		




  
  484
  
    
END))),


  		




  
  485
  
    
    CONSTRAINT "[scrubbed_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]genus__@DwC__@vegpath.org" IS DISTINCT FROM


  		




  
  486
  
    
CASE


  		




  
  487
  
    
    WHEN matched_has_accepted THEN "[accepted_]genus__@DwC__@vegpath.org"


  		




  
  488
  
    
    ELSE "*Genus_matched"


  		




  
  489
  
    
END))),


  		




  
  490
  
    
    CONSTRAINT "[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM


  		




  
  491
  
    
CASE


  		




  
  492
  
    
    WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"


  		




  
  493
  
    
    ELSE "*Infraspecific_epithet_matched"


  		




  
  494
  
    
END))),


  		




  
  495
  
    
    CONSTRAINT "[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM


  		




  
  496
  
    
CASE


  		




  
  497
  
    
    WHEN matched_has_accepted THEN "*Accepted_name"


  		




  
  498
  
    
    ELSE "*Name_matched"


  		




  
  499
  
    
END))),


  		




  
  500
  
    
    CONSTRAINT "[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" IS DISTINCT FROM


  		




  
  501
  
    
CASE


  		




  
  502
  
    
    WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  
  503
  
    
    ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  
  504
  
    
END))),


  		




  
  505
  
    
    CONSTRAINT "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM


  		




  
  506
  
    
CASE


  		




  
  507
  
    
    WHEN matched_has_accepted THEN "*Accepted_name_species"


  		




  
  508
  
    
    ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org"


  		




  
  509
  
    
END))),


  		




  
  510
  
    
    CONSTRAINT "[scrubbed_]specificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]specificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM


  		




  
  511
  
    
CASE


  		




  
  512
  
    
    WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"


  		




  
  513
  
    
    ELSE "*Specific_epithet_matched"


  		




  
  514
  
    
END))),


  		




  
  515
  
    
    CONSTRAINT "[scrubbed_]taxonRank__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]taxonRank__@DwC__@vegpath.org" IS DISTINCT FROM


  		




  
  516
  
    
CASE


  		




  
  517
  
    
    WHEN matched_has_accepted THEN "*Accepted_name_rank"


  		




  
  518
  
    
    ELSE "*Name_matched_rank"


  		




  
  519
  
    
END))),


  		




  390
  520
  
    
    CONSTRAINT __accepted_infraspecific_label CHECK ((NOT (__accepted_infraspecific_label IS DISTINCT FROM ltrim(NULLIF(util.remove_prefix("*Accepted_name_species", "*Accepted_name", require := true), ''::text), ' '::text)))),


  		




  391
  521
  
    
    CONSTRAINT "__accepted_infraspecific_{rank,epithet}" CHECK ((NOT ("__accepted_infraspecific_{rank,epithet}" IS DISTINCT FROM regexp_split_to_array(__accepted_infraspecific_label, ' '::text)))),


  		




  392
  522
  
    
    CONSTRAINT "__accepted_{genus,specific_epithet}" CHECK ((NOT ("__accepted_{genus,specific_epithet}" IS DISTINCT FROM regexp_split_to_array("*Accepted_name_species", ' '::text)))),


  		




  ......




  622
  752
  
    

  		




  623
  753
  
    

  		




  624
  754
  
    
--


  		




  
  755
  
    
-- Name: COLUMN taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  756
  
    
--


  		




  
  757
  
    

  		




  
  758
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org" IS '


  		




  
  759
  
    
derived column; = CASE


  		




  
  760
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_rank"


  		




  
  761
  
    
        ELSE "*Name_matched_rank"


  		




  
  762
  
    
    END


  		




  
  763
  
    

  		




  
  764
  
    
to modify expr:


  		




  
  765
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]taxonRank__@DwC__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "*Accepted_name_rank" ELSE "*Name_matched_rank" END$$)::util.derived_col_def);


  		




  
  766
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  767
  
    

  		




  
  768
  
    
to rename:


  		




  
  769
  
    
# rename column


  		




  
  770
  
    
# rename CHECK constraint


  		




  
  771
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  772
  
    
';


  		




  
  773
  
    

  		




  
  774
  
    

  		




  
  775
  
    
--


  		




  
  776
  
    
-- Name: COLUMN taxon_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  777
  
    
--


  		




  
  778
  
    

  		




  
  779
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" IS '


  		




  
  780
  
    
derived column; = CASE


  		




  
  781
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_family"


  		




  
  782
  
    
        ELSE "*Name_matched_accepted_family"


  		




  
  783
  
    
    END


  		




  
  784
  
    

  		




  
  785
  
    
to modify expr:


  		




  
  786
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "*Accepted_name_family" ELSE "*Name_matched_accepted_family" END$$)::util.derived_col_def);


  		




  
  787
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  788
  
    

  		




  
  789
  
    
to rename:


  		




  
  790
  
    
# rename column


  		




  
  791
  
    
# rename CHECK constraint


  		




  
  792
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  793
  
    
';


  		




  
  794
  
    

  		




  
  795
  
    

  		




  
  796
  
    
--


  		




  
  797
  
    
-- Name: COLUMN taxon_match."[scrubbed_]genus__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  798
  
    
--


  		




  
  799
  
    

  		




  
  800
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]genus__@DwC__@vegpath.org" IS '


  		




  
  801
  
    
derived column; = CASE


  		




  
  802
  
    
        WHEN matched_has_accepted THEN "[accepted_]genus__@DwC__@vegpath.org"


  		




  
  803
  
    
        ELSE "*Genus_matched"


  		




  
  804
  
    
    END


  		




  
  805
  
    

  		




  
  806
  
    
to modify expr:


  		




  
  807
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]genus__@DwC__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "[accepted_]genus__@DwC__@vegpath.org" ELSE "*Genus_matched" END$$)::util.derived_col_def);


  		




  
  808
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  809
  
    

  		




  
  810
  
    
to rename:


  		




  
  811
  
    
# rename column


  		




  
  812
  
    
# rename CHECK constraint


  		




  
  813
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  814
  
    
';


  		




  
  815
  
    

  		




  
  816
  
    

  		




  
  817
  
    
--


  		




  
  818
  
    
-- Name: COLUMN taxon_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  819
  
    
--


  		




  
  820
  
    

  		




  
  821
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org" IS '


  		




  
  822
  
    
derived column; = CASE


  		




  
  823
  
    
        WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"


  		




  
  824
  
    
        ELSE "*Specific_epithet_matched"


  		




  
  825
  
    
    END


  		




  
  826
  
    

  		




  
  827
  
    
to modify expr:


  		




  
  828
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]specificEpithet__@DwC__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org" ELSE "*Specific_epithet_matched" END$$)::util.derived_col_def);


  		




  
  829
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  830
  
    

  		




  
  831
  
    
to rename:


  		




  
  832
  
    
# rename column


  		




  
  833
  
    
# rename CHECK constraint


  		




  
  834
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  835
  
    
';


  		




  
  836
  
    

  		




  
  837
  
    

  		




  
  838
  
    
--


  		




  
  839
  
    
-- Name: COLUMN taxon_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  840
  
    
--


  		




  
  841
  
    

  		




  
  842
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" IS '


  		




  
  843
  
    
derived column; = CASE


  		




  
  844
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_species"


  		




  
  845
  
    
        ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org"


  		




  
  846
  
    
    END


  		




  
  847
  
    

  		




  
  848
  
    
to modify expr:


  		




  
  849
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "*Accepted_name_species" ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" END$$)::util.derived_col_def);


  		




  
  850
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  851
  
    

  		




  
  852
  
    
to rename:


  		




  
  853
  
    
# rename column


  		




  
  854
  
    
# rename CHECK constraint


  		




  
  855
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  856
  
    
';


  		




  
  857
  
    

  		




  
  858
  
    

  		




  
  859
  
    
--


  		




  
  860
  
    
-- Name: COLUMN taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  861
  
    
--


  		




  
  862
  
    

  		




  
  863
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS '


  		




  
  864
  
    
derived column; = CASE


  		




  
  865
  
    
        WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"


  		




  
  866
  
    
        ELSE "*Infraspecific_rank"


  		




  
  867
  
    
    END


  		




  
  868
  
    

  		




  
  869
  
    
to modify expr:


  		




  
  870
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" ELSE "*Infraspecific_rank" END$$)::util.derived_col_def);


  		




  
  871
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  872
  
    

  		




  
  873
  
    
to rename:


  		




  
  874
  
    
# rename column


  		




  
  875
  
    
# rename CHECK constraint


  		




  
  876
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  877
  
    
';


  		




  
  878
  
    

  		




  
  879
  
    

  		




  
  880
  
    
--


  		




  
  881
  
    
-- Name: COLUMN taxon_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  882
  
    
--


  		




  
  883
  
    

  		




  
  884
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" IS '


  		




  
  885
  
    
derived column; = CASE


  		




  
  886
  
    
        WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"


  		




  
  887
  
    
        ELSE "*Infraspecific_epithet_matched"


  		




  
  888
  
    
    END


  		




  
  889
  
    

  		




  
  890
  
    
to modify expr:


  		




  
  891
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org" ELSE "*Infraspecific_epithet_matched" END$$)::util.derived_col_def);


  		




  
  892
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  893
  
    

  		




  
  894
  
    
to rename:


  		




  
  895
  
    
# rename column


  		




  
  896
  
    
# rename CHECK constraint


  		




  
  897
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  898
  
    
';


  		




  
  899
  
    

  		




  
  900
  
    

  		




  
  901
  
    
--


  		




  
  902
  
    
-- Name: COLUMN taxon_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  903
  
    
--


  		




  
  904
  
    

  		




  
  905
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" IS '


  		




  
  906
  
    
derived column; = CASE


  		




  
  907
  
    
        WHEN matched_has_accepted THEN "*Accepted_name"


  		




  
  908
  
    
        ELSE "*Name_matched"


  		




  
  909
  
    
    END


  		




  
  910
  
    

  		




  
  911
  
    
to modify expr:


  		




  
  912
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "*Accepted_name" ELSE "*Name_matched" END$$)::util.derived_col_def);


  		




  
  913
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  914
  
    

  		




  
  915
  
    
to rename:


  		




  
  916
  
    
# rename column


  		




  
  917
  
    
# rename CHECK constraint


  		




  
  918
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  919
  
    
';


  		




  
  920
  
    

  		




  
  921
  
    

  		




  
  922
  
    
--


  		




  
  923
  
    
-- Name: COLUMN taxon_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  924
  
    
--


  		




  
  925
  
    

  		




  
  926
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" IS '


  		




  
  927
  
    
derived column; = CASE


  		




  
  928
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_author"


  		




  
  929
  
    
        ELSE "*Name_matched_author"


  		




  
  930
  
    
    END


  		




  
  931
  
    

  		




  
  932
  
    
to modify expr:


  		




  
  933
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "*Accepted_name_author" ELSE "*Name_matched_author" END$$)::util.derived_col_def);


  		




  
  934
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  935
  
    

  		




  
  936
  
    
to rename:


  		




  
  937
  
    
# rename column


  		




  
  938
  
    
# rename CHECK constraint


  		




  
  939
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  940
  
    
';


  		




  
  941
  
    

  		




  
  942
  
    

  		




  
  943
  
    
--


  		




  
  944
  
    
-- Name: COLUMN taxon_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  945
  
    
--


  		




  
  946
  
    

  		




  
  947
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" IS '


  		




  
  948
  
    
derived column; = CASE


  		




  
  949
  
    
        WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  
  950
  
    
        ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  
  951
  
    
    END


  		




  
  952
  
    

  		




  
  953
  
    
to modify expr:


  		




  
  954
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org" END$$)::util.derived_col_def);


  		




  
  955
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  956
  
    

  		




  
  957
  
    
to rename:


  		




  
  958
  
    
# rename column


  		




  
  959
  
    
# rename CHECK constraint


  		




  
  960
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  961
  
    
';


  		




  
  962
  
    

  		




  
  963
  
    

  		




  
  964
  
    
--


  		




  625
  965
  
    
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: -


  		




  626
  966
  
    
--


  		




  627
  967
  
    

  		












  

    
      trunk/schemas/vegbien.my.sql
    
  





  15473
  15473
  
    
    `__accepted_infraspecific_{rank,epithet}` varchar(255),


  		




  15474
  15474
  
    
    `[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org` varchar(255),


  		




  15475
  15475
  
    
    `[accepted_]infraspecificEpithet__@DwC__@vegpath.org` varchar(255),


  		




  15476
  
  
    
    `[accepted_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255)


  		




  
  15476
  
    
    `[accepted_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255),


  		




  
  15477
  
    
    `[scrubbed_]taxonRank__@DwC__@vegpath.org` varchar(255),


  		




  
  15478
  
    
    `[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255),


  		




  
  15479
  
    
    `[scrubbed_]genus__@DwC__@vegpath.org` varchar(255),


  		




  
  15480
  
    
    `[scrubbed_]specificEpithet__@DwC__@vegpath.org` varchar(255),


  		




  
  15481
  
    
    `[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255),


  		




  
  15482
  
    
    `[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org` varchar(255),


  		




  
  15483
  
    
    `[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org` varchar(255),


  		




  
  15484
  
    
    `[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255),


  		




  
  15485
  
    
    `[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255),


  		




  
  15486
  
    
    `[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255)


  		




  
  15487
  
    
CASE


  		




  
  15488
  
    
    WHEN matched_has_accepted THEN `[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org`


  		




  
  15489
  
    
    ELSE `*Infraspecific_rank`


  		




  
  15490
  
    
END)))


  		




  
  15491
  
    
CASE


  		




  
  15492
  
    
    WHEN matched_has_accepted THEN `*Accepted_name_author`


  		




  
  15493
  
    
    ELSE `*Name_matched_author`


  		




  
  15494
  
    
END)))


  		




  
  15495
  
    
CASE


  		




  
  15496
  
    
    WHEN matched_has_accepted THEN `*Accepted_name_family`


  		




  
  15497
  
    
    ELSE `*Name_matched_accepted_family`


  		




  
  15498
  
    
END)))


  		




  
  15499
  
    
CASE


  		




  
  15500
  
    
    WHEN matched_has_accepted THEN `[accepted_]genus__@DwC__@vegpath.org`


  		




  
  15501
  
    
    ELSE `*Genus_matched`


  		




  
  15502
  
    
END)))


  		




  
  15503
  
    
CASE


  		




  
  15504
  
    
    WHEN matched_has_accepted THEN `[accepted_]specificEpithet__@DwC__@vegpath.org`


  		




  
  15505
  
    
    ELSE `*Infraspecific_epithet_matched`


  		




  
  15506
  
    
END)))


  		




  
  15507
  
    
CASE


  		




  
  15508
  
    
    WHEN matched_has_accepted THEN `*Accepted_name`


  		




  
  15509
  
    
    ELSE `*Name_matched`


  		




  
  15510
  
    
END)))


  		




  
  15511
  
    
CASE


  		




  
  15512
  
    
    WHEN matched_has_accepted THEN `[accepted_]scientificName[_with_author]__@DwC__@vegpath.org`


  		




  
  15513
  
    
    ELSE `[matched_]scientificName[_with_author]__@DwC__@vegpath.org`


  		




  
  15514
  
    
END)))


  		




  
  15515
  
    
CASE


  		




  
  15516
  
    
    WHEN matched_has_accepted THEN `*Accepted_name_species`


  		




  
  15517
  
    
    ELSE `[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org`


  		




  
  15518
  
    
END)))


  		




  
  15519
  
    
CASE


  		




  
  15520
  
    
    WHEN matched_has_accepted THEN `[accepted_]specificEpithet__@DwC__@vegpath.org`


  		




  
  15521
  
    
    ELSE `*Specific_epithet_matched`


  		




  
  15522
  
    
END)))


  		




  
  15523
  
    
CASE


  		




  
  15524
  
    
    WHEN matched_has_accepted THEN `*Accepted_name_rank`


  		




  
  15525
  
    
    ELSE `*Name_matched_rank`


  		




  
  15526
  
    
END)))


  		




  15477
  15527
  
    
);


  		




  15478
  15528
  
    

  		




  15479
  15529
  
    

  		




  ......




  15562
  15612
  
    

  		




  15563
  15613
  
    

  		




  15564
  15614
  
    
--


  		




  
  15615
  
    
-- Name: COLUMN taxon_match.`[scrubbed_]taxonRank__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  15616
  
    
--


  		




  
  15617
  
    

  		




  
  15618
  
    

  		




  
  15619
  
    

  		




  
  15620
  
    

  		




  
  15621
  
    
--


  		




  
  15622
  
    
-- Name: COLUMN taxon_match.`[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  15623
  
    
--


  		




  
  15624
  
    

  		




  
  15625
  
    

  		




  
  15626
  
    

  		




  
  15627
  
    

  		




  
  15628
  
    
--


  		




  
  15629
  
    
-- Name: COLUMN taxon_match.`[scrubbed_]genus__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  15630
  
    
--


  		




  
  15631
  
    

  		




  
  15632
  
    

  		




  
  15633
  
    

  		




  
  15634
  
    

  		




  
  15635
  
    
--


  		




  
  15636
  
    
-- Name: COLUMN taxon_match.`[scrubbed_]specificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  15637
  
    
--


  		




  
  15638
  
    

  		




  
  15639
  
    

  		




  
  15640
  
    

  		




  
  15641
  
    

  		




  
  15642
  
    
--


  		




  
  15643
  
    
-- Name: COLUMN taxon_match.`[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  15644
  
    
--


  		




  
  15645
  
    

  		




  
  15646
  
    

  		




  
  15647
  
    

  		




  
  15648
  
    

  		




  
  15649
  
    
--


  		




  
  15650
  
    
-- Name: COLUMN taxon_match.`[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  15651
  
    
--


  		




  
  15652
  
    

  		




  
  15653
  
    

  		




  
  15654
  
    

  		




  
  15655
  
    

  		




  
  15656
  
    
--


  		




  
  15657
  
    
-- Name: COLUMN taxon_match.`[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  15658
  
    
--


  		




  
  15659
  
    

  		




  
  15660
  
    

  		




  
  15661
  
    

  		




  
  15662
  
    

  		




  
  15663
  
    
--


  		




  
  15664
  
    
-- Name: COLUMN taxon_match.`[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  15665
  
    
--


  		




  
  15666
  
    

  		




  
  15667
  
    

  		




  
  15668
  
    

  		




  
  15669
  
    

  		




  
  15670
  
    
--


  		




  
  15671
  
    
-- Name: COLUMN taxon_match.`[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  15672
  
    
--


  		




  
  15673
  
    

  		




  
  15674
  
    

  		




  
  15675
  
    

  		




  
  15676
  
    

  		




  
  15677
  
    
--


  		




  
  15678
  
    
-- Name: COLUMN taxon_match.`[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  15679
  
    
--


  		




  
  15680
  
    

  		




  
  15681
  
    

  		




  
  15682
  
    

  		




  
  15683
  
    

  		




  
  15684
  
    
--


  		




  15565
  15685
  
    
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: -


  		




  15566
  15686
  
    
--


  		




  15567
  15687
  
    

  		












  

    
      trunk/schemas/vegbien.sql
    
  





  19265
  19265
  
    
    LANGUAGE plpgsql


  		




  19266
  19266
  
    
    AS $$


  		




  19267
  19267
  
    
BEGIN


  		




  
  19268
  
    
	new."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT


  		




  
  19269
  
    
		("*Genus_matched" || ' '::text) || "*Specific_epithet_matched"


  		




  
  19270
  
    
		FROM (SELECT new.*) new);


  		




  
  19271
  
    
	


  		




  
  19272
  
    
	new."[matched_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT


  		




  
  19273
  
    
		"*Name_matched" || COALESCE((' '::text || "*Name_matched_author"), ''::text)


  		




  
  19274
  
    
		FROM (SELECT new.*) new);


  		




  
  19275
  
    
	


  		




  
  19276
  
    
	new.matched_has_accepted = (SELECT


  		




  
  19277
  
    
		"*Accepted_name" IS NOT NULL


  		




  
  19278
  
    
		FROM (SELECT new.*) new);


  		




  
  19279
  
    
	


  		




  19268
  19280
  
    
	new."__accepted_{genus,specific_epithet}" = (SELECT


  		




  19269
  19281
  
    
		regexp_split_to_array("*Accepted_name_species", ' '::text)


  		




  19270
  19282
  
    
		FROM (SELECT new.*) new);


  		




  ......




  19293
  19305
  
    
		"__accepted_infraspecific_{rank,epithet}"[2]


  		




  19294
  19306
  
    
		FROM (SELECT new.*) new);


  		




  19295
  19307
  
    
	


  		




  19296
  
  
    
	new."[matched_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT


  		




  19297
  
  
    
		"*Name_matched" || COALESCE((' '::text || "*Name_matched_author"), ''::text)


  		




  19298
  
  
    
		FROM (SELECT new.*) new);


  		




  19299
  
  
    
	


  		




  19300
  19308
  
    
	new."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT


  		




  19301
  19309
  
    
		"*Accepted_name" || COALESCE((' '::text || "*Accepted_name_author"), ''::text)


  		




  19302
  19310
  
    
		FROM (SELECT new.*) new);


  		




  19303
  19311
  
    
	


  		




  19304
  
  
    
	new.matched_has_accepted = (SELECT


  		




  19305
  
  
    
		"*Accepted_name" IS NOT NULL


  		




  
  19312
  
    
	new."[scrubbed_]taxonRank__@DwC__@vegpath.org" = (SELECT


  		




  
  19313
  
    
		CASE


  		




  
  19314
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_rank"


  		




  
  19315
  
    
        ELSE "*Name_matched_rank"


  		




  
  19316
  
    
    END


  		




  19306
  19317
  
    
		FROM (SELECT new.*) new);


  		




  19307
  19318
  
    
	


  		




  19308
  
  
    
	new."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT


  		




  19309
  
  
    
		("*Genus_matched" || ' '::text) || "*Specific_epithet_matched"


  		




  
  19319
  
    
	new."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT


  		




  
  19320
  
    
		CASE


  		




  
  19321
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_family"


  		




  
  19322
  
    
        ELSE "*Name_matched_accepted_family"


  		




  
  19323
  
    
    END


  		




  19310
  19324
  
    
		FROM (SELECT new.*) new);


  		




  19311
  19325
  
    
	


  		




  
  19326
  
    
	new."[scrubbed_]genus__@DwC__@vegpath.org" = (SELECT


  		




  
  19327
  
    
		CASE


  		




  
  19328
  
    
        WHEN matched_has_accepted THEN "[accepted_]genus__@DwC__@vegpath.org"


  		




  
  19329
  
    
        ELSE "*Genus_matched"


  		




  
  19330
  
    
    END


  		




  
  19331
  
    
		FROM (SELECT new.*) new);


  		




  
  19332
  
    
	


  		




  
  19333
  
    
	new."[scrubbed_]specificEpithet__@DwC__@vegpath.org" = (SELECT


  		




  
  19334
  
    
		CASE


  		




  
  19335
  
    
        WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"


  		




  
  19336
  
    
        ELSE "*Specific_epithet_matched"


  		




  
  19337
  
    
    END


  		




  
  19338
  
    
		FROM (SELECT new.*) new);


  		




  
  19339
  
    
	


  		




  
  19340
  
    
	new."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT


  		




  
  19341
  
    
		CASE


  		




  
  19342
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_species"


  		




  
  19343
  
    
        ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org"


  		




  
  19344
  
    
    END


  		




  
  19345
  
    
		FROM (SELECT new.*) new);


  		




  
  19346
  
    
	


  		




  
  19347
  
    
	new."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = (SELECT


  		




  
  19348
  
    
		CASE


  		




  
  19349
  
    
        WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"


  		




  
  19350
  
    
        ELSE "*Infraspecific_rank"


  		




  
  19351
  
    
    END


  		




  
  19352
  
    
		FROM (SELECT new.*) new);


  		




  
  19353
  
    
	


  		




  
  19354
  
    
	new."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" = (SELECT


  		




  
  19355
  
    
		CASE


  		




  
  19356
  
    
        WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"


  		




  
  19357
  
    
        ELSE "*Infraspecific_epithet_matched"


  		




  
  19358
  
    
    END


  		




  
  19359
  
    
		FROM (SELECT new.*) new);


  		




  
  19360
  
    
	


  		




  
  19361
  
    
	new."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT


  		




  
  19362
  
    
		CASE


  		




  
  19363
  
    
        WHEN matched_has_accepted THEN "*Accepted_name"


  		




  
  19364
  
    
        ELSE "*Name_matched"


  		




  
  19365
  
    
    END


  		




  
  19366
  
    
		FROM (SELECT new.*) new);


  		




  
  19367
  
    
	


  		




  
  19368
  
    
	new."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT


  		




  
  19369
  
    
		CASE


  		




  
  19370
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_author"


  		




  
  19371
  
    
        ELSE "*Name_matched_author"


  		




  
  19372
  
    
    END


  		




  
  19373
  
    
		FROM (SELECT new.*) new);


  		




  
  19374
  
    
	


  		




  
  19375
  
    
	new."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT


  		




  
  19376
  
    
		CASE


  		




  
  19377
  
    
        WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  
  19378
  
    
        ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  
  19379
  
    
    END


  		




  
  19380
  
    
		FROM (SELECT new.*) new);


  		




  
  19381
  
    
	


  		




  19312
  19382
  
    
	RETURN new;


  		




  19313
  19383
  
    
END;


  		




  19314
  19384
  
    
$$;


  		




  ......




  19492
  19562
  
    
    "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" text,


  		




  19493
  19563
  
    
    "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" text,


  		




  19494
  19564
  
    
    "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" text,


  		




  
  19565
  
    
    "[scrubbed_]taxonRank__@DwC__@vegpath.org" text,


  		




  
  19566
  
    
    "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" text,


  		




  
  19567
  
    
    "[scrubbed_]genus__@DwC__@vegpath.org" text,


  		




  
  19568
  
    
    "[scrubbed_]specificEpithet__@DwC__@vegpath.org" text,


  		




  
  19569
  
    
    "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" text,


  		




  
  19570
  
    
    "[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" text,


  		




  
  19571
  
    
    "[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" text,


  		




  
  19572
  
    
    "[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" text,


  		




  
  19573
  
    
    "[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" text,


  		




  
  19574
  
    
    "[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" text,


  		




  19495
  19575
  
    
    CONSTRAINT "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" CHECK ((NOT ("[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[1]))),


  		




  19496
  19576
  
    
    CONSTRAINT "[accepted_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]genus__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet}"[1]))),


  		




  19497
  19577
  
    
    CONSTRAINT "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]infraspecificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[2]))),


  		




  ......




  19499
  19579
  
    
    CONSTRAINT "[accepted_]specificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]specificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet}"[2]))),


  		




  19500
  19580
  
    
    CONSTRAINT "[matched_]scientificName[_with_author]__@DwC__@vegpath.org" CHECK ((NOT ("[matched_]scientificName[_with_author]__@DwC__@vegpath.org" IS DISTINCT FROM ("*Name_matched" || COALESCE((' '::text || "*Name_matched_author"), ''::text))))),


  		




  19501
  19581
  
    
    CONSTRAINT "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM (("*Genus_matched" || ' '::text) || "*Specific_epithet_matched")))),


  		




  
  19582
  
    
    CONSTRAINT "[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS DISTINCT FROM


  		




  
  19583
  
    
CASE


  		




  
  19584
  
    
    WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"


  		




  
  19585
  
    
    ELSE "*Infraspecific_rank"


  		




  
  19586
  
    
END))),


  		




  
  19587
  
    
    CONSTRAINT "[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM


  		




  
  19588
  
    
CASE


  		




  
  19589
  
    
    WHEN matched_has_accepted THEN "*Accepted_name_author"


  		




  
  19590
  
    
    ELSE "*Name_matched_author"


  		




  
  19591
  
    
END))),


  		




  
  19592
  
    
    CONSTRAINT "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM


  		




  
  19593
  
    
CASE


  		




  
  19594
  
    
    WHEN matched_has_accepted THEN "*Accepted_name_family"


  		




  
  19595
  
    
    ELSE "*Name_matched_accepted_family"


  		




  
  19596
  
    
END))),


  		




  
  19597
  
    
    CONSTRAINT "[scrubbed_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]genus__@DwC__@vegpath.org" IS DISTINCT FROM


  		




  
  19598
  
    
CASE


  		




  
  19599
  
    
    WHEN matched_has_accepted THEN "[accepted_]genus__@DwC__@vegpath.org"


  		




  
  19600
  
    
    ELSE "*Genus_matched"


  		




  
  19601
  
    
END))),


  		




  
  19602
  
    
    CONSTRAINT "[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM


  		




  
  19603
  
    
CASE


  		




  
  19604
  
    
    WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"


  		




  
  19605
  
    
    ELSE "*Infraspecific_epithet_matched"


  		




  
  19606
  
    
END))),


  		




  
  19607
  
    
    CONSTRAINT "[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM


  		




  
  19608
  
    
CASE


  		




  
  19609
  
    
    WHEN matched_has_accepted THEN "*Accepted_name"


  		




  
  19610
  
    
    ELSE "*Name_matched"


  		




  
  19611
  
    
END))),


  		




  
  19612
  
    
    CONSTRAINT "[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" IS DISTINCT FROM


  		




  
  19613
  
    
CASE


  		




  
  19614
  
    
    WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  
  19615
  
    
    ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  
  19616
  
    
END))),


  		




  
  19617
  
    
    CONSTRAINT "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM


  		




  
  19618
  
    
CASE


  		




  
  19619
  
    
    WHEN matched_has_accepted THEN "*Accepted_name_species"


  		




  
  19620
  
    
    ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org"


  		




  
  19621
  
    
END))),


  		




  
  19622
  
    
    CONSTRAINT "[scrubbed_]specificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]specificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM


  		




  
  19623
  
    
CASE


  		




  
  19624
  
    
    WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"


  		




  
  19625
  
    
    ELSE "*Specific_epithet_matched"


  		




  
  19626
  
    
END))),


  		




  
  19627
  
    
    CONSTRAINT "[scrubbed_]taxonRank__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]taxonRank__@DwC__@vegpath.org" IS DISTINCT FROM


  		




  
  19628
  
    
CASE


  		




  
  19629
  
    
    WHEN matched_has_accepted THEN "*Accepted_name_rank"


  		




  
  19630
  
    
    ELSE "*Name_matched_rank"


  		




  
  19631
  
    
END))),


  		




  19502
  19632
  
    
    CONSTRAINT __accepted_infraspecific_label CHECK ((NOT (__accepted_infraspecific_label IS DISTINCT FROM ltrim(NULLIF(util.remove_prefix("*Accepted_name_species", "*Accepted_name", require := true), ''::text), ' '::text)))),


  		




  19503
  19633
  
    
    CONSTRAINT "__accepted_infraspecific_{rank,epithet}" CHECK ((NOT ("__accepted_infraspecific_{rank,epithet}" IS DISTINCT FROM regexp_split_to_array(__accepted_infraspecific_label, ' '::text)))),


  		




  19504
  19634
  
    
    CONSTRAINT "__accepted_{genus,specific_epithet}" CHECK ((NOT ("__accepted_{genus,specific_epithet}" IS DISTINCT FROM regexp_split_to_array("*Accepted_name_species", ' '::text)))),


  		




  ......




  19734
  19864
  
    

  		




  19735
  19865
  
    

  		




  19736
  19866
  
    
--


  		




  
  19867
  
    
-- Name: COLUMN taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  19868
  
    
--


  		




  
  19869
  
    

  		




  
  19870
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org" IS '


  		




  
  19871
  
    
derived column; = CASE


  		




  
  19872
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_rank"


  		




  
  19873
  
    
        ELSE "*Name_matched_rank"


  		




  
  19874
  
    
    END


  		




  
  19875
  
    

  		




  
  19876
  
    
to modify expr:


  		




  
  19877
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]taxonRank__@DwC__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "*Accepted_name_rank" ELSE "*Name_matched_rank" END$$)::util.derived_col_def);


  		




  
  19878
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  19879
  
    

  		




  
  19880
  
    
to rename:


  		




  
  19881
  
    
# rename column


  		




  
  19882
  
    
# rename CHECK constraint


  		




  
  19883
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  19884
  
    
';


  		




  
  19885
  
    

  		




  
  19886
  
    

  		




  
  19887
  
    
--


  		




  
  19888
  
    
-- Name: COLUMN taxon_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  19889
  
    
--


  		




  
  19890
  
    

  		




  
  19891
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" IS '


  		




  
  19892
  
    
derived column; = CASE


  		




  
  19893
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_family"


  		




  
  19894
  
    
        ELSE "*Name_matched_accepted_family"


  		




  
  19895
  
    
    END


  		




  
  19896
  
    

  		




  
  19897
  
    
to modify expr:


  		




  
  19898
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "*Accepted_name_family" ELSE "*Name_matched_accepted_family" END$$)::util.derived_col_def);


  		




  
  19899
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  19900
  
    

  		




  
  19901
  
    
to rename:


  		




  
  19902
  
    
# rename column


  		




  
  19903
  
    
# rename CHECK constraint


  		




  
  19904
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  19905
  
    
';


  		




  
  19906
  
    

  		




  
  19907
  
    

  		




  
  19908
  
    
--


  		




  
  19909
  
    
-- Name: COLUMN taxon_match."[scrubbed_]genus__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  19910
  
    
--


  		




  
  19911
  
    

  		




  
  19912
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]genus__@DwC__@vegpath.org" IS '


  		




  
  19913
  
    
derived column; = CASE


  		




  
  19914
  
    
        WHEN matched_has_accepted THEN "[accepted_]genus__@DwC__@vegpath.org"


  		




  
  19915
  
    
        ELSE "*Genus_matched"


  		




  
  19916
  
    
    END


  		




  
  19917
  
    

  		




  
  19918
  
    
to modify expr:


  		




  
  19919
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]genus__@DwC__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "[accepted_]genus__@DwC__@vegpath.org" ELSE "*Genus_matched" END$$)::util.derived_col_def);


  		




  
  19920
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  19921
  
    

  		




  
  19922
  
    
to rename:


  		




  
  19923
  
    
# rename column


  		




  
  19924
  
    
# rename CHECK constraint


  		




  
  19925
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  19926
  
    
';


  		




  
  19927
  
    

  		




  
  19928
  
    

  		




  
  19929
  
    
--


  		




  
  19930
  
    
-- Name: COLUMN taxon_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  19931
  
    
--


  		




  
  19932
  
    

  		




  
  19933
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org" IS '


  		




  
  19934
  
    
derived column; = CASE


  		




  
  19935
  
    
        WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"


  		




  
  19936
  
    
        ELSE "*Specific_epithet_matched"


  		




  
  19937
  
    
    END


  		




  
  19938
  
    

  		




  
  19939
  
    
to modify expr:


  		




  
  19940
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]specificEpithet__@DwC__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org" ELSE "*Specific_epithet_matched" END$$)::util.derived_col_def);


  		




  
  19941
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  19942
  
    

  		




  
  19943
  
    
to rename:


  		




  
  19944
  
    
# rename column


  		




  
  19945
  
    
# rename CHECK constraint


  		




  
  19946
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  19947
  
    
';


  		




  
  19948
  
    

  		




  
  19949
  
    

  		




  
  19950
  
    
--


  		




  
  19951
  
    
-- Name: COLUMN taxon_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  19952
  
    
--


  		




  
  19953
  
    

  		




  
  19954
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" IS '


  		




  
  19955
  
    
derived column; = CASE


  		




  
  19956
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_species"


  		




  
  19957
  
    
        ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org"


  		




  
  19958
  
    
    END


  		




  
  19959
  
    

  		




  
  19960
  
    
to modify expr:


  		




  
  19961
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "*Accepted_name_species" ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" END$$)::util.derived_col_def);


  		




  
  19962
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  19963
  
    

  		




  
  19964
  
    
to rename:


  		




  
  19965
  
    
# rename column


  		




  
  19966
  
    
# rename CHECK constraint


  		




  
  19967
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  19968
  
    
';


  		




  
  19969
  
    

  		




  
  19970
  
    

  		




  
  19971
  
    
--


  		




  
  19972
  
    
-- Name: COLUMN taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  19973
  
    
--


  		




  
  19974
  
    

  		




  
  19975
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS '


  		




  
  19976
  
    
derived column; = CASE


  		




  
  19977
  
    
        WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"


  		




  
  19978
  
    
        ELSE "*Infraspecific_rank"


  		




  
  19979
  
    
    END


  		




  
  19980
  
    

  		




  
  19981
  
    
to modify expr:


  		




  
  19982
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" ELSE "*Infraspecific_rank" END$$)::util.derived_col_def);


  		




  
  19983
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  19984
  
    

  		




  
  19985
  
    
to rename:


  		




  
  19986
  
    
# rename column


  		




  
  19987
  
    
# rename CHECK constraint


  		




  
  19988
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  19989
  
    
';


  		




  
  19990
  
    

  		




  
  19991
  
    

  		




  
  19992
  
    
--


  		




  
  19993
  
    
-- Name: COLUMN taxon_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  19994
  
    
--


  		




  
  19995
  
    

  		




  
  19996
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" IS '


  		




  
  19997
  
    
derived column; = CASE


  		




  
  19998
  
    
        WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org"


  		




  
  19999
  
    
        ELSE "*Infraspecific_epithet_matched"


  		




  
  20000
  
    
    END


  		




  
  20001
  
    

  		




  
  20002
  
    
to modify expr:


  		




  
  20003
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org" ELSE "*Infraspecific_epithet_matched" END$$)::util.derived_col_def);


  		




  
  20004
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  20005
  
    

  		




  
  20006
  
    
to rename:


  		




  
  20007
  
    
# rename column


  		




  
  20008
  
    
# rename CHECK constraint


  		




  
  20009
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  20010
  
    
';


  		




  
  20011
  
    

  		




  
  20012
  
    

  		




  
  20013
  
    
--


  		




  
  20014
  
    
-- Name: COLUMN taxon_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  20015
  
    
--


  		




  
  20016
  
    

  		




  
  20017
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" IS '


  		




  
  20018
  
    
derived column; = CASE


  		




  
  20019
  
    
        WHEN matched_has_accepted THEN "*Accepted_name"


  		




  
  20020
  
    
        ELSE "*Name_matched"


  		




  
  20021
  
    
    END


  		




  
  20022
  
    

  		




  
  20023
  
    
to modify expr:


  		




  
  20024
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "*Accepted_name" ELSE "*Name_matched" END$$)::util.derived_col_def);


  		




  
  20025
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  20026
  
    

  		




  
  20027
  
    
to rename:


  		




  
  20028
  
    
# rename column


  		




  
  20029
  
    
# rename CHECK constraint


  		




  
  20030
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  20031
  
    
';


  		




  
  20032
  
    

  		




  
  20033
  
    

  		




  
  20034
  
    
--


  		




  
  20035
  
    
-- Name: COLUMN taxon_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  20036
  
    
--


  		




  
  20037
  
    

  		




  
  20038
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" IS '


  		




  
  20039
  
    
derived column; = CASE


  		




  
  20040
  
    
        WHEN matched_has_accepted THEN "*Accepted_name_author"


  		




  
  20041
  
    
        ELSE "*Name_matched_author"


  		




  
  20042
  
    
    END


  		




  
  20043
  
    

  		




  
  20044
  
    
to modify expr:


  		




  
  20045
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "*Accepted_name_author" ELSE "*Name_matched_author" END$$)::util.derived_col_def);


  		




  
  20046
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  20047
  
    

  		




  
  20048
  
    
to rename:


  		




  
  20049
  
    
# rename column


  		




  
  20050
  
    
# rename CHECK constraint


  		




  
  20051
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  20052
  
    
';


  		




  
  20053
  
    

  		




  
  20054
  
    

  		




  
  20055
  
    
--


  		




  
  20056
  
    
-- Name: COLUMN taxon_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  20057
  
    
--


  		




  
  20058
  
    

  		




  
  20059
  
    
COMMENT ON COLUMN taxon_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" IS '


  		




  
  20060
  
    
derived column; = CASE


  		




  
  20061
  
    
        WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  
  20062
  
    
        ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org"


  		




  
  20063
  
    
    END


  		




  
  20064
  
    

  		




  
  20065
  
    
to modify expr:


  		




  
  20066
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org'')::util.col, $$CASE WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org" END$$)::util.derived_col_def);


  		




  
  20067
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  
  20068
  
    

  		




  
  20069
  
    
to rename:


  		




  
  20070
  
    
# rename column


  		




  
  20071
  
    
# rename CHECK constraint


  		




  
  20072
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);


  		




  
  20073
  
    
';


  		




  
  20074
  
    

  		




  
  20075
  
    

  		




  
  20076
  
    
--


  		




  19737
  20077
  
    
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: -


  		




  19738
  20078
  
    
--


  		




  19739
  20079
  
    

  		












Also available in:  Unified diff