value of points per hexagons

DebraFischman — Tue, 24 Aug 2010 17:37:40 GMT

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.

Re: value of points per hexagons

EricRice — Wed, 25 Aug 2010 13:46:17 GMT

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

topic value of points per hexagons in Geoprocessing Questions

value of points per hexagons

Re: value of points per hexagons