V2.1.8 Fixes

[nickchadwick-noaa]

• Alaska AEP FIM Service
• Republish all services that had their Service Descriptions changed.
• Publish AK Catfim Service
• Remove 3 Day Layers from GFS Services.?
• Dummy Data table needs to be added for the following:
  • rfc/rfc_max_forecast "Record Forecasts"
  • nwm/srf_48hr_rapid_onset_flooding_hi_noaa "48 Hours - NWM Waterway Length Flooded"
  • nwm/srf_48hr_rapid_onset_flooding_prvi_noaa "48 Hours - NWM Waterway Length Flooded"

Remove Unneeded Services

Have duplicate Image and Map Services (Prod Only) (Note its just the depth coastal services, not extent)

• ana_coastal_inundation_depth_hi_noaa
• ana_coastal_inundation_depth_noaa
• ana_coastal_inundation_depth_prvi_noaa
• ana_past_24_hour_snow_melt_noaa
• ana_snow_depth_noaa
• mrf_gfs_10day_max_coastal_inundation_depth_noaa
• mrf_nbm_10day_max_coastal_inundation_depth_noaa
• srf_18hr_max_coastal_inundation_depth_noaa
• srf_48hr_max_coastal_inundation_depth_hi_noaa
• srf_48hr_max_coastal_inundation_depth_prvi_noaa

Don't need a Public Version (Prod Only)

• static_flow_based_catfim

Are not public and need non "_noaa" services removed

• mrf_nbm_10day_high_water_arrival_time_noaa
• mrf_nbm_10day_rapid_onset_flooding_noaa

Have a Public Version for CONUS so don't need NOAA version

• mrf_nbm_10day_max_high_flow_magnitude_noaa

---

Notes

Code for adding dummy data to services in the past

INSERT INTO {publish_table} (
    reference_time, 
    update_time
) VALUES (
    to_char('1900-01-01 00:00:00'::timestamp without time zone, 'YYYY-MM-DD HH24:MI:SS UTC'), 
    to_char(now()::timestamp without time zone, 'YYYY-MM-DD HH24:MI:SS UTC')
);