Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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?

share|improve this question
    
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

1 Answer 1

up vote 7 down vote accepted

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.

share|improve this answer
1  
That worked beautifully, thank you. –  isolier Oct 20 '11 at 23:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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