Activity
From 12/24/2011 to 01/22/2012
01/20/2012
- 03:02 PM Task #337 (Closed): VegBIEN table renames
- E-mail from Brad on 2012-1-20:
Hi Mike,
You and Aaron have convinced me. Bob & I were advocating a return to th... - 12:29 PM Task #338 (Resolved): put together samples of SALVIAS data that aggregates individuals and stems in different ways
- * individual count
* stem count
* individuals
* stems
01/19/2012
- 06:06 PM Task #337: VegBIEN table renames
- "observation" can be confusing, because it's not obvious what it's an observation of (a plot, an organism, a stem?). ...
- 06:02 PM Task #337 (Closed): VegBIEN table renames
- E-mail from Brad:
Conceptual definitions of tables:
observation: permanent attributes of a unit or area of obse... - 05:32 PM Task #336 (Resolved): create VegBIEN ERD
- Now live on [[VegBIEN schema]]!
- 04:56 PM Task #336: create VegBIEN ERD
- I discovered that MySQL Workbench can synchronize its model with an existing CREATE script. So, it looks like we can ...
- 04:54 PM Task #336 (Resolved): create VegBIEN ERD
- 11:35 AM Task #302 (Resolved): Make changes to VegBIEN schema
- Extensive changes have been made
- 11:33 AM Task #331 (Resolved): use VegX's individualOrganismObservation/relatedItem to model stems
- Stems are now modeled in VegX. (Note that _VegBIEN_ stems import not complete yet)
- 11:32 AM Task #319: Update statistics/lists of user-defined fields in use in VegX and VegBIEN
- I've done this for NYBG to VegX
- 11:31 AM Task #322 (Resolved): get access to raw CTFS data
- I have the data from Shash, including a SQL dump
- 11:30 AM Task #334 (Resolved): which DarwinCore attributes do we want to include in the specimen table?
- Desired fields have been added or moved from other tables
- 11:30 AM Task #314: Import CTFS data
- I have data from Shash and am working with her to make sure we can parse it
- 11:29 AM Task #318 (Resolved): decide whether to switch to VegX 1.5.2
- In fact, we will switch to 1.5.3, which is now available
01/13/2012
- 03:28 PM Task #335 (Rejected): Look into using Sybase Powerbuilder or IBM Enterprise Vision to map data
- The TACC (Texas Advanced Computing Center) people might have individual licenses they could let us use
01/12/2012
- 04:40 PM Task #334 (Resolved): which DarwinCore attributes do we want to include in the specimen table?
- 04:37 PM Task #314: Import CTFS data
- e-mails on 2012-1-12:
Steve Dolins:
We used the identical aggregate data file used for BIEN I... I think the da... - 04:30 PM Task #333 (Resolved): add traits table to VegBIEN
- 04:25 PM Task #318: decide whether to switch to VegX 1.5.2
- Brad: Yes! Latest version please, 1.5.2. It's about to get a lot less stable in any case, as we make more changes.
- 04:10 PM Task #318 (Resolved): decide whether to switch to VegX 1.5.2
- We have been mapping to VegX 1.5.1 (the latest stable version) but a release candidate VegX 1.5.2 is also available. ...
- 04:24 PM Task #332 (Rejected): switch to VegX 1.5.3
- 04:22 PM Task #331 (Resolved): use VegX's individualOrganismObservation/relatedItem to model stems
- 04:22 PM Task #330 (Rejected): DwC extension to VegX
- 04:22 PM Task #329 (New): make website user-protected
- 04:21 PM Task #328 (New): get raw data rather than flat file exports from RAINFOR
- 04:21 PM Task #327 (Resolved): look into Clio
- 04:21 PM Task #326 (Rejected): generic MOU template to request data
- 04:21 PM Task #325 (Resolved): map CTFS data
- 04:21 PM Task #324 (Resolved): NYBG validations
- 04:20 PM Task #323 (Resolved): map NYBG data
- 04:20 PM Task #322 (Resolved): get access to raw CTFS data
- 04:20 PM Task #321 (Resolved): Convert user-defined VegBIEN fields to first-class fields
- 04:20 PM Task #320 (Rejected): Convert user-defined VegX fields to first-class fields
- 04:20 PM Task #319 (Resolved): Update statistics/lists of user-defined fields in use in VegX and VegBIEN
- 01:25 PM Task #302: Make changes to VegBIEN schema
- I have applied most of Bob's changes to the VegBIEN schema, as well as many of Mark's suggestions. I posted a summary...
- 12:16 PM Task #317 (Rejected): Direct mapping from VegX to VegBIEN
- When complete, this will be a complete, generic mapping of all elements in VegX to all corresponding elements in VegB...
01/11/2012
- 11:08 AM Task #314: Import CTFS data
- e-mail from Brad Boyle on 2012-1-10:
Interesting observation. I must admit, I haven't inspected Shash's VegX yet, ...
01/10/2012
- 02:20 PM Task #314: Import CTFS data
- e-mail from Mark Schildhauer on 2012-1-10:
I think tt would be best (and certainly most scaleable) if the elements... - 01:20 PM Task #314: Import CTFS data
- Looking at Shash's VegX file, I noticed that she uses different VegX elements than we do for SALVIAS and NYBG data. F...
01/09/2012
- 04:44 PM Task #302: Make changes to VegBIEN schema
- Added new tables and moved/updated columns
- 04:44 PM Task #302: Make changes to VegBIEN schema
- I asked Bob a few questions about the new Collection table in the VegBIEN modifications:
* Is the Collection table m... - 11:40 AM Task #314: Import CTFS data
- I uploaded Shash's VegX file to vegbiendev at @/home/bien/svn/inputs/CTFS/src.VegX.xml@ .
01/05/2012
- 04:53 PM Task #311 (Resolved): Decouple VegBIEN from VegBank and map directly from VegX to VegBIEN
- Decoupled VegBIEN from VegBank and removed mappings to VegBank
- 03:07 PM Task #311 (Resolved): Decouple VegBIEN from VegBank and map directly from VegX to VegBIEN
- 03:09 PM Task #315 (New): Import TurboVeg data
- 03:09 PM Task #314 (Resolved): Import CTFS data
- * coordinate with Shash
* CTFS has a lot of stems data - 03:08 PM Task #313 (Resolved): Import full NYBG data
- 03:08 PM Task #312 (Resolved): Finish importing SALVIAS data
- # -Import stems data-
# -Fix data format issues-: _Not sure what these were, probably long fixed_
# -Map invalid da... - 11:26 AM Task #290: benchmark tests for database loading
- You can view the validation results by running the following on vegbiendev:
@make verify --directory=/home/bien/svn/... - 11:25 AM Task #305: Complete full-dataset validations for NYBG & SALVIAS
- You can view the validation results by running the following on vegbiendev:
@make verify --directory=/home/bien/svn/... - 11:25 AM Task #302: Make changes to VegBIEN schema
- The vegbien db now contains some of the modifications Bob Peet made to the VegBank schema for VegBIEN, so some table ...
- 11:24 AM Task #304: Complete full dataset imports to VegBIEN via VegX of NYBG and SALVIAS
- I loaded the SALVIAS data (plots and organisms) into VegBIEN on vegbiendev. To browse the data, follow the [[phpPgAdm...
01/04/2012
- 05:00 PM Task #305: Complete full-dataset validations for NYBG & SALVIAS
- Created mechanism to write verification queries and compare to desired output
- 04:57 PM Task #304: Complete full dataset imports to VegBIEN via VegX of NYBG and SALVIAS
- Core SALVIAS data (plots and organisms) are on vegbiendev in VegBIEN.
Takes overnight to reinsert organisms data whe... - 04:49 PM Task #303: Mapping from VegBIEN to original VegBank
- Search-and-replace operations that transform VegBank to VegBIEN can in many cases be reversed to transform VegBIEN to...
- 04:48 PM Task #302: Make changes to VegBIEN schema
- All functions that used to output to VegBank now output to VegBIEN db.
The VegBIEN schema is automatically generated... - 04:45 PM Task #296: Direct mapping from native salvias_plots MySQL database to VegBIEN
- We will also need to import the projects, stems, and lookup_MethodCode tables in order for all the verification queri...
- 04:43 PM Task #290: benchmark tests for database loading
- Created mechanism to write verification queries and compare to desired output
Also available in: Atom