<div></div><div>Hi Phil,</div><div>thanks a lot!</div><div>Marilena<br>
<br>
</div><blockquote>
----Messaggio originale----<br>
Da: phil@wyatt-family.com<br>
Data: 27/01/2015 23.41<br>
A: <labiancamarilena@libero.it><br>
Ogg: RE: RE: [Qgis-user] (no subject)<br>
<br>
<!--<style><!--
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.hps
{mso-style-name:hps;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-AU;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
-></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]-><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]->--><div class="WordSection1"><p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>Hi Marilena,<o:p></o:p></span></p><p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p><p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>There are quite a few tutorials about geocoding. A quick Google search with the terms .. QGIS geocoding .. returned plenty of leads. As always there are multiple ways this can be done so don't be afraid to try the geocoding from a few different services especially if the address locations are in rural areas. Some systems work best in cities, others in lesser known areas.<o:p></o:p></span></p><p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p><p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>https://www.google.com.au/search?q=qgis+geocoding&ie=utf-8&oe=utf-8&gws_rd=cr&ei=AxLIVMXfPMmD8gXStICoCQ#q=qgis+geocoding<o:p></o:p></span></p><p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p><p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>Given QGIS is open source there are lots of samples and websites that can help you through almost any process.<o:p></o:p></span></p><p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p><p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>Have fun!<o:p></o:p></span></p><p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p><p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>Cheers - Phil<o:p></o:p></span></p><p class="MsoNormal"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'><o:p> </o:p></span></p><p class="MsoNormal"><b><span lang="EN-US" style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'>From:</span></b><span lang="EN-US" style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'> labiancamarilena@libero.it [mailto:labiancamarilena@libero.it] <br><b>Sent:</b> Wednesday, 28 January 2015 6:37 AM<br><b>To:</b> phil@wyatt-family.com; qgis-user@lists.osgeo.org<br><b>Subject:</b> R: RE: [Qgis-user] (no subject)<o:p></o:p></span></p><p class="MsoNormal"><o:p> </o:p></p><div><p class="MsoNormal">Dear Phil, <o:p></o:p></p></div><div><p class="MsoNormal">great!<o:p></o:p></p></div><div><p class="MsoNormal">Thanks a lot!<o:p></o:p></p></div><div><p class="MsoNormal">It's a fantastic plugin, but are there videos or other sources for the best use of this plugin? <o:p></o:p></p></div><div><p class="MsoNormal">Thanks a lot<o:p></o:p></p></div><div><p class="MsoNormal" style="margin-bottom: 12pt;">Marilena <o:p></o:p></p></div><blockquote style="margin-top: 5pt; margin-bottom: 5pt;"><p class="MsoNormal" style="margin-bottom: 12pt;">----Messaggio originale----<br>Da: <a href="mailto:phil@wyatt-family.com">phil@wyatt-family.com</a><br>Data: 26/01/2015 23.51<br>A: <<a href="mailto:labiancamarilena@libero.it">labiancamarilena@libero.it</a>>, <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>><br>Ogg: RE: [Qgis-user] (no subject)<o:p></o:p></p><div><p class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>You will need to somehow assign geographic references (Lat/Long) to each address. This might be achieved by geocoding from the addresses. Under plugins, check if the experimental MMQGIS plugin is loaded. This has a menu item for geocoding the addresses from Google and Open Street Mapping.</span><o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'> </span><o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'>Cheers - Phil</span><o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"><span style='color: rgb(31, 73, 125); font-family: "Calibri","sans-serif"; font-size: 11pt;'> </span><o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"><b><span lang="EN-US" style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'>From:</span></b><span lang="EN-US" style='font-family: "Tahoma","sans-serif"; font-size: 10pt;'> <a href="mailto:qgis-user-bounces@lists.osgeo.org">qgis-user-bounces@lists.osgeo.org</a> [<a href="mailto:qgis-user-bounces@lists.osgeo.org">mailto:qgis-user-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b><a href="mailto:labiancamarilena@libero.it">labiancamarilena@libero.it</a><br><b>Sent:</b> Tuesday, 27 January 2015 2:20 AM<br><b>To:</b> <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br><b>Subject:</b> [Qgis-user] (no subject)</span><o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"> <o:p></o:p></p><div><p class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"><span class="hps"><span lang="EN">Dear all</span></span><span lang="EN">,<br><span class="hps">I should</span> add <span class="hps"> a spreadsheet</span> <span class="hps">with data</span> <span class="hps">containing</span> <span class="hps">the addresses</span> <span class="hps">of</span> <span class="hps">commercial activities</span> <span class="hps">to be loaded</span> <span class="hps">in QGIS</span>.<br><span class="hps">The</span> spread<span class="hps">sheet (Excel)</span> <span class="hps">contains</span> <span class="hps">the name</span>, <span class="hps">code</span>, <span class="hps">complete address</span>, <span class="hps">city</span>.<br><span class="hps">How can I assign</span> <span class="hps">these values</span> <span class="hps">properly if</span> <span class="hps">I want to use</span> <span class="hps">open layer</span> <span class="hps">plugin</span> <span class="hps">with</span> <span class="hps">a road map of</span> <span class="hps">Google</span>?</span><o:p></o:p></p></div><div><p class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;"><span lang="EN">Thanks</span><o:p></o:p></p></div></div><p class="MsoNormal"><o:p> </o:p></p></blockquote><p class="MsoNormal"><br><br><o:p></o:p></p><p class="MsoNormal" style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">No virus found in this message.<br>Checked by AVG - <a href="http://www.avg.com">www.avg.com</a><br>Version: 2015.0.5646 / Virus Database: 4273/9007 - Release Date: 01/27/15<o:p></o:p></p></div><br>
</blockquote><br>