Activity
From 08/30/2012 to 09/28/2012
09/24/2012
- 01:04 PM Task #501 (Resolved): find out which datasources won't allow their data to be publicly accessible
- * needed before we can make VegBIEN public
These datasources are:
* "REMIB":http://www.conabio.gob.mx/remib/cgi... - 01:02 PM Task #500 (New): when lower rank has name concatenated together, use lowest rank as the scientific name
- 12:57 PM Task #499 (Resolved): map example terms into the taxonomic schema
- 12:57 PM Task #498 (Resolved): add definitions to columns in "green tables"
- 12:57 PM Task #497 (Resolved): create examples of taxonomic names to test the limits of the new taxonomic schema
- * need types of morphospecies indicators
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....
Also available in: Atom