Idea with this ticket is to move the logic that is currently contained in the xl ss import macro and the R climate_obs app to python, so that we can download the data and write it into the SS all in one go.
Steps
For all the various input data sets:
ASP - Automated Snow Pillows
ECCC - Environment Canada weather stations
ZXS - Vertical temperature profiles
F_WX - BC Wildfire Weather Stations
For each dataset:
iterate over the various stations
Look up the stations name with the column header from the METADATA tab in the xl spreadsheet.
Copy the data for the current data / time into the ALL_DATA sheet.
Missing Data
How this is going to work hasn't been finalized at this time
One idea, is using the logic that was used in the R data ingestion script, where it looks at stations that are close by, and calculates the relative temperature differences between the two stations, and then using that information interpolates the missing values.
Overview
Idea with this ticket is to move the logic that is currently contained in the xl ss import macro and the R climate_obs app to python, so that we can download the data and write it into the SS all in one go.
Steps
For all the various input data sets:
For each dataset:
Missing Data How this is going to work hasn't been finalized at this time