[GIS] Spanish municipality level shapefile and population data

datapopulationshapefilespain

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:

  1. Load one set of csv-data into your MXD.
  2. Right-click the loaded table, hit display X/Y coordinates and select the fields with your Lat/Lon
  3. Right-click the data again, select data --> export data and save in a GDB or as a shape file.
  4. Repeat for your second data set.
  5. Navigate to your Analysis toolbox and select spatial 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.
Related Question