Maybe this select will improve the hit rate - if it is supported by MapInfo ;-)
Select *
From POINTTAB, LINETAB
Where Buffer(POINTTAB.OBJ, 12, 1, "m") Intersects LINETAB.OBJ
What it should do is add a buffer to the points so that the change of the
points intersecting a line is better.
I use a buffer of 1 meter. Maybe you need to make is smaller or bigger
depending on the accuracy of your data
As I said, I haven't tried it myself, so please let me know whether it actually
does work
Peter Horsb�ll M�ller
GIS Developer
Geographical Information & IT
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 08, 2005 6:19 PM
To: [email protected]
Subject: MI-L Joining point and line data
Is there a way to join point data and line data. The
point data falls on the line data(road)
I tried doing a spatial join using an intersect but i
lost alot of point data.
Also, there is no common field between the 2 tables.
Thanks
__________________________________
Yahoo! Messenger
Show us what our next emoticon should look like. Join the fun.
http://www.advision.webevents.yahoo.com/emoticontest
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16019
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16022
