RE: [MI-L] Updating column with number of objects nearest apolyline...

2006-04-29 Thread Peter Horsbøll Møller
Of Spencer Simpson Sent: Friday, April 28, 2006 2:51 PM To: [EMAIL PROTECTED]; 'Paul Donnelly' Cc: mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] Updating column with number of objects nearest apolyline... Line-based Voronoi polygons would be nice, wouldn't they? There's

RE: [MI-L] Updating column with number of objects nearest apolyline...

2006-04-28 Thread Spencer Simpson
D] On Behalf Of Lars I. Nielsen (GisPro) Sent: Thursday, April 27, 2006 4:48 PM To: Paul Donnelly Cc: mapinfo-l@lists.directionsmag.com Subject: Re: [MI-L] Updating column with number of objects nearest apolyline... Hi Poul, Would a feasible way not be to "explode" your polylines to no

Re: [MI-L] Updating column with number of objects nearest a polyline...

2006-04-27 Thread Lars I. Nielsen (GisPro)
Title: Updating column with number of objects nearest a polyline... Hi Poul, Would a feasible way not be to "explode" your polylines to node point objects, and generate voronoi polygons around these points ? Preserving some sort of "polyline ID" for each polygon. That way you could find the p

[MI-L] Updating column with number of objects nearest a polyline...

2006-04-27 Thread Paul Donnelly
Title: Updating column with number of objects nearest a polyline... Hello all! Was wondering if anyone can help me out with a little problem I need help in solving? Basically, I have two MapInfo tables - One table containing polylines representing road networks, and a second table containin

RE: MI - L Updating Column With Number Sequence

2005-05-11 Thread Eagle, David A
" + rowid, but the first is probably more appropriate. Cheers, Dave -Original Message- From: John Nott [mailto:[EMAIL PROTECTED] Sent: 11 May 2005 09:45 To: mapinfo-l@lists.directionsmag.com Subject: MI - L Updating Column With Number Sequence Hello All, I have a table of ab

MI - L Updating Column With Number Sequence

2005-05-11 Thread John Nott
Hello All, I have a table of about 500,000 entries which I need to get into excel for editing as my access skills aren't what they should be. Unfortunately excel will only take 65,000 or so. Is there anyway in MI that I can automatically add a new column with an ID for each row i.e 1 - 500,000

RE: MI-L RE : MI-L Updating column with pen style

2004-08-26 Thread Woody Woodruff
it our web site at http://www.geocities.com/ctuzoning/index.htm -Original Message- From: Simon Roy [mailto:[EMAIL PROTECTED] Sent: August 24, 2004 13:35 To: Mapinfo-L Subject: MI-L RE : MI-L Updating column with pen style Thanks to all! ObjectInfo(obj,2) works just fine. Where can I get

MI-L RE : MI-L Updating column with pen style

2004-08-24 Thread Simon Roy
Thanks to all! ObjectInfo(obj,2) works just fine. Where can I get a list of all possible values for ObjectInfo and ObjectGeography? Thanks again Simon - List hosting provided by Directions Magazine | www.directionsmag.com |

RE: MI-L Updating column with pen style

2004-08-24 Thread Spencer Simpson
e str$(obj)=any("Line","Polyline","Arc") and update the query. The strings are case-sensitive. HTH Spencer -Original Message- From: Simon Roy [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 11:46 AM To: Mapinfo-L Subject: MI-L Updating column with

MI-L Updating column with pen style

2004-08-24 Thread Simon Roy
Hi, is it possible to update a column from a line table with the Pen Style of each line? Ex.: Pen (15, 2, 3618610) Thank you Simon

RE: MI-L Updating Column using 2 other columns for the reference

2003-08-07 Thread Woody Woodruff
TED] Sent: Wednesday, June 18, 2003 19:48 To: [EMAIL PROTECTED] Subject: MI-L Updating Column using 2 other columns for the reference Hello, Need a bit of assistance updating a MI table. I have the need to update Column "D" of table 1 with the data from Column "D" from table

MI-L Updating Column using 2 other columns for the reference

2003-06-18 Thread Leighton Tong
Hello, Need a bit of assistance updating a MI table. I have the need to update Column "D" of table 1 with the data from Column "D" from table 2. The twist here is that I need update the data based on 2 columns matching on both tables. Since there are no other unique identifiers, the data in C

MI-L Updating Column solution

2002-01-15 Thread Dan_Page
Thanks for all who responded. Solution was to do a query and select the records in table A that match in table B and then do an Update Column on the selection. Just a note: I usually unselect the "Browser Results" box and just have the original browser table open when I do an update and I usua

MI-L Updating Column

2002-01-15 Thread Dan_Page
I have two tables. Table A has 300 records. Table B basically contains same information as Table A except it has updated information in one of the fields (field X) and only contains 100 records that were updated, the remaining 200 records in Table A were not updated and are not included in Table

MI-L updating column

2001-10-01 Thread christian . cattaneo
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. Dear all I have a table with polygons as surfaces. I would like to update the centroids of these surfaces, their X- and Y-Coordinates to create = points afterw

RE: MI-L Updating column with areas from another table - almost t here!

2000-11-01 Thread pel
5173 * [EMAIL PROTECTED] - 01-11-2000 13:30:30 Besvar venligst til [EMAIL PROTECTED] Til:[EMAIL PROTECTED] cc: (bcc: Peter Laulund/MI/KMS) Vedrørende:RE: MI-L Updating column with areas from another table - almost there! Thanks to Jacques Paris

RE: MI-L Updating column with areas from another table - almost there!

2000-11-01 Thread AYoung
Title: Re: MI-L Updating column with areas from another table - almost there! Thanks to Jacques Paris for the final piece of the jigsaw. The full expression for calculating the area of overlap of a number of small regions which overlap larger regions is:   Select proportionoverlap(small.Obj

Re: MI-L Updating column with areas from another table - almost there!

2000-11-01 Thread AYoung
Title: Re: MI-L Updating column with areas from another table - almost there! Thanks first of all to everyone who replied to my query. I almost have an answer that does what I want, thanks to Mike Hankins. Mike suggested using the following: Select proportionoverlap(small.Obj,large.Obj) from

Re: MI-L Updating column with areas from another table

2000-10-30 Thread Mike Hankins
ssage - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 30, 2000 9:50 AM Subject: MI-L Updating column with areas from another table Hello all, I have one table with a lot of small regions and one with two or three larger regions. I want to

MI-L Updating column with areas from another table

2000-10-30 Thread AYoung
Title: Updating column with areas from another table Hello all, I have one table with a lot of small regions and one with two or three larger regions. I want to update a column in the 'larger regions' table with the area of the smaller regions which are within the larger regions (are you wit