Evan
I think I have worked out your problem
This is what I would do
Copy your point layer to the cosmetic layer make cosmetic editable
Select all point in the cosmetic layer and put a 150ft buffer around each
point
Save the cosmetic layer as a table eg 150ftbuffer.tab
NOTE the saved table will contain both buffer and point objs.
MI will open the new table for you
In the SQL select
Select Colums *
From Tables: 150ftbuffer, boundary
Where Condition 150ftbuffer.Obj Intersects
boundary.Obj
You have the option of saving the SQL Query
Helpful if you use the query a lot
Best of luck
Regards
Andrew Hare
GIS Officer
Waimate District Council
PO Box 122
Waimate
New Zealand
Ph: (64 3) 689 8079 Fax: (64 3) 689 8075
-----Original Message-----
From: Macdougall, Evan 1065 [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 5:05 AM
To: 'MapInfo-L'
Subject: MI-L Buffer Query
This message is in MIME format. Since your mail reader does not
understand
this format, some or all of this message may not be legible.
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.
