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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    __accepted_infraspecific_label text,

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

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

--

COMMENT ON COLUMN taxon_match.__accepted_infraspecific_label IS '

= ltrim(NULLIF("TNRS".remove_prefix("Accepted_species[_binomial]__@TNRS__@vegpath.org", "*Accepted_name", require := true, case_sensitive := false), ''''::text), '' ''::text)

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''__accepted_infraspecific_label'')::util.col, $$ltrim(NULLIF("TNRS".remove_prefix("Accepted_species[_binomial]__@TNRS__@vegpath.org", "*Accepted_name", require := true, case_sensitive := false), ''''::text), '' ''::text)$$)::util.derived_col_def);

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

to rename:

# rename column

# rename CHECK constraint

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

to drop:

SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''__accepted_infraspecific_label'')::util.col);

	-- DROP __ CASCADE doesn''t work when there are dependent views

';

--

    taxon_match.__accepted_infraspecific_label,

    taxon_best_match.__accepted_infraspecific_label,

    "MatchedTaxon".__accepted_infraspecific_label,

    "ValidMatchedTaxon".__accepted_infraspecific_label,

    __accepted_infraspecific_label varchar(255),

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

--

--

    __accepted_infraspecific_label text,

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

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

--

COMMENT ON COLUMN taxon_match.__accepted_infraspecific_label IS '

= ltrim(NULLIF("TNRS".remove_prefix("Accepted_species[_binomial]__@TNRS__@vegpath.org", "*Accepted_name", require := true, case_sensitive := false), ''''::text), '' ''::text)

derived column

to modify expr:

SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''__accepted_infraspecific_label'')::util.col, $$ltrim(NULLIF("TNRS".remove_prefix("Accepted_species[_binomial]__@TNRS__@vegpath.org", "*Accepted_name", require := true, case_sensitive := false), ''''::text), '' ''::text)$$)::util.derived_col_def);

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

to rename:

# rename column

# rename CHECK constraint

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

to drop:

SELECT util.drop_derived_col((''"TNRS".taxon_match'', ''__accepted_infraspecific_label'')::util.col);

	-- DROP __ CASCADE doesn''t work when there are dependent views

';

--

    taxon_match.__accepted_infraspecific_label,

    taxon_best_match.__accepted_infraspecific_label,

    "MatchedTaxon".__accepted_infraspecific_label,

    "ValidMatchedTaxon".__accepted_infraspecific_label,