I'm new to GIS and new to StackedExchange.

I need help joining a CSV of Accessibility data to a LSOA shapefile in QGIS.

The process explained here does not work for me and I don't know why. The mmqgis plugin and the Joins feature in QGIS both provide me with either an empty Shapefile or an empty CSV file.

I'm trying to map statistics related to accessibility to hospitals from the Department for Transport. The data can be downloaded from here and is in CSV format and is georeferenced by Lower Super Output Area (LSOA), with one column of LSOA codes and the rest are the separate statistics (time taken to get to nearest hospital, for example).

I also have a LSOA shapefile from here, which obviously has the exact same list of LSOA codes.

How can I join the two datasets so that I can map the accessibility stats for each LSOA with a range of colours? I've tried using the 'Join' feature but I can't seem to get it to work.

Any help would be much appreciated.

The first image shows the Accessibility data, note the LSOA data in the first column which matches the LSOA data in the Shapefile and the last column is what I want to map/Join. The second image shows the data associated with the LSOA shapefile, note the LSOA data matches that in the Accessibility data. As far as I know the data type in each file matches. What I want to do is map the data in, say, column 5 of the Accessibility data onto the LSOA shapefile.

enter image description here

enter image description here

closed as unclear what you're asking by underdark Feb 21 at 17:13

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • related: Join non-spatial CSV to spatial data in QGIS gis.stackexchange.com/questions/6398/… – underdark Jan 23 '13 at 18:01
  • Please use the search before posting a question. You find a solution for your problem here: gis.stackexchange.com/questions/6398/… – Curlew Jan 23 '13 at 18:02
  • Please be more specific about "can't seem to get it to work". Do the values in both files really match? What happens if you use try do perform the join? – underdark Jan 23 '13 at 18:02
  • @Curlew I have spent the past two days following the instructions in that link at it doesn't seem to fix my problem. Hence the question. – KJGarbutt Jan 23 '13 at 22:56
  • 1
    "What I want to do is map the data in, say, column 5 of the Accessibility data onto the LSOA shapefile." ... That's not possible. QGIS will always add all columns. Are you really joining on the two code columns? I don't see why that wouldn't work. – underdark Jan 24 '13 at 14:27