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

This question already has an answer here:

I'm new in the GIS world.

I have a bunch of points (around 40,000), which are split in categories (1 to 9) and have a field which specifies their membership to a polygon (~50) (e.g, 30, which would mean that the point is located in polygon 30).

Some zones do not contain points of all categories.

I wish to know the frequency of each category per zone, in such a way that in the end I would have a table with the first column for the categories, and the zones listed in the first row.

Did somebody have the same challenge? How did you solve it?

share|improve this question

marked as duplicate by PolyGeo Oct 13 '15 at 22:55

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Being as though you have all of the info you require you could do this using a pivot table in Excel (just open and save a copy of the .dbf associated with your points shapefile).

In ArcGIS, you can also create a pivot table (i.e. Data Management > Table > Pivot Table) depending upon your licence level. Alternatively, you could use Summarise (click on the field header of the field you want to summarise). There's an ESRI article here: Summarise tool

share|improve this answer

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