Importing Cross Sections into HEC-RAS

[Anonymous]

Hello,
I am working on a floodplain modeling project for my University, where we have gone in the field and taken stream and river cross sections using Emlid RTK surveying equipment. This data is to be used to update stream and river bathymetry collected by LiDAR. I have the survey data available in GIS and as a .csv. I’m aware that there is an import data from .csv function, but I have had issues with getting the import correct. Can anyone provide more information regarding the format it would need to be in to import from .csv, or if there is a more effective way of getting the survey data into HEC-RAS.

Thanks,

[gerardo]

y;x;z;RS;Station;Elevation
6565985.445;4377489.69;716.09;0;0;716.09
6565985.039;4377489.869;715.66;0;0.44;715.66
6565980.635;4377491.815;713.39;0;5.26;713.39
6565979.481;4377492.324;712.98;0;6.52;712.98
6565978.194;4377492.893;713.3;0;7.93;713.3
6565974.168;4377494.672;714.39;0;12.33;714.39
6565969.651;4377496.667;716.44;0;17.27;716.44
6565962.793;4377499.697;715.89;0;24.76;715.89
6565958.434;4377501.622;716.18;0;29.53;716.18
6565952.649;4377504.178;716.56;0;35.85;716.56
6565944.94;4377507.584;717.3;0;44.28;717.3
;;;;;
6565973.875;4377468.779;716.3;24.1;3.41;716.3
6565972.398;4377469.348;715.53;24.1;5;715.53
6565969.762;4377470.363;714.35;24.1;7.82;714.35
6565968.653;4377470.79;713.87;24.1;9.01;713.87
6565967.479;4377471.243;714.29;24.1;10.27;714.29
6565965.84;4377471.874;714.94;24.1;12.02;714.94
6565965.403;4377472.042;715.07;24.1;12.49;715.07
6565964.225;4377472.496;715.6;24.1;13.75;715.6
6565958.891;4377474.551;715.96;24.1;19.47;715.96
6565953.424;4377476.657;717.16;24.1;25.33;717.16
6565945.71;4377479.629;717.48;24.1;33.6;717.48
6565938.187;4377482.527;717.99;24.1;41.66;717.99
6565930.541;4377485.473;719.18;24.1;49.85;719.18
;;;;;
6565965.736;4377448.567;717.24;45.65;0;717.24
6565962.418;4377450.042;715.07;45.65;3.63;715.07
6565959.577;4377451.305;714.45;45.65;6.74;714.45
6565958.395;4377451.83;713.95;45.65;8.03;713.95
6565955.718;4377453.02;714.39;45.65;10.96;714.39
6565954.225;4377453.684;715.32;45.65;12.6;715.32
6565952.051;4377454.65;716.62;45.65;14.98;716.62
6565947.313;4377456.756;716.2;45.65;20.16;716.2
6565943.444;4377458.475;716.58;45.65;24.39;716.58
6565939.008;4377460.447;717.04;45.65;29.25;717.04
6565934.06;4377462.646;717.58;45.65;34.66;717.58
6565929.89;4377464.5;718.01;45.65;39.23;718.01
;;;;;
6565954.219;4377423.218;718.46;72.95;0;718.46
6565953.507;4377423.598;718.24;72.95;0.81;718.24
6565947.112;4377427.008;716.64;72.95;8.05;716.64
6565945.79;4377427.712;716.05;72.95;9.55;716.05
6565943.66;4377428.849;715.44;72.95;11.97;715.44
6565942.536;4377429.448;715.68;72.95;13.24;715.68
6565939.299;4377431.174;715.76;72.95;16.91;715.76
6565935.417;4377433.245;717.12;72.95;21.31;717.12
6565928.491;4377436.938;717.89;72.95;29.16;717.89
6565918.95;4377442.026;719.17;72.95;39.97;719.17
6565915.068;4377444.096;720.5;72.95;44.37;720.5
;;;;;
6565950.721;4377394.467;721;96.07;0.99;721
6565946.782;4377397.439;719.63;96.07;5.92;719.63
6565938.314;4377403.828;717.78;96.07;16.53;717.78
6565934.302;4377406.856;716.73;96.07;21.56;716.73
6565930.105;4377410.023;715.82;96.07;26.81;715.82
6565929.049;4377410.819;716.6;96.07;28.14;716.6
6565928.332;4377411.36;715.8;96.07;29.03;715.8
6565928.246;4377411.425;715.5;96.07;29.14;715.5
6565927.093;4377412.295;715.23;96.07;30.59;715.23
6565926.461;4377412.772;715.52;96.07;31.38;715.52
6565925.295;4377413.651;715.98;96.07;32.84;715.98
6565921.395;4377416.594;716.65;96.07;37.72;716.65
6565917.004;4377419.907;717.56;96.07;43.22;717.56
6565912.698;4377423.156;719.97;96.07;48.62;719.97
;;;;;
6565930.314;4377381.286;718.46;120.94;0.03;718.46
6565925.768;4377384.142;717.95;120.94;5.34;717.95
6565921.118;4377387.064;717.37;120.94;10.83;717.37
6565915.232;4377390.762;715.94;120.94;17.78;715.94
6565913.516;4377391.84;715.61;120.94;19.8;715.61
6565912.72;4377392.34;715.23;120.94;20.75;715.23
6565912.329;4377392.586;715.46;120.94;21.21;715.46
6565911.918;4377392.845;715.67;120.94;21.69;715.67
6565911.918;4377392.845;715.65;120.94;21.69;715.65
6565907.875;4377395.385;716.45;120.94;26.47;716.45
6565903.342;4377398.233;718.18;120.94;31.82;718.18
6565899.03;4377400.942;719.45;120.94;36.91;719.45
6565894.698;4377403.665;721.08;120.94;42.03;721.08
;;;;;
6565939.255;4377366.146;721.39;143.88;0.23;721.39
6565938;4377366.336;720.79;143.88;1.04;720.79
6565931.967;4377367.249;719.99;143.88;7.14;719.99
6565924.584;4377368.366;718.94;143.88;14.61;718.94
6565917.564;4377369.428;718.42;143.88;21.71;718.42
6565913.605;4377370.027;719.08;143.88;25.71;719.08
6565910.296;4377370.528;717.77;143.88;29.06;717.77
6565907.686;4377370.923;716.82;143.88;31.7;716.82
6565903.706;4377371.525;716.25;143.88;35.72;716.25
6565902.936;4377371.642;715.96;143.88;36.5;715.96
6565901.53;4377371.855;715.63;143.88;37.92;715.63
6565901.497;4377371.86;715.63;143.88;37.96;715.63
6565900.051;4377372.079;715.84;143.88;39.42;715.84
6565897.875;4377372.408;716.2;143.88;41.62;716.2
6565894.895;4377372.859;718.55;143.88;44.63;718.55
6565892.95;4377373.153;719.65;143.88;46.6;719.65
;;;;;
6565931.924;4377347.03;721.97;172.48;0;721.97
6565929.372;4377346.757;720.65;172.48;2.57;720.65
6565924.084;4377346.19;719.98;172.48;7.89;719.98
6565919.133;4377345.66;719.72;172.48;12.86;719.72
6565915.671;4377345.289;719.47;172.48;16.35;719.47
6565914.774;4377345.193;718.8;172.48;17.25;718.8
6565910.227;4377344.706;719.28;172.48;21.82;719.28
6565906.139;4377344.268;718.11;172.48;25.93;718.11
6565904.271;4377344.068;718;172.48;27.81;718
6565902.668;4377343.896;717.52;172.48;29.42;717.52
6565900.822;4377343.698;717.28;172.48;31.28;717.28
6565899.025;4377343.506;717.73;172.48;33.09;717.73
6565896.004;4377343.182;719.33;172.48;36.13;719.33
6565894.871;4377343.061;720.08;172.48;37.27;720.08
;;;;;
6565919.296;4377318.109;718.47;204.73;13.94;718.47
6565919.215;4377318.061;718.4;204.73;14.03;718.4
6565916.183;4377316.245;717.68;204.73;17.57;717.68
6565914.309;4377315.123;717.48;204.73;19.75;717.48
6565910.868;4377313.063;716.97;204.73;23.76;716.97
6565910.864;4377313.06;716.97;204.73;23.77;716.97
6565909.533;4377312.263;717.38;204.73;25.32;717.38
6565907.898;4377311.284;718.35;204.73;27.23;718.35
6565905.215;4377309.678;719.66;204.73;30.35;719.66
6565903.488;4377308.644;721.05;204.73;32.37;721.05
6565901.59;4377307.507;722.05;204.73;34.58;722.05
;;;;;
6565926.387;4377304.228;718.31;225.48;6.29;718.31
6565924.604;4377302.285;718.13;225.48;8.93;718.13
6565922.891;4377300.417;717.48;225.48;11.46;717.48
6565922.198;4377299.662;717.82;225.48;12.49;717.82
6565919.662;4377296.898;718.86;225.48;16.24;718.86
6565917.855;4377294.929;719.89;225.48;18.91;719.89
6565915.221;4377292.058;721.01;225.48;22.8;721.01
6565911.737;4377288.26;722.4;225.48;27.96;722.4
;;;;;
6565942.421;4377294.711;720.38;245.78;0;720.38
6565941.901;4377293.86;719.31;245.78;1;719.31
6565939.761;4377290.364;718.38;245.78;5.1;718.38
6565938.286;4377287.954;717.61;245.78;7.92;717.61
6565937.546;4377286.744;717.79;245.78;9.34;717.79
6565937.28;4377286.309;718.29;245.78;9.85;718.29
6565934.533;4377281.82;719.54;245.78;15.11;719.54
6565932.752;4377278.91;720.43;245.78;18.52;720.43
6565932.241;4377278.074;720.32;245.78;19.5;720.32
6565929.841;4377274.153;721.61;245.78;24.1;721.61
6565928.439;4377271.862;723.5;245.78;26.79;723.5
;;;;;
6565966.383;4377286.674;720.88;270.32;0.21;720.88
6565964.424;4377284.011;719.64;270.32;3.52;719.64
6565962.586;4377281.513;719.1;270.32;6.62;719.1
6565960.651;4377278.883;718.67;270.32;9.89;718.67
6565959.834;4377277.772;718.7;270.32;11.26;718.7
6565957.365;4377274.417;718.37;270.32;15.43;718.37
6565957.073;4377274.02;718.91;270.32;15.92;718.91
6565955.14;4377271.393;719.68;270.32;19.19;719.68
6565954.385;4377270.367;719.89;270.32;20.46;719.89
6565952.915;4377268.369;721.13;270.32;22.94;721.13
6565952.051;4377267.194;721.26;270.32;24.4;721.26
6565949.22;4377263.347;721.66;270.32;29.17;721.66
6565946.435;4377259.562;722.89;270.32;33.87;722.89
;;;;;
6565984.623;4377271.184;721.67;291.62;0.11;721.67
6565981.569;4377268.186;719.87;291.62;4.38;719.87
6565979.108;4377265.769;719.22;291.62;7.83;719.22
6565976.686;4377263.391;719.98;291.62;11.23;719.98
6565976.612;4377263.317;720.06;291.62;11.33;720.06
6565974.742;4377261.482;719.35;291.62;13.95;719.35
6565970.788;4377257.598;719.9;291.62;19.5;719.9
6565969.268;4377256.106;720.62;291.62;21.63;720.62
6565968.095;4377254.955;721.61;291.62;23.27;721.61
6565966.734;4377253.617;722.94;291.62;25.18;722.94
;;;;;
6566010.971;4377255.9;722.97;320.2;0;722.97
6566007.791;4377253.005;722.72;320.2;4.3;722.72
6566004.662;4377250.157;721.93;320.2;8.53;721.93
6566000.573;4377246.434;720.97;320.2;14.06;720.97
6565997.265;4377243.423;720.39;320.2;18.53;720.39
6565995.945;4377242.22;719.94;320.2;20.32;719.94
6565995.652;4377241.954;719.69;320.2;20.72;719.69
6565995.262;4377241.598;719.56;320.2;21.24;719.56
6565993.648;4377240.129;719.86;320.2;23.43;719.86
6565991.804;4377238.45;720.47;320.2;25.92;720.47
6565989.149;4377236.034;720.2;320.2;29.51;720.2
6565987.106;4377234.173;722.18;320.2;32.27;722.18
6565984.853;4377232.123;722.98;320.2;35.32;722.98
;;;;;
6566024.443;4377235.453;721.68;348.52;0;721.68
6566018.87;4377229.865;721.64;348.52;7.89;721.64
6566011.553;4377222.528;720.95;348.52;18.25;720.95
6566010.169;4377221.14;720.53;348.52;20.21;720.53
6566009.099;4377220.068;720.08;348.52;21.73;720.08
6566007.561;4377218.525;721.37;348.52;23.91;721.37
6566003.86;4377214.814;721.22;348.52;29.15;721.22
6566002.019;4377212.968;722.52;348.52;31.75;722.52

[gerardo]

En excel debes acomodar los puntos (interpolando) para que queden en la misma linea que XS.
utilizando la ecuacion Y=aX+b.
Cualquier duda puedes consultarme

In excel you must accommodate the points (interpolating) so that they are on the same line as XS.
using the equation Y = aX + b.
Any questions you can ask me

[Anonymous]

you have to have 6 columns in your data..

River | Reach | RS | x | y | z |

OR

River | Reach | RS | Station | Elevation

so if these data points are somewhat random or do not fall exactly on cross-sections that you intend to model, then you have to interpolate them onto your desired cross-section location.

An alternative (if appropriate depending on data coverage and other factors) would be to convert the data to a raster and import it as terrain using RAS Mapper, then you can just draw your cross-sections and cut the profiles from the terrain.

[Anonymous]

Thanks for the help. I was able to get the xs’s correctly plotted in my terrain.

[PaoloP]

Take a look of RAS Geometry Maker https://www.m3eweb.it/products/ in could be useful

[ns4818]

Hi Gerardo,

My name is Neeraj. I am new to river modeling. I have UTM coordinates of the x-sections (elevation is depth). I don’t know the datum but I suppose it’s zero from some benchmark.
Can you please explain your method of finding RS and Station in detail? I am attaching my data for your convenience. It would be great if you could show your method in the attached excel file. Thank you very much for your help.
GGA_Depth_US_DS.csv

[Author]

Posts