Assigning location data from a points feature to a different excel file

78
1
11-29-2021 10:48 AM
Labels (2)
ThomasHamming
New Contributor

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!

0 Kudos
1 Reply
ABishop
Regular Contributor II

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.

Amanda Bishop, GISP
0 Kudos