RE: MI-L Creating Buffers

Peter Horsbï¿½ll Mï¿½ller Thu, 19 Dec 2002 00:09:36 -0800

Or even easier:

1. Make a copy of your table, if you want to keep the original point data as
well as your buffers
2. Open the copy, lets call it TABLECOPY
3. Open the MapBasic window
4. Enter the following text and hit ENTER afterwards:
        Update TABLECOPY Set OBJ = Buffer(OBJ, 12, 1000, "m")


Now your points have changed to regions, 12 is the resolution, 1000 is the
radius and "m" is the distance units.
This could of course also by "mi" or "ft" if you don't like the metric
system ;-)

Or even easier: Upgrade to MapInfo 7.0: The buffer function in MI 7.0 can do
the data aggregation when buffering !

Peter Horsbï¿½ll Mï¿½ller
GIS Developer
COWI A/S
Rugï¿½rdsvej 55
DK 5000 Odense C

Tel       +45 6313 5013
Direct    +45 6313 5008
Mobil     +45 2270 4308
Fax       +45 6313 5090    

Kampsax blev i juni 2002 overtaget af COWI. I forbindelse med den
igangvï¿½rende integrationsprocess udskiftes vores Kampsax e-mail adresser med
COWI e-mail adresser.Hjemmesideadresser forbliver uï¿½ndrede


> -----Original Message-----
> From: Kathy Tang [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, December 18, 2002 5:21 PM
> To: David Piner Cen-IT; [EMAIL PROTECTED]
> Subject: RE: MI-L Creating Buffers
> 
> 
> David:
> 
> 
> I recently wrote a routine to do this for cell site 
> locations. This is for point objects only. Can be modified 
> for other object types. Here is how it goes:
> 
> 1. Open your object table.
> 2. Create an empty mappable table based on the object table 
> coordinate system. This will be your buffer table. 3. 
> Determine the total number of records in your object table. 
> Select 1 record at a time and ... 4. Insert a new record into 
> the buffer table with whatever information you want from the 
> object table into your buffer table, including the buffer object.
> 
> This part of the code looks something like this, where Temp 
> is the name of the selection table (1 record), f_xcoord is 
> the X coordinate of the object and f_ycoord is the Y 
> coordinate of the object, i_resol is the variable which 
> stores the buffer resolution and f_radius is the buffer size. :
> 
> s_cmdstr = "Insert Into BufferTable (CellSite_Number, 
> CellSite_Location, obj)"+
>               "Values ("+Temp.col1+","+ Temp.col2+","+
>               " 
> Buffer(CreatePoint("+f_xcoord+","+f_ycoord+"),"+i_resol+","+f_
radius+","+
>               CHR$(34)+"km"+CHR$(34)+"))"
> 
> Run Command s_cmdstr
> 
> -----------------------------------------------------------------
> Let me know if you want the rest of the code. If you do not 
> have MapBasic, you can do a lot of "update columns" or 
> contact me and I can customize the code for your file.
> 
> Regards,
> 
> Katherine Tang
> GeoSolutions Consulting Inc.
> 38 Auriga Drive, Unit 3
> Ottawa, Ontario, Canada K2E 8A5
> 
> Toll free: 1-877-727-7563
> Ph: (613) 727-7563 ext. 402
> Fx: (613) 727-3210
> [EMAIL PROTECTED]
> 
http://www.geosolutions.com
http://mapinfo.geosolutions.com




-----Original Message-----
From: David Piner Cen-IT [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 10:48 AM
To: [EMAIL PROTECTED]
Subject: MI-L Creating Buffers


Hello all,
Does anybody know of a tool or a way to create buffers for each object from
a table and populate the created buffer with the data from the buffered
object.

Thanks in advance,
David Piner
Bournemouth Borough Council



**********************************************************************
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.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: 4603



---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 4607

---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 4623

RE: MI-L Creating Buffers

Reply via email to