Project

General

Profile

« Previous | Next » 

Revision 11629

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/.TNRS/schema.sql: tnrs: removed Is_plant, since this functionality is now provided by is_valid_match. note that whether a name is a plant is not meaningful for TNRS, because it can match only plant names (thus a "non-plant" is actually a non-match).

View differences:

inputs/.TNRS/data.sql
35 35 
-- Data for Name: tnrs; Type: TABLE DATA; Schema: TNRS; Owner: -
36 36 
--
37 37 

  		




  38
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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, NULL, NULL, NULL, false, NULL);


  		




  39
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa annua L.', false, true, true, 'Poaceae Poa annua L.');


  		




  40
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 2, 'Poa annua', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.tropicos.org/Name/25509881', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.tropicos.org/Name/25509881', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa annua L.', false, true, true, 'Poaceae Poa annua L.');


  		




  41
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' [Partial match] ', NULL, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, true, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  42
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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, 'Fabaceae Lindl.', false, true, true, 'Fabaceae Lindl.');


  		




  43
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa infirma Kunth', false, true, true, 'Poaceae Poa infirma Kunth');


  		




  44
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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, 'Poaceae Poa infirma Kunth', false, true, true, 'Poaceae Poa infirma Kunth');


  		




  45
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.', false, true, true, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.');


  		




  46
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 8, 'Poa annua L.', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.tropicos.org/Name/25509881', 'L.', 1, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.tropicos.org/Name/25509881', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa annua L.', false, true, true, 'Poaceae Poa annua L.');


  		




  47
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' ', NULL, 'Asteraceae Bercht. & J. Presl', false, true, true, 'Asteraceae Bercht. & J. Presl');


  		




  48
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa annua var. annua', false, true, true, 'Poaceae Poa annua var. annua');


  		




  49
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' [Partial match] ', NULL, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, true, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  50
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' ', NULL, 'Fabaceae Inga Mill.', true, true, true, 'Fabaceae Inga Mill.');


  		




  51
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' ', NULL, 'Fabaceae Inga Mill.', true, true, true, 'Fabaceae Inga Mill.');


  		




  52
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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, 'Fabaceae Lindl.', false, true, true, 'Fabaceae Lindl.');


  		




  53
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 0, 'Poaceae Poa infirma Kunth', 1, 'Poa infirma', 'species', 1, 'Kunth', 'http://www.tropicos.org/Name/25514158', 'Kunth', 1, 'Poaceae', 1, 'Poaceae', 'Poa', 1, 'infirma', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa infirma Kunth', false, true, true, 'Poaceae Poa infirma Kunth');


  		




  54
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 1, 'Fabaceae Lindl.', 0.5, 'Fabaceae', 'family', 0.5, 'Lindl.', 'http://www.tropicos.org/Name/42000184', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Lindl.', 'Accepted', 'Fabaceae', 'Lindl.', 'family', 'http://www.tropicos.org/Name/42000184', NULL, 'Fabaceae', 'true', 'tropicos', ' [Partial match] ', NULL, 'Fabaceae Lindl.', false, true, true, 'Fabaceae Lindl.');


  		




  55
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 2, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.', 1, 'Poa annua subvar. minima', 'subvariety', 1, '(Schur) Asch. & Graebn.', 'http://www.tropicos.org/Name/50158097', '(Schur) Asch. & Graebn.', 1, 'Poaceae', 1, '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, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.', false, true, true, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.');


  		




  56
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 3, 'Fabaceae Inga Mill.', 1, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', 'Mill.', 1, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'true', 'tropicos', ' ', NULL, 'Fabaceae Inga Mill.', false, true, true, 'Fabaceae Inga Mill.');


  		




  57
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 4, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 1, 'Silene scouleri subsp. pringlei', 'subspecies', 1, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', '(S. Watson) C.L. Hitchc. & Maguire', 1, 'Caryophyllaceae', 1, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'true', 'tropicos', ' ', NULL, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', false, true, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  58
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 5, 'Poaceae Poa annua L.', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.tropicos.org/Name/25509881', 'L.', 1, 'Poaceae', 1, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.tropicos.org/Name/25509881', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa annua L.', false, true, true, 'Poaceae Poa annua L.');


  		




  59
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 6, 'Asteraceae Bercht. & J. Presl', 0.400000000000000022, 'Asteraceae', 'family', 0.5, NULL, 'http://compositae.landcareresearch.co.nz/default.aspx', NULL, NULL, 'Asteraceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Bercht. & J. Presl', 'Accepted', 'Asteraceae', NULL, 'family', 'http://compositae.landcareresearch.co.nz/default.aspx', NULL, NULL, 'true', 'gcc', ' [Partial match] ', NULL, 'Asteraceae', false, true, true, 'Asteraceae');


  		




  60
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 7, 'Poaceae Poa annua var. annua', 1, 'Poa annua var. annua', 'variety', 1, NULL, 'http://www.tropicos.org/Name/25517736', NULL, NULL, 'Poaceae', 1, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'annua', 1, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua var. annua', NULL, 'variety', 'http://www.tropicos.org/Name/25517736', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa annua var. annua', false, true, true, 'Poaceae Poa annua var. annua');


  		




  61
  
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:43.024394-07', 0, 'Asteraceae', 1, 'Asteraceae', 'family', 1, NULL, 'http://compositae.landcareresearch.co.nz/default.aspx', NULL, NULL, 'Asteraceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Asteraceae', NULL, 'family', 'http://compositae.landcareresearch.co.nz/default.aspx', NULL, NULL, 'true', 'gcc', ' ', NULL, 'Asteraceae', false, true, true, 'Asteraceae');


  		




  
  38
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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, NULL, NULL, false, NULL);


  		




  
  39
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa annua L.', false, true, 'Poaceae Poa annua L.');


  		




  
  40
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 2, 'Poa annua', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.tropicos.org/Name/25509881', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.tropicos.org/Name/25509881', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa annua L.', false, true, 'Poaceae Poa annua L.');


  		




  
  41
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' [Partial match] ', NULL, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  
  42
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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, 'Fabaceae Lindl.', false, true, 'Fabaceae Lindl.');


  		




  
  43
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa infirma Kunth', false, true, 'Poaceae Poa infirma Kunth');


  		




  
  44
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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, 'Poaceae Poa infirma Kunth', false, true, 'Poaceae Poa infirma Kunth');


  		




  
  45
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.', false, true, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.');


  		




  
  46
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 8, 'Poa annua L.', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.tropicos.org/Name/25509881', 'L.', 1, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.tropicos.org/Name/25509881', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa annua L.', false, true, 'Poaceae Poa annua L.');


  		




  
  47
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' ', NULL, 'Asteraceae Bercht. & J. Presl', false, true, 'Asteraceae Bercht. & J. Presl');


  		




  
  48
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa annua var. annua', false, true, 'Poaceae Poa annua var. annua');


  		




  
  49
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' [Partial match] ', NULL, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  
  50
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' ', NULL, 'Fabaceae Inga Mill.', true, true, 'Fabaceae Inga Mill.');


  		




  
  51
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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', 'true', 'tropicos', ' ', NULL, 'Fabaceae Inga Mill.', true, true, 'Fabaceae Inga Mill.');


  		




  
  52
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:36.042579-07', 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, 'Fabaceae Lindl.', false, true, 'Fabaceae Lindl.');


  		




  
  53
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 0, 'Poaceae Poa infirma Kunth', 1, 'Poa infirma', 'species', 1, 'Kunth', 'http://www.tropicos.org/Name/25514158', 'Kunth', 1, 'Poaceae', 1, 'Poaceae', 'Poa', 1, 'infirma', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa infirma Kunth', false, true, 'Poaceae Poa infirma Kunth');


  		




  
  54
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 1, 'Fabaceae Lindl.', 0.5, 'Fabaceae', 'family', 0.5, 'Lindl.', 'http://www.tropicos.org/Name/42000184', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Lindl.', 'Accepted', 'Fabaceae', 'Lindl.', 'family', 'http://www.tropicos.org/Name/42000184', NULL, 'Fabaceae', 'true', 'tropicos', ' [Partial match] ', NULL, 'Fabaceae Lindl.', false, true, 'Fabaceae Lindl.');


  		




  
  55
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 2, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.', 1, 'Poa annua subvar. minima', 'subvariety', 1, '(Schur) Asch. & Graebn.', 'http://www.tropicos.org/Name/50158097', '(Schur) Asch. & Graebn.', 1, 'Poaceae', 1, '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, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.', false, true, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.');


  		




  
  56
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 3, 'Fabaceae Inga Mill.', 1, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', 'Mill.', 1, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'true', 'tropicos', ' ', NULL, 'Fabaceae Inga Mill.', false, true, 'Fabaceae Inga Mill.');


  		




  
  57
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 4, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 1, 'Silene scouleri subsp. pringlei', 'subspecies', 1, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', '(S. Watson) C.L. Hitchc. & Maguire', 1, 'Caryophyllaceae', 1, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'true', 'tropicos', ' ', NULL, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', false, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


  		




  
  58
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 5, 'Poaceae Poa annua L.', 1, 'Poa annua', 'species', 1, 'L.', 'http://www.tropicos.org/Name/25509881', 'L.', 1, 'Poaceae', 1, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua', 'L.', 'species', 'http://www.tropicos.org/Name/25509881', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa annua L.', false, true, 'Poaceae Poa annua L.');


  		




  
  59
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 6, 'Asteraceae Bercht. & J. Presl', 0.400000000000000022, 'Asteraceae', 'family', 0.5, NULL, 'http://compositae.landcareresearch.co.nz/default.aspx', NULL, NULL, 'Asteraceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Bercht. & J. Presl', 'Accepted', 'Asteraceae', NULL, 'family', 'http://compositae.landcareresearch.co.nz/default.aspx', NULL, NULL, 'true', 'gcc', ' [Partial match] ', NULL, 'Asteraceae', false, true, 'Asteraceae');


  		




  
  60
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:41.03229-07', 7, 'Poaceae Poa annua var. annua', 1, 'Poa annua var. annua', 'variety', 1, NULL, 'http://www.tropicos.org/Name/25517736', NULL, NULL, 'Poaceae', 1, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'annua', 1, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa annua var. annua', NULL, 'variety', 'http://www.tropicos.org/Name/25517736', 'Poa annua', 'Poaceae', 'true', 'tropicos', ' ', NULL, 'Poaceae Poa annua var. annua', false, true, 'Poaceae Poa annua var. annua');


  		




  
  61
  
    
INSERT INTO tnrs VALUES ('2013-08-27 22:02:43.024394-07', 0, 'Asteraceae', 1, 'Asteraceae', 'family', 1, NULL, 'http://compositae.landcareresearch.co.nz/default.aspx', NULL, NULL, 'Asteraceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Asteraceae', NULL, 'family', 'http://compositae.landcareresearch.co.nz/default.aspx', NULL, NULL, 'true', 'gcc', ' ', NULL, 'Asteraceae', false, true, 'Asteraceae');


  		




  62
  62
  
    

  		




  63
  63
  
    

  		




  64
  64
  
    
--


  		












  

    
      inputs/.TNRS/schema.sql
    
  





  111
  111
  
    
		, new."Accepted_name_author"


  		




  112
  112
  
    
		), '');


  		




  113
  113
  
    
	new."Is_homonym" = COALESCE(genus_is_homonym, family_is_homonym);


  		




  114
  
  
    
	new."Is_plant" = (CASE


  		




  
  114
  
    
	/* exclude homonyms because these are not valid matches (i.e. TNRS provides


  		




  
  115
  
    
	a name, but the name is not meaningful because it is not unambiguous). */


  		




  
  116
  
    
	new.is_valid_match = COALESCE(CASE


  		




  115
  117
  
    
		WHEN new."Family_score" = 1 AND NOT family_is_homonym -- exact match


  		




  116
  118
  
    
			THEN true


  		




  117
  119
  
    
		ELSE -- consider genus


  		




  ......




  126
  128
  
    
				THEN "Specific_epithet_is_plant"


  		




  127
  129
  
    
			ELSE NULL -- ambiguous


  		




  128
  130
  
    
			END)


  		




  129
  
  
    
		END);


  		




  130
  
  
    
	/* exclude homonyms because these are not valid matches (i.e. TNRS provides


  		




  131
  
  
    
	a name, but the name is not meaningful because it is not unambiguous). */


  		




  132
  
  
    
	new.is_valid_match = COALESCE(new."Is_plant", false);


  		




  
  131
  
    
		END, false);


  		




  133
  132
  
    
	new.scrubbed_taxon_name_with_author = COALESCE(


  		




  134
  133
  
    
		new."Accepted_scientific_name", matched_taxon_name_with_author);


  		




  135
  134
  
    
	


  		




  ......




  197
  196
  
    
    "Accepted_name_lsid" text,


  		




  198
  197
  
    
    "Accepted_scientific_name" text,


  		




  199
  198
  
    
    "Is_homonym" boolean,


  		




  200
  
  
    
    "Is_plant" boolean,


  		




  201
  199
  
    
    is_valid_match boolean NOT NULL,


  		




  202
  200
  
    
    scrubbed_taxon_name_with_author text


  		




  203
  201
  
    
);


  		












Also available in:  Unified diff