Project

General

Profile

Statistics
| Revision:

root/trunk/validation/aggregating @ 13127

Name Size Revision Age Author Comment
  pipeline 13127 over 10 years Aaron Marcuse-Kubitza validation/aggregating/pipeline/aggregating_val...
  plots 13103 over 10 years Aaron Marcuse-Kubitza removed old version validation/aggregating/plot...
  specimens 13122 over 10 years Aaron Marcuse-Kubitza validation/aggregating/specimens/NY/qualitative...
  traits 13061 over 10 years Aaron Marcuse-Kubitza validation/aggregating/**.sql output queries: u...

Latest revisions

# Date Author Comment
13127 04/14/2014 04:04 PM Aaron Marcuse-Kubitza

validation/aggregating/pipeline/aggregating_validations_pipeline.odg: diff tables: added line for different rows (vs. missing/extra)
13122 04/10/2014 03:52 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: updated to inputs/NY/validations.sql
13121 04/10/2014 03:50 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: updated to DB
13103 04/10/2014 06:38 AM Aaron Marcuse-Kubitza

removed old version validation/aggregating/plots/SALVIAS/bien3_validations_salvias_db_original.sql. use validation/aggregating/plots/SALVIAS/_archive/bien3_validations_salvias_db_original.sql instead.
13102 04/10/2014 06:19 AM Aaron Marcuse-Kubitza

validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: updated to inputs/NY/validations.sql
13101 04/10/2014 06:17 AM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: updated to DB
13087 04/10/2014 02:07 AM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql, inputs/NY/validations.sql, validation/aggregating/specimens/qualitative_validations_specimens.sql: _specimens_12_distinct_collector_name_collect_num_date_w_count: dateCollected: cast this to text rather than date because some values for this field are not valid dates and will throw an error if cast to date
13085 04/09/2014 06:23 PM Aaron Marcuse-Kubitza

validation/aggregating/pipeline/aggregating_validations_pipeline.odg: show that the staging table(s) are denormalized before running the input queries on them. clarified that what is compared are the input and output query results, not the queries themselves.
13083 04/09/2014 02:48 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: removed `public.` prefix to avoid cluttering up the SQL
13082 04/09/2014 02:46 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql, validation/aggregating/specimens/qualitative_validations_specimens.sql: _specimens_10_count_number_of_records_by_institution: need to dereference specimenreplicate.duplicate_institutions_sourcelist_id to the corresponding sourcelist.name

View revisions

Also available in: Atom