Revision 13885
Added by Aaron Marcuse-Kubitza over 10 years ago
| 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)); |
Also available in: Unified diff
schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: added functional traits that we have 1st-class columns for (dbh_cm, height_m)