Importing Excel file into HEC-RAS
Importing Excel file into HEC-RAS
(OP)
I have been given an ASCII point file in CSV format in excel. The information is ordered as follows: Point number, Northing (Y), Easting (X), Elevation, and Description.
This data is the culmination of a hydrographic survey done on a river reach that is to be modeled in HEC-RAS. How do I import this data into HEC-RAS without having to painstakingly input each cross section one point at a time? Do I need additional programs (ArcView, ArcGIS, GeoRAS) in order to accomplish this?
Any help or insight is much appreciated.
This data is the culmination of a hydrographic survey done on a river reach that is to be modeled in HEC-RAS. How do I import this data into HEC-RAS without having to painstakingly input each cross section one point at a time? Do I need additional programs (ArcView, ArcGIS, GeoRAS) in order to accomplish this?
Any help or insight is much appreciated.





RE: Importing Excel file into HEC-RAS
HEC-RAS has the ability to import geometric data in several different formats. These formats include: a GIS format (developed at HEC); the USACE Standard Surveyor format; HEC-2 data format; HEC-RAS data format; UNET geometric data format; and the MIKE11 cross section data format. Data can be imported into an existing HEC-RAS geometry file or for a completely new geometry file. Multiple data files can be imported into the same geometric data file on a reach-by-reach basis.
To import data into a HEC-RAS geometric data file, the user selects the Import Geometric Data option from the File menu of the Geometric Data window. Once this option is selected, the user then selects one of the three available formats from the list. After a format is selected, the user will be asked if they want to add the data to the current geometry file, or if they want to clear the current geometry file before importing the data. Once this choice is made, the user will be prompted to enter the name of the file containing the data. The following is a discussion of each of the three file formats.
--------------------------------------------------------------------------------
GIS Format
USACE Survey Data Format
HEC-2 Data Format
HEC-RAS Data Format
UNET Geometric Data Format
MIKE11 Cross-Section Data"
good luck
RE: Importing Excel file into HEC-RAS
RE: Importing Excel file into HEC-RAS
We have EaglePoint in our office and are currently trying to figure out a way to import this data into EP and then export out to HEC-RAS. The only problem we seem to be running into is a "tab delimited" error. EP apparently doesn't play well with this file type. I've gone and converted the original file to several different options (comma delimited, space delimited....) but everytime I go to resave it, it defaults back to tab delimited. Still trying to hammer out this bug.
I've noticed in scanning the internet for possible solutions that you could create a text file with commands but sadly, I am not at all familiar with that. I also tried creating a few generic cross sections but don't know how to discern the format.
Thanks for the input guys. I'll keep hammering away at it.
RE: Importing Excel file into HEC-RAS
RE: Importing Excel file into HEC-RAS
I've tried creating a series of river and reaches (stick figure on geometry data plan) with which to import this data into and I've also tried to only import one cross section (as a test) to see if it would work, but I keep getting this error message.
I know there is a solution to this without having to go buy ArcView or ArcGIS (to use with GeoRAS), but I keep spinning my wheels trying to figure it out. Any thoughts?
RE: Importing Excel file into HEC-RAS
RE: Importing Excel file into HEC-RAS
RE: Importing Excel file into HEC-RAS
RE: Importing Excel file into HEC-RAS
I've seen the sample geometry files in the HEC-RAS manual but I don't know how to convert the csv to this type of file (forgive me for my ignorance). Do I have to manually type out the data file structure in word or is there a simpler way to convert one to the other?
Again, I apologize if it seems that I am asking the same questions, but I am new to taking raw survey data and importing it into HEC-RAS. Here is my file if anyone can take a look at it and see if there is something wrong with the initial setup.
Thanks again.
RE: Importing Excel file into HEC-RAS
RE: Importing Excel file into HEC-RAS
Could it be that the new version (4.0) still has some bugs pertaining to importing csv files?
It seems that the only option left is to use ArcGIS and GeoRAS. I'm in the process of downloading GeoRAS and going through its manual as we speak.
I shall slay this beast if it takes everything inside of me...(or until 5pm roles around).
RE: Importing Excel file into HEC-RAS
RE: Importing Excel file into HEC-RAS
Currently, I'm in the process of pairing each cross section with a station number. I'll see if the placing matters as far as upstream/downstream layout it concerned.