Project

General

Profile

2014-04-10 conference call

Martha's notes

upcoming

  • the next conference call is next week at the usual time (Th. 9am PT/9am Tucson/12pm ET)

availability

  • Brad will not be available the rest of this week
  • please add your availability for spring 2014 to the *spreadsheet*:

Loading Google Spreadsheet...

decisions

VegBIEN schema

  • TNRS and geoscrub tables should be part of ERD see VegBIEN schema
  • better to have just the taxondetermination, taxonverbatim, and TNRS tables in the taxonomic schema, not taxonlabel/taxonconcept/etc. (Brad)
  • TNRS is part of the normalization process (Brad)

aggregating validations

  • include first and last rows of result set (Mark)
    • note that this refers to the result set, not the diff. the diff itself consists of 3 sections: different, missing, and extra rows, each of which would need the first and last row.

to do for Aaron

VegBIEN schema

  • add taxonverbatim.subspecies
  • add TNRS and geoscrub tables to ERD see VegBIEN schema

specimens aggregating validations

  1. fix input queries #4,5: remove subspecies IS NOT NULL filter
  2. fix input queries #6,7: add subspecies IS NOT NULL filter
  3. fix output queries #6,7: use subspecies instead of the concatenated taxonomic name