[Qgis-user] Fwd: Joining data to a shape file by country name when the names don't match exactly

Nyall Dawson nyall.dawson at gmail.com
Fri Nov 4 20:22:31 PDT 2016


On 5 Nov 2016 12:13 PM, "Joe Lertola" <joe at joelertola.com> wrote:
>
> Hello.
>
> Today I made a thematic map by joining a list of data that had country
names to a shape file of world countries. I had to spend a lot of time
working in Excel to make my data names match the names in the shape file. A
lot of them already matched but there were many that didn’t. For example
the the shape file had Ivory Coast and the data had Cte d’Ivoire as the
name. Is there any way to do this in Qgis instead of Excel? Years ago I
recall doing this in ArcMap. There was a tool that matched up the data
where it could and then for each record that wasn’t matched you could
choose the matching record manually. Any help would be greatly appreciated.

How good are your python skills? Sounds like a perfect candidate for a new
processing algorithm. QgsStringUtils has methods for performing "fuzzy"
matching of strings, so a lot of the hard work is already done.

Nyall

>
> Thanks,
> -Joe
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20161105/61bbd206/attachment.html>


More information about the Qgis-user mailing list