Project

General

Profile

Activity

From 11/08/2012 to 12/07/2012

12/06/2012

08:21 PM Task #474 (Rejected): use svn to figure out when a map file has changed and needs to be cleaned up
This would prevent forcing a cleanup by touching the map file Aaron Marcuse-Kubitza
08:16 PM Task #309 (Rejected): mapping and export utility from VegBank to VegX
We are importing VegBank directly into VegBIEN rather than via VegX Aaron Marcuse-Kubitza
08:13 PM Task #299 (Resolved): Mapping from NVS to VegX and VegBIEN
Done for spreadsheet extract provided by Nick Spencer, on vegbiendev in @/home/bien/svn/inputs/NVS/_src/@. We aren't ... Aaron Marcuse-Kubitza
08:13 PM Task #477 (Rejected): allow putting specimens data directly in the top level of the datasource directory
This would prevent adding a separate metadata table later on, so we don't want to allow this Aaron Marcuse-Kubitza
08:11 PM Task #544 (New): integrate creation of analytical DB into automated testing
Aaron Marcuse-Kubitza

12/03/2012

12:10 PM Task #539 (Rejected): get analytical_stem_view to use merge joins instead of hash joins
* This will speed up the joins, which used to take 0.5 hour but now take 2.5 hours
* It will also reduce the disk sp...
Aaron Marcuse-Kubitza

11/08/2012

03:56 AM Task #346: add georeferencing support to schema
Georeferencing information can be stored in the geovalidation place entry, which the original place is linked to via ... Aaron Marcuse-Kubitza
03:42 AM Task #292: VegBank metadata query mechanism
Added possible strategy Aaron Marcuse-Kubitza
03:32 AM Task #343 (Resolved): integrate TNRS into VegBIEN
Aaron Marcuse-Kubitza
03:32 AM Task #308 (Resolved): do a direct transfer of some public data from VegBank
Core fields in VegBank have been mapped. A recent full export of the live VegBank DB is used as the input. Aaron Marcuse-Kubitza
03:31 AM Task #335 (Rejected): Look into using Sybase Powerbuilder or IBM Enterprise Vision to map data
We are using map spreadsheets and auto-mapping instead, which work well so far and would not be easy to translate to ... Aaron Marcuse-Kubitza
03:30 AM Task #312: Finish importing SALVIAS data
Still need to map methods, probably using LEFT JOIN Aaron Marcuse-Kubitza
03:27 AM Task #365 (Rejected): retrieve taxonomic hierarchy in analytical layer by using dynamic queries to external sources
We're using a fixed version of the NCBI tree of life instead Aaron Marcuse-Kubitza
03:26 AM Task #424: Finish translating XML functions to SQL functions for column-based import
Most translated; still left:
* _map
* _range*
* _avg
* _compass
* a few others
Aaron Marcuse-Kubitza
03:24 AM Task #440: aggregating validations of imports
Queries work for current schema Aaron Marcuse-Kubitza
03:22 AM Task #454 (Resolved): update summarizing queries for current schema
@make inputs/SALVIAS/verify/@ and @make inputs/NY/verify/@ work again Aaron Marcuse-Kubitza
03:16 AM Task #476 (Rejected): develop map spreadsheet -> header override file translation utility
Shouldn't do this because it would prevent map spreadsheets from having multiple output locations for the same input ... Aaron Marcuse-Kubitza
03:11 AM Task #495 (Resolved): add separate datasource table rather than using party for this
Now using @reference@ for this Aaron Marcuse-Kubitza
03:07 AM Task #521 (Resolved): make place* tables use a structure similar to taxonconcept
Aaron Marcuse-Kubitza
 

Also available in: Atom