FIMPact to just Critical Infrastructure Layer

[derekgiardino]

A request from the field came to create a critical infrastructure hotspot FIMpact layer, as another option in the QC FIM layers. The Critical Infrastructure Layer can be found here if access is limited let me know as I made the layer back at WGRFC and we can move that layer over to HydroVIS as well for part of this process. This isn't required for 2.1.8, its a nice if we have time, but if not we can push it to the next update.

[derekgiardino]

I moved this one to next update so George could potentially take the lead on this and use the tethys app that Shawn has to do so.

[GeorgeRought-NOAA]

To Do:

Create Static Critical Infrastructure Service

• Grab Derek's All Infrastructure Merged service as an editable local copy.
• Create a Jupyter Notebook to script and document the ingestion of the dataset into the EGIS hydrovis database, in the reference schema as a new table.
• Configure the dataset symbology in ArcGIS Pro and create a new mapx in the reference services folder in the repo.
• Publish the service to eks-maps-testing.water.noaa.gov.
• Create a service publishing configuration .yml file at Core/LAMBDA/viz_functions/viz_publish_service/services/reference.
  service: <service_name>
  summary: <service_name_as_title>
  description: <brief_description>
  tags: national water model, nwm, reference,
  credits: National Water Model, NOAA/NWS National Water Center
  egis_server: server|image (for vector|raster)
  egis_folder: reference
  feature_service: true|false
  public_service: true|false
• Commit the Jupyter Notebook, .mapx, .yml files into a new branch in github and submit a PR.

Create Critical Infrastructure FIMPact Service in QC FIM

• The service should exist as a new sub layer within 18 Hours - Impacted Buildings (Estimated)

• The service should use the same symbology as the 18hr estimated impacted buildings heatmap

• Draft a FIMPact Critical Infrastructure Heatmap for review.

• Develop FIMPact Critical Infrastructure Service in the VPP.

• Update Core/LAMBDA/viz_functions/viz_publish_service/services/short_range/srf_18hr_max_inundation_extent_noaa.mapx and the corresponding .yml.

• Commit the updated .mapx and .yml to a new branch and submit PR for review.

• Repeat for MRF NBM, MRF GFS, RFC, and ANA FIMs

[GeorgeRought-NOAA]

Reference this service: 18hr estimated impacted buildings heatmap

[GeorgeRought-NOAA]

New static service for the critical infrastructure point layer can be found in TI here:
https://eks-maps-testing.water.noaa.gov/server/rest/services/reference/static_public_critical_infrastructure_points/FeatureServer

[GeorgeRought-NOAA]

The below screenshot is a heatmap in ArcGIS Pro of the new FIMPact to Critical Infrastructure dataset, it's the result of spatially intersecting the "All_merged_infrastructure" layer provided by Derek with the srf_18hr_max_inundation_geo geometry. It retains columns from the srf_18hr_max_inundation and srf_18hr_max_inundation_flows tables.

The proposed table name is srf_18hr_max_inundation_critical_infrastructure, matching the naming scheme of the existing building footprints FIMPact layer - srf_18hr_max_inundation_building_footprints. It will be placed in the publish schema of the vizprocessing database, and will be accessible as a foreign table in the vizprc_publish schema in the egis database.

The proposed service name is "18 Hours - Estimated Impacted Critical Infrastructure - Heatmap".

The new service will exist as a sublayer in 18 Hours Impacted Buildings (Estimated) layer with the same symbology as the 18 Hours - Estimated Impacted Buildings - Heatmap sublayer.

This screenshot shows the estimated impacted critical infrastructure as points (red) ontop of the 18 hour max inundation geometry (pink) to visualize exactly what the heat map is based on. The blue points are critical infrastructure outside the max inundation extent.

The original all_merged_infrastructure layer contained the following 44 columns. I plan to reduce these columns to better align with the current impacted buildings service.

column_name | country | naics_code | specialty | excess_bed | val_method | tot_enroll | city | latitude | county | level_ | source | type | st_grade | sourcedate | st_grade_1 | alias | state | id | helipad | build_type | end_grade | longitude | zip | trauma | naics_desc | website | address | naicscode | telephone | addressbui | tot_emp | population | enrollment | val_date | zipcode | alt_name | naicsdescr | ft_teacher | name | beds | objectid | status | geometry | oid