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 6070 over 12 years Aaron Marcuse-Kubitza my2pg: Also remove column comments. Note that t...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 6075 over 12 years Aaron Marcuse-Kubitza inputs/bien_web/observation/map.csv: Omit *_ind...
  lib 6027 over 12 years Aaron Marcuse-Kubitza lib/PostgreSQL-MySQL.csv: Remove SELECT pg_cata...
  mappings 6069 over 12 years Aaron Marcuse-Kubitza mappings/VegCore.csv: Removed incorrect duplica...
  schemas 6068 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: _taxon_family_require_std(...
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 5971 over 12 years Aaron Marcuse-Kubitza Updated validation/BIEN2_Analytical_DB_overview...
Makefile 9.89 KB 6023 over 12 years Aaron Marcuse-Kubitza root Makefile: VegBIEN DB: DB and bien user: db...
README.TXT 12.7 KB 6059 over 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Before starting import...
map 989 Bytes 5158 over 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
6075 11/08/2012 12:39 PM Aaron Marcuse-Kubitza

inputs/bien_web/observation/map.csv: Omit *_index because they are placeholder columns created by the MySQL to PostgreSQL translation

6074 11/08/2012 12:37 PM Aaron Marcuse-Kubitza

input.Makefile: Maps building: %/.map.csv.last_cleanup: Fixed bug where can only canon/translate using $(srcDict) if it exists for the datasource

6073 11/08/2012 12:26 PM Aaron Marcuse-Kubitza

inputs/bien_web/observation/: Regenerated from actual bien_web.observation schema on nimoy, which has additional columns

6072 11/08/2012 12:24 PM Aaron Marcuse-Kubitza

input.Makefile: SVN: $(svnFilesGlob): Added top-level map.csv, which can be used to apply a datasource-global data dictionary to all tables

6071 11/08/2012 12:18 PM Aaron Marcuse-Kubitza

input.Makefile: Maps building: %/.map.csv.last_cleanup: Also apply any map.csv at the top level of the datasource directory. This can be used to apply a datasource-global data dictionary to all tables.

6070 11/08/2012 12:01 PM Aaron Marcuse-Kubitza

my2pg: Also remove column comments. Note that these cannot be translated by sed, because PostgreSQL only allows setting column comments in a separate statement, not inline with the column's entry in the CREATE TABLE statement, and sed can only make replacements contiguous with the input line.

6069 11/08/2012 11:28 AM Aaron Marcuse-Kubitza

mappings/VegCore.csv: Removed incorrect duplicate entry for verbatimSubgenus

6068 11/08/2012 10:58 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: _taxon_family_require_std(): Fixed bug where name needed to be lowercased before checking if it ended in -aceae, to support family names that are uppercase. Note that this resulted in the family not being prepended to the TNRS input name for datasources with uppercase family names, so the next DB import will likely produce a number of unscrubbed TNRS input names which now have the uppercase family prepended.

6067 11/08/2012 10:17 AM Aaron Marcuse-Kubitza

inputs/.TNRS/tnrs/tnrs.make: Fixed bug where need to reference the log file path relative to the make script itself, because otherwise the log file would go in inputs/.TNRS/logs/tnrs.make.log.sql

6066 11/08/2012 10:07 AM Aaron Marcuse-Kubitza

inputs/.TNRS/tnrs/tnrs.make: Fixed bug where need to use just the basename of $0 as the log file name

View all revisions | View revisions

Also available in: Atom