Project

General

Profile

« Previous | Next » 

Revision 12602

Added by Aaron Marcuse-Kubitza almost 11 years ago

bugfix: inputs/SALVIAS/validations.sql: _plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_pro: changed summarizing column from mean_cover->totalpercentcover to match output query

View differences:

trunk/inputs/SALVIAS/validations.sql
277 277 
 SELECT DISTINCT p.project_name,
278 278 
    (pm."SiteCode")::text AS plot_code,
279 279 
    btrim(concat_ws(' '::text, ifnull(po."Family", ''::text), ifnull(po."Genus", ''::text), ifnull(po."Species", ''::text), if((po.infra_ep_1 IS NULL), ifnull(po.auth, ''::text), btrim(concat_ws(' '::text, ifnull(po.infra_rank_1, ''::text), ifnull(po.infra_ep_1, ''::text), ifnull(po.infra_auth_1, ''::text)))))) AS taxon,
280 
    avg(po.cover_percent) AS mean_cover
280 
    sum(po.cover_percent) AS totalpercentcover
281 281 
   FROM ((projects p
282 282 
   JOIN "plotMetadata" pm ON ((p.project_id = pm.project_id)))
283 283 
   JOIN "plotObservations" po ON (((pm."PlotID" = po."PlotID") AND (po.cover_percent IS NOT NULL))))

Also available in: Unified diff