I have a series of natural gas service lines with three variables – pipe size, pipe material and decade of installation. The beginning and endpoint of the line are the tee and meter respectively. There can be anywhere from one to as many as five different variations per service line of the size, material and installation decade from the tee to the meter.
In order to complete a report, I need to determine which is the predominant segment of pipe of each service line. In other words, if there happens to be two segments of a 100’ service line between the tee and the meter with different characteristics, segment A is 52’ in length and segment B is 48’, segment A becomes the predominant segment because if its majority length. Characteristics of segment A are submitted for that service line in the report.
We have close to 10,000 service lines in our system and this report is submitted annually. I am looking of a way to report this information relatively fast with consistency and accuracy.