Project

General

Profile

« Previous | Next » 

Revision 13885

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: added functional traits that we have 1st-class columns for (dbh_cm, height_m)

View differences:

trunk/schemas/public_.sql
6064 6064 
    analytical_stem.scrubbed_genus AS accepted_genus,
6065 6065 
    analytical_stem.scrubbed_species_binomial AS accepted_species_binomial,
6066 6066 
    analytical_stem.scrubbed_taxon_name_with_author AS accepted_taxon_name_with_author,
6067 
    analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" AS dbh_cm,
6068 
    analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" AS height_m,
6067 6069 
    analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" AS lifeform
6068 6070 
   FROM analytical_stem
6069 6071 
  WHERE ((COALESCE((analytical_stem.geovalid_bien)::boolean, true) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND COALESCE((analytical_stem."taxonomicStatus__@DwC__@vegpath.org" = 'accepted'::text), false));
trunk/schemas/vegbien.sql
6064 6064 
    analytical_stem.scrubbed_genus AS accepted_genus,
6065 6065 
    analytical_stem.scrubbed_species_binomial AS accepted_species_binomial,
6066 6066 
    analytical_stem.scrubbed_taxon_name_with_author AS accepted_taxon_name_with_author,
6067 
    analytical_stem."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" AS dbh_cm,
6068 
    analytical_stem."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" AS height_m,
6067 6069 
    analytical_stem."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" AS lifeform
6068 6070 
   FROM analytical_stem
6069 6071 
  WHERE ((COALESCE((analytical_stem.geovalid_bien)::boolean, true) AND (NOT COALESCE((analytical_stem.cultivated_bien)::boolean, false))) AND COALESCE((analytical_stem."taxonomicStatus__@DwC__@vegpath.org" = 'accepted'::text), false));

Also available in: Unified diff