Project

General

Profile

Statistics
| Revision:

root/trunk @ 13131

Name Size Revision Age Author Comment
  BIEN2 12779 almost 11 years Aaron Marcuse-Kubitza *{.sh,run}: use new begin_target instead of `ec...
  _archive 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  _license 13088 over 10 years Aaron Marcuse-Kubitza _license/UCSB/LICENSE.TXT: use (c) verbatim fro...
  backups 13008 over 10 years Aaron Marcuse-Kubitza backups/TNRS.backup.md5: updated
  bin 13077 over 10 years Aaron Marcuse-Kubitza bin/repl: match as whole-word text (like SQL id...
  config 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  derived 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  exports 12968 over 10 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
  inputs 13130 over 10 years Aaron Marcuse-Kubitza bugfix: inputs/NY/validations.sql: _specimens_1...
  issues 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
  lib 13116 over 10 years Aaron Marcuse-Kubitza bugfix: lib/sh/util.sh: local_array/export_arra...
  mappings 13115 over 10 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: mapped subspecies...
  planning 13053 over 10 years Aaron Marcuse-Kubitza planning/workflow/bien3_architecture/stage_I.pn...
  schemas 13131 over 10 years Aaron Marcuse-Kubitza fix: schemas/vegbien.sql: _specimens_13_count_o...
  validation 13128 over 10 years Aaron Marcuse-Kubitza validation/aggregating/pipeline/aggregating_val...
  web 13114 over 10 years Aaron Marcuse-Kubitza bugfix: web/.phpPgAdmin/.htaccess: work around ...
  wiki 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
.htaccess 326 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_filter.upload 33 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_ignore 12 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
LICENSE.TXT 6.18 KB 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
Makefile 13.7 KB 13015 over 10 years Aaron Marcuse-Kubitza /Makefile: postgres_restart-Linux: documented t...
README.TXT 31.7 KB 13119 over 10 years Aaron Marcuse-Kubitza bugfix: /README.TXT: Full database import: to i...
fix_perms 97 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
map 1001 Bytes 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
new_terms.csv 80.2 KB 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
run 518 Bytes 12968 over 10 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
unmapped_terms.csv 33 KB 11970 almost 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  • 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 revisions

Also available in: Atom