Import Superelevation
Incorporates superelevation values via a CSV file.
You can access this tool from the following:
Import Superelevation
In lieu of using rule-based superelevation transitions, the data may be imported from a CSV file, where calculations are done outside of the Civil products and just the results are imported. In this case, rules do not apply, so no rules file is needed or specified.
Entire projects can be imported, in which case, only one superelevation section is needed. However, you can also import just a turn lane or two, or part of your project. Keep in mind the superelevation section and lanes must be created prior to importation, and lane names associated with the graphics do not need to match the names in the import file. Also keep in mind you can only import CSV into one superelevation section at a time. You may want to create a single superelevation section for the entire project by setting the Minimum Tangent Length to 5000 or some other equally large number.
The Windows delimiter value is used, which is generally set to comma; however, if you are experiencing difficulties, you may want to verify this on your workstation or laptop.
If a file is imported twice, duplicate lanes are not created; rather the values of the import file overwrite any values (including manual edits) of lanes.
File Format
The file format of the comma separated values file is:
SuperelevationLane,Station,CrossSlope,PivotAbout,PointType,TransitionType,NonLinearCurveLength
One sample line uses all options:
CL_RT1,2+50.000,-0.02,LS,NCIN,L,0
Another example has only the required information:
CL_RT1,2+50.000,-0.02,LS
The following details the required information:
Data |
Description |
Superelevation Lane |
Required - Links the data to an existing superelevation lane, therefore, the name in the CSV file must match the lane names created prior to importation. |
Station |
Required - Station where cross slope is defined. Station equations supported based on the section's reference alignment and the Design File Settings > Civil Formatting > Station Settings > Equation setting. |
Cross Slope |
Required - Cross slope at the specified station formatted as a double value: (-2% = -0.02). |
Pivot About |
Required - Identifies which edge to pivot about. Generally, if you are rotating about the center line, the right lane would pivot about the left edge (LS) while the left lane would pivot about the right edge (RS). LS = left side (edge) RS = right side (edge) |
Point Type |
Optional - Type of superelevation point at this station and cross slope. Possible values include: NC = Normal Crow NCIN = Normal Crown Inside, NCOUT = Normal Crown Outside, LC = Level Crown LCIN = Level Crown Inside LCOUT = Level Crown Outside RC = Reverse Crown RCIN = Reverse Crown Inside RCOUT = Reverse Crown Outside FS = Full Super FSIN = Full Super Inside FSOUT = Full Super Outside U = Undefined |
Transition Type |
Optional - Type of superelevation transition at this station and cross slope. Possible values include: L = Linear PC = Parabolic Curve PRC = Parabolic Reverse Curve BRC = Biquadratic Reverse Curve CRC = Cubic Reverse Curve SRC = Symmetrical Reverse Curve |
Non-Linear Curve Length |
Optional - Defines the maximum length of parabolic transition. This length will be reduced if the given length exceeds the length of the tangents on either side of the point. This parameter does not apply when Transition Type is Linear. |
Tool Workflow:
- Create the CSV file, based on file format.
- Create superelevation section and lanes, ensuring the lane names match those used in the CSV file.
- Select the Import Superelevation tool.
- Follow the heads-up
prompts:
Prompt
User Action
Locate First Superelevation Section
Select the first section. You can only import one section at a time, but you can call out the same CSV file for multiple sections. It will utilize the station range of the superelevation section and ignore any lines in the CSV file that are outside that range.
Import File Name
Use <ALT> <DOWN> to open the File Manager to select directory/CSV file.
The results look identical to those of the calculated superelevation lanes. All functionality (editor, graphic manipulation, etcetera) supported for calculation lanes is also supported for imported lanes, aside from reprocessing