INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 0, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Compositae/', NULL, NULL, 'Compositae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Accepted', 'Compositae', NULL, 'family', 'http://www.theplantlist.org/1.1/browse/A/Compositae/', NULL, NULL, 'true', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', 'Compositae', true);

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 1, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, NULL, NULL, NULL, NULL, 'Compositae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Accepted', 'Compositae', NULL, 'family', NULL, NULL, NULL, 'false', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', 'Compositae', true);

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

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 3, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'Fagaceae', true);

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 4, 1, 'Fabaceae Boyle#6500', 0.900000000000000022, 'Fabaceae', 'family', 1, 'Lindl.', 'http://www.tropicos.org/Name/42000184', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fabaceae', 'Lindl.', 'family', 'http://www.tropicos.org/Name/42000184', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'Fabaceae Lindl.', true);

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 5, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'Fagaceae Dumort.', true);

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

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 7, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fucaceae', NULL, false);

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 8, 1, 'Fabaceae Boyle#6500', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'Fabaceae', true);

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

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 10, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga Mill.', 'Inga Mill.', true);

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 11, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga Scop.', NULL, false);

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

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

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 14, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga Scop.', NULL, false);

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 15, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'Fagaceae', true);

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 16, 4, 'Fabaceae unknown #2', 0.900000000000000022, 'Fabaceae', 'family', 1, 'Lindl.', 'http://www.tropicos.org/Name/42000184', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fabaceae', 'Lindl.', 'family', 'http://www.tropicos.org/Name/42000184', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'Fabaceae Lindl.', true);

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 17, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'Fagaceae Dumort.', true);

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

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 19, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fucaceae', NULL, false);

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 20, 4, 'Fabaceae unknown #2', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'Fabaceae', true);

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-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, NULL, NULL, NULL, 'No suitable matches found.', NULL, false);

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

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

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

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

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

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

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

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

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

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

INSERT INTO taxon_match VALUES ('2014-06-26 04:50:24.98378-07', 32, 11, 'Poa annua subvar. minima', 1, 'Poa annua subvar. minima', 'subvariety', 1, '(Schur) Asch. & Graebn.', 'http://www.tropicos.org/Name/50158097', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subvar.', 'minima', 1, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua subvar. minima', '(Schur) Asch. & Graebn.', 'subvariety', 'http://www.tropicos.org/Name/50158097', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.', '{Poa,annua}', 'Poa', 'annua', 'subvar. minima', '{subvar.,minima}', 'subvar.', 'minima', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', true);

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

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

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

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

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

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

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

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

	new._matched_has_accepted = (SELECT

		"*Accepted_name" IS NOT NULL

		FROM (SELECT new.*) new);

    _matched_has_accepted boolean,

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

    CONSTRAINT _matched_has_accepted CHECK ((NOT (_matched_has_accepted IS DISTINCT FROM ("*Accepted_name" IS NOT NULL))))

-- Name: COLUMN taxon_match._matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: -

--

COMMENT ON COLUMN taxon_match._matched_has_accepted IS '

derived column; = "*Accepted_name" IS NOT NULL

to modify:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''_matched_has_accepted'')::util.col, $$"*Accepted_name" IS NOT NULL$$)::util.derived_col_def);

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

';

--

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

    _matched_has_accepted int(1)

-- Name: COLUMN taxon_match._matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: -

--

--

	new._matched_has_accepted = (SELECT

		"*Accepted_name" IS NOT NULL

		FROM (SELECT new.*) new);

    _matched_has_accepted boolean,

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

    CONSTRAINT _matched_has_accepted CHECK ((NOT (_matched_has_accepted IS DISTINCT FROM ("*Accepted_name" IS NOT NULL))))

-- Name: COLUMN taxon_match._matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: -

--

COMMENT ON COLUMN taxon_match._matched_has_accepted IS '

derived column; = "*Accepted_name" IS NOT NULL

to modify:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''_matched_has_accepted'')::util.col, $$"*Accepted_name" IS NOT NULL$$)::util.derived_col_def);

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

';

--