Method For Checking Spatial Data In A Table

Discussion created by gdixon on Sep 28, 2012
Latest reply on Sep 28, 2012 by LDanzinger-esristaff
I am having difficulty figuring out this problem and I am hoping for some guidance from the forum.

I have two feature layers; a point layer of donut shops and a US Counties polygon layer. I have to visually check all the locations of the donut shops on an imagery layer to make sure that they are in the correct location. What I would like to do is iterate through the list of donut shops and check to see if each point feature is located in the correct county and state. As the process checks each donut shop, put a yes or no in the county and state fields. This is of course to weed out the ones that are in the wrong county or state. I can those send back to the data providers for a new XY coordinate and I do not have to manually check them.

I was thinking that I could do something like this in model builder and thought that the first place to start looking was at the Iterator toolset. Theoretically, I know how this should work but I do not know how to do it.

Does a model all ready exist to do this that I can modify? Or can someone point me in the right direction regarding as to how I might accomplish this task?

Thanks for any consideration of my problem.

The point layer has the following columns:
Shop Name
County Name
State Name

The US Counties layer has the columns:
County Name
State Name