Project

General

Profile

« Previous | Next » 

Revision 13541

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: analytical_stem_view: added scrubbed_taxon_name_with_author, needed by Jeff Ott's analysis (wiki.vegpath.org/Data_requests)

View differences:

trunk/schemas/vegbien.my.sql
3200 3200 
    scrubbed_species_binomial varchar(255),
3201 3201 
    scrubbed_taxon_name_no_author varchar(255),
3202 3202 
    scrubbed_author varchar(255),
3203 
    scrubbed_taxon_name_with_author varchar(255),
3203 3204 
    scrubbed_morphospecies_binomial varchar(255),
3204 3205 
    `growthForm` varchar(255),
3205 3206 
    `reproductiveCondition` varchar(255),
trunk/schemas/public_.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",
trunk/schemas/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