1 |
5423
|
aaronmk
|
--
|
2 |
|
|
-- PostgreSQL database dump
|
3 |
|
|
--
|
4 |
|
|
|
5 |
|
|
SET statement_timeout = 0;
|
6 |
|
|
SET client_encoding = 'UTF8';
|
7 |
|
|
SET standard_conforming_strings = off;
|
8 |
|
|
SET check_function_bodies = false;
|
9 |
|
|
SET client_min_messages = warning;
|
10 |
|
|
SET escape_string_warning = off;
|
11 |
|
|
|
12 |
|
|
--
|
13 |
|
|
-- Name: TNRS; Type: SCHEMA; Schema: -; Owner: bien
|
14 |
|
|
--
|
15 |
|
|
|
16 |
|
|
CREATE SCHEMA "TNRS";
|
17 |
|
|
|
18 |
|
|
|
19 |
|
|
ALTER SCHEMA "TNRS" OWNER TO bien;
|
20 |
|
|
|
21 |
|
|
SET search_path = "TNRS", pg_catalog;
|
22 |
|
|
|
23 |
5804
|
aaronmk
|
--
|
24 |
|
|
-- Name: array_to_string(anyarray, text); Type: FUNCTION; Schema: TNRS; Owner: bien
|
25 |
|
|
--
|
26 |
|
|
|
27 |
|
|
CREATE FUNCTION array_to_string(anyarray, text) RETURNS text
|
28 |
|
|
LANGUAGE sql IMMUTABLE STRICT
|
29 |
|
|
AS $_$
|
30 |
|
|
SELECT pg_catalog.array_to_string($1, $2)
|
31 |
|
|
$_$;
|
32 |
|
|
|
33 |
|
|
|
34 |
|
|
ALTER FUNCTION "TNRS".array_to_string(anyarray, text) OWNER TO bien;
|
35 |
|
|
|
36 |
5423
|
aaronmk
|
SET default_tablespace = '';
|
37 |
|
|
|
38 |
|
|
SET default_with_oids = false;
|
39 |
|
|
|
40 |
|
|
--
|
41 |
|
|
-- Name: tnrs; Type: TABLE; Schema: TNRS; Owner: bien; Tablespace:
|
42 |
|
|
--
|
43 |
|
|
|
44 |
|
|
CREATE TABLE tnrs (
|
45 |
5742
|
aaronmk
|
"Time_submitted" timestamp with time zone,
|
46 |
5423
|
aaronmk
|
"Name_number" text,
|
47 |
|
|
"Name_submitted" text NOT NULL,
|
48 |
|
|
"Overall_score" text,
|
49 |
|
|
"Name_matched" text,
|
50 |
|
|
"Name_matched_rank" text,
|
51 |
|
|
"Name_score" text,
|
52 |
|
|
"Name_matched_author" text,
|
53 |
|
|
"Name_matched_url" text,
|
54 |
|
|
"Author_matched" text,
|
55 |
|
|
"Author_score" text,
|
56 |
|
|
"Family_matched" text,
|
57 |
|
|
"Family_score" text,
|
58 |
|
|
"Name_matched_accepted_family" text,
|
59 |
|
|
"Genus_matched" text,
|
60 |
|
|
"Genus_score" text,
|
61 |
|
|
"Specific_epithet_matched" text,
|
62 |
|
|
"Specific_epithet_score" text,
|
63 |
|
|
"Infraspecific_rank" text,
|
64 |
|
|
"Infraspecific_epithet_matched" text,
|
65 |
|
|
"Infraspecific_epithet_score" text,
|
66 |
|
|
"Infraspecific_rank_2" text,
|
67 |
|
|
"Infraspecific_epithet_2_matched" text,
|
68 |
|
|
"Infraspecific_epithet_2_score" text,
|
69 |
|
|
"Annotations" text,
|
70 |
|
|
"Unmatched_terms" text,
|
71 |
|
|
"Taxonomic_status" text,
|
72 |
|
|
"Accepted_name" text,
|
73 |
|
|
"Accepted_name_author" text,
|
74 |
|
|
"Accepted_name_rank" text,
|
75 |
|
|
"Accepted_name_url" text,
|
76 |
|
|
"Accepted_name_species" text,
|
77 |
|
|
"Accepted_name_family" text,
|
78 |
|
|
"Selected" text,
|
79 |
|
|
"Source" text,
|
80 |
|
|
"Warnings" text,
|
81 |
|
|
"Accepted_name_lsid" text
|
82 |
|
|
);
|
83 |
|
|
|
84 |
|
|
|
85 |
|
|
ALTER TABLE "TNRS".tnrs OWNER TO bien;
|
86 |
|
|
|
87 |
|
|
--
|
88 |
5917
|
aaronmk
|
-- Name: tnrs_accepted; Type: TABLE; Schema: TNRS; Owner: bien; Tablespace:
|
89 |
5423
|
aaronmk
|
--
|
90 |
|
|
|
91 |
5917
|
aaronmk
|
CREATE TABLE tnrs_accepted (
|
92 |
|
|
"Time_submitted" timestamp with time zone,
|
93 |
|
|
"Name_number" text,
|
94 |
|
|
"Name_submitted" text NOT NULL,
|
95 |
|
|
"Overall_score" text,
|
96 |
|
|
"Name_matched" text,
|
97 |
|
|
"Name_matched_rank" text,
|
98 |
|
|
"Name_score" text,
|
99 |
|
|
"Name_matched_author" text,
|
100 |
|
|
"Name_matched_url" text,
|
101 |
|
|
"Author_matched" text,
|
102 |
|
|
"Author_score" text,
|
103 |
|
|
"Family_matched" text,
|
104 |
|
|
"Family_score" text,
|
105 |
|
|
"Name_matched_accepted_family" text,
|
106 |
|
|
"Genus_matched" text,
|
107 |
|
|
"Genus_score" text,
|
108 |
|
|
"Specific_epithet_matched" text,
|
109 |
|
|
"Specific_epithet_score" text,
|
110 |
|
|
"Infraspecific_rank" text,
|
111 |
|
|
"Infraspecific_epithet_matched" text,
|
112 |
|
|
"Infraspecific_epithet_score" text,
|
113 |
|
|
"Infraspecific_rank_2" text,
|
114 |
|
|
"Infraspecific_epithet_2_matched" text,
|
115 |
|
|
"Infraspecific_epithet_2_score" text,
|
116 |
|
|
"Annotations" text,
|
117 |
|
|
"Unmatched_terms" text,
|
118 |
|
|
"Taxonomic_status" text,
|
119 |
|
|
"Accepted_name" text,
|
120 |
|
|
"Accepted_name_author" text,
|
121 |
|
|
"Accepted_name_rank" text,
|
122 |
|
|
"Accepted_name_url" text,
|
123 |
|
|
"Accepted_name_species" text,
|
124 |
|
|
"Accepted_name_family" text,
|
125 |
|
|
"Selected" text,
|
126 |
|
|
"Source" text,
|
127 |
|
|
"Warnings" text,
|
128 |
|
|
"Accepted_name_lsid" text
|
129 |
|
|
);
|
130 |
5423
|
aaronmk
|
|
131 |
|
|
|
132 |
5917
|
aaronmk
|
ALTER TABLE "TNRS".tnrs_accepted OWNER TO bien;
|
133 |
5606
|
aaronmk
|
|
134 |
5423
|
aaronmk
|
--
|
135 |
5917
|
aaronmk
|
-- Name: tnrs_other; Type: TABLE; Schema: TNRS; Owner: bien; Tablespace:
|
136 |
|
|
--
|
137 |
|
|
|
138 |
|
|
CREATE TABLE tnrs_other (
|
139 |
|
|
"Time_submitted" timestamp with time zone,
|
140 |
|
|
"Name_number" text,
|
141 |
|
|
"Name_submitted" text NOT NULL,
|
142 |
|
|
"Overall_score" text,
|
143 |
|
|
"Name_matched" text,
|
144 |
|
|
"Name_matched_rank" text,
|
145 |
|
|
"Name_score" text,
|
146 |
|
|
"Name_matched_author" text,
|
147 |
|
|
"Name_matched_url" text,
|
148 |
|
|
"Author_matched" text,
|
149 |
|
|
"Author_score" text,
|
150 |
|
|
"Family_matched" text,
|
151 |
|
|
"Family_score" text,
|
152 |
|
|
"Name_matched_accepted_family" text,
|
153 |
|
|
"Genus_matched" text,
|
154 |
|
|
"Genus_score" text,
|
155 |
|
|
"Specific_epithet_matched" text,
|
156 |
|
|
"Specific_epithet_score" text,
|
157 |
|
|
"Infraspecific_rank" text,
|
158 |
|
|
"Infraspecific_epithet_matched" text,
|
159 |
|
|
"Infraspecific_epithet_score" text,
|
160 |
|
|
"Infraspecific_rank_2" text,
|
161 |
|
|
"Infraspecific_epithet_2_matched" text,
|
162 |
|
|
"Infraspecific_epithet_2_score" text,
|
163 |
|
|
"Annotations" text,
|
164 |
|
|
"Unmatched_terms" text,
|
165 |
|
|
"Taxonomic_status" text,
|
166 |
|
|
"Accepted_name" text,
|
167 |
|
|
"Accepted_name_author" text,
|
168 |
|
|
"Accepted_name_rank" text,
|
169 |
|
|
"Accepted_name_url" text,
|
170 |
|
|
"Accepted_name_species" text,
|
171 |
|
|
"Accepted_name_family" text,
|
172 |
|
|
"Selected" text,
|
173 |
|
|
"Source" text,
|
174 |
|
|
"Warnings" text,
|
175 |
|
|
"Accepted_name_lsid" text
|
176 |
|
|
);
|
177 |
|
|
|
178 |
|
|
|
179 |
|
|
ALTER TABLE "TNRS".tnrs_other OWNER TO bien;
|
180 |
|
|
|
181 |
|
|
--
|
182 |
5423
|
aaronmk
|
-- Data for Name: tnrs; Type: TABLE DATA; Schema: TNRS; Owner: bien
|
183 |
|
|
--
|
184 |
|
|
|
185 |
5742
|
aaronmk
|
COPY tnrs ("Time_submitted", "Name_number", "Name_submitted", "Overall_score", "Name_matched", "Name_matched_rank", "Name_score", "Name_matched_author", "Name_matched_url", "Author_matched", "Author_score", "Family_matched", "Family_score", "Name_matched_accepted_family", "Genus_matched", "Genus_score", "Specific_epithet_matched", "Specific_epithet_score", "Infraspecific_rank", "Infraspecific_epithet_matched", "Infraspecific_epithet_score", "Infraspecific_rank_2", "Infraspecific_epithet_2_matched", "Infraspecific_epithet_2_score", "Annotations", "Unmatched_terms", "Taxonomic_status", "Accepted_name", "Accepted_name_author", "Accepted_name_rank", "Accepted_name_url", "Accepted_name_species", "Accepted_name_family", "Selected", "Source", "Warnings", "Accepted_name_lsid") FROM stdin;
|
186 |
5917
|
aaronmk
|
2012-11-01 05:10:40.128415-07 0 Compositae indet. sp.1 0.9 Compositae family 1 Giseke http://www.tropicos.org/Name/50255940 \N \N Compositae 1 Compositae \N \N \N \N \N \N \N \N \N \N \N indet. sp.1 Synonym Asteraceae Bercht. & J. Presl family http://www.tropicos.org/Name/50307371 \N Asteraceae true tropicos \N
|
187 |
|
|
2012-11-01 05:10:40.128415-07 1 Fabaceae Boyle#6500 0.9 Fabaceae family 1 Lindl. http://www.tropicos.org/Name/42000184 \N \N Fabaceae 1 Fabaceae \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 Accepted Fabaceae Lindl. family http://www.tropicos.org/Name/42000184 \N Fabaceae true tropicos \N
|
188 |
|
|
2012-11-01 05:10:40.128415-07 2 Fabaceae Inga "fuzzy leaf" 0.9 Inga genus 1 Mill. http://www.tropicos.org/Name/40031040 \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N "fuzzy leaf" Accepted Inga Mill. genus http://www.tropicos.org/Name/40031040 \N Fabaceae true tropicos \N
|
189 |
|
|
2012-11-01 05:10:40.128415-07 3 Fabaceae Inga sp.3 0.9 Inga genus 1 Mill. http://www.tropicos.org/Name/40031040 \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N sp.3 Accepted Inga Mill. genus http://www.tropicos.org/Name/40031040 \N Fabaceae true tropicos \N
|
190 |
|
|
2012-11-01 05:10:40.128415-07 4 Fabaceae unknown #2 0.9 Fabaceae family 1 Lindl. http://www.tropicos.org/Name/42000184 \N \N Fabaceae 1 Fabaceae \N \N \N \N \N \N \N \N \N \N \N unknown #2 Accepted Fabaceae Lindl. family http://www.tropicos.org/Name/42000184 \N Fabaceae true tropicos \N
|
191 |
|
|
2012-11-01 05:10:40.128415-07 5 Fam_indet. Boyle#6501 0 No suitable matches found. \N 0 \N \N \N 0 \N 0 \N \N 0 \N 0 \N \N 0 \N \N 0 \N \N \N \N \N \N \N \N \N true \N \N
|
192 |
|
|
2012-11-01 05:10:40.128415-07 6 Poa annua 1 Poa annua species 1 L. http://www.tropicos.org/Name/25509881 \N \N \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N Accepted Poa annua L. species http://www.tropicos.org/Name/25509881 Poa annua Poaceae true tropicos \N
|
193 |
|
|
2012-11-01 05:10:40.128415-07 7 Poa annua L. 1 Poa annua species 1 L. http://www.tropicos.org/Name/25509881 L. 1 \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N Accepted Poa annua L. species http://www.tropicos.org/Name/25509881 Poa annua Poaceae true tropicos \N
|
194 |
|
|
2012-11-01 05:10:40.128415-07 8 Poa annua fo. lanuginosa 1 Poa annua fo. lanuginosa forma 1 Sennen http://www.tropicos.org/Name/50267771 \N \N \N \N Poaceae Poa 1 annua 1 fo. lanuginosa 1 \N \N \N \N \N Synonym Poa annua var. annua \N variety http://www.tropicos.org/Name/25517736 Poa annua Poaceae true tropicos \N
|
195 |
|
|
2012-11-01 05:10:40.128415-07 9 Poa annua ssp. exilis 0.4 Poa genus 0.4 L. http://www.tropicos.org/Name/40012319 \N \N \N \N Poaceae Poa 1 \N \N \N \N \N \N \N \N \N annua ssp. exilis Accepted Poa L. genus http://www.tropicos.org/Name/40012319 \N Poaceae true tropicos [Partial match] \N
|
196 |
|
|
2012-11-01 05:10:40.128415-07 10 Poa annua subsp. exilis 1 Poa annua subsp. exilis subspecies 1 (Tomm. ex Freyn) Asch. & Graebn. http://www.tropicos.org/Name/50063800 \N \N \N \N Poaceae Poa 1 annua 1 subsp. exilis 1 \N \N \N \N \N Synonym Poa infirma Kunth species http://www.tropicos.org/Name/25514158 Poa infirma Poaceae true tropicos \N
|
197 |
|
|
2012-11-01 05:10:40.128415-07 11 Poa annua subvar. minima 1 Poa annua subvar. minima subvariety 1 (Schur) Asch. & Graebn. http://www.tropicos.org/Name/50158097 \N \N \N \N Poaceae Poa 1 annua 1 subvar. minima 1 \N \N \N \N \N Accepted Poa annua subvar. minima (Schur) Asch. & Graebn. subvariety http://www.tropicos.org/Name/50158097 Poa annua Poaceae true tropicos \N
|
198 |
|
|
2012-11-01 05:10:40.128415-07 12 Poa annua var. eriolepis 1 Poa annua var. eriolepis variety 1 E. Desv. http://www.tropicos.org/Name/50119145 \N \N \N \N Poaceae Poa 1 annua 1 var. eriolepis 1 \N \N \N \N \N Synonym Poa annua L. species http://www.tropicos.org/Name/25509881 Poa annua Poaceae true tropicos \N
|
199 |
|
|
2012-11-01 05:10:40.128415-07 13 Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire 0.77 Silene scouleri subsp. pringlei subspecies 0.77 (S. Watson) C.L. Hitchc. & Maguire http://www.tropicos.org/Name/6303627 \N \N \N \N Caryophyllaceae Silene 1 scouleri 1 subsp. pringlei 1 \N \N \N \N 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] \N
|
200 |
|
|
2012-11-01 05:10:40.128415-07 14 Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire 0.77 Silene scouleri subsp. pringlei subspecies 0.77 (S. Watson) C.L. Hitchc. & Maguire http://www.tropicos.org/Name/6303627 \N \N \N \N Caryophyllaceae Silene 1 scouleri 1 subsp. pringlei 1 \N \N \N \N 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] \N
|
201 |
|
|
2012-11-01 05:10:55.49172-07 0 Asteraceae Asteraceae Bercht. & J. Presl 0.4 Asteraceae family 0.5 Bercht. & J. Presl http://www.tropicos.org/Name/50307371 \N \N Asteraceae 1 Asteraceae \N \N \N \N \N \N \N \N \N \N \N Asteraceae Bercht. & J. Presl Accepted Asteraceae Bercht. & J. Presl family http://www.tropicos.org/Name/50307371 \N Asteraceae true tropicos [Partial match] \N
|
202 |
|
|
2012-11-01 05:10:55.49172-07 1 Caryophyllaceae 1 Caryophyllaceae family 1 Juss. http://www.tropicos.org/Name/42000077 \N \N Caryophyllaceae 1 Caryophyllaceae \N \N \N \N \N \N \N \N \N \N \N \N Accepted Caryophyllaceae Juss. family http://www.tropicos.org/Name/42000077 \N Caryophyllaceae true tropicos \N
|
203 |
|
|
2012-11-01 05:10:55.49172-07 2 Compositae 1 Compositae family 1 Giseke http://www.tropicos.org/Name/50255940 \N \N Compositae 1 Compositae \N \N \N \N \N \N \N \N \N \N \N \N Synonym Asteraceae Bercht. & J. Presl family http://www.tropicos.org/Name/50307371 \N Asteraceae true tropicos \N
|
204 |
|
|
2012-11-01 05:10:55.49172-07 3 Fabaceae 1 Fabaceae family 1 Lindl. http://www.tropicos.org/Name/42000184 \N \N Fabaceae 1 Fabaceae \N \N \N \N \N \N \N \N \N \N \N \N Accepted Fabaceae Lindl. family http://www.tropicos.org/Name/42000184 \N Fabaceae true tropicos \N
|
205 |
|
|
2012-11-01 05:10:55.49172-07 4 Inga 1 Inga genus 1 Mill. http://www.tropicos.org/Name/40031040 \N \N \N \N Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N \N Accepted Inga Mill. genus http://www.tropicos.org/Name/40031040 \N Fabaceae true tropicos \N
|
206 |
|
|
2012-11-01 05:10:55.49172-07 5 Poa 1 Poa genus 1 L. http://www.tropicos.org/Name/40012319 \N \N \N \N Poaceae Poa 1 \N \N \N \N \N \N \N \N \N \N Accepted Poa L. genus http://www.tropicos.org/Name/40012319 \N Poaceae true tropicos \N
|
207 |
|
|
2012-11-01 05:10:55.49172-07 6 Poaceae 1 Poaceae family 1 Barnhart http://www.tropicos.org/Name/42000357 \N \N Poaceae 1 Poaceae \N \N \N \N \N \N \N \N \N \N \N \N Accepted Poaceae Barnhart family http://www.tropicos.org/Name/42000357 \N Poaceae true tropicos \N
|
208 |
|
|
2012-11-01 05:10:55.49172-07 7 Poaceae Poa annua var. annua 1 Poa annua var. annua variety 1 \N http://www.tropicos.org/Name/25517736 \N \N Poaceae 1 Poaceae Poa 1 annua 1 var. annua 1 \N \N \N \N \N Accepted Poa annua var. annua \N variety http://www.tropicos.org/Name/25517736 Poa annua Poaceae true tropicos \N
|
209 |
|
|
2012-11-01 05:10:55.49172-07 8 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 \N \N \N \N \N \N \N \N Accepted Poa infirma Kunth species http://www.tropicos.org/Name/25514158 Poa infirma Poaceae true tropicos \N
|
210 |
|
|
2012-11-01 05:10:55.49172-07 9 Silene 1 Silene genus 1 L. http://www.tropicos.org/Name/40000236 \N \N \N \N Caryophyllaceae Silene 1 \N \N \N \N \N \N \N \N \N \N Accepted Silene L. genus http://www.tropicos.org/Name/40000236 \N Caryophyllaceae true tropicos \N
|
211 |
5423
|
aaronmk
|
\.
|
212 |
|
|
|
213 |
|
|
|
214 |
|
|
--
|
215 |
5917
|
aaronmk
|
-- Data for Name: tnrs_accepted; Type: TABLE DATA; Schema: TNRS; Owner: bien
|
216 |
5423
|
aaronmk
|
--
|
217 |
|
|
|
218 |
5917
|
aaronmk
|
COPY tnrs_accepted ("Time_submitted", "Name_number", "Name_submitted", "Overall_score", "Name_matched", "Name_matched_rank", "Name_score", "Name_matched_author", "Name_matched_url", "Author_matched", "Author_score", "Family_matched", "Family_score", "Name_matched_accepted_family", "Genus_matched", "Genus_score", "Specific_epithet_matched", "Specific_epithet_score", "Infraspecific_rank", "Infraspecific_epithet_matched", "Infraspecific_epithet_score", "Infraspecific_rank_2", "Infraspecific_epithet_2_matched", "Infraspecific_epithet_2_score", "Annotations", "Unmatched_terms", "Taxonomic_status", "Accepted_name", "Accepted_name_author", "Accepted_name_rank", "Accepted_name_url", "Accepted_name_species", "Accepted_name_family", "Selected", "Source", "Warnings", "Accepted_name_lsid") FROM stdin;
|
219 |
|
|
2012-11-01 05:10:55.49172-07 0 Asteraceae Asteraceae Bercht. & J. Presl 0.4 Asteraceae family 0.5 Bercht. & J. Presl http://www.tropicos.org/Name/50307371 \N \N Asteraceae 1 Asteraceae \N \N \N \N \N \N \N \N \N \N \N Asteraceae Bercht. & J. Presl Accepted Asteraceae Bercht. & J. Presl family http://www.tropicos.org/Name/50307371 \N Asteraceae true tropicos [Partial match] \N
|
220 |
|
|
2012-11-01 05:10:55.49172-07 7 Poaceae Poa annua var. annua 1 Poa annua var. annua variety 1 \N http://www.tropicos.org/Name/25517736 \N \N Poaceae 1 Poaceae Poa 1 annua 1 var. annua 1 \N \N \N \N \N Accepted Poa annua var. annua \N variety http://www.tropicos.org/Name/25517736 Poa annua Poaceae true tropicos \N \N
|
221 |
|
|
2012-11-01 05:10:55.49172-07 8 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 \N \N \N \N \N \N \N \N Accepted Poa infirma Kunth species http://www.tropicos.org/Name/25514158 Poa infirma Poaceae true tropicos \N \N
|
222 |
|
|
\.
|
223 |
5423
|
aaronmk
|
|
224 |
|
|
|
225 |
|
|
--
|
226 |
5917
|
aaronmk
|
-- Data for Name: tnrs_other; Type: TABLE DATA; Schema: TNRS; Owner: bien
|
227 |
5423
|
aaronmk
|
--
|
228 |
|
|
|
229 |
5917
|
aaronmk
|
COPY tnrs_other ("Time_submitted", "Name_number", "Name_submitted", "Overall_score", "Name_matched", "Name_matched_rank", "Name_score", "Name_matched_author", "Name_matched_url", "Author_matched", "Author_score", "Family_matched", "Family_score", "Name_matched_accepted_family", "Genus_matched", "Genus_score", "Specific_epithet_matched", "Specific_epithet_score", "Infraspecific_rank", "Infraspecific_epithet_matched", "Infraspecific_epithet_score", "Infraspecific_rank_2", "Infraspecific_epithet_2_matched", "Infraspecific_epithet_2_score", "Annotations", "Unmatched_terms", "Taxonomic_status", "Accepted_name", "Accepted_name_author", "Accepted_name_rank", "Accepted_name_url", "Accepted_name_species", "Accepted_name_family", "Selected", "Source", "Warnings", "Accepted_name_lsid") FROM stdin;
|
230 |
|
|
2012-11-01 05:10:55.49172-07 1 Caryophyllaceae 1 Caryophyllaceae family 1 Juss. http://www.tropicos.org/Name/42000077 \N \N Caryophyllaceae 1 Caryophyllaceae \N \N \N \N \N \N \N \N \N \N \N \N Accepted Caryophyllaceae Juss. family http://www.tropicos.org/Name/42000077 \N Caryophyllaceae true tropicos \N \N
|
231 |
|
|
2012-11-01 05:10:55.49172-07 2 Compositae 1 Compositae family 1 Giseke http://www.tropicos.org/Name/50255940 \N \N Compositae 1 Compositae \N \N \N \N \N \N \N \N \N \N \N \N Synonym Asteraceae Bercht. & J. Presl family http://www.tropicos.org/Name/50307371 \N Asteraceae true tropicos \N \N
|
232 |
|
|
2012-11-01 05:10:40.128415-07 0 Compositae indet. sp.1 0.9 Compositae family 1 Giseke http://www.tropicos.org/Name/50255940 \N \N Compositae 1 Compositae \N \N \N \N \N \N \N \N \N \N \N indet. sp.1 Synonym Asteraceae Bercht. & J. Presl family http://www.tropicos.org/Name/50307371 \N Asteraceae true tropicos \N \N
|
233 |
|
|
2012-11-01 05:10:55.49172-07 3 Fabaceae 1 Fabaceae family 1 Lindl. http://www.tropicos.org/Name/42000184 \N \N Fabaceae 1 Fabaceae \N \N \N \N \N \N \N \N \N \N \N \N Accepted Fabaceae Lindl. family http://www.tropicos.org/Name/42000184 \N Fabaceae true tropicos \N \N
|
234 |
|
|
2012-11-01 05:10:40.128415-07 1 Fabaceae Boyle#6500 0.9 Fabaceae family 1 Lindl. http://www.tropicos.org/Name/42000184 \N \N Fabaceae 1 Fabaceae \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 Accepted Fabaceae Lindl. family http://www.tropicos.org/Name/42000184 \N Fabaceae true tropicos \N \N
|
235 |
|
|
2012-11-01 05:10:40.128415-07 2 Fabaceae Inga "fuzzy leaf" 0.9 Inga genus 1 Mill. http://www.tropicos.org/Name/40031040 \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N "fuzzy leaf" Accepted Inga Mill. genus http://www.tropicos.org/Name/40031040 \N Fabaceae true tropicos \N \N
|
236 |
|
|
2012-11-01 05:10:40.128415-07 3 Fabaceae Inga sp.3 0.9 Inga genus 1 Mill. http://www.tropicos.org/Name/40031040 \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N sp.3 Accepted Inga Mill. genus http://www.tropicos.org/Name/40031040 \N Fabaceae true tropicos \N \N
|
237 |
|
|
2012-11-01 05:10:40.128415-07 4 Fabaceae unknown #2 0.9 Fabaceae family 1 Lindl. http://www.tropicos.org/Name/42000184 \N \N Fabaceae 1 Fabaceae \N \N \N \N \N \N \N \N \N \N \N unknown #2 Accepted Fabaceae Lindl. family http://www.tropicos.org/Name/42000184 \N Fabaceae true tropicos \N \N
|
238 |
|
|
2012-11-01 05:10:55.49172-07 4 Inga 1 Inga genus 1 Mill. http://www.tropicos.org/Name/40031040 \N \N \N \N Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N \N Accepted Inga Mill. genus http://www.tropicos.org/Name/40031040 \N Fabaceae true tropicos \N \N
|
239 |
|
|
2012-11-01 05:10:55.49172-07 5 Poa 1 Poa genus 1 L. http://www.tropicos.org/Name/40012319 \N \N \N \N Poaceae Poa 1 \N \N \N \N \N \N \N \N \N \N Accepted Poa L. genus http://www.tropicos.org/Name/40012319 \N Poaceae true tropicos \N \N
|
240 |
|
|
2012-11-01 05:10:40.128415-07 6 Poa annua 1 Poa annua species 1 L. http://www.tropicos.org/Name/25509881 \N \N \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N Accepted Poa annua L. species http://www.tropicos.org/Name/25509881 Poa annua Poaceae true tropicos \N \N
|
241 |
|
|
2012-11-01 05:10:40.128415-07 7 Poa annua L. 1 Poa annua species 1 L. http://www.tropicos.org/Name/25509881 L. 1 \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N Accepted Poa annua L. species http://www.tropicos.org/Name/25509881 Poa annua Poaceae true tropicos \N \N
|
242 |
|
|
2012-11-01 05:10:40.128415-07 8 Poa annua fo. lanuginosa 1 Poa annua fo. lanuginosa forma 1 Sennen http://www.tropicos.org/Name/50267771 \N \N \N \N Poaceae Poa 1 annua 1 fo. lanuginosa 1 \N \N \N \N \N Synonym Poa annua var. annua \N variety http://www.tropicos.org/Name/25517736 Poa annua Poaceae true tropicos \N \N
|
243 |
|
|
2012-11-01 05:10:40.128415-07 9 Poa annua ssp. exilis 0.4 Poa genus 0.4 L. http://www.tropicos.org/Name/40012319 \N \N \N \N Poaceae Poa 1 \N \N \N \N \N \N \N \N \N annua ssp. exilis Accepted Poa L. genus http://www.tropicos.org/Name/40012319 \N Poaceae true tropicos [Partial match] \N
|
244 |
|
|
2012-11-01 05:10:40.128415-07 10 Poa annua subsp. exilis 1 Poa annua subsp. exilis subspecies 1 (Tomm. ex Freyn) Asch. & Graebn. http://www.tropicos.org/Name/50063800 \N \N \N \N Poaceae Poa 1 annua 1 subsp. exilis 1 \N \N \N \N \N Synonym Poa infirma Kunth species http://www.tropicos.org/Name/25514158 Poa infirma Poaceae true tropicos \N \N
|
245 |
|
|
2012-11-01 05:10:40.128415-07 11 Poa annua subvar. minima 1 Poa annua subvar. minima subvariety 1 (Schur) Asch. & Graebn. http://www.tropicos.org/Name/50158097 \N \N \N \N Poaceae Poa 1 annua 1 subvar. minima 1 \N \N \N \N \N Accepted Poa annua subvar. minima (Schur) Asch. & Graebn. subvariety http://www.tropicos.org/Name/50158097 Poa annua Poaceae true tropicos \N \N
|
246 |
|
|
2012-11-01 05:10:40.128415-07 12 Poa annua var. eriolepis 1 Poa annua var. eriolepis variety 1 E. Desv. http://www.tropicos.org/Name/50119145 \N \N \N \N Poaceae Poa 1 annua 1 var. eriolepis 1 \N \N \N \N \N Synonym Poa annua L. species http://www.tropicos.org/Name/25509881 Poa annua Poaceae true tropicos \N \N
|
247 |
|
|
2012-11-01 05:10:55.49172-07 6 Poaceae 1 Poaceae family 1 Barnhart http://www.tropicos.org/Name/42000357 \N \N Poaceae 1 Poaceae \N \N \N \N \N \N \N \N \N \N \N \N Accepted Poaceae Barnhart family http://www.tropicos.org/Name/42000357 \N Poaceae true tropicos \N \N
|
248 |
|
|
2012-11-01 05:10:55.49172-07 9 Silene 1 Silene genus 1 L. http://www.tropicos.org/Name/40000236 \N \N \N \N Caryophyllaceae Silene 1 \N \N \N \N \N \N \N \N \N \N Accepted Silene L. genus http://www.tropicos.org/Name/40000236 \N Caryophyllaceae true tropicos \N \N
|
249 |
|
|
2012-11-01 05:10:40.128415-07 13 Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire 0.77 Silene scouleri subsp. pringlei subspecies 0.77 (S. Watson) C.L. Hitchc. & Maguire http://www.tropicos.org/Name/6303627 \N \N \N \N Caryophyllaceae Silene 1 scouleri 1 subsp. pringlei 1 \N \N \N \N 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] \N
|
250 |
|
|
2012-11-01 05:10:40.128415-07 14 Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire 0.77 Silene scouleri subsp. pringlei subspecies 0.77 (S. Watson) C.L. Hitchc. & Maguire http://www.tropicos.org/Name/6303627 \N \N \N \N Caryophyllaceae Silene 1 scouleri 1 subsp. pringlei 1 \N \N \N \N 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] \N
|
251 |
|
|
\.
|
252 |
5423
|
aaronmk
|
|
253 |
|
|
|
254 |
5917
|
aaronmk
|
--
|
255 |
|
|
-- Name: tnrs_accepted_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: bien; Tablespace:
|
256 |
|
|
--
|
257 |
5423
|
aaronmk
|
|
258 |
5917
|
aaronmk
|
ALTER TABLE ONLY tnrs_accepted
|
259 |
|
|
ADD CONSTRAINT tnrs_accepted_pkey PRIMARY KEY ("Name_submitted");
|
260 |
|
|
|
261 |
|
|
|
262 |
5423
|
aaronmk
|
--
|
263 |
5917
|
aaronmk
|
-- Name: tnrs_other_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: bien; Tablespace:
|
264 |
|
|
--
|
265 |
|
|
|
266 |
|
|
ALTER TABLE ONLY tnrs_other
|
267 |
|
|
ADD CONSTRAINT tnrs_other_pkey PRIMARY KEY ("Name_submitted");
|
268 |
|
|
|
269 |
|
|
|
270 |
|
|
--
|
271 |
|
|
-- Name: tnrs_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: bien; Tablespace:
|
272 |
|
|
--
|
273 |
|
|
|
274 |
|
|
ALTER TABLE ONLY tnrs
|
275 |
|
|
ADD CONSTRAINT tnrs_pkey PRIMARY KEY ("Name_submitted");
|
276 |
|
|
|
277 |
|
|
|
278 |
|
|
--
|
279 |
5423
|
aaronmk
|
-- PostgreSQL database dump complete
|
280 |
|
|
--
|