Skip to Main Content
Autodesk

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
      Drop here to upload
    • 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?