WSWUP / agweather-qaqc

Visualized QA/QC of weather station data
https://wswup.github.io/agweather-qaqc/
Apache License 2.0
20 stars 11 forks source link

Format of output files, column names for corrected and metadata #7

Closed JohnVolk closed 3 years ago

JohnVolk commented 5 years ago

Hi Christian, I am working on gridwxcomp a package that creates bias creation ratios between station climate and gridMET data. I am setting the default names of input climate variables based on what PyWeatherQAQC outputs, also I am using the same format for a climate station metadata file from what PyWeatherQAQC uses or produces. In other words the default assumption is that users first use PyWeatherQAQC before running gridwxcomp, although it is not necessary.

Anyhow, I want to be clear on the formats and column names you use in your output files. Here is the header and hence variable names I am currently using that is assumed to be produced by PyWeatherQAQC in a corrected climate xlsx time series file (on the corrected sheet):

  year month day TAvg (C) TMax (C) TMin (C) TDew (C) Vapor Pres (kPa) RHAvg (%) RHMax (%) RHMin (%) Rs (w/m2) Rs_TR (w/m2) Rso (w/m2) Windspeed (m/s) Precip (mm) Data_ETr (mm) Data_ETo (mm) Calc_ETr (mm) Calc_ETo (mm) ws_2m (m/s)

And here is what I have for columns in a station_data.csv metadata file which has info for all the corrected station time series files:

FID OBJECTID Id State Source Status Station LATDECDEG LONGDECDEG Date Station_ID Elev_FT Comments Location FileName Irrigation Website Elev_m

Can you let me know what the normal format for these files will be? In particular the climate variable names in the time series files and the fields for lat, long, station, elevation, and file name in the metadata file. Those will be required inputs for gridwxcomp. Also, if you could, show an example row after a standard header for a metadata file, it would be greatly appreciated! Thanks John.