Route Formats
A variety of Route Data Formats can be Imported. The Format Types are hard-coded into AutoChart and Details of the currently available file types are given below:
CFloor
The CFloor Route Format
Easting/Northing TP Comma Delimited
The Easting/Northing TP Route Format consists of a comma delimited file in the format Easting, Northing. The File should define the Route as a Series of Straight, Arc, Straight, Arc, etc. points with the Start and End of each Arc defined by the appropriate Tangent Points. i.e. Point -> Start Tangent Point -> End Tangent Point -> Start Tangent Point... etc.
Easting/Northing TP/CP Comma Delimited
The Easting/Northing TP/CP Route Format consists of a comma delimited file in the format Easting, Northing. The File should define the Route as a Series of Straight, Arc, Straight, Arc, etc. points with the Start and End of each Arc defined by the appropriate Tangent Points and Arc Centre Point. i.e. Point -> Start Tangent Point -> Centre Point -> End Tangent Point -> Start Tangent Point -> Centre Point... etc.
Easting/Northing TP/IP Comma Delimited
The Easting/Northing TP/IP Route Format consists of a comma delimited file in the format Easting, Northing. The File should define the Route as a Series of Straight, Arc, Straight, Arc, etc. points with the Start and End of each Arc defined by the appropriate Tangent Points and Arc Intersection Point. i.e. Point -> Start Tangent Point -> Intersection Point -> End Tangent Point -> Start Tangent Point -> Intersection Point... etc.
Easting/Northing/[Description] Comma Delimited
The Easting/Northing/[Description] Route Format consists of a comma delimited file in the format Easting, Northing, Description (Optional). The File should define the Route as a Series of Straight point to point segments. If the optional Description Field is included, then this information is attached to each vertex in the polyline and can be used to name/label Alter Course points etc. along the Route.
Eiva 5pt
The Eiva 5pt File Format is a semi-colon delimited file containing the cross profile markers in the format:
Column Number |
Description |
Format |
1 |
Date (DD.MM.YYYY) |
A10 |
2 |
Time (HHMMSS.ss |
F9.2 |
3 |
UTM Easting (in metres, e.g. 566782.21) |
F9.2 |
4 |
UTM Northing (in metres, e.g. 6781349.42) |
F9.2 |
5 |
KP (in Kms e.g. 106.45231) |
F9.5 |
6 |
Depth to Top of Pipe/Cover (in metres) |
F6.2 |
7 |
Depth Indicator P=Pipe, C=Cover |
A1 |
8 |
Depth in metres, trench left |
A6.2 |
9 |
Distance in metres from Pipe to field 8 |
A6.2 |
10 |
Depth in metres, trench right |
A6.2 |
11 |
Distance in metres from Pipe to field 10 |
A6.2 |
12 |
Depth in metres, mean seabed left |
A6.2 |
13 |
Distance in metres from Pipe to field 12 |
A6.2 |
14 |
Depth in metres, mean seabed right |
A6.2 |
15 |
Distance in metres from Pipe to field 14 |
A6.2 |
16 |
Depth of Cover in metres (from pipetracker if pipe is buried) |
A6.2 |
17 |
Comment (Free Text) |
A100 |
06.06.2009;001006.05;2548779.52;6183407.77; 0.14374;108.60;P;109.19; -0.39;109.16; 0.38;109.01; -4.00;108.86; 4.00; 0.00; ;
06.06.2009;001048.36;2548779.71;6183407.95; 0.14400;108.59;P;109.15; -0.38;109.16; 0.38;108.95; -4.00;108.85; 4.00; 0.00; ;
06.06.2009;001101.32;2548780.39;6183408.69; 0.14500;108.59;P;109.16; -0.38;109.15; 0.39;108.92; -4.01;108.77; 3.99; 0.00; ;
06.06.2009;001110.94;2548781.09;6183409.40; 0.14600;108.54;P;109.12; -0.39;109.13; 0.38;108.89; -4.00;108.68; 4.00; 0.00; ;
06.06.2009;001118.58;2548781.70;6183410.20; 0.14700;108.55;P;109.11; -0.38;109.10; 0.38;108.91; -4.00;108.68; 4.00; 0.00; ;
06.06.2009;001127.49;2548782.42;6183410.90; 0.14800;108.65;P;109.26; -0.38;109.28; 0.38;109.04; -4.00;108.87; 4.00; 0.00; ;
06.06.2009;001138.16;2548783.09;6183411.64; 0.14900;108.53;P;109.18; -0.38;109.18; 0.38;108.99; -4.00;108.74; 4.00; 0.00; ;
Eiva Rlx
The Eiva Rlx Route Format
Geoconsult POI
The Geoconsult POI Route Format
Eiva Rln
The Eiva Rln Route Format
Kp(m)/Easting/Northing/[Description] Comma Delimited
The Kp(m)/Easting/Northing/[Description] Route Format consists of a comma delimited file in the format Kp in metres, Easting, Northing, Description (Optional). The File should define the Route as a Series of Straight point to point segments. The Kp value of each point is assigned to the appropriate polyline vertex and enables Interpolated Kp calculation to be used with AutoChart. If the optional Description Field is included, then this information is attached to each vertex in the polyline and can be used to name/label Alter Course points etc. along the Route.
Kp/Easting/Northing/[Description] Comma Delimited
The Kp/Easting/Northing/[Description] Route Format consists of a comma delimited file in the format Kp in kilometres, Easting, Northing, Description (Optional). The File should define the Route as a Series of Straight point to point segments. The Kp value of each point is assigned to the appropriate polyline vertex and enables Interpolated Kp calculation to be used with AutoChart. If the optional Description Field is included, then this information is attached to each vertex in the polyline and can be used to name/label Alter Course points etc. along the Route.
Kp/Lat/Long/[Description] Comma Delimited
The Kp/Lat/Long/[Description] Route Format consists of a comma delimited file in the format Kp in kilometres, Latitude, Longitude, Description (Optional). The File should define the Route as a Series of Straight point to point segments. The Kp value of each point is assigned to the appropriate polyline vertex and enables Interpolated Kp calculation to be used with AutoChart. If the optional Description Field is included, then this information is attached to each vertex in the polyline and can be used to name/label Alter Course points etc. along the Route. The Latitude and Longitude values can be read from most common formats (Decimal Degrees, Degrees & Minutes, Degrees Minutes Seconds) with appropriate separators (symbols, spaces, etc.)
Lat/Long/[Description] Comma Delimited
The Lat/Long/[Description] Route Format consists of a comma delimited file in the format Latitude, Longitude, Description (Optional). The File should define the Route as a Series of Straight point to point segments. If the optional Description Field is included, then this information is attached to each vertex in the polyline and can be used to name/label Alter Course points etc. along the Route. The Latitude and Longitude values can be read from most common formats (Decimal Degrees, Degrees & Minutes, Degrees Minutes Seconds) with appropriate separators (symbols, spaces, etc.)
Pisys TPDS Ver 2
See TPDS Version 2 (Processed Format) Cross Profile File in the Cross Profile Formats Section.
Pisys TPDS Ver 3
See TPDS Version 3 Cross Profile File in the Cross Profile Formats Section.
QPS Survey Line
The QPS Survey Line Route Format
VisualWorks XP.csv
See VisualWorks XP.csv Cross Profile File in the Cross Profile Formats Section. The Route Polyline is created along the As-Found Top of Pipe position from the processed Cross Profile Markers.
VisualWorks Sail Line
The VisualWorks Sail Line File Format is a comma delimited file with records are terminated with a CRLF. The format must contain a header record to define the column contents. This should be:
* Type, Easting, Northing, Kp
The data records must be ordered in ascending KP order. The Easting Northing and KP columns contain decimal number values, the number of decimals can vary.
The 'Type' column has the following options:
* 0 - Specifies as end of a straight line segment.
* 1 - Specifies the centre of an arc in a clockwise direction.
* 2 - Specifies the centre of an arc in an anti-clockwise direction.
Data Example
Type,Easting,Northing,KP
0,500000,6300000,0
0,500000,6300500,0.5
1,500500,6301000,1.285
0,501000,6301000,1.785
2,502000,6302000,3.355
WinFrog Pts
The WinFrog Pts File Format
WinFrog Pts with TPs
The WinFrog Pts with TPs File Format is stored as ASCII, free formatted, comma-delimited fields as follows.
Field Data Format Comment
1 Type 1 Survey Line point record
2 SOL Lat [-]f.dddddddddd Latitude of point, decimal of degrees
3 SOL Lon [-]f.dddddddddd Longitude of point, decimal of degrees
4 Depth [-]f.ddd Depth of Point1
5 Radius [-]f.ddd Radius of Curvature1
6 Northing [-]d.dd Grid Northing of Point2
7 Easting [-]d.dd Grid Easting of Point2
8 KP f.ddd Kilometer Post value (m)
The SOL coordinates are the EOL for the Previous Segment.
1 Units are included in field and are based upon selected distance units and the number of decimal places specified for the same, default is metres.
2 Units are not included in the field and are based upon Map Projection units, default is metres.