Project

General

Profile

Download (13.1 KB) Statistics
| Revision:

root/trunk/inputs/.TNRS/data.sql @ 13580

1 
--
2 
-- PostgreSQL database dump
3 
--
4 

    		
  

  

    
      5
    
    
      
SET statement_timeout = 0;


    		
  

  

    
      6
    
    
      
SET lock_timeout = 0;


    		
  

  

    
      7
    
    
      
SET client_encoding = 'UTF8';


    		
  

  

    
      8
    
    
      
SET standard_conforming_strings = on;


    		
  

  

    
      9
    
    
      
SET check_function_bodies = false;


    		
  

  

    
      10
    
    
      
SET client_min_messages = warning;


    		
  

  

    
      11
    
    
      

    		
  

  

    
      12
    
    
      
SET search_path = "TNRS", pg_catalog;


    		
  

  

    
      13
    
    
      

    		
  

  

    
      14
    
    
      
--


    		
  

  

    
      15
    
    
      
-- Data for Name: client_version; Type: TABLE DATA; Schema: TNRS; Owner: -


    		
  

  

    
      16
    
    
      
--


    		
  

  

    
      17
    
    
      

    		
  

  

    
      18
    
    
      

    		
  

  

    
      19
    
    
      

    		
  

  

    
      20
    
    
      
--


    		
  

  

    
      21
    
    
      
-- Data for Name: batch; Type: TABLE DATA; Schema: TNRS; Owner: -


    		
  

  

    
      22
    
    
      
--


    		
  

  

    
      23
    
    
      

    		
  

  

    
      24
    
    
      
INSERT INTO batch VALUES ('2014-05-31 22:27:09.866404-07', '2014-05-31 22:27:09.866404-07', '2014-05-31 22:27:09.866404-07', NULL);


    		
  

  

    
      25
    
    
      
INSERT INTO batch VALUES ('2014-05-31 22:27:15.994569-07', '2014-05-31 22:27:15.994569-07', '2014-05-31 22:27:15.994569-07', NULL);


    		
  

  

    
      26
    
    
      

    		
  

  

    
      27
    
    
      

    		
  

  

    
      28
    
    
      
--


    		
  

  

    
      29
    
    
      
-- Data for Name: batch_download_settings; Type: TABLE DATA; Schema: TNRS; Owner: -


    		
  

  

    
      30
    
    
      
--


    		
  

  

    
      31
    
    
      

    		
  

  

    
      32
    
    
      

    		
  

  

    
      33
    
    
      

    		
  

  

    
      34
    
    
      
--


    		
  

  

    
      35
    
    
      
-- Data for Name: tnrs; Type: TABLE DATA; Schema: TNRS; Owner: -


    		
  

  

    
      36
    
    
      
--


    		
  

  

    
      37
    
    
      

    		
  

  

    
      38
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-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);


    		
  

  

    
      39
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-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.');


    		
  

  

    
      40
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 2, 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.');


    		
  

  

    
      41
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 3, 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');


    		
  

  

    
      42
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 4, 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.');


    		
  

  

    
      43
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 5, 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');


    		
  

  

    
      44
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 6, 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');


    		
  

  

    
      45
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 7, 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.');


    		
  

  

    
      46
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 8, 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.');


    		
  

  

    
      47
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 9, 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');


    		
  

  

    
      48
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 10, 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.');


    		
  

  

    
      49
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 11, 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');


    		
  

  

    
      50
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 12, 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');


    		
  

  

    
      51
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 13, 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');


    		
  

  

    
      52
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:09.866404-07', 14, 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.');


    		
  

  

    
      53
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:15.994569-07', 0, 0, 'Poaceae 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, 'Poaceae', 1, '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.');


    		
  

  

    
      54
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:15.994569-07', 1, 1, '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, true, 'Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.');


    		
  

  

    
      55
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:15.994569-07', 2, 2, 'Compositae', 1, '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, NULL, 'Accepted', 'Compositae', NULL, 'family', 'http://www.theplantlist.org/1.1/browse/A/Compositae/', NULL, NULL, 'true', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae');


    		
  

  

    
      56
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:15.994569-07', 3, 3, '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, true, 'Fabaceae Lindl.');


    		
  

  

    
      57
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:15.994569-07', 4, 4, 'Fabaceae Inga', 1, '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, NULL, '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');


    		
  

  

    
      58
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:15.994569-07', 5, 5, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 1, 'Silene scouleri subsp. pringlei', 'subsp.', 1, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.theplantlist.org/tpl1.1/record/tro-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', 'subsp.', 'http://www.theplantlist.org/tpl1.1/record/tro-6303627', 'Silene scouleri', 'Caryophyllaceae', 'true', 'tpl', ' ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');


    		
  

  

    
      59
    
    
      
INSERT INTO tnrs VALUES ('2014-05-31 22:27:15.994569-07', 6, 6, 'Poaceae Poa infirma Kunth', 1, 'Poa infirma', 'species', 1, 'Kunth', 'http://www.theplantlist.org/tpl1.1/record/kew-436189;http://www.tropicos.org/Name/25514158;http://plants.usda.gov/java/profile?symbol=POIN30', 'Kunth', 1, 'Poaceae', 1, 'Poaceae', 'Poa', 1, 'infirma', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Accepted', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189;http://www.tropicos.org/Name/25514158;http://plants.usda.gov/java/profile?symbol=POIN30', 'Poa infirma', 'Poaceae', 'true', 'tpl;tropicos;usda', ' ', NULL, true, 'Poaceae Poa infirma Kunth');


    		
  

  

    
      60
    
    
      

    		
  

  

    
      61
    
    
      

    		
  

  

    
      62
    
    
      
--


    		
  

  

    
      63
    
    
      
-- PostgreSQL database dump complete


    		
  

  

    
      64
    
    
      
--


    		
  

  

    
      65
    
    
      

    		
  









  (3-3/10)