Revision 13541
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 5374 | 5374 |
scrubbed_species_binomial text, |
| 5375 | 5375 |
scrubbed_taxon_name_no_author text, |
| 5376 | 5376 |
scrubbed_author text, |
| 5377 |
scrubbed_taxon_name_with_author text, |
|
| 5377 | 5378 |
scrubbed_morphospecies_binomial text, |
| 5378 | 5379 |
"growthForm" growthform, |
| 5379 | 5380 |
"reproductiveCondition" text, |
| ... | ... | |
| 6735 | 6736 |
((taxon_scrub.scrubbed_genus || ' '::text) || taxon_scrub.scrubbed_specific_epithet) AS scrubbed_species_binomial, |
| 6736 | 6737 |
taxon_scrub.scrubbed_taxon_name_no_author, |
| 6737 | 6738 |
taxon_scrub.scrubbed_author, |
| 6739 |
taxon_scrub.scrubbed_taxon_name_with_author, |
|
| 6738 | 6740 |
taxon_scrub.scrubbed_morphospecies_binomial, |
| 6739 | 6741 |
taxonoccurrence.growthform AS "growthForm", |
| 6740 | 6742 |
plantobservation.reproductivecondition AS "reproductiveCondition", |
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: added scrubbed_taxon_name_with_author, needed by Jeff Ott's analysis (wiki.vegpath.org/Data_requests)