Project

General

Profile

Activity

From 08/19/2012 to 09/17/2012

09/17/2012

10:06 AM Task #383: convert VegBank data dictionary to database comments
Bob wants a VegBIEN data dictionary Aaron Marcuse-Kubitza
07:09 AM Task #327 (Resolved): look into Clio
*[[Column-based import]]* does effectively what "*Clio*":http://www.almaden.ibm.com/cs/projects/criollo/ does Aaron Marcuse-Kubitza
07:07 AM Task #427 (Resolved): Load all plots data
All *[[Databanks#BIEN 2 datasources|BIEN2 plots data*]] has been loaded, including the core fields of VegBank Aaron Marcuse-Kubitza
07:05 AM Task #288 (Resolved): VegX-VegBank mapping
We now map "VegX->VegCore":https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/mappings/VegX-VegCore.c... Aaron Marcuse-Kubitza
07:03 AM Task #314 (Resolved): Import CTFS data
Aaron Marcuse-Kubitza
07:02 AM Task #368 (Rejected): get TEAM VegX data
Not needed because we have the raw TEAM data, which is easier to work with than XML Aaron Marcuse-Kubitza
07:01 AM Task #455 (Resolved): change summarizing queries to use vegbien staging tables
Aaron Marcuse-Kubitza
06:59 AM Task #441 (Resolved): import CTFS data using JOINs from DB export, not VegX
Aaron Marcuse-Kubitza
06:58 AM Task #317 (Rejected): Direct mapping from VegX to VegBIEN
We instead have a mapping from "VegX to VegCore":https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/m... Aaron Marcuse-Kubitza

09/10/2012

06:55 PM Task #490 (New): change import.stats.xls to use field rather than row count
* This will be more accurate, because different data sources have different #s of columns, and this affects the load ... Aaron Marcuse-Kubitza

09/05/2012

08:26 AM Task #484 (Resolved): support installing staging tables directly from a MySQL export
Aaron Marcuse-Kubitza

08/31/2012

06:55 PM Task #486 (New): add unit-conversion mechanism
* This is primarily needed for DBH, plot area, and elevation/depth
* Make quantities with units be a tuple type cont...
Aaron Marcuse-Kubitza
02:34 PM Task #485 (New): track data provider's citation requirements in VegBIEN
* Some providers require them to be cited on any analysis that's conducted with their data:
** "Forest Plots Databas...
Aaron Marcuse-Kubitza
02:08 PM Task #483 (Rejected): rename staging table columns according to map.csv
Reinstalling staging tables whenever a mapping changes is not a good idea.
Renaming will instead continue to occur d...
Aaron Marcuse-Kubitza

08/30/2012

08:49 AM Task #484 (Resolved): support installing staging tables directly from a MySQL export
* requires (re-)exporting MySQL DB with "@--compatible=postgresql@":http://dev.mysql.com/doc/refman/5.6/en/mysqldump.... Aaron Marcuse-Kubitza

08/29/2012

04:16 PM Task #483 (Resolved): rename staging table columns according to map.csv
* This will allow us to have just one VegCore-VegBIEN mapping, with each staging table already using VegCore column n... Aaron Marcuse-Kubitza

08/28/2012

06:57 PM Task #482 (New): translate README.TXT to wiki page
* This will provide easy-to-read formatting to what is currently a plain text file Aaron Marcuse-Kubitza
06:31 PM Task #464 (Resolved): reverse XPaths so that they start with location instead of plantobservation or specimenreplicate
> CTFS's two test rows needed to be disabled because they require a transformation of the new mappings
CTFS is bei...
Aaron Marcuse-Kubitza
06:30 PM Task #471 (Resolved): add make actions so new dependent maps are rebuilt automatically when their source map changes
This appears to be fixed now that the primary map refactoring is done and the symlinks are gone Aaron Marcuse-Kubitza
06:29 PM Task #458 (Resolved): map all VegX sources to stems table
Aaron Marcuse-Kubitza
06:28 PM Task #452 (Resolved): add column-based import to automated testing
@make test by_col=1@ Aaron Marcuse-Kubitza

08/27/2012

05:51 PM Task #480 (Resolved): automate adding a new table to an existing datasource
@make inputs/<datasrc>/<table>/add@ Aaron Marcuse-Kubitza

08/24/2012

07:51 PM Task #480 (Resolved): automate adding a new table to an existing datasource
Aaron Marcuse-Kubitza

08/23/2012

01:44 PM Task #477 (Rejected): allow putting specimens data directly in the top level of the datasource directory
* this avoids needing to create a single @specimens@ subdir for the DwC CSV
* need to work around make's autoremoval...
Aaron Marcuse-Kubitza
01:39 PM Task #476 (New): develop map spreadsheet -> header override file translation utility
* this will avoid the need to create a @map.full.csv@ and @VegBIEN.csv@ file for each table, because @mappings/Veg+-V... Aaron Marcuse-Kubitza
 

Also available in: Atom