Try this:
This SQL select statement should select all street objects from Streets
table that are inside each zipcode region of the Zipcode boundary table
accounting for the overlap. Then, provide a sum of the object lengths in
miles for all streets in each zipcode boundary by class.
Select Zipcodes.ZIP, Streets.Class, Sum(ObjectLen(OverLap(Streets.obj,
Zipcodes.obj), "mi")) from Zipcodes, Streets where Zipcodes.Obj intersects
Streets.Obj group by Streets.Class into Selection
Browse * From Selection
Regards,
-Bill
Mail List:[EMAIL PROTECTED]
From: "Saadat U Khan" <[EMAIL PROTECTED]> on
05/22/2001 04:50 PM AST
To: [EMAIL PROTECTED]
cc:
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.
