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