At 06:40 PM 04/22/1999 +0200, Christoph Ebner von Eschenbach wrote:
>Sorry, if this is a frequently asked question, but I did not find an
>answer to this problem on MapInfo-L yet.
>
>I have a table with lines/polylines, which intersects a table with region
>objects and I want to calculate the length of the intersection.
>
>When I execute statements like
>'Select Overlap(Polylines.obj, Regions.obj) from Polylines,Regions where
>Polylines.OBJ intersects Regions.OBJ Into NewTable', MapInfo selects the
>WHOLE length of these lines, which intersect regions. But since I'm only
>interested in the intersecting part, I cannot use the ObjectLen-Statement
>afterwards to get the intersecting length.
This seemed to do what you asked on a simple map set I made.
Select objectlen(overlap(lines.Obj,regions.Obj),"mi") from lines, regions
where lines.Obj intersects regions.Obj into Temp
Browse * from Temp
Steve Wallace
GIS & Market Information Manager
Florida Farm Bureau Insurance Companies
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
