Skip to Main Content
Autodesk
Status Gathering support
Product Info360 Asset
Created by Martha Nunez
Created on Oct 23, 2024

Rehab query for comparison of survey length vs total pipe length (as a %)

This is to determine what percentage of the pipe was surveyed and identify potential abandoned surveys where the 'MSA' code was not coded. This query exists in InfoAsset Planner.

  • Attach files
  • Admin
    Martha Nunez
    Reply
    |
    Oct 31, 2024

    Yes Tony, I renamed the query for more clarity.

  • Admin
    Tony Andrews
    Reply
    |
    Oct 31, 2024

    @Martha Nunez @Guest Where do you see this implemented? On the main map, or inspections table? I think you are looking for a validation report that selects all the inspections that are not full pipe length with a +- 5% (or whatever) of the pipe length. So for a pipe that is 100ft and the CCTV inspection is 94ft this would be identified as a potential abandoned survey?

    Can this be achieved when we have implemented the request to be able to compare the values from two different record types in the rehab query logic?