Define HAND-based Flood Depth and Extent from Table

[Rokon_Zaman]

Hello good People. Recently i am working on HAND based Flood depth toolbox from ArcHydro tools for inundation mapping. For "Define Hand- based Flood Depth and Extent from Table" tool inputs are HAND raster, catchment raster and flood depth table. I have different flood depth level at different reach. How do i assign different flood depth at different stream? what is the format of "flood depth table"? What are the other data i need to input? 

This is my "StreamLink" files attribute table

[DeanDjokic]

Here is the data schema that will make it work:

Catchment raster needs to have VALUE field (unique identifier of the catchment raster).  This is the raster value.

Flood depth table needs to have two fields (example below):

1. COMID (Long integer) - this needs to match the VALUE field for the catchment you are assigning depth for.

2. H (Double) - depth that you want to "flood" catchment with.

That's it (note that the HAND raster should have been derived using streams/drainage lines matching the catchments).

[PhilAd]

Can you help me resolve this error when trying to run the tool?:

1. Calculating depth raster.

ERROR 010423: C:\Users\padalikw\AppData\Local\Temp\ArcGISProTemp29148\x07bd4292_d8ea_4a4c_b1bb_e6f0f8a54f26y0.afr does not have valid statistics as required by the operation.

ERROR 010423: C:\Users\padalikw\AppData\Local\Temp\ArcGISProTemp29148\x07bd4292_d8ea_4a4c_b1bb_e6f0f8a54f26y0.afr does not have valid statistics as required by the operation.

Failed to execute (Con).

 ('line 165', 'c:\\program files\\arcgis\\pro\\Resources\\ArcToolbox\\Scripts\\ArcHydro\\defineHANDbasedflooddepthandextentfromtable.py', '')

Finished at 2025-03-21 11:21:08

[DeanDjokic]

please provide a more detailed description of inputs and version of software you are using (Pro/AH).  on data side - do a screen capture of the UI with filled inputs and outputs. and for inputs the screenshot of the size of HAND raster (rows/columns), spatial reference, number of catchments, and the catchment/depth table.  similar to what is in the initial post.  that will help narrowing down what the possible problem is.

[PhilAd]

My software is ArcGIS Pro 3.4.2

Unfortunately, I do not have permission to upload images (screen capture). However, my HAND raster is a HUC4 size, the catchment raster has 51 catchments. My flood depth table has the same number of columns as the one you posted in your reply to the first question, with the same headers.

I will upload screenshots when I am granted permission to upload images.

Thanks.

[DeanDjokic]

how big is your DEM (rows by columns)?  is the comid value in the table the same as the grid value in your catchment raster?

[PhilAd]

My DEM has 35723 rows and 23318 columns.  No, the COMID value in the table is not the same as the grid value in my catchment raster. 

[DeanDjokic]

the size of the raster should be OK (unless your computer has only 16GB of RAM, then it might be a possible issue). the mismatch between the table COMID and the value of the catchment raster is DEFINITELY the problem.  make sure that the COMID value matches the grid value for the catchment you are trying to assign the HAND value (H) for.  let's see if that does the trick (no need to do screen captures if that fixes it).

one things to consider in the long run - HUC4 is a large area and having only 51 catchments means that each is fairly large and each has a uniform depth of flooding so no much variation within such large area.  you might want to partition your area into more catchments - that will give you better spatial variability (of course, you need to be able to match that increased spatial resolution with variability in H values - can you get the depts be different over more catchments).  just a thought ...

[PhilAd]

I went ahead and made the COMID in the table the same as the grid value of the Cat  raster and reran the tool. Below is the new error:

arcpy.env.scratchworkspace=C:\Users\padalikw\Documents\ArcGIS\Projects\FloodDepthExtent_MHW\scratch.gdb scracthfolder=C:\Users\padalikw\Documents\ArcGIS\Projects\FloodDepthExtent_MHW\scratch
1. Adding HInt field and calculate it as H * 100.
Completed, 1. Adding HInt field and calculate it as H * 100. ddt=7.317 seconds.
2. Reclassifying - assigning integer depth of flooding for each catchment.
Completed, 2. Reclassifying - assigning integer depth of flooding for each catchment. ddt=34.869 seconds.
3. Calculating float depth of flooding for each catchment.
Completed, 3. Calculating float depth of flooding for each catchment. ddt=0.059 seconds.
4. Calculating unrestricted depth raster.
Completed, 4. Calculating unrestricted depth raster. ddt=0.949 seconds.
5. Calculating depth raster.
ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.
CreateRasterDatasetName: The workspace c:\10Data\ChesterOps\Layers does not exist. [c:\10Data\ChesterOps\Layers\FloodDepthA_Max_SR.tif]
Failed to execute (CopyRaster).
('line 167', 'c:\\program files\\arcgis\\pro\\Resources\\ArcToolbox\\Scripts\\ArcHydro\\defineHANDbasedflooddepthandextentfromtable.py', '')
Finished at 2025-03-21 15:30:37

[PhilAd]

Yeh!!!! It worked after I fixed the directory path for the flood depth raster and flood extent polygon. Thanks so much for your help. I should have reached out sooner. lol!