Import Station, Offset, and Elevation Files (.csv)Import a text file (.csv) of station, offset, an elevation values to create points or stored cross-sections associated with an alignment in your project. You can then use the data to create a surface. To import a file, follow the instructions in Import Data. Note: Before selecting a Station/Offset/Elevation .csv file to import using the Import pane, right-click the file in the Select File(s) list and select the file type Station/Offset/Elevation. Rules for importing a station, offset, and elevation file: - The name of the .csv file must match the name of an alignment in your project, if you have more than one alignment. If you have only one alignment, the indicated .csv file will e imported with respect to that alignment. If you do not have an alignment, the importer will not work.
- The header (first line) in the file must contain the phrase "TBC Excel" (in English). The header can contain other explanatory text beyond the above key phrase.
- The second line in the file is expected to contain the first cross-section node data.
- The order of the data fields associated with each cross-section node is Station,Offset,Elevation,Code.
- Unless otherwise noted in the header line, the default delimiter between data fields is a comma. However, if the header line is found to contain a semicolon, that is an indication of the fact that the delimiter is expected instead to be a semicolon.
Sample: - Alignment in project: First Street
- File name: First Street.csv
File data showing the header and first two cross-sections: TBC Excel - Station,Offset,Elevation,Code 20,-8.89,59.36,TIEL 20,-3.8,62.75,SHLDL 20,-2.5,62.83,EOPL 20,0,62.9,CL 20,2.5,62.98,EOPR 20,3.8,63.02,SHLDR 20,8.65,59.78,TIER 30,-8.89,59.36,TIEL 30,-3.8,62.75,SHLDL 30,-2.5,62.83,EOPL 30,0,62.9,CL 30,2.5,62.98,EOPR 30,3.8,63.02,SHLDR 30,8.65,59.78,TIER |