4

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

9
  • related: Join non-spatial CSV to spatial data in QGIS gis.stackexchange.com/questions/6398/…
    – underdark
    Jan 23, 2013 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, 2013 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, 2013 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, 2013 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, 2013 at 14:27

0

Browse other questions tagged or ask your own question.