Project

General

Profile

« Previous | Next » 

Revision 13536

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: added scrubbed_specific_epithet, scrubbed_species_binomial, which are needed by Jeff Ott's analysis (wiki.vegpath.org/Data_requests)

View differences:

trunk/schemas/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,
trunk/schemas/vegbien.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