2

I know the question is all over this site, unfortunately I cannot find a solution. I have this CSV file and this CSVT file that I want to merge with this shapefile. I've tried to format the .csv using all software mentioned in the forum including Excel, Numbers, Open Office, Libre Office, Text Edit and Sublime text.

The .csv file is imported almost correctly as you can see from the pictures, but the fields are wrong. Therefore the merge function does not work, because the csv fields are still seen as "text".

Can someone give me a hand on this?

enter image description here

PolyGeo
  • 65,136
  • 29
  • 109
  • 338
Matteo Mandrile
  • 299
  • 2
  • 8

2 Answers2

1

As mentioned in the answer to QGIS 2.0 text delimited layer importing data as single row:

The Add delimited text layer plugin does not use the .csvt file. The .csvt file is only interpreted by OGR - that means when you load the .csv using Add vector layer.

You will find some hints on Mac-specific problems with delimited text too.

Apart from that, I see no common field in your data except the name field. PRO_COM contains different values than Zona in the csv table.

You can join on the name field, and get this picture:

enter image description here

30 Communes get coloured categorized by the joined field Zona, except for C015 and C020, which are spelled slightly different in the tables.

Community
  • 1
AndreJ
  • 76,698
  • 5
  • 86
  • 162
0

You might want to see this post: Joining non-spatial CSV file to spatial data (shapefile) using QGIS?

And here is a video demo on how to join CSV data to Shapefiles in QGIS: https://www.youtube.com/watch?v=82aRDdJdhI0

Community
  • 1
clhenrick
  • 1,845
  • 3
  • 18
  • 24