Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

share|improve this 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. –  user14519 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
show 4 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.