Revision 14284
Added by Aaron Marcuse-Kubitza over 10 years ago
| schema.sql | ||
|---|---|---|
| 1078 | 1078 |
taxon_match."*Accepted_name_lsid", |
| 1079 | 1079 |
taxon_match.is_valid_match, |
| 1080 | 1080 |
taxon_match.scrubbed_unique_taxon_name, |
| 1081 |
taxon_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1082 |
taxon_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1083 |
taxon_match.matched_has_accepted, |
|
| 1081 | 1084 |
taxon_match."__accepted_{genus,specific_epithet}",
|
| 1082 | 1085 |
taxon_match."[accepted_]genus__@DwC__@vegpath.org", |
| 1083 | 1086 |
taxon_match."[accepted_]specificEpithet__@DwC__@vegpath.org", |
| ... | ... | |
| 1085 | 1088 |
taxon_match."__accepted_infraspecific_{rank,epithet}",
|
| 1086 | 1089 |
taxon_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
| 1087 | 1090 |
taxon_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org", |
| 1088 |
taxon_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1089 |
taxon_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" |
|
| 1091 |
taxon_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1092 |
taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org", |
|
| 1093 |
taxon_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1094 |
taxon_match."[scrubbed_]genus__@DwC__@vegpath.org", |
|
| 1095 |
taxon_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org", |
|
| 1096 |
taxon_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1097 |
taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
|
| 1098 |
taxon_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", |
|
| 1099 |
taxon_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1100 |
taxon_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1101 |
taxon_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" |
|
| 1090 | 1102 |
FROM taxon_match |
| 1091 | 1103 |
WHERE (taxon_match."*Selected" = 'true'::text); |
| 1092 | 1104 |
|
| ... | ... | |
| 1148 | 1160 |
taxon_best_match."*Accepted_name_lsid", |
| 1149 | 1161 |
taxon_best_match.is_valid_match, |
| 1150 | 1162 |
taxon_best_match.scrubbed_unique_taxon_name, |
| 1163 |
taxon_best_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1164 |
taxon_best_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1165 |
taxon_best_match.matched_has_accepted, |
|
| 1151 | 1166 |
taxon_best_match."__accepted_{genus,specific_epithet}",
|
| 1152 | 1167 |
taxon_best_match."[accepted_]genus__@DwC__@vegpath.org", |
| 1153 | 1168 |
taxon_best_match."[accepted_]specificEpithet__@DwC__@vegpath.org", |
| ... | ... | |
| 1155 | 1170 |
taxon_best_match."__accepted_infraspecific_{rank,epithet}",
|
| 1156 | 1171 |
taxon_best_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
| 1157 | 1172 |
taxon_best_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org", |
| 1158 |
taxon_best_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1159 | 1173 |
taxon_best_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org", |
| 1174 |
taxon_best_match."[scrubbed_]taxonRank__@DwC__@vegpath.org", |
|
| 1175 |
taxon_best_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1176 |
taxon_best_match."[scrubbed_]genus__@DwC__@vegpath.org", |
|
| 1177 |
taxon_best_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org", |
|
| 1178 |
taxon_best_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1179 |
taxon_best_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
|
| 1180 |
taxon_best_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", |
|
| 1181 |
taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1182 |
taxon_best_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1183 |
taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1160 | 1184 |
map_taxonomic_status(taxon_best_match."*Taxonomic_status", taxon_best_match."*Accepted_name") AS "taxonomicStatus", |
| 1161 | 1185 |
CASE |
| 1162 | 1186 |
WHEN (taxon_best_match."*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, taxon_best_match."*Accepted_name_family", taxon_best_match."*Unmatched_terms")
|
| ... | ... | |
| 1223 | 1247 |
"MatchedTaxon"."*Accepted_name_lsid", |
| 1224 | 1248 |
"MatchedTaxon".is_valid_match, |
| 1225 | 1249 |
"MatchedTaxon".scrubbed_unique_taxon_name, |
| 1250 |
"MatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1251 |
"MatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1252 |
"MatchedTaxon".matched_has_accepted, |
|
| 1226 | 1253 |
"MatchedTaxon"."__accepted_{genus,specific_epithet}",
|
| 1227 | 1254 |
"MatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org", |
| 1228 | 1255 |
"MatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org", |
| ... | ... | |
| 1230 | 1257 |
"MatchedTaxon"."__accepted_infraspecific_{rank,epithet}",
|
| 1231 | 1258 |
"MatchedTaxon"."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
| 1232 | 1259 |
"MatchedTaxon"."[accepted_]infraspecificEpithet__@DwC__@vegpath.org", |
| 1233 |
"MatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1234 | 1260 |
"MatchedTaxon"."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org", |
| 1261 |
"MatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org", |
|
| 1262 |
"MatchedTaxon"."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1263 |
"MatchedTaxon"."[scrubbed_]genus__@DwC__@vegpath.org", |
|
| 1264 |
"MatchedTaxon"."[scrubbed_]specificEpithet__@DwC__@vegpath.org", |
|
| 1265 |
"MatchedTaxon"."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1266 |
"MatchedTaxon"."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
|
| 1267 |
"MatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", |
|
| 1268 |
"MatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1269 |
"MatchedTaxon"."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1270 |
"MatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1235 | 1271 |
"MatchedTaxon"."taxonomicStatus", |
| 1236 | 1272 |
"MatchedTaxon".accepted_morphospecies_binomial |
| 1237 | 1273 |
FROM "MatchedTaxon" |
| ... | ... | |
| 1503 | 1539 |
"ValidMatchedTaxon"."*Warnings", |
| 1504 | 1540 |
"ValidMatchedTaxon"."*Accepted_name_lsid", |
| 1505 | 1541 |
"ValidMatchedTaxon".is_valid_match, |
| 1542 |
"ValidMatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1543 |
"ValidMatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1544 |
"ValidMatchedTaxon".matched_has_accepted, |
|
| 1506 | 1545 |
"ValidMatchedTaxon"."__accepted_{genus,specific_epithet}",
|
| 1507 | 1546 |
"ValidMatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org", |
| 1508 | 1547 |
"ValidMatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org", |
| ... | ... | |
| 1510 | 1549 |
"ValidMatchedTaxon"."__accepted_infraspecific_{rank,epithet}",
|
| 1511 | 1550 |
"ValidMatchedTaxon"."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
| 1512 | 1551 |
"ValidMatchedTaxon"."[accepted_]infraspecificEpithet__@DwC__@vegpath.org", |
| 1513 |
"ValidMatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1514 | 1552 |
"ValidMatchedTaxon"."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org", |
| 1553 |
"ValidMatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org", |
|
| 1554 |
"ValidMatchedTaxon"."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1555 |
"ValidMatchedTaxon"."[scrubbed_]genus__@DwC__@vegpath.org", |
|
| 1556 |
"ValidMatchedTaxon"."[scrubbed_]specificEpithet__@DwC__@vegpath.org", |
|
| 1557 |
"ValidMatchedTaxon"."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1558 |
"ValidMatchedTaxon"."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
|
| 1559 |
"ValidMatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", |
|
| 1560 |
"ValidMatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1561 |
"ValidMatchedTaxon"."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 1562 |
"ValidMatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 1515 | 1563 |
"ValidMatchedTaxon"."taxonomicStatus", |
| 1516 | 1564 |
"ValidMatchedTaxon".accepted_morphospecies_binomial, |
| 1517 | 1565 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank, |
Also available in: Unified diff
inputs/.TNRS/schema.sql: added new derived columns to derived views