Project

General

Profile

« Previous | Next » 

Revision 12166

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: shortened view names to fit in the 63-char limit

View differences:

trunk/validation/aggregating/plots/bien3_validations_salvias_vegbien.sql
213 213 
--
214 214 
-- Note: Must do equivalent concatenation of taxonomic field in source db.
215 215 
-- ------------------
216 
CREATE OR REPLACE VIEW _14_count_of_individuals_per_verbatim_taxon_per_plot_in_each_project AS
216 
CREATE OR REPLACE VIEW _14_count_of_indiv_per_verbatim_taxon_per_plot_in_each_project AS
217 217 
select distinct p.projectname, l.authorlocationcode as plotcode,
218 218 
trim('' || coalesce(family::text,'') || ' ' || coalesce(genus::text,'') || ' ' || coalesce(specific_epithet::text,'') || ' ' ||  coalesce(morphospecies::text,'')) as taxon,
219 219 
sum(ao.count) as individuals
......
237 237 
-- Check: join to source db by all columns, returns same number of rows
238 238 
-- Note: Must do equivalent concatenation of taxonomic field in source db.
239 239 
-- ------------------
240 
CREATE OR REPLACE VIEW _15_percent_cover_of_each_verbatim_taxon_in_each_plot_in_each_project AS
240 
CREATE OR REPLACE VIEW _15_pct_cover_of_each_verb_taxon_in_each_plot_in_each_project AS
241 241 
select distinct p.projectname, l.authorlocationcode as plotcode,
242 242 
trim('' || coalesce(family::text,'') || ' ' || coalesce(genus::text,'') || ' ' || coalesce(specific_epithet::text,'') || ' ' ||  coalesce(morphospecies::text,'')) as taxon,
243 243 
sum(ci.coverpercent) as totalpercentcover
......
268 268 
--       stratum) with plots without subplots or strata (one cover measure
269 269 
--       per species per plot.
270 270 
-- ------------------
271 
CREATE OR REPLACE VIEW _16_intercept_values_for_each_verbatim_taxon_in_each_plot_in_each_project AS
271 
CREATE OR REPLACE VIEW _16_intercepts_for_each_verb_taxon_in_each_plot_in_each_project AS
272 272 

  		




  273
  273
  
    

  		




  274
  274
  
    

  		












Also available in:  Unified diff