topic Re: Field not diplaying in Quantities Symbology in Spatial Statistics Questions

Field not diplaying in Quantities Symbology

MelissaTraverso — Thu, 05 Jun 2014 22:46:44 GMT

Hi I am trying to create a graduate color quantities symbology for a string field in my attribute table but in the drop down menu it doesn't show up. If I go to categories>unique values it shows up in the drop down of the field values. Does anyone know why? Or what I could be doing wrong?

Thanks

Re: Field not diplaying in Quantities Symbology

IanMurray — Fri, 06 Jun 2014 11:57:53 GMT

I'm fairly certain that for the Quantities symbology, you must have a field that is a numeric type, that is to say Short Integer, Long Integer, Float or Double. I'm guessing you are using a text field, which won't show up as a possible selection for the quantities symbology. If all your data in your text field is numbers, then you should be able to make a new numeric field and set that field equal to the text field and symboloize off that field.

Either that or if the field is a joined field, it will not show up, you need to make a new field and copy the values of the joined field to it.

Re: Field not diplaying in Quantities Symbology

MelissaTraverso — Fri, 06 Jun 2014 17:20:47 GMT

Thanks! This sounds like it will work. Do you know what I would set for my field calculator once I have created a double field? can I just said <new field>=<old field>

Re: Field not diplaying in Quantities Symbology

IanMurray — Fri, 06 Jun 2014 17:45:23 GMT

That should be fine as long as all the values in the other fields are numbers. A double field type won't support any letters or symbols.

Re: Field not diplaying in Quantities Symbology

MelissaTraverso — Fri, 06 Jun 2014 18:17:30 GMT

I have 7 null values in this field which is probably why it was initially marked as a string while the rest of the number fields were set as long integer/double. Does this mean using the quantities symbology tab on this field won't work?

Re: Field not diplaying in Quantities Symbology

IanMurray — Fri, 06 Jun 2014 18:51:03 GMT

I don't think it will since the field type is already defined. However, you can replace the null values as seen here. Then you should be able to make the new numeric field and use the field calculator and have <new field>=<old field> and then you should be able to find it for the quantities symbology.

Re: Field not diplaying in Quantities Symbology

MelissaTraverso — Fri, 06 Jun 2014 20:56:47 GMT

Thanks so much for the help thus far. The only way it will let me Add a field is if I convert it to a feature class within a geodatabase. I tried to add field after saving it as a layer file and it isn't an option. THe only thing that seems to work is when I use the conversion tool and save it into my geodatabase and use this new feature class. However in the process it says it was executed successfully but when I zoom to layer one of the points gets thrown out in the middle of nowhere which isn't how it was prior as a resulting layer from displaying the xy data of the original excel table. Suggestions ?

Re: Field not diplaying in Quantities Symbology

IanMurray — Mon, 09 Jun 2014 12:43:48 GMT

Ah, you are creating this from an excel spreadsheet. I just did a test and if you select the column with your values in excel and rightclick and select format cells and change the category to numeric, it will bring the field into ARCgis as a double, instead of text, which is what it bring it in as if the format in excel is general.

Re: Field not diplaying in Quantities Symbology

MelissaTraverso — Mon, 09 Jun 2014 16:47:03 GMT

True! But I was having difficulty displaying XY data with the excel spreadsheet because the attribute table wouldn't carry over to the new layer so I saved the excel file as a CSV. In the CSV all columns (even numeric) seem to be formatted as general in excel with no specific number format and when brought into arcMap to display xy data all numeric fields except this particular field I have been working on take the correct numeric format to be displayed under quantities symbology and the attribute table carries over. I went into the csv to try and format this field as numeric but it won't let me save it without giving me the following message below. when I click yes and save it anyway I ordered this column descending in the attribute table in ArcMap and noticed that I lose some of the values.

Re: Field not diplaying in Quantities Symbology

IanMurray — Mon, 09 Jun 2014 17:39:08 GMT

Would it be possible for you to upload a copy of the csv? Dealing in with all this theoretically makes it a bit hard to deal with.

Also which method are you using to create the layer in ArcGIS? Are you bringing the csv sheet into the Table of Contents, then right clicking and selecting "Display XY data" or are you bring it up in the catalog and right clicking on the sheet in the catalog and selecting "Make Feature Class">"From XY data". If you follow the second method, you should be able to make a shapefile out of it, so it wouldn't mess with the lack of projection and move your points like it did when it you made it a gdb feature class.

Re: Field not diplaying in Quantities Symbology

MelissaTraverso — Mon, 09 Jun 2014 18:15:28 GMT

I was originally doing the first of the two but I also just tried the second and when I zoom to layer there is still a point way outside of where it should be which doesn't happen when I display XY data within the table of contents it happens when I try to save these layers that I am working on into a geodatabase by using the "feature class to feature class" tool under conversion tools "To Geodatabase". For some reason the CSV won't upload it says invalid file and the excel file exceeds the limit... hmmm...

Re: Field not diplaying in Quantities Symbology

IanMurray — Mon, 09 Jun 2014 18:27:40 GMT

If you put in it a zip file then it probably wouldn't be too big.

Re: Field not diplaying in Quantities Symbology

ELTerrell — Fri, 03 Mar 2017 13:49:34 GMT

What was the verdict on this one? I am having the same issue...

I uploaded a CSV file of numeric columns, joined them to my polygons, they show in the attribute table and under >symboloby>categories but NOT under >quantities....

Re: Field not diplaying in Quantities Symbology

ELTerrell — Fri, 03 Mar 2017 14:04:39 GMT

Also, the title of the joined columns doesn't show what it was in excel...instead of my text is says 'field2 field3 field4'.

Re: Field not diplaying in Quantities Symbology

IanMurray — Fri, 03 Mar 2017 15:03:06 GMT

There was never any additional follow-up from them, so no idea if it ever got resolved. I again extend my offer to look at a copy of the csv.

Also I recommend converting the csv to a geodatabase table, it usually helps clear up a few things prior to the join.

Re: Field not diplaying in Quantities Symbology

ELTerrell — Fri, 03 Mar 2017 16:08:18 GMT

I guess I can just reply to this email instead of messaging...

Best,

Edwin Terrell

Re: Field not diplaying in Quantities Symbology

JakobKnoll — Mon, 23 Oct 2017 16:24:30 GMT

Hey guys, I seem to have an issue with that function as well, i importet datasets form a CSV file for my BA Thesis, trying to show the date of emergencies around my hometown. now for some reason i can't choose to show all sets from the column "Indikation" which sucks and is essential to my work. can you please help me?

what came to my mind is that i recognize next to the different sets there are "," marks that are not in the original Dataset....any ideas on that?

thanks in advance!

Re: Field not diplaying in Quantities Symbology

JakobKnoll — Mon, 23 Oct 2017 16:25:28 GMT

Re: Field not diplaying in Quantities Symbology

jasleensethi — Thu, 09 Aug 2018 18:57:51 GMT

I am in the same situation right now. How did you fix the issue on your end ?

Re: Field not diplaying in Quantities Symbology

ELTerrell — Thu, 09 Aug 2018 19:44:15 GMT

Hmmm, it's been awhile (4 years)...I believe I sent it to Ian and he was able to make it work. If I remember correctly he may have simply copied and pasted it into another file. Sorry that's probably not much help, it was a long time ago.