topic Re: Joining Data with duplicate records.... in Geoprocessing Questions

Joining Data with duplicate records....

BrianKeller__GISP — Fri, 05 Aug 2011 15:59:10 GMT

Im attempting to join a list of addresses from our local police department with an address point layer. The excel spreadsheet given to me, has an address field, and a description field. There are several locations where multiple incidents have occurred, my problem occurs when I try to join the two tables based on the addresses. Arcmap will only join the first matching record, then drop any subsequent duplicates. Is there another way to go about doing this so I can represent those locations that have had multiple incidents?

Thanks,

-Brian
ArcEditor 10

Re: Joining Data with duplicate records....

DanPatterson_Retired — Fri, 05 Aug 2011 17:03:19 GMT

A "many-to-one" is called a relate in Arc-parlance...check the help files
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//005s0000002n000000.htm

Re: Joining Data with duplicate records....

BrianKeller__GISP — Fri, 05 Aug 2011 18:28:05 GMT

A "many-to-one" is called a relate in Arc-parlance...check the help files
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//005s0000002n000000.htm

Thanks!

Is there no way to create symbology based on the attributes of the related table?

Re: Joining Data with duplicate records....

DaleHoneycutt — Fri, 05 Aug 2011 23:14:22 GMT

Whenever I've got a 1:M, M:1, or M:M join situation, I end up using the Make Query Table tool. It creates a new table (or feature class, if you include the shape field in your output). It's a very powerful tool, but overwhelming at first, so experiment on a small subset of your records and paw through the output to make sure you're getting exactly what you want (I almost always do this, and I'm supposed to know this stuff.)