Gantt

Custom queries

Issue status report
Open assignments

Filters

Add filter

Options

Columns Display Available Columns Selected Columns
Related issues Blocks Precedes	Progress line Display

Zoom in Zoom out « August | October »

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

In Progress

New

In Progress

New

In Progress

New

In Progress

New

In Progress

New

In Progress

New

Priority

Normal

High

Normal

High

Normal

Immediate

Normal

High

Normal

High

Normal

High

Normal

High

Normal

High

Normal

High

Normal

Assignee

Aaron Marcuse-Kubitza

Brad Boyle

Aaron Marcuse-Kubitza

Brad Boyle

Aaron Marcuse-Kubitza

Brad Boyle

Aaron Marcuse-Kubitza

Martha Narro

Brian Enquist

Aaron Marcuse-Kubitza

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: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: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

2024-9

2024-10

2024-11

2024-12

2025-1

2025-2

BIEN 3

New 60%

New 70%

Environment and organisms

In Progress 100%

New 0%

In Progress 30%

In Progress 80%

« Previous
Next »

Also available in: PDF PNG

Project

General

Profile

Custom queries

Gantt