Project

General

Profile

« Previous | Next » 

Revision 12404

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql: renamed truncated views to match the output queries

View differences:

trunk/validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql
170 170 
-- Note: Assumes identical concatenation of taxonomic fields
171 171 
--       to form verbatim taxon name in vegBIEN.
172 172 
-- ------------------
173 
CREATE OR REPLACE VIEW _plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_project AS
173 
CREATE OR REPLACE VIEW _plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_each_p AS
174 174 
SELECT DISTINCT p.project_name, "SiteCode" AS plotcode,
175 175 
TRIM(CONCAT_WS(' ',IFNULL("Family",''),IFNULL("Genus",''),IFNULL("Species",''),
176 176 
IF(infra_ep_1 IS NULL,IFNULL(auth,''),
......
188 188 
-- Note: Assumes identical concatenation of taxonomic fields
189 189 
--       to form verbatim taxon name in vegBIEN
190 190 
-- ------------------
191 
CREATE OR REPLACE VIEW _plots_14_count_of_individuals_per_verbatim_taxon_per_plot_in_each_project AS
191 
CREATE OR REPLACE VIEW _plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_pr AS
192 192 
SELECT DISTINCT p.project_name, "SiteCode" AS plotcode,
193 193 
TRIM(CONCAT_WS(' ',IFNULL("Family",''),IFNULL("Genus",''),IFNULL("Species",''),
194 194 
IF(infra_ep_1 IS NULL,IFNULL(auth,''),
......
215 215 
--       per species per plot) in same query.
216 216 
-- Note 3: currently, there are no SALVIAS percent cover plots in BIEN
217 217 
-- ------------------
218 
CREATE OR REPLACE VIEW _plots_15_percent_cover_of_each_verbatim_taxon_in_each_plot_in_each_project AS
218 
CREATE OR REPLACE VIEW _plots_15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_pro AS
219 219 
SELECT DISTINCT p.project_name, "SiteCode" AS plotcode,
220 220 
TRIM(CONCAT_WS(' ',IFNULL("Family",''),IFNULL("Genus",''),IFNULL("Species",''),
221 221 
IF(infra_ep_1 IS NULL,IFNULL(auth,''),
......
242 242 
--       stratum) with plots without subplots or strata (one cover measure
243 243 
--       per species per plot.
244 244 
-- ------------------
245 
CREATE OR REPLACE VIEW _plots_16_intercept_values_for_each_verbatim_taxon_in_each_plot_in_each_project AS
245 
CREATE OR REPLACE VIEW _plots_16_intercepts_for_each_verb_taxon_in_each_plot_each_proj AS
246 246 
SELECT DISTINCT p.project_name, "SiteCode" AS plotcode,
247 247 
TRIM(CONCAT_WS(' ',IFNULL("Family",''),IFNULL("Genus",''),IFNULL("Species",''),
248 248 
IF(infra_ep_1 IS NULL,IFNULL(auth,''),

Also available in: Unified diff