Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am working on a file which contains points from different areas of country. I have symbolized points. I want the feature count of respective area in a database form in .dbf file or excel etc. How can i get this count number (shown in figure) the dbf file.

enter image description here

share|improve this question
up vote 1 down vote accepted

You should be able to run a Frequency on the feature. Just select your "Constituen" field for the frequency field in the input and then join the output on the same field.

Although it is an extra step to the summary statistics, it will definitely work on a text field, and should work on any field type you throw at it.

share|improve this answer
thx a lot it has been done just the way i wanted.. :) Though I used programming techniques to solve it but this is really helpful... :) – Ade'l May 27 '13 at 6:46
Note that Frequency tool requires an Advanced license. – PolyGeo May 27 '13 at 7:27

To do this I would use the Summary Statistics tool which can be used with a Basic license and has a COUNT option.

In the graphic below I want to count how many times each value of a field called CLASSIFICA occurs so I use the COUNT statistic on the FID (object ID) field using CLASSIFICA as the case field.

enter image description here

The output has a field called FREQUENCY that is the count of each unique value found for the CLASSIFICA field.

enter image description here

share|improve this answer
The type i want to go along is "text" whereas it does not go with text... My data comes from field and I have a mixture of alpha numeric data that also includes a "-" in that... – Ade'l May 8 '13 at 16:41
@Ade'l - as you will see above there is no problem using a text field with Summary Statistics to count unique values. – PolyGeo May 27 '13 at 7:29
I may be experiencing this as I am using 9.3 version... ill try this on version 10 as well... :) – Ade'l May 27 '13 at 11:00
I did this lots at 9.3 too so am pretty confident it works there too. – PolyGeo May 27 '13 at 11:05
ok, what I am doing here is "adding a field OID_1" as it does not give me the option to select the FID field. I tried this field with different data types e.g long, int, double and etxt field was already of no use! even then it gives me an error 000800, The value is not a matter of SUM|MIN|MAX|COUNT etc. I used the field emplty and also tried after populating it wid FID values... Hope it give u some clue where I am mistaken... :) – Ade'l May 27 '13 at 11:21

Your Answer


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.