-- -- PostgreSQL database dump -- SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; SET search_path = "TNRS", pg_catalog; -- -- Data for Name: client_version; Type: TABLE DATA; Schema: TNRS; Owner: - -- -- -- Data for Name: batch; Type: TABLE DATA; Schema: TNRS; Owner: - -- INSERT INTO batch VALUES ('2014-07-21 16:31:50.48692-07', '2014-07-21 16:31:50.48692-07', '2014-07-21 16:31:50.48692-07', NULL); -- -- Data for Name: batch_download_settings; Type: TABLE DATA; Schema: TNRS; Owner: - -- -- -- Data for Name: taxon_match; Type: TABLE DATA; Schema: TNRS; Owner: - -- INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 0, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Compositae/', NULL, NULL, 'Compositae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Accepted', 'Compositae', NULL, 'family', 'http://www.theplantlist.org/1.1/browse/A/Compositae/', NULL, NULL, 'true', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae', NULL, 'Compositae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', NULL, 'Compositae', 'indet. sp.1', 'indet. sp.1'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 1, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, NULL, NULL, NULL, NULL, 'Compositae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Accepted', 'Compositae', NULL, 'family', NULL, NULL, NULL, 'false', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae', NULL, 'Compositae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Compositae', NULL, 'Compositae', 'indet. sp.1', 'indet. sp.1'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 2, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, 'Giseke', 'http://www.tropicos.org/Name/50255940', NULL, NULL, 'Compositae', 1, 'Compositae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Synonym', 'Asteraceae', 'Bercht. & J. Presl', 'family', 'http://www.tropicos.org/Name/50307371', NULL, 'Asteraceae', 'false', 'tropicos', ' ', NULL, true, 'Asteraceae Bercht. & J. Presl', NULL, 'Compositae Giseke', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Asteraceae Bercht. & J. Presl', 'family', 'Asteraceae', NULL, NULL, NULL, NULL, NULL, 'Asteraceae', 'Bercht. & J. Presl', 'Asteraceae Bercht. & J. Presl', 'indet. sp.1', 'Asteraceae indet. sp.1'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 3, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', NULL, 'Fagaceae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', NULL, 'Fagaceae', 'Boyle#6500', 'Boyle#6500'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 4, 1, 'Fabaceae Boyle#6500', 0.900000000000000022, 'Fabaceae', 'family', 1, 'Lindl.', 'http://www.tropicos.org/Name/42000184', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fabaceae', 'Lindl.', 'family', 'http://www.tropicos.org/Name/42000184', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', NULL, 'Fabaceae Lindl.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'family', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.', 'Boyle#6500', 'Fabaceae Boyle#6500'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 5, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', NULL, 'Fagaceae Dumort.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'family', 'Fagaceae', NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.', 'Boyle#6500', 'Fagaceae Boyle#6500'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 6, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Ficaceae', 'family', 0.770000000000000018, 'Bercht. & J. Presl', 'http://www.tropicos.org/Name/100353631', NULL, NULL, 'Ficaceae', 0.75, 'Ficaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Ficaceae Bercht. & J. Presl', NULL, 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Ficaceae', NULL, NULL, NULL, NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl', 'Boyle#6500', NULL); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 7, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', NULL, 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Fucaceae', NULL, NULL, NULL, NULL, NULL, 'Fucaceae', NULL, 'Fucaceae', 'Boyle#6500', NULL); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 8, 1, 'Fabaceae Boyle#6500', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', NULL, 'Fabaceae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', NULL, 'Fabaceae', 'Boyle#6500', 'Boyle#6500'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 9, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Accepted', 'Inga', NULL, 'genus', 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, 'Fabaceae', 'true', 'tpl;usda', ' ', NULL, true, 'Fabaceae Inga', NULL, 'Inga', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', NULL, 'Inga', '"fuzzy leaf"', 'Inga "fuzzy leaf"'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 10, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', NULL, 'Inga Mill.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga Mill.', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.', '"fuzzy leaf"', 'Inga "fuzzy leaf"'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 11, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', NULL, 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'genus', 'Fabaceae', 'Inga', NULL, NULL, NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.', '"fuzzy leaf"', NULL); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 12, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, NULL, 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Accepted', 'Inga', NULL, 'genus', 'http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA', NULL, 'Fabaceae', 'true', 'tpl;usda', ' ', NULL, true, 'Fabaceae Inga', NULL, 'Inga', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', NULL, 'Inga', 'sp.3', 'Inga sp.3'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 13, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', NULL, 'Inga Mill.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Inga Mill.', 'genus', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.', 'sp.3', 'Inga sp.3'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 14, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', NULL, 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'genus', 'Fabaceae', 'Inga', NULL, NULL, NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.', 'sp.3', NULL); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 15, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', NULL, 'Fagaceae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae', NULL, 'Fagaceae', 'unknown #2', 'unknown #2'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 16, 4, 'Fabaceae unknown #2', 0.900000000000000022, 'Fabaceae', 'family', 1, 'Lindl.', 'http://www.tropicos.org/Name/42000184', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fabaceae', 'Lindl.', 'family', 'http://www.tropicos.org/Name/42000184', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', NULL, 'Fabaceae Lindl.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'family', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.', 'unknown #2', 'Fabaceae unknown #2'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 17, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', NULL, 'Fagaceae Dumort.', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'family', 'Fagaceae', NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.', 'unknown #2', 'Fagaceae unknown #2'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 18, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Ficaceae', 'family', 0.770000000000000018, 'Bercht. & J. Presl', 'http://www.tropicos.org/Name/100353631', NULL, NULL, 'Ficaceae', 0.75, 'Ficaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Ficaceae Bercht. & J. Presl', NULL, 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Ficaceae', NULL, NULL, NULL, NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl', 'unknown #2', NULL); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 19, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', NULL, 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Fucaceae', NULL, NULL, NULL, NULL, NULL, 'Fucaceae', NULL, 'Fucaceae', 'unknown #2', NULL); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 20, 4, 'Fabaceae unknown #2', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', NULL, 'Fabaceae', true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'family', NULL, NULL, NULL, NULL, NULL, NULL, 'Fabaceae', NULL, 'Fabaceae', 'unknown #2', 'unknown #2'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 21, 5, 'Fam_indet. Boyle#6501', 0, 'No suitable matches found.', NULL, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'true', NULL, ' ', NULL, false, NULL, NULL, 'No suitable matches found.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'No suitable matches found.', NULL, 'No suitable matches found.', NULL, NULL); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 22, 6, 'Poa annua', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', 'Poa annua', 'Poaceae', 'true', 'tpl;tropicos;usda', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua L.', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.', NULL, 'Poa annua'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 23, 6, 'Poa annua', 1, 'Poa annua', 'species', 1, 'Cham. & Schltdl.', 'http://www.theplantlist.org/tpl1.1/record/kew-435195', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'false', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua Cham. & Schltdl.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth', NULL, 'Poa infirma'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 24, 7, 'Poa annua L.', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', 'L.', 1, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194;http://www.tropicos.org/Name/25509881;http://plants.usda.gov/java/profile?symbol=POAN', 'Poa annua', 'Poaceae', 'true', 'tpl;tropicos;usda', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua L.', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.', NULL, 'Poa annua'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 25, 7, 'Poa annua L.', 0.800000000000000044, 'Poa annua', 'species', 1, 'Cham. & Schltdl.', 'http://www.theplantlist.org/tpl1.1/record/kew-435195', 'Cham. & Schltdl.', 0, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'false', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua Cham. & Schltdl.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth', NULL, 'Poa infirma'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 26, 8, 'Poa annua fo. lanuginosa', 1, 'Poa annua fo. lanuginosa', 'fo.', 1, 'Sennen', 'http://www.theplantlist.org/tpl1.1/record/tro-50267771', NULL, NULL, NULL, NULL, NULL, 'Poa', 1, 'annua', 1, 'fo.', 'lanuginosa', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194', 'Poa annua', 'Poaceae', 'true', 'tpl', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua fo. lanuginosa Sennen', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.', NULL, 'Poa annua'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 27, 8, 'Poa annua fo. lanuginosa', 1, 'Poa annua fo. lanuginosa', 'forma', 1, 'Sennen', 'http://www.tropicos.org/Name/50267771', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'fo.', 'lanuginosa', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua var. annua', NULL, 'variety', 'http://www.tropicos.org/Name/25517736', 'Poa annua', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua var. annua', 'Poa annua', 'Poa annua fo. lanuginosa Sennen', true, '{Poa,annua}', 'Poa', 'annua', 'var. annua', '{var.,annua}', 'var.', 'annua', 'Poa annua var. annua', 'variety', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'var.', 'annua', 'Poa annua var. annua', NULL, 'Poa annua var. annua', NULL, 'Poa annua'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 28, 9, 'Poa annua ssp. exilis', 1, 'Poa annua subsp. exilis', 'subspecies', 1, '(Tomm. ex Freyn) Asch. & Graebn.', 'http://www.tropicos.org/Name/50063800', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'true', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth', NULL, 'Poa infirma'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 29, 9, 'Poa annua ssp. exilis', 0.959999999999999964, 'Poa annua var. exilis', 'variety', 0.959999999999999964, 'Tomm. ex Freyn', 'http://www.tropicos.org/Name/25547854', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'exilis', 0.699999999999999956, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua var. exilis Tomm. ex Freyn', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth', NULL, 'Poa infirma'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 30, 10, 'Poa annua subsp. exilis', 1, 'Poa annua subsp. exilis', 'subsp.', 1, '(Tomm. ex Freyn.) Asch. & Graebn.', 'http://www.theplantlist.org/tpl1.1/record/kew-435202', NULL, NULL, NULL, NULL, NULL, 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'true', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn.) Asch. & Graebn.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth', NULL, 'Poa infirma'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 31, 10, 'Poa annua subsp. exilis', 1, 'Poa annua subsp. exilis', 'subspecies', 1, '(Tomm. ex Freyn) Asch. & Graebn.', 'http://www.tropicos.org/Name/50063800', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, '{Poa,infirma}', 'Poa', 'infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth', NULL, 'Poa infirma'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 32, 11, 'Poa annua subvar. minima', 1, 'Poa annua subvar. minima', 'subvariety', 1, '(Schur) Asch. & Graebn.', 'http://www.tropicos.org/Name/50158097', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subvar.', 'minima', 1, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua subvar. minima', '(Schur) Asch. & Graebn.', 'subvariety', 'http://www.tropicos.org/Name/50158097', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.', 'Poa annua', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', true, '{Poa,annua}', 'Poa', 'annua', 'subvar. minima', '{subvar.,minima}', 'subvar.', 'minima', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', 'subvariety', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'subvar.', 'annua', 'Poa annua subvar. minima', '(Schur) Asch. & Graebn.', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', NULL, 'Poa annua'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 33, 12, 'Poa annua var. eriolepis', 1, 'Poa annua var. eriolepis', 'var.', 1, '̉ۡ.Desv.', 'http://www.theplantlist.org/tpl1.1/record/kew-435206', NULL, NULL, NULL, NULL, NULL, 'Poa', 1, 'annua', 1, 'var.', 'eriolepis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-435194', 'Poa annua', 'Poaceae', 'true', 'tpl', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua var. eriolepis ̉ۡ.Desv.', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.', NULL, 'Poa annua'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 34, 12, 'Poa annua var. eriolepis', 1, 'Poa annua var. eriolepis', 'variety', 1, 'E. Desv.', 'http://www.tropicos.org/Name/50119145', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'eriolepis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.tropicos.org/Name/25509881', 'Poa annua', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua L.', 'Poa annua', 'Poa annua var. eriolepis E. Desv.', true, '{Poa,annua}', 'Poa', 'annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.', NULL, 'Poa annua'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 35, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subsp.', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', 'Silene scouleri', 'Caryophyllaceae', 'true', 'tpl', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 36, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'false', 'tropicos', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 37, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://plants.usda.gov/java/profile?symbol=SISCP', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://plants.usda.gov/java/profile?symbol=SISCP', 'Silene scouleri', 'Caryophyllaceae', 'false', 'usda', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'ssp. pringlei', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'ssp.', 'scouleri', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 38, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subsp.', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', 'Silene scouleri', 'Caryophyllaceae', 'true', 'tpl', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 39, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'false', 'tropicos', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri'); INSERT INTO taxon_match VALUES ('2014-07-21 16:31:50.48692-07', 40, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://plants.usda.gov/java/profile?symbol=SISCP', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://plants.usda.gov/java/profile?symbol=SISCP', 'Silene scouleri', 'Caryophyllaceae', 'false', 'usda', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, '{Silene,scouleri}', 'Silene', 'scouleri', 'ssp. pringlei', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'ssp.', 'scouleri', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri'); -- -- Data for Name: taxon_match_input__copy_to; Type: TABLE DATA; Schema: TNRS; Owner: - -- -- -- PostgreSQL database dump complete --