Project

General

Profile

Statistics
| Revision:

root @ 13131

Name Size Revision Age Author Comment
  branches 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  tags 11969 almost 11 years Aaron Marcuse-Kubitza added standard svn dirs branches, tags, trunk
  trunk 13131 over 10 years Aaron Marcuse-Kubitza fix: schemas/vegbien.sql: _specimens_13_count_o...
  • svn:ignore: extern

Latest revisions

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

fix: schemas/vegbien.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: need to DISTINCT the values that are being counted, because the coordinates_unique unique constraint includes other columns as well, so there may be multiple instances of each lat/long
13130 04/14/2014 04:51 PM Aaron Marcuse-Kubitza

bugfix: inputs/NY/validations.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: need to include both lat and long in the value to DISTINCT on
13129 04/14/2014 04:48 PM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql: _specimens_13_count_of_all_verbatim_and_decimal_lat_long: need to DISTINCT the values that are being counted, because they are merged by the coordinates_unique unique constraint in the import
13128 04/14/2014 04:24 PM Aaron Marcuse-Kubitza

validation/aggregating/pipeline/aggregating_validations_pipeline.odg: diff tables: integrated row labels into table
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)
13126 04/14/2014 03:58 PM Aaron Marcuse-Kubitza

inputs/NY/run: `make inputs/NY/validate`: documented slow queries: _specimens_12_distinct_collector_name_collect_num_date_w_count
13125 04/14/2014 03:23 PM Aaron Marcuse-Kubitza

inputs/SALVIAS/run_: `make inputs/SALVIAS/validate`: documented slow queries (_plots_06a_list_of_stems). these may need to have their query plans rechecked.
13124 04/14/2014 03:22 PM Aaron Marcuse-Kubitza

inputs/NY/run, inputs/SALVIAS/run_: `make inputs/.../validate`: updated runtime (+2 min)
13123 04/10/2014 04:06 PM Aaron Marcuse-Kubitza

fix: inputs/NY/validations.sql: specimens*_of_unique_verbatim_author_taxa_with_genus: use scientificName rather than the concatenated ranks, because that is what is imported to taxonlabel.taxonomicname
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

View all revisions | View revisions

Also available in: Atom