Activity
From 08/22/2012 to 09/20/2012
09/18/2012
- 05:18 PM Task #495 (Resolved): add separate datasource table rather than using party for this
- 05:14 PM Task #494 (Resolved): add indexes for the analytical_db_view joins
- Index added on specimenreplicate
- 05:01 PM Task #494: add indexes for the analytical_db_view joins
- Indexes added on locationevent, taxonoccurrence, aggregateoccurrence
- 04:38 PM Task #494 (Resolved): add indexes for the analytical_db_view joins
- * *_unique indexes are often used in joins, but some (such as locationevent_unique_within_location) have filter condi...
09/17/2012
- 10:06 AM Task #383: convert VegBank data dictionary to database comments
- Bob wants a VegBIEN data dictionary
- 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
- 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
- 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...
- 07:03 AM Task #314 (Resolved): Import CTFS data
- 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
- 07:01 AM Task #455 (Resolved): change summarizing queries to use vegbien staging tables
- 06:59 AM Task #441 (Resolved): import CTFS data using JOINs from DB export, not VegX
- 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...
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 ...
09/05/2012
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... - 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... - 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...
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....
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...
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
- 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... - 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
- 06:29 PM Task #458 (Resolved): map all VegX sources to stems table
- 06:28 PM Task #452 (Resolved): add column-based import to automated testing
- @make test by_col=1@
08/27/2012
- 05:51 PM Task #480 (Resolved): automate adding a new table to an existing datasource
- @make inputs/<datasrc>/<table>/add@
08/24/2012
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... - 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...
Also available in: Atom