Download from this website the NUTS_RG_60M_2006 files (shapefile) and the csv-file T_DischargePoints_West.csv (source) and save them on your computer. Open them through ArcGis and plot xy-points. You get this result:

enter image description here

The cvs-file contains a number of variables. There is one categorical variable (dcpWaterBodyType). I now would like to know how many points from each category of dcpWaterBodyType there are in each nuts3-polygon. If possible, I also would like to determine automatically what the percentage of points of WaterBodyTypeA, WaterBodyTypeB, WaterBodyTypeC... is in one polygon and this for all the polygons.

Can somebody explain me how to do this in ArcGis or R?

1 Answer 1


Here is one option:

  1. Use the Spatial Join method to join the polygon info to the points
  2. Create a new text field in the joined point layer
  3. Field calculate/concatenate the dcpWaterBodyType field values with the polygon name or id field
  4. Finally, right click on field created in step three and choose the Summarize option

This should produce a count of the various dcpWaterBodyType per polygon feature.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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