Project

General

Profile

« Previous | Next » 

Revision 14448

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: taxon_match: removed no longer used scrubbed_unique_taxon_name. the scrubbed name ranks are now generated from the other TNRS columns instead.

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-26 21:26:21.824011-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', 'indet. sp.1', NULL, 'Compositae', 'Compositae', true, 'Compositae', NULL, '{Compositae}', 'Compositae', NULL, 'Compositae indet. sp.1', NULL, NULL, NULL, 'Compositae', 'accepted', 'family', 'Compositae', 'Compositae', NULL, NULL, 'Compositae indet. sp.1', NULL, NULL, 'Compositae', NULL, 'Compositae');


  		




  38
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', 'indet. sp.1', NULL, 'Compositae', 'Compositae', true, 'Compositae', NULL, '{Compositae}', 'Compositae', NULL, 'Compositae indet. sp.1', NULL, NULL, NULL, 'Compositae', 'accepted', 'family', 'Compositae', 'Compositae', NULL, NULL, 'Compositae indet. sp.1', NULL, NULL, 'Compositae', NULL, 'Compositae');


  		




  39
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', 'indet. sp.1', NULL, 'Compositae', 'Compositae Giseke', true, 'Asteraceae', NULL, '{Asteraceae}', 'Asteraceae', NULL, 'Asteraceae indet. sp.1', NULL, NULL, NULL, 'Asteraceae Bercht. & J. Presl', 'accepted', 'family', 'Asteraceae', 'Asteraceae', NULL, NULL, 'Asteraceae indet. sp.1', NULL, NULL, 'Asteraceae', 'Bercht. & J. Presl', 'Asteraceae Bercht. & J. Presl');


  		




  40
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', 'Boyle#6500', NULL, 'Fagaceae', 'Fagaceae', true, 'Fagaceae', NULL, '{Fagaceae}', 'Fagaceae', NULL, 'Fagaceae Boyle#6500', NULL, NULL, NULL, 'Fagaceae', 'accepted', 'family', 'Fagaceae', 'Fagaceae', NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, 'Fagaceae', NULL, 'Fagaceae');


  		




  41
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', 'Boyle#6500', NULL, 'Fabaceae', 'Fabaceae Lindl.', true, 'Fabaceae', NULL, '{Fabaceae}', 'Fabaceae', NULL, 'Fabaceae Boyle#6500', NULL, NULL, NULL, 'Fabaceae Lindl.', 'accepted', 'family', 'Fabaceae', 'Fabaceae', NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.');


  		




  42
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', 'Boyle#6500', NULL, 'Fagaceae', 'Fagaceae Dumort.', true, 'Fagaceae', NULL, '{Fagaceae}', 'Fagaceae', NULL, 'Fagaceae Boyle#6500', NULL, NULL, NULL, 'Fagaceae Dumort.', 'accepted', 'family', 'Fagaceae', 'Fagaceae', NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.');


  		




  43
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', 'Boyle#6500', NULL, 'Ficaceae', 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no opinion', 'family', 'Ficaceae', NULL, NULL, NULL, 'Ficaceae Boyle#6500', NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl');


  		




  44
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', 'Boyle#6500', NULL, 'Fucaceae', 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no opinion', 'family', 'Fucaceae', NULL, NULL, NULL, 'Fucaceae Boyle#6500', NULL, NULL, 'Fucaceae', NULL, 'Fucaceae');


  		




  45
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', 'Boyle#6500', NULL, 'Fabaceae', 'Fabaceae', true, 'Fabaceae', NULL, '{Fabaceae}', 'Fabaceae', NULL, 'Fabaceae Boyle#6500', NULL, NULL, NULL, 'Fabaceae', 'accepted', 'family', 'Fabaceae', 'Fabaceae', NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, 'Fabaceae', NULL, 'Fabaceae');


  		




  46
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', '"fuzzy leaf"', NULL, 'Inga', 'Inga', true, 'Fabaceae', NULL, '{Inga}', 'Inga', NULL, 'Inga "fuzzy leaf"', NULL, NULL, NULL, 'Inga', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga "fuzzy leaf"', NULL, NULL, 'Inga', NULL, 'Inga');


  		




  47
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', '"fuzzy leaf"', NULL, 'Inga', 'Inga Mill.', true, 'Fabaceae', NULL, '{Inga}', 'Inga', NULL, 'Inga "fuzzy leaf"', NULL, NULL, NULL, 'Inga Mill.', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga "fuzzy leaf"', NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');


  		




  48
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', '"fuzzy leaf"', NULL, 'Inga', 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'illegitimate', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga "fuzzy leaf"', NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.');


  		




  49
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', 'sp.3', NULL, 'Inga', 'Inga', true, 'Fabaceae', NULL, '{Inga}', 'Inga', NULL, 'Inga sp.3', NULL, NULL, NULL, 'Inga', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga sp.3', NULL, NULL, 'Inga', NULL, 'Inga');


  		




  50
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', 'sp.3', NULL, 'Inga', 'Inga Mill.', true, 'Fabaceae', NULL, '{Inga}', 'Inga', NULL, 'Inga sp.3', NULL, NULL, NULL, 'Inga Mill.', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga sp.3', NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');


  		




  51
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', 'sp.3', NULL, 'Inga', 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'illegitimate', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga sp.3', NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.');


  		




  52
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', 'unknown #2', NULL, 'Fagaceae', 'Fagaceae', true, 'Fagaceae', NULL, '{Fagaceae}', 'Fagaceae', NULL, 'Fagaceae unknown #2', NULL, NULL, NULL, 'Fagaceae', 'accepted', 'family', 'Fagaceae', 'Fagaceae', NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, 'Fagaceae', NULL, 'Fagaceae');


  		




  53
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', 'unknown #2', NULL, 'Fabaceae', 'Fabaceae Lindl.', true, 'Fabaceae', NULL, '{Fabaceae}', 'Fabaceae', NULL, 'Fabaceae unknown #2', NULL, NULL, NULL, 'Fabaceae Lindl.', 'accepted', 'family', 'Fabaceae', 'Fabaceae', NULL, NULL, 'Fabaceae unknown #2', NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.');


  		




  54
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', 'unknown #2', NULL, 'Fagaceae', 'Fagaceae Dumort.', true, 'Fagaceae', NULL, '{Fagaceae}', 'Fagaceae', NULL, 'Fagaceae unknown #2', NULL, NULL, NULL, 'Fagaceae Dumort.', 'accepted', 'family', 'Fagaceae', 'Fagaceae', NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.');


  		




  55
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', 'unknown #2', NULL, 'Ficaceae', 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no opinion', 'family', 'Ficaceae', NULL, NULL, NULL, 'Ficaceae unknown #2', NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl');


  		




  56
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', 'unknown #2', NULL, 'Fucaceae', 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no opinion', 'family', 'Fucaceae', NULL, NULL, NULL, 'Fucaceae unknown #2', NULL, NULL, 'Fucaceae', NULL, 'Fucaceae');


  		




  57
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', 'unknown #2', NULL, 'Fabaceae', 'Fabaceae', true, 'Fabaceae', NULL, '{Fabaceae}', 'Fabaceae', NULL, 'Fabaceae unknown #2', NULL, NULL, NULL, 'Fabaceae', 'accepted', 'family', 'Fabaceae', 'Fabaceae', NULL, NULL, 'Fabaceae unknown #2', NULL, NULL, 'Fabaceae', NULL, 'Fabaceae');


  		




  58
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, NULL, NULL, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


  		




  59
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', NULL, 'Poa annua', 'Poa annua', 'Poa annua L.', true, 'Poaceae', 'Poa annua', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  60
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', NULL, 'Poa annua', 'Poa annua', 'Poa annua Cham. & Schltdl.', true, 'Poaceae', 'Poa infirma', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  61
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', NULL, 'Poa annua', 'Poa annua', 'Poa annua L.', true, 'Poaceae', 'Poa annua', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  62
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', NULL, 'Poa annua', 'Poa annua', 'Poa annua Cham. & Schltdl.', true, 'Poaceae', 'Poa infirma', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  63
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', NULL, 'Poa annua', 'Poa annua fo. lanuginosa', 'Poa annua fo. lanuginosa Sennen', true, 'Poaceae', 'Poa annua', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  64
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', NULL, 'Poa annua', 'Poa annua fo. lanuginosa', 'Poa annua fo. lanuginosa Sennen', true, 'Poaceae', 'Poa annua', '{Poa,annua,var.,annua}', 'Poa', 'annua', 'Poa annua', '{var.,annua}', 'var.', 'annua', 'Poa annua var. annua', 'accepted', 'variety', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', 'var.', 'annua', 'Poa annua var. annua', NULL, 'Poa annua var. annua');


  		




  65
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', NULL, 'Poa annua', 'Poa annua subsp. exilis', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, 'Poaceae', 'Poa infirma', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  66
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', NULL, 'Poa annua', 'Poa annua var. exilis', 'Poa annua var. exilis Tomm. ex Freyn', true, 'Poaceae', 'Poa infirma', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  67
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', NULL, 'Poa annua', 'Poa annua subsp. exilis', 'Poa annua subsp. exilis (Tomm. ex Freyn.) Asch. & Graebn.', true, 'Poaceae', 'Poa infirma', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  68
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', NULL, 'Poa annua', 'Poa annua subsp. exilis', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, 'Poaceae', 'Poa infirma', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  69
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', NULL, 'Poa annua', 'Poa annua subvar. minima', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', true, 'Poaceae', 'Poa annua', '{Poa,annua,subvar.,minima}', 'Poa', 'annua', 'Poa annua', '{subvar.,minima}', 'subvar.', 'minima', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', 'accepted', 'subvariety', 'Poaceae', 'Poa', 'annua', '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-26 21:26:21.824011-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.', NULL, 'Poa annua', 'Poa annua var. eriolepis', 'Poa annua var. eriolepis ̉ۡ.Desv.', true, 'Poaceae', 'Poa annua', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  71
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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.', NULL, 'Poa annua', 'Poa annua var. eriolepis', 'Poa annua var. eriolepis E. Desv.', true, 'Poaceae', 'Poa annua', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  72
  
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', 'Silene scouleri', '{Silene,scouleri,subsp.,pringlei}', 'Silene', 'scouleri', 'Silene scouleri', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', '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-26 21:26:21.824011-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', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', 'Silene scouleri', '{Silene,scouleri,subsp.,pringlei}', 'Silene', 'scouleri', 'Silene scouleri', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', '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-26 21:26:21.824011-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', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', 'Silene scouleri', '{Silene,scouleri,ssp.,pringlei}', 'Silene', 'scouleri', 'Silene scouleri', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', '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-26 21:26:21.824011-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', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', 'Silene scouleri', '{Silene,scouleri,subsp.,pringlei}', 'Silene', 'scouleri', 'Silene scouleri', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', '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-26 21:26:21.824011-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', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', 'Silene scouleri', '{Silene,scouleri,subsp.,pringlei}', 'Silene', 'scouleri', 'Silene scouleri', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', '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-26 21:26:21.824011-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', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', 'Silene scouleri', '{Silene,scouleri,ssp.,pringlei}', 'Silene', 'scouleri', 'Silene scouleri', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', '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');


  		




  
  37
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'indet. sp.1', NULL, 'Compositae', 'Compositae', true, 'Compositae', NULL, '{Compositae}', 'Compositae', NULL, 'Compositae indet. sp.1', NULL, NULL, NULL, 'Compositae', 'accepted', 'family', 'Compositae', 'Compositae', NULL, NULL, 'Compositae indet. sp.1', NULL, NULL, 'Compositae', NULL, 'Compositae');


  		




  
  38
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'indet. sp.1', NULL, 'Compositae', 'Compositae', true, 'Compositae', NULL, '{Compositae}', 'Compositae', NULL, 'Compositae indet. sp.1', NULL, NULL, NULL, 'Compositae', 'accepted', 'family', 'Compositae', 'Compositae', NULL, NULL, 'Compositae indet. sp.1', NULL, NULL, 'Compositae', NULL, 'Compositae');


  		




  
  39
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'indet. sp.1', NULL, 'Compositae', 'Compositae Giseke', true, 'Asteraceae', NULL, '{Asteraceae}', 'Asteraceae', NULL, 'Asteraceae indet. sp.1', NULL, NULL, NULL, 'Asteraceae Bercht. & J. Presl', 'accepted', 'family', 'Asteraceae', 'Asteraceae', NULL, NULL, 'Asteraceae indet. sp.1', NULL, NULL, 'Asteraceae', 'Bercht. & J. Presl', 'Asteraceae Bercht. & J. Presl');


  		




  
  40
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'Boyle#6500', NULL, 'Fagaceae', 'Fagaceae', true, 'Fagaceae', NULL, '{Fagaceae}', 'Fagaceae', NULL, 'Fagaceae Boyle#6500', NULL, NULL, NULL, 'Fagaceae', 'accepted', 'family', 'Fagaceae', 'Fagaceae', NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, 'Fagaceae', NULL, 'Fagaceae');


  		




  
  41
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'Boyle#6500', NULL, 'Fabaceae', 'Fabaceae Lindl.', true, 'Fabaceae', NULL, '{Fabaceae}', 'Fabaceae', NULL, 'Fabaceae Boyle#6500', NULL, NULL, NULL, 'Fabaceae Lindl.', 'accepted', 'family', 'Fabaceae', 'Fabaceae', NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.');


  		




  
  42
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'Boyle#6500', NULL, 'Fagaceae', 'Fagaceae Dumort.', true, 'Fagaceae', NULL, '{Fagaceae}', 'Fagaceae', NULL, 'Fagaceae Boyle#6500', NULL, NULL, NULL, 'Fagaceae Dumort.', 'accepted', 'family', 'Fagaceae', 'Fagaceae', NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.');


  		




  
  43
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'Boyle#6500', NULL, 'Ficaceae', 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no opinion', 'family', 'Ficaceae', NULL, NULL, NULL, 'Ficaceae Boyle#6500', NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl');


  		




  
  44
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'Boyle#6500', NULL, 'Fucaceae', 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no opinion', 'family', 'Fucaceae', NULL, NULL, NULL, 'Fucaceae Boyle#6500', NULL, NULL, 'Fucaceae', NULL, 'Fucaceae');


  		




  
  45
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'Boyle#6500', NULL, 'Fabaceae', 'Fabaceae', true, 'Fabaceae', NULL, '{Fabaceae}', 'Fabaceae', NULL, 'Fabaceae Boyle#6500', NULL, NULL, NULL, 'Fabaceae', 'accepted', 'family', 'Fabaceae', 'Fabaceae', NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, 'Fabaceae', NULL, 'Fabaceae');


  		




  
  46
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, '"fuzzy leaf"', NULL, 'Inga', 'Inga', true, 'Fabaceae', NULL, '{Inga}', 'Inga', NULL, 'Inga "fuzzy leaf"', NULL, NULL, NULL, 'Inga', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga "fuzzy leaf"', NULL, NULL, 'Inga', NULL, 'Inga');


  		




  
  47
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, '"fuzzy leaf"', NULL, 'Inga', 'Inga Mill.', true, 'Fabaceae', NULL, '{Inga}', 'Inga', NULL, 'Inga "fuzzy leaf"', NULL, NULL, NULL, 'Inga Mill.', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga "fuzzy leaf"', NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');


  		




  
  48
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, '"fuzzy leaf"', NULL, 'Inga', 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'illegitimate', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga "fuzzy leaf"', NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.');


  		




  
  49
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'sp.3', NULL, 'Inga', 'Inga', true, 'Fabaceae', NULL, '{Inga}', 'Inga', NULL, 'Inga sp.3', NULL, NULL, NULL, 'Inga', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga sp.3', NULL, NULL, 'Inga', NULL, 'Inga');


  		




  
  50
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'sp.3', NULL, 'Inga', 'Inga Mill.', true, 'Fabaceae', NULL, '{Inga}', 'Inga', NULL, 'Inga sp.3', NULL, NULL, NULL, 'Inga Mill.', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga sp.3', NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');


  		




  
  51
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'sp.3', NULL, 'Inga', 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'illegitimate', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga sp.3', NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.');


  		




  
  52
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'unknown #2', NULL, 'Fagaceae', 'Fagaceae', true, 'Fagaceae', NULL, '{Fagaceae}', 'Fagaceae', NULL, 'Fagaceae unknown #2', NULL, NULL, NULL, 'Fagaceae', 'accepted', 'family', 'Fagaceae', 'Fagaceae', NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, 'Fagaceae', NULL, 'Fagaceae');


  		




  
  53
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'unknown #2', NULL, 'Fabaceae', 'Fabaceae Lindl.', true, 'Fabaceae', NULL, '{Fabaceae}', 'Fabaceae', NULL, 'Fabaceae unknown #2', NULL, NULL, NULL, 'Fabaceae Lindl.', 'accepted', 'family', 'Fabaceae', 'Fabaceae', NULL, NULL, 'Fabaceae unknown #2', NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.');


  		




  
  54
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'unknown #2', NULL, 'Fagaceae', 'Fagaceae Dumort.', true, 'Fagaceae', NULL, '{Fagaceae}', 'Fagaceae', NULL, 'Fagaceae unknown #2', NULL, NULL, NULL, 'Fagaceae Dumort.', 'accepted', 'family', 'Fagaceae', 'Fagaceae', NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.');


  		




  
  55
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'unknown #2', NULL, 'Ficaceae', 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no opinion', 'family', 'Ficaceae', NULL, NULL, NULL, 'Ficaceae unknown #2', NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl');


  		




  
  56
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'unknown #2', NULL, 'Fucaceae', 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no opinion', 'family', 'Fucaceae', NULL, NULL, NULL, 'Fucaceae unknown #2', NULL, NULL, 'Fucaceae', NULL, 'Fucaceae');


  		




  
  57
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'unknown #2', NULL, 'Fabaceae', 'Fabaceae', true, 'Fabaceae', NULL, '{Fabaceae}', 'Fabaceae', NULL, 'Fabaceae unknown #2', NULL, NULL, NULL, 'Fabaceae', 'accepted', 'family', 'Fabaceae', 'Fabaceae', NULL, NULL, 'Fabaceae unknown #2', NULL, NULL, 'Fabaceae', NULL, 'Fabaceae');


  		




  
  58
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, NULL, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


  		




  
  59
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua', 'Poa annua L.', true, 'Poaceae', 'Poa annua', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  
  60
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua', 'Poa annua Cham. & Schltdl.', true, 'Poaceae', 'Poa infirma', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  
  61
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua', 'Poa annua L.', true, 'Poaceae', 'Poa annua', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  
  62
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua', 'Poa annua Cham. & Schltdl.', true, 'Poaceae', 'Poa infirma', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  
  63
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua fo. lanuginosa', 'Poa annua fo. lanuginosa Sennen', true, 'Poaceae', 'Poa annua', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  
  64
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua fo. lanuginosa', 'Poa annua fo. lanuginosa Sennen', true, 'Poaceae', 'Poa annua', '{Poa,annua,var.,annua}', 'Poa', 'annua', 'Poa annua', '{var.,annua}', 'var.', 'annua', 'Poa annua var. annua', 'accepted', 'variety', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', 'var.', 'annua', 'Poa annua var. annua', NULL, 'Poa annua var. annua');


  		




  
  65
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua subsp. exilis', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, 'Poaceae', 'Poa infirma', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  
  66
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua var. exilis', 'Poa annua var. exilis Tomm. ex Freyn', true, 'Poaceae', 'Poa infirma', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  
  67
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua subsp. exilis', 'Poa annua subsp. exilis (Tomm. ex Freyn.) Asch. & Graebn.', true, 'Poaceae', 'Poa infirma', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  
  68
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua subsp. exilis', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, 'Poaceae', 'Poa infirma', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  
  69
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua subvar. minima', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', true, 'Poaceae', 'Poa annua', '{Poa,annua,subvar.,minima}', 'Poa', 'annua', 'Poa annua', '{subvar.,minima}', 'subvar.', 'minima', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', 'accepted', 'subvariety', 'Poaceae', 'Poa', 'annua', '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-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua var. eriolepis', 'Poa annua var. eriolepis ̉ۡ.Desv.', true, 'Poaceae', 'Poa annua', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  
  71
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, NULL, 'Poa annua', 'Poa annua var. eriolepis', 'Poa annua var. eriolepis E. Desv.', true, 'Poaceae', 'Poa annua', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');


  		




  
  72
  
    
INSERT INTO taxon_match VALUES ('2014-07-26 21:26:21.824011-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, 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', 'Silene scouleri', '{Silene,scouleri,subsp.,pringlei}', 'Silene', 'scouleri', 'Silene scouleri', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', '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-26 21:26:21.824011-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, 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', 'Silene scouleri', '{Silene,scouleri,subsp.,pringlei}', 'Silene', 'scouleri', 'Silene scouleri', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', '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-26 21:26:21.824011-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, 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', 'Silene scouleri', '{Silene,scouleri,ssp.,pringlei}', 'Silene', 'scouleri', 'Silene scouleri', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', '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-26 21:26:21.824011-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, 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', 'Silene scouleri', '{Silene,scouleri,subsp.,pringlei}', 'Silene', 'scouleri', 'Silene scouleri', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', '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-26 21:26:21.824011-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, 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', 'Silene scouleri', '{Silene,scouleri,subsp.,pringlei}', 'Silene', 'scouleri', 'Silene scouleri', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', '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-26 21:26:21.824011-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, 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', 'Silene scouleri', '{Silene,scouleri,ssp.,pringlei}', 'Silene', 'scouleri', 'Silene scouleri', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', '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
    
  





  171
  171
  
    
			END, false);


  		




  172
  172
  
    
	END;


  		




  173
  173
  
    
	


  		




  174
  
  
    
	DECLARE


  		




  175
  
  
    
		matched_taxon_name_with_author text = NULLIF(concat_ws(' '


  		




  176
  
  
    
			, NULLIF(NULLIF(new."*Name_matched_accepted_family", 'Unknown'),


  		




  177
  
  
    
				new."*Name_matched")


  		




  178
  
  
    
			, NULLIF(new."*Name_matched", 'No suitable matches found.')


  		




  179
  
  
    
			, new."*Name_matched_author"


  		




  180
  
  
    
			), '');


  		




  181
  
  
    
		accepted_taxon_name_with_author text = NULLIF(concat_ws(' '


  		




  182
  
  
    
			, NULLIF(NULLIF(new."*Accepted_name_family", 'Unknown'),


  		




  183
  
  
    
				new."*Accepted_name")


  		




  184
  
  
    
			, new."*Accepted_name"


  		




  185
  
  
    
			, new."*Accepted_name_author"


  		




  186
  
  
    
			), '');


  		




  187
  
  
    
	BEGIN


  		




  188
  
  
    
		new.scrubbed_unique_taxon_name = COALESCE(


  		




  189
  
  
    
			accepted_taxon_name_with_author, matched_taxon_name_with_author);


  		




  190
  
  
    
	END;


  		




  191
  
  
    
	


  		




  192
  174
  
    
	RETURN new;


  		




  193
  175
  
    
END;


  		




  194
  176
  
    
$$;


  		




  ......




  535
  517
  
    
    "*Warnings" text,


  		




  536
  518
  
    
    "*Accepted_name_lsid" text,


  		




  537
  519
  
    
    is_valid_match boolean NOT NULL,


  		




  538
  
  
    
    scrubbed_unique_taxon_name text,


  		




  539
  520
  
    
    "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" text,


  		




  540
  521
  
    
    "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" text,


  		




  541
  522
  
    
    "matched~Name[_no_author]___@TNRS__@vegpath.org" text,


  		




  ......




  1465
  1446
  
    
    taxon_match."*Warnings",


  		




  1466
  1447
  
    
    taxon_match."*Accepted_name_lsid",


  		




  1467
  1448
  
    
    taxon_match.is_valid_match,


  		




  1468
  
  
    
    taxon_match.scrubbed_unique_taxon_name,


  		




  1469
  1449
  
    
    taxon_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",


  		




  1470
  1450
  
    
    taxon_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  1471
  1451
  
    
    taxon_match."matched~Name[_no_author]___@TNRS__@vegpath.org",


  		




  ......




  1641
  1621
  
    
    taxon_best_match."*Warnings",


  		




  1642
  1622
  
    
    taxon_best_match."*Accepted_name_lsid",


  		




  1643
  1623
  
    
    taxon_best_match.is_valid_match,


  		




  1644
  
  
    
    taxon_best_match.scrubbed_unique_taxon_name,


  		




  1645
  1624
  
    
    taxon_best_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",


  		




  1646
  1625
  
    
    taxon_best_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  1647
  1626
  
    
    taxon_best_match."matched~Name[_no_author]___@TNRS__@vegpath.org",


  		












  

    
      trunk/schemas/vegbien.my.sql
    
  





  16754
  16754
  
    
    `*Warnings` varchar(255),


  		




  16755
  16755
  
    
    `*Accepted_name_lsid` varchar(255),


  		




  16756
  16756
  
    
    is_valid_match int(1) NOT NULL,


  		




  16757
  
  
    
    scrubbed_unique_taxon_name varchar(255),


  		




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


  		




  16759
  16758
  
    
    `[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255),


  		




  16760
  16759
  
    
    `matched~Name[_no_author]___@TNRS__@vegpath.org` varchar(255),


  		












  

    
      trunk/schemas/vegbien.sql
    
  





  20755
  20755
  
    
			END, false);


  		




  20756
  20756
  
    
	END;


  		




  20757
  20757
  
    
	


  		




  20758
  
  
    
	DECLARE


  		




  20759
  
  
    
		matched_taxon_name_with_author text = NULLIF(concat_ws(' '


  		




  20760
  
  
    
			, NULLIF(NULLIF(new."*Name_matched_accepted_family", 'Unknown'),


  		




  20761
  
  
    
				new."*Name_matched")


  		




  20762
  
  
    
			, NULLIF(new."*Name_matched", 'No suitable matches found.')


  		




  20763
  
  
    
			, new."*Name_matched_author"


  		




  20764
  
  
    
			), '');


  		




  20765
  
  
    
		accepted_taxon_name_with_author text = NULLIF(concat_ws(' '


  		




  20766
  
  
    
			, NULLIF(NULLIF(new."*Accepted_name_family", 'Unknown'),


  		




  20767
  
  
    
				new."*Accepted_name")


  		




  20768
  
  
    
			, new."*Accepted_name"


  		




  20769
  
  
    
			, new."*Accepted_name_author"


  		




  20770
  
  
    
			), '');


  		




  20771
  
  
    
	BEGIN


  		




  20772
  
  
    
		new.scrubbed_unique_taxon_name = COALESCE(


  		




  20773
  
  
    
			accepted_taxon_name_with_author, matched_taxon_name_with_author);


  		




  20774
  
  
    
	END;


  		




  20775
  
  
    
	


  		




  20776
  20758
  
    
	RETURN new;


  		




  20777
  20759
  
    
END;


  		




  20778
  20760
  
    
$$;


  		




  ......




  21161
  21143
  
    
    "*Warnings" text,


  		




  21162
  21144
  
    
    "*Accepted_name_lsid" text,


  		




  21163
  21145
  
    
    is_valid_match boolean NOT NULL,


  		




  21164
  
  
    
    scrubbed_unique_taxon_name text,


  		




  21165
  21146
  
    
    "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" text,


  		




  21166
  21147
  
    
    "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" text,


  		




  21167
  21148
  
    
    "matched~Name[_no_author]___@TNRS__@vegpath.org" text,


  		




  ......




  22091
  22072
  
    
    taxon_match."*Warnings",


  		




  22092
  22073
  
    
    taxon_match."*Accepted_name_lsid",


  		




  22093
  22074
  
    
    taxon_match.is_valid_match,


  		




  22094
  
  
    
    taxon_match.scrubbed_unique_taxon_name,


  		




  22095
  22075
  
    
    taxon_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",


  		




  22096
  22076
  
    
    taxon_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  22097
  22077
  
    
    taxon_match."matched~Name[_no_author]___@TNRS__@vegpath.org",


  		




  ......




  22267
  22247
  
    
    taxon_best_match."*Warnings",


  		




  22268
  22248
  
    
    taxon_best_match."*Accepted_name_lsid",


  		




  22269
  22249
  
    
    taxon_best_match.is_valid_match,


  		




  22270
  
  
    
    taxon_best_match.scrubbed_unique_taxon_name,


  		




  22271
  22250
  
    
    taxon_best_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",


  		




  22272
  22251
  
    
    taxon_best_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",


  		




  22273
  22252
  
    
    taxon_best_match."matched~Name[_no_author]___@TNRS__@vegpath.org",


  		












Also available in:  Unified diff