AnsweredAssumed Answered

Connecting information of elements of one layer to elements of an other layer

Question asked by griessie on Jan 23, 2015
Latest reply on Jan 28, 2015 by tkowal

Hallo dears,


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)