3

I have a series of 500m buffer zones along a polyline. I also have a series of points following the line, each point represents a 10m x 10m cell. I calculated the values of a field in each point known as "F18".

I want to find the average, maximum and minimum values in F18 for all points within each buffer zone and add fields to the attribute table of the buffer for each.

ArcGIS 10.1, arcinfo license.

  • Are you looking for a scripting answer or just a workflow on how to do the process? – dklassen Apr 11 '14 at 22:12
2

Seeing as you have Info (Advanced) level of license you can use the cool geoprocessing toys.

Get the values of the polygons onto the points either by spatial join, identity or intersect. I think that intersect would be my choice. This will generate a point for each intersection i.e. if a point falls in more than one buffer then there will be one instance for each buffer it intersects.

To turn this into a table with min, mean and max you can use frequency or summary statistics, I use summary statistics mostly so I have a bias toward that one.

The OID field for the polygon is a 'case' field which will give one row in the table for each polygon with the min, mean and max values of the intersecting points listed in the row.

To get the values in the table back to the polygon use "join by attributes" using the OID for the polygon to join to the table 'case' field, then export to make it permanent.

This procedure can be used in a model, Python scripting or ArcObjects as a geoprocessor... whichever one floats your boat.

  • Does exactly what I need and can be inputted into a model or python scripting which means I can automate it for many polygons and points. – JC11 Apr 14 '14 at 14:58
3

I had a tool I made that basically did this, so I just tweaked it a little to fit what you need.

It's called Calculate Point Statistics, and you can download it here:

http://ianbroad.com/arcgis-toolbox-calculate-point-statistics-polygon-arcpy/

Source code:

http://ianbroad.com/download/script/CalculatePointStatistics.py

It takes an input Polygon and Point feature class and uses a selected field to find the minimum, maximum, and average of the points and adds the results to the polygon feature. It skips any null values. It will work with ArcGIS 10.1+

Here's a screenshot of the parameters: enter image description here

  • This is very useful, I have downloaded it and will use it. – JC11 Apr 14 '14 at 14:58
  • I added the source code to my post. – ianbroad Apr 15 '14 at 4:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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