Project

General

Profile

2012-02-24 conference call

To do

Martha

  • Aaron make the changes to VegBIEN ERD, send it out.
  • Brad, Bob, Mike review and sign off on the ERD. (Nick too?)
  • Aaron ask Steve for glossary or data dictionary for CTFS.
  • move on to refactoring VegX

Notes

Martha's notes: 12-02-24_BIEN_db.docx

Agenda (from Martha)

Aaron's feedback in italics

Milestone Revise Schemas I

  • Next week, will we be finished with the first round of revisions to VegBIEN schema, DwC-VegBIEN mapping?
    • VegBIEN schema: Some things we might want to include in this round:
      • Converting all user-defined fields to first-class fields
      • Adding tables to store traits information
    • DwC-VegBIEN mapping: We have mappings for DwC elements used by NYBG
  • Are the corresponding requests for changes to VegX, VegBank documented?
    • VegBank: The only change we have made to VegBank itself is to remove the length constraints on text fields. Everything else is a VegBIEN-only change.
    • VegX: We have not started revising VegX yet, as we have been focusing on VegBIEN revision. Here are some possible changes:
      • Converting all user-defined fields to first-class fields
      • Allowing all top-level tables to be nested inside the ID elements that point to them

VegBIEN schema

  • Methods tables
    • Are there any more first-class fields we want to add? (Data providers can always create user-defined method fields for any fields that don't already exist.)

Shifting focus to data loading

  • Specimens
    • Full NYBG data has been loaded on vegbiendev (not yet validated)
  • Plots
    • Full SALVIAS data has been loaded on nimoy
    • Getting the validations to pass is in progress (involves adjusting mappings and configuring duplicate elimination on all relevant tables)