Project

General

Profile

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

Latest revisions

# Date Author Comment
6065 11/08/2012 09:51 AM Aaron Marcuse-Kubitza

Added inputs/IUCN/

6064 11/08/2012 09:51 AM Aaron Marcuse-Kubitza

input.Makefile: SVN: add: Added _src/ (when it exists). $(_svnFilesGlob): Added .url, .pdf files in _src/.

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

View all revisions | View revisions

Also available in: Atom