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

10/17/2012

12:02 PM Task #497 (Resolved): create examples of taxonomic names to test the limits of the new taxonomic schema

See "*testNames.txt*":https://projects.nceas.ucsb.edu/nceas/attachments/download/377/testNames.txt Aaron Marcuse-Kubitza

10/12/2012

05:01 AM Task #498 (Resolved): add definitions to columns in "green tables"

Definitions have been added on all new tables (currently taxonconcept and taxonconcept_ancestor). Other tables' colum... Aaron Marcuse-Kubitza

04:56 AM Task #462 (Resolved): name backups according to svn revision instead of or in addition to the date

This now happens for backups as well as log files Aaron Marcuse-Kubitza

01:06 AM Task #522 (New): fix deadlock when multiple testers are running simultaneously

Commands running simultaneously:
* @make inputs/.TNRS/tnrs/test.by_col.xml verbosity=3@
* @make test by_col=1@
... Aaron Marcuse-Kubitza

10/11/2012

09:53 PM Task #521 (Resolved): make place* tables use a structure similar to taxonconcept

Aaron Marcuse-Kubitza