you can try this query: select zipfile.zipcode,street.class,sum(street.length) from zipfile,street where zipfile.obj contains street.obj group by zipfile.zipcode,street.class i have not tried this query. if this does not work then break the query into two parts: select zipfile.zipcode,street.class,street.length from zipfile,street where zipfile.obj contains street.obj into tempTable select code,class,sum(length) from tempTable group by code,class. this however is not 100% accurate. A road segment will get included in the zipcode if the centroid of that segment falls within that zipcode. if your segment sizes are small, then your error will be small. if your segments are large, then your error wouls also be large. bye. -- Rajeev saraf manchitra services ----- Original Message ----- From: "Saadat U Khan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 23, 2001 2:20 AM Subject: MI-L to find the length of streets in a zipcode boundries > > Need help any one knows how to calculate the length of the street by > class in a zip code boundries. > > Street file has Class and Length of each street. > > I want run a program that can calculate the total length of the streets > by Class in each zip code boundries. > > Thanks > > > > _______________________________________________________________________ > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, send e-mail to [EMAIL PROTECTED] and > put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
