Project

General

Profile

Activity

From 09/05/2012 to 10/04/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...
Aaron Marcuse-Kubitza
01:02 PM Task #500 (New): when lower rank has name concatenated together, use lowest rank as the scientific name
Aaron Marcuse-Kubitza
12:57 PM Task #499 (Resolved): map example terms into the taxonomic schema
Aaron Marcuse-Kubitza
12:57 PM Task #498 (Resolved): add definitions to columns in "green tables"
Aaron Marcuse-Kubitza
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 Aaron Marcuse-Kubitza

09/18/2012

05:18 PM Task #495 (Resolved): add separate datasource table rather than using party for this
Aaron Marcuse-Kubitza
05:14 PM Task #494 (Resolved): add indexes for the analytical_db_view joins
Index added on specimenreplicate Aaron Marcuse-Kubitza
05:01 PM Task #494: add indexes for the analytical_db_view joins
Indexes added on locationevent, taxonoccurrence, aggregateoccurrence Aaron Marcuse-Kubitza
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... Aaron Marcuse-Kubitza

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
 

Also available in: Atom