There are several ways how to do it, one of them is: Issue following three statements in MapBasic window, one after another:
Set CoordSys Table line_tab
Select * From line_tab, poly_tab Where CreatePoint(ObjectGeography(line_tab.obj,1),ObjectGeography(line_tab.obj,2)) Within poly_tab.obj Into result
Browse from result
Substitute table names with real ones.
Jaromir Svasta
On 04 Nov 03 14:49:15 +0000, Andy Brumwell, GIS Researcher, Force CSB Lloyd House <[EMAIL PROTECTED]> wrote:
Colleagues
I have a set of lines (one start point and one end point) and a set of areas.
I need to know which areas the line originates in.
Is this possible using a standard SQL statement/table update column - or do I
need to write some form of MB script.
thanks in advance
Andy Brumwell GIS & Crime Mapping Unit West Midlands Police
Andy Brumwell external 0845 113 5000 ext 2771 internal 7800 2771
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9017
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9028
