0

I am using ArcMap.

I joined table data to the latest TIGERLine tract shapefile for my county and exported the data. When I attempt to create a choropleth/thematic map, many of the fields in the table are not visible/options to choose from the Value Field in the Quantities symbology. E.G. I cannot find/choose 2015 Median Income as a value for a graduated color map.

enter image description here

Improve this question
4
  • can you add a screenshot for your table after joining and export? does it still have your desired field (2015 median income)?
    – Moh
    Commented Mar 17, 2018 at 1:45
  • 2
    The Value Field in symbology requires Numeric field types. From the look of your table these fields are all Text field types (based solely on the fact they are all displayed left-aligned). Create a new Numeric field and copy the values you need to it
    – Midavalo ♦
    Commented Mar 17, 2018 at 2:25
  • I created a new [type=short] field for each [type=string] field to be converted. I attempted to create new numeric values for each new field using the Field Calcuator. I set the new field equal to the string (following the support.esri.com/en/technical-article/000002287 article), but got the following message when I hit 'Ok.' "The calculated value is invalid for the row with ObjectID = 1. For example, the calculated value may be too large for the field or you may be trying to add a string to a number field. This row will not be updated.
    – Ryan Stephenson
    Commented Mar 20, 2018 at 0:09
  • @RyanStephenson If your values without decimal points, so choose (Long integer), if they are with decimal points, then choose (double or float). please have a look over the different type in this link
    – Moh
    Commented Mar 20, 2018 at 0:11

1 Answer 1

Reset to default
1

The Value Field in symbology requires Numeric field types, and my table fields are all Text type fields. Creating a new field of types Short, Long, Float or Double will fix the problem, but each are appropriate for different number types i.e. integers, decimals. Opening the Field Calculator on the newly created number field, and clicking on the text field that the new number field is to represent, moving it into the dialog box sets the operation to be 'calculated.' TargetName_number = TargetName_string. Clicking 'OK' calculates all fields.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.