Revision 14284
Added by Aaron Marcuse-Kubitza over 10 years ago
| 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