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.
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.
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!
