[ddj] [Spam?] Reverse Geocoding Country: Best Practice

Mon Nov 17 08:34:24 UTC 2014

Matt,

Late reply:

I would use QGIS, a shapefile of country borders and the feature Merge attributes by location.

This is very clean and is simpler.

Mihi

From: data-driven-journalism [mailto:data-driven-journalism-bounces at lists.okfn.org] On Behalf Of Matthew Linares
Sent: Tuesday, November 11, 2014 12:48 PM
To: data-driven-journalism at lists.okfn.org
Subject: [Spam?] [ddj] Reverse Geocoding Country: Best Practice
Importance: Low

Dear all,

I have a table which includes latitude/longitude values but no clean country location. I'm presently fiddling with the Google sheets IMPORTXML method to get a plain country field:

http://schoolofdata.org/handbook/recipes/geocoding/

...which is a bit untidy due to xPath selection on the resulting XML.

Does anyone know a slicker tool or method to achieve this? I did start by loading the data into mapping apps and seeing if they exported with country data but nothing I found did that.

Thanks,
Matt

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20141117/7c703b81/attachment-0003.html>