Revision 13441
Added by Aaron Marcuse-Kubitza over 10 years ago
| schema.sql | ||
|---|---|---|
| 243 | 243 |
tnrs."Annotations" AS "identificationQualifier", |
| 244 | 244 |
tnrs."Unmatched_terms" AS "morphospeciesSuffix", |
| 245 | 245 |
tnrs."Taxonomic_status" AS "taxonomicStatus", |
| 246 |
tnrs."Accepted_name" AS scrubbed_taxon_name_no_author,
|
|
| 247 |
tnrs."Accepted_name_author" AS scrubbed_author,
|
|
| 248 |
tnrs."Accepted_name_rank" AS scrubbed_taxon_rank,
|
|
| 246 |
tnrs."Accepted_name" AS accepted_taxon_name_no_author,
|
|
| 247 |
tnrs."Accepted_name_author" AS accepted_author,
|
|
| 248 |
tnrs."Accepted_name_rank" AS accepted_taxon_rank,
|
|
| 249 | 249 |
tnrs."Accepted_name_url" AS "acceptedScientificNameID", |
| 250 | 250 |
tnrs."Accepted_name_species" AS "*Name_matched.Accepted_name_species", |
| 251 |
tnrs."Accepted_name_family" AS scrubbed_family,
|
|
| 251 |
tnrs."Accepted_name_family" AS accepted_family,
|
|
| 252 | 252 |
tnrs."Selected" AS "*Name_matched.Selected", |
| 253 | 253 |
tnrs."Source" AS "*Name_matched.Source", |
| 254 | 254 |
tnrs."Warnings" AS "*Name_matched.Warnings", |
| ... | ... | |
| 282 | 282 |
"MatchedTaxon"."identificationQualifier", |
| 283 | 283 |
"MatchedTaxon"."morphospeciesSuffix", |
| 284 | 284 |
"MatchedTaxon"."taxonomicStatus", |
| 285 |
"MatchedTaxon".scrubbed_taxon_name_no_author,
|
|
| 286 |
"MatchedTaxon".scrubbed_author,
|
|
| 287 |
"MatchedTaxon".scrubbed_taxon_rank,
|
|
| 285 |
"MatchedTaxon".accepted_taxon_name_no_author,
|
|
| 286 |
"MatchedTaxon".accepted_author,
|
|
| 287 |
"MatchedTaxon".accepted_taxon_rank,
|
|
| 288 | 288 |
"MatchedTaxon"."acceptedScientificNameID", |
| 289 | 289 |
"MatchedTaxon"."*Name_matched.Accepted_name_species", |
| 290 |
"MatchedTaxon".scrubbed_family,
|
|
| 290 |
"MatchedTaxon".accepted_family,
|
|
| 291 | 291 |
"MatchedTaxon"."*Name_matched.Selected", |
| 292 | 292 |
"MatchedTaxon"."*Name_matched.Source", |
| 293 | 293 |
"MatchedTaxon"."*Name_matched.Warnings", |
| ... | ... | |
| 392 | 392 |
|
| 393 | 393 |
CREATE VIEW "taxon_scrub.scrubbed_unique_taxon_name.*" AS |
| 394 | 394 |
SELECT tnrs."Name_submitted" AS scrubbed_unique_taxon_name, |
| 395 |
tnrs."Name_matched_rank" AS scrubbed_parsed_taxon_rank,
|
|
| 396 |
COALESCE(tnrs."Name_matched_accepted_family", tnrs."Family_matched") AS scrubbed_parsed_family,
|
|
| 395 |
tnrs."Name_matched_rank" AS scrubbed_taxon_rank, |
|
| 396 |
COALESCE(tnrs."Name_matched_accepted_family", tnrs."Family_matched") AS scrubbed_family, |
|
| 397 | 397 |
tnrs."Genus_matched" AS scrubbed_genus, |
| 398 | 398 |
tnrs."Specific_epithet_matched" AS scrubbed_specific_epithet, |
| 399 | 399 |
tnrs."Infraspecific_rank" AS scrubbed_infraspecific_rank, |
| 400 | 400 |
tnrs."Infraspecific_epithet_matched" AS scrubbed_infraspecific_epithet, |
| 401 |
tnrs."Name_matched_author" AS scrubbed_parsed_author,
|
|
| 402 |
tnrs."Name_matched" AS scrubbed_parsed_taxon_name_no_author
|
|
| 401 |
tnrs."Name_matched_author" AS scrubbed_author, |
|
| 402 |
tnrs."Name_matched" AS scrubbed_taxon_name_no_author |
|
| 403 | 403 |
FROM tnrs; |
| 404 | 404 |
|
| 405 | 405 |
|
| ... | ... | |
| 435 | 435 |
"ValidMatchedTaxon"."identificationQualifier", |
| 436 | 436 |
"ValidMatchedTaxon"."morphospeciesSuffix", |
| 437 | 437 |
"ValidMatchedTaxon"."taxonomicStatus", |
| 438 |
"ValidMatchedTaxon".scrubbed_taxon_name_no_author,
|
|
| 439 |
"ValidMatchedTaxon".scrubbed_author,
|
|
| 440 |
"ValidMatchedTaxon".scrubbed_taxon_rank,
|
|
| 438 |
"ValidMatchedTaxon".accepted_taxon_name_no_author,
|
|
| 439 |
"ValidMatchedTaxon".accepted_author,
|
|
| 440 |
"ValidMatchedTaxon".accepted_taxon_rank,
|
|
| 441 | 441 |
"ValidMatchedTaxon"."acceptedScientificNameID", |
| 442 | 442 |
"ValidMatchedTaxon"."*Name_matched.Accepted_name_species", |
| 443 |
"ValidMatchedTaxon".scrubbed_family,
|
|
| 443 |
"ValidMatchedTaxon".accepted_family,
|
|
| 444 | 444 |
"ValidMatchedTaxon"."*Name_matched.Selected", |
| 445 | 445 |
"ValidMatchedTaxon"."*Name_matched.Source", |
| 446 | 446 |
"ValidMatchedTaxon"."*Name_matched.Warnings", |
| 447 | 447 |
"ValidMatchedTaxon"."*Name_matched.Accepted_name_lsid", |
| 448 | 448 |
"ValidMatchedTaxon".taxon_scrub__is_valid_match, |
| 449 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_parsed_taxon_rank,
|
|
| 450 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_parsed_family,
|
|
| 449 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank, |
|
| 450 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_family, |
|
| 451 | 451 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_genus, |
| 452 | 452 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_specific_epithet, |
| 453 | 453 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_rank, |
| 454 | 454 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_epithet, |
| 455 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_parsed_author,
|
|
| 456 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_parsed_taxon_name_no_author
|
|
| 455 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_author, |
|
| 456 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author |
|
| 457 | 457 |
FROM ("ValidMatchedTaxon"
|
| 458 | 458 |
LEFT JOIN "taxon_scrub.scrubbed_unique_taxon_name.*" USING (scrubbed_unique_taxon_name)); |
| 459 | 459 |
|
Also available in: Unified diff
bugfix: inputs/.TNRS/schema.sql: taxon_scrub, etc.: undid rename of accepted name columns to scrubbed_* (r13435), because these are actually not the same (scrubbed_* is the combination of accepted and no-opinion names). the accepted name columns will now be named accepted_*, following the standard naming scheme.