I have geometry feature class of states that I would like to build a choropleth map from by using the quantity of people in that state. However, the data of what people in what state is in seperate table with other attributes like first and last name and so on. Is there a way to count all of the, say, Washington State people from the seperate table and append a "population" attribute at the end of the geometry feature class' attribute table so that I may then use this newly derived "population" attribute to use for the choropleth map?

  • Can you just join the table to the feature layer? – blah238 Oct 20 '11 at 5:15
  • 1
    No, the situation is there are 30+ names per state in a separate data table, so I need to get that count and append it to the corresponding state attribute in the geometry feature class so that I have a count for every state. I will then use that count as the quantity to create the choropleth. – isolier Oct 20 '11 at 6:00

It sounds like you should be able to do a Frequency (Analysis) on the "state name" field of your separate table, and then join that to your states feature class on the state name field. See more about joining tables here.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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