Historical Data upload, Data format change, Precipitation and Tidal Data no appearing

1) UPLOAD HISTORICAL DATA

  • ACTION>> CM/BS - package a historic data update to fill in historic precipitation, as well as sensor data with new filters applied (will be multiple csvs) for all modalities:
    • Flood Depth
    • Tide Level
    • Precipitation
  • ACTION>> JL - verify that the historic data will work
  • ACTION>> All - schedule time to do the import (may incur downtime)
  • ACTION>> JL upload historical data at the agreed time (may incur downtime)
  • ACTION>> FN - test and confirm all is working as expected

2) DATA FORMAT CHANGE 1: PRECIPITATION

  • Data viz from 5 minute max 1 hour incremental to 5 minute incremental (accumulated precipitation in 5 minutes)
  • Axis Label from “Precipitation (Inches/Hour)” to “Precipitation (Inches/5 Mins)”
  • ACTION>> CM/BS - start sending the new payload fields for precipitation. These will be in inches (FN currently sending in mm and FK converts to inches)
  • ACTION>> JL - create new column in DB and implement new payload fields for precipitation
  • ACTION>> FN - test and confirm all is working as expected

3) DATA FORMAT CHANGE 2: FLOOD DEPTH AND TIDAL

  • Data units from being converted at FK’s end to FN sending correct units and no conversion at FK’s end
  • Axis Labels remain the same (as they are currently correct)
  • ACTION>> CM/BS - start sending the new payload fields for:
    • flood depth (FN currently sending in mm and FK converts to inches)
    • tide level  (FN currently sending in currently feet)
  • ACTION>> JL - stop conversion at FK’s end
  • ACTION>> FN - test and confirm all is working as expected

4) PRECIPITATION DATA NOT APPEARING [MIGHT BE FIXED ALREADY]

(ref: Monday Tkt: Precipitation data not available for certain (newer?) sensors)

  • If not ALL the weather data is sent, it won’t update it
  • It could be that the temperature field is not there in some way - (Evaluation error; temperature)?
  • ACTION>> JL - check what’s going on with the temperature field and if it’s all weather sensors or some only?
  • ACTION>> JL - turn off temperature DONE

5) TIDE DATA NOT APPEARING

  • This is a separate json message
  • Seems to be happening from 7/30
  • ACTION>> JL and FN - check if anything happened on that date (when was the last message we got?)