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 containing point objects representing the locations of road accidents.
I need a method of calculating the sum of accidents per road link. Previously I had buffered the polylines and then simply used the 'update column' function to sum up the number of objects within the buffer. The problem with this though was that where two polylines meet at a junction there was an overlap with the buffers and so when an accident point falls in this overlap it is double counted within both overlapping buffers. With small sections of road networks I simply edited the buffers to remove the overlap and then used the update column method. The problem now is that I have a lot of road newtork data and if I were to go round and remove each overlap for each individual section I'd still be here this time next year!
So, ideally I need a method of assigning accident points to a single road link which is nearest. Then I need to update a column within the link table to count the number of accidents assigned to each particular road section. Any help solving this problem would much appreciated!
Thanks in advance,
Paul Donnelly
Email: paul.donnelly@hyderconsulting.com
**********************************************************************
This message contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender and then delete the email and destroy any copies of it. Thank you.
Hyder cannot guarantee that this message or any attachment is virus-free or has not been intercepted or changed.
Any opinions or other information in this message that do not relate to the official business of the Company are neither given nor endorsed
by it.
**********************************************************************
_______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
