Revision 13579
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/inputs/test_taxonomic_names/_scrub/TNRS.sql | ||
---|---|---|
22 | 22 |
-- Name: SCHEMA "TNRS"; Type: COMMENT; Schema: -; Owner: bien |
23 | 23 |
-- |
24 | 24 |
|
25 |
COMMENT ON SCHEMA "TNRS" IS 'IMPORTANT: when changing this schema, you must also make the same changes on vegbiendev: |
|
25 |
COMMENT ON SCHEMA "TNRS" IS ' |
|
26 |
IMPORTANT: when changing this schema, you must also make the same changes on vegbiendev: |
|
26 | 27 |
on vegbiendev: |
27 | 28 |
# back up existing TNRS schema (in case of an accidental incorrect change): |
28 | 29 |
$ make backups/TNRS.backup-remake # runtime: 3 min ("real 2m44.277s") |
... | ... | |
36 | 37 |
$ rm=1 inputs/.TNRS/schema.sql.run |
37 | 38 |
# repeat until `svn di` shows no diff |
38 | 39 |
# back up new TNRS schema: |
39 |
$ make backups/TNRS.backup-remake # runtime: 3 min ("real 2m44.277s")'; |
|
40 |
$ make backups/TNRS.backup-remake # runtime: 3 min ("real 2m44.277s") |
|
41 |
'; |
|
40 | 42 |
|
41 | 43 |
|
42 | 44 |
SET search_path = "TNRS", pg_catalog; |
... | ... | |
188 | 190 |
ALTER FUNCTION "TNRS".tnrs__batch_begin() OWNER TO bien; |
189 | 191 |
|
190 | 192 |
-- |
193 |
-- Name: tnrs__match_num__fill(); Type: FUNCTION; Schema: TNRS; Owner: bien |
|
194 |
-- |
|
195 |
|
|
196 |
CREATE FUNCTION tnrs__match_num__fill() RETURNS trigger |
|
197 |
LANGUAGE plpgsql |
|
198 |
AS $$ |
|
199 |
BEGIN |
|
200 |
new.match_num = "TNRS".tnrs__match_num__next(); |
|
201 |
RETURN new; |
|
202 |
END; |
|
203 |
$$; |
|
204 |
|
|
205 |
|
|
206 |
ALTER FUNCTION "TNRS".tnrs__match_num__fill() OWNER TO bien; |
|
207 |
|
|
208 |
-- |
|
191 | 209 |
-- Name: tnrs__match_num__next(); Type: FUNCTION; Schema: TNRS; Owner: bien |
192 | 210 |
-- |
193 | 211 |
|
... | ... | |
268 | 286 |
-- Name: FUNCTION tnrs_populate_fields(); Type: COMMENT; Schema: TNRS; Owner: bien |
269 | 287 |
-- |
270 | 288 |
|
271 |
COMMENT ON FUNCTION tnrs_populate_fields() IS 'IMPORTANT: when changing this function, you must regenerate the derived cols: |
|
289 |
COMMENT ON FUNCTION tnrs_populate_fields() IS ' |
|
290 |
IMPORTANT: when changing this function, you must regenerate the derived cols: |
|
272 | 291 |
UPDATE "TNRS".tnrs SET "Name_submitted" = "Name_submitted" |
273 | 292 |
runtime: 30 min ("5564082 rows affected, 1918900 ms execution time") |
274 | 293 |
VACUUM ANALYZE "TNRS".tnrs -- to remove previous rows |
275 |
runtime: 1.5 min ("92633 ms")'; |
|
294 |
runtime: 1.5 min ("92633 ms") |
|
295 |
'; |
|
276 | 296 |
|
277 | 297 |
|
278 | 298 |
SET default_tablespace = ''; |
... | ... | |
333 | 353 |
-- Name: TABLE tnrs; Type: COMMENT; Schema: TNRS; Owner: bien |
334 | 354 |
-- |
335 | 355 |
|
336 |
COMMENT ON TABLE tnrs IS 'IMPORTANT: when changing this table''s schema, you may need to re-run TNRS: |
|
337 |
$ inputs/.TNRS/data.sql.run refresh'; |
|
356 |
COMMENT ON TABLE tnrs IS ' |
|
357 |
to remove columns or add columns at the end: |
|
358 |
$ rm=1 inputs/.TNRS/data.sql.run |
|
359 |
$ make schemas/remake |
|
338 | 360 |
|
361 |
to add columns in the middle: |
|
362 |
make the changes in inputs/.TNRS/schema.sql |
|
363 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS |
|
364 |
$ make schemas/remake |
|
365 |
'; |
|
339 | 366 |
|
367 |
|
|
340 | 368 |
-- |
341 | 369 |
-- Name: MatchedTaxon; Type: VIEW; Schema: TNRS; Owner: bien |
342 | 370 |
-- |
... | ... | |
553 | 581 |
-- Name: TABLE batch_download_settings; Type: COMMENT; Schema: TNRS; Owner: bien |
554 | 582 |
-- |
555 | 583 |
|
556 |
COMMENT ON TABLE batch_download_settings IS 'stores data from http://tnrs.iplantcollaborative.org/TNRSapp.html > Submit List > results section > Download settings > settings.txt'; |
|
584 |
COMMENT ON TABLE batch_download_settings IS ' |
|
585 |
stores data from http://tnrs.iplantcollaborative.org/TNRSapp.html > Submit List > results section > Download settings > settings.txt |
|
586 |
'; |
|
557 | 587 |
|
558 | 588 |
|
559 | 589 |
-- |
... | ... | |
574 | 604 |
-- Name: TABLE client_version; Type: COMMENT; Schema: TNRS; Owner: bien |
575 | 605 |
-- |
576 | 606 |
|
577 |
COMMENT ON TABLE client_version IS 'contains svn revisions'; |
|
607 |
COMMENT ON TABLE client_version IS ' |
|
608 |
contains svn revisions |
|
609 |
'; |
|
578 | 610 |
|
579 | 611 |
|
580 | 612 |
-- |
581 | 613 |
-- Name: COLUMN client_version.global_rev; Type: COMMENT; Schema: TNRS; Owner: bien |
582 | 614 |
-- |
583 | 615 |
|
584 |
COMMENT ON COLUMN client_version.global_rev IS 'from `svn info .` > Last Changed Rev'; |
|
616 |
COMMENT ON COLUMN client_version.global_rev IS ' |
|
617 |
from `svn info .` > Last Changed Rev |
|
618 |
'; |
|
585 | 619 |
|
586 | 620 |
|
587 | 621 |
-- |
588 | 622 |
-- Name: COLUMN client_version."/lib/tnrs.py rev"; Type: COMMENT; Schema: TNRS; Owner: bien |
589 | 623 |
-- |
590 | 624 |
|
591 |
COMMENT ON COLUMN client_version."/lib/tnrs.py rev" IS 'from `svn info lib/tnrs.py` > Last Changed Rev'; |
|
625 |
COMMENT ON COLUMN client_version."/lib/tnrs.py rev" IS ' |
|
626 |
from `svn info lib/tnrs.py` > Last Changed Rev |
|
627 |
'; |
|
592 | 628 |
|
593 | 629 |
|
594 | 630 |
-- |
595 | 631 |
-- Name: COLUMN client_version."/bin/tnrs_db rev"; Type: COMMENT; Schema: TNRS; Owner: bien |
596 | 632 |
-- |
597 | 633 |
|
598 |
COMMENT ON COLUMN client_version."/bin/tnrs_db rev" IS 'from `svn info bin/tnrs_db` > Last Changed Rev'; |
|
634 |
COMMENT ON COLUMN client_version."/bin/tnrs_db rev" IS ' |
|
635 |
from `svn info bin/tnrs_db` > Last Changed Rev |
|
636 |
'; |
|
599 | 637 |
|
600 | 638 |
|
601 | 639 |
-- |
... | ... | |
622 | 660 |
-- Name: VIEW "taxon_scrub.scrubbed_unique_taxon_name.*"; Type: COMMENT; Schema: TNRS; Owner: bien |
623 | 661 |
-- |
624 | 662 |
|
625 |
COMMENT ON VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" IS 'scrubbed_family: Name_matched_accepted_family was missing from the TNRS results at one point, so Family_matched is used as a workaround to populate this. the workaround is for *accepted names only*, as no opinion names do not have an Accepted_name_family to prepend to the scrubbed name to parse.'; |
|
663 |
COMMENT ON VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" IS ' |
|
664 |
scrubbed_family: Name_matched_accepted_family was missing from the TNRS results at one point, so Family_matched is used as a workaround to populate this. the workaround is for *accepted names only*, as no opinion names do not have an Accepted_name_family to prepend to the scrubbed name to parse. |
|
665 |
'; |
|
626 | 666 |
|
627 | 667 |
|
628 | 668 |
-- |
... | ... | |
724 | 764 |
-- |
725 | 765 |
|
726 | 766 |
COPY batch (id, id_by_time, time_submitted, client_version) FROM stdin; |
727 |
2014-05-31 20:04:19.706592-07 2014-05-31 20:04:19.706592-07 2014-05-31 20:04:19.706592-07 \N
|
|
728 |
2014-05-31 20:04:25.799698-07 2014-05-31 20:04:25.799698-07 2014-05-31 20:04:25.799698-07 \N
|
|
767 |
2014-05-31 22:27:09.866404-07 2014-05-31 22:27:09.866404-07 2014-05-31 22:27:09.866404-07 \N
|
|
768 |
2014-05-31 22:27:15.994569-07 2014-05-31 22:27:15.994569-07 2014-05-31 22:27:15.994569-07 \N
|
|
729 | 769 |
\. |
730 | 770 |
|
731 | 771 |
|
... | ... | |
750 | 790 |
-- |
751 | 791 |
|
752 | 792 |
COPY tnrs (batch, match_num, "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", is_valid_match, scrubbed_unique_taxon_name) FROM stdin; |
753 |
2014-05-31 20:04:19.706592-07 \N 0 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 f \N
|
|
754 |
2014-05-31 20:04:19.706592-07 \N 1 Poa annua var. eriolepis 1 Poa annua var. eriolepis var. 1 ̉ۡ.Desv. http://www.theplantlist.org/tpl1.1/record/kew-435206 \N \N \N \N \N Poa 1 annua 1 var. eriolepis 1 \N \N \N \N \N Synonym Poa annua L. species http://www.theplantlist.org/tpl1.1/record/kew-435194 Poa annua Poaceae true tpl \N t Poaceae Poa annua L.
|
|
755 |
2014-05-31 20:04:19.706592-07 \N 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 \N \N \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N 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 \N t Poaceae Poa annua L.
|
|
756 |
2014-05-31 20:04:19.706592-07 \N 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 \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 subsp. http://www.theplantlist.org/tpl1.1/record/tro-6303627 Silene scouleri Caryophyllaceae true tpl [Partial match] \N t Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
757 |
2014-05-31 20:04:19.706592-07 \N 4 Fabaceae Boyle#6500 0.900000000000000022 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 t Fabaceae Lindl.
|
|
758 |
2014-05-31 20:04:19.706592-07 \N 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 \N \N \N \N \N Poa 1 annua 1 subsp. exilis 1 \N \N \N \N \N Synonym Poa infirma Kunth species http://www.theplantlist.org/tpl1.1/record/kew-436189 Poa infirma Poaceae true tpl \N t Poaceae Poa infirma Kunth
|
|
759 |
2014-05-31 20:04:19.706592-07 \N 6 Poa annua ssp. 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 t Poaceae Poa infirma Kunth
|
|
760 |
2014-05-31 20:04:19.706592-07 \N 7 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 t Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.
|
|
761 |
2014-05-31 20:04:19.706592-07 \N 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 \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N 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 \N t Poaceae Poa annua L.
|
|
762 |
2014-05-31 20:04:19.706592-07 \N 9 Compositae indet. sp.1 0.900000000000000022 Compositae family 1 \N http://www.theplantlist.org/1.1/browse/A/Compositae/ \N \N Compositae 1 \N \N \N \N \N \N \N \N \N \N \N \N indet. sp.1 Accepted Compositae \N family http://www.theplantlist.org/1.1/browse/A/Compositae/ \N \N true tpl [Ambiguous match] \N t Compositae
|
|
763 |
2014-05-31 20:04:19.706592-07 \N 10 Poa annua fo. lanuginosa 1 Poa annua fo. lanuginosa fo. 1 Sennen http://www.theplantlist.org/tpl1.1/record/tro-50267771 \N \N \N \N \N Poa 1 annua 1 fo. lanuginosa 1 \N \N \N \N \N Synonym Poa annua L. species http://www.theplantlist.org/tpl1.1/record/kew-435194 Poa annua Poaceae true tpl \N t Poaceae Poa annua L.
|
|
764 |
2014-05-31 20:04:19.706592-07 \N 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 \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 subsp. http://www.theplantlist.org/tpl1.1/record/tro-6303627 Silene scouleri Caryophyllaceae true tpl [Partial match] \N t Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
765 |
2014-05-31 20:04:19.706592-07 \N 12 Fabaceae Inga "fuzzy leaf" 0.900000000000000022 Inga genus 1 \N http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N "fuzzy leaf" Accepted Inga \N genus http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA \N Fabaceae true tpl;usda \N t Fabaceae Inga
|
|
766 |
2014-05-31 20:04:19.706592-07 \N 13 Fabaceae Inga sp.3 0.900000000000000022 Inga genus 1 \N http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N sp.3 Accepted Inga \N genus http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA \N Fabaceae true tpl;usda \N t Fabaceae Inga
|
|
767 |
2014-05-31 20:04:19.706592-07 \N 14 Fabaceae unknown #2 0.900000000000000022 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 t Fabaceae Lindl.
|
|
768 |
2014-05-31 20:04:25.799698-07 \N 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 \N \N \N \N \N \N \N \N 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 \N t Poaceae Poa annua L.
|
|
769 |
2014-05-31 20:04:25.799698-07 \N 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 \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 t Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.
|
|
770 |
2014-05-31 20:04:25.799698-07 \N 2 Compositae 1 Compositae family 1 \N http://www.theplantlist.org/1.1/browse/A/Compositae/ \N \N Compositae 1 \N \N \N \N \N \N \N \N \N \N \N \N \N Accepted Compositae \N family http://www.theplantlist.org/1.1/browse/A/Compositae/ \N \N true tpl [Ambiguous match] \N t Compositae
|
|
771 |
2014-05-31 20:04:25.799698-07 \N 3 Fabaceae Lindl. 0.5 Fabaceae family 0.5 Lindl. http://www.tropicos.org/Name/42000184 \N \N Fabaceae 1 Fabaceae \N \N \N \N \N \N \N \N \N \N \N Lindl. Accepted Fabaceae Lindl. family http://www.tropicos.org/Name/42000184 \N Fabaceae true tropicos [Partial match] \N t Fabaceae Lindl.
|
|
772 |
2014-05-31 20:04:25.799698-07 \N 4 Fabaceae Inga 1 Inga genus 1 \N http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N \N Accepted Inga \N genus http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA \N Fabaceae true tpl;usda \N t Fabaceae Inga
|
|
773 |
2014-05-31 20:04:25.799698-07 \N 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 \N \N \N \N \N 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 \N t Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
774 |
2014-05-31 20:04:25.799698-07 \N 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 \N \N \N \N \N \N \N \N 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 \N t Poaceae Poa infirma Kunth
|
|
793 |
2014-05-31 22:27:09.866404-07 0 0 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 f \N
|
|
794 |
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 \N \N \N \N \N Poa 1 annua 1 var. eriolepis 1 \N \N \N \N \N Synonym Poa annua L. species http://www.theplantlist.org/tpl1.1/record/kew-435194 Poa annua Poaceae true tpl \N t Poaceae Poa annua L.
|
|
795 |
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 \N \N \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N 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 \N t Poaceae Poa annua L.
|
|
796 |
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 \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 subsp. http://www.theplantlist.org/tpl1.1/record/tro-6303627 Silene scouleri Caryophyllaceae true tpl [Partial match] \N t Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
797 |
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 \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 t Fabaceae Lindl.
|
|
798 |
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 \N \N \N \N \N Poa 1 annua 1 subsp. exilis 1 \N \N \N \N \N Synonym Poa infirma Kunth species http://www.theplantlist.org/tpl1.1/record/kew-436189 Poa infirma Poaceae true tpl \N t Poaceae Poa infirma Kunth
|
|
799 |
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 \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 t Poaceae Poa infirma Kunth
|
|
800 |
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 \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 t Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.
|
|
801 |
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 \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N 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 \N t Poaceae Poa annua L.
|
|
802 |
2014-05-31 22:27:09.866404-07 9 9 Compositae indet. sp.1 0.900000000000000022 Compositae family 1 \N http://www.theplantlist.org/1.1/browse/A/Compositae/ \N \N Compositae 1 \N \N \N \N \N \N \N \N \N \N \N \N indet. sp.1 Accepted Compositae \N family http://www.theplantlist.org/1.1/browse/A/Compositae/ \N \N true tpl [Ambiguous match] \N t Compositae
|
|
803 |
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 \N \N \N \N \N Poa 1 annua 1 fo. lanuginosa 1 \N \N \N \N \N Synonym Poa annua L. species http://www.theplantlist.org/tpl1.1/record/kew-435194 Poa annua Poaceae true tpl \N t Poaceae Poa annua L.
|
|
804 |
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 \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 subsp. http://www.theplantlist.org/tpl1.1/record/tro-6303627 Silene scouleri Caryophyllaceae true tpl [Partial match] \N t Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
805 |
2014-05-31 22:27:09.866404-07 12 12 Fabaceae Inga "fuzzy leaf" 0.900000000000000022 Inga genus 1 \N http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N "fuzzy leaf" Accepted Inga \N genus http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA \N Fabaceae true tpl;usda \N t Fabaceae Inga
|
|
806 |
2014-05-31 22:27:09.866404-07 13 13 Fabaceae Inga sp.3 0.900000000000000022 Inga genus 1 \N http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N sp.3 Accepted Inga \N genus http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA \N Fabaceae true tpl;usda \N t Fabaceae Inga
|
|
807 |
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 \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 t Fabaceae Lindl.
|
|
808 |
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 \N \N \N \N \N \N \N \N 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 \N t Poaceae Poa annua L.
|
|
809 |
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 \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 t Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn.
|
|
810 |
2014-05-31 22:27:15.994569-07 2 2 Compositae 1 Compositae family 1 \N http://www.theplantlist.org/1.1/browse/A/Compositae/ \N \N Compositae 1 \N \N \N \N \N \N \N \N \N \N \N \N \N Accepted Compositae \N family http://www.theplantlist.org/1.1/browse/A/Compositae/ \N \N true tpl [Ambiguous match] \N t Compositae
|
|
811 |
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 \N \N Fabaceae 1 Fabaceae \N \N \N \N \N \N \N \N \N \N \N Lindl. Accepted Fabaceae Lindl. family http://www.tropicos.org/Name/42000184 \N Fabaceae true tropicos [Partial match] \N t Fabaceae Lindl.
|
|
812 |
2014-05-31 22:27:15.994569-07 4 4 Fabaceae Inga 1 Inga genus 1 \N http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N \N Accepted Inga \N genus http://www.theplantlist.org/1.1/browse/A/Leguminosae/Inga/;http://plants.usda.gov/java/profile?symbol=INGA \N Fabaceae true tpl;usda \N t Fabaceae Inga
|
|
813 |
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 \N \N \N \N \N 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 \N t Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
814 |
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 \N \N \N \N \N \N \N \N 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 \N t Poaceae Poa infirma Kunth
|
|
775 | 815 |
\. |
776 | 816 |
|
777 | 817 |
|
... | ... | |
896 | 936 |
|
897 | 937 |
|
898 | 938 |
-- |
939 |
-- Name: tnrs__match_num__fill; Type: TRIGGER; Schema: TNRS; Owner: bien |
|
940 |
-- |
|
941 |
|
|
942 |
CREATE TRIGGER tnrs__match_num__fill BEFORE INSERT ON tnrs FOR EACH ROW EXECUTE PROCEDURE tnrs__match_num__fill(); |
|
943 |
|
|
944 |
|
|
945 |
-- |
|
899 | 946 |
-- Name: tnrs_populate_fields; Type: TRIGGER; Schema: TNRS; Owner: bien |
900 | 947 |
-- |
901 | 948 |
|
trunk/inputs/test_taxonomic_names/_scrub/public.test_taxonomic_names.sql | ||
---|---|---|
22 | 22 |
-- Name: SCHEMA "public.test_taxonomic_names"; Type: COMMENT; Schema: -; Owner: bien |
23 | 23 |
-- |
24 | 24 |
|
25 |
COMMENT ON SCHEMA "public.test_taxonomic_names" IS 'Version: public (2014-5-31 20:04:29 PDT)';
|
|
25 |
COMMENT ON SCHEMA "public.test_taxonomic_names" IS 'Version: public (2014-5-31 22:27:20 PDT)';
|
|
26 | 26 |
|
27 | 27 |
|
28 | 28 |
SET search_path = "public.test_taxonomic_names", pg_catalog; |
trunk/inputs/.TNRS/data.sql | ||
---|---|---|
21 | 21 |
-- Data for Name: batch; Type: TABLE DATA; Schema: TNRS; Owner: - |
22 | 22 |
-- |
23 | 23 |
|
24 |
INSERT INTO batch VALUES ('2014-05-31 20:04:19.706592-07', '2014-05-31 20:04:19.706592-07', '2014-05-31 20:04:19.706592-07', NULL);
|
|
25 |
INSERT INTO batch VALUES ('2014-05-31 20:04:25.799698-07', '2014-05-31 20:04:25.799698-07', '2014-05-31 20:04:25.799698-07', NULL);
|
|
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 | 26 |
|
27 | 27 |
|
28 | 28 |
-- |
... | ... | |
35 | 35 |
-- Data for Name: tnrs; Type: TABLE DATA; Schema: TNRS; Owner: - |
36 | 36 |
-- |
37 | 37 |
|
38 |
INSERT INTO tnrs VALUES ('2014-05-31 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:19.706592-07', NULL, 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 20:04:25.799698-07', NULL, 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 20:04:25.799698-07', NULL, 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 20:04:25.799698-07', NULL, 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 20:04:25.799698-07', NULL, 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 20:04:25.799698-07', NULL, 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 20:04:25.799698-07', NULL, 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 20:04:25.799698-07', NULL, 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');
|
|
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 | 60 |
|
61 | 61 |
|
62 | 62 |
-- |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs: populate match_num