Counts and Amounts (Size) Not Showing up as an option

MegDavidson · ‎11-28-2016

I just uploaded a layer to my map (Neighborhood Grocery Network) and the option to change the style to Counts and Amounts (Size) is not showing up, despite the fact that the Attribute I selected is a numerical field (UOS field).

Does anyone have suggestions as to why this is happening or how I can get Counts and Amounts (Size) to show up? It worked on every other layer I added and they all came from the same data source and were uploaded from the same file format.

http://www.arcgis.com/home/webmap/viewer.html?webmap=8c6ada8d2814409aa881e52843211923

KellyGerrow · ‎11-30-2016

Hi Meg,

When you look at the JSON of the webmap:

http://www.arcgis.com/sharing/rest/content/items/8c6ada8d2814409aa881e52843211923/data?f=pjson , the Neighbourhood Grocery Network is a feature collection that is stored in the web map. The UOS field is identified as a string field:

{
"name": "UOS",
"type": "esriFieldTypeString",
"alias": "UOS",
"sqlType": "sqlTypeNVarchar",
"length": 256,
"nullable": true,
"editable": true,
"domain": null,
"defaultValue": null
}

How did you publish this data? Was it by adding a csv file directly to the map? If so, try publishing this as a hosted feature service. You will be prompted to select the correct data type during the publishing process.

Also, feel free to share the datasource and I can look into why the datatype was incorrectly set.

-Kelly

MegDavidson · ‎11-30-2016

Hi Kelly,

Thanks for the help!

I tried to upload this CSV as a hosted feature service but I am unable to publish due to my privileges. I have a free account and I’m not sure it’s possible for me to change my privileges with this type of account.

I attached the CSV here to see if you might be able to offer any insight into why the datatype was initially incorrectly set.

Thank you for your help!

Meg

Meg Davidson

Sr. Program Mgr. – Analytics

(415) 282-1907, ext. 225

www.sfmfoodbank.org<http://www.sfmfoodbank.org/>

Find us on Twitter<https://twitter.com/SFMFoodBank> and Facebook<https://www.facebook.com/sfmfoodbank>

Do you believe in Food For All?

Take the pledge<http://org2.salsalabs.com/o/5420/p/salsa/web/common/public/signup?signup_page_KEY=9808> to help end hunger in our community.

KellyGerrow · ‎11-30-2016

Thanks Meg,

It looks like there is a value that was causing the data type to be defined as a string. As this is a CSV, commas are used to separate values. There is a comma in one of the name fields which resulted in all of the fields of for that record being shifted over by one value adding a string value into the UOS field: Korean American Senior Services, Inc. To get this to use the correct field type, remove the comma from this title, or modify the csv so that this title is contained in single quotes.

I've attached your spread sheet with the single quotes workaround.

MegDavidson · ‎11-30-2016

Kelly! You’re my GIS hero! Thank you for figuring it out and for helping me understand what caused the issue in the first place so I can avoid it happening again.

I really appreciate your help!

Best,

Meg