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 would like to calculate the total number of events within each feature of a polygon using a dbf file and a polygon shapefile.

Is there an easy way to automate this so I can then produce charts per feature area?



share|improve this question
What software are you using? How are the events geolocated (e.g., as coodinates, route miles, addresses, grid codes, something else)? – whuber Jan 23 '11 at 20:12
I'm using ArcGIS 9.3. Currently the events are in a dbf format and are simply added in via add XY Tool. They include XY coordinates. I know I can pull them in and convert them to a shapefile in model builder, but not quite sure how to compare them to a polygon and count the total number. I can do a work around with the intersection and export stats for a field, manually. However I would like to automate the process. We should have ArcGIS 10 within the next month or so. – user1746 Jan 24 '11 at 4:14

Have you investigated Spatial Joins?

share|improve this answer
Yeah I was just playing around with the spatial join and the summarize function in the attribute table. I think I can automate the process using these tools, but there has to be a better way. Maybe with the new 10 version... – user1746 Jan 24 '11 at 19:35

If you make the shapefile from your xy data you can use Hawths Tools - Count Points in Polygon: Link to Count Points in Polygons tool description

You can download Hawths Tools for ArcGIS 9.x for free here: Download Hawths Tools

I hope this helps you.

share|improve this answer
Have you had any issues using it with ArcGIS 9.3? Their website states that there are issues with the software when using the 9.3 version. The tool sounds really good though. What software are you using with it, 9.2 or 9.3? – user1746 Jan 24 '11 at 19:18
I have been using the tool with ArcGIS 9.3 and have not encountered any problems, what so ever. I have only used a few of the available tools though, so I'm not saying, that there could not be problems with some of the tools I haven't used. – Steen Kjeldsen Jan 24 '11 at 20:39
Okay, but the count tool appears to work for you. You are using the Hawths Tools and not the newer beta software, correct? – user1746 Jan 24 '11 at 21:19
Yes - that is correct - and I have used the count tool. – Steen Kjeldsen Jan 25 '11 at 11:51

Your Answer


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