select diafeet,sum(objectlen(obj,"ft")) group by diafeet please note the "US-style" for diameter :-)
Regards Uffe ----- Original Message ----- From: "Daryl Riggins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 30, 2003 8:08 PM Subject: MI-L Report of Length of Lines and Polylines > I'm constructing a water system map. Objects are either line or > polyline. With each object, I have two fields: diameter and material. > I am attempting to determine the total length of water pipe in the map > with relation to the pipe diameter (e.g. total 2-inch pipe=10,000 FT). > Suggestions? > _________________________ > Daryl Riggins, PE > Camp Chestnut Ridge > www.campchestnutridge.org > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8972
