VegBIEN schema¶

• Plot Methodology
• VegBIEN schema refactoring
• VegBIEN taxonomic schema

• Table of contents
• VegBIEN schema
  • ERD
  • Comparison to VegBank
  • Proposed changes
  • Remaining user-defined fields
  • Data dictionary changes
  • Other changes

ERD¶

Note: The ERD displays a subset of the full schema

full SQL DDL

ERD: PNG | SVG | PDF split into pages (letter sized) | PDF on one page | MySQL Workbench with MySQL DDL used

Last updated: 2014-5-30 7:30am PT

Comparison to VegBank¶

These tables have been renamed:

VegBank	VegBIEN
plot	location
place	locationplace
namedplace	place
observation	locationevent
taxonobservation	taxonoccurrence
taxonimportance	aggregateoccurrence
stemcount	plantobservation
stemlocation	stemobservation
taxoninterpretation	taxondetermination
plantconcept	taxon

These tables have been merged:

VegBank	VegBIEN
stratummethod	method
stratumtype	method

We will be using the new names whenever possible, so please familiarize yourself with them.

Also, there are several new tables in VegBIEN:

specimenreplicate: A herbarium's replicate of a specimen. Contains Darwin Core specimen data.
method: A method for sampling and aggregating plants.

Proposed changes¶

See To Do: VegBIEN schema

Remaining user-defined fields¶

7 fields (in 3 tables)

• stemobservation
  • canopyForm
  • canopyPosition
  • gentryDiameter
  • lianaInfestation
  • notes
• aggregateoccurrence
  • censusNo
• specimenreplicate
  • sex

Data dictionary changes¶

1. plantstatus.plantlevel closed list: Add Authority, Binomial

Other changes¶

• Bob Peet's redesign: New-DD.xlsx
• 2011 working group We BIEN tools
• 2011 working group Th VegBank conference call
• 2011 working group whiteboard sketches:
  • BIEN_OctWG-Whtbrd1.jpg
  • BIEN_OctWG-Whtbrd2.jpg
  • BIEN_OctWG-Whtbrd3.jpg
  • BIEN_OctWG-Whtbrd4.jpg