Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  FIA 12058 over 10 years Aaron Marcuse-Kubitza added validation/aggregating/plots/FIA/bien3_va...
  SALVIAS 12397 over 10 years Aaron Marcuse-Kubitza added validation/aggregating/plots/SALVIAS/bien...
  _archive 12061 over 10 years Aaron Marcuse-Kubitza validation/**: removed by=... indicators so tha...
bien3_validations_salvias_vegbien.sql 13.3 KB 12224 over 10 years Aaron Marcuse-Kubitza validation/aggregating/*/*.sql, schemas/vegbien...

Latest revisions

# Date Author Comment
12397 02/24/2014 12:16 AM Aaron Marcuse-Kubitza

added validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.VegCore.sql, modified from bien3_validations_salvias_db_original.sql using the steps at http://wiki.vegpath.org/Aggregating_validations_refactoring

12224 02/14/2014 03:09 PM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql, schemas/vegbien.sql, lib/runscripts/validations.pg.sql.run, inputs/bien2_traits/validations.sql: added _ to beginning of each view name so the validation views would sort at the top in the datasource's tables list. this will also make the validation result sets easily distinguishable from the data tables.

12223 02/14/2014 02:34 PM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: renamed views to match the current naming scheme in the DB. these files still need to be kept up-to-date because there are some queries that haven't been implemented yet, and therefore exist only in these files, not the DB.

12172 02/13/2014 10:41 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql, validation/aggregating/*/*.sql: renamed public_validation_* to plural public_validations_* since we refer to them as aggregating validation*s*

12167 02/13/2014 08:26 AM Aaron Marcuse-Kubitza

validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _12_count_of_verbatim_taxa_per_plot_in_each_project: removed typo (in the original queries, not added by the refactoring)

12166 02/13/2014 08:23 AM Aaron Marcuse-Kubitza

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

12163 02/13/2014 08:02 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: use "" to preserve case in column aliases, so that they match the input queries

12162 02/13/2014 07:58 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: use current_schema instead of a hardcoded datasource name or psql variable

12161 02/13/2014 07:49 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: search_path: added public

12160 02/13/2014 07:45 AM Aaron Marcuse-Kubitza

validation/aggregating/*/*.sql: use the new type-specific validation schema names

View revisions

Also available in: Atom