The Linear Reference System survey import option is only available in InfoAsset Planner version 2019.3 and above. This survey import option may be used for non-standard and generic surveys for any facility type in any InfoAsset Planner network type. When creating a new survey for a linear feature other than gravity mains, the Linear Reference System import option will be the only option available. 

  1.  To create a survey import follow the same initial steps as with any CCTV import. Give the survey a unique ID. Note that survey IDs need to be unique within the InfoAsset Planner database regardless of the facility type.                          

       2. Choose the Tables specified in next step option under the Import From section. Existing Survey's may be imported as well.         

       3.  A generic survey import window will appear. The import process is similar to other survey import types in InfoAsset Planner. As seen below the tables Inspections, Conditions, Media_Inspections, and Media_Conditions are available within the database to be populated with the user's raw data. However, the tables for Linear Reference System surveys have been structured to be generic and allow any type of survey to be imported as long as the required System Fields are populated.

The mandatory fields (highlighted in red) for importing surveys are the same mandatory fields for any other type of survey import in InfoAsset Planner. Alternatively, the Linear Reference System import tool uses additional fields to match a survey with a linear facility besides Start Node and End Node (1), and Pipe Segment Reference (2). If a survey has end point GPS latitude and longitude (3) information for a line segment, the survey will be assigned to the line segment even when information for fields 1 and 2 is not available. During the import, InfoAsset Planner will check for information in the following order:

  1. Start Node ID and End Node ID: Similar to standard CCTV surveys, the end point IDs need to be mapped as Manhole facility type. For pressurized mains the end point IDs need to be Fitting facility type 
  2. Line Segment Reference: If end point IDs are not available, the survey will be associated to the facility based on the line segment unique ID.
  3. Start and End Latitude and Longitude: This option is only available within the Linear Reference System import type. Regardless of the end point feature type, the inspections will be mapped based on coordinate information for the end points. Each end point will need a latitude and longitude field associated with it's location.

Importing surveys with coordinate data:  

When coordinate data for the start and end locations for an inspection is available, the inspection can be imported and assigned to any linear facility that is along the length of the inspection. Coordinates must be in the form of latitude and longitude that correlates with the WSG 1984 coordinate system. 

Even when end point features and/or end point IDs are not available, the coordinate data should be sufficient to assign the inspection to linear facilities. This feature is useful for linear facilities that do not have end point features associated to them (e.g., roads), or when the end point feature class is from a facility type other than manholes (for gravity mains), or fittings (for pressurized mains in the water network). As seen below, with the Linear Reference System tool, inspections that span over the length of several linear facilities can be imported and mapped to all facilities.

The inspection will be split into several inspections (one for each linear facility) and the original inspection ID will be available if it was mapped during import. A 'Split' field was added to identify all inspections that have been split during import with a value of 'Yes' assigned to them.

After running the Survey Analysis wizard, the conditions will be geocoded using the same method as with other types of survey.

Note that for surveys that span over the length of several linear facilities, if the end point IDs are available they will be mapped the same way as specified above. Again, this only applies if the end points are either manholes for gravity mains, or fittings for pressurized mains.

Importing conditions as feature classes:

With the Linear Reference System import type, condition data can come in the form of feature classes. The conditions will be assigned to the linear facility that it is closest to. Condition feature classes can be either line feature types (continuous defects), or point feature types (point defects). 

The same mapping procedure for any other survey import is followed. Both the Inspection and Conditions tables must be populated within the project database. The feature class is selected under the Conditions 'Select a table' option. As seen below, the Condition ID and the Inspection ID are mandatory. The Observation Code System Field corresponds to the Code name that InfoAsset Planner will use in lieu of standard inspection codes (e.g., NASSCO PACP codes).

After the Survey Analysis wizard is ran, the conditions will be geocoded with their respective scores and rehab methods. Note that as opposed to the scoring methodology used during PACP survey imports, the Linear Reference System import tool does not calculate scores such as mean, peak, quick scores etc. However, if the condition scores are available and mapped as shown above, the scores from the raw data will be assigned and displayed in InfoAsset Planner.

Note that the Start and End Distance for the continuous defects are populated after import:

Note that prior to running the Survey Analysis wizard, the user may assign Rehab Methods to each condition to generate the Draft Rehab in step 4. For more information on Draft Rehab and costs for Linear Reference System please go to Linear Reference System Defect Codes