I'm struggling with the Spanish municipality level.
I need to incorporate population data with the lat/long for each Spanish municipality and below are the details of my current files:
- I cannot find one master CSV having population for each municipality,
instead I have 52 files having population for municipalities within
each Spanish province; - I have the lat/long for each municipality in a separate CSV, and
- The problem is, I need a master CSV with all data in one place and my CSV files don't have an id I can use to map the data.
Best Answer
I don't know whether you're still after an answer to this problem. Anyway, I'm assuming you're using ESRI GIS. There probably is a similar method in case you're using different software.
What you're after is the
spatial join
tool. Try this:display X/Y coordinates
and select the fields with your Lat/LonAnalysis
toolbox and selectspatial join
. Use the data set you want to join your data to as "Target feature". Add a search radius (in case your coordinates aren't identical). Select an output feature class and hit OK.