Revision 14426
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 1489 | 1489 |
taxon_best_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", |
| 1490 | 1490 |
taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
| 1491 | 1491 |
taxon_best_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
| 1492 |
taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1493 |
CASE |
|
| 1494 |
WHEN true THEN taxon_best_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" |
|
| 1495 |
ELSE NULL::text |
|
| 1496 |
END AS "taxonomicStatus", |
|
| 1497 |
CASE |
|
| 1498 |
WHEN true THEN taxon_best_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" |
|
| 1499 |
ELSE NULL::text |
|
| 1500 |
END AS accepted_morphospecies_binomial |
|
| 1492 |
taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" |
|
| 1501 | 1493 |
FROM taxon_best_match; |
| 1502 | 1494 |
|
| 1503 | 1495 |
|
| ... | ... | |
| 1584 | 1576 |
"MatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", |
| 1585 | 1577 |
"MatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
| 1586 | 1578 |
"MatchedTaxon"."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
| 1587 |
"MatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1588 |
"MatchedTaxon"."taxonomicStatus", |
|
| 1589 |
"MatchedTaxon".accepted_morphospecies_binomial |
|
| 1579 |
"MatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" |
|
| 1590 | 1580 |
FROM "MatchedTaxon" |
| 1591 | 1581 |
WHERE "MatchedTaxon".is_valid_match; |
| 1592 | 1582 |
|
| ... | ... | |
| 1784 | 1774 |
-- |
| 1785 | 1775 |
|
| 1786 | 1776 |
CREATE VIEW taxon_scrub AS |
| 1787 |
SELECT "ValidMatchedTaxon".scrubbed_unique_taxon_name, |
|
| 1788 |
"ValidMatchedTaxon".batch, |
|
| 1777 |
SELECT "ValidMatchedTaxon".batch, |
|
| 1789 | 1778 |
"ValidMatchedTaxon".match_num, |
| 1790 | 1779 |
"ValidMatchedTaxon"."*Name_number", |
| 1791 | 1780 |
"ValidMatchedTaxon"."*Name_submitted", |
| ... | ... | |
| 1824 | 1813 |
"ValidMatchedTaxon"."*Warnings", |
| 1825 | 1814 |
"ValidMatchedTaxon"."*Accepted_name_lsid", |
| 1826 | 1815 |
"ValidMatchedTaxon".is_valid_match, |
| 1816 |
"ValidMatchedTaxon".scrubbed_unique_taxon_name, |
|
| 1827 | 1817 |
"ValidMatchedTaxon"."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org", |
| 1828 | 1818 |
"ValidMatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", |
| 1829 | 1819 |
"ValidMatchedTaxon"."matched~Name[_no_author]___@TNRS__@vegpath.org", |
| ... | ... | |
| 1851 | 1841 |
"ValidMatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
| 1852 | 1842 |
"ValidMatchedTaxon"."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
| 1853 | 1843 |
"ValidMatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
| 1854 |
"ValidMatchedTaxon"."taxonomicStatus", |
|
| 1855 |
"ValidMatchedTaxon".accepted_morphospecies_binomial, |
|
| 1856 | 1844 |
CASE |
| 1857 | 1845 |
WHEN true THEN "ValidMatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org" |
| 1858 | 1846 |
ELSE NULL::text |
| trunk/schemas/public_.sql | ||
|---|---|---|
| 8448 | 8448 |
taxon_scrub."*Name_matched" AS "Name_matched__@TNRS__@vegpath.org", |
| 8449 | 8449 |
taxon_scrub."*Name_matched_author" AS "Name_matched_author__@TNRS__@vegpath.org", |
| 8450 | 8450 |
family_higher_plant_group.higher_plant_group AS "[higher_plant_group~]higherClassification__@DwC__@vegpath.org", |
| 8451 |
taxon_scrub."taxonomicStatus" AS "taxonomicStatus__@DwC__@vegpath.org",
|
|
| 8451 |
taxon_scrub."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" AS "taxonomicStatus__@DwC__@vegpath.org",
|
|
| 8452 | 8452 |
taxon_scrub.scrubbed_family, |
| 8453 | 8453 |
taxon_scrub.scrubbed_genus, |
| 8454 | 8454 |
taxon_scrub.scrubbed_specific_epithet, |
| ... | ... | |
| 12439 | 12439 |
CREATE VIEW _plots_20_tnrs_names AS |
| 12440 | 12440 |
SELECT taxonverbatim.taxonomicname AS verbatim_name_with_author, |
| 12441 | 12441 |
taxonlabel.taxonomicname AS tnrs_input_name, |
| 12442 |
taxon_scrub."taxonomicStatus" AS tnrs_taxonomic_status,
|
|
| 12442 |
taxon_scrub."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" AS tnrs_taxonomic_status,
|
|
| 12443 | 12443 |
taxon_scrub."*Accepted_name_family" AS tnrs_accepted_name_family, |
| 12444 | 12444 |
taxon_scrub."*Accepted_name" AS tnrs_accepted_name, |
| 12445 | 12445 |
taxon_scrub."*Accepted_name_author" AS tnrs_accepted_name_author, |
| 12446 |
taxon_scrub.accepted_morphospecies_binomial AS taxon_morphospecies
|
|
| 12446 |
taxon_scrub."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" AS taxon_morphospecies
|
|
| 12447 | 12447 |
FROM ((public.taxonverbatim |
| 12448 | 12448 |
JOIN public.taxonlabel USING (taxonlabel_id)) |
| 12449 | 12449 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."*Name_submitted" = taxonlabel.taxonomicname))) |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 8448 | 8448 |
taxon_scrub."*Name_matched" AS "Name_matched__@TNRS__@vegpath.org", |
| 8449 | 8449 |
taxon_scrub."*Name_matched_author" AS "Name_matched_author__@TNRS__@vegpath.org", |
| 8450 | 8450 |
family_higher_plant_group.higher_plant_group AS "[higher_plant_group~]higherClassification__@DwC__@vegpath.org", |
| 8451 |
taxon_scrub."taxonomicStatus" AS "taxonomicStatus__@DwC__@vegpath.org",
|
|
| 8451 |
taxon_scrub."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" AS "taxonomicStatus__@DwC__@vegpath.org",
|
|
| 8452 | 8452 |
taxon_scrub.scrubbed_family, |
| 8453 | 8453 |
taxon_scrub.scrubbed_genus, |
| 8454 | 8454 |
taxon_scrub.scrubbed_specific_epithet, |
| ... | ... | |
| 12439 | 12439 |
CREATE VIEW _plots_20_tnrs_names AS |
| 12440 | 12440 |
SELECT taxonverbatim.taxonomicname AS verbatim_name_with_author, |
| 12441 | 12441 |
taxonlabel.taxonomicname AS tnrs_input_name, |
| 12442 |
taxon_scrub."taxonomicStatus" AS tnrs_taxonomic_status,
|
|
| 12442 |
taxon_scrub."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" AS tnrs_taxonomic_status,
|
|
| 12443 | 12443 |
taxon_scrub."*Accepted_name_family" AS tnrs_accepted_name_family, |
| 12444 | 12444 |
taxon_scrub."*Accepted_name" AS tnrs_accepted_name, |
| 12445 | 12445 |
taxon_scrub."*Accepted_name_author" AS tnrs_accepted_name_author, |
| 12446 |
taxon_scrub.accepted_morphospecies_binomial AS taxon_morphospecies
|
|
| 12446 |
taxon_scrub."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" AS taxon_morphospecies
|
|
| 12447 | 12447 |
FROM ((public.taxonverbatim |
| 12448 | 12448 |
JOIN public.taxonlabel USING (taxonlabel_id)) |
| 12449 | 12449 |
JOIN "TNRS".taxon_scrub ON ((taxon_scrub."*Name_submitted" = taxonlabel.taxonomicname))) |
| ... | ... | |
| 21411 | 21411 |
taxon_best_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", |
| 21412 | 21412 |
taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
| 21413 | 21413 |
taxon_best_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
| 21414 |
taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 21415 |
CASE |
|
| 21416 |
WHEN true THEN taxon_best_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org" |
|
| 21417 |
ELSE NULL::text |
|
| 21418 |
END AS "taxonomicStatus", |
|
| 21419 |
CASE |
|
| 21420 |
WHEN true THEN taxon_best_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" |
|
| 21421 |
ELSE NULL::text |
|
| 21422 |
END AS accepted_morphospecies_binomial |
|
| 21414 |
taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" |
|
| 21423 | 21415 |
FROM taxon_best_match; |
| 21424 | 21416 |
|
| 21425 | 21417 |
|
| ... | ... | |
| 21506 | 21498 |
"MatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", |
| 21507 | 21499 |
"MatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
| 21508 | 21500 |
"MatchedTaxon"."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
| 21509 |
"MatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 21510 |
"MatchedTaxon"."taxonomicStatus", |
|
| 21511 |
"MatchedTaxon".accepted_morphospecies_binomial |
|
| 21501 |
"MatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" |
|
| 21512 | 21502 |
FROM "MatchedTaxon" |
| 21513 | 21503 |
WHERE "MatchedTaxon".is_valid_match; |
| 21514 | 21504 |
|
| ... | ... | |
| 21706 | 21696 |
-- |
| 21707 | 21697 |
|
| 21708 | 21698 |
CREATE VIEW taxon_scrub AS |
| 21709 |
SELECT "ValidMatchedTaxon".scrubbed_unique_taxon_name, |
|
| 21710 |
"ValidMatchedTaxon".batch, |
|
| 21699 |
SELECT "ValidMatchedTaxon".batch, |
|
| 21711 | 21700 |
"ValidMatchedTaxon".match_num, |
| 21712 | 21701 |
"ValidMatchedTaxon"."*Name_number", |
| 21713 | 21702 |
"ValidMatchedTaxon"."*Name_submitted", |
| ... | ... | |
| 21746 | 21735 |
"ValidMatchedTaxon"."*Warnings", |
| 21747 | 21736 |
"ValidMatchedTaxon"."*Accepted_name_lsid", |
| 21748 | 21737 |
"ValidMatchedTaxon".is_valid_match, |
| 21738 |
"ValidMatchedTaxon".scrubbed_unique_taxon_name, |
|
| 21749 | 21739 |
"ValidMatchedTaxon"."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org", |
| 21750 | 21740 |
"ValidMatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", |
| 21751 | 21741 |
"ValidMatchedTaxon"."matched~Name[_no_author]___@TNRS__@vegpath.org", |
| ... | ... | |
| 21773 | 21763 |
"ValidMatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
| 21774 | 21764 |
"ValidMatchedTaxon"."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
| 21775 | 21765 |
"ValidMatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
| 21776 |
"ValidMatchedTaxon"."taxonomicStatus", |
|
| 21777 |
"ValidMatchedTaxon".accepted_morphospecies_binomial, |
|
| 21778 | 21766 |
CASE |
| 21779 | 21767 |
WHEN true THEN "ValidMatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org" |
| 21780 | 21768 |
ELSE NULL::text |
Also available in: Unified diff
fix: inputs/.TNRS/schema.sql: MatchedTaxon: merged synonymous columns