2014-10-30 conference call¶

Martha's notes¶

CVS (Redmine issue #953)

* Two critical issues remained for CVS (numbers below are from Bob’s email)

• #10: "I observe that some, but not all, plots in VegBank dump do not have the plot name populated”
• #2: "I do not know the definitions of the fields georeferenceProtocol__@DwC__@vegbiendev.nceas.ucsb.edu & “geovalid_bien”. However, they were blank for all records and I suspect they relate to geovalidation, in which case they should not be blank." this is issue #950

• Aaron said it could take a while to figure out what is causing each of them (couple days each).

Trait data

• Need the geolocation data included in the taxon-trait table.
• Cyrille has not yet provided feedback on the latest extract.

Walkthrough of documentation on data loading

• Redmine issue #961 Need to make sure staging tables load
• Redmine #962 Walkthrough of the documentation. Loading a single or several sources into an unpopulated normalized db.
• Redmine #952 GBIF changed their format; use it as one of the sources
• Redmine issue #814 rename columns by name, not position & #767 autodetect column mismatches
• Redmine issue #945 TNRS synonym (the workflow does not yet parse the JSON file that is returned from TNRS on toad, which is a development server)

Other

• Redmine issue #944 phpPgAdmin – it’s fixing their source code; Mark saying No, unless minor;

availability¶

• see the *spreadsheet*:

decisions¶

sPlot extract¶

• Bob will give this to them

to do for Aaron¶

CVS validation¶

• send Bob a CVS extract of analytical_stem, which has the DBH, instead of view_full_occurrence_individual

sPlot extract¶

• send Bob the sPlot extract

documentation¶

• document how to make remaining TNRS fixes (#943, #945)
• document how to fix #814 (rename columns by name, not position)

traits¶

• add geospatial info to taxon_trait view
  • requires changing the definition of taxon_trait_view to also join to place and coordinates as in view_full_occurrence_individual_view/plot.**  

to do for Mark and Aaron¶

• make sure Mark comfortable with workflow documentation