How about converting your roads to buffers and using the ProportionOverlap() to determine how big a part are overlapping ?
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 COWI GIS konference afvikles i dagene d. 2.-3. september. Se yderligere oplysninger p� www.cowi.dk/Div04/Profiles/nyheder.asp > -----Original Message----- > From: Ben Crane [mailto:[EMAIL PROTECTED] > Sent: Friday, July 04, 2003 8:25 AM > To: [EMAIL PROTECTED] > Subject: MI-L Re: Majority contain SQL? > > > Hi all, > > Anyone know how to do a SQL statement that looks for > the majority of an object within another? I have a > table of road segments, and a table of highway extents > (adopted highway). I need to check whether the road > segments just intersect (and therefore are not adopted > highway) and those where the bulk of the road segment > object is within the adopted highway table. > > I can't use contain entire or contain part since even > the slightest touch counts...I'm looking for a > function that deems the majority of an object is > within another (say 50% plus)? > > Ben > > __________________________________ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | > www.directionsmag.com | To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > Message number: 7493 > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7494
