nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Field not diplaying in Quantities Symbology

MelissaTraverso

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

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

IanMurray

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.

MelissaTraverso

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>

IanMurray

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.

MelissaTraverso

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?

IanMurray

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.

MelissaTraverso

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 ?

IanMurray

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.

MelissaTraverso

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.

Capture.PNG

IanMurray

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.

MelissaTraverso

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

IanMurray

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

ELTerrell

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

ELTerrell

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

IanMurray

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.

ELTerrell

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

Best,

Edwin Terrell

time lapse experiment2.csv.zip

screenshot.png

Showing the join.JPG

brrh96

hi. how can i change type of the fields?

MikeHope

I am also having this problem. I have joined a CSV file to my shapefile. It has a large number of columns all of which I can see in the attribute table. Use of the quantities category in Symbology works fine for the majority of columns. But, it is not accessible for columns with the word crafts in the field name. I have tried making the csv file numeric with no effect. Can anyone help?

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.