Skip to main content

Adding KP signage to cable/pipeline data in QGIS

There is no standard way of adding KP signage to polylines, to do so in GRIDit KP values need to be embedded as measure (M) field to a 3D line (XYZ CSV file) representing cable/pipeline routes. A QGIS Plugin (XYZKP to 3D Line Plugin) has been built by Periplus Solutions to be used in QGIS for this purpose.

 

The Plugin can be installed from ZIP (QGIS-Plugin-to-create-Routes.zip). The tool will create a single layer GeoPackage (.gpkg) that can be used to create a layer in GRIDit.

1. Install QGIS Plugin
  1. Download the zip from this link.
  2. Extract the zip to you computer. Within the zip is another zip xyzkp_to_3d_line_plugin.zip
  3. Open QGIS Go to Plugins → Manage and Install Plugins…
  4. Click the button “Install from ZIP”: You’ll find it in the lower-left corner
  5. Select the ZIP file: Choose: xyzkp_to_3d_line_Plugin
  6. Click “Install Plugin”: QGIS will unpack it and install it.
  7. Activate the Plugin: After installation, ensure the checkbox is enabled

1 - Installed plugins.png

2. Run the plug-in

To add the plug-in to the toolbar: Menu bar / Plugins / Periplus / GRIDit → XYZKP to 3D Line incl. KP

2 - add tool to toolbar.png

 

To open the tool: Select ot from the toolbar:

3 - access the tool.png

3. Add the KP distance to cable/pipeline

The input CSV for the QGIS Plugin needs to be formatted as shown below. In this CSV the start of a cable route is defined in a 1  meter intervals. Reducing the interval will give more details on the actual position of the pipeline/cable. It is advised to use ‘name’ as attribute containing the cable name. If this is not the case the correct attribute name containing the name needs to be configured in GRIDit after creating the layer.

4 - CSV input.png

 

The attribute (or field-) names may vary, as they can be selected from the pull-down menu in the interface of the Plugin. The Plugin will be automatically populated with the expected fields, however the user can adjust the input parameters by choosing another attribute name from the pull-down menu. The user can also set the desired EPSG code.

5 - tool dialog.png

4. Create GeoPackage (.gpkg) for import into GRIDit

Run the script. The result is written to a GeoPackage (.gpkg). This dataset can be uploaded into GRIDit (see Add a Layer documentation). Set the object type of your layer to “Project cable/pipeline with depth”. This way the data will become available for the Profile and Burial Assessment tools in GRIDit.

6 - object type.png

 

Data is shown in the Profile tool in GRIDit.

7 - profile tool.png

5. Additional attributes

Additional attributes from an external table, such as cable characteristics, can be joined to the GeoPackage dataset in QGIS. The additional attributes will become available in GRIDit and can be viewed in the attribute table and info panel.

Back to top