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*:

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