Project

General

Profile

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

Latest revisions

# Date Author Comment
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.

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.

View revisions

Also available in: Atom