Project

General

Profile

Statistics
| Revision:

root/trunk @ 13061

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 about 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  _license 12225 almost 11 years Aaron Marcuse-Kubitza _license/non-open-source/applies_to.txt: clarif...
  backups 13008 almost 11 years Aaron Marcuse-Kubitza backups/TNRS.backup.md5: updated
  bin 12995 almost 11 years Aaron Marcuse-Kubitza bin/make_analytical_db: removed remake_diff_tab...
  config 11970 about 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  derived 11970 about 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  exports 12968 almost 11 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
  inputs 13056 almost 11 years Aaron Marcuse-Kubitza inputs/NY/run: documented `make inputs/NY/valid...
  issues 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
  lib 13058 almost 11 years Aaron Marcuse-Kubitza bugfix: lib/runscripts/table.run: table_make_in...
  mappings 12961 almost 11 years Aaron Marcuse-Kubitza fix: mappings/VegCore-VegBIEN.csv: taxonoccurre...
  planning 13053 almost 11 years Aaron Marcuse-Kubitza planning/workflow/bien3_architecture/stage_I.pn...
  schemas 13060 almost 11 years Aaron Marcuse-Kubitza fix: schemas/vegbien.sql: public_validations.re...
  validation 13061 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/**.sql output queries: u...
  web 12968 almost 11 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
  wiki 12124 almost 11 years Aaron Marcuse-Kubitza **/LICENSE.TXT: corrected "it recommended" to "...
.htaccess 326 Bytes 11970 about 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_filter.upload 33 Bytes 11970 about 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
.rsync_ignore 12 Bytes 11970 about 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 almost 11 years Aaron Marcuse-Kubitza /Makefile: postgres_restart-Linux: documented t...
README.TXT 31.5 KB 13031 almost 11 years Aaron Marcuse-Kubitza /README.TXT: Full database import: disk space: ...
fix_perms 97 Bytes 11970 about 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
map 1001 Bytes 11970 about 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
new_terms.csv 80.2 KB 11970 about 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
run 518 Bytes 12968 almost 11 years Aaron Marcuse-Kubitza *{.sh,run}: runscript targets: use begin_target...
unmapped_terms.csv 33 KB 11970 about 11 years Aaron Marcuse-Kubitza moved everything into /trunk/ to create the sta...
  • svn:ignore: extern

Latest revisions

# Date Author Comment
13061 04/07/2014 05:35 PM Aaron Marcuse-Kubitza

validation/aggregating/**.sql output queries: use `SET join_collapse_limit = 1;` to match public_validations.rematerialize_out_view()
13060 04/07/2014 05:17 PM Aaron Marcuse-Kubitza

fix: schemas/vegbien.sql: public_validations.rematerialize_out_view(text, regclass): run with join_collapse_limit = 1 to fix query planner issues. this option has been tested on the queries that do not yet use the standard join sequence (plots #11,12,13,14,16,17,18), and all of these queries also work fine with join_collapse_limit = 1. (the standard join sequence is used to ensure both correctness of the query and compatibility with join_collapse_limit = 1, but in some cases is not needed for join_collapse_limit.)
13059 04/07/2014 04:35 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: _specimens_12_distinct_collector_name_collect_num_date_w_count: turn off join_collapse_limit instead of enable_mergejoin/enable_hashjoin, because join_collapse_limit is something that we will eventually want to turn off for all queries, which would avoid this query needing special handling. (on the other hand, enable_mergejoin/enable_hashjoin may be necessary for some queries and we probably won't turn them off for all queries.)
13058 04/07/2014 01:43 PM Aaron Marcuse-Kubitza

bugfix: lib/runscripts/table.run: table_make_install(): need to ignore skip_table() errexit
13057 04/07/2014 10:39 AM Aaron Marcuse-Kubitza

lib/sh/util.sh: import_vars: documented that vars already set will not be overwritten
13056 04/07/2014 09:47 AM Aaron Marcuse-Kubitza

inputs/NY/run: documented `make inputs/NY/validate` runtime (2 min, currently for the input queries)
13055 04/04/2014 06:13 PM Aaron Marcuse-Kubitza

added inputs/Madidi/_src/ to match wiki steps in wiki.vegpath.org/Adding_a_flat-file_datasource
13054 04/03/2014 07:31 PM Aaron Marcuse-Kubitza

added validation/aggregating/pipeline/validations_on_sparse_datasources.odg
13053 04/03/2014 04:13 PM Aaron Marcuse-Kubitza

planning/workflow/bien3_architecture/stage_I.png, stages.png: synced to bien3_architecture.pptx
13052 04/03/2014 04:09 PM Aaron Marcuse-Kubitza

planning/workflow/bien3_architecture.pptx: stage I: made all datasources the same height so that the denormalized VegCore schema boxes would all look exactly the same. widened the denormalized VegCore schema boxes to make it visually clear that they have more columns than the staging tables denormalized together

View revisions

Also available in: Atom