Revision 13536
Added by Aaron Marcuse-Kubitza over 10 years ago
| public_.sql | ||
|---|---|---|
| 6731 | 6731 |
taxon_scrub."taxonomicStatus" AS taxonomic_status, |
| 6732 | 6732 |
taxon_scrub.scrubbed_family, |
| 6733 | 6733 |
taxon_scrub.scrubbed_genus, |
| 6734 |
taxon_scrub.scrubbed_morphospecies_binomial, |
|
| 6734 |
taxon_scrub.scrubbed_specific_epithet, |
|
| 6735 |
((taxon_scrub.scrubbed_genus || ' '::text) || taxon_scrub.scrubbed_specific_epithet) AS scrubbed_species_binomial, |
|
| 6735 | 6736 |
taxon_scrub.scrubbed_taxon_name_no_author, |
| 6736 | 6737 |
taxon_scrub.scrubbed_author, |
| 6738 |
taxon_scrub.scrubbed_morphospecies_binomial, |
|
| 6737 | 6739 |
taxonoccurrence.growthform AS "growthForm", |
| 6738 | 6740 |
plantobservation.reproductivecondition AS "reproductiveCondition", |
| 6739 | 6741 |
((threatened_taxonlabel.taxonlabel_id IS NOT NULL))::integer AS threatened_bien, |
Also available in: Unified diff
schemas/public_.sql: added scrubbed_specific_epithet, scrubbed_species_binomial, which are needed by Jeff Ott's analysis (wiki.vegpath.org/Data_requests)