Extracting results from HEC-HMS

[devacharan]

I successfully ran my model in HEC-HMS software, but I want to extract the hydrographs from each basin into TXT or CSV files so that I can use that data further.
However, I am unable to do that with the options provided in this package. can someone guide me through it or suggest any other ways to extract the data?

[oskarhurst]

Hello @devacharan, were you able to successfully read the data from the DSS file into a TimeSeries python object. If this was successful we then recommend you use existing python tools to write your data to the file of your choice.
Basic example

dss_file_path = "example.dss"

# Define the path for the time series data in the DSS file
path = "/path/to/data//1Hour/Time Series/"

# Open the DSS file for reading
with HecDss(dss_file_path) as dss:
    # Read the time series data from the DSS file
    ts = dss.get(path)

    # Convert the time series data to a pandas DataFrame
    df = pd.DataFrame({
        'Time': ts.times,
        'Value': ts.values,
        'Path': [path for _ in range(len(ts.times))]
    })

    # Save the DataFrame to a CSV file
    df.to_csv('output.csv', index=False)

    # Print the first few rows of the DataFrame
    print(df.head())

[ktarbet]

closing issue, no activity in 3-weeks.

[devacharan]

@ktarbet , sorry for not being active I am on vacation

@oskarhurst Thanks a lot for the reply, but I am a little confused,
no, I wasn't able to successfully read the data from the DSS file into a TimeSeries Python object

Can you please suggest where I can get that path for the time series data in the DSS file?
In HEC-HMS software, in time-series gage, mine is a manual entry, so, I couldn't see a DSS Pathname. currently, I am using '//gage/precip-inc//5min/gage/' but it's giving KeyError: '//gage/precip-inc//5min/gage/'

Best wishes,
Charan

[oskarhurst]

@devacharan could you please send me an attach copy of the dss file that you are trying to read from so I can see that data within it.

[devacharan]

Hallo @oskarhurst,

I cannot attach the DSS file here (not supported), could you provide your email or something? so that I can transfer

Best,
Charan

[oskarhurst]

Hallo @oskarhurst,

I cannot attach the DSS file here (not supported), could you provide your email or something? so that I can transfer

Best, Charan

Questions on DSS, bugs and resources to replicate them can be submitted to hec.dss@usace.army.mil

[ktarbet]

Hi @devacharan ,

Your file is formatted as DSS Version 6. The DSS python library only supports DSS version 7 files.
Please first convert to DSS 7. That can be done with the HEC-DSSVue - Tools menu.

You can attach a DSS file (in github) by first zipping to a zip file.

[oskarhurst]

@devacharan Hi i was just able to look at your email today and I think I found the problem. So there is a couple things, of the two dss files you sent "Trial_2.dss" and "Trail_2.dss" Trial2 is a dss 6 file with data inside and Trail2 is a dss 7 file which is empty. Within your code you were opening up dss_file_path = "Trial_7.dss" which is the empty file hence the KeyError since it has no records. Another important note is when I opened up the Trial2 dss 6 file and converted it to dss 7 I could see the correct path to your time series is

'//GAGE 1 - PREC/PRECIP-INC/08Jul2021 - 10Jul2021/5Minute/GAGE/'
not
'//GAGE1-PREC/PRECIP-INC/08JUL2021-10JUL2021/5MIN/GAGE/'

which was in your code. The important difference is the spaces in the B part. DSS is not capitilazation sensitive but it is white space sensitive. Note 5MIN is automatically converted to 5Minute when converting from dss 6 to 7.

To view and convert your dss files we recommend using HEC-DSSVue
https://www.hec.usace.army.mil/software/hec-dssvue/

you can also view all the paths in you dss file after you opened it using dss-py using the get_catalog() function

with HecDss(self.test_files.get_copy("sample7.dss")) as dss:
    catalog = dss.get_catalog()
    for ds in catalog:
        print(ds.recType, ds)

[devacharan]

@oskarhurst Thanks for your answer,
I converted to dss7 but still there is a KeyError: '//gage 1 - prec/precip-inc//5minute/gage/' and get_catalog() function is giving self error

[ktarbet]

@devacharan , @oskarhurst 's example was an example.

use like this:

with HecDss("new_trail7.dss") as dss:
....