Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 4751 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 6063 about 12 years Aaron Marcuse-Kubitza psql_vegbien: Use bash because it supports subs...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 6052 about 12 years Aaron Marcuse-Kubitza inputs/.TNRS/tnrs/tnrs.make: Output the time at...
  lib 6027 about 12 years Aaron Marcuse-Kubitza lib/PostgreSQL-MySQL.csv: Remove SELECT pg_cata...
  mappings 6035 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Always map taxonN...
  schemas 6061 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_stem_view: Chan...
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 5971 about 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 9.89 KB 6023 about 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: DB and bien user: db...
README.TXT 12.7 KB 6059 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Before starting import...
map 989 Bytes 5158 about 12 years Aaron Marcuse-Kubitza root map: Removed no longer needed public schem...
new_terms.csv 30.4 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
6063 11/08/2012 07:47 AM Aaron Marcuse-Kubitza

psql_vegbien: Use bash because it supports substitutions

6062 11/08/2012 07:46 AM Aaron Marcuse-Kubitza

psql_vegbien: Set the search_path to $out_schemas set by vegbien_dest. This will enable running any psql_vegbien script on a schema other than public.

6061 11/08/2012 07:07 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: Changed inner joins on non-datasource taxonlabels to LEFT JOINs, to ensure that an entry is included in the analytical DB even if there was no matched taxonlabel. In theory, this shouldn't be necessary, because every taxonlabel should have a canonical taxonlabel since canon_label_id is auto-populated to the taxonlabel_id if there is no matched_label_id; there should be a taxonverbatim for every datasource and accepted taxonlabel because datasources link to taxonlabel via taxonverbatim and TNRS populates a taxonverbatim for every accepted taxonlabel; and there should be a parsed taxonlabel for every datasource taxonlabel because the mappings populate it.

6060 11/08/2012 06:56 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_stem_view: Removed join on specimenreplicate, because it isn't used in the analytical DB. Each specimen will still get an entry in analytical_*, because it gets its own location.

6059 11/08/2012 06:45 AM Aaron Marcuse-Kubitza

README.TXT: Data import: Before starting import, added step to run `make inputs/upload` and reinstall newly-uploaded datasources

6058 11/08/2012 03:22 AM Aaron Marcuse-Kubitza

README.TXT: Schema changes: Remember to update the following files with any renamings: Added mappings/verify.*.sql

6057 11/08/2012 02:21 AM Aaron Marcuse-Kubitza

README.TXT: Data import: make_analytical_db: Documented how to view progress in log file

6056 11/08/2012 02:18 AM Aaron Marcuse-Kubitza

make_analytical_db: Run all commands synchronously so the log file output doesn't become jumbled

6055 11/08/2012 02:16 AM Aaron Marcuse-Kubitza

make_analytical_db: Fixed bug where log file needed to be appended to instead of overwritten

6054 11/08/2012 02:15 AM Aaron Marcuse-Kubitza

make_analytical_db: Wrap each individual command in `set -x` to avoid echoing low-level commands such as sleep, wait

View all revisions | View revisions

Also available in: Atom