arcgis-10.1arcgis-desktoppointpoint-in-polygon
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.
If I understand your question correctly, I run something similar on occasion for stormwater lines. It involves extracting depths at each endpoint and adding them to the table of the lines.
What you can do is create your own Unique ID's based off of the XY coordinates of both sources and then use those to join the tables together. You would end up doing two joins, one for the startFA and one for the endFA.
Add new fields called startFAXY and endFAXY in your lines table. Populate those by concatenating your coordinates of start and end. The startFAXY of FID0 would be "-76.350441, 45.434355". Run this same procedure on endFAXY. Then, continue this same process on your extracted values FA table so that you have a column that concatenates your FA table coords. Use these concatenated XY values as a unique ID to join the two sources together (lines table + FA table) and populate the field. The first join (startFAXY + FA table) would populate the startFA field. The second join (endFAXY + FA table) would populate the endFA field.
Using the example from above, FID0 startFAXY -76.350441, 45.434355 would join to a record in the FA table with a concatenated "ID" of -76.350441, 45.434355.
It is generally not perfect since it deals with coordinates, but I find I am able to capture >98% so any manual matching is not too bad. Add in the use of the Attribute Transfer Tool during cleanup/QA and it really reduces the headache.
From what you are explaining the Euclidean Distance would be (a) The buffers would be (b) So the differences would be in the corners (c)
Best Answer
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: