Revision 14430
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 1510 | 1510 |
-- |
| 1511 | 1511 |
|
| 1512 | 1512 |
CREATE VIEW "ValidMatchedTaxon" AS |
| 1513 |
SELECT "MatchedTaxon".batch,
|
|
| 1514 |
"MatchedTaxon".match_num,
|
|
| 1515 |
"MatchedTaxon"."*Name_number",
|
|
| 1516 |
"MatchedTaxon"."*Name_submitted",
|
|
| 1517 |
"MatchedTaxon"."*Overall_score",
|
|
| 1518 |
"MatchedTaxon"."*Name_matched",
|
|
| 1519 |
"MatchedTaxon"."*Name_matched_rank",
|
|
| 1520 |
"MatchedTaxon"."*Name_score",
|
|
| 1521 |
"MatchedTaxon"."*Name_matched_author",
|
|
| 1522 |
"MatchedTaxon"."*Name_matched_url",
|
|
| 1523 |
"MatchedTaxon"."*Author_matched",
|
|
| 1524 |
"MatchedTaxon"."*Author_score",
|
|
| 1525 |
"MatchedTaxon"."*Family_matched",
|
|
| 1526 |
"MatchedTaxon"."*Family_score",
|
|
| 1527 |
"MatchedTaxon"."*Name_matched_accepted_family",
|
|
| 1528 |
"MatchedTaxon"."*Genus_matched",
|
|
| 1529 |
"MatchedTaxon"."*Genus_score",
|
|
| 1530 |
"MatchedTaxon"."*Specific_epithet_matched",
|
|
| 1531 |
"MatchedTaxon"."*Specific_epithet_score",
|
|
| 1532 |
"MatchedTaxon"."*Infraspecific_rank",
|
|
| 1533 |
"MatchedTaxon"."*Infraspecific_epithet_matched",
|
|
| 1534 |
"MatchedTaxon"."*Infraspecific_epithet_score",
|
|
| 1535 |
"MatchedTaxon"."*Infraspecific_rank_2",
|
|
| 1536 |
"MatchedTaxon"."*Infraspecific_epithet_2_matched",
|
|
| 1537 |
"MatchedTaxon"."*Infraspecific_epithet_2_score",
|
|
| 1538 |
"MatchedTaxon"."*Annotations",
|
|
| 1539 |
"MatchedTaxon"."*Unmatched_terms",
|
|
| 1540 |
"MatchedTaxon"."*Taxonomic_status",
|
|
| 1541 |
"MatchedTaxon"."*Accepted_name",
|
|
| 1542 |
"MatchedTaxon"."*Accepted_name_author",
|
|
| 1543 |
"MatchedTaxon"."*Accepted_name_rank",
|
|
| 1544 |
"MatchedTaxon"."*Accepted_name_url",
|
|
| 1545 |
"MatchedTaxon"."*Accepted_name_species",
|
|
| 1546 |
"MatchedTaxon"."*Accepted_name_family",
|
|
| 1547 |
"MatchedTaxon"."*Selected",
|
|
| 1548 |
"MatchedTaxon"."*Source",
|
|
| 1549 |
"MatchedTaxon"."*Warnings",
|
|
| 1550 |
"MatchedTaxon"."*Accepted_name_lsid",
|
|
| 1551 |
"MatchedTaxon".is_valid_match,
|
|
| 1552 |
"MatchedTaxon".scrubbed_unique_taxon_name,
|
|
| 1553 |
"MatchedTaxon"."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",
|
|
| 1554 |
"MatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 1555 |
"MatchedTaxon"."matched~Name[_no_author]___@TNRS__@vegpath.org",
|
|
| 1556 |
"MatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",
|
|
| 1557 |
"MatchedTaxon".matched_has_accepted,
|
|
| 1558 |
"MatchedTaxon"."Accepted_family__@TNRS__@vegpath.org",
|
|
| 1559 |
"MatchedTaxon"."Accepted_species[_binomial]__@TNRS__@vegpath.org",
|
|
| 1560 |
"MatchedTaxon"."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",
|
|
| 1561 |
"MatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org",
|
|
| 1562 |
"MatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org",
|
|
| 1563 |
"MatchedTaxon"."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
|
|
| 1564 |
"MatchedTaxon"."__accepted_infraspecific_{rank,epithet}",
|
|
| 1565 |
"MatchedTaxon"."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
|
|
| 1566 |
"MatchedTaxon"."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",
|
|
| 1567 |
"MatchedTaxon"."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",
|
|
| 1568 |
"MatchedTaxon"."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",
|
|
| 1569 |
"MatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org",
|
|
| 1570 |
"MatchedTaxon"."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 1571 |
"MatchedTaxon"."[scrubbed_]genus__@DwC__@vegpath.org",
|
|
| 1572 |
"MatchedTaxon"."[scrubbed_]specificEpithet__@DwC__@vegpath.org",
|
|
| 1573 |
"MatchedTaxon"."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 1574 |
"MatchedTaxon"."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
|
|
| 1575 |
"MatchedTaxon"."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
|
|
| 1576 |
"MatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",
|
|
| 1577 |
"MatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 1578 |
"MatchedTaxon"."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 1579 |
"MatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org"
|
|
| 1580 |
FROM "MatchedTaxon"
|
|
| 1581 |
WHERE "MatchedTaxon".is_valid_match;
|
|
| 1513 |
SELECT taxon_best_match.batch,
|
|
| 1514 |
taxon_best_match.match_num,
|
|
| 1515 |
taxon_best_match."*Name_number",
|
|
| 1516 |
taxon_best_match."*Name_submitted",
|
|
| 1517 |
taxon_best_match."*Overall_score",
|
|
| 1518 |
taxon_best_match."*Name_matched",
|
|
| 1519 |
taxon_best_match."*Name_matched_rank",
|
|
| 1520 |
taxon_best_match."*Name_score",
|
|
| 1521 |
taxon_best_match."*Name_matched_author",
|
|
| 1522 |
taxon_best_match."*Name_matched_url",
|
|
| 1523 |
taxon_best_match."*Author_matched",
|
|
| 1524 |
taxon_best_match."*Author_score",
|
|
| 1525 |
taxon_best_match."*Family_matched",
|
|
| 1526 |
taxon_best_match."*Family_score",
|
|
| 1527 |
taxon_best_match."*Name_matched_accepted_family",
|
|
| 1528 |
taxon_best_match."*Genus_matched",
|
|
| 1529 |
taxon_best_match."*Genus_score",
|
|
| 1530 |
taxon_best_match."*Specific_epithet_matched",
|
|
| 1531 |
taxon_best_match."*Specific_epithet_score",
|
|
| 1532 |
taxon_best_match."*Infraspecific_rank",
|
|
| 1533 |
taxon_best_match."*Infraspecific_epithet_matched",
|
|
| 1534 |
taxon_best_match."*Infraspecific_epithet_score",
|
|
| 1535 |
taxon_best_match."*Infraspecific_rank_2",
|
|
| 1536 |
taxon_best_match."*Infraspecific_epithet_2_matched",
|
|
| 1537 |
taxon_best_match."*Infraspecific_epithet_2_score",
|
|
| 1538 |
taxon_best_match."*Annotations",
|
|
| 1539 |
taxon_best_match."*Unmatched_terms",
|
|
| 1540 |
taxon_best_match."*Taxonomic_status",
|
|
| 1541 |
taxon_best_match."*Accepted_name",
|
|
| 1542 |
taxon_best_match."*Accepted_name_author",
|
|
| 1543 |
taxon_best_match."*Accepted_name_rank",
|
|
| 1544 |
taxon_best_match."*Accepted_name_url",
|
|
| 1545 |
taxon_best_match."*Accepted_name_species",
|
|
| 1546 |
taxon_best_match."*Accepted_name_family",
|
|
| 1547 |
taxon_best_match."*Selected",
|
|
| 1548 |
taxon_best_match."*Source",
|
|
| 1549 |
taxon_best_match."*Warnings",
|
|
| 1550 |
taxon_best_match."*Accepted_name_lsid",
|
|
| 1551 |
taxon_best_match.is_valid_match,
|
|
| 1552 |
taxon_best_match.scrubbed_unique_taxon_name,
|
|
| 1553 |
taxon_best_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",
|
|
| 1554 |
taxon_best_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 1555 |
taxon_best_match."matched~Name[_no_author]___@TNRS__@vegpath.org",
|
|
| 1556 |
taxon_best_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",
|
|
| 1557 |
taxon_best_match.matched_has_accepted,
|
|
| 1558 |
taxon_best_match."Accepted_family__@TNRS__@vegpath.org",
|
|
| 1559 |
taxon_best_match."Accepted_species[_binomial]__@TNRS__@vegpath.org",
|
|
| 1560 |
taxon_best_match."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",
|
|
| 1561 |
taxon_best_match."[accepted_]genus__@DwC__@vegpath.org",
|
|
| 1562 |
taxon_best_match."[accepted_]specificEpithet__@DwC__@vegpath.org",
|
|
| 1563 |
taxon_best_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
|
|
| 1564 |
taxon_best_match."__accepted_infraspecific_{rank,epithet}",
|
|
| 1565 |
taxon_best_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
|
|
| 1566 |
taxon_best_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",
|
|
| 1567 |
taxon_best_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",
|
|
| 1568 |
taxon_best_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",
|
|
| 1569 |
taxon_best_match."[scrubbed_]taxonRank__@DwC__@vegpath.org",
|
|
| 1570 |
taxon_best_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 1571 |
taxon_best_match."[scrubbed_]genus__@DwC__@vegpath.org",
|
|
| 1572 |
taxon_best_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org",
|
|
| 1573 |
taxon_best_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 1574 |
taxon_best_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
|
|
| 1575 |
taxon_best_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
|
|
| 1576 |
taxon_best_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",
|
|
| 1577 |
taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 1578 |
taxon_best_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 1579 |
taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org"
|
|
| 1580 |
FROM taxon_best_match
|
|
| 1581 |
WHERE taxon_best_match.is_valid_match;
|
|
| 1582 | 1582 |
|
| 1583 | 1583 |
|
| 1584 | 1584 |
-- |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 21432 | 21432 |
-- |
| 21433 | 21433 |
|
| 21434 | 21434 |
CREATE VIEW "ValidMatchedTaxon" AS |
| 21435 |
SELECT "MatchedTaxon".batch,
|
|
| 21436 |
"MatchedTaxon".match_num,
|
|
| 21437 |
"MatchedTaxon"."*Name_number",
|
|
| 21438 |
"MatchedTaxon"."*Name_submitted",
|
|
| 21439 |
"MatchedTaxon"."*Overall_score",
|
|
| 21440 |
"MatchedTaxon"."*Name_matched",
|
|
| 21441 |
"MatchedTaxon"."*Name_matched_rank",
|
|
| 21442 |
"MatchedTaxon"."*Name_score",
|
|
| 21443 |
"MatchedTaxon"."*Name_matched_author",
|
|
| 21444 |
"MatchedTaxon"."*Name_matched_url",
|
|
| 21445 |
"MatchedTaxon"."*Author_matched",
|
|
| 21446 |
"MatchedTaxon"."*Author_score",
|
|
| 21447 |
"MatchedTaxon"."*Family_matched",
|
|
| 21448 |
"MatchedTaxon"."*Family_score",
|
|
| 21449 |
"MatchedTaxon"."*Name_matched_accepted_family",
|
|
| 21450 |
"MatchedTaxon"."*Genus_matched",
|
|
| 21451 |
"MatchedTaxon"."*Genus_score",
|
|
| 21452 |
"MatchedTaxon"."*Specific_epithet_matched",
|
|
| 21453 |
"MatchedTaxon"."*Specific_epithet_score",
|
|
| 21454 |
"MatchedTaxon"."*Infraspecific_rank",
|
|
| 21455 |
"MatchedTaxon"."*Infraspecific_epithet_matched",
|
|
| 21456 |
"MatchedTaxon"."*Infraspecific_epithet_score",
|
|
| 21457 |
"MatchedTaxon"."*Infraspecific_rank_2",
|
|
| 21458 |
"MatchedTaxon"."*Infraspecific_epithet_2_matched",
|
|
| 21459 |
"MatchedTaxon"."*Infraspecific_epithet_2_score",
|
|
| 21460 |
"MatchedTaxon"."*Annotations",
|
|
| 21461 |
"MatchedTaxon"."*Unmatched_terms",
|
|
| 21462 |
"MatchedTaxon"."*Taxonomic_status",
|
|
| 21463 |
"MatchedTaxon"."*Accepted_name",
|
|
| 21464 |
"MatchedTaxon"."*Accepted_name_author",
|
|
| 21465 |
"MatchedTaxon"."*Accepted_name_rank",
|
|
| 21466 |
"MatchedTaxon"."*Accepted_name_url",
|
|
| 21467 |
"MatchedTaxon"."*Accepted_name_species",
|
|
| 21468 |
"MatchedTaxon"."*Accepted_name_family",
|
|
| 21469 |
"MatchedTaxon"."*Selected",
|
|
| 21470 |
"MatchedTaxon"."*Source",
|
|
| 21471 |
"MatchedTaxon"."*Warnings",
|
|
| 21472 |
"MatchedTaxon"."*Accepted_name_lsid",
|
|
| 21473 |
"MatchedTaxon".is_valid_match,
|
|
| 21474 |
"MatchedTaxon".scrubbed_unique_taxon_name,
|
|
| 21475 |
"MatchedTaxon"."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",
|
|
| 21476 |
"MatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 21477 |
"MatchedTaxon"."matched~Name[_no_author]___@TNRS__@vegpath.org",
|
|
| 21478 |
"MatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",
|
|
| 21479 |
"MatchedTaxon".matched_has_accepted,
|
|
| 21480 |
"MatchedTaxon"."Accepted_family__@TNRS__@vegpath.org",
|
|
| 21481 |
"MatchedTaxon"."Accepted_species[_binomial]__@TNRS__@vegpath.org",
|
|
| 21482 |
"MatchedTaxon"."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",
|
|
| 21483 |
"MatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org",
|
|
| 21484 |
"MatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org",
|
|
| 21485 |
"MatchedTaxon"."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
|
|
| 21486 |
"MatchedTaxon"."__accepted_infraspecific_{rank,epithet}",
|
|
| 21487 |
"MatchedTaxon"."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
|
|
| 21488 |
"MatchedTaxon"."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",
|
|
| 21489 |
"MatchedTaxon"."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",
|
|
| 21490 |
"MatchedTaxon"."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",
|
|
| 21491 |
"MatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org",
|
|
| 21492 |
"MatchedTaxon"."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 21493 |
"MatchedTaxon"."[scrubbed_]genus__@DwC__@vegpath.org",
|
|
| 21494 |
"MatchedTaxon"."[scrubbed_]specificEpithet__@DwC__@vegpath.org",
|
|
| 21495 |
"MatchedTaxon"."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 21496 |
"MatchedTaxon"."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
|
|
| 21497 |
"MatchedTaxon"."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
|
|
| 21498 |
"MatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",
|
|
| 21499 |
"MatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 21500 |
"MatchedTaxon"."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 21501 |
"MatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org"
|
|
| 21502 |
FROM "MatchedTaxon"
|
|
| 21503 |
WHERE "MatchedTaxon".is_valid_match;
|
|
| 21435 |
SELECT taxon_best_match.batch,
|
|
| 21436 |
taxon_best_match.match_num,
|
|
| 21437 |
taxon_best_match."*Name_number",
|
|
| 21438 |
taxon_best_match."*Name_submitted",
|
|
| 21439 |
taxon_best_match."*Overall_score",
|
|
| 21440 |
taxon_best_match."*Name_matched",
|
|
| 21441 |
taxon_best_match."*Name_matched_rank",
|
|
| 21442 |
taxon_best_match."*Name_score",
|
|
| 21443 |
taxon_best_match."*Name_matched_author",
|
|
| 21444 |
taxon_best_match."*Name_matched_url",
|
|
| 21445 |
taxon_best_match."*Author_matched",
|
|
| 21446 |
taxon_best_match."*Author_score",
|
|
| 21447 |
taxon_best_match."*Family_matched",
|
|
| 21448 |
taxon_best_match."*Family_score",
|
|
| 21449 |
taxon_best_match."*Name_matched_accepted_family",
|
|
| 21450 |
taxon_best_match."*Genus_matched",
|
|
| 21451 |
taxon_best_match."*Genus_score",
|
|
| 21452 |
taxon_best_match."*Specific_epithet_matched",
|
|
| 21453 |
taxon_best_match."*Specific_epithet_score",
|
|
| 21454 |
taxon_best_match."*Infraspecific_rank",
|
|
| 21455 |
taxon_best_match."*Infraspecific_epithet_matched",
|
|
| 21456 |
taxon_best_match."*Infraspecific_epithet_score",
|
|
| 21457 |
taxon_best_match."*Infraspecific_rank_2",
|
|
| 21458 |
taxon_best_match."*Infraspecific_epithet_2_matched",
|
|
| 21459 |
taxon_best_match."*Infraspecific_epithet_2_score",
|
|
| 21460 |
taxon_best_match."*Annotations",
|
|
| 21461 |
taxon_best_match."*Unmatched_terms",
|
|
| 21462 |
taxon_best_match."*Taxonomic_status",
|
|
| 21463 |
taxon_best_match."*Accepted_name",
|
|
| 21464 |
taxon_best_match."*Accepted_name_author",
|
|
| 21465 |
taxon_best_match."*Accepted_name_rank",
|
|
| 21466 |
taxon_best_match."*Accepted_name_url",
|
|
| 21467 |
taxon_best_match."*Accepted_name_species",
|
|
| 21468 |
taxon_best_match."*Accepted_name_family",
|
|
| 21469 |
taxon_best_match."*Selected",
|
|
| 21470 |
taxon_best_match."*Source",
|
|
| 21471 |
taxon_best_match."*Warnings",
|
|
| 21472 |
taxon_best_match."*Accepted_name_lsid",
|
|
| 21473 |
taxon_best_match.is_valid_match,
|
|
| 21474 |
taxon_best_match.scrubbed_unique_taxon_name,
|
|
| 21475 |
taxon_best_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",
|
|
| 21476 |
taxon_best_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 21477 |
taxon_best_match."matched~Name[_no_author]___@TNRS__@vegpath.org",
|
|
| 21478 |
taxon_best_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",
|
|
| 21479 |
taxon_best_match.matched_has_accepted,
|
|
| 21480 |
taxon_best_match."Accepted_family__@TNRS__@vegpath.org",
|
|
| 21481 |
taxon_best_match."Accepted_species[_binomial]__@TNRS__@vegpath.org",
|
|
| 21482 |
taxon_best_match."__accepted_{genus,specific_epithet,infra_{rank,epithet}}",
|
|
| 21483 |
taxon_best_match."[accepted_]genus__@DwC__@vegpath.org",
|
|
| 21484 |
taxon_best_match."[accepted_]specificEpithet__@DwC__@vegpath.org",
|
|
| 21485 |
taxon_best_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
|
|
| 21486 |
taxon_best_match."__accepted_infraspecific_{rank,epithet}",
|
|
| 21487 |
taxon_best_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
|
|
| 21488 |
taxon_best_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",
|
|
| 21489 |
taxon_best_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",
|
|
| 21490 |
taxon_best_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",
|
|
| 21491 |
taxon_best_match."[scrubbed_]taxonRank__@DwC__@vegpath.org",
|
|
| 21492 |
taxon_best_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 21493 |
taxon_best_match."[scrubbed_]genus__@DwC__@vegpath.org",
|
|
| 21494 |
taxon_best_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org",
|
|
| 21495 |
taxon_best_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 21496 |
taxon_best_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
|
|
| 21497 |
taxon_best_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
|
|
| 21498 |
taxon_best_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",
|
|
| 21499 |
taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 21500 |
taxon_best_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org",
|
|
| 21501 |
taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org"
|
|
| 21502 |
FROM taxon_best_match
|
|
| 21503 |
WHERE taxon_best_match.is_valid_match;
|
|
| 21504 | 21504 |
|
| 21505 | 21505 |
|
| 21506 | 21506 |
-- |
Also available in: Unified diff
inputs/.TNRS/schema.sql: ValidMatchedTaxon: use taxon_best_match now that it's equivalent to MatchedTaxon