2013-02-21 conference call¶

Data validation¶

• fix remaining issues Brad found
• include empty fields even if not provided by the data provider
  • e.g. collectionCode
  • these may be in the source data, but not mapped
• map VegBank strata, % cover, etc.
• higher priority than analytical DB

Data refresh¶

• higher priority than analytical DB

GBIF¶

• filter out animal observations
• import only raw_occurrence_record
• Brad will send formula to extract list of institutions with plant data: _inputs/GBIF/_src/_README.TXT_

FIA¶

• map subset of fields in the FIA filter document from Brad: issues with duplicated column names preventing joining the tables
• fkeys are the four columns together: for join, also use UNITCD
  plotCode = STATECD,COUNTYCD,PLOT (not PLOT_CN)
  plotCensusCode = STATECD,COUNTYCD,PLOT,INVYR

MO¶

• remind Peter J and Bob Magill
• need it by mid-March to be part of the range modeling
• can't use Tropicos Specimen Search because it provides only a small subset of fields
  • it's missing the lat/long and specimen description that we especially need

CTFS¶

• Rick C would prefer us to use the CTFS data from BIEN2: BIEN2 CTFS data mapped
• Rick C looking for new CTFS records for us to put in BIEN
• Steve Hubble might not want CTFS data in BIEN
• also add Chinese plots data from Fang He
  • the Chinese plots are another part of the CTFS network of researchers

New data¶

BRIT¶

• remind Jason Best

TEX¶

• remind Tom Wendt

Analytical DB¶

habit classes¶

• Brad was copied on Brian's e-mails