I ran up against my limits so I need some help and I hope I'm right here.
I have some segments painted (streets) in a map. This is my first layer. In a second layer are some accidents. I imported them (the coordinates were given in several columns) from an excel-table. In another column of the excel-table is the accident-ID (Un-Key … please have a look to the attachment).
Now it is necessary for me, to know which accidents are on which segment. So at its best, I need the accident-IDs in the Attribute Table of the streets. Therefor I add 15 further columns to the Attribute Table of the streets (for 15 potential accidents within a segment). But know I don’t know if it is possible and how it is realizable to connect the accidents to the Attribute Table of the street-segment-layer. Of course, I can’t insert the IDs by hand (I am 32 years old and I won’t do it for the rest of my life)
I would be very thankful if anyone has an idea to solve my problem.
I attached the files of my project in an zip-file and. I hope It will helps you.
If you need any further information please feel free to ask me.
Thanks by now!!!!!
p.s. using ESRI ArcMap 10.0. (Win 7, 32 Bit)