arcgis-desktopshapefile
I'm creating a map with two shapefiles:
I used the function Intersect to group the cities in each county.
I'm trying to get the number of cities in each county to show up in the legend.
For example, in county A there are 16 cities, in county B there are 7 cities and so on.
I'm trying to create a choropleth map that shows the number of cities in each county.
After using Spatial Join or Intersect to get the County name attribute onto each point, try using Dan Patterson's Split Layer by Attributes tool available on the Geoprocessing Model and Script Tool Gallery.
Alternatively you could use ModelBuilder to automate this using a different approach involving Select Layer by Location (click thumbnail for full image).
Lifted from this thread on the ESRI forums: Batch Selecting by Location and Exporting Shapefiles
There is an ArcToolbox tool called Snap found in the "Editing Tools" toolset.
You could use Select by Location to select all the points that don't intersect one of your polygons (the ones that are in the ocean), and then run the Snap tool to snap those to the nearest polygon edge. Use invert_spatial_relationship to select the points that don't intersect.
Please note that Snap modifies the existing data, it doesn't output into a new feature class so take a copy first.
Best Answer
You can get a count of cities in each county by doing a spatial join. This will create a new shapefile with a new column in the attribute table called "Count."
You can set your map symbology based on that column to create a choropleth map.