search

srm-ecology / mhwci

https://srm-ecology.github.io/mhwci/
1 stars 0 forks source link

more flexible functions #5

Open billspat opened 1 month ago

billspat commented 1 month ago

most functions are now based on decades and may not be flexible.

create a new versions of the database -> plot functions that allow for different time periods, ensemble filtering and metric calculation

process will be

  1. generate / create the SQL string to run for one time period (not grouped by decade)
    • summarizes one of the metrics over time fixed in space (lat/lon coordinate) using SQL aggregate functions
    • can give a 10 year period (2040-2049) to use decades
  2. run the SQL against the database into a dataframe,
  3. create a raster from it
  4. repeat 1-3 for groups of time periods and save rasters
  5. create a list of rasters named for time periods (eg. decades
  6. plot the list of rasters OR subtract rasters from historical period summaries for delta
billspat commented 1 month ago

started on this with eb344aa25ad4de1afca7ed4a723320eb20a273e5