search

HydrologicEngineeringCenter / cwms-python

Corps Water Management Systems (CWMS) library utilizing CWMS Data API
MIT License
6 stars 4 forks source link

saving null timeseries values #105

Open Enovotny opened 1 month ago

Enovotny commented 1 month ago

To save a missing/null timeseries value using CDA the values needs to be value = -340282346638528859811704183484516925440 quality code = 5

changes to CDA are being made to change this. Steps for task 1) check the new behavior in CDA 2) incorporate the new behavior into the timeseries_df_to_json function to convert null values to the required values 3) add a parameter such as write_null that if true with convert null values to missing in the databases. If false it will remove null values before saving to the database.

MikeNeilson commented 1 month ago

NOTE: null is now an acceptable value. quality should be set to 5, but with null it is not required by the default database configuration.

specifically

values: [
  [ 1234439, null, 5]
]

null without quotes is a normal and expected value in JSON.