Revision 14328
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/test_taxonomic_names/_scrub/TNRS.sql | ||
|---|---|---|
| 214 | 214 |
new."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" = NULL; |
| 215 | 215 |
new."[matched_]scientificName[_with_author]__@DwC__@vegpath.org" = NULL; |
| 216 | 216 |
new.matched_has_accepted = NULL; |
| 217 |
new."Accepted_family__@TNRS__@vegpath.org" = NULL; |
|
| 217 | 218 |
new."__accepted_{genus,specific_epithet}" = NULL;
|
| 218 | 219 |
new."[accepted_]genus__@DwC__@vegpath.org" = NULL; |
| 219 | 220 |
new."[accepted_]specificEpithet__@DwC__@vegpath.org" = NULL; |
| ... | ... | |
| 233 | 234 |
new."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" = NULL; |
| 234 | 235 |
new."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" = NULL; |
| 235 | 236 |
new."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" = NULL; |
| 236 |
new."Accepted_family__@TNRS__@vegpath.org" = NULL; |
|
| 237 |
new."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" = NULL; |
|
| 238 |
new."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = NULL; |
|
| 237 | 239 |
|
| 238 | 240 |
-- populate derived cols |
| 239 | 241 |
new."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" = (SELECT "*Unmatched_terms" FROM (SELECT new.*) new); |
| 240 | 242 |
new."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT ("*Genus_matched" || ' '::text) || "*Specific_epithet_matched" FROM (SELECT new.*) new);
|
| 241 | 243 |
new."[matched_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT "*Name_matched" || COALESCE((' '::text || "*Name_matched_author"), ''::text) FROM (SELECT new.*) new);
|
| 242 | 244 |
new.matched_has_accepted = (SELECT "*Accepted_name" IS NOT NULL FROM (SELECT new.*) new); |
| 245 |
new."Accepted_family__@TNRS__@vegpath.org" = (SELECT COALESCE("*Accepted_name_family",
|
|
| 246 |
CASE |
|
| 247 |
WHEN ("*Accepted_name_rank" = 'family'::text) THEN "*Accepted_name"
|
|
| 248 |
ELSE NULL::text |
|
| 249 |
END) FROM (SELECT new.*) new); |
|
| 243 | 250 |
new."__accepted_{genus,specific_epithet}" = (SELECT regexp_split_to_array("*Accepted_name_species", ' '::text) FROM (SELECT new.*) new);
|
| 244 |
new."[accepted_]genus__@DwC__@vegpath.org" = (SELECT "__accepted_{genus,specific_epithet}"[1] FROM (SELECT new.*) new);
|
|
| 251 |
new."[accepted_]genus__@DwC__@vegpath.org" = (SELECT COALESCE("__accepted_{genus,specific_epithet}"[1],
|
|
| 252 |
CASE |
|
| 253 |
WHEN ("*Accepted_name_rank" = 'genus'::text) THEN "*Accepted_name"
|
|
| 254 |
ELSE NULL::text |
|
| 255 |
END) FROM (SELECT new.*) new); |
|
| 245 | 256 |
new."[accepted_]specificEpithet__@DwC__@vegpath.org" = (SELECT "__accepted_{genus,specific_epithet}"[2] FROM (SELECT new.*) new);
|
| 246 | 257 |
new."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = (SELECT CASE |
| 247 |
WHEN ("*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 248 |
WHEN ("*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 258 |
WHEN ("*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, "Accepted_family__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 259 |
WHEN ("*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, "[accepted_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 249 | 260 |
ELSE "*Accepted_name_species" |
| 250 | 261 |
END FROM (SELECT new.*) new); |
| 251 | 262 |
new.__accepted_infraspecific_label = (SELECT ltrim(NULLIF(util.remove_prefix("*Accepted_name_species", "*Accepted_name", require := true), ''::text), ' '::text) FROM (SELECT new.*) new);
|
| ... | ... | |
| 258 | 269 |
ELSE "*Name_matched_rank" |
| 259 | 270 |
END FROM (SELECT new.*) new); |
| 260 | 271 |
new."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" = (SELECT CASE |
| 261 |
WHEN matched_has_accepted THEN "*Accepted_name_family"
|
|
| 272 |
WHEN matched_has_accepted THEN "Accepted_family__@TNRS__@vegpath.org"
|
|
| 262 | 273 |
ELSE "*Name_matched_accepted_family" |
| 263 | 274 |
END FROM (SELECT new.*) new); |
| 264 | 275 |
new."[scrubbed_]genus__@DwC__@vegpath.org" = (SELECT CASE |
| ... | ... | |
| 293 | 304 |
WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" |
| 294 | 305 |
ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org" |
| 295 | 306 |
END FROM (SELECT new.*) new); |
| 296 |
new."Accepted_family__@TNRS__@vegpath.org" = (SELECT COALESCE("*Accepted_name_family",
|
|
| 297 |
CASE |
|
| 298 |
WHEN ("*Accepted_name_rank" = 'family'::text) THEN "*Accepted_name"
|
|
| 299 |
ELSE NULL::text |
|
| 300 |
END) FROM (SELECT new.*) new); |
|
| 307 |
new."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" = (SELECT "TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name") FROM (SELECT new.*) new);
|
|
| 308 |
new."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = (SELECT CASE |
|
| 309 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = 'family'::text) THEN concat_ws(' '::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 310 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = 'genus'::text) THEN concat_ws(' '::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 311 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 312 |
END FROM (SELECT new.*) new); |
|
| 301 | 313 |
|
| 302 | 314 |
RETURN new; |
| 303 | 315 |
END; |
| ... | ... | |
| 455 | 467 |
"[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" text, |
| 456 | 468 |
"[accepted_]infraspecificEpithet__@DwC__@vegpath.org" text, |
| 457 | 469 |
"[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" text, |
| 470 |
"[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" text, |
|
| 458 | 471 |
"[scrubbed_]taxonRank__@DwC__@vegpath.org" text, |
| 459 | 472 |
"[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| 460 | 473 |
"[scrubbed_]genus__@DwC__@vegpath.org" text, |
| 461 | 474 |
"[scrubbed_]specificEpithet__@DwC__@vegpath.org" text, |
| 462 | 475 |
"[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| 476 |
"[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" text, |
|
| 463 | 477 |
"[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" text, |
| 464 | 478 |
"[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" text, |
| 465 | 479 |
"[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| ... | ... | |
| 471 | 485 |
ELSE NULL::text |
| 472 | 486 |
END)))), |
| 473 | 487 |
CONSTRAINT "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" CHECK ((NOT ("[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[1]))),
|
| 474 |
CONSTRAINT "[accepted_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]genus__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet}"[1]))),
|
|
| 488 |
CONSTRAINT "[accepted_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]genus__@DwC__@vegpath.org" IS DISTINCT FROM COALESCE("__accepted_{genus,specific_epithet}"[1],
|
|
| 489 |
CASE |
|
| 490 |
WHEN ("*Accepted_name_rank" = 'genus'::text) THEN "*Accepted_name"
|
|
| 491 |
ELSE NULL::text |
|
| 492 |
END)))), |
|
| 475 | 493 |
CONSTRAINT "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]infraspecificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[2]))),
|
| 476 | 494 |
CONSTRAINT "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" CHECK ((NOT ("[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS DISTINCT FROM
|
| 477 | 495 |
CASE |
| 478 |
WHEN ("*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 479 |
WHEN ("*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 496 |
WHEN ("*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, "Accepted_family__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 497 |
WHEN ("*Accepted_name_rank" = 'genus'::text) THEN concat_ws(' '::text, "[accepted_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 480 | 498 |
ELSE "*Accepted_name_species" |
| 481 | 499 |
END))), |
| 482 | 500 |
CONSTRAINT "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" IS DISTINCT FROM ("*Accepted_name" || COALESCE((' '::text || "*Accepted_name_author"), ''::text))))),
|
| ... | ... | |
| 496 | 514 |
END))), |
| 497 | 515 |
CONSTRAINT "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM
|
| 498 | 516 |
CASE |
| 499 |
WHEN matched_has_accepted THEN "*Accepted_name_family"
|
|
| 517 |
WHEN matched_has_accepted THEN "Accepted_family__@TNRS__@vegpath.org"
|
|
| 500 | 518 |
ELSE "*Name_matched_accepted_family" |
| 501 | 519 |
END))), |
| 502 | 520 |
CONSTRAINT "[scrubbed_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]genus__@DwC__@vegpath.org" IS DISTINCT FROM
|
| ... | ... | |
| 509 | 527 |
WHEN matched_has_accepted THEN "[accepted_]specificEpithet__@DwC__@vegpath.org" |
| 510 | 528 |
ELSE "*Infraspecific_epithet_matched" |
| 511 | 529 |
END))), |
| 530 |
CONSTRAINT "[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" CHECK ((NOT ("[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS DISTINCT FROM
|
|
| 531 |
CASE |
|
| 532 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = 'family'::text) THEN concat_ws(' '::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 533 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = 'genus'::text) THEN concat_ws(' '::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 534 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 535 |
END))), |
|
| 512 | 536 |
CONSTRAINT "[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" CHECK ((NOT ("[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" IS DISTINCT FROM
|
| 513 | 537 |
CASE |
| 514 | 538 |
WHEN matched_has_accepted THEN "*Accepted_name" |
| ... | ... | |
| 534 | 558 |
WHEN matched_has_accepted THEN "*Accepted_name_rank" |
| 535 | 559 |
ELSE "*Name_matched_rank" |
| 536 | 560 |
END))), |
| 561 |
CONSTRAINT "[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" CHECK ((NOT ("[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" IS DISTINCT FROM map_taxonomic_status("*Taxonomic_status", "*Accepted_name")))),
|
|
| 537 | 562 |
CONSTRAINT __accepted_infraspecific_label CHECK ((NOT (__accepted_infraspecific_label IS DISTINCT FROM ltrim(NULLIF(util.remove_prefix("*Accepted_name_species", "*Accepted_name", require := true), ''::text), ' '::text)))),
|
| 538 | 563 |
CONSTRAINT "__accepted_infraspecific_{rank,epithet}" CHECK ((NOT ("__accepted_infraspecific_{rank,epithet}" IS DISTINCT FROM regexp_split_to_array(__accepted_infraspecific_label, ' '::text)))),
|
| 539 | 564 |
CONSTRAINT "__accepted_{genus,specific_epithet}" CHECK ((NOT ("__accepted_{genus,specific_epithet}" IS DISTINCT FROM regexp_split_to_array("*Accepted_name_species", ' '::text)))),
|
| ... | ... | |
| 660 | 685 |
|
| 661 | 686 |
COMMENT ON COLUMN taxon_match."Accepted_family__@TNRS__@vegpath.org" IS ' |
| 662 | 687 |
= COALESCE("*Accepted_name_family",
|
| 663 |
CASE
|
|
| 664 |
WHEN ("*Accepted_name_rank" = ''family''::text) THEN "*Accepted_name"
|
|
| 665 |
ELSE NULL::text
|
|
| 666 |
END)
|
|
| 688 |
CASE |
|
| 689 |
WHEN ("*Accepted_name_rank" = ''family''::text) THEN "*Accepted_name"
|
|
| 690 |
ELSE NULL::text |
|
| 691 |
END) |
|
| 667 | 692 |
|
| 668 | 693 |
derived column |
| 669 | 694 |
|
| 670 | 695 |
to modify expr: |
| 671 | 696 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''Accepted_family__@TNRS__@vegpath.org'')::util.col, $$COALESCE("*Accepted_name_family",
|
| 672 |
CASE
|
|
| 673 |
WHEN ("*Accepted_name_rank" = ''family''::text) THEN "*Accepted_name"
|
|
| 674 |
ELSE NULL::text
|
|
| 675 |
END)$$)::util.derived_col_def);
|
|
| 697 |
CASE |
|
| 698 |
WHEN ("*Accepted_name_rank" = ''family''::text) THEN "*Accepted_name"
|
|
| 699 |
ELSE NULL::text |
|
| 700 |
END)$$)::util.derived_col_def); |
|
| 676 | 701 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
| 677 | 702 |
|
| 678 | 703 |
to rename: |
| ... | ... | |
| 707 | 732 |
-- |
| 708 | 733 |
|
| 709 | 734 |
COMMENT ON COLUMN taxon_match."[accepted_]genus__@DwC__@vegpath.org" IS ' |
| 710 |
= "__accepted_{genus,specific_epithet}"[1]
|
|
| 735 |
= COALESCE("__accepted_{genus,specific_epithet}"[1],
|
|
| 736 |
CASE |
|
| 737 |
WHEN ("*Accepted_name_rank" = ''genus''::text) THEN "*Accepted_name"
|
|
| 738 |
ELSE NULL::text |
|
| 739 |
END) |
|
| 711 | 740 |
|
| 712 | 741 |
derived column |
| 713 | 742 |
|
| 714 | 743 |
to modify expr: |
| 715 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]genus__@DwC__@vegpath.org'')::util.col, $$"__accepted_{genus,specific_epithet}"[1]$$)::util.derived_col_def);
|
|
| 744 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]genus__@DwC__@vegpath.org'')::util.col, $$COALESCE("__accepted_{genus,specific_epithet}"[1],
|
|
| 745 |
CASE |
|
| 746 |
WHEN ("*Accepted_name_rank" = ''genus''::text) THEN "*Accepted_name"
|
|
| 747 |
ELSE NULL::text |
|
| 748 |
END)$$)::util.derived_col_def); |
|
| 716 | 749 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
| 717 | 750 |
|
| 718 | 751 |
to rename: |
| ... | ... | |
| 748 | 781 |
|
| 749 | 782 |
COMMENT ON COLUMN taxon_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS ' |
| 750 | 783 |
= CASE |
| 751 |
WHEN ("*Accepted_name_rank" = ''family''::text) THEN concat_ws('' ''::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 752 |
WHEN ("*Accepted_name_rank" = ''genus''::text) THEN concat_ws('' ''::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 784 |
WHEN ("*Accepted_name_rank" = ''family''::text) THEN concat_ws('' ''::text, "Accepted_family__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 785 |
WHEN ("*Accepted_name_rank" = ''genus''::text) THEN concat_ws('' ''::text, "[accepted_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 753 | 786 |
ELSE "*Accepted_name_species" |
| 754 | 787 |
END |
| 755 | 788 |
|
| ... | ... | |
| 757 | 790 |
|
| 758 | 791 |
to modify expr: |
| 759 | 792 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col, $$CASE
|
| 760 |
WHEN ("*Accepted_name_rank" = ''family''::text) THEN concat_ws('' ''::text, "*Accepted_name_family", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 761 |
WHEN ("*Accepted_name_rank" = ''genus''::text) THEN concat_ws('' ''::text, "*Accepted_name", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 793 |
WHEN ("*Accepted_name_rank" = ''family''::text) THEN concat_ws('' ''::text, "Accepted_family__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 794 |
WHEN ("*Accepted_name_rank" = ''genus''::text) THEN concat_ws('' ''::text, "[accepted_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 762 | 795 |
ELSE "*Accepted_name_species" |
| 763 | 796 |
END$$)::util.derived_col_def); |
| 764 | 797 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
| ... | ... | |
| 871 | 904 |
|
| 872 | 905 |
|
| 873 | 906 |
-- |
| 907 |
-- Name: COLUMN taxon_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien |
|
| 908 |
-- |
|
| 909 |
|
|
| 910 |
COMMENT ON COLUMN taxon_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" IS ' |
|
| 911 |
= "TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name")
|
|
| 912 |
|
|
| 913 |
derived column |
|
| 914 |
|
|
| 915 |
to modify expr: |
|
| 916 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]taxonomicStatus__@DwC__@vegpath.org'')::util.col, $$"TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name")$$)::util.derived_col_def);
|
|
| 917 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
|
| 918 |
|
|
| 919 |
to rename: |
|
| 920 |
# rename column |
|
| 921 |
# rename CHECK constraint |
|
| 922 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 923 |
'; |
|
| 924 |
|
|
| 925 |
|
|
| 926 |
-- |
|
| 874 | 927 |
-- Name: COLUMN taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien |
| 875 | 928 |
-- |
| 876 | 929 |
|
| ... | ... | |
| 902 | 955 |
|
| 903 | 956 |
COMMENT ON COLUMN taxon_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" IS ' |
| 904 | 957 |
= CASE |
| 905 |
WHEN matched_has_accepted THEN "*Accepted_name_family"
|
|
| 958 |
WHEN matched_has_accepted THEN "Accepted_family__@TNRS__@vegpath.org"
|
|
| 906 | 959 |
ELSE "*Name_matched_accepted_family" |
| 907 | 960 |
END |
| 908 | 961 |
|
| ... | ... | |
| 910 | 963 |
|
| 911 | 964 |
to modify expr: |
| 912 | 965 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org'')::util.col, $$CASE
|
| 913 |
WHEN matched_has_accepted THEN "*Accepted_name_family"
|
|
| 966 |
WHEN matched_has_accepted THEN "Accepted_family__@TNRS__@vegpath.org"
|
|
| 914 | 967 |
ELSE "*Name_matched_accepted_family" |
| 915 | 968 |
END$$)::util.derived_col_def); |
| 916 | 969 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
| ... | ... | |
| 1001 | 1054 |
|
| 1002 | 1055 |
|
| 1003 | 1056 |
-- |
| 1057 |
-- Name: COLUMN taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien |
|
| 1058 |
-- |
|
| 1059 |
|
|
| 1060 |
COMMENT ON COLUMN taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS ' |
|
| 1061 |
= CASE |
|
| 1062 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''family''::text) THEN concat_ws('' ''::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 1063 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''genus''::text) THEN concat_ws('' ''::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 1064 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 1065 |
END |
|
| 1066 |
|
|
| 1067 |
derived column |
|
| 1068 |
|
|
| 1069 |
to modify expr: |
|
| 1070 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col, $$CASE
|
|
| 1071 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''family''::text) THEN concat_ws('' ''::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 1072 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''genus''::text) THEN concat_ws('' ''::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 1073 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 1074 |
END$$)::util.derived_col_def); |
|
| 1075 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
|
| 1076 |
|
|
| 1077 |
to rename: |
|
| 1078 |
# rename column |
|
| 1079 |
# rename CHECK constraint |
|
| 1080 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 1081 |
'; |
|
| 1082 |
|
|
| 1083 |
|
|
| 1084 |
-- |
|
| 1004 | 1085 |
-- Name: COLUMN taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: bien |
| 1005 | 1086 |
-- |
| 1006 | 1087 |
|
| ... | ... | |
| 1769 | 1850 |
-- |
| 1770 | 1851 |
|
| 1771 | 1852 |
COPY batch (id, id_by_time, time_submitted, client_version) FROM stdin; |
| 1772 |
2014-07-22 04:06:20.378232-07 2014-07-22 04:06:20.378232-07 2014-07-22 04:06:20.378232-07 \N
|
|
| 1853 |
2014-07-22 06:48:16.289953-07 2014-07-22 06:48:16.289953-07 2014-07-22 06:48:16.289953-07 \N
|
|
| 1773 | 1854 |
\. |
| 1774 | 1855 |
|
| 1775 | 1856 |
|
| ... | ... | |
| 1793 | 1874 |
-- Data for Name: taxon_match; Type: TABLE DATA; Schema: TNRS; Owner: bien |
| 1794 | 1875 |
-- |
| 1795 | 1876 |
|
| 1796 |
COPY taxon_match (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, "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org", "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", "[matched_]scientificName[_with_author]__@DwC__@vegpath.org", matched_has_accepted, "Accepted_family__@TNRS__@vegpath.org", "__accepted_{genus,specific_epithet}", "[accepted_]genus__@DwC__@vegpath.org", "[accepted_]specificEpithet__@DwC__@vegpath.org", "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org", __accepted_infraspecific_label, "__accepted_infraspecific_{rank,epithet}", "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", "[accepted_]infraspecificEpithet__@DwC__@vegpath.org", "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org", "[scrubbed_]taxonRank__@DwC__@vegpath.org", "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[scrubbed_]genus__@DwC__@vegpath.org", "[scrubbed_]specificEpithet__@DwC__@vegpath.org", "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org", "[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", "[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", "[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", "[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", "[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org") FROM stdin;
|
|
| 1797 |
2014-07-22 04:06:20.378232-07 0 0 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 indet. sp.1 \N Compositae t Compositae \N \N \N indet. sp.1 \N \N \N \N Compositae family \N \N \N \N \N \N Compositae \N Compositae
|
|
| 1798 |
2014-07-22 04:06:20.378232-07 1 0 Compositae indet. sp.1 0.900000000000000022 Compositae family 1 \N \N \N \N Compositae 1 \N \N \N \N \N \N \N \N \N \N \N \N indet. sp.1 Accepted Compositae \N family \N \N \N false tpl [Ambiguous match] \N t Compositae indet. sp.1 \N Compositae t Compositae \N \N \N indet. sp.1 \N \N \N \N Compositae family \N \N \N \N \N \N Compositae \N Compositae
|
|
| 1799 |
2014-07-22 04:06:20.378232-07 2 0 Compositae indet. sp.1 0.900000000000000022 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 false tropicos \N t Asteraceae Bercht. & J. Presl indet. sp.1 \N Compositae Giseke t Asteraceae \N \N \N Asteraceae indet. sp.1 \N \N \N \N Asteraceae Bercht. & J. Presl family Asteraceae \N \N \N \N \N Asteraceae Bercht. & J. Presl Asteraceae Bercht. & J. Presl
|
|
| 1800 |
2014-07-22 04:06:20.378232-07 3 1 Fabaceae Boyle#6500 0.839999999999999969 Fagaceae family 0.939999999999999947 \N ;http://plants.usda.gov/java/nameSearch \N \N Fagaceae 0.880000000000000004 \N \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 Accepted Fagaceae \N family ;http://plants.usda.gov/java/nameSearch \N \N true tpl;usda \N f Fagaceae Boyle#6500 \N Fagaceae t Fagaceae \N \N \N Boyle#6500 \N \N \N \N Fagaceae family \N \N \N \N \N \N Fagaceae \N Fagaceae
|
|
| 1801 |
2014-07-22 04:06:20.378232-07 4 1 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 false tropicos \N t Fabaceae Lindl. Boyle#6500 \N Fabaceae Lindl. t Fabaceae \N \N \N Fabaceae Boyle#6500 \N \N \N \N Fabaceae Lindl. family Fabaceae \N \N \N \N \N Fabaceae Lindl. Fabaceae Lindl.
|
|
| 1802 |
2014-07-22 04:06:20.378232-07 5 1 Fabaceae Boyle#6500 0.839999999999999969 Fagaceae family 0.939999999999999947 Dumort. http://www.tropicos.org/Name/42000062 \N \N Fagaceae 0.880000000000000004 Fagaceae \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 Accepted Fagaceae Dumort. family http://www.tropicos.org/Name/42000062 \N Fagaceae false tropicos \N f Fagaceae Dumort. Boyle#6500 \N Fagaceae Dumort. t Fagaceae \N \N \N Fagaceae Boyle#6500 \N \N \N \N Fagaceae Dumort. family Fagaceae \N \N \N \N \N Fagaceae Dumort. Fagaceae Dumort.
|
|
| 1803 |
2014-07-22 04:06:20.378232-07 6 1 Fabaceae Boyle#6500 0.67000000000000004 Ficaceae family 0.770000000000000018 Bercht. & J. Presl http://www.tropicos.org/Name/100353631 \N \N Ficaceae 0.75 Ficaceae \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 No opinion \N \N \N \N \N \N false tropicos \N f Ficaceae Bercht. & J. Presl Boyle#6500 \N Ficaceae Bercht. & J. Presl f \N \N \N \N \N \N \N \N \N \N family Ficaceae \N \N \N \N \N Ficaceae Bercht. & J. Presl Ficaceae Bercht. & J. Presl
|
|
| 1804 |
2014-07-22 04:06:20.378232-07 7 1 Fabaceae Boyle#6500 0.67000000000000004 Fucaceae family 0.770000000000000018 \N http://www.tropicos.org/Name/100371040 \N \N Fucaceae 0.75 Fucaceae \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 No opinion \N \N \N \N \N \N false tropicos \N f Fucaceae Boyle#6500 \N Fucaceae f \N \N \N \N \N \N \N \N \N \N family Fucaceae \N \N \N \N \N Fucaceae \N Fucaceae
|
|
| 1805 |
2014-07-22 04:06:20.378232-07 8 1 Fabaceae Boyle#6500 0.900000000000000022 Fabaceae family 1 \N http://plants.usda.gov/java/nameSearch \N \N Fabaceae 1 \N \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 Accepted Fabaceae \N family http://plants.usda.gov/java/nameSearch \N \N false usda \N t Fabaceae Boyle#6500 \N Fabaceae t Fabaceae \N \N \N Boyle#6500 \N \N \N \N Fabaceae family \N \N \N \N \N \N Fabaceae \N Fabaceae
|
|
| 1806 |
2014-07-22 04:06:20.378232-07 9 2 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 "fuzzy leaf" \N Inga t Fabaceae \N \N \N Inga "fuzzy leaf" \N \N \N \N Inga genus Fabaceae \N \N \N \N \N Inga \N Inga
|
|
| 1807 |
2014-07-22 04:06:20.378232-07 10 2 Fabaceae Inga "fuzzy leaf" 0.900000000000000022 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 false tropicos \N t Fabaceae Inga Mill. "fuzzy leaf" \N Inga Mill. t Fabaceae \N \N \N Inga "fuzzy leaf" \N \N \N \N Inga Mill. genus Fabaceae \N \N \N \N \N Inga Mill. Inga Mill.
|
|
| 1808 |
2014-07-22 04:06:20.378232-07 11 2 Fabaceae Inga "fuzzy leaf" 0.900000000000000022 Inga genus 1 Scop. http://www.tropicos.org/Name/50215121 \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N "fuzzy leaf" Illegitimate \N \N \N \N \N \N false tropicos \N t Fabaceae Inga Scop. "fuzzy leaf" \N Inga Scop. f \N \N \N \N \N \N \N \N \N \N genus Fabaceae Inga \N \N \N \N Inga Scop. Inga Scop.
|
|
| 1809 |
2014-07-22 04:06:20.378232-07 12 3 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 sp.3 \N Inga t Fabaceae \N \N \N Inga sp.3 \N \N \N \N Inga genus Fabaceae \N \N \N \N \N Inga \N Inga
|
|
| 1810 |
2014-07-22 04:06:20.378232-07 13 3 Fabaceae Inga sp.3 0.900000000000000022 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 false tropicos \N t Fabaceae Inga Mill. sp.3 \N Inga Mill. t Fabaceae \N \N \N Inga sp.3 \N \N \N \N Inga Mill. genus Fabaceae \N \N \N \N \N Inga Mill. Inga Mill.
|
|
| 1811 |
2014-07-22 04:06:20.378232-07 14 3 Fabaceae Inga sp.3 0.900000000000000022 Inga genus 1 Scop. http://www.tropicos.org/Name/50215121 \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N sp.3 Illegitimate \N \N \N \N \N \N false tropicos \N t Fabaceae Inga Scop. sp.3 \N Inga Scop. f \N \N \N \N \N \N \N \N \N \N genus Fabaceae Inga \N \N \N \N Inga Scop. Inga Scop.
|
|
| 1812 |
2014-07-22 04:06:20.378232-07 15 4 Fabaceae unknown #2 0.839999999999999969 Fagaceae family 0.939999999999999947 \N ;http://plants.usda.gov/java/nameSearch \N \N Fagaceae 0.880000000000000004 \N \N \N \N \N \N \N \N \N \N \N \N unknown #2 Accepted Fagaceae \N family ;http://plants.usda.gov/java/nameSearch \N \N true tpl;usda \N f Fagaceae unknown #2 \N Fagaceae t Fagaceae \N \N \N unknown #2 \N \N \N \N Fagaceae family \N \N \N \N \N \N Fagaceae \N Fagaceae
|
|
| 1813 |
2014-07-22 04:06:20.378232-07 16 4 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 false tropicos \N t Fabaceae Lindl. unknown #2 \N Fabaceae Lindl. t Fabaceae \N \N \N Fabaceae unknown #2 \N \N \N \N Fabaceae Lindl. family Fabaceae \N \N \N \N \N Fabaceae Lindl. Fabaceae Lindl.
|
|
| 1814 |
2014-07-22 04:06:20.378232-07 17 4 Fabaceae unknown #2 0.839999999999999969 Fagaceae family 0.939999999999999947 Dumort. http://www.tropicos.org/Name/42000062 \N \N Fagaceae 0.880000000000000004 Fagaceae \N \N \N \N \N \N \N \N \N \N \N unknown #2 Accepted Fagaceae Dumort. family http://www.tropicos.org/Name/42000062 \N Fagaceae false tropicos \N f Fagaceae Dumort. unknown #2 \N Fagaceae Dumort. t Fagaceae \N \N \N Fagaceae unknown #2 \N \N \N \N Fagaceae Dumort. family Fagaceae \N \N \N \N \N Fagaceae Dumort. Fagaceae Dumort.
|
|
| 1815 |
2014-07-22 04:06:20.378232-07 18 4 Fabaceae unknown #2 0.67000000000000004 Ficaceae family 0.770000000000000018 Bercht. & J. Presl http://www.tropicos.org/Name/100353631 \N \N Ficaceae 0.75 Ficaceae \N \N \N \N \N \N \N \N \N \N \N unknown #2 No opinion \N \N \N \N \N \N false tropicos \N f Ficaceae Bercht. & J. Presl unknown #2 \N Ficaceae Bercht. & J. Presl f \N \N \N \N \N \N \N \N \N \N family Ficaceae \N \N \N \N \N Ficaceae Bercht. & J. Presl Ficaceae Bercht. & J. Presl
|
|
| 1816 |
2014-07-22 04:06:20.378232-07 19 4 Fabaceae unknown #2 0.67000000000000004 Fucaceae family 0.770000000000000018 \N http://www.tropicos.org/Name/100371040 \N \N Fucaceae 0.75 Fucaceae \N \N \N \N \N \N \N \N \N \N \N unknown #2 No opinion \N \N \N \N \N \N false tropicos \N f Fucaceae unknown #2 \N Fucaceae f \N \N \N \N \N \N \N \N \N \N family Fucaceae \N \N \N \N \N Fucaceae \N Fucaceae
|
|
| 1817 |
2014-07-22 04:06:20.378232-07 20 4 Fabaceae unknown #2 0.900000000000000022 Fabaceae family 1 \N http://plants.usda.gov/java/nameSearch \N \N Fabaceae 1 \N \N \N \N \N \N \N \N \N \N \N \N unknown #2 Accepted Fabaceae \N family http://plants.usda.gov/java/nameSearch \N \N false usda \N t Fabaceae unknown #2 \N Fabaceae t Fabaceae \N \N \N unknown #2 \N \N \N \N Fabaceae family \N \N \N \N \N \N Fabaceae \N Fabaceae
|
|
| 1818 |
2014-07-22 04:06:20.378232-07 21 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 f \N \N \N No suitable matches found. f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N No suitable matches found. \N No suitable matches found.
|
|
| 1819 |
2014-07-22 04:06:20.378232-07 22 6 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. \N Poa annua Poa annua L. t Poaceae {Poa,annua} Poa annua Poa annua \N \N \N \N Poa annua L. species Poaceae Poa annua Poa annua \N annua Poa annua L. Poa annua L.
|
|
| 1820 |
2014-07-22 04:06:20.378232-07 23 6 Poa annua 1 Poa annua species 1 Cham. & Schltdl. http://www.theplantlist.org/tpl1.1/record/kew-435195 \N \N \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N Synonym Poa infirma Kunth species http://www.theplantlist.org/tpl1.1/record/kew-436189 Poa infirma Poaceae false tpl \N t Poaceae Poa infirma Kunth \N Poa annua Poa annua Cham. & Schltdl. t Poaceae {Poa,infirma} Poa infirma Poa infirma \N \N \N \N Poa infirma Kunth species Poaceae Poa infirma Poa infirma \N infirma Poa infirma Kunth Poa infirma Kunth
|
|
| 1821 |
2014-07-22 04:06:20.378232-07 24 7 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. \N Poa annua Poa annua L. t Poaceae {Poa,annua} Poa annua Poa annua \N \N \N \N Poa annua L. species Poaceae Poa annua Poa annua \N annua Poa annua L. Poa annua L.
|
|
| 1822 |
2014-07-22 04:06:20.378232-07 25 7 Poa annua L. 0.800000000000000044 Poa annua species 1 Cham. & Schltdl. http://www.theplantlist.org/tpl1.1/record/kew-435195 Cham. & Schltdl. 0 \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N Synonym Poa infirma Kunth species http://www.theplantlist.org/tpl1.1/record/kew-436189 Poa infirma Poaceae false tpl \N t Poaceae Poa infirma Kunth \N Poa annua Poa annua Cham. & Schltdl. t Poaceae {Poa,infirma} Poa infirma Poa infirma \N \N \N \N Poa infirma Kunth species Poaceae Poa infirma Poa infirma \N infirma Poa infirma Kunth Poa infirma Kunth
|
|
| 1823 |
2014-07-22 04:06:20.378232-07 26 8 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. \N Poa annua Poa annua fo. lanuginosa Sennen t Poaceae {Poa,annua} Poa annua Poa annua \N \N \N \N Poa annua L. species Poaceae Poa annua Poa annua \N annua Poa annua L. Poa annua L.
|
|
| 1824 |
2014-07-22 04:06:20.378232-07 27 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 false tropicos \N t Poaceae Poa annua var. annua \N Poa annua Poa annua fo. lanuginosa Sennen t Poaceae {Poa,annua} Poa annua Poa annua var. annua {var.,annua} var. annua Poa annua var. annua variety Poaceae Poa annua Poa annua var. annua Poa annua var. annua \N Poa annua var. annua
|
|
| 1825 |
2014-07-22 04:06:20.378232-07 28 9 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 \N Poa annua Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn. t Poaceae {Poa,infirma} Poa infirma Poa infirma \N \N \N \N Poa infirma Kunth species Poaceae Poa infirma Poa infirma \N infirma Poa infirma Kunth Poa infirma Kunth
|
|
| 1826 |
2014-07-22 04:06:20.378232-07 29 9 Poa annua ssp. exilis 0.959999999999999964 Poa annua var. exilis variety 0.959999999999999964 Tomm. ex Freyn http://www.tropicos.org/Name/25547854 \N \N \N \N Poaceae Poa 1 annua 1 var. exilis 0.699999999999999956 \N \N \N \N \N Synonym Poa infirma Kunth species http://www.tropicos.org/Name/25514158 Poa infirma Poaceae false tropicos \N t Poaceae Poa infirma Kunth \N Poa annua Poa annua var. exilis Tomm. ex Freyn t Poaceae {Poa,infirma} Poa infirma Poa infirma \N \N \N \N Poa infirma Kunth species Poaceae Poa infirma Poa infirma \N infirma Poa infirma Kunth Poa infirma Kunth
|
|
| 1827 |
2014-07-22 04:06:20.378232-07 30 10 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 \N Poa annua Poa annua subsp. exilis (Tomm. ex Freyn.) Asch. & Graebn. t Poaceae {Poa,infirma} Poa infirma Poa infirma \N \N \N \N Poa infirma Kunth species Poaceae Poa infirma Poa infirma \N infirma Poa infirma Kunth Poa infirma Kunth
|
|
| 1828 |
2014-07-22 04:06:20.378232-07 31 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 false tropicos \N t Poaceae Poa infirma Kunth \N Poa annua Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn. t Poaceae {Poa,infirma} Poa infirma Poa infirma \N \N \N \N Poa infirma Kunth species Poaceae Poa infirma Poa infirma \N infirma Poa infirma Kunth Poa infirma Kunth
|
|
| 1829 |
2014-07-22 04:06:20.378232-07 32 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 t Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn. \N Poa annua Poa annua subvar. minima (Schur) Asch. & Graebn. t Poaceae {Poa,annua} Poa annua Poa annua subvar. minima {subvar.,minima} subvar. minima Poa annua subvar. minima (Schur) Asch. & Graebn. subvariety Poaceae Poa annua Poa annua subvar. annua Poa annua subvar. minima (Schur) Asch. & Graebn. Poa annua subvar. minima (Schur) Asch. & Graebn.
|
|
| 1830 |
2014-07-22 04:06:20.378232-07 33 12 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. \N Poa annua Poa annua var. eriolepis ̉ۡ.Desv. t Poaceae {Poa,annua} Poa annua Poa annua \N \N \N \N Poa annua L. species Poaceae Poa annua Poa annua \N annua Poa annua L. Poa annua L.
|
|
| 1831 |
2014-07-22 04:06:20.378232-07 34 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 false tropicos \N t Poaceae Poa annua L. \N Poa annua Poa annua var. eriolepis E. Desv. t Poaceae {Poa,annua} Poa annua Poa annua \N \N \N \N Poa annua L. species Poaceae Poa annua Poa annua \N annua Poa annua L. Poa annua L.
|
|
| 1832 |
2014-07-22 04:06:20.378232-07 35 13 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 var. grisea Silene scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire t Caryophyllaceae {Silene,scouleri} Silene scouleri Silene scouleri subsp. pringlei {subsp.,pringlei} subsp. pringlei Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire subsp. Caryophyllaceae Silene scouleri Silene scouleri subsp. scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
| 1833 |
2014-07-22 04:06:20.378232-07 36 13 Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire 0.770000000000000018 Silene scouleri subsp. pringlei subspecies 0.770000000000000018 (S. Watson) C.L. Hitchc. & Maguire http://www.tropicos.org/Name/6303627 \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 false tropicos [Partial match] \N t Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea Silene scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire t Caryophyllaceae {Silene,scouleri} Silene scouleri Silene scouleri subsp. pringlei {subsp.,pringlei} subsp. pringlei Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire subspecies Caryophyllaceae Silene scouleri Silene scouleri subsp. scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
| 1834 |
2014-07-22 04:06:20.378232-07 37 13 Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire 0.770000000000000018 Silene scouleri subsp. pringlei subspecies 0.770000000000000018 (S. Watson) C.L. Hitchc. & Maguire http://plants.usda.gov/java/profile?symbol=SISCP \N \N \N \N Caryophyllaceae Silene 1 scouleri 1 subsp. pringlei 1 \N \N \N \N var. grisea Accepted Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire subspecies http://plants.usda.gov/java/profile?symbol=SISCP Silene scouleri Caryophyllaceae false usda [Partial match] \N t Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea Silene scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire t Caryophyllaceae {Silene,scouleri} Silene scouleri Silene scouleri ssp. pringlei {ssp.,pringlei} ssp. pringlei Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire subspecies Caryophyllaceae Silene scouleri Silene scouleri ssp. scouleri Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
| 1835 |
2014-07-22 04:06:20.378232-07 38 14 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 var. grisea Silene scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire t Caryophyllaceae {Silene,scouleri} Silene scouleri Silene scouleri subsp. pringlei {subsp.,pringlei} subsp. pringlei Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire subsp. Caryophyllaceae Silene scouleri Silene scouleri subsp. scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
| 1836 |
2014-07-22 04:06:20.378232-07 39 14 Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire 0.770000000000000018 Silene scouleri subsp. pringlei subspecies 0.770000000000000018 (S. Watson) C.L. Hitchc. & Maguire http://www.tropicos.org/Name/6303627 \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 false tropicos [Partial match] \N t Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea Silene scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire t Caryophyllaceae {Silene,scouleri} Silene scouleri Silene scouleri subsp. pringlei {subsp.,pringlei} subsp. pringlei Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire subspecies Caryophyllaceae Silene scouleri Silene scouleri subsp. scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
| 1837 |
2014-07-22 04:06:20.378232-07 40 14 Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire 0.770000000000000018 Silene scouleri subsp. pringlei subspecies 0.770000000000000018 (S. Watson) C.L. Hitchc. & Maguire http://plants.usda.gov/java/profile?symbol=SISCP \N \N \N \N Caryophyllaceae Silene 1 scouleri 1 subsp. pringlei 1 \N \N \N \N var. grisea Accepted Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire subspecies http://plants.usda.gov/java/profile?symbol=SISCP Silene scouleri Caryophyllaceae false usda [Partial match] \N t Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea Silene scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire t Caryophyllaceae {Silene,scouleri} Silene scouleri Silene scouleri ssp. pringlei {ssp.,pringlei} ssp. pringlei Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire subspecies Caryophyllaceae Silene scouleri Silene scouleri ssp. scouleri Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
| 1877 |
COPY taxon_match (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, "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org", "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", "[matched_]scientificName[_with_author]__@DwC__@vegpath.org", matched_has_accepted, "Accepted_family__@TNRS__@vegpath.org", "__accepted_{genus,specific_epithet}", "[accepted_]genus__@DwC__@vegpath.org", "[accepted_]specificEpithet__@DwC__@vegpath.org", "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org", __accepted_infraspecific_label, "__accepted_infraspecific_{rank,epithet}", "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", "[accepted_]infraspecificEpithet__@DwC__@vegpath.org", "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org", "[scrubbed_]taxonomicStatus__@DwC__@vegpath.org", "[scrubbed_]taxonRank__@DwC__@vegpath.org", "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[scrubbed_]genus__@DwC__@vegpath.org", "[scrubbed_]specificEpithet__@DwC__@vegpath.org", "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org", "[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org", "[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", "[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", "[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", "[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", "[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org") FROM stdin;
|
|
| 1878 |
2014-07-22 06:48:16.289953-07 0 0 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 indet. sp.1 \N Compositae t Compositae \N \N \N Compositae indet. sp.1 \N \N \N \N Compositae accepted family Compositae \N \N \N Compositae indet. sp.1 \N \N Compositae \N Compositae
|
|
| 1879 |
2014-07-22 06:48:16.289953-07 1 0 Compositae indet. sp.1 0.900000000000000022 Compositae family 1 \N \N \N \N Compositae 1 \N \N \N \N \N \N \N \N \N \N \N \N indet. sp.1 Accepted Compositae \N family \N \N \N false tpl [Ambiguous match] \N t Compositae indet. sp.1 \N Compositae t Compositae \N \N \N Compositae indet. sp.1 \N \N \N \N Compositae accepted family Compositae \N \N \N Compositae indet. sp.1 \N \N Compositae \N Compositae
|
|
| 1880 |
2014-07-22 06:48:16.289953-07 2 0 Compositae indet. sp.1 0.900000000000000022 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 false tropicos \N t Asteraceae Bercht. & J. Presl indet. sp.1 \N Compositae Giseke t Asteraceae \N \N \N Asteraceae indet. sp.1 \N \N \N \N Asteraceae Bercht. & J. Presl accepted family Asteraceae \N \N \N Asteraceae indet. sp.1 \N \N Asteraceae Bercht. & J. Presl Asteraceae Bercht. & J. Presl
|
|
| 1881 |
2014-07-22 06:48:16.289953-07 3 1 Fabaceae Boyle#6500 0.839999999999999969 Fagaceae family 0.939999999999999947 \N ;http://plants.usda.gov/java/nameSearch \N \N Fagaceae 0.880000000000000004 \N \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 Accepted Fagaceae \N family ;http://plants.usda.gov/java/nameSearch \N \N true tpl;usda \N f Fagaceae Boyle#6500 \N Fagaceae t Fagaceae \N \N \N Fagaceae Boyle#6500 \N \N \N \N Fagaceae accepted family Fagaceae \N \N \N Fagaceae Boyle#6500 \N \N Fagaceae \N Fagaceae
|
|
| 1882 |
2014-07-22 06:48:16.289953-07 4 1 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 false tropicos \N t Fabaceae Lindl. Boyle#6500 \N Fabaceae Lindl. t Fabaceae \N \N \N Fabaceae Boyle#6500 \N \N \N \N Fabaceae Lindl. accepted family Fabaceae \N \N \N Fabaceae Boyle#6500 \N \N Fabaceae Lindl. Fabaceae Lindl.
|
|
| 1883 |
2014-07-22 06:48:16.289953-07 5 1 Fabaceae Boyle#6500 0.839999999999999969 Fagaceae family 0.939999999999999947 Dumort. http://www.tropicos.org/Name/42000062 \N \N Fagaceae 0.880000000000000004 Fagaceae \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 Accepted Fagaceae Dumort. family http://www.tropicos.org/Name/42000062 \N Fagaceae false tropicos \N f Fagaceae Dumort. Boyle#6500 \N Fagaceae Dumort. t Fagaceae \N \N \N Fagaceae Boyle#6500 \N \N \N \N Fagaceae Dumort. accepted family Fagaceae \N \N \N Fagaceae Boyle#6500 \N \N Fagaceae Dumort. Fagaceae Dumort.
|
|
| 1884 |
2014-07-22 06:48:16.289953-07 6 1 Fabaceae Boyle#6500 0.67000000000000004 Ficaceae family 0.770000000000000018 Bercht. & J. Presl http://www.tropicos.org/Name/100353631 \N \N Ficaceae 0.75 Ficaceae \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 No opinion \N \N \N \N \N \N false tropicos \N f Ficaceae Bercht. & J. Presl Boyle#6500 \N Ficaceae Bercht. & J. Presl f \N \N \N \N \N \N \N \N \N \N no opinion family Ficaceae \N \N \N Ficaceae Boyle#6500 \N \N Ficaceae Bercht. & J. Presl Ficaceae Bercht. & J. Presl
|
|
| 1885 |
2014-07-22 06:48:16.289953-07 7 1 Fabaceae Boyle#6500 0.67000000000000004 Fucaceae family 0.770000000000000018 \N http://www.tropicos.org/Name/100371040 \N \N Fucaceae 0.75 Fucaceae \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 No opinion \N \N \N \N \N \N false tropicos \N f Fucaceae Boyle#6500 \N Fucaceae f \N \N \N \N \N \N \N \N \N \N no opinion family Fucaceae \N \N \N Fucaceae Boyle#6500 \N \N Fucaceae \N Fucaceae
|
|
| 1886 |
2014-07-22 06:48:16.289953-07 8 1 Fabaceae Boyle#6500 0.900000000000000022 Fabaceae family 1 \N http://plants.usda.gov/java/nameSearch \N \N Fabaceae 1 \N \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 Accepted Fabaceae \N family http://plants.usda.gov/java/nameSearch \N \N false usda \N t Fabaceae Boyle#6500 \N Fabaceae t Fabaceae \N \N \N Fabaceae Boyle#6500 \N \N \N \N Fabaceae accepted family Fabaceae \N \N \N Fabaceae Boyle#6500 \N \N Fabaceae \N Fabaceae
|
|
| 1887 |
2014-07-22 06:48:16.289953-07 9 2 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 "fuzzy leaf" \N Inga t Fabaceae \N Inga \N Inga "fuzzy leaf" \N \N \N \N Inga accepted genus Fabaceae Inga \N \N Inga "fuzzy leaf" \N \N Inga \N Inga
|
|
| 1888 |
2014-07-22 06:48:16.289953-07 10 2 Fabaceae Inga "fuzzy leaf" 0.900000000000000022 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 false tropicos \N t Fabaceae Inga Mill. "fuzzy leaf" \N Inga Mill. t Fabaceae \N Inga \N Inga "fuzzy leaf" \N \N \N \N Inga Mill. accepted genus Fabaceae Inga \N \N Inga "fuzzy leaf" \N \N Inga Mill. Inga Mill.
|
|
| 1889 |
2014-07-22 06:48:16.289953-07 11 2 Fabaceae Inga "fuzzy leaf" 0.900000000000000022 Inga genus 1 Scop. http://www.tropicos.org/Name/50215121 \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N "fuzzy leaf" Illegitimate \N \N \N \N \N \N false tropicos \N t Fabaceae Inga Scop. "fuzzy leaf" \N Inga Scop. f \N \N \N \N \N \N \N \N \N \N illegitimate genus Fabaceae Inga \N \N Inga "fuzzy leaf" \N \N Inga Scop. Inga Scop.
|
|
| 1890 |
2014-07-22 06:48:16.289953-07 12 3 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 sp.3 \N Inga t Fabaceae \N Inga \N Inga sp.3 \N \N \N \N Inga accepted genus Fabaceae Inga \N \N Inga sp.3 \N \N Inga \N Inga
|
|
| 1891 |
2014-07-22 06:48:16.289953-07 13 3 Fabaceae Inga sp.3 0.900000000000000022 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 false tropicos \N t Fabaceae Inga Mill. sp.3 \N Inga Mill. t Fabaceae \N Inga \N Inga sp.3 \N \N \N \N Inga Mill. accepted genus Fabaceae Inga \N \N Inga sp.3 \N \N Inga Mill. Inga Mill.
|
|
| 1892 |
2014-07-22 06:48:16.289953-07 14 3 Fabaceae Inga sp.3 0.900000000000000022 Inga genus 1 Scop. http://www.tropicos.org/Name/50215121 \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N sp.3 Illegitimate \N \N \N \N \N \N false tropicos \N t Fabaceae Inga Scop. sp.3 \N Inga Scop. f \N \N \N \N \N \N \N \N \N \N illegitimate genus Fabaceae Inga \N \N Inga sp.3 \N \N Inga Scop. Inga Scop.
|
|
| 1893 |
2014-07-22 06:48:16.289953-07 15 4 Fabaceae unknown #2 0.839999999999999969 Fagaceae family 0.939999999999999947 \N ;http://plants.usda.gov/java/nameSearch \N \N Fagaceae 0.880000000000000004 \N \N \N \N \N \N \N \N \N \N \N \N unknown #2 Accepted Fagaceae \N family ;http://plants.usda.gov/java/nameSearch \N \N true tpl;usda \N f Fagaceae unknown #2 \N Fagaceae t Fagaceae \N \N \N Fagaceae unknown #2 \N \N \N \N Fagaceae accepted family Fagaceae \N \N \N Fagaceae unknown #2 \N \N Fagaceae \N Fagaceae
|
|
| 1894 |
2014-07-22 06:48:16.289953-07 16 4 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 false tropicos \N t Fabaceae Lindl. unknown #2 \N Fabaceae Lindl. t Fabaceae \N \N \N Fabaceae unknown #2 \N \N \N \N Fabaceae Lindl. accepted family Fabaceae \N \N \N Fabaceae unknown #2 \N \N Fabaceae Lindl. Fabaceae Lindl.
|
|
| 1895 |
2014-07-22 06:48:16.289953-07 17 4 Fabaceae unknown #2 0.839999999999999969 Fagaceae family 0.939999999999999947 Dumort. http://www.tropicos.org/Name/42000062 \N \N Fagaceae 0.880000000000000004 Fagaceae \N \N \N \N \N \N \N \N \N \N \N unknown #2 Accepted Fagaceae Dumort. family http://www.tropicos.org/Name/42000062 \N Fagaceae false tropicos \N f Fagaceae Dumort. unknown #2 \N Fagaceae Dumort. t Fagaceae \N \N \N Fagaceae unknown #2 \N \N \N \N Fagaceae Dumort. accepted family Fagaceae \N \N \N Fagaceae unknown #2 \N \N Fagaceae Dumort. Fagaceae Dumort.
|
|
| 1896 |
2014-07-22 06:48:16.289953-07 18 4 Fabaceae unknown #2 0.67000000000000004 Ficaceae family 0.770000000000000018 Bercht. & J. Presl http://www.tropicos.org/Name/100353631 \N \N Ficaceae 0.75 Ficaceae \N \N \N \N \N \N \N \N \N \N \N unknown #2 No opinion \N \N \N \N \N \N false tropicos \N f Ficaceae Bercht. & J. Presl unknown #2 \N Ficaceae Bercht. & J. Presl f \N \N \N \N \N \N \N \N \N \N no opinion family Ficaceae \N \N \N Ficaceae unknown #2 \N \N Ficaceae Bercht. & J. Presl Ficaceae Bercht. & J. Presl
|
|
| 1897 |
2014-07-22 06:48:16.289953-07 19 4 Fabaceae unknown #2 0.67000000000000004 Fucaceae family 0.770000000000000018 \N http://www.tropicos.org/Name/100371040 \N \N Fucaceae 0.75 Fucaceae \N \N \N \N \N \N \N \N \N \N \N unknown #2 No opinion \N \N \N \N \N \N false tropicos \N f Fucaceae unknown #2 \N Fucaceae f \N \N \N \N \N \N \N \N \N \N no opinion family Fucaceae \N \N \N Fucaceae unknown #2 \N \N Fucaceae \N Fucaceae
|
|
| 1898 |
2014-07-22 06:48:16.289953-07 20 4 Fabaceae unknown #2 0.900000000000000022 Fabaceae family 1 \N http://plants.usda.gov/java/nameSearch \N \N Fabaceae 1 \N \N \N \N \N \N \N \N \N \N \N \N unknown #2 Accepted Fabaceae \N family http://plants.usda.gov/java/nameSearch \N \N false usda \N t Fabaceae unknown #2 \N Fabaceae t Fabaceae \N \N \N Fabaceae unknown #2 \N \N \N \N Fabaceae accepted family Fabaceae \N \N \N Fabaceae unknown #2 \N \N Fabaceae \N Fabaceae
|
|
| 1899 |
2014-07-22 06:48:16.289953-07 21 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 f \N \N \N No suitable matches found. f \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N No suitable matches found. \N No suitable matches found.
|
|
| 1900 |
2014-07-22 06:48:16.289953-07 22 6 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. \N Poa annua Poa annua L. t Poaceae {Poa,annua} Poa annua Poa annua \N \N \N \N Poa annua L. accepted species Poaceae Poa annua Poa annua Poa annua \N annua Poa annua L. Poa annua L.
|
|
| 1901 |
2014-07-22 06:48:16.289953-07 23 6 Poa annua 1 Poa annua species 1 Cham. & Schltdl. http://www.theplantlist.org/tpl1.1/record/kew-435195 \N \N \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N Synonym Poa infirma Kunth species http://www.theplantlist.org/tpl1.1/record/kew-436189 Poa infirma Poaceae false tpl \N t Poaceae Poa infirma Kunth \N Poa annua Poa annua Cham. & Schltdl. t Poaceae {Poa,infirma} Poa infirma Poa infirma \N \N \N \N Poa infirma Kunth accepted species Poaceae Poa infirma Poa infirma Poa infirma \N infirma Poa infirma Kunth Poa infirma Kunth
|
|
| 1902 |
2014-07-22 06:48:16.289953-07 24 7 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. \N Poa annua Poa annua L. t Poaceae {Poa,annua} Poa annua Poa annua \N \N \N \N Poa annua L. accepted species Poaceae Poa annua Poa annua Poa annua \N annua Poa annua L. Poa annua L.
|
|
| 1903 |
2014-07-22 06:48:16.289953-07 25 7 Poa annua L. 0.800000000000000044 Poa annua species 1 Cham. & Schltdl. http://www.theplantlist.org/tpl1.1/record/kew-435195 Cham. & Schltdl. 0 \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N Synonym Poa infirma Kunth species http://www.theplantlist.org/tpl1.1/record/kew-436189 Poa infirma Poaceae false tpl \N t Poaceae Poa infirma Kunth \N Poa annua Poa annua Cham. & Schltdl. t Poaceae {Poa,infirma} Poa infirma Poa infirma \N \N \N \N Poa infirma Kunth accepted species Poaceae Poa infirma Poa infirma Poa infirma \N infirma Poa infirma Kunth Poa infirma Kunth
|
|
| 1904 |
2014-07-22 06:48:16.289953-07 26 8 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. \N Poa annua Poa annua fo. lanuginosa Sennen t Poaceae {Poa,annua} Poa annua Poa annua \N \N \N \N Poa annua L. accepted species Poaceae Poa annua Poa annua Poa annua \N annua Poa annua L. Poa annua L.
|
|
| 1905 |
2014-07-22 06:48:16.289953-07 27 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 false tropicos \N t Poaceae Poa annua var. annua \N Poa annua Poa annua fo. lanuginosa Sennen t Poaceae {Poa,annua} Poa annua Poa annua var. annua {var.,annua} var. annua Poa annua var. annua accepted variety Poaceae Poa annua Poa annua Poa annua var. annua Poa annua var. annua \N Poa annua var. annua
|
|
| 1906 |
2014-07-22 06:48:16.289953-07 28 9 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 \N Poa annua Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn. t Poaceae {Poa,infirma} Poa infirma Poa infirma \N \N \N \N Poa infirma Kunth accepted species Poaceae Poa infirma Poa infirma Poa infirma \N infirma Poa infirma Kunth Poa infirma Kunth
|
|
| 1907 |
2014-07-22 06:48:16.289953-07 29 9 Poa annua ssp. exilis 0.959999999999999964 Poa annua var. exilis variety 0.959999999999999964 Tomm. ex Freyn http://www.tropicos.org/Name/25547854 \N \N \N \N Poaceae Poa 1 annua 1 var. exilis 0.699999999999999956 \N \N \N \N \N Synonym Poa infirma Kunth species http://www.tropicos.org/Name/25514158 Poa infirma Poaceae false tropicos \N t Poaceae Poa infirma Kunth \N Poa annua Poa annua var. exilis Tomm. ex Freyn t Poaceae {Poa,infirma} Poa infirma Poa infirma \N \N \N \N Poa infirma Kunth accepted species Poaceae Poa infirma Poa infirma Poa infirma \N infirma Poa infirma Kunth Poa infirma Kunth
|
|
| 1908 |
2014-07-22 06:48:16.289953-07 30 10 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 \N Poa annua Poa annua subsp. exilis (Tomm. ex Freyn.) Asch. & Graebn. t Poaceae {Poa,infirma} Poa infirma Poa infirma \N \N \N \N Poa infirma Kunth accepted species Poaceae Poa infirma Poa infirma Poa infirma \N infirma Poa infirma Kunth Poa infirma Kunth
|
|
| 1909 |
2014-07-22 06:48:16.289953-07 31 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 false tropicos \N t Poaceae Poa infirma Kunth \N Poa annua Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn. t Poaceae {Poa,infirma} Poa infirma Poa infirma \N \N \N \N Poa infirma Kunth accepted species Poaceae Poa infirma Poa infirma Poa infirma \N infirma Poa infirma Kunth Poa infirma Kunth
|
|
| 1910 |
2014-07-22 06:48:16.289953-07 32 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 t Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn. \N Poa annua Poa annua subvar. minima (Schur) Asch. & Graebn. t Poaceae {Poa,annua} Poa annua Poa annua subvar. minima {subvar.,minima} subvar. minima Poa annua subvar. minima (Schur) Asch. & Graebn. accepted subvariety Poaceae Poa annua Poa annua Poa annua subvar. annua Poa annua subvar. minima (Schur) Asch. & Graebn. Poa annua subvar. minima (Schur) Asch. & Graebn.
|
|
| 1911 |
2014-07-22 06:48:16.289953-07 33 12 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. \N Poa annua Poa annua var. eriolepis ̉ۡ.Desv. t Poaceae {Poa,annua} Poa annua Poa annua \N \N \N \N Poa annua L. accepted species Poaceae Poa annua Poa annua Poa annua \N annua Poa annua L. Poa annua L.
|
|
| 1912 |
2014-07-22 06:48:16.289953-07 34 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 false tropicos \N t Poaceae Poa annua L. \N Poa annua Poa annua var. eriolepis E. Desv. t Poaceae {Poa,annua} Poa annua Poa annua \N \N \N \N Poa annua L. accepted species Poaceae Poa annua Poa annua Poa annua \N annua Poa annua L. Poa annua L.
|
|
| 1913 |
2014-07-22 06:48:16.289953-07 35 13 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 var. grisea Silene scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire t Caryophyllaceae {Silene,scouleri} Silene scouleri Silene scouleri subsp. pringlei {subsp.,pringlei} subsp. pringlei Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire accepted subsp. Caryophyllaceae Silene scouleri Silene scouleri Silene scouleri subsp. scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
| 1914 |
2014-07-22 06:48:16.289953-07 36 13 Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire 0.770000000000000018 Silene scouleri subsp. pringlei subspecies 0.770000000000000018 (S. Watson) C.L. Hitchc. & Maguire http://www.tropicos.org/Name/6303627 \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 false tropicos [Partial match] \N t Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea Silene scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire t Caryophyllaceae {Silene,scouleri} Silene scouleri Silene scouleri subsp. pringlei {subsp.,pringlei} subsp. pringlei Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire accepted subspecies Caryophyllaceae Silene scouleri Silene scouleri Silene scouleri subsp. scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
| 1915 |
2014-07-22 06:48:16.289953-07 37 13 Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire 0.770000000000000018 Silene scouleri subsp. pringlei subspecies 0.770000000000000018 (S. Watson) C.L. Hitchc. & Maguire http://plants.usda.gov/java/profile?symbol=SISCP \N \N \N \N Caryophyllaceae Silene 1 scouleri 1 subsp. pringlei 1 \N \N \N \N var. grisea Accepted Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire subspecies http://plants.usda.gov/java/profile?symbol=SISCP Silene scouleri Caryophyllaceae false usda [Partial match] \N t Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea Silene scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire t Caryophyllaceae {Silene,scouleri} Silene scouleri Silene scouleri ssp. pringlei {ssp.,pringlei} ssp. pringlei Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire accepted subspecies Caryophyllaceae Silene scouleri Silene scouleri Silene scouleri ssp. scouleri Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
| 1916 |
2014-07-22 06:48:16.289953-07 38 14 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 var. grisea Silene scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire t Caryophyllaceae {Silene,scouleri} Silene scouleri Silene scouleri subsp. pringlei {subsp.,pringlei} subsp. pringlei Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire accepted subsp. Caryophyllaceae Silene scouleri Silene scouleri Silene scouleri subsp. scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
| 1917 |
2014-07-22 06:48:16.289953-07 39 14 Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire 0.770000000000000018 Silene scouleri subsp. pringlei subspecies 0.770000000000000018 (S. Watson) C.L. Hitchc. & Maguire http://www.tropicos.org/Name/6303627 \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 false tropicos [Partial match] \N t Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea Silene scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire t Caryophyllaceae {Silene,scouleri} Silene scouleri Silene scouleri subsp. pringlei {subsp.,pringlei} subsp. pringlei Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire accepted subspecies Caryophyllaceae Silene scouleri Silene scouleri Silene scouleri subsp. scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
| 1918 |
2014-07-22 06:48:16.289953-07 40 14 Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire 0.770000000000000018 Silene scouleri subsp. pringlei subspecies 0.770000000000000018 (S. Watson) C.L. Hitchc. & Maguire http://plants.usda.gov/java/profile?symbol=SISCP \N \N \N \N Caryophyllaceae Silene 1 scouleri 1 subsp. pringlei 1 \N \N \N \N var. grisea Accepted Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire subspecies http://plants.usda.gov/java/profile?symbol=SISCP Silene scouleri Caryophyllaceae false usda [Partial match] \N t Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea Silene scouleri Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire t Caryophyllaceae {Silene,scouleri} Silene scouleri Silene scouleri ssp. pringlei {ssp.,pringlei} ssp. pringlei Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire accepted subspecies Caryophyllaceae Silene scouleri Silene scouleri Silene scouleri ssp. scouleri Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire
|
|
| 1838 | 1919 |
\. |
| 1839 | 1920 |
|
| 1840 | 1921 |
|
| 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-7-22 4:06:27 PDT)';
|
|
| 25 |
COMMENT ON SCHEMA "public.test_taxonomic_names" IS 'Version: public (2014-7-22 6:48:23 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-07-22 04:06:20.378232-07', '2014-07-22 04:06:20.378232-07', '2014-07-22 04:06:20.378232-07', NULL);
|
|
| 24 |
INSERT INTO batch VALUES ('2014-07-22 06:48:16.289953-07', '2014-07-22 06:48:16.289953-07', '2014-07-22 06:48:16.289953-07', NULL);
|
|
| 25 | 25 |
|
| 26 | 26 |
|
| 27 | 27 |
-- |
| ... | ... | |
| 34 | 34 |
-- Data for Name: taxon_match; Type: TABLE DATA; Schema: TNRS; Owner: - |
| 35 | 35 |
-- |
| 36 | 36 |
|
| 37 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 0, 0, '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', 'indet. sp.1', NULL, 'Compositae', true, 'Compositae', NULL, NULL, NULL, 'Compositae indet. sp.1', NULL, NULL, NULL, NULL, 'Compositae', 'family', 'Compositae', NULL, NULL, NULL, NULL, NULL, 'Compositae', NULL, 'Compositae', 'accepted', 'Compositae indet. sp.1');
|
|
| 38 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 1, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, NULL, NULL, NULL, NULL, 'Compositae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Accepted', 'Compositae', NULL, 'family', NULL, NULL, NULL, 'false', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae', 'indet. sp.1', NULL, 'Compositae', true, 'Compositae', NULL, NULL, NULL, 'Compositae indet. sp.1', NULL, NULL, NULL, NULL, 'Compositae', 'family', 'Compositae', NULL, NULL, NULL, NULL, NULL, 'Compositae', NULL, 'Compositae', 'accepted', 'Compositae indet. sp.1');
|
|
| 39 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 2, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, 'Giseke', 'http://www.tropicos.org/Name/50255940', NULL, NULL, 'Compositae', 1, 'Compositae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Synonym', 'Asteraceae', 'Bercht. & J. Presl', 'family', 'http://www.tropicos.org/Name/50307371', NULL, 'Asteraceae', 'false', 'tropicos', ' ', NULL, true, 'Asteraceae Bercht. & J. Presl', 'indet. sp.1', NULL, 'Compositae Giseke', true, 'Asteraceae', NULL, NULL, NULL, 'Asteraceae indet. sp.1', NULL, NULL, NULL, NULL, 'Asteraceae Bercht. & J. Presl', 'family', 'Asteraceae', NULL, NULL, NULL, NULL, NULL, 'Asteraceae', 'Bercht. & J. Presl', 'Asteraceae Bercht. & J. Presl', 'accepted', 'Asteraceae indet. sp.1');
|
|
| 40 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 3, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', 'Boyle#6500', NULL, 'Fagaceae', true, 'Fagaceae', NULL, NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fagaceae', 'family', 'Fagaceae', NULL, NULL, NULL, NULL, NULL, 'Fagaceae', NULL, 'Fagaceae', 'accepted', 'Fagaceae Boyle#6500');
|
|
| 41 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 4, 1, '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', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', 'Boyle#6500', NULL, 'Fabaceae Lindl.', true, 'Fabaceae', NULL, NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'family', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.', 'accepted', 'Fabaceae Boyle#6500');
|
|
| 42 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 5, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', 'Boyle#6500', NULL, 'Fagaceae Dumort.', true, 'Fagaceae', NULL, NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'family', 'Fagaceae', NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.', 'accepted', 'Fagaceae Boyle#6500');
|
|
| 43 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 6, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Ficaceae', 'family', 0.770000000000000018, 'Bercht. & J. Presl', 'http://www.tropicos.org/Name/100353631', NULL, NULL, 'Ficaceae', 0.75, 'Ficaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Ficaceae Bercht. & J. Presl', 'Boyle#6500', NULL, 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Ficaceae', NULL, NULL, NULL, NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl', 'no opinion', 'Ficaceae Boyle#6500');
|
|
| 44 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 7, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', 'Boyle#6500', NULL, 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Fucaceae', NULL, NULL, NULL, NULL, NULL, 'Fucaceae', NULL, 'Fucaceae', 'no opinion', 'Fucaceae Boyle#6500');
|
|
| 45 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 8, 1, 'Fabaceae Boyle#6500', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', 'Boyle#6500', NULL, 'Fabaceae', true, 'Fabaceae', NULL, NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fabaceae', 'family', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Fabaceae', NULL, 'Fabaceae', 'accepted', 'Fabaceae Boyle#6500');
|
|
| 46 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 9, 2, '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', '"fuzzy leaf"', NULL, 'Inga', true, 'Fabaceae', NULL, 'Inga', NULL, 'Inga "fuzzy leaf"', NULL, NULL, NULL, NULL, 'Inga', 'genus', 'Fabaceae', 'Inga', NULL, NULL, NULL, NULL, 'Inga', NULL, 'Inga', 'accepted', 'Inga "fuzzy leaf"');
|
|
| 47 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 10, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', '"fuzzy leaf"', NULL, 'Inga Mill.', true, 'Fabaceae', NULL, 'Inga', NULL, 'Inga "fuzzy leaf"', NULL, NULL, NULL, NULL, 'Inga Mill.', 'genus', 'Fabaceae', 'Inga', NULL, NULL, NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.', 'accepted', 'Inga "fuzzy leaf"');
|
|
| 48 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 11, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', '"fuzzy leaf"', NULL, 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'genus', 'Fabaceae', 'Inga', NULL, NULL, NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.', 'illegitimate', 'Inga "fuzzy leaf"');
|
|
| 49 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 12, 3, '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', 'sp.3', NULL, 'Inga', true, 'Fabaceae', NULL, 'Inga', NULL, 'Inga sp.3', NULL, NULL, NULL, NULL, 'Inga', 'genus', 'Fabaceae', 'Inga', NULL, NULL, NULL, NULL, 'Inga', NULL, 'Inga', 'accepted', 'Inga sp.3');
|
|
| 50 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 13, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', 'sp.3', NULL, 'Inga Mill.', true, 'Fabaceae', NULL, 'Inga', NULL, 'Inga sp.3', NULL, NULL, NULL, NULL, 'Inga Mill.', 'genus', 'Fabaceae', 'Inga', NULL, NULL, NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.', 'accepted', 'Inga sp.3');
|
|
| 51 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 14, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', 'sp.3', NULL, 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'genus', 'Fabaceae', 'Inga', NULL, NULL, NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.', 'illegitimate', 'Inga sp.3');
|
|
| 52 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 15, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', 'unknown #2', NULL, 'Fagaceae', true, 'Fagaceae', NULL, NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, NULL, NULL, 'Fagaceae', 'family', 'Fagaceae', NULL, NULL, NULL, NULL, NULL, 'Fagaceae', NULL, 'Fagaceae', 'accepted', 'Fagaceae unknown #2');
|
|
| 53 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 16, 4, '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', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', 'unknown #2', NULL, 'Fabaceae Lindl.', true, 'Fabaceae', NULL, NULL, NULL, 'Fabaceae unknown #2', NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'family', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.', 'accepted', 'Fabaceae unknown #2');
|
|
| 54 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 17, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', 'unknown #2', NULL, 'Fagaceae Dumort.', true, 'Fagaceae', NULL, NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'family', 'Fagaceae', NULL, NULL, NULL, NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.', 'accepted', 'Fagaceae unknown #2');
|
|
| 55 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 18, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Ficaceae', 'family', 0.770000000000000018, 'Bercht. & J. Presl', 'http://www.tropicos.org/Name/100353631', NULL, NULL, 'Ficaceae', 0.75, 'Ficaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Ficaceae Bercht. & J. Presl', 'unknown #2', NULL, 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Ficaceae', NULL, NULL, NULL, NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl', 'no opinion', 'Ficaceae unknown #2');
|
|
| 56 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 19, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', 'unknown #2', NULL, 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'family', 'Fucaceae', NULL, NULL, NULL, NULL, NULL, 'Fucaceae', NULL, 'Fucaceae', 'no opinion', 'Fucaceae unknown #2');
|
|
| 57 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 20, 4, 'Fabaceae unknown #2', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', 'unknown #2', NULL, 'Fabaceae', true, 'Fabaceae', NULL, NULL, NULL, 'Fabaceae unknown #2', NULL, NULL, NULL, NULL, 'Fabaceae', 'family', 'Fabaceae', NULL, NULL, NULL, NULL, NULL, 'Fabaceae', NULL, 'Fabaceae', 'accepted', 'Fabaceae unknown #2');
|
|
| 58 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 21, 5, '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, NULL, NULL, 'No suitable matches found.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'No suitable matches found.', NULL, 'No suitable matches found.', NULL, NULL);
|
|
| 59 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 22, 6, '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.', NULL, 'Poa annua', 'Poa annua L.', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.', 'accepted', 'Poa annua');
|
|
| 60 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 23, 6, 'Poa annua', 1, 'Poa annua', 'species', 1, 'Cham. & Schltdl.', 'http://www.theplantlist.org/tpl1.1/record/kew-435195', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'false', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua Cham. & Schltdl.', true, 'Poaceae', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth', 'accepted', 'Poa infirma');
|
|
| 61 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 24, 7, '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.', NULL, 'Poa annua', 'Poa annua L.', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.', 'accepted', 'Poa annua');
|
|
| 62 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 25, 7, 'Poa annua L.', 0.800000000000000044, 'Poa annua', 'species', 1, 'Cham. & Schltdl.', 'http://www.theplantlist.org/tpl1.1/record/kew-435195', 'Cham. & Schltdl.', 0, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'false', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua Cham. & Schltdl.', true, 'Poaceae', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth', 'accepted', 'Poa infirma');
|
|
| 63 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 26, 8, '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.', NULL, 'Poa annua', 'Poa annua fo. lanuginosa Sennen', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.', 'accepted', 'Poa annua');
|
|
| 64 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 27, 8, 'Poa annua fo. lanuginosa', 1, 'Poa annua fo. lanuginosa', 'forma', 1, 'Sennen', 'http://www.tropicos.org/Name/50267771', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'fo.', 'lanuginosa', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua var. annua', NULL, 'variety', 'http://www.tropicos.org/Name/25517736', 'Poa annua', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua var. annua', NULL, 'Poa annua', 'Poa annua fo. lanuginosa Sennen', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', 'var. annua', '{var.,annua}', 'var.', 'annua', 'Poa annua var. annua', 'variety', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'var.', 'annua', 'Poa annua var. annua', NULL, 'Poa annua var. annua', 'accepted', 'Poa annua');
|
|
| 65 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 28, 9, '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', NULL, 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, 'Poaceae', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth', 'accepted', 'Poa infirma');
|
|
| 66 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 29, 9, 'Poa annua ssp. exilis', 0.959999999999999964, 'Poa annua var. exilis', 'variety', 0.959999999999999964, 'Tomm. ex Freyn', 'http://www.tropicos.org/Name/25547854', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'exilis', 0.699999999999999956, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua var. exilis Tomm. ex Freyn', true, 'Poaceae', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth', 'accepted', 'Poa infirma');
|
|
| 67 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 30, 10, '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', NULL, 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn.) Asch. & Graebn.', true, 'Poaceae', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth', 'accepted', 'Poa infirma');
|
|
| 68 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 31, 10, 'Poa annua subsp. exilis', 1, 'Poa annua subsp. exilis', 'subspecies', 1, '(Tomm. ex Freyn) Asch. & Graebn.', 'http://www.tropicos.org/Name/50063800', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, 'Poaceae', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth', 'accepted', 'Poa infirma');
|
|
| 69 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 32, 11, '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.', NULL, 'Poa annua', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', 'subvar. minima', '{subvar.,minima}', 'subvar.', 'minima', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', 'subvariety', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'subvar.', 'annua', 'Poa annua subvar. minima', '(Schur) Asch. & Graebn.', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', 'accepted', 'Poa annua');
|
|
| 70 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 33, 12, '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.', NULL, 'Poa annua', 'Poa annua var. eriolepis ̉ۡ.Desv.', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.', 'accepted', 'Poa annua');
|
|
| 71 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 34, 12, 'Poa annua var. eriolepis', 1, 'Poa annua var. eriolepis', 'variety', 1, 'E. Desv.', 'http://www.tropicos.org/Name/50119145', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'eriolepis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.tropicos.org/Name/25509881', 'Poa annua', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua L.', NULL, 'Poa annua', 'Poa annua var. eriolepis E. Desv.', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.', 'accepted', 'Poa annua');
|
|
| 72 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 35, 13, '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', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'Silene scouleri');
|
|
| 73 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 36, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'false', 'tropicos', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'Silene scouleri');
|
|
| 74 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 37, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://plants.usda.gov/java/profile?symbol=SISCP', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://plants.usda.gov/java/profile?symbol=SISCP', 'Silene scouleri', 'Caryophyllaceae', 'false', 'usda', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'ssp. pringlei', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'ssp.', 'scouleri', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'Silene scouleri');
|
|
| 75 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 38, 14, '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', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'Silene scouleri');
|
|
| 76 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 39, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'false', 'tropicos', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'Silene scouleri');
|
|
| 77 |
INSERT INTO taxon_match VALUES ('2014-07-22 04:06:20.378232-07', 40, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://plants.usda.gov/java/profile?symbol=SISCP', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://plants.usda.gov/java/profile?symbol=SISCP', 'Silene scouleri', 'Caryophyllaceae', 'false', 'usda', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'ssp. pringlei', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'ssp.', 'scouleri', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'Silene scouleri');
|
|
| 37 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 0, 0, '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', 'indet. sp.1', NULL, 'Compositae', true, 'Compositae', NULL, NULL, NULL, 'Compositae indet. sp.1', NULL, NULL, NULL, NULL, 'Compositae', 'accepted', 'family', 'Compositae', NULL, NULL, NULL, 'Compositae indet. sp.1', NULL, NULL, 'Compositae', NULL, 'Compositae');
|
|
| 38 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 1, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, NULL, NULL, NULL, NULL, 'Compositae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Accepted', 'Compositae', NULL, 'family', NULL, NULL, NULL, 'false', 'tpl', ' [Ambiguous match] ', NULL, true, 'Compositae', 'indet. sp.1', NULL, 'Compositae', true, 'Compositae', NULL, NULL, NULL, 'Compositae indet. sp.1', NULL, NULL, NULL, NULL, 'Compositae', 'accepted', 'family', 'Compositae', NULL, NULL, NULL, 'Compositae indet. sp.1', NULL, NULL, 'Compositae', NULL, 'Compositae');
|
|
| 39 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 2, 0, 'Compositae indet. sp.1', 0.900000000000000022, 'Compositae', 'family', 1, 'Giseke', 'http://www.tropicos.org/Name/50255940', NULL, NULL, 'Compositae', 1, 'Compositae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'indet. sp.1', 'Synonym', 'Asteraceae', 'Bercht. & J. Presl', 'family', 'http://www.tropicos.org/Name/50307371', NULL, 'Asteraceae', 'false', 'tropicos', ' ', NULL, true, 'Asteraceae Bercht. & J. Presl', 'indet. sp.1', NULL, 'Compositae Giseke', true, 'Asteraceae', NULL, NULL, NULL, 'Asteraceae indet. sp.1', NULL, NULL, NULL, NULL, 'Asteraceae Bercht. & J. Presl', 'accepted', 'family', 'Asteraceae', NULL, NULL, NULL, 'Asteraceae indet. sp.1', NULL, NULL, 'Asteraceae', 'Bercht. & J. Presl', 'Asteraceae Bercht. & J. Presl');
|
|
| 40 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 3, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', 'Boyle#6500', NULL, 'Fagaceae', true, 'Fagaceae', NULL, NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fagaceae', 'accepted', 'family', 'Fagaceae', NULL, NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, 'Fagaceae', NULL, 'Fagaceae');
|
|
| 41 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 4, 1, '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', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', 'Boyle#6500', NULL, 'Fabaceae Lindl.', true, 'Fabaceae', NULL, NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'accepted', 'family', 'Fabaceae', NULL, NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.');
|
|
| 42 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 5, 1, 'Fabaceae Boyle#6500', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', 'Boyle#6500', NULL, 'Fagaceae Dumort.', true, 'Fagaceae', NULL, NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'accepted', 'family', 'Fagaceae', NULL, NULL, NULL, 'Fagaceae Boyle#6500', NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.');
|
|
| 43 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 6, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Ficaceae', 'family', 0.770000000000000018, 'Bercht. & J. Presl', 'http://www.tropicos.org/Name/100353631', NULL, NULL, 'Ficaceae', 0.75, 'Ficaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Ficaceae Bercht. & J. Presl', 'Boyle#6500', NULL, 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no opinion', 'family', 'Ficaceae', NULL, NULL, NULL, 'Ficaceae Boyle#6500', NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl');
|
|
| 44 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 7, 1, 'Fabaceae Boyle#6500', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', 'Boyle#6500', NULL, 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no opinion', 'family', 'Fucaceae', NULL, NULL, NULL, 'Fucaceae Boyle#6500', NULL, NULL, 'Fucaceae', NULL, 'Fucaceae');
|
|
| 45 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 8, 1, 'Fabaceae Boyle#6500', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Boyle#6500', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', 'Boyle#6500', NULL, 'Fabaceae', true, 'Fabaceae', NULL, NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, NULL, NULL, 'Fabaceae', 'accepted', 'family', 'Fabaceae', NULL, NULL, NULL, 'Fabaceae Boyle#6500', NULL, NULL, 'Fabaceae', NULL, 'Fabaceae');
|
|
| 46 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 9, 2, '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', '"fuzzy leaf"', NULL, 'Inga', true, 'Fabaceae', NULL, 'Inga', NULL, 'Inga "fuzzy leaf"', NULL, NULL, NULL, NULL, 'Inga', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga "fuzzy leaf"', NULL, NULL, 'Inga', NULL, 'Inga');
|
|
| 47 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 10, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', '"fuzzy leaf"', NULL, 'Inga Mill.', true, 'Fabaceae', NULL, 'Inga', NULL, 'Inga "fuzzy leaf"', NULL, NULL, NULL, NULL, 'Inga Mill.', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga "fuzzy leaf"', NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');
|
|
| 48 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 11, 2, 'Fabaceae Inga "fuzzy leaf"', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '"fuzzy leaf"', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', '"fuzzy leaf"', NULL, 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'illegitimate', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga "fuzzy leaf"', NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.');
|
|
| 49 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 12, 3, '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', 'sp.3', NULL, 'Inga', true, 'Fabaceae', NULL, 'Inga', NULL, 'Inga sp.3', NULL, NULL, NULL, NULL, 'Inga', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga sp.3', NULL, NULL, 'Inga', NULL, 'Inga');
|
|
| 50 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 13, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Mill.', 'http://www.tropicos.org/Name/40031040', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Accepted', 'Inga', 'Mill.', 'genus', 'http://www.tropicos.org/Name/40031040', NULL, 'Fabaceae', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Mill.', 'sp.3', NULL, 'Inga Mill.', true, 'Fabaceae', NULL, 'Inga', NULL, 'Inga sp.3', NULL, NULL, NULL, NULL, 'Inga Mill.', 'accepted', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga sp.3', NULL, NULL, 'Inga', 'Mill.', 'Inga Mill.');
|
|
| 51 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 14, 3, 'Fabaceae Inga sp.3', 0.900000000000000022, 'Inga', 'genus', 1, 'Scop.', 'http://www.tropicos.org/Name/50215121', NULL, NULL, 'Fabaceae', 1, 'Fabaceae', 'Inga', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sp.3', 'Illegitimate', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Inga Scop.', 'sp.3', NULL, 'Inga Scop.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'illegitimate', 'genus', 'Fabaceae', 'Inga', NULL, NULL, 'Inga sp.3', NULL, NULL, 'Inga', 'Scop.', 'Inga Scop.');
|
|
| 52 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 15, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, NULL, ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fagaceae', 0.880000000000000004, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', NULL, 'family', ';http://plants.usda.gov/java/nameSearch', NULL, NULL, 'true', 'tpl;usda', ' ', NULL, false, 'Fagaceae', 'unknown #2', NULL, 'Fagaceae', true, 'Fagaceae', NULL, NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, NULL, NULL, 'Fagaceae', 'accepted', 'family', 'Fagaceae', NULL, NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, 'Fagaceae', NULL, 'Fagaceae');
|
|
| 53 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 16, 4, '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', 'false', 'tropicos', ' ', NULL, true, 'Fabaceae Lindl.', 'unknown #2', NULL, 'Fabaceae Lindl.', true, 'Fabaceae', NULL, NULL, NULL, 'Fabaceae unknown #2', NULL, NULL, NULL, NULL, 'Fabaceae Lindl.', 'accepted', 'family', 'Fabaceae', NULL, NULL, NULL, 'Fabaceae unknown #2', NULL, NULL, 'Fabaceae', 'Lindl.', 'Fabaceae Lindl.');
|
|
| 54 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 17, 4, 'Fabaceae unknown #2', 0.839999999999999969, 'Fagaceae', 'family', 0.939999999999999947, 'Dumort.', 'http://www.tropicos.org/Name/42000062', NULL, NULL, 'Fagaceae', 0.880000000000000004, 'Fagaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fagaceae', 'Dumort.', 'family', 'http://www.tropicos.org/Name/42000062', NULL, 'Fagaceae', 'false', 'tropicos', ' ', NULL, false, 'Fagaceae Dumort.', 'unknown #2', NULL, 'Fagaceae Dumort.', true, 'Fagaceae', NULL, NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, NULL, NULL, 'Fagaceae Dumort.', 'accepted', 'family', 'Fagaceae', NULL, NULL, NULL, 'Fagaceae unknown #2', NULL, NULL, 'Fagaceae', 'Dumort.', 'Fagaceae Dumort.');
|
|
| 55 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 18, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Ficaceae', 'family', 0.770000000000000018, 'Bercht. & J. Presl', 'http://www.tropicos.org/Name/100353631', NULL, NULL, 'Ficaceae', 0.75, 'Ficaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Ficaceae Bercht. & J. Presl', 'unknown #2', NULL, 'Ficaceae Bercht. & J. Presl', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no opinion', 'family', 'Ficaceae', NULL, NULL, NULL, 'Ficaceae unknown #2', NULL, NULL, 'Ficaceae', 'Bercht. & J. Presl', 'Ficaceae Bercht. & J. Presl');
|
|
| 56 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 19, 4, 'Fabaceae unknown #2', 0.67000000000000004, 'Fucaceae', 'family', 0.770000000000000018, NULL, 'http://www.tropicos.org/Name/100371040', NULL, NULL, 'Fucaceae', 0.75, 'Fucaceae', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'No opinion', NULL, NULL, NULL, NULL, NULL, NULL, 'false', 'tropicos', ' ', NULL, false, 'Fucaceae', 'unknown #2', NULL, 'Fucaceae', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'no opinion', 'family', 'Fucaceae', NULL, NULL, NULL, 'Fucaceae unknown #2', NULL, NULL, 'Fucaceae', NULL, 'Fucaceae');
|
|
| 57 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 20, 4, 'Fabaceae unknown #2', 0.900000000000000022, 'Fabaceae', 'family', 1, NULL, 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'Fabaceae', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'unknown #2', 'Accepted', 'Fabaceae', NULL, 'family', 'http://plants.usda.gov/java/nameSearch', NULL, NULL, 'false', 'usda', ' ', NULL, true, 'Fabaceae', 'unknown #2', NULL, 'Fabaceae', true, 'Fabaceae', NULL, NULL, NULL, 'Fabaceae unknown #2', NULL, NULL, NULL, NULL, 'Fabaceae', 'accepted', 'family', 'Fabaceae', NULL, NULL, NULL, 'Fabaceae unknown #2', NULL, NULL, 'Fabaceae', NULL, 'Fabaceae');
|
|
| 58 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 21, 5, '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, NULL, NULL, 'No suitable matches found.', false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'No suitable matches found.', NULL, 'No suitable matches found.');
|
|
| 59 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 22, 6, '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.', NULL, 'Poa annua', 'Poa annua L.', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');
|
|
| 60 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 23, 6, 'Poa annua', 1, 'Poa annua', 'species', 1, 'Cham. & Schltdl.', 'http://www.theplantlist.org/tpl1.1/record/kew-435195', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'false', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua Cham. & Schltdl.', true, 'Poaceae', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');
|
|
| 61 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 24, 7, '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.', NULL, 'Poa annua', 'Poa annua L.', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');
|
|
| 62 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 25, 7, 'Poa annua L.', 0.800000000000000044, 'Poa annua', 'species', 1, 'Cham. & Schltdl.', 'http://www.theplantlist.org/tpl1.1/record/kew-435195', 'Cham. & Schltdl.', 0, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.theplantlist.org/tpl1.1/record/kew-436189', 'Poa infirma', 'Poaceae', 'false', 'tpl', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua Cham. & Schltdl.', true, 'Poaceae', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');
|
|
| 63 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 26, 8, '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.', NULL, 'Poa annua', 'Poa annua fo. lanuginosa Sennen', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');
|
|
| 64 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 27, 8, 'Poa annua fo. lanuginosa', 1, 'Poa annua fo. lanuginosa', 'forma', 1, 'Sennen', 'http://www.tropicos.org/Name/50267771', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'fo.', 'lanuginosa', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua var. annua', NULL, 'variety', 'http://www.tropicos.org/Name/25517736', 'Poa annua', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua var. annua', NULL, 'Poa annua', 'Poa annua fo. lanuginosa Sennen', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', 'var. annua', '{var.,annua}', 'var.', 'annua', 'Poa annua var. annua', 'accepted', 'variety', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', 'var.', 'annua', 'Poa annua var. annua', NULL, 'Poa annua var. annua');
|
|
| 65 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 28, 9, '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', NULL, 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, 'Poaceae', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');
|
|
| 66 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 29, 9, 'Poa annua ssp. exilis', 0.959999999999999964, 'Poa annua var. exilis', 'variety', 0.959999999999999964, 'Tomm. ex Freyn', 'http://www.tropicos.org/Name/25547854', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'exilis', 0.699999999999999956, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua var. exilis Tomm. ex Freyn', true, 'Poaceae', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');
|
|
| 67 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 30, 10, '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', NULL, 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn.) Asch. & Graebn.', true, 'Poaceae', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');
|
|
| 68 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 31, 10, 'Poa annua subsp. exilis', 1, 'Poa annua subsp. exilis', 'subspecies', 1, '(Tomm. ex Freyn) Asch. & Graebn.', 'http://www.tropicos.org/Name/50063800', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'subsp.', 'exilis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa infirma', 'Kunth', 'species', 'http://www.tropicos.org/Name/25514158', 'Poa infirma', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa infirma Kunth', NULL, 'Poa annua', 'Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.', true, 'Poaceae', '{Poa,infirma}', 'Poa', 'infirma', 'Poa infirma', NULL, NULL, NULL, NULL, 'Poa infirma Kunth', 'accepted', 'species', 'Poaceae', 'Poa', 'infirma', 'Poa infirma', 'Poa infirma', NULL, 'infirma', 'Poa infirma', 'Kunth', 'Poa infirma Kunth');
|
|
| 69 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 32, 11, '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.', NULL, 'Poa annua', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', 'subvar. minima', '{subvar.,minima}', 'subvar.', 'minima', 'Poa annua subvar. minima (Schur) Asch. & Graebn.', 'accepted', 'subvariety', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', 'subvar.', 'annua', 'Poa annua subvar. minima', '(Schur) Asch. & Graebn.', 'Poa annua subvar. minima (Schur) Asch. & Graebn.');
|
|
| 70 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 33, 12, '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.', NULL, 'Poa annua', 'Poa annua var. eriolepis ̉ۡ.Desv.', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');
|
|
| 71 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 34, 12, 'Poa annua var. eriolepis', 1, 'Poa annua var. eriolepis', 'variety', 1, 'E. Desv.', 'http://www.tropicos.org/Name/50119145', NULL, NULL, NULL, NULL, 'Poaceae', 'Poa', 1, 'annua', 1, 'var.', 'eriolepis', 1, NULL, NULL, NULL, NULL, NULL, 'Synonym', 'Poa annua', 'L.', 'species', 'http://www.tropicos.org/Name/25509881', 'Poa annua', 'Poaceae', 'false', 'tropicos', ' ', NULL, true, 'Poaceae Poa annua L.', NULL, 'Poa annua', 'Poa annua var. eriolepis E. Desv.', true, 'Poaceae', '{Poa,annua}', 'Poa', 'annua', 'Poa annua', NULL, NULL, NULL, NULL, 'Poa annua L.', 'accepted', 'species', 'Poaceae', 'Poa', 'annua', 'Poa annua', 'Poa annua', NULL, 'annua', 'Poa annua', 'L.', 'Poa annua L.');
|
|
| 72 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 35, 13, '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', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');
|
|
| 73 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 36, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'false', 'tropicos', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');
|
|
| 74 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 37, 13, 'Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://plants.usda.gov/java/profile?symbol=SISCP', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://plants.usda.gov/java/profile?symbol=SISCP', 'Silene scouleri', 'Caryophyllaceae', 'false', 'usda', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'ssp. pringlei', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'Silene scouleri', 'ssp.', 'scouleri', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire');
|
|
| 75 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 38, 14, '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', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subsp.', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');
|
|
| 76 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 39, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://www.tropicos.org/Name/6303627', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://www.tropicos.org/Name/6303627', 'Silene scouleri', 'Caryophyllaceae', 'false', 'tropicos', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'subsp. pringlei', '{subsp.,pringlei}', 'subsp.', 'pringlei', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'Silene scouleri', 'subsp.', 'scouleri', 'Silene scouleri subsp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire');
|
|
| 77 |
INSERT INTO taxon_match VALUES ('2014-07-22 06:48:16.289953-07', 40, 14, 'Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire', 0.770000000000000018, 'Silene scouleri subsp. pringlei', 'subspecies', 0.770000000000000018, '(S. Watson) C.L. Hitchc. & Maguire', 'http://plants.usda.gov/java/profile?symbol=SISCP', NULL, NULL, NULL, NULL, 'Caryophyllaceae', 'Silene', 1, 'scouleri', 1, 'subsp.', 'pringlei', 1, NULL, NULL, NULL, NULL, 'var. grisea', 'Accepted', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'subspecies', 'http://plants.usda.gov/java/profile?symbol=SISCP', 'Silene scouleri', 'Caryophyllaceae', 'false', 'usda', ' [Partial match] ', NULL, true, 'Caryophyllaceae Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'var. grisea', 'Silene scouleri', 'Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire', true, 'Caryophyllaceae', '{Silene,scouleri}', 'Silene', 'scouleri', 'Silene scouleri', 'ssp. pringlei', '{ssp.,pringlei}', 'ssp.', 'pringlei', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire', 'accepted', 'subspecies', 'Caryophyllaceae', 'Silene', 'scouleri', 'Silene scouleri', 'Silene scouleri', 'ssp.', 'scouleri', 'Silene scouleri ssp. pringlei', '(S. Watson) C.L. Hitchc. & Maguire', 'Silene scouleri ssp. pringlei (S. Watson) C.L. Hitchc. & Maguire');
|
|
| 78 | 78 |
|
| 79 | 79 |
|
| 80 | 80 |
-- |
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 210 | 210 |
new."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = NULL; |
| 211 | 211 |
new."[accepted_]infraspecificEpithet__@DwC__@vegpath.org" = NULL; |
| 212 | 212 |
new."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" = NULL; |
| 213 |
new."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" = NULL; |
|
| 213 | 214 |
new."[scrubbed_]taxonRank__@DwC__@vegpath.org" = NULL; |
| 214 | 215 |
new."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" = NULL; |
| 215 | 216 |
new."[scrubbed_]genus__@DwC__@vegpath.org" = NULL; |
| 216 | 217 |
new."[scrubbed_]specificEpithet__@DwC__@vegpath.org" = NULL; |
| 217 | 218 |
new."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" = NULL; |
| 219 |
new."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = NULL; |
|
| 218 | 220 |
new."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = NULL; |
| 219 | 221 |
new."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" = NULL; |
| 220 | 222 |
new."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" = NULL; |
| 221 | 223 |
new."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" = NULL; |
| 222 | 224 |
new."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" = NULL; |
| 223 |
new."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" = NULL; |
|
| 224 |
new."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = NULL; |
|
| 225 | 225 |
|
| 226 | 226 |
-- populate derived cols |
| 227 | 227 |
new."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" = (SELECT "*Unmatched_terms" FROM (SELECT new.*) new); |
| ... | ... | |
| 250 | 250 |
new."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = (SELECT "__accepted_infraspecific_{rank,epithet}"[1] FROM (SELECT new.*) new);
|
| 251 | 251 |
new."[accepted_]infraspecificEpithet__@DwC__@vegpath.org" = (SELECT "__accepted_infraspecific_{rank,epithet}"[2] FROM (SELECT new.*) new);
|
| 252 | 252 |
new."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT "*Accepted_name" || COALESCE((' '::text || "*Accepted_name_author"), ''::text) FROM (SELECT new.*) new);
|
| 253 |
new."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" = (SELECT "TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name") FROM (SELECT new.*) new);
|
|
| 253 | 254 |
new."[scrubbed_]taxonRank__@DwC__@vegpath.org" = (SELECT CASE |
| 254 | 255 |
WHEN matched_has_accepted THEN "*Accepted_name_rank" |
| 255 | 256 |
ELSE "*Name_matched_rank" |
| ... | ... | |
| 270 | 271 |
WHEN matched_has_accepted THEN "*Accepted_name_species" |
| 271 | 272 |
ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" |
| 272 | 273 |
END FROM (SELECT new.*) new); |
| 274 |
new."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = (SELECT CASE |
|
| 275 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = 'family'::text) THEN concat_ws(' '::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 276 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = 'genus'::text) THEN concat_ws(' '::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 277 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 278 |
END FROM (SELECT new.*) new); |
|
| 273 | 279 |
new."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = (SELECT CASE |
| 274 | 280 |
WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" |
| 275 | 281 |
ELSE "*Infraspecific_rank" |
| ... | ... | |
| 290 | 296 |
WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" |
| 291 | 297 |
ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org" |
| 292 | 298 |
END FROM (SELECT new.*) new); |
| 293 |
new."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" = (SELECT "TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name") FROM (SELECT new.*) new);
|
|
| 294 |
new."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = (SELECT CASE |
|
| 295 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = 'family'::text) THEN concat_ws(' '::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 296 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = 'genus'::text) THEN concat_ws(' '::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 297 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 298 |
END FROM (SELECT new.*) new); |
|
| 299 | 299 |
|
| 300 | 300 |
RETURN new; |
| 301 | 301 |
END; |
| ... | ... | |
| 441 | 441 |
"[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" text, |
| 442 | 442 |
"[accepted_]infraspecificEpithet__@DwC__@vegpath.org" text, |
| 443 | 443 |
"[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" text, |
| 444 |
"[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" text, |
|
| 444 | 445 |
"[scrubbed_]taxonRank__@DwC__@vegpath.org" text, |
| 445 | 446 |
"[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| 446 | 447 |
"[scrubbed_]genus__@DwC__@vegpath.org" text, |
| 447 | 448 |
"[scrubbed_]specificEpithet__@DwC__@vegpath.org" text, |
| 448 | 449 |
"[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| 450 |
"[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" text, |
|
| 449 | 451 |
"[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" text, |
| 450 | 452 |
"[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" text, |
| 451 | 453 |
"[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| 452 | 454 |
"[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| 453 | 455 |
"[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" text, |
| 454 |
"[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" text, |
|
| 455 |
"[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" text, |
|
| 456 | 456 |
CONSTRAINT "Accepted_family__@TNRS__@vegpath.org" CHECK ((NOT ("Accepted_family__@TNRS__@vegpath.org" IS DISTINCT FROM COALESCE("*Accepted_name_family",
|
| 457 | 457 |
CASE |
| 458 | 458 |
WHEN ("*Accepted_name_rank" = 'family'::text) THEN "*Accepted_name"
|
| ... | ... | |
| 876 | 876 |
|
| 877 | 877 |
|
| 878 | 878 |
-- |
| 879 |
-- Name: COLUMN taxon_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 880 |
-- |
|
| 881 |
|
|
| 882 |
COMMENT ON COLUMN taxon_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" IS ' |
|
| 883 |
= "TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name")
|
|
| 884 |
|
|
| 885 |
derived column |
|
| 886 |
|
|
| 887 |
to modify expr: |
|
| 888 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]taxonomicStatus__@DwC__@vegpath.org'')::util.col, $$"TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name")$$)::util.derived_col_def);
|
|
| 889 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
|
| 890 |
|
|
| 891 |
to rename: |
|
| 892 |
# rename column |
|
| 893 |
# rename CHECK constraint |
|
| 894 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 895 |
'; |
|
| 896 |
|
|
| 897 |
|
|
| 898 |
-- |
|
| 879 | 899 |
-- Name: COLUMN taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
| 880 | 900 |
-- |
| 881 | 901 |
|
| ... | ... | |
| 1006 | 1026 |
|
| 1007 | 1027 |
|
| 1008 | 1028 |
-- |
| 1029 |
-- Name: COLUMN taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 1030 |
-- |
|
| 1031 |
|
|
| 1032 |
COMMENT ON COLUMN taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS ' |
|
| 1033 |
= CASE |
|
| 1034 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''family''::text) THEN concat_ws('' ''::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 1035 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''genus''::text) THEN concat_ws('' ''::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 1036 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 1037 |
END |
|
| 1038 |
|
|
| 1039 |
derived column |
|
| 1040 |
|
|
| 1041 |
to modify expr: |
|
| 1042 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col, $$CASE
|
|
| 1043 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''family''::text) THEN concat_ws('' ''::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 1044 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''genus''::text) THEN concat_ws('' ''::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 1045 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 1046 |
END$$)::util.derived_col_def); |
|
| 1047 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
|
| 1048 |
|
|
| 1049 |
to rename: |
|
| 1050 |
# rename column |
|
| 1051 |
# rename CHECK constraint |
|
| 1052 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 1053 |
'; |
|
| 1054 |
|
|
| 1055 |
|
|
| 1056 |
-- |
|
| 1009 | 1057 |
-- Name: COLUMN taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
| 1010 | 1058 |
-- |
| 1011 | 1059 |
|
| ... | ... | |
| 1136 | 1184 |
|
| 1137 | 1185 |
|
| 1138 | 1186 |
-- |
| 1139 |
-- Name: COLUMN taxon_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 1140 |
-- |
|
| 1141 |
|
|
| 1142 |
COMMENT ON COLUMN taxon_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" IS ' |
|
| 1143 |
= "TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name")
|
|
| 1144 |
|
|
| 1145 |
derived column |
|
| 1146 |
|
|
| 1147 |
to modify expr: |
|
| 1148 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]taxonomicStatus__@DwC__@vegpath.org'')::util.col, $$"TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name")$$)::util.derived_col_def);
|
|
| 1149 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
|
| 1150 |
|
|
| 1151 |
to rename: |
|
| 1152 |
# rename column |
|
| 1153 |
# rename CHECK constraint |
|
| 1154 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 1155 |
'; |
|
| 1156 |
|
|
| 1157 |
|
|
| 1158 |
-- |
|
| 1159 |
-- Name: COLUMN taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 1160 |
-- |
|
| 1161 |
|
|
| 1162 |
COMMENT ON COLUMN taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS ' |
|
| 1163 |
= CASE |
|
| 1164 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''family''::text) THEN concat_ws('' ''::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 1165 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''genus''::text) THEN concat_ws('' ''::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 1166 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 1167 |
END |
|
| 1168 |
|
|
| 1169 |
derived column |
|
| 1170 |
|
|
| 1171 |
to modify expr: |
|
| 1172 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col, $$CASE
|
|
| 1173 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''family''::text) THEN concat_ws('' ''::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 1174 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''genus''::text) THEN concat_ws('' ''::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 1175 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 1176 |
END$$)::util.derived_col_def); |
|
| 1177 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
|
| 1178 |
|
|
| 1179 |
to rename: |
|
| 1180 |
# rename column |
|
| 1181 |
# rename CHECK constraint |
|
| 1182 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 1183 |
'; |
|
| 1184 |
|
|
| 1185 |
|
|
| 1186 |
-- |
|
| 1187 | 1187 |
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: - |
| 1188 | 1188 |
-- |
| 1189 | 1189 |
|
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 15469 | 15469 |
`[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org` varchar(255), |
| 15470 | 15470 |
`[accepted_]infraspecificEpithet__@DwC__@vegpath.org` varchar(255), |
| 15471 | 15471 |
`[accepted_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255), |
| 15472 |
`[scrubbed_]taxonomicStatus__@DwC__@vegpath.org` varchar(255), |
|
| 15472 | 15473 |
`[scrubbed_]taxonRank__@DwC__@vegpath.org` varchar(255), |
| 15473 | 15474 |
`[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255), |
| 15474 | 15475 |
`[scrubbed_]genus__@DwC__@vegpath.org` varchar(255), |
| 15475 | 15476 |
`[scrubbed_]specificEpithet__@DwC__@vegpath.org` varchar(255), |
| 15476 | 15477 |
`[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255), |
| 15478 |
`[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org` varchar(255), |
|
| 15477 | 15479 |
`[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org` varchar(255), |
| 15478 | 15480 |
`[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org` varchar(255), |
| 15479 | 15481 |
`[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255), |
| 15480 | 15482 |
`[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org` varchar(255), |
| 15481 | 15483 |
`[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255), |
| 15482 |
`[scrubbed_]taxonomicStatus__@DwC__@vegpath.org` varchar(255), |
|
| 15483 |
`[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org` varchar(255), |
|
| 15484 | 15484 |
CASE |
| 15485 | 15485 |
WHEN (`*Accepted_name_rank` = CAST('family' AS varchar(255))) THEN `*Accepted_name`
|
| 15486 | 15486 |
ELSE NULL::varchar(255) |
| ... | ... | |
| 15648 | 15648 |
|
| 15649 | 15649 |
|
| 15650 | 15650 |
-- |
| 15651 |
-- Name: COLUMN taxon_match.`[scrubbed_]taxonRank__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15651 |
-- Name: COLUMN taxon_match.`[scrubbed_]taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15652 | 15652 |
-- |
| 15653 | 15653 |
|
| 15654 | 15654 |
|
| 15655 | 15655 |
|
| 15656 | 15656 |
|
| 15657 | 15657 |
-- |
| 15658 |
-- Name: COLUMN taxon_match.`[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15658 |
-- Name: COLUMN taxon_match.`[scrubbed_]taxonRank__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15659 | 15659 |
-- |
| 15660 | 15660 |
|
| 15661 | 15661 |
|
| 15662 | 15662 |
|
| 15663 | 15663 |
|
| 15664 | 15664 |
-- |
| 15665 |
-- Name: COLUMN taxon_match.`[scrubbed_]genus__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15665 |
-- Name: COLUMN taxon_match.`[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15666 | 15666 |
-- |
| 15667 | 15667 |
|
| 15668 | 15668 |
|
| 15669 | 15669 |
|
| 15670 | 15670 |
|
| 15671 | 15671 |
-- |
| 15672 |
-- Name: COLUMN taxon_match.`[scrubbed_]specificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15672 |
-- Name: COLUMN taxon_match.`[scrubbed_]genus__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15673 | 15673 |
-- |
| 15674 | 15674 |
|
| 15675 | 15675 |
|
| 15676 | 15676 |
|
| 15677 | 15677 |
|
| 15678 | 15678 |
-- |
| 15679 |
-- Name: COLUMN taxon_match.`[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15679 |
-- Name: COLUMN taxon_match.`[scrubbed_]specificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15680 | 15680 |
-- |
| 15681 | 15681 |
|
| 15682 | 15682 |
|
| 15683 | 15683 |
|
| 15684 | 15684 |
|
| 15685 | 15685 |
-- |
| 15686 |
-- Name: COLUMN taxon_match.`[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15686 |
-- Name: COLUMN taxon_match.`[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15687 | 15687 |
-- |
| 15688 | 15688 |
|
| 15689 | 15689 |
|
| 15690 | 15690 |
|
| 15691 | 15691 |
|
| 15692 | 15692 |
-- |
| 15693 |
-- Name: COLUMN taxon_match.`[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15693 |
-- Name: COLUMN taxon_match.`[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15694 | 15694 |
-- |
| 15695 | 15695 |
|
| 15696 | 15696 |
|
| 15697 | 15697 |
|
| 15698 | 15698 |
|
| 15699 | 15699 |
-- |
| 15700 |
-- Name: COLUMN taxon_match.`[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15700 |
-- Name: COLUMN taxon_match.`[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15701 | 15701 |
-- |
| 15702 | 15702 |
|
| 15703 | 15703 |
|
| 15704 | 15704 |
|
| 15705 | 15705 |
|
| 15706 | 15706 |
-- |
| 15707 |
-- Name: COLUMN taxon_match.`[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15707 |
-- Name: COLUMN taxon_match.`[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15708 | 15708 |
-- |
| 15709 | 15709 |
|
| 15710 | 15710 |
|
| 15711 | 15711 |
|
| 15712 | 15712 |
|
| 15713 | 15713 |
-- |
| 15714 |
-- Name: COLUMN taxon_match.`[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15714 |
-- Name: COLUMN taxon_match.`[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15715 | 15715 |
-- |
| 15716 | 15716 |
|
| 15717 | 15717 |
|
| 15718 | 15718 |
|
| 15719 | 15719 |
|
| 15720 | 15720 |
-- |
| 15721 |
-- Name: COLUMN taxon_match.`[scrubbed_]taxonomicStatus__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15721 |
-- Name: COLUMN taxon_match.`[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15722 | 15722 |
-- |
| 15723 | 15723 |
|
| 15724 | 15724 |
|
| 15725 | 15725 |
|
| 15726 | 15726 |
|
| 15727 | 15727 |
-- |
| 15728 |
-- Name: COLUMN taxon_match.`[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15728 |
-- Name: COLUMN taxon_match.`[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org`; Type: COMMENT; Schema: TNRS; Owner: -
|
|
| 15729 | 15729 |
-- |
| 15730 | 15730 |
|
| 15731 | 15731 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19272 | 19272 |
new."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = NULL; |
| 19273 | 19273 |
new."[accepted_]infraspecificEpithet__@DwC__@vegpath.org" = NULL; |
| 19274 | 19274 |
new."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" = NULL; |
| 19275 |
new."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" = NULL; |
|
| 19275 | 19276 |
new."[scrubbed_]taxonRank__@DwC__@vegpath.org" = NULL; |
| 19276 | 19277 |
new."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" = NULL; |
| 19277 | 19278 |
new."[scrubbed_]genus__@DwC__@vegpath.org" = NULL; |
| 19278 | 19279 |
new."[scrubbed_]specificEpithet__@DwC__@vegpath.org" = NULL; |
| 19279 | 19280 |
new."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" = NULL; |
| 19281 |
new."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = NULL; |
|
| 19280 | 19282 |
new."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = NULL; |
| 19281 | 19283 |
new."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" = NULL; |
| 19282 | 19284 |
new."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" = NULL; |
| 19283 | 19285 |
new."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" = NULL; |
| 19284 | 19286 |
new."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" = NULL; |
| 19285 |
new."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" = NULL; |
|
| 19286 |
new."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = NULL; |
|
| 19287 | 19287 |
|
| 19288 | 19288 |
-- populate derived cols |
| 19289 | 19289 |
new."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org" = (SELECT "*Unmatched_terms" FROM (SELECT new.*) new); |
| ... | ... | |
| 19312 | 19312 |
new."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = (SELECT "__accepted_infraspecific_{rank,epithet}"[1] FROM (SELECT new.*) new);
|
| 19313 | 19313 |
new."[accepted_]infraspecificEpithet__@DwC__@vegpath.org" = (SELECT "__accepted_infraspecific_{rank,epithet}"[2] FROM (SELECT new.*) new);
|
| 19314 | 19314 |
new."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" = (SELECT "*Accepted_name" || COALESCE((' '::text || "*Accepted_name_author"), ''::text) FROM (SELECT new.*) new);
|
| 19315 |
new."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" = (SELECT "TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name") FROM (SELECT new.*) new);
|
|
| 19315 | 19316 |
new."[scrubbed_]taxonRank__@DwC__@vegpath.org" = (SELECT CASE |
| 19316 | 19317 |
WHEN matched_has_accepted THEN "*Accepted_name_rank" |
| 19317 | 19318 |
ELSE "*Name_matched_rank" |
| ... | ... | |
| 19332 | 19333 |
WHEN matched_has_accepted THEN "*Accepted_name_species" |
| 19333 | 19334 |
ELSE "[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org" |
| 19334 | 19335 |
END FROM (SELECT new.*) new); |
| 19336 |
new."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = (SELECT CASE |
|
| 19337 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = 'family'::text) THEN concat_ws(' '::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 19338 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = 'genus'::text) THEN concat_ws(' '::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 19339 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 19340 |
END FROM (SELECT new.*) new); |
|
| 19335 | 19341 |
new."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = (SELECT CASE |
| 19336 | 19342 |
WHEN matched_has_accepted THEN "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" |
| 19337 | 19343 |
ELSE "*Infraspecific_rank" |
| ... | ... | |
| 19352 | 19358 |
WHEN matched_has_accepted THEN "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" |
| 19353 | 19359 |
ELSE "[matched_]scientificName[_with_author]__@DwC__@vegpath.org" |
| 19354 | 19360 |
END FROM (SELECT new.*) new); |
| 19355 |
new."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" = (SELECT "TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name") FROM (SELECT new.*) new);
|
|
| 19356 |
new."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = (SELECT CASE |
|
| 19357 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = 'family'::text) THEN concat_ws(' '::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 19358 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = 'genus'::text) THEN concat_ws(' '::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 19359 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 19360 |
END FROM (SELECT new.*) new); |
|
| 19361 | 19361 |
|
| 19362 | 19362 |
RETURN new; |
| 19363 | 19363 |
END; |
| ... | ... | |
| 19545 | 19545 |
"[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" text, |
| 19546 | 19546 |
"[accepted_]infraspecificEpithet__@DwC__@vegpath.org" text, |
| 19547 | 19547 |
"[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" text, |
| 19548 |
"[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" text, |
|
| 19548 | 19549 |
"[scrubbed_]taxonRank__@DwC__@vegpath.org" text, |
| 19549 | 19550 |
"[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| 19550 | 19551 |
"[scrubbed_]genus__@DwC__@vegpath.org" text, |
| 19551 | 19552 |
"[scrubbed_]specificEpithet__@DwC__@vegpath.org" text, |
| 19552 | 19553 |
"[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| 19554 |
"[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" text, |
|
| 19553 | 19555 |
"[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" text, |
| 19554 | 19556 |
"[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org" text, |
| 19555 | 19557 |
"[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| 19556 | 19558 |
"[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org" text, |
| 19557 | 19559 |
"[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" text, |
| 19558 |
"[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" text, |
|
| 19559 |
"[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" text, |
|
| 19560 | 19560 |
CONSTRAINT "Accepted_family__@TNRS__@vegpath.org" CHECK ((NOT ("Accepted_family__@TNRS__@vegpath.org" IS DISTINCT FROM COALESCE("*Accepted_name_family",
|
| 19561 | 19561 |
CASE |
| 19562 | 19562 |
WHEN ("*Accepted_name_rank" = 'family'::text) THEN "*Accepted_name"
|
| ... | ... | |
| 19980 | 19980 |
|
| 19981 | 19981 |
|
| 19982 | 19982 |
-- |
| 19983 |
-- Name: COLUMN taxon_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 19984 |
-- |
|
| 19985 |
|
|
| 19986 |
COMMENT ON COLUMN taxon_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" IS ' |
|
| 19987 |
= "TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name")
|
|
| 19988 |
|
|
| 19989 |
derived column |
|
| 19990 |
|
|
| 19991 |
to modify expr: |
|
| 19992 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]taxonomicStatus__@DwC__@vegpath.org'')::util.col, $$"TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name")$$)::util.derived_col_def);
|
|
| 19993 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
|
| 19994 |
|
|
| 19995 |
to rename: |
|
| 19996 |
# rename column |
|
| 19997 |
# rename CHECK constraint |
|
| 19998 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 19999 |
'; |
|
| 20000 |
|
|
| 20001 |
|
|
| 20002 |
-- |
|
| 19983 | 20003 |
-- Name: COLUMN taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
| 19984 | 20004 |
-- |
| 19985 | 20005 |
|
| ... | ... | |
| 20110 | 20130 |
|
| 20111 | 20131 |
|
| 20112 | 20132 |
-- |
| 20133 |
-- Name: COLUMN taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 20134 |
-- |
|
| 20135 |
|
|
| 20136 |
COMMENT ON COLUMN taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS ' |
|
| 20137 |
= CASE |
|
| 20138 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''family''::text) THEN concat_ws('' ''::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 20139 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''genus''::text) THEN concat_ws('' ''::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 20140 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 20141 |
END |
|
| 20142 |
|
|
| 20143 |
derived column |
|
| 20144 |
|
|
| 20145 |
to modify expr: |
|
| 20146 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col, $$CASE
|
|
| 20147 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''family''::text) THEN concat_ws('' ''::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 20148 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''genus''::text) THEN concat_ws('' ''::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 20149 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 20150 |
END$$)::util.derived_col_def); |
|
| 20151 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
|
| 20152 |
|
|
| 20153 |
to rename: |
|
| 20154 |
# rename column |
|
| 20155 |
# rename CHECK constraint |
|
| 20156 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 20157 |
'; |
|
| 20158 |
|
|
| 20159 |
|
|
| 20160 |
-- |
|
| 20113 | 20161 |
-- Name: COLUMN taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
| 20114 | 20162 |
-- |
| 20115 | 20163 |
|
| ... | ... | |
| 20240 | 20288 |
|
| 20241 | 20289 |
|
| 20242 | 20290 |
-- |
| 20243 |
-- Name: COLUMN taxon_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 20244 |
-- |
|
| 20245 |
|
|
| 20246 |
COMMENT ON COLUMN taxon_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" IS ' |
|
| 20247 |
= "TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name")
|
|
| 20248 |
|
|
| 20249 |
derived column |
|
| 20250 |
|
|
| 20251 |
to modify expr: |
|
| 20252 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]taxonomicStatus__@DwC__@vegpath.org'')::util.col, $$"TNRS".map_taxonomic_status("*Taxonomic_status", "*Accepted_name")$$)::util.derived_col_def);
|
|
| 20253 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
|
| 20254 |
|
|
| 20255 |
to rename: |
|
| 20256 |
# rename column |
|
| 20257 |
# rename CHECK constraint |
|
| 20258 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 20259 |
'; |
|
| 20260 |
|
|
| 20261 |
|
|
| 20262 |
-- |
|
| 20263 |
-- Name: COLUMN taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: - |
|
| 20264 |
-- |
|
| 20265 |
|
|
| 20266 |
COMMENT ON COLUMN taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS ' |
|
| 20267 |
= CASE |
|
| 20268 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''family''::text) THEN concat_ws('' ''::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 20269 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''genus''::text) THEN concat_ws('' ''::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 20270 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 20271 |
END |
|
| 20272 |
|
|
| 20273 |
derived column |
|
| 20274 |
|
|
| 20275 |
to modify expr: |
|
| 20276 |
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org'')::util.col, $$CASE
|
|
| 20277 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''family''::text) THEN concat_ws('' ''::text, "[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 20278 |
WHEN ("[scrubbed_]taxonRank__@DwC__@vegpath.org" = ''genus''::text) THEN concat_ws('' ''::text, "[scrubbed_]genus__@DwC__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
|
|
| 20279 |
ELSE "[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org" |
|
| 20280 |
END$$)::util.derived_col_def); |
|
| 20281 |
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);
|
|
| 20282 |
|
|
| 20283 |
to rename: |
|
| 20284 |
# rename column |
|
| 20285 |
# rename CHECK constraint |
|
| 20286 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''::regclass);
|
|
| 20287 |
'; |
|
| 20288 |
|
|
| 20289 |
|
|
| 20290 |
-- |
|
| 20291 | 20291 |
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: - |
| 20292 | 20292 |
-- |
| 20293 | 20293 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: reordered derived columns in dependency order