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'm kind of new in the GIS world but have been finding my way around in forums and help places up to now. Still, there's one task I need to perform that I cannot get my head around it or even find somebody with the same problem.

I would be really grateful if somebody could help me on this.

Basically 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?

Best regards! Andre

share|improve this question
add comment

1 Answer 1

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
add comment

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.