Summary SQL for the Huc Hotspot layer:
Core/LAMBDA/viz_functions/viz_db_postprocess_sql/summaries/mrf_nbm_10day_rapid_onset_flooding_alaska/hucs.sql
Publish Service MAPX and YAML:
Core/LAMBDA/viz_functions/viz_publish_service/services/medium_range_blend_alaska/mrf_nbm_10day_peak_flow_arrival_time_alaska_noaa.yml
Core/LAMBDA/viz_functions/viz_publish_service/services/medium_range_blend_alaska/mrf_nbm_10day_peak_flow_arrival_time_alaska_noaa.mapx
Screenshots
Notes
In order to create the Huc Hotspot layers for this and other services, there were 2 new tables added to the "derived" schema in the vizprocessing database (TI). These will need to be manually moved to the UAT and Production databases:
Created the new MRF 10-day NBM Rapid Onset Flooding service for Alaska:
Additions
Initialize Pipeline Configuration YAML: Core/LAMBDA/viz_functions/viz_initialize_pipeline/product_configs/medium_range_blend_alaska/mrf_nbm_10day_rapid_onset_flooding_ak.yml
Postprocessing SQL: Core/LAMBDA/viz_functions/viz_db_postprocess_sql/products/medium_range_blend_alaska/mrf_nbm_10day_rapid_onset_flooding_alaska.sql
Summary SQL for the Huc Hotspot layer: Core/LAMBDA/viz_functions/viz_db_postprocess_sql/summaries/mrf_nbm_10day_rapid_onset_flooding_alaska/hucs.sql
Publish Service MAPX and YAML: Core/LAMBDA/viz_functions/viz_publish_service/services/medium_range_blend_alaska/mrf_nbm_10day_peak_flow_arrival_time_alaska_noaa.yml Core/LAMBDA/viz_functions/viz_publish_service/services/medium_range_blend_alaska/mrf_nbm_10day_peak_flow_arrival_time_alaska_noaa.mapx
Screenshots
Notes
In order to create the Huc Hotspot layers for this and other services, there were 2 new tables added to the "derived" schema in the vizprocessing database (TI). These will need to be manually moved to the UAT and Production databases:
derived.huc10s_alaska derived.featureid_huc_crosswalk_ak