I guess you are looking for a way to group and sum your information. This
can be done very easy using SQL:
Select DIAMETER, Sum(CartesianObjectLen(OBJ, "ft"))
From PIPES
Group By DIAMETER
Order By DIAMETER
This query will return the total length of the pipes for each diameter you
have. The result will also be ordered by the diameter
HTH,
Peter Horsb�ll M�ller
GIS Developer
Geographical Information & IT
COWI A/S
Rug�rdsvej 55
DK-5000 Odense
Denmark
Tel +45 6313 5013
Direct +45 6313 5008
Mob +45 5156 1045
Fax +45 6313 5090
E-mail [EMAIL PROTECTED]
http://www.cowi.dk
> -----Original Message-----
> From: Daryl Riggins [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 30, 2003 8:08 PM
> To: [EMAIL PROTECTED]
> 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: 8971
