How to find the nearest line from a point

596 views
Skip to first unread message

Rahul

unread,
Jul 2, 2009, 12:11:50 AM7/2/09
to mapi...@googlegroups.com
hi All,
 
I want to find the nearest line/polyline feature with any point feature. The idea is that to update the attributes in point feature with the attibutes of line feature.
Any one have idea about this, please help asap.
 
Thanks
--
Rahul
GIS Developer

Steve Smith

unread,
Jul 2, 2009, 12:33:01 AM7/2/09
to mapi...@googlegroups.com

I would test the nearest command to see if it gives you the desired result.

The process goes something like;
1) Build an empty table for the results (select * from LineTab where rowid = 0 into ResultTab NoSelect & save & open ResultTab)
2) NEAREST 30 FROM TABLE LineTab TO PointTab INTO ResultTab TYPE Spherical IGNORE MAX 150 UNITS"m"
DATA Col1=Col1Als,Col2=Col2Als,Col3=Col3Als

You can look at your result table in a map window to determine what is happening after the nearest command does its thing. Sorting your Result table by line length may also be useful.

If the nearest command does not work then try buffers of the points and lines partly within the buffers. I suspect it will be many times slower than the nearest command.


Regards

Steve Smith
Australian Bureau of Statistics (ABS)
Post: Locked Bag 10 Belconnen ACT 2616
Location: ABS House, 45 Benjamin Way, Belconnen ACT 2617
Geography / Spatial Data Management and Research
ABS Level 2 South 232 , Wk: (02) 6252-6824
wk email: steve...@abs.gov.au


Inactive hide details for Rahul ---02/07/2009 02:12:40 PM---hi All, I want to find the nearest line/polyline feature with any pRahul ---02/07/2009 02:12:40 PM---hi All, I want to find the nearest line/polyline feature with any point feature. The


From:

Rahul <rahul...@gmail.com>

To:

mapi...@googlegroups.com

Date:

02/07/2009 02:12 PM

Subject:

[MI-L] How to find the nearest line from a point

Sent by:

mapi...@googlegroups.com

------------------------------------------------------------------------------------------------

Free publications and statistics available on www.abs.gov.au

 

Bonwick, Vicky

unread,
Jul 2, 2009, 12:54:12 AM7/2/09
to mapi...@googlegroups.com
Rahul,
Try the Distance Calculator tool from the Tool Manager.  I had to do a similar thing once and it did the trick.
Vicky
 
Vicky Bonwick
GIS Administrator
Glenorchy City Council
Ph:  (03) 6216 6719
mailto:vbon...@gcc.tas.gov.au


From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On Behalf Of Rahul
Sent: Thursday, 2 July 2009 2:12 PM
To: mapi...@googlegroups.com
Subject: [MI-L] How to find the nearest line from a point

This message was scanned by ESVA and is believed to be clean.
Click here to report this message as spam (within GCC offices only).

______________________________________________________________________
This communication and any files transmitted with it are intended for the named
addressee, are confidential in nature and may contain legally privileged
information. The copying or distribution of this communication or any
information it contains, by anyone other than the addressee or the person
responsible for delivering this communication to the intended addressee, is
prohibited. If you receive this communication in error, please advise us by
reply email or telephone on +61 3 6216 6700, then delete the communication. You
will be reimbursed for reasonable costs incurred in notifying us.
______________________________________________________________________

Rahul

unread,
Jul 3, 2009, 11:59:34 PM7/3/09
to mapi...@googlegroups.com
Yes, NEAREST command is great, i fecthed the desired result by using this one.
Thanks much.

Regards,
Rahul Srivastava
Reply all
Reply to author
Forward
0 new messages