Hello Evan
Solve your problem like this:
1) Create a copy of your points table called Tpoint
2) Split the boundary table in two halves: In and Out
3) In a mapbasic window type: update Tpoint set obj=buffer(obj,100,150,"ft")
4) Select * from Tpoint, In where Tpoint.obj intersects In.obj into tmp1
5) Save tmp1 as Tpoint1 and open it.
6) Select * from Tpoint1, Out where Tpoint1.obj intersects Out.obj into tmp2
7) Save tmp2 as Tpoint2 and open it.
8) In a mapbasic window type: update Tpoint2 set obj=centroid(obj)
Tpoint2 should now hold the result.
Regards
Uffe Kousgaard
----- Original Message -----
From: "Macdougall, Evan 1065" <[EMAIL PROTECTED]>
To: "'MapInfo-L'" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 7:05 PM
Subject: MI-L Buffer Query
> Hello all,
> I have what I think should be a simple SQL query that I need to run,
> but I am not at all literate in SQL or MapBasic. Please let me know the
> quickest/easiest way to perform the following function in MapInfo.
>
> I have a point layer and a boundary layer. The boundary layer
> contains 2 different types of zones: IN and OUT. I want to run a query
that
> will select all objects in the point layer where any part of an IN zone
AND
> any part of an OUT zone fall within a 150 feet radius of the object. This
> sounds so simple to me, but I just don't know how to phrase this correctly
> in SQL or MapBasic. Thank you in advance for your assistance.
>
> -Evan MacDougall ([EMAIL PROTECTED])
> GIS Specialist
> ACE USA Flood Services
> (310)342-3600 / (800)736-3109
> "The biggest burden in my life is potential." - Calvin (Calvin & Hobbes)
>
>
>
> _______________________________________________________________________
> 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.
