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)