Project

General

Profile

Statistics
| Revision:

root @ 4398

Name Size Revision Age Author Comment
  _archive 1598 over 12 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 4200 over 12 years Aaron Marcuse-Kubitza backups/: svn:ignore: Also ignore .*, which inc...
  bin 4395 about 12 years Aaron Marcuse-Kubitza Added make_analytical_db
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 4389 about 12 years Aaron Marcuse-Kubitza inputs/import.stats.xls: Updated with stats fro...
  lib 4388 about 12 years Aaron Marcuse-Kubitza sql_io.py: null_strs: Added 'UNKNOWN'
  mappings 4382 about 12 years Aaron Marcuse-Kubitza mappings/Veg+-VegCore.csv: Remapped CTFS Quadra...
  schemas 4398 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: make_analytical_db(): Remo...
  to_do 4091 over 12 years Aaron Marcuse-Kubitza to_do/: svn:ignore OpenOffice lock files
Makefile 10.1 KB 3764 over 12 years Aaron Marcuse-Kubitza root Makefile, input.Makefile: Maps validation:...
README.TXT 10.1 KB 4396 about 12 years Aaron Marcuse-Kubitza README.TXT: After a new import: Use bin/make_an...
map 1.22 KB 3475 over 12 years Aaron Marcuse-Kubitza root map: Run bin/map with a nice increment of ...

Latest revisions

# Date Author Comment
4398 09/04/2012 04:25 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: make_analytical_db(): Removed explicit schema reference so that the function can be redirected to use the current (rotated) schema using the search_path
4397 08/31/2012 08:32 PM Aaron Marcuse-Kubitza

schemas/Makefile: Removed no longer needed analytical_db, which has been replaced by bin/make_analytical_db
4396 08/31/2012 08:31 PM Aaron Marcuse-Kubitza

README.TXT: After a new import: Use bin/make_analytical_db instead of `make schemas/analytical_db`, and run it asynchronously because it takes a long time
4395 08/31/2012 08:29 PM Aaron Marcuse-Kubitza

Added make_analytical_db
4394 08/31/2012 08:22 PM Aaron Marcuse-Kubitza

schemas/Makefile: Analytical DB: analytical_db: Time the creation of the analytical DB
4393 08/31/2012 08:18 PM Aaron Marcuse-Kubitza

README.TXT: After a new import: Added command to make the analytical DB
4392 08/31/2012 08:15 PM Aaron Marcuse-Kubitza

schemas/Makefile: Added analytical_db target
4391 08/31/2012 08:09 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Added make_analytical_db() and helper view analytical_db_view. Note that adding a view which depends on other tables will cause those tables to be reordered in dependency order to appear before the view, causing the svn diff to change completely even though the DB structure has only been added to.
4390 08/31/2012 08:05 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Removed OIDs from tables because we don't use them (tables have primary keys instead)
4389 08/31/2012 02:23 PM Aaron Marcuse-Kubitza

inputs/import.stats.xls: Updated with stats from latest import. This now includes CTFS.TaxonOccurrence (presence-only observations), FIA (11 million rows!), and Madidi.Organism. The addition of FIA almost doubles the # of rows to 26 million and increases the import time from 9.5 to 11.5 hours.

View all revisions | View revisions

Also available in: Atom