Project

General

Profile

« Previous | Next » 

Revision 14375

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: inputs/.TNRS/schema.sql: taxon_match."__accepted_{genus,specific_epithet}": use "*Accepted_name" instead of "Accepted_species[_binomial]__@TNRS__@vegpath.org" (from "*Accepted_name_species") because Accepted_name_species apparently sometimes does not match the Accepted_name and uses malformed Unicode characters

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, NULL, NULL, NULL, 'Compositae indet. sp.1', NULL, NULL, NULL, NULL, 'Compositae', 'accepted', 'family', 'Compositae', NULL, 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, NULL, NULL, NULL, 'Compositae indet. sp.1', NULL, NULL, NULL, NULL, 'Compositae', 'accepted', 'family', 'Compositae', NULL, 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, NULL, NULL, NULL, 'Asteraceae indet. sp.1', NULL, NULL, NULL, NULL, 'Asteraceae Bercht. & J. Presl', 'accepted', 'family', 'Asteraceae', NULL, 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, NULL, NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fagaceae', 'accepted', 'family', 'Fagaceae', NULL, 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, NULL, NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'accepted', 'family', 'Fabaceae', NULL, 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, NULL, NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'accepted', 'family', 'Fagaceae', NULL, NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.');


  		




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


  		




  43
  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, NULL, 'no opinion', 'family', 'Ficaceae', NULL, NULL, NULL, 'Ficaceae Boyle#6500', NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl');


  		




  44
  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, 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, NULL, NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fabaceae', 'accepted', 'family', 'Fabaceae', NULL, 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, NULL, 'Inga', NULL, 'Inga "fuzzy leaf"', NULL, 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, NULL, 'Inga', NULL, 'Inga "fuzzy leaf"', NULL, NULL, NULL, NULL, 'Inga Mill.', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga "fuzzy leaf"', NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');


  		




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


  		




  48
  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, 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, NULL, 'Inga', NULL, 'Inga sp.3', NULL, 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, NULL, 'Inga', NULL, 'Inga sp.3', NULL, NULL, NULL, NULL, 'Inga Mill.', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga sp.3', NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');


  		




  
  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, 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, NULL, 'Inga Mill.', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga sp.3', NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');


  		




  51
  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, 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, NULL, NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, NULL, NULL, 'Fagaceae', 'accepted', 'family', 'Fagaceae', NULL, 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, NULL, NULL, NULL, 'Fabaceae unknown #2', NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'accepted', 'family', 'Fabaceae', NULL, 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, NULL, NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'accepted', 'family', 'Fagaceae', NULL, NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.');


  		




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


  		




  55
  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, NULL, 'no opinion', 'family', 'Ficaceae', NULL, NULL, NULL, 'Ficaceae unknown #2', NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl');


  		




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


  		




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


  		




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


  		




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


  		




  60
  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, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




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


  		




  62
  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, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  63
  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, 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}', 'Poa', 'annua', 'Poa annua', 'var. 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');


  		




  
  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}', '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
  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, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  66
  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, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  67
  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, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');


  		




  68
  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, 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}', 'Poa', 'annua', 'Poa annua', 'subvar. minima', '{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.');


  		




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


  		




  71
  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, 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}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{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}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{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}', 'Silene', 'scouleri', 'Silene scouleri', 'ssp. pringlei', '{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}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{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}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{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}', 'Silene', 'scouleri', 'Silene scouleri', 'ssp. pringlei', '{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');


  		




  
  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}', '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}', '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}', '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}', '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}', '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}', '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
    
  





  257
  257
  
    
    ELSE NULL::text


  		




  258
  258
  
    
END) FROM (SELECT new.*) new);


  		




  259
  259
  
    
	new."Accepted_species[_binomial]__@TNRS__@vegpath.org" = (SELECT rtrim("*Accepted_name_species", ' '::text) FROM (SELECT new.*) new);


  		




  260
  
  
    
	new."__accepted_{genus,specific_epithet}" = (SELECT regexp_split_to_array("Accepted_species[_binomial]__@TNRS__@vegpath.org", ' '::text) FROM (SELECT new.*) new);


  		




  
  260
  
    
	new."__accepted_{genus,specific_epithet}" = (SELECT regexp_split_to_array("*Accepted_name", ' '::text) FROM (SELECT new.*) new);


  		




  261
  261
  
    
	new."[accepted_]genus__@DwC__@vegpath.org" = (SELECT COALESCE("__accepted_{genus,specific_epithet}"[1],


  		




  262
  262
  
    
CASE


  		




  263
  263
  
    
    WHEN ("*Accepted_name_rank" = 'genus'::text) THEN "*Accepted_name"


  		




  ......




  562
  562
  
    
    CONSTRAINT "[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" IS DISTINCT FROM map_taxonomic_status("*Taxonomic_status", "*Accepted_name")))),


  		




  563
  563
  
    
    CONSTRAINT __accepted_infraspecific_label CHECK ((NOT (__accepted_infraspecific_label IS DISTINCT FROM ltrim(NULLIF(remove_prefix("Accepted_species[_binomial]__@TNRS__@vegpath.org", "*Accepted_name", require := true, case_sensitive := false), ''::text), ' '::text)))),


  		




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


  		




  565
  
  
    
    CONSTRAINT "__accepted_{genus,specific_epithet}" CHECK ((NOT ("__accepted_{genus,specific_epithet}" IS DISTINCT FROM regexp_split_to_array("Accepted_species[_binomial]__@TNRS__@vegpath.org", ' '::text)))),


  		




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


  		




  566
  566
  
    
    CONSTRAINT matched_has_accepted CHECK ((NOT (matched_has_accepted IS DISTINCT FROM ("*Accepted_name" IS NOT NULL)))),


  		




  567
  567
  
    
    CONSTRAINT "matched~Name[_no_author]___@TNRS__@vegpath.org" CHECK ((NOT ("matched~Name[_no_author]___@TNRS__@vegpath.org" IS DISTINCT FROM NULLIF("*Name_matched", 'No suitable matches found.'::text))))


  		




  568
  568
  
    
);


  		




  ......




  759
  759
  
    
--


  		




  760
  760
  
    

  		




  761
  761
  
    
COMMENT ON COLUMN taxon_match."__accepted_{genus,specific_epithet}" IS '


  		




  762
  
  
    
= regexp_split_to_array("Accepted_species[_binomial]__@TNRS__@vegpath.org", '' ''::text)


  		




  
  762
  
    
= regexp_split_to_array("*Accepted_name", '' ''::text)


  		




  763
  763
  
    

  		




  764
  764
  
    
derived column


  		




  765
  765
  
    

  		




  766
  766
  
    
to modify expr:


  		




  767
  
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''__accepted_{genus,specific_epithet}'')::util.col, $$regexp_split_to_array("Accepted_species[_binomial]__@TNRS__@vegpath.org", '' ''::text)$$)::util.derived_col_def);


  		




  
  767
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''__accepted_{genus,specific_epithet}'')::util.col, $$regexp_split_to_array("*Accepted_name", '' ''::text)$$)::util.derived_col_def);


  		




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


  		




  769
  769
  
    

  		




  770
  770
  
    
to rename:


  		












  

    
      trunk/schemas/vegbien.sql
    
  





  19876
  19876
  
    
    ELSE NULL::text


  		




  19877
  19877
  
    
END) FROM (SELECT new.*) new);


  		




  19878
  19878
  
    
	new."Accepted_species[_binomial]__@TNRS__@vegpath.org" = (SELECT rtrim("*Accepted_name_species", ' '::text) FROM (SELECT new.*) new);


  		




  19879
  
  
    
	new."__accepted_{genus,specific_epithet}" = (SELECT regexp_split_to_array("Accepted_species[_binomial]__@TNRS__@vegpath.org", ' '::text) FROM (SELECT new.*) new);


  		




  
  19879
  
    
	new."__accepted_{genus,specific_epithet}" = (SELECT regexp_split_to_array("*Accepted_name", ' '::text) FROM (SELECT new.*) new);


  		




  19880
  19880
  
    
	new."[accepted_]genus__@DwC__@vegpath.org" = (SELECT COALESCE("__accepted_{genus,specific_epithet}"[1],


  		




  19881
  19881
  
    
CASE


  		




  19882
  19882
  
    
    WHEN ("*Accepted_name_rank" = 'genus'::text) THEN "*Accepted_name"


  		




  ......




  20223
  20223
  
    
    CONSTRAINT "[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" IS DISTINCT FROM map_taxonomic_status("*Taxonomic_status", "*Accepted_name")))),


  		




  20224
  20224
  
    
    CONSTRAINT __accepted_infraspecific_label CHECK ((NOT (__accepted_infraspecific_label IS DISTINCT FROM ltrim(NULLIF(remove_prefix("Accepted_species[_binomial]__@TNRS__@vegpath.org", "*Accepted_name", require := true, case_sensitive := false), ''::text), ' '::text)))),


  		




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


  		




  20226
  
  
    
    CONSTRAINT "__accepted_{genus,specific_epithet}" CHECK ((NOT ("__accepted_{genus,specific_epithet}" IS DISTINCT FROM regexp_split_to_array("Accepted_species[_binomial]__@TNRS__@vegpath.org", ' '::text)))),


  		




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


  		




  20227
  20227
  
    
    CONSTRAINT matched_has_accepted CHECK ((NOT (matched_has_accepted IS DISTINCT FROM ("*Accepted_name" IS NOT NULL)))),


  		




  20228
  20228
  
    
    CONSTRAINT "matched~Name[_no_author]___@TNRS__@vegpath.org" CHECK ((NOT ("matched~Name[_no_author]___@TNRS__@vegpath.org" IS DISTINCT FROM NULLIF("*Name_matched", 'No suitable matches found.'::text))))


  		




  20229
  20229
  
    
);


  		




  ......




  20420
  20420
  
    
--


  		




  20421
  20421
  
    

  		




  20422
  20422
  
    
COMMENT ON COLUMN taxon_match."__accepted_{genus,specific_epithet}" IS '


  		




  20423
  
  
    
= regexp_split_to_array("Accepted_species[_binomial]__@TNRS__@vegpath.org", '' ''::text)


  		




  
  20423
  
    
= regexp_split_to_array("*Accepted_name", '' ''::text)


  		




  20424
  20424
  
    

  		




  20425
  20425
  
    
derived column


  		




  20426
  20426
  
    

  		




  20427
  20427
  
    
to modify expr:


  		




  20428
  
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''__accepted_{genus,specific_epithet}'')::util.col, $$regexp_split_to_array("Accepted_species[_binomial]__@TNRS__@vegpath.org", '' ''::text)$$)::util.derived_col_def);


  		




  
  20428
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''__accepted_{genus,specific_epithet}'')::util.col, $$regexp_split_to_array("*Accepted_name", '' ''::text)$$)::util.derived_col_def);


  		




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


  		




  20430
  20430
  
    

  		




  20431
  20431
  
    
to rename:


  		












Also available in:  Unified diff