Project

General

Profile

Actions
Summary

Issue status report

Apply Clear

# Status Priority Subject Assignee Updated Due date % Done
348 Resolved Normal 1st draft of schema Robert Peet 06/01/2012 03:07 PM 02/29/2012

Actions
306 Resolved Normal Acquire additional plot data sets from providers willing to work with Aaron on mappings and validations Brad Boyle 10/03/2013 01:09 PM

Actions
307 Resolved Normal Acquire additional specimen data sets in both DwC and DwCA format, esp. GBIF Brad Boyle 10/03/2013 01:09 PM

Actions
452 Resolved Normal add column-based import to automated testing Aaron Marcuse-Kubitza 08/28/2012 06:28 PM

Actions
549 Resolved Normal add covering indexes on fkeys Aaron Marcuse-Kubitza 01/04/2013 09:15 PM

Actions
498 Resolved Normal add definitions to columns in "green tables" Aaron Marcuse-Kubitza 10/12/2012 05:01 AM

Actions
346 New Normal add georeferencing support to schema Aaron Marcuse-Kubitza 10/03/2013 01:06 PM

Actions
494 Resolved Normal add indexes for the analytical_db_view joins Aaron Marcuse-Kubitza 09/18/2012 05:14 PM

Actions
882 Rejected High add limit on the # of parallel import processes Aaron Marcuse-Kubitza 04/02/2014 10:10 AM

Actions
471 Resolved Normal add make actions so new dependent maps are rebuilt automatically when their source map changes Aaron Marcuse-Kubitza 08/28/2012 06:30 PM

Actions
957 Resolved High add mechanism to customize NULL-equivalent strings used by staging table import Aaron Marcuse-Kubitza 10/14/2014 10:16 AM

Actions
904 Resolved Normal add MySQL public user to allow accessing the normalized VegCore data dictionary Aaron Marcuse-Kubitza 04/28/2017 04:40 AM

Actions
495 Resolved Normal add separate datasource table rather than using party for this Aaron Marcuse-Kubitza 11/08/2012 03:11 AM

Actions
353 Resolved Normal add terms from previous versions of DwC to DwC-BIEN Aaron Marcuse-Kubitza 02/28/2012 04:44 PM

Actions
333 Resolved Normal add traits table to VegBIEN Aaron Marcuse-Kubitza 10/03/2013 01:07 PM

Actions
486 New Normal add unit-conversion mechanism Aaron Marcuse-Kubitza 10/08/2012 07:16 PM

Actions
440 New Normal aggregating validations of imports Aaron Marcuse-Kubitza 03/28/2014 02:53 AM

Actions
463 Resolved Normal allow an input to appear multiple times in the same map spreadsheet Aaron Marcuse-Kubitza 08/03/2012 06:38 PM

Actions
477 Rejected Normal allow putting specimens data directly in the top level of the datasource directory Aaron Marcuse-Kubitza 12/06/2012 08:13 PM

Actions
377 Resolved Normal ask NYBG for direct access to server Brad Boyle 10/03/2013 01:06 PM

Actions
767 New High autodetect column mismatches Aaron Marcuse-Kubitza 03/18/2014 03:15 AM

Actions
580 New Normal automap each word *in* a VegCore term instead of just the whole term Aaron Marcuse-Kubitza 03/06/2013 09:08 PM

Actions
573 New Normal automap the analytical DB columns Aaron Marcuse-Kubitza 03/05/2013 09:41 PM

Actions
480 Resolved Normal automate adding a new table to an existing datasource Aaron Marcuse-Kubitza 08/27/2012 05:51 PM

Actions
310 Resolved Normal automated build process Aaron Marcuse-Kubitza 12/22/2011 12:31 PM

Actions
566 New Normal automatically adjust staging tables for easier mapping Aaron Marcuse-Kubitza 02/14/2013 11:04 AM

Actions
815 New Normal auto-prepend table name to columns Aaron Marcuse-Kubitza 11/08/2013 10:10 PM

Actions
443 Resolved Normal back up staging tables Aaron Marcuse-Kubitza 07/17/2012 03:58 PM

Actions
290 Resolved Normal benchmark tests for database loading Aaron Marcuse-Kubitza 03/28/2014 02:52 AM

Actions
931 New Normal BIEN db at iPlant Martha Narro 05/22/2014 04:32 PM

Actions
450 New Normal cast all untyped literals as text using cast_literal() Aaron Marcuse-Kubitza 07/30/2012 04:24 PM

Actions
490 New Normal change import.stats.xls to use field rather than row count Aaron Marcuse-Kubitza 09/10/2012 06:55 PM

Actions
455 Resolved Normal change summarizing queries to use vegbien staging tables Aaron Marcuse-Kubitza 09/17/2012 07:01 AM

Actions
929 New Normal change TNRS client to store metadata Aaron Marcuse-Kubitza 06/26/2014 05:24 PM

Actions
453 New Normal cluster vegbien tables periodically Aaron Marcuse-Kubitza 07/30/2012 06:50 PM

Actions
466 Rejected Normal column-based import: avoid most exceptions by introspecting the DB structure instead of waiting for a parseable exception to be raised Aaron Marcuse-Kubitza 10/03/2013 01:03 PM

Actions
304 Resolved Normal Complete full dataset imports to VegBIEN via VegX of NYBG and SALVIAS Aaron Marcuse-Kubitza 04/02/2012 10:46 AM

Actions
305 Resolved Normal Complete full-dataset validations for NYBG & SALVIAS Aaron Marcuse-Kubitza 10/03/2013 01:09 PM

Actions
344 Resolved Normal contact John about GNRS/georeferencing Jim Regetz 10/03/2013 01:07 PM

Actions
321 Resolved Normal Convert user-defined VegBIEN fields to first-class fields Aaron Marcuse-Kubitza 04/02/2012 10:42 AM

Actions
320 Rejected Normal Convert user-defined VegX fields to first-class fields Aaron Marcuse-Kubitza 10/03/2013 01:08 PM

Actions
383 New Normal convert VegBank data dictionary to database comments Aaron Marcuse-Kubitza 09/17/2012 10:06 AM

Actions
387 New Normal count how many duplicates between Canadensys and GBIF Aaron Marcuse-Kubitza 03/16/2012 02:59 PM

Actions
378 New Normal create automated feedback mechanism Aaron Marcuse-Kubitza 07/20/2012 06:31 AM

Actions
370 Resolved Normal create ERD of final schema Aaron Marcuse-Kubitza 06/01/2012 03:06 PM

Actions
497 Resolved Normal create examples of taxonomic names to test the limits of the new taxonomic schema Brad Boyle 10/17/2012 12:02 PM

Actions
336 Resolved Normal create VegBIEN ERD Aaron Marcuse-Kubitza 01/19/2012 05:32 PM

Actions
341 New Normal create verbal descriptions of edge cases Brad Boyle 01/27/2012 03:03 PM

Actions
352 Resolved Normal create way to represent methods hierarchically in schema Aaron Marcuse-Kubitza 02/21/2012 01:08 PM

Actions
285 Resolved Normal CSV to XML mappings for NYBG, SALVIAS Aaron Marcuse-Kubitza 12/15/2011 01:55 PM

Actions
286 New Normal CSV-XML-database mapping script Aaron Marcuse-Kubitza 12/15/2011 01:03 PM

Actions
953 New High CVS and VegBank data Aaron Marcuse-Kubitza 04/28/2017 04:30 AM

Actions
934 New High Data Dictionary Aaron Marcuse-Kubitza 10/03/2014 03:19 PM 06/06/2014

Actions
459 New Normal data provider feedback: propagate srcs (input columns for an intermediate column) for all tables, not just SQL functions? Aaron Marcuse-Kubitza 07/30/2012 07:49 PM

Actions
856 New Normal data provider feedback tables: include the individual records that have errors Aaron Marcuse-Kubitza 01/16/2014 10:42 AM

Actions
318 Resolved Normal decide whether to switch to VegX 1.5.2 01/19/2012 11:29 AM

Actions
311 Resolved Normal Decouple VegBIEN from VegBank and map directly from VegX to VegBIEN Aaron Marcuse-Kubitza 01/05/2012 04:53 PM

Actions
476 New Normal develop map spreadsheet -> header override file translation utility Aaron Marcuse-Kubitza 09/10/2014 03:58 PM

Actions
296 Resolved Normal Direct mapping from native salvias_plots MySQL database to VegBIEN Aaron Marcuse-Kubitza 02/09/2012 05:34 PM

Actions
317 Rejected High Direct mapping from VegX to VegBIEN Aaron Marcuse-Kubitza 09/17/2012 06:58 AM

Actions
932 New Normal Discovering BIEN data through iPlant Brian Enquist 05/22/2014 04:43 PM

Actions
308 Resolved Normal do a direct transfer of some public data from VegBank Aaron Marcuse-Kubitza 11/08/2012 03:32 AM

Actions
461 New Normal don't display warning when nullable boolean columns are handled without using COALESCE() Aaron Marcuse-Kubitza 08/01/2012 06:57 AM

Actions
330 Rejected Normal DwC extension to VegX Aaron Marcuse-Kubitza 02/24/2012 02:08 PM

Actions
584 Resolved Normal enable running all the import steps from one runscript Aaron Marcuse-Kubitza 03/18/2014 03:07 AM

Actions
869 New Immediate enable schema changes to be made on vegbiendev rather than the development machine Aaron Marcuse-Kubitza 11/17/2014 08:47 AM

Actions
938 New Normal Enquist's taxon validation Aaron Marcuse-Kubitza 06/25/2014 01:19 PM

Actions
966 New Normal figure out why some rows are not getting geoscrubbed Aaron Marcuse-Kubitza 10/25/2014 03:29 PM

Actions
501 Resolved Normal find out which datasources won't allow their data to be publicly accessible Aaron Marcuse-Kubitza 02/23/2014 07:57 PM

Actions
294 Resolved Normal find plot data source provider to work with Aaron Brad Boyle 10/03/2013 01:10 PM

Actions
312 Resolved Normal Finish importing SALVIAS data Aaron Marcuse-Kubitza 10/03/2013 01:09 PM

Actions
424 New Normal Finish translating XML functions to SQL functions for column-based import Aaron Marcuse-Kubitza 10/03/2013 01:05 PM

Actions
902 Resolved Normal fix bug that causes joining on the wrong columns in the import Aaron Marcuse-Kubitza 04/28/2017 04:39 AM

Actions
878 New Normal fix crow's foot notation in ERD Aaron Marcuse-Kubitza 04/16/2014 10:16 PM

Actions
446 New Normal fix deadlock in INSERT IGNORE replacement Aaron Marcuse-Kubitza 02/23/2014 08:01 PM

Actions
522 New Normal fix deadlock when multiple testers are running simultaneously Aaron Marcuse-Kubitza 10/12/2012 01:06 AM

Actions
887 Rejected Normal fix disk space leak that fills the disk and crashes the import Aaron Marcuse-Kubitza 04/28/2017 04:39 AM

Actions
948 Resolved High fix duplicated rows in view_full_occurrence_individual Aaron Marcuse-Kubitza 09/04/2014 10:04 AM

Actions
955 Resolved High fix geovalidation duplicated rows Aaron Marcuse-Kubitza 10/14/2014 02:59 PM

Actions
937 New Normal fix missing date fields Aaron Marcuse-Kubitza 10/03/2014 03:18 PM

Actions
944 New High fix phpPgAdmin bug that crashes the DB when browsing large tables Aaron Marcuse-Kubitza 04/28/2017 04:35 AM

Actions
884 Rejected High fix Postgres bug that causes query planner to use seq scans and slow sorts instead of index scans in the import Aaron Marcuse-Kubitza 04/23/2014 04:00 PM

Actions
949 New Normal fix shortened view_full_occurrence_individual column names that are now ambiguous Aaron Marcuse-Kubitza 10/03/2014 03:22 PM

Actions
963 New High fix slow loading of pages hosted on vegbiendev Aaron Marcuse-Kubitza 10/16/2014 12:47 PM

Actions
859 New Normal fix slowness in _taxonlabel_set_parent_id() Aaron Marcuse-Kubitza 01/20/2014 09:14 PM

Actions
903 Resolved High fix Ubuntu 14.04 upgrade bug that prevents Apache from displaying vegbiendev.nceas.ucsb.edu properly Aaron Marcuse-Kubitza 04/28/2017 04:41 AM

Actions
950 Resolved High fix view_full_occurrence_individual_view rows with is_geovalid NULL Aaron Marcuse-Kubitza 10/17/2014 11:27 AM

Actions
562 New Normal flatten the mappings Aaron Marcuse-Kubitza 03/28/2014 03:05 AM

Actions
371 Resolved Normal formalize proposed changes to VegX Mark Schildhauer 06/01/2012 03:05 PM

Actions
908 New Normal generate the source-general derived columns directly on the denormalized staging table Aaron Marcuse-Kubitza 04/28/2017 04:39 AM

Actions
326 Rejected Normal generic MOU template to request data 04/10/2014 03:21 AM

Actions
322 Resolved Normal get access to raw CTFS data Brad Boyle 01/19/2012 11:31 AM

Actions
539 Rejected Normal get analytical_stem_view to use merge joins instead of hash joins Aaron Marcuse-Kubitza 03/28/2014 02:55 AM

Actions
369 Resolved Normal get CTFS data dictionary Aaron Marcuse-Kubitza 03/23/2012 02:15 PM

Actions
328 New Normal get raw data rather than flat file exports from RAINFOR Brad Boyle 01/12/2012 04:21 PM

Actions
368 Rejected Normal get TEAM VegX data 09/17/2012 07:02 AM

Actions
367 Resolved Normal get Univ of Arizona DwC data Brad Boyle 02/28/2012 04:43 PM

Actions
469 New Normal give everyone their own account on vegbien Aaron Marcuse-Kubitza 08/27/2012 05:52 PM

Actions
870 New Normal grant bien_read access to publishable staging tables Aaron Marcuse-Kubitza 02/23/2014 08:02 PM

Actions
871 New Normal grant bien_read access to validation result tables Aaron Marcuse-Kubitza 02/23/2014 08:03 PM

Actions
(1-100/225) Per page: 25, 50, 100

Also available in: Atom CSV PDF