Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  pipeline 12171 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/pipeline/aggregating_val...
  plots 12923 over 10 years Aaron Marcuse-Kubitza validation/**.sql: replaced CREATE OR REPLACE V...
  specimens 12932 over 10 years Aaron Marcuse-Kubitza validation/aggregating/specimens/qualitative_va...
  traits 12923 over 10 years Aaron Marcuse-Kubitza validation/**.sql: replaced CREATE OR REPLACE V...

Latest revisions

# Date Author Comment
12932 03/27/2014 07:35 AM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: implemented _specimens_01_count_of_total_records_specimens_in_source_db

12931 03/27/2014 07:34 AM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: added config statements for datasource and query planner

12926 03/27/2014 04:13 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/specimens/qualitative_validations_specimens.sql: use pg_dump's formatting for COMMENT ON to facilitate diffing against a pg_dump export of the DDL statements

12925 03/27/2014 04:07 AM Aaron Marcuse-Kubitza

validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: removed DDL statements so that running the query file does not alter the database, using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#remove-DDL-statements

12924 03/27/2014 04:01 AM Aaron Marcuse-Kubitza

validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: updated to DB, which pg_dump-formats the views

12923 03/27/2014 03:57 AM Aaron Marcuse-Kubitza

validation/**.sql: replaced CREATE OR REPLACE VIEW with CREATE VIEW to match pg_dump output for diffing

12921 03/27/2014 03:34 AM Aaron Marcuse-Kubitza

fix: validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: use pg_dump's formatting for COMMENT ON to facilitate diffing against a pg_dump export of the DDL statements

12918 03/26/2014 09:34 PM Aaron Marcuse-Kubitza

fix: validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: decimalLatitude/decimalLongitude: need to cast to double precision for numeric comparisons

12917 03/26/2014 09:33 PM Aaron Marcuse-Kubitza

fix: validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: CollectedDate: updated for refreshed NY data

12916 03/26/2014 09:30 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: fixed typos in column aliases

View revisions

Also available in: Atom