Can You Export Profile Data to a Spreadsheet/Text File?

[jonathan]

I have a very large topographical area that I am analyzing to simulate a dam breach using HECRAS.  I have already imported the point data and created a surface.  The reach could be as much as 5 miles long, and I plan to do a profile cross-section every 200 feet.  You can only imagine how long it will take to create detailed stream channel profile sections to input into the program by hand (think 26 profiles per mile over at least five miles with 30 elevations per profile... 4000 points not including the time to create the profiles).

Is there some way to create a profile (quick profile would be perfect) and then output the station/elevation of that profile to a text file, spreadsheet, or some other kind of file?  I have no iea if there is a way to import it all into HECRAS, but even copying/pasting would make this incredibly faster.  Thanks!!

[Buzz12345]

A couple of options for you:

A. Export to Hec ras on the output ribbon.  I've never used it, so I don't know if it'll work for you.

B. There are some options for exporting profiles to csv or landxml in the report manager in the prospector toolbox, but I've found that they need a bit of extra processing to adjust formatting such as removing blank lines.

C. We export profiles to csv, by copying the data from the panorama view:

Select the profile, right click and select edit profile geometry, select profile grid view, (button 3rd from right)

right click in the grid and select Copyall

paste into excel

You'll find the data goes in as text strings, so you'll need to manipulate it in excel to get numerical values (use the =numbervalue function)

Hopefully one of these options will work for you.

[sboon]

I had to do something like this a few weeks ago, so I worked out a method using a corridor and sample lines to get the data into a format that could be manipulated in Excel.

Start by creating an assembly using two copies of StrippingTopsoil.  Use a very small value for the depth, set the slopes to zero and the width to suit your channel.  Use this assembly to create a corridor along the river alignment with frequencies set to 200'  Once that is done you need to create a sample line group on the same alignment with sample lines at corridor stations.

The last step is to run the Corridor Section Points report from the Toolbox.  From there you can cut and paste the data into Excel and manipulate it to suit your purposes.

Steve
Please use the Accept as Solution or Kudo buttons when appropriate

[Nik-D]

check these tutorials they will show you what you want to bring in your sections

https://www.youtube.com/watch?v=DpMvnvoTKUA

https://www.youtube.com/watch?v=0wo6_ydSvZI

https://www.youtube.com/watch?v=qU_-EL9rmDw

Nik

[leonard_kellySN9GR]

Option C worked for me to export to Excel.

"Select the profile, right-click and select edit profile geometry, and select profile grid view, (button 3rd from right)

right-click in the grid and select Copy all

paste into excel"

Thank You!