Revision 13540
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 521 | 521 |
tnrs."Infraspecific_rank" AS scrubbed_infraspecific_rank, |
| 522 | 522 |
tnrs."Infraspecific_epithet_matched" AS scrubbed_infraspecific_epithet, |
| 523 | 523 |
tnrs."Name_matched_author" AS scrubbed_author, |
| 524 |
tnrs."Name_matched" AS scrubbed_taxon_name_no_author |
|
| 524 |
tnrs."Name_matched" AS scrubbed_taxon_name_no_author, |
|
| 525 |
(tnrs."Name_matched" || COALESCE((' '::text || tnrs."Name_matched_author"), ''::text)) AS scrubbed_taxon_name_with_author
|
|
| 525 | 526 |
FROM tnrs; |
| 526 | 527 |
|
| 527 | 528 |
|
| ... | ... | |
| 577 | 578 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_epithet, |
| 578 | 579 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_author, |
| 579 | 580 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author, |
| 581 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_with_author, |
|
| 580 | 582 |
CASE |
| 581 | 583 |
WHEN ("taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank = 'family'::text) THEN concat_ws(' '::text, "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_family, "ValidMatchedTaxon"."morphospeciesSuffix")
|
| 582 | 584 |
WHEN ("taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank = 'genus'::text) THEN concat_ws(' '::text, "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author, "ValidMatchedTaxon"."morphospeciesSuffix")
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 17329 | 17329 |
tnrs."Infraspecific_rank" AS scrubbed_infraspecific_rank, |
| 17330 | 17330 |
tnrs."Infraspecific_epithet_matched" AS scrubbed_infraspecific_epithet, |
| 17331 | 17331 |
tnrs."Name_matched_author" AS scrubbed_author, |
| 17332 |
tnrs."Name_matched" AS scrubbed_taxon_name_no_author |
|
| 17332 |
tnrs."Name_matched" AS scrubbed_taxon_name_no_author, |
|
| 17333 |
(tnrs."Name_matched" || COALESCE((' '::text || tnrs."Name_matched_author"), ''::text)) AS scrubbed_taxon_name_with_author
|
|
| 17333 | 17334 |
FROM tnrs; |
| 17334 | 17335 |
|
| 17335 | 17336 |
|
| ... | ... | |
| 17385 | 17386 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_infraspecific_epithet, |
| 17386 | 17387 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_author, |
| 17387 | 17388 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author, |
| 17389 |
"taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_with_author, |
|
| 17388 | 17390 |
CASE |
| 17389 | 17391 |
WHEN ("taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank = 'family'::text) THEN concat_ws(' '::text, "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_family, "ValidMatchedTaxon"."morphospeciesSuffix")
|
| 17390 | 17392 |
WHEN ("taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_rank = 'genus'::text) THEN concat_ws(' '::text, "taxon_scrub.scrubbed_unique_taxon_name.*".scrubbed_taxon_name_no_author, "ValidMatchedTaxon"."morphospeciesSuffix")
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_scrub.scrubbed_unique_taxon_name.*: added scrubbed_taxon_name_with_author, needed by Jeff Ott's analysis (wiki.vegpath.org/Data_requests)