topic Representing Duplicate Geocoded Addresses in Data Management Questions

Representing Duplicate Geocoded Addresses

DavidDeMarco — Thu, 30 Jun 2011 20:34:03 GMT

Hello,

I am trying to geocode a table of addresses which contain many duplicates. This list of addresses is a list of emergency incidents over a period of time, and I would like the symbology to represent the number of times each address requested service. Is there a way to do this within the geocoding process or do I have to separately sort/count the incidents and map them as quantities in symbology?

Currently I get one geocoded point for an address that has 20+ representations in the dataset. I'd like to be able to weight that point more heavily so a person viewing the data can tell the difference between an address that requested service once vs. an address that had multiple requests.

Thanks!

Re: Representing Duplicate Geocoded Addresses

JoeBorgione — Thu, 30 Jun 2011 23:58:27 GMT

Hello,

I am trying to geocode a table of addresses which contain many duplicates. This list of addresses is a list of emergency incidents over a period of time, and I would like the symbology to represent the number of times each address requested service. Is there a way to do this within the geocoding process or do I have to separately sort/count the incidents and map them as quantities in symbology?

Currently I get one geocoded point for an address that has 20+ representations in the dataset. I'd like to be able to weight that point more heavily so a person viewing the data can tell the difference between an address that requested service once vs. an address that had multiple requests.

Thanks!

I think you'll want to do it before or after the actual geocoding process; what I suggest is creating a summary table. If you do it before the geocoding process, you'll only geocode a percentage of the overall incidents. If you summarize it after wards, obviously you'll geocode them all.

You could then symbolize them using the count attribute in the summary table.

Re: Representing Duplicate Geocoded Addresses

DavidDeMarco — Fri, 01 Jul 2011 00:49:32 GMT

Summary table... Thank you.

Re: Representing Duplicate Geocoded Addresses

RyanMiller — Mon, 05 Nov 2012 18:39:36 GMT

I am attempting to do something similar to this as well. Once you create the summary table, how do you use it to symbolize the points? In the table, I have the address field, and then another field for the count. Thanks!

Re: Representing Duplicate Geocoded Addresses

JoeBorgione — Mon, 05 Nov 2012 20:14:42 GMT

Try joining your summary table to your geocoding results attribute table.