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 6045 about 12 years Aaron Marcuse-Kubitza make_analytical_db: Use new psql_verbose_vegbien
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 6040 about 12 years Aaron Marcuse-Kubitza inputs/import.stats.xls: Updated import times. ...
  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 6041 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: make_analytical_db(): Adde...
  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.5 KB 6015 about 12 years Aaron Marcuse-Kubitza README.TXT: Datasource setup: Moved Auto-create...
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
6045 11/08/2012 01:23 AM Aaron Marcuse-Kubitza

make_analytical_db: Use new psql_verbose_vegbien

6044 11/08/2012 01:22 AM Aaron Marcuse-Kubitza

Added psql_verbose_vegbien

6043 11/08/2012 01:18 AM Aaron Marcuse-Kubitza

make_analytical_db: Use psql_script_vegbien, which contains the necessary psq options, instead of setting those options manually

6042 11/08/2012 01:15 AM Aaron Marcuse-Kubitza

make_analytical_db: Run the SQL commands directly with psql instead of using the make_analytical_db() function. This provides incremental results and avoids running all commands in one transaction, thus preventing pgAdmin from freezing when the user attempts to access a table used in analytical DB creation (because the TRUNCATE statement fully locks the table until the entire analytical DB is built).

6041 11/08/2012 12:46 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: make_analytical_db(): Added make_family_higher_plant_group()

6040 11/08/2012 12:17 AM Aaron Marcuse-Kubitza

inputs/import.stats.xls: Updated import times. Fixed input row counts and import times to include derived data, such as TNRS and geoscrub, which adds to the import time and therefore should be considered in the import's speed. (TNRS was already being included in the import time for some, but not all, imports.)

6039 11/06/2012 05:02 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_*: Added higherPlantGroup

6038 11/06/2012 04:06 PM Aaron Marcuse-Kubitza

pg_dump_vegbien: When not in data mode, use --inserts so the INSERT statements generated can be run directly in pgAdmin, they can be directly translated to MySQL, and an empty COPY FROM statement isn't generated for every table

6037 11/06/2012 04:05 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Added family_higher_plant_group lookup table, generated with make_family_higher_plant_group() using the contents of higher_plant_group_nodes

6036 11/06/2012 03:40 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Added family_higher_plant_group lookup table, generated with make_family_higher_plant_group() using the contents of higher_plant_group_nodes

View all revisions | View revisions

Also available in: Atom