Project

General

Profile

Activity

From 01/24/2013 to 02/22/2013

02/14/2013

11:04 AM Task #566 (New): automatically adjust staging tables for easier mapping
* remove empty columns
* mark columns with data in every row as NOT NULL
Aaron Marcuse-Kubitza
07:20 AM Task #386 (Resolved): load Canadensys data
Aaron Marcuse-Kubitza
07:19 AM Task #470 (Resolved): source terms from old versions of DwC to the DwC history page
Aaron Marcuse-Kubitza
07:18 AM Task #472 (Rejected): replace accessioncodes with datasource_id+sourceaccessioncode
Accessioncode fields have been removed instead. Globally unique ID fields (#561) will eventually serve the purpose th... Aaron Marcuse-Kubitza
07:06 AM Task #565 (Resolved): partition the TaxonDetermination table by row into the different types of determinations
* this makes it easy to horizontally join the different types of determinations for a row
** it avoids the need for ...
Aaron Marcuse-Kubitza
06:37 AM Task #564 (New): make all VegBIEN column names globally unique
* this enables creating a table to contain the results of a join, without needing to resolve column name collisions
...
Aaron Marcuse-Kubitza
06:33 AM Task #563 (New): refactor VegBIEN to use VegCore terms
* add key VegCore tables such as Occurrence and Record
* note that many VegCore tables have an inheritance relations...
Aaron Marcuse-Kubitza
05:17 AM Task #562 (New): flatten the mappings
* put the destination table at the beginning of the mapping, rather than nesting it within a hierarchy of tables it h... Aaron Marcuse-Kubitza
04:47 AM Task #561 (New): make VegBIEN ID fields plain-text instead of numeric
h3. Rationale
* this makes it possible to append data from multiple sources without having pkey collisions
h3. ...
Aaron Marcuse-Kubitza
04:12 AM Task #560 (New): move VegCore data dictionary to a phpPgAdmin-accessible database
* term details go in column comments, with Redmine formatting translated to HTML
* each synonym becomes a parameter ...
Aaron Marcuse-Kubitza
 

Also available in: Atom