topic Re: I am trying to aggregate and summarize zip code date from excel file. in Mapping Questions

I am trying to aggregate and summarize zip code date from excel file.

BrandonRutledge — Tue, 06 Feb 2018 19:47:36 GMT

I am attempting to create a map that shows the frequency of evictions by zip code within a single county. I have the data in an excel file. What would be the easiest way to import the data to the map. Is this something that is even possible to do?

Thanks in advance.

Re: I am trying to aggregate and summarize zip code date from excel file.

XanderBakker — Tue, 06 Feb 2018 20:31:21 GMT

What software do you have? Desktop (ArcMap or ArcGIS Pro), ArcGIS Online?

There is a layer with Zip code points available: http://www.arcgis.com/home/item.html?id=70b012d7c6ad4d5b8be7403ee5683aa0 that you can use. Summarize the data in Excel to have the count per ZIP code and join them together to show the locations with the count.

Re: I am trying to aggregate and summarize zip code date from excel file.

BrandonRutledge — Tue, 06 Feb 2018 20:37:28 GMT

I am currently using ArcGIS online but I plan to download ArcGIS Pro later today on my macbook. Thanks for the info.

Re: I am trying to aggregate and summarize zip code date from excel file.

XanderBakker — Tue, 06 Feb 2018 20:44:20 GMT

Be sure to read this: Recommendations for running ArcGIS Pro on a Mac—ArcGIS Pro | ArcGIS Desktop

You can do the join in either ArcGIS Pro: Add Join—Data Management toolbox | ArcGIS Desktop

or in ArcGIS Online: Join Features—ArcGIS Online Help | ArcGIS (will consume credits Understand credits—ArcGIS Online Help | ArcGIS )