Rajeev, Thank you for your help, it works. I appreciate the time and effort. Rajeev saraf wrote: > 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.
