Project

General

Profile

Statistics
| Revision:

root @ 4395

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 4394 about 12 years Aaron Marcuse-Kubitza schemas/Makefile: Analytical DB: analytical_db:...
  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 KB 4393 about 12 years Aaron Marcuse-Kubitza README.TXT: After a new import: Added command t...
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
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.
4388 08/30/2012 04:54 PM Aaron Marcuse-Kubitza

sql_io.py: null_strs: Added 'UNKNOWN'
4387 08/30/2012 04:02 PM Aaron Marcuse-Kubitza

Added inputs/FIA/
4386 08/30/2012 12:45 PM Aaron Marcuse-Kubitza

inputs/: Renamed subfolders to VegCSV names, using the steps at <https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCSV_subfolders#Rename-subfolders-to-VegCSV-names>

View all revisions | View revisions

Also available in: Atom