/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 13850

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: tnrs: renamed to tnrs_match to distinguish it from other TNRS-related tables

     --
     -- Data for Name: tnrs; Type: TABLE DATA; Schema: TNRS; Owner: -
     -- Data for Name: tnrs_match; Type: TABLE DATA; Schema: TNRS; Owner: -
     --
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 0, 0, '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);
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 1, 1, '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.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 2, 1, '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.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 3, 2, '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.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 4, 2, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 5, 3, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 6, 3, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 7, 3, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 8, 4, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 9, 4, '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', 'true', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 10, 4, '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.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 11, 4, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 12, 4, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 13, 4, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 14, 5, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 15, 5, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 16, 6, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 17, 6, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 18, 7, '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.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 19, 8, '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.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 20, 8, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 21, 9, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 22, 9, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 23, 9, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 24, 10, '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.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 25, 10, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 26, 11, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 27, 11, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 28, 11, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 29, 12, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 30, 12, '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.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 31, 12, '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.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 32, 13, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 33, 13, '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.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 34, 13, '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.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 35, 14, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 36, 14, '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', 'true', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 37, 14, '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.');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 38, 14, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 39, 14, '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');
     INSERT INTO tnrs VALUES ('2014-06-02 04:36:16.989683-07', 40, 14, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 0, 0, '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);
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 1, 1, '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.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 2, 1, '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.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 3, 2, '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.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 4, 2, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 5, 3, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 6, 3, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 7, 3, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 8, 4, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 9, 4, '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', 'true', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 10, 4, '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.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 11, 4, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 12, 4, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 13, 4, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 14, 5, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 15, 5, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 16, 6, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 17, 6, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 18, 7, '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.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 19, 8, '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.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 20, 8, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 21, 9, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 22, 9, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 23, 9, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 24, 10, '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.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 25, 10, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 26, 11, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 27, 11, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 28, 11, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 29, 12, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 30, 12, '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.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 31, 12, '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.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 32, 13, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 33, 13, '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.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 34, 13, '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.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 35, 14, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 36, 14, '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', 'true', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 37, 14, '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.');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 38, 14, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 39, 14, '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');
     INSERT INTO tnrs_match VALUES ('2014-06-02 04:36:16.989683-07', 40, 14, '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');
     --

     $ svn di
     # make the changes shown in the diff
     ## to change column types:
     SELECT util.set_col_types(''"TNRS".tnrs'', ARRAY[
     SELECT util.set_col_types(''"TNRS".tnrs_match'', ARRAY[
       (''col'', ''new_type'')
     ]::util.col_cast[]); -- runtime: 9 min ("531282 ms")
     $ rm=1 inputs/.TNRS/schema.sql.run
-...
     COMMENT ON FUNCTION tnrs_populate_fields() IS '
     IMPORTANT: when changing this function, you must regenerate the derived cols:
     UPDATE "TNRS".tnrs SET "Name_submitted" = "Name_submitted"
     UPDATE "TNRS".tnrs_match SET "Name_submitted" = "Name_submitted"
     runtime: 30 min ("5564082 rows affected, 1918900 ms execution time")
     VACUUM ANALYZE "TNRS".tnrs -- to remove previous rows
     VACUUM ANALYZE "TNRS".tnrs_match -- to remove previous rows
     runtime: 1.5 min ("92633 ms")
     ';
-...
     SET default_with_oids = false;
     --
     -- Name: tnrs; Type: TABLE; Schema: TNRS; Owner: -; Tablespace:
     -- Name: tnrs_match; Type: TABLE; Schema: TNRS; Owner: -; Tablespace:
     --
     CREATE TABLE tnrs (
     CREATE TABLE tnrs_match (
         batch text DEFAULT now() NOT NULL,
         match_num integer NOT NULL,
         "Name_number" integer NOT NULL,
-...
     --
     -- Name: TABLE tnrs; Type: COMMENT; Schema: TNRS; Owner: -
     -- Name: TABLE tnrs_match; Type: COMMENT; Schema: TNRS; Owner: -
     --
     COMMENT ON TABLE tnrs IS '
     COMMENT ON TABLE tnrs_match IS '
     to remove columns or add columns at the end:
     $ rm=1 inputs/.TNRS/data.sql.run
     $ make schemas/remake
-...
     $ make schemas/remake
     to populate a new column:
     ALTER TABLE "TNRS".tnrs DISABLE TRIGGER tnrs_populate_fields; --speeds up update
     UPDATE "TNRS".tnrs SET "col" = value;
     ALTER TABLE "TNRS".tnrs_match DISABLE TRIGGER tnrs_populate_fields; --speeds up update
     UPDATE "TNRS".tnrs_match SET "col" = value;
     	-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
     ALTER TABLE "TNRS".tnrs ENABLE TRIGGER tnrs_populate_fields;
     VACUUM ANALYZE "TNRS".tnrs --remove previous rows; runtime: 1.5 min ("92633 ms")
     ALTER TABLE "TNRS".tnrs_match ENABLE TRIGGER tnrs_populate_fields;
     VACUUM ANALYZE "TNRS".tnrs_match --remove previous rows; runtime: 1.5 min ("92633 ms")
     to add a constraint: runtime: 3 min ("173620 ms")
     ';
-...
                 WHEN (s.accepted_taxon_rank = 'genus'::text) THEN concat_ws(' '::text, s.accepted_taxon_name_no_author, s."morphospeciesSuffix")
                 ELSE s.accepted_species_binomial
             END AS accepted_morphospecies_binomial
        FROM ( SELECT tnrs.batch AS "*Name_matched.batch",
                 tnrs."Name_submitted" AS "concatenatedScientificName",
                 tnrs."Name_matched" AS "matchedTaxonName",
                 tnrs."Name_matched_rank" AS "matchedTaxonRank",
                 tnrs."Name_score" AS "*Name_matched.Name_score",
                 tnrs."Name_matched_author" AS "matchedScientificNameAuthorship",
                 tnrs."Name_matched_url" AS "matchedScientificNameID",
                 tnrs."Author_score" AS "*Name_matched.Author_score",
                 tnrs."Family_score" AS "matchedFamilyConfidence_fraction",
                 COALESCE(tnrs."Name_matched_accepted_family", tnrs."Accepted_name_family") AS "matchedFamily",
                 tnrs."Genus_matched" AS "matchedGenus",
                 tnrs."Genus_score" AS "matchedGenusConfidence_fraction",
                 tnrs."Specific_epithet_matched" AS "matchedSpecificEpithet",
                 tnrs."Specific_epithet_score" AS "matchedSpeciesConfidence_fraction",
                 tnrs."Infraspecific_epithet_matched" AS "matchedInfraspecificEpithet",
                 tnrs."Infraspecific_epithet_score" AS "*Name_matched.Infraspecific_epithet_score",
                 tnrs."Annotations" AS "identificationQualifier",
                 tnrs."Unmatched_terms" AS "morphospeciesSuffix",
                 map_taxonomic_status(tnrs."Taxonomic_status", tnrs."Accepted_name") AS "taxonomicStatus",
                 tnrs."Accepted_name" AS accepted_taxon_name_no_author,
                 tnrs."Accepted_name_author" AS accepted_author,
                 tnrs."Accepted_name_rank" AS accepted_taxon_rank,
                 tnrs."Accepted_name_url" AS "acceptedScientificNameID",
                 tnrs."Accepted_name_species" AS accepted_species_binomial,
                 tnrs."Accepted_name_family" AS accepted_family,
                 tnrs."Selected" AS "*Name_matched.Selected",
                 tnrs."Source" AS "*Name_matched.Source",
                 tnrs."Warnings" AS "*Name_matched.Warnings",
                 tnrs."Accepted_name_lsid" AS "*Name_matched.Accepted_name_lsid",
                 tnrs.is_valid_match AS taxon_scrub__is_valid_match,
                 tnrs.scrubbed_unique_taxon_name
                FROM tnrs) s;
        FROM ( SELECT tnrs_match.batch AS "*Name_matched.batch",
                 tnrs_match."Name_submitted" AS "concatenatedScientificName",
                 tnrs_match."Name_matched" AS "matchedTaxonName",
                 tnrs_match."Name_matched_rank" AS "matchedTaxonRank",
                 tnrs_match."Name_score" AS "*Name_matched.Name_score",
                 tnrs_match."Name_matched_author" AS "matchedScientificNameAuthorship",
                 tnrs_match."Name_matched_url" AS "matchedScientificNameID",
                 tnrs_match."Author_score" AS "*Name_matched.Author_score",
                 tnrs_match."Family_score" AS "matchedFamilyConfidence_fraction",
                 COALESCE(tnrs_match."Name_matched_accepted_family", tnrs_match."Accepted_name_family") AS "matchedFamily",
                 tnrs_match."Genus_matched" AS "matchedGenus",
                 tnrs_match."Genus_score" AS "matchedGenusConfidence_fraction",
                 tnrs_match."Specific_epithet_matched" AS "matchedSpecificEpithet",
                 tnrs_match."Specific_epithet_score" AS "matchedSpeciesConfidence_fraction",
                 tnrs_match."Infraspecific_epithet_matched" AS "matchedInfraspecificEpithet",
                 tnrs_match."Infraspecific_epithet_score" AS "*Name_matched.Infraspecific_epithet_score",
                 tnrs_match."Annotations" AS "identificationQualifier",
                 tnrs_match."Unmatched_terms" AS "morphospeciesSuffix",
                 map_taxonomic_status(tnrs_match."Taxonomic_status", tnrs_match."Accepted_name") AS "taxonomicStatus",
                 tnrs_match."Accepted_name" AS accepted_taxon_name_no_author,
                 tnrs_match."Accepted_name_author" AS accepted_author,
                 tnrs_match."Accepted_name_rank" AS accepted_taxon_rank,
                 tnrs_match."Accepted_name_url" AS "acceptedScientificNameID",
                 tnrs_match."Accepted_name_species" AS accepted_species_binomial,
                 tnrs_match."Accepted_name_family" AS accepted_family,
                 tnrs_match."Selected" AS "*Name_matched.Selected",
                 tnrs_match."Source" AS "*Name_matched.Source",
                 tnrs_match."Warnings" AS "*Name_matched.Warnings",
                 tnrs_match."Accepted_name_lsid" AS "*Name_matched.Accepted_name_lsid",
                 tnrs_match.is_valid_match AS taxon_scrub__is_valid_match,
                 tnrs_match.scrubbed_unique_taxon_name
                FROM tnrs_match) s;
     --
-...
     --
     CREATE VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" AS
      SELECT tnrs."Name_submitted" AS scrubbed_unique_taxon_name,
         tnrs."Name_matched_rank" AS scrubbed_taxon_rank,
         COALESCE(tnrs."Name_matched_accepted_family", tnrs."Family_matched") AS scrubbed_family,
         tnrs."Genus_matched" AS scrubbed_genus,
         tnrs."Specific_epithet_matched" AS scrubbed_specific_epithet,
         tnrs."Infraspecific_rank" AS scrubbed_infraspecific_rank,
         tnrs."Infraspecific_epithet_matched" AS scrubbed_infraspecific_epithet,
         tnrs."Name_matched_author" AS scrubbed_author,
         tnrs."Name_matched" AS scrubbed_taxon_name_no_author,
         (tnrs."Name_matched" || COALESCE((' '::text || tnrs."Name_matched_author"), ''::text)) AS scrubbed_taxon_name_with_author
        FROM tnrs;
      SELECT tnrs_match."Name_submitted" AS scrubbed_unique_taxon_name,
         tnrs_match."Name_matched_rank" AS scrubbed_taxon_rank,
         COALESCE(tnrs_match."Name_matched_accepted_family", tnrs_match."Family_matched") AS scrubbed_family,
         tnrs_match."Genus_matched" AS scrubbed_genus,
         tnrs_match."Specific_epithet_matched" AS scrubbed_specific_epithet,
         tnrs_match."Infraspecific_rank" AS scrubbed_infraspecific_rank,
         tnrs_match."Infraspecific_epithet_matched" AS scrubbed_infraspecific_epithet,
         tnrs_match."Name_matched_author" AS scrubbed_author,
         tnrs_match."Name_matched" AS scrubbed_taxon_name_no_author,
         (tnrs_match."Name_matched" || COALESCE((' '::text || tnrs_match."Name_matched_author"), ''::text)) AS scrubbed_taxon_name_with_author
        FROM tnrs_match;
     --
-...
     -- Name: tnrs_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY tnrs
     ALTER TABLE ONLY tnrs_match
         ADD CONSTRAINT tnrs_pkey PRIMARY KEY (batch, match_num);
-...
     -- Name: tnrs_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
     --
     CREATE INDEX "tnrs_Name_submitted_idx" ON tnrs USING btree ("Name_submitted");
     CREATE INDEX "tnrs_Name_submitted_idx" ON tnrs_match USING btree ("Name_submitted");
     --
     -- Name: tnrs__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
     --
     CREATE INDEX tnrs__valid_match ON tnrs USING btree ("Name_submitted") WHERE is_valid_match;
     CREATE INDEX tnrs__valid_match ON tnrs_match USING btree ("Name_submitted") WHERE is_valid_match;
     --
-...
     -- Name: tnrs__batch_begin; Type: TRIGGER; Schema: TNRS; Owner: -
     --
     CREATE TRIGGER tnrs__batch_begin BEFORE INSERT ON tnrs FOR EACH STATEMENT EXECUTE PROCEDURE tnrs__batch_begin();
     CREATE TRIGGER tnrs__batch_begin BEFORE INSERT ON tnrs_match FOR EACH STATEMENT EXECUTE PROCEDURE tnrs__batch_begin();
     --
     -- Name: tnrs__match_num__fill; Type: TRIGGER; Schema: TNRS; Owner: -
     --
     CREATE TRIGGER tnrs__match_num__fill BEFORE INSERT ON tnrs FOR EACH ROW EXECUTE PROCEDURE tnrs__match_num__fill();
     CREATE TRIGGER tnrs__match_num__fill BEFORE INSERT ON tnrs_match FOR EACH ROW EXECUTE PROCEDURE tnrs__match_num__fill();
     --
     -- Name: tnrs_populate_fields; Type: TRIGGER; Schema: TNRS; Owner: -
     --
     CREATE TRIGGER tnrs_populate_fields BEFORE INSERT OR UPDATE ON tnrs FOR EACH ROW EXECUTE PROCEDURE tnrs_populate_fields();
     CREATE TRIGGER tnrs_populate_fields BEFORE INSERT OR UPDATE ON tnrs_match FOR EACH ROW EXECUTE PROCEDURE tnrs_populate_fields();
     --
-...
     -- Name: tnrs_batch_fkey; Type: FK CONSTRAINT; Schema: TNRS; Owner: -
     --
     ALTER TABLE ONLY tnrs
     ALTER TABLE ONLY tnrs_match
         ADD CONSTRAINT tnrs_batch_fkey FOREIGN KEY (batch) REFERENCES batch(id) ON UPDATE CASCADE ON DELETE CASCADE;
-...
     --
     -- Name: tnrs; Type: ACL; Schema: TNRS; Owner: -
     -- Name: tnrs_match; Type: ACL; Schema: TNRS; Owner: -
     --
     REVOKE ALL ON TABLE tnrs FROM PUBLIC;
     REVOKE ALL ON TABLE tnrs FROM bien;
     GRANT ALL ON TABLE tnrs TO bien;
     GRANT SELECT ON TABLE tnrs TO bien_read;
     REVOKE ALL ON TABLE tnrs_match FROM PUBLIC;
     REVOKE ALL ON TABLE tnrs_match FROM bien;
     GRANT ALL ON TABLE tnrs_match TO bien;
     GRANT SELECT ON TABLE tnrs_match TO bien_read;
     --

     --
     -- Name: tnrs; Type: TABLE; Schema: TNRS; Owner: -; Tablespace:
     -- Name: tnrs_match; Type: TABLE; Schema: TNRS; Owner: -; Tablespace:
     --
     CREATE TABLE tnrs (
     CREATE TABLE tnrs_match (
         batch varchar(255)  NOT NULL,
         match_num int(11) NOT NULL,
         `Name_number` int(11) NOT NULL,
-...
     --
     -- Name: TABLE tnrs; Type: COMMENT; Schema: TNRS; Owner: -
     -- Name: TABLE tnrs_match; Type: COMMENT; Schema: TNRS; Owner: -
     --
-...
     -- Name: tnrs_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace:
     --
     ALTER TABLE tnrs
     ALTER TABLE tnrs_match
         ADD CONSTRAINT tnrs_pkey PRIMARY KEY (batch, match_num);
-...
     -- Name: tnrs_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
     --
     CREATE INDEX `tnrs_Name_submitted_idx` ON tnrs  (`Name_submitted`);
     CREATE INDEX `tnrs_Name_submitted_idx` ON tnrs_match  (`Name_submitted`);
     --
-...
     -- Name: tnrs_batch_fkey; Type: FK CONSTRAINT; Schema: TNRS; Owner: -
     --
     ALTER TABLE tnrs
     ALTER TABLE tnrs_match
         ADD CONSTRAINT tnrs_batch_fkey FOREIGN KEY (batch) REFERENCES batch(id) ON UPDATE CASCADE ON DELETE CASCADE;
-...
     --
     -- Name: tnrs; Type: ACL; Schema: TNRS; Owner: -
     -- Name: tnrs_match; Type: ACL; Schema: TNRS; Owner: -
     --

     $ svn di
     # make the changes shown in the diff
     ## to change column types:
     SELECT util.set_col_types(''"TNRS".tnrs'', ARRAY[
     SELECT util.set_col_types(''"TNRS".tnrs_match'', ARRAY[
       (''col'', ''new_type'')
     ]::util.col_cast[]); -- runtime: 9 min ("531282 ms")
     $ rm=1 inputs/.TNRS/schema.sql.run
-...
     COMMENT ON FUNCTION tnrs_populate_fields() IS '
     IMPORTANT: when changing this function, you must regenerate the derived cols:
     UPDATE "TNRS".tnrs SET "Name_submitted" = "Name_submitted"
     UPDATE "TNRS".tnrs_match SET "Name_submitted" = "Name_submitted"
     runtime: 30 min ("5564082 rows affected, 1918900 ms execution time")
     VACUUM ANALYZE "TNRS".tnrs -- to remove previous rows
     VACUUM ANALYZE "TNRS".tnrs_match -- to remove previous rows
     runtime: 1.5 min ("92633 ms")
     ';
-...
     SET default_with_oids = false;
     --
     -- Name: tnrs; Type: TABLE; Schema: TNRS; Owner: -; Tablespace:
     -- Name: tnrs_match; Type: TABLE; Schema: TNRS; Owner: -; Tablespace:
     --
     CREATE TABLE tnrs (
     CREATE TABLE tnrs_match (
         batch text DEFAULT now() NOT NULL,
         match_num integer NOT NULL,
         "Name_number" integer NOT NULL,
-...
     --
     -- Name: TABLE tnrs; Type: COMMENT; Schema: TNRS; Owner: -
     -- Name: TABLE tnrs_match; Type: COMMENT; Schema: TNRS; Owner: -
     --
     COMMENT ON TABLE tnrs IS '
     COMMENT ON TABLE tnrs_match IS '
     to remove columns or add columns at the end:
     $ rm=1 inputs/.TNRS/data.sql.run
     $ make schemas/remake
-...
     $ make schemas/remake
     to populate a new column:
     ALTER TABLE "TNRS".tnrs DISABLE TRIGGER tnrs_populate_fields; --speeds up update
     UPDATE "TNRS".tnrs SET "col" = value;
     ALTER TABLE "TNRS".tnrs_match DISABLE TRIGGER tnrs_populate_fields; --speeds up update
     UPDATE "TNRS".tnrs_match SET "col" = value;
     	-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
     ALTER TABLE "TNRS".tnrs ENABLE TRIGGER tnrs_populate_fields;
     VACUUM ANALYZE "TNRS".tnrs --remove previous rows; runtime: 1.5 min ("92633 ms")
     ALTER TABLE "TNRS".tnrs_match ENABLE TRIGGER tnrs_populate_fields;
     VACUUM ANALYZE "TNRS".tnrs_match --remove previous rows; runtime: 1.5 min ("92633 ms")
     to add a constraint: runtime: 3 min ("173620 ms")
     ';
-...
                 WHEN (s.accepted_taxon_rank = 'genus'::text) THEN concat_ws(' '::text, s.accepted_taxon_name_no_author, s."morphospeciesSuffix")
                 ELSE s.accepted_species_binomial
             END AS accepted_morphospecies_binomial
        FROM ( SELECT tnrs.batch AS "*Name_matched.batch",
                 tnrs."Name_submitted" AS "concatenatedScientificName",
                 tnrs."Name_matched" AS "matchedTaxonName",
                 tnrs."Name_matched_rank" AS "matchedTaxonRank",
                 tnrs."Name_score" AS "*Name_matched.Name_score",
                 tnrs."Name_matched_author" AS "matchedScientificNameAuthorship",
                 tnrs."Name_matched_url" AS "matchedScientificNameID",
                 tnrs."Author_score" AS "*Name_matched.Author_score",
                 tnrs."Family_score" AS "matchedFamilyConfidence_fraction",
                 COALESCE(tnrs."Name_matched_accepted_family", tnrs."Accepted_name_family") AS "matchedFamily",
                 tnrs."Genus_matched" AS "matchedGenus",
                 tnrs."Genus_score" AS "matchedGenusConfidence_fraction",
                 tnrs."Specific_epithet_matched" AS "matchedSpecificEpithet",
                 tnrs."Specific_epithet_score" AS "matchedSpeciesConfidence_fraction",
                 tnrs."Infraspecific_epithet_matched" AS "matchedInfraspecificEpithet",
                 tnrs."Infraspecific_epithet_score" AS "*Name_matched.Infraspecific_epithet_score",
                 tnrs."Annotations" AS "identificationQualifier",
                 tnrs."Unmatched_terms" AS "morphospeciesSuffix",
                 map_taxonomic_status(tnrs."Taxonomic_status", tnrs."Accepted_name") AS "taxonomicStatus",
                 tnrs."Accepted_name" AS accepted_taxon_name_no_author,
                 tnrs."Accepted_name_author" AS accepted_author,
                 tnrs."Accepted_name_rank" AS accepted_taxon_rank,
                 tnrs."Accepted_name_url" AS "acceptedScientificNameID",
                 tnrs."Accepted_name_species" AS accepted_species_binomial,
                 tnrs."Accepted_name_family" AS accepted_family,
                 tnrs."Selected" AS "*Name_matched.Selected",
                 tnrs."Source" AS "*Name_matched.Source",
                 tnrs."Warnings" AS "*Name_matched.Warnings",
                 tnrs."Accepted_name_lsid" AS "*Name_matched.Accepted_name_lsid",
                 tnrs.is_valid_match AS taxon_scrub__is_valid_match,
                 tnrs.scrubbed_unique_taxon_name
                FROM tnrs) s;
        FROM ( SELECT tnrs_match.batch AS "*Name_matched.batch",
                 tnrs_match."Name_submitted" AS "concatenatedScientificName",
                 tnrs_match."Name_matched" AS "matchedTaxonName",
                 tnrs_match."Name_matched_rank" AS "matchedTaxonRank",
                 tnrs_match."Name_score" AS "*Name_matched.Name_score",
                 tnrs_match."Name_matched_author" AS "matchedScientificNameAuthorship",
                 tnrs_match."Name_matched_url" AS "matchedScientificNameID",
                 tnrs_match."Author_score" AS "*Name_matched.Author_score",
                 tnrs_match."Family_score" AS "matchedFamilyConfidence_fraction",
                 COALESCE(tnrs_match."Name_matched_accepted_family", tnrs_match."Accepted_name_family") AS "matchedFamily",
                 tnrs_match."Genus_matched" AS "matchedGenus",
                 tnrs_match."Genus_score" AS "matchedGenusConfidence_fraction",
                 tnrs_match."Specific_epithet_matched" AS "matchedSpecificEpithet",
                 tnrs_match."Specific_epithet_score" AS "matchedSpeciesConfidence_fraction",
                 tnrs_match."Infraspecific_epithet_matched" AS "matchedInfraspecificEpithet",
                 tnrs_match."Infraspecific_epithet_score" AS "*Name_matched.Infraspecific_epithet_score",
                 tnrs_match."Annotations" AS "identificationQualifier",
                 tnrs_match."Unmatched_terms" AS "morphospeciesSuffix",
                 map_taxonomic_status(tnrs_match."Taxonomic_status", tnrs_match."Accepted_name") AS "taxonomicStatus",
                 tnrs_match."Accepted_name" AS accepted_taxon_name_no_author,
                 tnrs_match."Accepted_name_author" AS accepted_author,
                 tnrs_match."Accepted_name_rank" AS accepted_taxon_rank,
                 tnrs_match."Accepted_name_url" AS "acceptedScientificNameID",
                 tnrs_match."Accepted_name_species" AS accepted_species_binomial,
                 tnrs_match."Accepted_name_family" AS accepted_family,
                 tnrs_match."Selected" AS "*Name_matched.Selected",
                 tnrs_match."Source" AS "*Name_matched.Source",
                 tnrs_match."Warnings" AS "*Name_matched.Warnings",
                 tnrs_match."Accepted_name_lsid" AS "*Name_matched.Accepted_name_lsid",
                 tnrs_match.is_valid_match AS taxon_scrub__is_valid_match,
                 tnrs_match.scrubbed_unique_taxon_name
                FROM tnrs_match) s;
     --
-...
     --
     CREATE VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" AS
      SELECT tnrs."Name_submitted" AS scrubbed_unique_taxon_name,
         tnrs."Name_matched_rank" AS scrubbed_taxon_rank,
         COALESCE(tnrs."Name_matched_accepted_family", tnrs."Family_matched") AS scrubbed_family,
         tnrs."Genus_matched" AS scrubbed_genus,
         tnrs."Specific_epithet_matched" AS scrubbed_specific_epithet,
         tnrs."Infraspecific_rank" AS scrubbed_infraspecific_rank,
         tnrs."Infraspecific_epithet_matched" AS scrubbed_infraspecific_epithet,
         tnrs."Name_matched_author" AS scrubbed_author,
         tnrs."Name_matched" AS scrubbed_taxon_name_no_author,
         (tnrs."Name_matched" || COALESCE((' '::text || tnrs."Name_matched_author"), ''::text)) AS scrubbed_taxon_name_with_author
        FROM tnrs;
      SELECT tnrs_match."Name_submitted" AS scrubbed_unique_taxon_name,
         tnrs_match."Name_matched_rank" AS scrubbed_taxon_rank,
         COALESCE(tnrs_match."Name_matched_accepted_family", tnrs_match."Family_matched") AS scrubbed_family,
         tnrs_match."Genus_matched" AS scrubbed_genus,
         tnrs_match."Specific_epithet_matched" AS scrubbed_specific_epithet,
         tnrs_match."Infraspecific_rank" AS scrubbed_infraspecific_rank,
         tnrs_match."Infraspecific_epithet_matched" AS scrubbed_infraspecific_epithet,
         tnrs_match."Name_matched_author" AS scrubbed_author,
         tnrs_match."Name_matched" AS scrubbed_taxon_name_no_author,
         (tnrs_match."Name_matched" || COALESCE((' '::text || tnrs_match."Name_matched_author"), ''::text)) AS scrubbed_taxon_name_with_author
        FROM tnrs_match;
     --
-...
     -- Name: tnrs_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace:
     --
     ALTER TABLE ONLY tnrs
     ALTER TABLE ONLY tnrs_match
         ADD CONSTRAINT tnrs_pkey PRIMARY KEY (batch, match_num);
-...
     -- Name: tnrs_Name_submitted_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
     --
     CREATE INDEX "tnrs_Name_submitted_idx" ON tnrs USING btree ("Name_submitted");
     CREATE INDEX "tnrs_Name_submitted_idx" ON tnrs_match USING btree ("Name_submitted");
     --
     -- Name: tnrs__valid_match; Type: INDEX; Schema: TNRS; Owner: -; Tablespace:
     --
     CREATE INDEX tnrs__valid_match ON tnrs USING btree ("Name_submitted") WHERE is_valid_match;
     CREATE INDEX tnrs__valid_match ON tnrs_match USING btree ("Name_submitted") WHERE is_valid_match;
     SET search_path = geoscrub, pg_catalog;
-...
     -- Name: tnrs__batch_begin; Type: TRIGGER; Schema: TNRS; Owner: -
     --
     CREATE TRIGGER tnrs__batch_begin BEFORE INSERT ON tnrs FOR EACH STATEMENT EXECUTE PROCEDURE tnrs__batch_begin();
     CREATE TRIGGER tnrs__batch_begin BEFORE INSERT ON tnrs_match FOR EACH STATEMENT EXECUTE PROCEDURE tnrs__batch_begin();
     --
     -- Name: tnrs__match_num__fill; Type: TRIGGER; Schema: TNRS; Owner: -
     --
     CREATE TRIGGER tnrs__match_num__fill BEFORE INSERT ON tnrs FOR EACH ROW EXECUTE PROCEDURE tnrs__match_num__fill();
     CREATE TRIGGER tnrs__match_num__fill BEFORE INSERT ON tnrs_match FOR EACH ROW EXECUTE PROCEDURE tnrs__match_num__fill();
     --
     -- Name: tnrs_populate_fields; Type: TRIGGER; Schema: TNRS; Owner: -
     --
     CREATE TRIGGER tnrs_populate_fields BEFORE INSERT OR UPDATE ON tnrs FOR EACH ROW EXECUTE PROCEDURE tnrs_populate_fields();
     CREATE TRIGGER tnrs_populate_fields BEFORE INSERT OR UPDATE ON tnrs_match FOR EACH ROW EXECUTE PROCEDURE tnrs_populate_fields();
     --
-...
     -- Name: tnrs_batch_fkey; Type: FK CONSTRAINT; Schema: TNRS; Owner: -
     --
     ALTER TABLE ONLY tnrs
     ALTER TABLE ONLY tnrs_match
         ADD CONSTRAINT tnrs_batch_fkey FOREIGN KEY (batch) REFERENCES batch(id) ON UPDATE CASCADE ON DELETE CASCADE;
-...
     --
     -- Name: tnrs; Type: ACL; Schema: TNRS; Owner: -
     -- Name: tnrs_match; Type: ACL; Schema: TNRS; Owner: -
     --
     REVOKE ALL ON TABLE tnrs FROM PUBLIC;
     REVOKE ALL ON TABLE tnrs FROM bien;
     GRANT ALL ON TABLE tnrs TO bien;
     GRANT SELECT ON TABLE tnrs TO bien_read;
     REVOKE ALL ON TABLE tnrs_match FROM PUBLIC;
     REVOKE ALL ON TABLE tnrs_match FROM bien;
     GRANT ALL ON TABLE tnrs_match TO bien;
     GRANT SELECT ON TABLE tnrs_match TO bien_read;
     --

     tnrs_input = sql_gen.Table('tnrs_input_name')
     tnrs_batch = sql_gen.Table('batch')
     tnrs_data = sql_gen.Table('tnrs')
     tnrs_data = sql_gen.Table('tnrs_match')
     def main():
         # Input

Also available in: Unified diff

Project

General

Profile

Revision 13850

Added by Aaron Marcuse-Kubitza over 10 years ago