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:

trunk/inputs/.TNRS/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",
trunk/schemas/vegbien.sql
20937 20937 
    taxon_match."*Accepted_name_lsid",
20938 20938 
    taxon_match.is_valid_match,
20939 20939 
    taxon_match.scrubbed_unique_taxon_name,
20940 
    taxon_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",
20940 20941 
    taxon_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",
20942 
    taxon_match."matched~Name[_no_author]___@TNRS__@vegpath.org",
20941 20943 
    taxon_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",
20942 20944 
    taxon_match.matched_has_accepted,
20945 
    taxon_match."Accepted_family__@TNRS__@vegpath.org",
20943 20946 
    taxon_match."__accepted_{genus,specific_epithet}",
20944 20947 
    taxon_match."[accepted_]genus__@DwC__@vegpath.org",
20945 20948 
    taxon_match."[accepted_]specificEpithet__@DwC__@vegpath.org",
20949 
    taxon_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
20946 20950 
    taxon_match.__accepted_infraspecific_label,
20947 20951 
    taxon_match."__accepted_infraspecific_{rank,epithet}",
20948 20952 
    taxon_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
20949 20953 
    taxon_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",
20950 20954 
    taxon_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",
20955 
    taxon_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",
20951 20956 
    taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org",
20952 20957 
    taxon_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",
20953 20958 
    taxon_match."[scrubbed_]genus__@DwC__@vegpath.org",
20954 20959 
    taxon_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org",
20955 20960 
    taxon_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",
20961 
    taxon_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
20956 20962 
    taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
20957 20963 
    taxon_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",
20958 20964 
    taxon_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",
......
21019 21025 
    taxon_best_match."*Accepted_name_lsid",
21020 21026 
    taxon_best_match.is_valid_match,
21021 21027 
    taxon_best_match.scrubbed_unique_taxon_name,
21028 
    taxon_best_match."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",
21022 21029 
    taxon_best_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",
21030 
    taxon_best_match."matched~Name[_no_author]___@TNRS__@vegpath.org",
21023 21031 
    taxon_best_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",
21024 21032 
    taxon_best_match.matched_has_accepted,
21033 
    taxon_best_match."Accepted_family__@TNRS__@vegpath.org",
21025 21034 
    taxon_best_match."__accepted_{genus,specific_epithet}",
21026 21035 
    taxon_best_match."[accepted_]genus__@DwC__@vegpath.org",
21027 21036 
    taxon_best_match."[accepted_]specificEpithet__@DwC__@vegpath.org",
21037 
    taxon_best_match."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
21028 21038 
    taxon_best_match.__accepted_infraspecific_label,
21029 21039 
    taxon_best_match."__accepted_infraspecific_{rank,epithet}",
21030 21040 
    taxon_best_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
21031 21041 
    taxon_best_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",
21032 21042 
    taxon_best_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",
21043 
    taxon_best_match."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",
21033 21044 
    taxon_best_match."[scrubbed_]taxonRank__@DwC__@vegpath.org",
21034 21045 
    taxon_best_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",
21035 21046 
    taxon_best_match."[scrubbed_]genus__@DwC__@vegpath.org",
21036 21047 
    taxon_best_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org",
21037 21048 
    taxon_best_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",
21049 
    taxon_best_match."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
21038 21050 
    taxon_best_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
21039 21051 
    taxon_best_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",
21040 21052 
    taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",
......
21106 21118 
    "MatchedTaxon"."*Accepted_name_lsid",
21107 21119 
    "MatchedTaxon".is_valid_match,
21108 21120 
    "MatchedTaxon".scrubbed_unique_taxon_name,
21121 
    "MatchedTaxon"."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",
21109 21122 
    "MatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",
21123 
    "MatchedTaxon"."matched~Name[_no_author]___@TNRS__@vegpath.org",
21110 21124 
    "MatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",
21111 21125 
    "MatchedTaxon".matched_has_accepted,
21126 
    "MatchedTaxon"."Accepted_family__@TNRS__@vegpath.org",
21112 21127 
    "MatchedTaxon"."__accepted_{genus,specific_epithet}",
21113 21128 
    "MatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org",
21114 21129 
    "MatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org",
21130 
    "MatchedTaxon"."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
21115 21131 
    "MatchedTaxon".__accepted_infraspecific_label,
21116 21132 
    "MatchedTaxon"."__accepted_infraspecific_{rank,epithet}",
21117 21133 
    "MatchedTaxon"."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
21118 21134 
    "MatchedTaxon"."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",
21119 21135 
    "MatchedTaxon"."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",
21136 
    "MatchedTaxon"."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",
21120 21137 
    "MatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org",
21121 21138 
    "MatchedTaxon"."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",
21122 21139 
    "MatchedTaxon"."[scrubbed_]genus__@DwC__@vegpath.org",
21123 21140 
    "MatchedTaxon"."[scrubbed_]specificEpithet__@DwC__@vegpath.org",
21124 21141 
    "MatchedTaxon"."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",
21142 
    "MatchedTaxon"."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
21125 21143 
    "MatchedTaxon"."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
21126 21144 
    "MatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",
21127 21145 
    "MatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",
......
21398 21416 
    "ValidMatchedTaxon"."*Warnings",
21399 21417 
    "ValidMatchedTaxon"."*Accepted_name_lsid",
21400 21418 
    "ValidMatchedTaxon".is_valid_match,
21419 
    "ValidMatchedTaxon"."[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org",
21401 21420 
    "ValidMatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org",
21421 
    "ValidMatchedTaxon"."matched~Name[_no_author]___@TNRS__@vegpath.org",
21402 21422 
    "ValidMatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org",
21403 21423 
    "ValidMatchedTaxon".matched_has_accepted,
21424 
    "ValidMatchedTaxon"."Accepted_family__@TNRS__@vegpath.org",
21404 21425 
    "ValidMatchedTaxon"."__accepted_{genus,specific_epithet}",
21405 21426 
    "ValidMatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org",
21406 21427 
    "ValidMatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org",
21428 
    "ValidMatchedTaxon"."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
21407 21429 
    "ValidMatchedTaxon".__accepted_infraspecific_label,
21408 21430 
    "ValidMatchedTaxon"."__accepted_infraspecific_{rank,epithet}",
21409 21431 
    "ValidMatchedTaxon"."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
21410 21432 
    "ValidMatchedTaxon"."[accepted_]infraspecificEpithet__@DwC__@vegpath.org",
21411 21433 
    "ValidMatchedTaxon"."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org",
21434 
    "ValidMatchedTaxon"."[scrubbed_]taxonomicStatus__@DwC__@vegpath.org",
21412 21435 
    "ValidMatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org",
21413 21436 
    "ValidMatchedTaxon"."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org",
21414 21437 
    "ValidMatchedTaxon"."[scrubbed_]genus__@DwC__@vegpath.org",
21415 21438 
    "ValidMatchedTaxon"."[scrubbed_]specificEpithet__@DwC__@vegpath.org",
21416 21439 
    "ValidMatchedTaxon"."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org",
21440 
    "ValidMatchedTaxon"."[scrubbed_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org",
21417 21441 
    "ValidMatchedTaxon"."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org",
21418 21442 
    "ValidMatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org",
21419 21443 
    "ValidMatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org",

Also available in: Unified diff