rkmcswain
2010-03-17, 04:57 PM
Starting with an empty drawing.
We import a shape file of lines and bring in the object data with it. The object data includes the size and length.
The goal is to generate a report showing the total length of these lines, based on the size stored in the object data.
I know I can run a query on this drawing and import the lines by size and then run another tool to give me the length of those lines, but we are wondering if we are overlooking something in Map that will create this report for us all in one step. We ran a Query Report, and was able to generate a file that includes the length of each pipe segment on separate lines, which could be imported into Excel for a total.... Is this as close as we can get?
We are kind of looking for something like this:
Size = 10", Length total = 1064 l.f.
Size = 15", Length total = 874 l.f.
Size = 21", Length total = 369 l.f.
We import a shape file of lines and bring in the object data with it. The object data includes the size and length.
The goal is to generate a report showing the total length of these lines, based on the size stored in the object data.
I know I can run a query on this drawing and import the lines by size and then run another tool to give me the length of those lines, but we are wondering if we are overlooking something in Map that will create this report for us all in one step. We ran a Query Report, and was able to generate a file that includes the length of each pipe segment on separate lines, which could be imported into Excel for a total.... Is this as close as we can get?
We are kind of looking for something like this:
Size = 10", Length total = 1064 l.f.
Size = 15", Length total = 874 l.f.
Size = 21", Length total = 369 l.f.