I have an existing points feature containing the locations and names of all addresses in a city. I have another excel file with a list of people who live at each address. For purposes of seeing how many people live in a specific area, I want to assign each of the people in the excel sheet to a point location based on their address. What is the best way to go about doing this with these 2 data sets? Thanks!
Hello Thomas,
First, I would export both the feature (class or shapefile?) and the excel file into a file geodatabase.
Then I would geocode the converted excel file table from the file geodatabase.
Lastly, I would do a spatial join using the feature class to geocoded table (1 to many).
You can then use this newly joined data and export it for use in your project.