value of points per hexagons

[DebraFischman]

Hi,

I have a point file that has a value column in its attribute table.  I want to get the values of each point in a polygon (hexagon) cell.

I know that tabulate area will give me a count of points per hexagon. Is there anyway to get the values?  A tool or a script?  I could look at each hexagon and manually add the values found in each hexagon but I have a lot of points so automation would help immensely.

Thank you in advance for your time and help.

[EricRice]

Hi there,

Try performing a spatial join.  It should work great if there is only 1 point per hexagon.  If there are more points you will get the attribute of the first point encountered.  You can do this by right clicking the polygon layer > Joins and Relates > Join.  Switch the join type to be based on spatial location rather than by attribute in a table. In section 2, choose the second radial button to get all the attributes of the points that fall inside (or are nearest) to the polygon.

If you need to script it or just want to use geoprocessing, there is a Spatial Join GP tool.  This tool provides more options than doing the spatial join manually.  Of particular note, it has a parameter where you can specify to join 1:1, or 1:M.  If you have multiple points in a single hexagon, and you need the attributes of all the points, you should run the GP tool with 1:M option.  The GP tool also provides field mapping in case you don't want all of the points attributes.  I understand you are only interested in a single value (attribute) of the points so GP may be the best way to approach this.  The tool is in ArcToolbox > Analysis Tools > Overlay > Spatial Join.

Here is the documentation on Spatial Join

Hope this helps.

Best Regards,
Eric