Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  NY 12896 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/specimens/NY/qualitative...
qualitative_validations_specimens.sql 4.68 KB 12895 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/specimens/**.sql: remove...

Latest revisions

# Date Author Comment
12896 03/26/2014 12:02 AM Aaron Marcuse-Kubitza

validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: use our staging tables instead of the BIEN2 MySQL staging tables

12895 03/25/2014 11:52 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/**.sql: removed trailing whitespace, using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#translate-to-Postgres

12894 03/25/2014 11:39 PM Aaron Marcuse-Kubitza

archived validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.sql

12893 03/25/2014 11:39 PM Aaron Marcuse-Kubitza

added validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql, copied from qualitative_validations_source_db_NYBG.sql

12892 03/25/2014 11:33 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: added ; at end of `CREATE OR REPLACE VIEW` statements

12890 03/24/2014 06:22 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: removed input-query-specific comments

12889 03/24/2014 06:21 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: reworded rowcount check comments to apply to the output queries

12888 03/24/2014 06:18 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: shortened view names to fit within the 63-char limit without truncation

12884 03/24/2014 05:22 PM Aaron Marcuse-Kubitza

fix: validation/aggregating/specimens/qualitative_validations_specimens.sql: changed "Full inner join" to "Full outer join" because a FULL JOIN is a type of outer join, not inner join

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.

View revisions

Also available in: Atom