<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<html><body>
<p>On 05/14/2012 08:35 AM, M.E.Dodd wrote:</p>
<blockquote type="cite" style="padding-left:5px; border-left:#1010ff 2px solid; margin-left:5px; width:100%">
<div>Is it possible to geocode a list of addresses? I have the geocoding plugin loaded and it works (api key sorted out) but not sure how to get the list of addresses into qgis as they have no x,y location info at the moment. Am sure this question asked before but could not find the answer.</div>
<div><span> </span></div>
<div> </div>
<div>Dr Mike Dodd</div>
<div>Department of Environment, Earth and Ecosystems</div>
<div>The Open University<br />Walton Hall<br />Milton Keynes<br />MK7 6AA</div>
<div> </div>
<div><span><a href="http://www.ispot.org.uk/" target="_blank"><span><span>http://www.ispot.org.uk/</span></span></a></span></div>
<div><span><span><span><a href="http://www.floodplainmeadows.org.uk/" target="_blank">http://www.floodplainmeadows.org.uk/</a></span></span></span></div>
</blockquote>
<div>
<pre> </pre>
<pre>I am aware of two potential solutions:</pre>
<pre> </pre>
<pre>1) Locate a webservice and have that produce the Latitude/Longitude coordinate pairs.</pre>
<pre>This site has several: https://webgis.usc.edu/Services/Geocode/About/GeocoderList.aspx</pre>
<pre>Most as far as I can tell do not have support outside the United States however.</pre>
<pre> </pre>
<pre>Ultimately it would be a nice feature to have added to the plugin.</pre>
<pre> </pre>
<pre>2) The solution I had to go with was to use PostGIS outside of QGIS to generate the Latitude/Longitude pairs. This may not work depending on your setup, available time, knowledge level, budget, or level of access within your organization.</pre>
<pre> </pre>
<pre>The available documentation I found assumes that United States Census Bureau data is used to geocode against. This solution could be made to work for other countries if the same/similar type of data released by the US Census Bureau is made available by the locality for which you wish to geocode for. Changes likely will be needed either to the setup scripts or the final database columns prior to loading data from your locality to take into account differences between how things are done in the US versus your locality. Examples might include length and data type of postal codes and state/provincial abbreviations.</pre>
<pre> </pre>
<pre>Some information can be found here: http://postgis.refractions.net/documentation/manual-svn/Geocode.html </pre>
<pre>A setup guide http://www.letseehere.com/postgis-geocoder-using-tiger-2010-data</pre>
<pre> </pre>
<pre> </pre>
<pre> </pre>
<pre>--
Dan Dittmann</pre>
</div>
</body></html>