Revision 14284
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/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, |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 20190 | 20190 |
taxon_match."*Accepted_name_lsid", |
| 20191 | 20191 |
taxon_match.is_valid_match, |
| 20192 | 20192 |
taxon_match.scrubbed_unique_taxon_name, |
| 20193 |
taxon_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20194 |
taxon_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 20195 |
taxon_match.matched_has_accepted, |
|
| 20193 | 20196 |
taxon_match."__accepted_{genus,specific_epithet}",
|
| 20194 | 20197 |
taxon_match."[accepted_]genus__@DwC__@vegpath.org", |
| 20195 | 20198 |
taxon_match."[accepted_]specificEpithet__@DwC__@vegpath.org", |
| ... | ... | |
| 20197 | 20200 |
taxon_match."__accepted_infraspecific_{rank,epithet}",
|
| 20198 | 20201 |
taxon_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
| 20199 | 20202 |
taxon_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org", |
| 20200 |
taxon_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 20201 |
taxon_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" |
|
| 20203 |
taxon_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 20204 |
taxon_match."[scrubbed_]taxonRank__@DwC__@vegpath.org", |
|
| 20205 |
taxon_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20206 |
taxon_match."[scrubbed_]genus__@DwC__@vegpath.org", |
|
| 20207 |
taxon_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org", |
|
| 20208 |
taxon_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20209 |
taxon_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
|
| 20210 |
taxon_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", |
|
| 20211 |
taxon_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20212 |
taxon_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20213 |
taxon_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org" |
|
| 20202 | 20214 |
FROM taxon_match |
| 20203 | 20215 |
WHERE (taxon_match."*Selected" = 'true'::text); |
| 20204 | 20216 |
|
| ... | ... | |
| 20260 | 20272 |
taxon_best_match."*Accepted_name_lsid", |
| 20261 | 20273 |
taxon_best_match.is_valid_match, |
| 20262 | 20274 |
taxon_best_match.scrubbed_unique_taxon_name, |
| 20275 |
taxon_best_match."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20276 |
taxon_best_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 20277 |
taxon_best_match.matched_has_accepted, |
|
| 20263 | 20278 |
taxon_best_match."__accepted_{genus,specific_epithet}",
|
| 20264 | 20279 |
taxon_best_match."[accepted_]genus__@DwC__@vegpath.org", |
| 20265 | 20280 |
taxon_best_match."[accepted_]specificEpithet__@DwC__@vegpath.org", |
| ... | ... | |
| 20267 | 20282 |
taxon_best_match."__accepted_infraspecific_{rank,epithet}",
|
| 20268 | 20283 |
taxon_best_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
| 20269 | 20284 |
taxon_best_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org", |
| 20270 |
taxon_best_match."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 20271 | 20285 |
taxon_best_match."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org", |
| 20286 |
taxon_best_match."[scrubbed_]taxonRank__@DwC__@vegpath.org", |
|
| 20287 |
taxon_best_match."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20288 |
taxon_best_match."[scrubbed_]genus__@DwC__@vegpath.org", |
|
| 20289 |
taxon_best_match."[scrubbed_]specificEpithet__@DwC__@vegpath.org", |
|
| 20290 |
taxon_best_match."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20291 |
taxon_best_match."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
|
| 20292 |
taxon_best_match."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", |
|
| 20293 |
taxon_best_match."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20294 |
taxon_best_match."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20295 |
taxon_best_match."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 20272 | 20296 |
map_taxonomic_status(taxon_best_match."*Taxonomic_status", taxon_best_match."*Accepted_name") AS "taxonomicStatus", |
| 20273 | 20297 |
CASE |
| 20274 | 20298 |
WHEN (taxon_best_match."*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, taxon_best_match."*Accepted_name_family", taxon_best_match."*Unmatched_terms")
|
| ... | ... | |
| 20335 | 20359 |
"MatchedTaxon"."*Accepted_name_lsid", |
| 20336 | 20360 |
"MatchedTaxon".is_valid_match, |
| 20337 | 20361 |
"MatchedTaxon".scrubbed_unique_taxon_name, |
| 20362 |
"MatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20363 |
"MatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 20364 |
"MatchedTaxon".matched_has_accepted, |
|
| 20338 | 20365 |
"MatchedTaxon"."__accepted_{genus,specific_epithet}",
|
| 20339 | 20366 |
"MatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org", |
| 20340 | 20367 |
"MatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org", |
| ... | ... | |
| 20342 | 20369 |
"MatchedTaxon"."__accepted_infraspecific_{rank,epithet}",
|
| 20343 | 20370 |
"MatchedTaxon"."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
| 20344 | 20371 |
"MatchedTaxon"."[accepted_]infraspecificEpithet__@DwC__@vegpath.org", |
| 20345 |
"MatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 20346 | 20372 |
"MatchedTaxon"."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org", |
| 20373 |
"MatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org", |
|
| 20374 |
"MatchedTaxon"."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20375 |
"MatchedTaxon"."[scrubbed_]genus__@DwC__@vegpath.org", |
|
| 20376 |
"MatchedTaxon"."[scrubbed_]specificEpithet__@DwC__@vegpath.org", |
|
| 20377 |
"MatchedTaxon"."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20378 |
"MatchedTaxon"."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
|
| 20379 |
"MatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", |
|
| 20380 |
"MatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20381 |
"MatchedTaxon"."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20382 |
"MatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 20347 | 20383 |
"MatchedTaxon"."taxonomicStatus", |
| 20348 | 20384 |
"MatchedTaxon".accepted_morphospecies_binomial |
| 20349 | 20385 |
FROM "MatchedTaxon" |
| ... | ... | |
| 20615 | 20651 |
"ValidMatchedTaxon"."*Warnings", |
| 20616 | 20652 |
"ValidMatchedTaxon"."*Accepted_name_lsid", |
| 20617 | 20653 |
"ValidMatchedTaxon".is_valid_match, |
| 20654 |
"ValidMatchedTaxon"."[matched_]species[_binomial]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20655 |
"ValidMatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 20656 |
"ValidMatchedTaxon".matched_has_accepted, |
|
| 20618 | 20657 |
"ValidMatchedTaxon"."__accepted_{genus,specific_epithet}",
|
| 20619 | 20658 |
"ValidMatchedTaxon"."[accepted_]genus__@DwC__@vegpath.org", |
| 20620 | 20659 |
"ValidMatchedTaxon"."[accepted_]specificEpithet__@DwC__@vegpath.org", |
| ... | ... | |
| 20622 | 20661 |
"ValidMatchedTaxon"."__accepted_infraspecific_{rank,epithet}",
|
| 20623 | 20662 |
"ValidMatchedTaxon"."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
| 20624 | 20663 |
"ValidMatchedTaxon"."[accepted_]infraspecificEpithet__@DwC__@vegpath.org", |
| 20625 |
"ValidMatchedTaxon"."[matched_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 20626 | 20664 |
"ValidMatchedTaxon"."[accepted_]scientificName[_with_author]__@DwC__@vegpath.org", |
| 20665 |
"ValidMatchedTaxon"."[scrubbed_]taxonRank__@DwC__@vegpath.org", |
|
| 20666 |
"ValidMatchedTaxon"."[scrubbed_]family~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20667 |
"ValidMatchedTaxon"."[scrubbed_]genus__@DwC__@vegpath.org", |
|
| 20668 |
"ValidMatchedTaxon"."[scrubbed_]specificEpithet__@DwC__@vegpath.org", |
|
| 20669 |
"ValidMatchedTaxon"."[scrubbed_]species[_binom]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20670 |
"ValidMatchedTaxon"."[scrubbed_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", |
|
| 20671 |
"ValidMatchedTaxon"."[scrubbed_]infraspecificEpithet__@DwC__@vegpath.org", |
|
| 20672 |
"ValidMatchedTaxon"."[scrubbed_]name[_no_author]~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20673 |
"ValidMatchedTaxon"."[scrubbed_]author~(-Accepted_-)__@TNRS__@vegpath.org", |
|
| 20674 |
"ValidMatchedTaxon"."[scrubbed_]scientificName[_with_author]__@DwC__@vegpath.org", |
|
| 20627 | 20675 |
"ValidMatchedTaxon"."taxonomicStatus", |
| 20628 | 20676 |
"ValidMatchedTaxon".accepted_morphospecies_binomial, |
| 20629 | 20677 |
"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