Project

General

Profile

« Previous | Next » 

Revision 14359

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: added new derived columns to derived views

View differences:

schema.sql
1276 1276 
    taxon_match."*Accepted_name_lsid",
1277 1277 
    taxon_match.is_valid_match,
1278 1278 
    taxon_match.scrubbed_unique_taxon_name,
1279 
    taxon_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",
1279 1280 
    taxon_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",
1281 
    taxon_match."matched~Name[_no_author]___@TNRS__@vegpath.org",
1280 1282 
    taxon_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",
1281 1283 
    taxon_match.matched_has_accepted,
1284 
    taxon_match."Accepted_family__@TNRS__@vegpath.org",
1282 1285 
    taxon_match."__accepted_{genus,specific_epithet}",
1283 1286 
    taxon_match."[accepted_]genus__@DwC__@vegpath.org",
1284 1287 
    taxon_match."[accepted_]specificEpithet__@DwC__@vegpath.org",
1288 
    taxon_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
1285 1289 
    taxon_match.__accepted_infraspecific_label,
1286 1290 
    taxon_match."__accepted_infraspecific_{rank,epithet}",
1287 1291 
    taxon_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
1288 1292 
    taxon_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",
1289 1293 
    taxon_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",
1294 
    taxon_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",
1290 1295 
    taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org",
1291 1296 
    taxon_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",
1292 1297 
    taxon_match."[scrubbed_]genus__@DwC__@vegpath.org",
1293 1298 
    taxon_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org",
1294 1299 
    taxon_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",
1300 
    taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
1295 1301 
    taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
1296 1302 
    taxon_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",
1297 1303 
    taxon_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",
......
1358 1364 
    taxon_best_match."*Accepted_name_lsid",
1359 1365 
    taxon_best_match.is_valid_match,
1360 1366 
    taxon_best_match.scrubbed_unique_taxon_name,
1367 
    taxon_best_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",
1361 1368 
    taxon_best_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",
1369 
    taxon_best_match."matched~Name[_no_author]___@TNRS__@vegpath.org",
1362 1370 
    taxon_best_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",
1363 1371 
    taxon_best_match.matched_has_accepted,
1372 
    taxon_best_match."Accepted_family__@TNRS__@vegpath.org",
1364 1373 
    taxon_best_match."__accepted_{genus,specific_epithet}",
1365 1374 
    taxon_best_match."[accepted_]genus__@DwC__@vegpath.org",
1366 1375 
    taxon_best_match."[accepted_]specificEpithet__@DwC__@vegpath.org",
1376 
    taxon_best_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
1367 1377 
    taxon_best_match.__accepted_infraspecific_label,
1368 1378 
    taxon_best_match."__accepted_infraspecific_{rank,epithet}",
1369 1379 
    taxon_best_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
1370 1380 
    taxon_best_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",
1371 1381 
    taxon_best_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",
1382 
    taxon_best_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",
1372 1383 
    taxon_best_match."[scrubbed_]taxonRank__@DwC__@vegpath.org",
1373 1384 
    taxon_best_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",
1374 1385 
    taxon_best_match."[scrubbed_]genus__@DwC__@vegpath.org",
1375 1386 
    taxon_best_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org",
1376 1387 
    taxon_best_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",
1388 
    taxon_best_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
1377 1389 
    taxon_best_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
1378 1390 
    taxon_best_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",
1379 1391 
    taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",
......
1445 1457 
    "MatchedTaxon"."*Accepted_name_lsid",
1446 1458 
    "MatchedTaxon".is_valid_match,
1447 1459 
    "MatchedTaxon".scrubbed_unique_taxon_name,
1460 
    "MatchedTaxon"."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",
1448 1461 
    "MatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",
1462 
    "MatchedTaxon"."matched~Name[_no_author]___@TNRS__@vegpath.org",
1449 1463 
    "MatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",
1450 1464 
    "MatchedTaxon".matched_has_accepted,
1465 
    "MatchedTaxon"."Accepted_family__@TNRS__@vegpath.org",
1451 1466 
    "MatchedTaxon"."__accepted_{genus,specific_epithet}",
1452 1467 
    "MatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org",
1453 1468 
    "MatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org",
1469 
    "MatchedTaxon"."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
1454 1470 
    "MatchedTaxon".__accepted_infraspecific_label,
1455 1471 
    "MatchedTaxon"."__accepted_infraspecific_{rank,epithet}",
1456 1472 
    "MatchedTaxon"."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
1457 1473 
    "MatchedTaxon"."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",
1458 1474 
    "MatchedTaxon"."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",
1475 
    "MatchedTaxon"."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",
1459 1476 
    "MatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org",
1460 1477 
    "MatchedTaxon"."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",
1461 1478 
    "MatchedTaxon"."[scrubbed_]genus__@DwC__@vegpath.org",
1462 1479 
    "MatchedTaxon"."[scrubbed_]specificEpithet__@DwC__@vegpath.org",
1463 1480 
    "MatchedTaxon"."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",
1481 
    "MatchedTaxon"."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
1464 1482 
    "MatchedTaxon"."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
1465 1483 
    "MatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",
1466 1484 
    "MatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",
......
1737 1755 
    "ValidMatchedTaxon"."*Warnings",
1738 1756 
    "ValidMatchedTaxon"."*Accepted_name_lsid",
1739 1757 
    "ValidMatchedTaxon".is_valid_match,
1758 
    "ValidMatchedTaxon"."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",
1740 1759 
    "ValidMatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",
1760 
    "ValidMatchedTaxon"."matched~Name[_no_author]___@TNRS__@vegpath.org",
1741 1761 
    "ValidMatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",
1742 1762 
    "ValidMatchedTaxon".matched_has_accepted,
1763 
    "ValidMatchedTaxon"."Accepted_family__@TNRS__@vegpath.org",
1743 1764 
    "ValidMatchedTaxon"."__accepted_{genus,specific_epithet}",
1744 1765 
    "ValidMatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org",
1745 1766 
    "ValidMatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org",
1767 
    "ValidMatchedTaxon"."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
1746 1768 
    "ValidMatchedTaxon".__accepted_infraspecific_label,
1747 1769 
    "ValidMatchedTaxon"."__accepted_infraspecific_{rank,epithet}",
1748 1770 
    "ValidMatchedTaxon"."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
1749 1771 
    "ValidMatchedTaxon"."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",
1750 1772 
    "ValidMatchedTaxon"."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",
1773 
    "ValidMatchedTaxon"."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",
1751 1774 
    "ValidMatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org",
1752 1775 
    "ValidMatchedTaxon"."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",
1753 1776 
    "ValidMatchedTaxon"."[scrubbed_]genus__@DwC__@vegpath.org",
1754 1777 
    "ValidMatchedTaxon"."[scrubbed_]specificEpithet__@DwC__@vegpath.org",
1755 1778 
    "ValidMatchedTaxon"."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",
1779 
    "ValidMatchedTaxon"."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
1756 1780 
    "ValidMatchedTaxon"."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
1757 1781 
    "ValidMatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",
1758 1782 
    "ValidMatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",

Also available in: Unified diff