RE: [MI-L] Creating a line from a series of points

Spencer Simpson Wed, 21 Jun 2006 11:36:49 -0700

I think we need to know a little more about the table, such as:

Are there columns specifying X and Y, or formulas, or a point object you can derive X and Y Coordinates from?
Is there a column specifying the order that a point appears in the polyline?
Is there more than one polyline? If so, is there a column specifying which polyline a row belongs to?

If so, then it’s possible to write a MapBasic application to chain the points together. Some of the other listers may have even written such applications.

Sort by (select statement with order by clause) polyline specifier and order specifier
Iterate through the result table. For each record:

if the line specifier changed, finish the current polyline (insert) and start a new one with the coordinates from current rec (Create Pline).

If not, add the coordinates from the current rec to the end of the current line. (Alter Object Add Node)

At the end, finish the current polyline.

Hope this helps

Spencer

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Silvester
Sent: Wednesday, June 21, 2006 11:30 AM
To: [email protected]
Subject: [MI-L] Creating a line from a series of points

Dear All,

Does anybody know how to automatically create a line from a series of points, i.e. rather than drawing a line from point to point, I want to be able to make a line that automatically joins up the points. The problem is, is that the next point to join up with the line may not be the next record in the table?! The points are however all 1km apart.

Does anyone have any ideas?

Regards,

Alan

Alan Silvester

GIS Manager

GroundSure Limited

Unit E, Level 7

New England House

Brighton

BN1 4GH

Tel: +44 (0)1273 819500 (Switchboard)

+44 (0)1273 647811 (Direct dial)

Email: [EMAIL PROTECTED]

This e-mail is private and confidential. Access by or disclosure to

anyone other than the intended recipient for any reason other than the

business purpose for which the message is intended, is unauthorised. If

you are not the intended recipient, you must not act or omit to take any

action based on this message. This e-mail and any views or opinions

contained in it are subject to any terms and conditions agreed between

GroundSure Limited and the recipient.

All reasonable precautions have been taken to ensure no viruses are

present in this e-mail. As GroundSure Limited cannot accept

responsibility for loss or damage arising from the use of this e-mail or

attachments we recommend that you subject these to your virus checking

procedures prior to use.

vested in the company and we assert our moral rights, unless terms

provide otherwise.

_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

RE: [MI-L] Creating a line from a series of points

Reply via email to