[x] Remove space from the SiteCode value. Use underscore instead? Fix in Sites and DataValues tables.
[x] MethodLink includes descriptive text and URL. Merge descriptive text into MethodDescription, leaving just a valid URL for MethodLink.
[x] DataValues has NA as QualityControlLevelCode, but that code isn't defined. Define it, or change to something else.
[x] DataValue column includes 9999, which I think is a NoData value, but according to Variables.csv, that should be -9999.
[x] DataValue column includes NA. Text is not allowed. Change to -9999.
[x] Some AIR_MEAN values are wild, like -4991. If that's from the original data, then fine. But maybe something went wrong in the conversion script?
[x] VariableUnitsName should have unit names from the CV, not abbreviations.
[x] TimeSupport for daily min and max temperature should be 1. This is because the max temperature is taken from all recorded values throughout one day.
[x] The only provided value that is appropriate for quality control levels is Q, Preliminary Value, not been QA/QC. The others fit better with Qualifiers in ODM parlance.
Regarding qualifiers, the preferred CUAHSI solution would be to add a QualifierCode column to the DataValues table, and add a Qualifiers.csv table with QualifierCode and QualifierDescription fields. This can be found in their advanced template.
Regarding qualifiers, the preferred CUAHSI solution would be to add a QualifierCode column to the DataValues table, and add a Qualifiers.csv table with QualifierCode and QualifierDescription fields. This can be found in their advanced template.