Project

General

Profile

« Previous | Next » 

Revision 14304

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: taxon_match: added derived column "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org"

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', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', NULL, 'Compositae', 'indet. sp.1');


  		




  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', 'indet. sp.1');


  		




  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', 'indet. sp.1');


  		




  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', 'Boyle#6500');


  		




  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.', 'Boyle#6500');


  		




  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.', 'Boyle#6500');


  		




  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', 'Boyle#6500');


  		




  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', 'Boyle#6500');


  		




  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', 'Boyle#6500');


  		




  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', '"fuzzy leaf"');


  		




  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.', '"fuzzy leaf"');


  		




  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.', '"fuzzy leaf"');


  		




  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', 'sp.3');


  		




  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.', 'sp.3');


  		




  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.', 'sp.3');


  		




  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', 'unknown #2');


  		




  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.', 'unknown #2');


  		




  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.', 'unknown #2');


  		




  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', 'unknown #2');


  		




  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', 'unknown #2');


  		




  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', 'unknown #2');


  		




  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.', 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.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.', NULL);


  		




  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', NULL);


  		




  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.', NULL);


  		




  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', NULL);


  		




  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.', NULL);


  		




  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', NULL);


  		




  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', NULL);


  		




  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', NULL);


  		




  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', NULL);


  		




  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', NULL);


  		




  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.', NULL);


  		




  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.', NULL);


  		




  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.', NULL);


  		




  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', 'var. grisea');


  		




  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', 'var. grisea');


  		




  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', 'var. grisea');


  		




  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', 'var. grisea');


  		




  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', 'var. grisea');


  		




  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', 'var. grisea');


  		




  
  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', 'indet. sp.1', 'indet. sp.1');


  		




  
  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', 'indet. sp.1', 'indet. sp.1');


  		




  
  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', 'indet. sp.1', 'Asteraceae indet. sp.1');


  		




  
  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', 'Boyle#6500', 'Boyle#6500');


  		




  
  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.', 'Boyle#6500', 'Fabaceae Boyle#6500');


  		




  
  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.', 'Boyle#6500', 'Fagaceae Boyle#6500');


  		




  
  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', 'Boyle#6500', 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, 'family', 'Fucaceae', NULL, NULL, NULL, NULL, NULL, 'Fucaceae', NULL, 'Fucaceae', 'Boyle#6500', 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', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', NULL, 'Fabaceae', 'Boyle#6500', 'Boyle#6500');


  		




  
  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', '"fuzzy leaf"', 'Inga "fuzzy leaf"');


  		




  
  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.', '"fuzzy leaf"', 'Inga "fuzzy leaf"');


  		




  
  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.', '"fuzzy leaf"', 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', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', NULL, 'Inga', 'sp.3', 'Inga sp.3');


  		




  
  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.', 'sp.3', 'Inga sp.3');


  		




  
  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.', 'sp.3', 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', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', NULL, 'Fagaceae', 'unknown #2', 'unknown #2');


  		




  
  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.', 'unknown #2', 'Fabaceae unknown #2');


  		




  
  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.', 'unknown #2', 'Fagaceae unknown #2');


  		




  
  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', 'unknown #2', 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, 'family', 'Fucaceae', NULL, NULL, NULL, NULL, NULL, 'Fucaceae', NULL, 'Fucaceae', 'unknown #2', 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', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', NULL, 'Fabaceae', 'unknown #2', 'unknown #2');


  		




  
  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.', 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.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.', NULL, 'Poa annua');


  		




  
  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', NULL, 'Poa infirma');


  		




  
  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.', NULL, 'Poa annua');


  		




  
  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', NULL, 'Poa infirma');


  		




  
  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.', NULL, 'Poa annua');


  		




  
  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', NULL, 'Poa 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', NULL, 'Poa infirma');


  		




  
  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', NULL, 'Poa infirma');


  		




  
  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', NULL, 'Poa infirma');


  		




  
  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', NULL, 'Poa infirma');


  		




  
  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.', NULL, 'Poa annua');


  		




  
  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.', NULL, 'Poa annua');


  		




  
  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.', NULL, 'Poa annua');


  		




  
  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', 'var. grisea', 'Silene scouleri');


  		




  
  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', 'var. grisea', 'Silene scouleri');


  		




  
  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', 'var. grisea', 'Silene scouleri');


  		




  
  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', 'var. grisea', 'Silene scouleri');


  		




  
  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', 'var. grisea', 'Silene scouleri');


  		




  
  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', 'var. grisea', 'Silene scouleri');


  		




  78
  78
  
    

  		




  79
  79
  
    

  		




  80
  80
  
    
--


  		












  

    
      trunk/inputs/.TNRS/schema.sql
    
  





  313
  313
  
    
		"*Unmatched_terms"


  		




  314
  314
  
    
		FROM (SELECT new.*) new);


  		




  315
  315
  
    
	


  		




  
  316
  
    
	new."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = (SELECT


  		




  
  317
  
    
		CASE


  		




  
  318
  
    
        WHEN ("*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  319
  
    
        WHEN ("*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  320
  
    
        ELSE "*Accepted_name_species"


  		




  
  321
  
    
    END


  		




  
  322
  
    
		FROM (SELECT new.*) new);


  		




  
  323
  
    
	


  		




  316
  324
  
    
	RETURN new;


  		




  317
  325
  
    
END;


  		




  318
  326
  
    
$$;


  		




  ......




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


  		




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


  		




  467
  475
  
    
    "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" text,


  		




  
  476
  
    
    "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" text,


  		




  468
  477
  
    
    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]))),


  		




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


  		




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


  		




  
  480
  
    
    CONSTRAINT "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" CHECK ((NOT ("[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS DISTINCT FROM


  		




  
  481
  
    
CASE


  		




  
  482
  
    
    WHEN ("*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  483
  
    
    WHEN ("*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  484
  
    
    ELSE "*Accepted_name_species"


  		




  
  485
  
    
END))),


  		




  471
  486
  
    
    CONSTRAINT "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" IS DISTINCT FROM ("*Accepted_name" || COALESCE((' '::text || "*Accepted_name_author"), ''::text))))),


  		




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


  		




  473
  488
  
    
    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))))),


  		




  ......




  1060
  1075
  
    

  		




  1061
  1076
  
    

  		




  1062
  1077
  
    
--


  		




  
  1078
  
    
-- Name: COLUMN taxon_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  1079
  
    
--


  		




  
  1080
  
    

  		




  
  1081
  
    
COMMENT ON COLUMN taxon_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS '


  		




  
  1082
  
    
= 


  		




  
  1083
  
    
        CASE


  		




  
  1084
  
    
            WHEN "*Accepted_name_rank" = ''family''::text THEN concat_ws('' ''::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  1085
  
    
            WHEN "*Accepted_name_rank" = ''genus''::text THEN concat_ws('' ''::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  1086
  
    
            ELSE "*Accepted_name_species"


  		




  
  1087
  
    
        END


  		




  
  1088
  
    

  		




  
  1089
  
    
derived column


  		




  
  1090
  
    

  		




  
  1091
  
    
to modify expr:


  		




  
  1092
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col, $$CASE


  		




  
  1093
  
    
        WHEN ("*Accepted_name_rank" = ''family''::text) THEN concat_ws('' ''::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  1094
  
    
        WHEN ("*Accepted_name_rank" = ''genus''::text) THEN concat_ws('' ''::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  1095
  
    
        ELSE "*Accepted_name_species"


  		




  
  1096
  
    
    END$$)::util.derived_col_def);


  		




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


  		




  
  1098
  
    

  		




  
  1099
  
    
to rename:


  		




  
  1100
  
    
# rename column


  		




  
  1101
  
    
# rename CHECK constraint


  		




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


  		




  
  1103
  
    
';


  		




  
  1104
  
    

  		




  
  1105
  
    

  		




  
  1106
  
    
--


  		




  1063
  1107
  
    
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: -


  		




  1064
  1108
  
    
--


  		




  1065
  1109
  
    

  		












  

    
      trunk/schemas/vegbien.my.sql
    
  





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


  		




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


  		




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


  		




  15479
  
  
    
    `[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org` varchar(255)


  		




  
  15479
  
    
    `[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org` varchar(255),


  		




  
  15480
  
    
    `[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org` varchar(255)


  		




  15480
  15481
  
    
CASE


  		




  
  15482
  
    
    WHEN (`*Accepted_name_rank` = CAST('family' AS varchar(255))) THEN concat_ws(CAST(' ' AS varchar(255)), `*Accepted_name_family`, `[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org`)


  		




  
  15483
  
    
    WHEN (`*Accepted_name_rank` = CAST('genus' AS varchar(255))) THEN concat_ws(CAST(' ' AS varchar(255)), `*Accepted_name`, `[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org`)


  		




  
  15484
  
    
    ELSE `*Accepted_name_species`


  		




  
  15485
  
    
END)))


  		




  
  15486
  
    
CASE


  		




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


  		




  15482
  15488
  
    
    ELSE `*Infraspecific_rank`


  		




  15483
  15489
  
    
END)))


  		




  ......




  15682
  15688
  
    

  		




  15683
  15689
  
    

  		




  15684
  15690
  
    
--


  		




  
  15691
  
    
-- Name: COLUMN taxon_match.`[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  15692
  
    
--


  		




  
  15693
  
    

  		




  
  15694
  
    

  		




  
  15695
  
    

  		




  
  15696
  
    

  		




  
  15697
  
    
--


  		




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


  		




  15686
  15699
  
    
--


  		




  15687
  15700
  
    

  		












  

    
      trunk/schemas/vegbien.sql
    
  





  19375
  19375
  
    
		"*Unmatched_terms"


  		




  19376
  19376
  
    
		FROM (SELECT new.*) new);


  		




  19377
  19377
  
    
	


  		




  
  19378
  
    
	new."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = (SELECT


  		




  
  19379
  
    
		CASE


  		




  
  19380
  
    
        WHEN ("*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  19381
  
    
        WHEN ("*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  19382
  
    
        ELSE "*Accepted_name_species"


  		




  
  19383
  
    
    END


  		




  
  19384
  
    
		FROM (SELECT new.*) new);


  		




  
  19385
  
    
	


  		




  19378
  19386
  
    
	RETURN new;


  		




  19379
  19387
  
    
END;


  		




  19380
  19388
  
    
$$;


  		




  ......




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


  		




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


  		




  19571
  19579
  
    
    "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" text,


  		




  
  19580
  
    
    "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" text,


  		




  19572
  19581
  
    
    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]))),


  		




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


  		




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


  		




  
  19584
  
    
    CONSTRAINT "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" CHECK ((NOT ("[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS DISTINCT FROM


  		




  
  19585
  
    
CASE


  		




  
  19586
  
    
    WHEN ("*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  19587
  
    
    WHEN ("*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  19588
  
    
    ELSE "*Accepted_name_species"


  		




  
  19589
  
    
END))),


  		




  19575
  19590
  
    
    CONSTRAINT "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" IS DISTINCT FROM ("*Accepted_name" || COALESCE((' '::text || "*Accepted_name_author"), ''::text))))),


  		




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


  		




  19577
  19592
  
    
    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))))),


  		




  ......




  20164
  20179
  
    

  		




  20165
  20180
  
    

  		




  20166
  20181
  
    
--


  		




  
  20182
  
    
-- Name: COLUMN taxon_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  20183
  
    
--


  		




  
  20184
  
    

  		




  
  20185
  
    
COMMENT ON COLUMN taxon_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS '


  		




  
  20186
  
    
= 


  		




  
  20187
  
    
        CASE


  		




  
  20188
  
    
            WHEN "*Accepted_name_rank" = ''family''::text THEN concat_ws('' ''::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  20189
  
    
            WHEN "*Accepted_name_rank" = ''genus''::text THEN concat_ws('' ''::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  20190
  
    
            ELSE "*Accepted_name_species"


  		




  
  20191
  
    
        END


  		




  
  20192
  
    

  		




  
  20193
  
    
derived column


  		




  
  20194
  
    

  		




  
  20195
  
    
to modify expr:


  		




  
  20196
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col, $$CASE


  		




  
  20197
  
    
        WHEN ("*Accepted_name_rank" = ''family''::text) THEN concat_ws('' ''::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  20198
  
    
        WHEN ("*Accepted_name_rank" = ''genus''::text) THEN concat_ws('' ''::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")


  		




  
  20199
  
    
        ELSE "*Accepted_name_species"


  		




  
  20200
  
    
    END$$)::util.derived_col_def);


  		




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


  		




  
  20202
  
    

  		




  
  20203
  
    
to rename:


  		




  
  20204
  
    
# rename column


  		




  
  20205
  
    
# rename CHECK constraint


  		




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


  		




  
  20207
  
    
';


  		




  
  20208
  
    

  		




  
  20209
  
    

  		




  
  20210
  
    
--


  		




  20167
  20211
  
    
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: -


  		




  20168
  20212
  
    
--


  		




  20169
  20213
  
    

  		












Also available in:  Unified diff