2013-10-03 conference call¶

Martha's notes¶

Upcoming¶

• call next week at usual time (Th. 9am PDT&Tucson)

Availability¶

• Brad will not be on the conference call next week (possibly not for the next few weeks), but will be available by e-mail
• Brian will be in Perth, Australia ‎for the next week
• See the *Google spreadsheet* (and please add your availability for future weeks once it's known):

Decisions made¶

VegBank validation¶

• up to Bob whether to have 3 separate tables (plot, species, stems), or one denormalized table for the occurrences
  "I will opt for three tables as it will be much easier for Michael and me to validate these" (Bob)
  "I concur. With VegBank data, the possibility of multiple stems for multiple records of the same species on a plot means you could get a false duplication of records, depending on how you are denormalizing them" (Mike Lee)

datasource validations¶

• "getting data in and validated is the absolute top priority" (Martha)
• tabling having a generic approach that works for all plot datasources (Martha) (i.e. automation of validation)
  • 2-6 queries depending on what tables are needed
  • don't include output columns where there is no data for the corresponding input column

order:

1. VegBank
2. CVS
3. Madidi
   • do this before FIA (Brad)
   • fix issues in whatever order (Brad)
4. ARIZ, U, TEX
5. FIA, GBIF, MO

To do for all¶

• review Brad's data use and attribution document
  • see ERD on p. 7
  • pay especial attention to the dataset table and how this connects to data records

To do for Aaron¶

datasource validations¶

1. VegBank
   1. e-mail Bob to see whether to have 3 separate tables or one denormalized view 3 separate tables
   2. generate extract
2. CVS
   1. make changes to match VegBank
3. Madidi
   • if have questions, e-mail Peter Jorgensen and cc the BIEN list
4. ARIZ, U, TEX