Revision 5917
Added by Aaron Marcuse-Kubitza over 11 years ago
TNRS.sql | ||
---|---|---|
85 | 85 |
ALTER TABLE "TNRS".tnrs OWNER TO bien; |
86 | 86 |
|
87 | 87 |
-- |
88 |
-- Name: TABLE tnrs; Type: COMMENT; Schema: TNRS; Owner: bien
|
|
88 |
-- Name: tnrs_accepted; Type: TABLE; Schema: TNRS; Owner: bien; Tablespace:
|
|
89 | 89 |
-- |
90 | 90 |
|
91 |
COMMENT ON TABLE tnrs IS 'tnrs_accepted_names sorts accepted names first (note that false sorts before true). Accepted names are defined as names that scrub to themselves. |
|
91 |
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 |
); |
|
92 | 130 |
|
93 |
Accepted names must be processed before any names that resolve to them, because the entry for the accepted name contains all the ranks parsed out but the resolved name of another entry contains just some ranks and the taxonomic name. Column-based import will do this automatically when the total # of rows is <= the partition_size (because _taxonconcept_set_matched_concept_id()''s accepted taxonconcept is created after the main taxonconcept), but TNRS has more rows than this so sorting is needed to ensure that all the accepted names are processed in the first partitions.'; |
|
94 | 131 |
|
132 |
ALTER TABLE "TNRS".tnrs_accepted OWNER TO bien; |
|
95 | 133 |
|
96 | 134 |
-- |
135 |
-- 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 |
-- |
|
97 | 182 |
-- Data for Name: tnrs; Type: TABLE DATA; Schema: TNRS; Owner: bien |
98 | 183 |
-- |
99 | 184 |
|
100 | 185 |
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; |
101 |
2012-10-26 15:04:15.502163-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 |
|
102 |
2012-10-26 15:04:15.502163-07 8 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 |
|
103 |
2012-10-26 15:04:15.502163-07 9 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 |
|
104 |
2012-10-26 15:04:15.502163-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 |
|
105 |
2012-10-26 15:04:15.502163-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 |
|
106 |
2012-10-26 15:03:59.419728-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 |
|
107 |
2012-10-26 15:04:15.502163-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 |
|
108 |
2012-10-26 15:03:59.419728-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 |
|
109 |
2012-10-26 15:03:59.419728-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 |
|
110 |
2012-10-26 15:03:59.419728-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 |
|
111 |
2012-10-26 15:03:59.419728-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 |
|
112 |
2012-10-26 15:04:15.502163-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 |
|
113 |
2012-10-26 15:04:15.502163-07 6 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 |
|
114 |
2012-10-26 15:03:59.419728-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 |
|
115 |
2012-10-26 15:03:59.419728-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 |
|
116 |
2012-10-26 15:03:59.419728-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 |
|
117 |
2012-10-26 15:03:59.419728-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 |
|
118 |
2012-10-26 15:03:59.419728-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 |
|
119 |
2012-10-26 15:03:59.419728-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 |
|
120 |
2012-10-26 15:03:59.419728-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 |
|
121 |
2012-10-26 15:04:15.502163-07 7 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 |
|
122 |
2012-10-26 15:04:15.502163-07 10 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 |
|
123 |
2012-10-26 15:03:59.419728-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 |
|
124 |
2012-10-26 15:03:59.419728-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 |
|
125 |
2012-10-26 15:03:59.419728-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 |
|
126 |
2012-10-26 15:04:15.502163-07 5 No suitable matches found. 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 |
|
186 |
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 |
|
127 | 211 |
\. |
128 | 212 |
|
129 | 213 |
|
130 | 214 |
-- |
131 |
-- Name: tnrs_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: bien; Tablespace:
|
|
215 |
-- Data for Name: tnrs_accepted; Type: TABLE DATA; Schema: TNRS; Owner: bien
|
|
132 | 216 |
-- |
133 | 217 |
|
134 |
ALTER TABLE ONLY tnrs |
|
135 |
ADD CONSTRAINT tnrs_pkey PRIMARY KEY ("Name_submitted"); |
|
218 |
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 |
\. |
|
136 | 223 |
|
137 | 224 |
|
138 | 225 |
-- |
139 |
-- Name: tnrs_accepted_names; Type: INDEX; Schema: TNRS; Owner: bien; Tablespace:
|
|
226 |
-- Data for Name: tnrs_other; Type: TABLE DATA; Schema: TNRS; Owner: bien
|
|
140 | 227 |
-- |
141 | 228 |
|
142 |
CREATE INDEX tnrs_accepted_names ON tnrs USING btree (((NOT ("Name_submitted" = NULLIF(array_to_string(ARRAY[NULLIF("Accepted_name_family", 'Unknown'::text), "Accepted_name", "Accepted_name_author"], ' '::text), ''::text)))), "Name_submitted"); |
|
229 |
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 |
\. |
|
143 | 252 |
|
144 |
ALTER TABLE tnrs CLUSTER ON tnrs_accepted_names; |
|
145 | 253 |
|
254 |
-- |
|
255 |
-- Name: tnrs_accepted_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: bien; Tablespace: |
|
256 |
-- |
|
146 | 257 |
|
258 |
ALTER TABLE ONLY tnrs_accepted |
|
259 |
ADD CONSTRAINT tnrs_accepted_pkey PRIMARY KEY ("Name_submitted"); |
|
260 |
|
|
261 |
|
|
147 | 262 |
-- |
263 |
-- 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 |
-- |
|
148 | 279 |
-- PostgreSQL database dump complete |
149 | 280 |
-- |
150 | 281 |
|
Also available in: Unified diff
Calls to `make inputs/.TNRS/cleanup`: Do `make inputs/.TNRS/tnrs_accepted/reinstall; make inputs/.TNRS/tnrs_other/reinstall` instead to use new split TNRS tables