Adjuster for National_XG

[peterdudfield]

Detailed Description

It would be good to get the Adjuster working for the National model

Context

• Adjuster looks at the last 7 days of error, per 30 minute in the data, and for each forecast horizon.
• Adjuster is currently just for the CNN (PVnet)

Possible Implementation

• [x] Add a column mode_id to metric_value table, so we can have multiple values for different models - https://github.com/openclimatefix/nowcasting_datamodel/pull/167
• [x] Get National_xg to save to `Forecast_Value_last_seven_days' table - https://github.com/openclimatefix/gradboost_pv/pull/64
• [x] Update API to read blended 4 hour view - https://github.com/openclimatefix/nowcasting_datamodel/pull/169
• [x] add metric ME for cnn and National_xg - currenrly only does cnn - https://github.com/openclimatefix/nowasting_metrics/pull/16
• [x] Update PVnet to load from that table, and load CNN results - https://github.com/openclimatefix/nowcasting_forecast/pull/192
• [x] Add Adjuster to National_xg - https://github.com/openclimatefix/gradboost_pv/pull/65

This needs

• migrations - this
• API >1.4.3
• nowcasting_metrics 1.0.4
• nowcasting_forecast 1.3.9
• National_xg 1.0.5

[peterdudfield]

FROM forecast_value, gsp_yield 
WHERE forecast_value.uuid IN (SELECT anon_1.uuid 
FROM (SELECT DISTINCT ON (forecast_value.target_time) forecast_value.uuid AS uuid 
FROM forecast_value JOIN forecast ON forecast.id = forecast_value.forecast_id 
      JOIN location ON location.id = forecast.location_id 
      JOIN model ON model.id = forecast.model_id 
        WHERE location.gsp_id = 0 
      AND forecast_value.target_time - forecast_value.created_utc >= interval '450 minute' 
--    AND %(created_utc_1)s - forecast_value_last_seven_days.created_utc < interval '450 minute' 
      AND forecast_value.target_time > '2023-04-06'  
      AND forecast_value.target_time <= '2023-04-12' 
      AND model.name = 'National_xg' 
      ORDER BY forecast_value.target_time, forecast_value.created_utc DESC) AS anon_1) AND gsp_yield.id IN (SELECT anon_2.id 
FROM (SELECT gsp_yield.id AS id 
FROM gsp_yield JOIN location ON location.id = gsp_yield.location_id 
WHERE location.gsp_id = 0 
      AND gsp_yield.datetime_utc > '2023-04-06' 
      AND gsp_yield.datetime_utc <= '2023-04-12'  
      AND gsp_yield.regime = 'day-after') AS anon_2) 
      AND gsp_yield.datetime_utc = forecast_value.target_time 
      GROUP BY CAST(gsp_yield.datetime_utc AS TIME WITHOUT TIME ZONE)

Ran this, and found errors from 0 to 800 MW, so I think its worth doing the adjuster

[peterdudfield]

This is now working on dev

[peterdudfield]

All deployed on production now