Project

General

Profile

Gantt

Filters

Zoom in Zoom out « December 2024 | February »

months from Apply Clear

Working Groups
BIEN 3
Task #286: CSV-XML-database mapping script
Task #292: VegBank metadata query mechanism
Task #293: mapping inversion script
Task #298: Try to find source of DwCA (DwC Archives) data
Task #300: TurboVeg data
Task #303: Mapping from VegBIEN to original VegBank
Task #315: Import TurboVeg data
Task #328: get raw data rather than flat file exports from RAINFOR
Task #329: make website user-protected
Task #339: have "schema showdown"
Task #341: create verbal descriptions of edge cases
Task #346: add georeferencing support to schema
Task #349: make ERD of full schema
Task #378: create automated feedback mechanism
Task #383: convert VegBank data dictionary to database comments
Task #387: count how many duplicates between Canadensys and GBIF
Task #424: Finish translating XML functions to SQL functions for column-based import
Task #440: aggregating validations of imports
Task #446: fix deadlock in INSERT IGNORE replacement
Task #448: timeout ANALYZE queries
Task #449: optimize JOINs on existing rows
Task #450: cast all untyped literals as text using cast_literal()
Task #451: verify database contents as part of automated testing
Task #453: cluster vegbien tables periodically
Task #456: test that querying the DB uses the unique indexes instead of a seq scan
Task #457: use driver-native autocommit mode instead of our custom autocommit implementation
Task #459: data provider feedback: propagate srcs (input columns for an intermediate column) for all tables, not just SQL functions?
Task #461: don't display warning when nullable boolean columns are handled without using COALESCE()
Task #465: move issue tracker comments to wiki pages to ensure version history
Task #467: underline all to do items in meetings notes
Task #469: give everyone their own account on vegbien
Task #476: develop map spreadsheet -> header override file translation utility
Task #482: translate README.TXT to wiki page
Task #485: track data provider's citation requirements in VegBIEN
Task #486: add unit-conversion mechanism
Task #490: change import.stats.xls to use field rather than row count
Task #500: when lower rank has name concatenated together, use lowest rank as the scientific name
Task #522: fix deadlock when multiple testers are running simultaneously
Task #544: integrate creation of analytical DB into automated testing
Task #548: remove benign errors from the data provider feedback tables
Task #560: move VegCore data dictionary to a phpPgAdmin-accessible database
Task #561: make VegBIEN ID fields plain-text instead of numeric
Task #562: flatten the mappings
Task #563: refactor VegBIEN to use VegCore terms
Task #564: make all VegBIEN column names globally unique
Task #566: automatically adjust staging tables for easier mapping
Task #573: automap the analytical DB columns
Task #574: mechanism to manually override the CSV dialect, encoding, etc.
Task #575: put all wiki attachments in svn
Task #576: merge the datasources' mappings into the VegCore data dictionary
Task #578: replace all fields of type text with a domain type that ensures the value is non-empty (not '')
Task #579: in sql_gen.EnsureNotNull, use ARRAY[] instead of COALESCE() to wrap values where NULL should be compared literally
Task #580: automap each word *in* a VegCore term instead of just the whole term
Task #581: mechanism to dynamically autopopulate NOT NULL values
Task #636: support TNRS-matching names in "", insted of encoding them and letting TNRS return no match
Task #767: autodetect column mismatches
Task #814: rename columns by name, not position
Task #815: auto-prepend table name to columns
Task #816: re-run TNRS on mis-scrubbed names
Task #831: make tests use their own public schema
Task #856: data provider feedback tables: include the individual records that have errors
Task #857: standardize taxon ranks to a common vocabulary
Task #859: fix slowness in _taxonlabel_set_parent_id()
Task #898: remove dependencies on the development machine
Task #869: enable schema changes to be made on vegbiendev rather than the development machine
Task #886: move test DB to vegbiendev VM
Task #870: grant bien_read access to publishable staging tables
Task #871: grant bien_read access to validation result tables
Task #878: fix crow's foot notation in ERD
Task #899: remove dependencies on Mac
Task #901: schedule regular pg_dump backups of the DB
Task #908: generate the source-general derived columns directly on the denormalized staging table
Task #909: in aggregating validations pipeline, support using input result sets from CSVs instead of only by querying the staging tables
Task #928: switch to new TNRS setup
Task #916: Taxon name validation: VegBank
Task #917: TNRS: Instructions for new version with TPL
Task #915: Taxon Name Validation
Task #938: Enquist's taxon validation
Task #929: change TNRS client to store metadata
Task #931: BIEN db at iPlant
Task #932: Discovering BIEN data through iPlant
Task #934: Data Dictionary
Task #936: in TNRS client, detect Internal Server Errors when they occur instead of after the pauses have timed out
Task #937: fix missing date fields
Bug #943: in TNRS, the Constrain by Source option is applied incorrectly to the results download
Bug #944: fix phpPgAdmin bug that crashes the DB when browsing large tables
Bug #945: incorrect synonym being selected in TNRS
Task #946: update the column names in the VegBIEN example queries to reflect Brian M's renamings
Task #947: have all scripts that replace DB items rename the existing item out of the way rather than dropping it
Bug #949: fix shortened view_full_occurrence_individual column names that are now ambiguous
Task #952: refresh GBIF so it can be published
Bug #953: CVS and VegBank data
Task #961: test that staging tables can be reloaded from scratch
Task #962: walk through loading of datasources from scratch
Bug #963: fix slow loading of pages hosted on vegbiendev
Bug #966: figure out why some rows are not getting geoscrubbed
Environment and organisms
Task #359: Test GAM method to produce Tmax for one day (OREGON): r script
Task #207: Produce global fused DEM layer
Task #209: Produce global slope layer
Task #210: Produce global aspect layer
Task #211: Produce global flow accumulation layer
Task #208: Evaluate existing E&O AML scripts
Task #225: Organize and document SRTM input DEM files
Task #360: Producing, formatting and extracting variables for the GAM regression (OREGON)
Task #361: Test and compare the GAM method on several days (10 days for now) for Oregon
Task #362: Decide on a map projection for the Oregon case study
Task #364: Integrate spatial variables and structure in the GAM methodology
Task #375: Assemble monthly mean MODIS LST values for the complete record (2000-2012) for Oregon
Task #376: Assemble monthly mean TRMM precipitation values for the complete record for Oregon
Task #411: Insert DEM adaptive smoothing procedure into terrain workflow
Task #393: Identify Focal Regions
Task #406: OR-GAM predictions-model assessment over 365 dates, year 2010
Task #408: Capturing LST spatial structure using spatial eigenvectors
Task #409: Effect of sampling on GAM: hold out proportions and sampling observations
Task #363: Assemble all GHCN data into a single database
Task #416: Scope out workflow for calculating monthly LST climatologies
Task #415: Process MOD06_L2 Cloud data
Task #418: Explore Landcover - LST interactions
Task #419: Assessment of results in the context of the literature: Literature review and accuracy
Task #423: Develop stratified station sampling procedure
Task #430: Estimate total storage size of daily 1970-2010 1km dataset
Task #438: Add buffer to station subsetting algorithm
Task #479: Climatic Stationarity
Task #491: Methods comparison
Task #552: Facilitate raster buffering across antimeridian
Task #568: Interpolation of temperatures in the Venezuela region
Task #583: MODIS Cloud Mask - landcover interaction
Task #612: DEM Evaluation
Task #744: Create Global Grid for Interpolation
Task #745: Run interpolation over tiles for North America
Task #746: Generate Global Monthly Median (Climatologies) MODIS LST
Task #747: Run interpolation over all five case study regions

Status

New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
New
In Progress
In Progress
New
New
New
In Progress
In Progress
In Progress
In Progress
New
New
New
New
In Progress
New
New
New
New
In Progress
In Progress
New
New
In Progress
New
New
New
New
In Progress
In Progress
New
New
New
New
New
New
New

Priority

Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
High
High
Normal
Normal
High
Normal
Normal
Normal
Immediate
Immediate
Immediate
Normal
Normal
Normal
Normal
Normal
Normal
Normal
High
High
Normal
Normal
Normal
Normal
Normal
Normal
High
High
Normal
High
High
High
Normal
Normal
Normal
High
High
High
High
High
Normal
Normal
Normal
High
High
High
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
High
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal
Normal

Assignee

Rick Reeves
Rick Reeves
Rick Reeves

Updated

12/15/2011 01:03 PM
11/08/2012 03:42 AM
12/14/2011 02:31 PM
12/14/2011 02:08 PM
12/16/2011 12:31 PM
01/04/2012 04:49 PM
04/02/2012 08:54 AM
01/12/2012 04:21 PM
04/02/2012 08:54 AM
01/24/2012 06:32 PM
01/27/2012 03:03 PM
10/03/2013 01:06 PM
02/04/2012 03:27 PM
07/20/2012 06:31 AM
09/17/2012 10:06 AM
03/16/2012 02:59 PM
10/03/2013 01:05 PM
03/28/2014 02:53 AM
02/23/2014 08:01 PM
07/30/2012 04:15 PM
07/30/2012 04:15 PM
07/30/2012 04:24 PM
07/30/2012 06:25 PM
07/30/2012 06:50 PM
07/30/2012 07:07 PM
07/30/2012 07:19 PM
07/30/2012 07:49 PM
08/01/2012 06:57 AM
10/03/2013 01:03 PM
10/03/2013 01:02 PM
08/27/2012 05:52 PM
09/10/2014 03:58 PM
10/03/2013 01:01 PM
04/10/2014 03:19 AM
10/08/2012 07:16 PM
09/10/2012 06:55 PM
09/24/2012 01:02 PM
10/12/2012 01:06 AM
10/03/2013 01:00 PM
12/20/2012 02:36 PM
10/03/2013 01:00 PM
12/03/2013 05:54 AM
03/28/2014 03:05 AM
02/14/2013 06:33 AM
03/09/2013 02:10 AM
02/14/2013 11:04 AM
03/05/2013 09:41 PM
02/26/2013 12:48 PM
10/03/2013 12:56 PM
03/05/2013 05:09 AM
03/06/2013 02:08 PM
03/06/2013 08:45 PM
03/06/2013 09:08 PM
03/06/2013 10:57 PM
04/28/2017 05:13 AM
03/18/2014 03:15 AM
10/31/2014 03:24 PM
11/08/2013 10:10 PM
01/09/2014 09:44 AM
07/28/2014 04:50 PM
01/16/2014 10:42 AM
01/16/2014 10:40 AM
01/20/2014 09:14 PM
11/17/2014 08:47 AM
11/17/2014 08:47 AM
11/17/2014 08:27 AM
02/23/2014 08:02 PM
02/23/2014 08:03 PM
04/16/2014 10:16 PM
04/16/2014 10:14 PM
04/23/2014 03:16 PM
04/28/2017 04:39 AM
05/03/2014 05:30 PM
08/25/2014 05:19 PM
06/19/2014 11:00 AM
04/28/2017 04:38 AM
04/28/2017 04:21 AM
06/25/2014 01:19 PM
06/26/2014 05:24 PM
05/22/2014 04:32 PM
05/22/2014 04:43 PM
10/03/2014 03:19 PM
06/05/2014 04:42 AM
10/03/2014 03:18 PM
10/24/2014 03:18 PM
04/28/2017 04:35 AM
10/17/2014 03:40 PM
04/28/2017 04:34 AM
10/03/2014 03:17 PM
10/03/2014 03:22 PM
09/16/2014 05:12 PM
04/28/2017 04:30 AM
10/26/2014 05:16 PM
10/16/2014 09:38 AM
10/16/2014 12:47 PM
10/25/2014 03:29 PM
02/29/2012 06:27 PM
10/10/2012 05:15 PM
04/29/2011 11:04 AM
04/29/2011 11:05 AM
04/14/2011 02:29 PM
05/15/2012 09:57 AM
01/25/2012 04:42 PM
07/03/2012 09:40 AM
05/01/2012 02:24 PM
07/17/2012 10:37 AM
06/05/2012 12:27 AM
05/17/2012 03:44 PM
03/07/2012 08:38 AM
05/15/2012 11:22 AM
05/02/2012 02:16 PM
05/08/2012 04:31 PM
05/09/2012 03:40 PM
05/01/2012 02:16 PM
07/03/2012 09:45 AM
05/17/2012 11:38 PM
06/01/2012 12:43 PM
06/22/2012 09:47 AM
08/24/2012 01:40 PM
06/01/2012 12:54 PM
06/14/2012 12:34 PM
07/06/2012 06:36 AM
08/24/2012 01:32 PM
12/12/2012 04:36 PM
01/18/2013 05:41 PM
03/08/2013 10:24 AM
03/08/2013 10:21 AM
05/09/2013 08:10 AM
08/22/2013 11:58 AM
08/22/2013 12:01 PM
08/22/2013 12:19 PM
08/22/2013 12:23 PM
 
2025-1
2025-2
2025-3
2025-4
2025-5
2025-6
 
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
BIEN 3
New 60%
New 60%
New 70%
Environment and organisms
In Progress 100%
New 0%
New 0%
New 0%
In Progress 30%
In Progress 80%

Also available in: PDF PNG