Prepare Asset Data for Import

Before you import data into Info360 Asset, it is important to ensure that the data is quality assured and meets all the requirements; once imported there are limited opportunities to correct the data.

The reliability of results from risk models and rehabilitation decision trees is also dependent on the quality of data that is used.

Asset data refers to GIS layers that contain assets such as pipes or manholes.

You can import asset data via local GeoJSON files of up to 500 MB, via Shapefiles, or via an integration with ArcGIS Online.

Important: Ensure your data are in the WGS84 / EPSG4326 coordinate system before you import.

If using Shapefiles, the local coordinate system will be re-projected to the WGS84 system by Info360 Asset.

Pipe GIS layers

The following fields are required for pipe layers:

• Asset ID
• Upstream Manhole ID
• Downstream Manhole ID
• Length

If you have segmented pipes, a Segment ID is also required (see below).

Asset ID

Each pipe asset must have one unique Asset ID.

• The Asset ID is used to identify a pipe asset and to associate any custom table data (e.g., data from your CMMS, hydraulic model, etc.) to the asset.
• Check that there are no duplicate asset IDs in your data. Duplicates will be ignored and not imported.
• If you have more than one ID field per asset in your GIS, you must select which to use.

  You must then use the same ID when importing any associated data (custom tables) so that it gets associated to the asset.

Upstream and Downstream Manhole IDs

Pipe layers must include the upstream and downstream manhole IDs.

• Info360 Asset uses the upstream and downstream manhole IDs specified in the pipe GIS layer to associate CCTV inspections to the pipe.
• It also uses the manhole IDs to calculate the geometry of CCTV inspections and determine the location of the observations along the pipe.
• Map these to usNodeId and dsNodeId respectively when importing the pipe layer.

Length

Make sure the units are correct for your pipe length.

• When mapping fields in Info360 Asset, make sure to select the correct unit. That is, if the value in your GIS layer is in feet, then change the Source Unit to feet.
• The length and geometry of the pipe asset are used to geocode CCTV pipeline observations and to locate them along the pipe.
• For some inspection standards, the length is also used in the calculation of condition ratings.

Segmented pipes

Check if any of your pipes are divided into multiple segments. If they are, see Import Segmented Pipes for information on how to handle these. If they are not, do not map anything to the Segment ID when importing.

Manhole GIS layers

The Asset ID is the only required field for manhole layers.

Asset ID

For inspections to be associated correctly to the asset, the asset ID in the GIS layer needs to match the manhole number in the inspection database.