total line length of pipe

2690
3
11-04-2014 06:31 AM
MikeHenson
Occasional Contributor

Working in my sewer map, I have lines of pipe with attributes of diameter, and material.  I know how to query size and type of pipe, but I am needing to get the length of say all 6" pipe. How would a guy do that? Thanks for any help you can give.

 

MKH

0 Kudos
3 Replies
JakeSkinner
Esri Esteemed Contributor

Hi Mike,

If your data is in a geodatabase, you should automatically have a field called 'Shape_Length'.  You can select all 6" pipes, then right-click on this field > Statistics.  One of the statistics returned is 'Sum'.

0 Kudos
MikeHenson
Occasional Contributor

thanks Jake, but this is a shape file, not a geodatabase. Any suggestions?

0 Kudos
JakeSkinner
Esri Esteemed Contributor

I would recommend importing the data into a geodatabase.  You get much more functionality with your data.

If you are unable to do this, you can perform the following steps:

1.  Open the attribute table

2.  Add a field of type 'Double'

3.  Right-click on the Field > Calculate Geometry

4.  Change the 'Property' to Length

This will calculate the length of each line.