Hi all,
I have mapped a points layer.
I would like to select those records where there is more than 10 points within a radius of .5km.
I'm having trouble even starting on this one! Can anyone provide some guidance/thoughts?
Thanks
Christine
-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Spencer Simpson
Sent: Wed 6/21/2006 11:34 AM
To: 'Alan Silvester'; mapinfo-l@lists.directionsmag.com
Subject: RE: [MI-L] Creating a line from a series of points
I think we need to know a little more about the table, such as:
1. Are there columns specifying X and Y, or formulas, or a point object
you can derive X and Y Coordinates from?
2. Is there a column specifying the order that a point appears in the
polyline?
3. 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.
A. Sort by (select statement with order by clause) polyline specifier
and order specifier
B. 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)
C. 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: mapinfo-l@lists.directionsmag.com
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.
Copyright in documents created by or on behalf of this company remains
vested in the company and we assert our moral rights, unless terms
provide otherwise.
_______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l