topic Re: Is it possible to have both choropleth and circles displayed at the same time? in ArcGIS Online Questions

Is it possible to have both choropleth and circles displayed at the same time?

Jackbigs — Mon, 30 Oct 2023 14:35:12 GMT

Hello there,

Apologies if this has been asked before or if it's something obvious. I'm new to trying to learn how to use ARCGIS as it seems to be more advanced in its capabilities. Anyways, I was wondering if it's at all possible to have both a choropleth/fill map also have circles on it. To clarify I'm trying to show a count of callers from each county as well as by specific zip codes and have both visually represented at the same time. I'm mostly trying to figure out if this is possible within Power BI but if it can be done online then I assume I could transfer it over to a dashboard? Any help, suggestions or directions to this information would be greatly appreciated.

thanks!

Re: Is it possible to have both choropleth and circles displayed at the same time?

bbollin — Mon, 30 Oct 2023 20:29:19 GMT

Hi @Jackbigs, yes it is possible to display a map using color and size but you need to have the correct types of variables to apply the style. In this example I have the cities layer selected, then I clicked on Styles. From here I clicked on the + Field button where you can add one or more fields to represent on your map. Once I selected my POP2000 field, I applied the Color and Size style.

You can learn more about what styles are supported and how by viewing the table in this documentation: https://doc.arcgis.com/en/arcgis-online/create-maps/apply-styles-mv.htm

Re: Is it possible to have both choropleth and circles displayed at the same time?

Jackbigs — Mon, 30 Oct 2023 20:48:39 GMT

Appreciate your reply! So would it be possible to do something like... Show a choropleth by county that shows, for example, food insecurity rates and then use circles to show locations of food banks within that county?

Re: Is it possible to have both choropleth and circles displayed at the same time?

bbollin — Mon, 30 Oct 2023 21:06:46 GMT

Absolutely @Jackbigs! I'm not sure how your dataset is structured, but I would have two separate layers in my map like this:

1: Food bank location points
2: County polygons

Then from here, select the points layer and apply the field you want using the steps above (or can just leave as a defaulted location).

For the counties layer underneath, apply a color/choropleth map that displays the food insecurity rates using the steps above.

If you share your data or describe how it is set up I can help you out a bit further

Re: Is it possible to have both choropleth and circles displayed at the same time?

bbollin — Mon, 30 Oct 2023 21:09:22 GMT

It sounds like you may be new to ArcGIS Online, if that is the case I highly recommend working through these free learning samples: https://learn.arcgis.com/en/projects/get-started-with-arcgis-online/ this will allow you to get a better understanding how how to build your map

Re: Is it possible to have both choropleth and circles displayed at the same time?

Jackbigs — Mon, 30 Oct 2023 21:09:40 GMT

Okay I'll take a crack at this and see how it goes. As far as the data, the insecurity rate we pull from feeding america's data so its just a percentage by county. The food bank data is based on our own collection of those locations and its pretty basic, zip code address name etc etc

Re: Is it possible to have both choropleth and circles displayed at the same time?

JayLarsen — Tue, 31 Oct 2023 00:48:53 GMT

A classic AGOL trick is to dupe the layer of interest and then set up multiple copies with all the different styles of interest. Just rename them something useful after duplication.

The real trick you'll see is designing your data table that you upload to be able to show all you want.

Fun times ahead! Enjoy!

Re: Is it possible to have both choropleth and circles displayed at the same time?

Jackbigs — Tue, 31 Oct 2023 15:34:37 GMT

Do I need to have a file structed in a very specific way to have it upload? I'm trying to load the feeding america data I have and when I click next all it does is spin and return to the page that shows the name of the file I chose. No explanation of why it is or isnt working. Do I need to have coordinates for arc to accept a file? I have county and state locations but that doesnt seem to make a difference. If i try to upload a file that does have long and lat it allows it. Ive attached the CVS for you to see.

Re: Is it possible to have both choropleth and circles displayed at the same time?

JenniferAcunto — Wed, 01 Nov 2023 13:46:45 GMT

I think the issue with uploading this dataset is due to your header names. It is best to avoid spaces, special characters, and headers that start with a number. Additionally, some of your headers are rather long and very similar, so when they get truncated they are duplicate names which is also not allowed.

Cleaning up your headers should help with your publishing issue. However, I would also recommend cleaning up your data fields as well. Including % and $ in your cells turns that value into a string instead of an integer or double. This will limit the types of things you can do with that data.

Re: Is it possible to have both choropleth and circles displayed at the same time?

Jackbigs — Thu, 02 Nov 2023 14:27:23 GMT

Ah okay, thank you for that. I'm used to being able to ingest most anything into Power BI and it not really be a problem. It would be nice if the program gave some insight as to what the problem is rather than tossing me back to the same page.