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 a question with ArcGIS 9.2. In an attribute table the column [name] includes the name of every place in this layer. Next to that (in columns [numbers]) there should be recorded how often a place of this name is in the map. How can I calculate this values with VBA in the field calculator? I am really happy about every answer and every help. Thank you.

share|improve this question

1 Answer 1

up vote 7 down vote accepted

I don't know how to do this with Field Calculator, but I do know a workaround.

Run Summary Statistics in ArcToolbox with COUNT on the [name] field. This will create another table where each unique [name] entry will have next to it the number of times it appears in the original layer. Then Join this table back to your original layer, with the [name] field as the link.

share|improve this answer
    
Thank you for the answer, but I can just choose between SUM, MEAN, MIN, MAX, RANGE, STD, FIRST and LAST. Is it possible that the COUNT option is not included in ArcGIS 9.2 and just in later varsions? –  Muschter Nov 4 '11 at 13:42
    
You're right, COUNT was not an option in 9.2. Fortunately, you do have access to the Frequency tool, which basically does the same thing. –  dmahr Nov 4 '11 at 14:42
    
It works really great! This is exactly what I needed. Thank you very much! –  Muschter Nov 4 '11 at 15:41
    
No problem buddy =) Be sure to mark this question as "answered" whenever you get a chance. –  dmahr Nov 4 '11 at 16:10

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.