<div></div><div>Dear Phil, </div><div>great!</div><div>Thanks a lot!</div><div>It's a fantastic plugin, but are there videos or other sources for the best use of this plugin? </div><div>Thanks a lot</div><div>Marilena <br>
<br>
</div><blockquote>
----Messaggio originale----<br>
Da: phil@wyatt-family.com<br>
Data: 26/01/2015 23.51<br>
A: <labiancamarilena@libero.it>, <qgis-user@lists.osgeo.org><br>
Ogg: 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;}
span.hps
        {mso-style-name:hps;}
span.jfk-button-img
        {mso-style-name:jfk-button-img;}
span.EmailStyle19
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.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;'>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.<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;'> qgis-user-bounces@lists.osgeo.org [mailto:qgis-user-bounces@lists.osgeo.org] <b>On Behalf Of </b>labiancamarilena@libero.it<br><b>Sent:</b> Tuesday, 27 January 2015 2:20 AM<br><b>To:</b> qgis-user@lists.osgeo.org<br><b>Subject:</b> [Qgis-user] (no subject)<o:p></o:p></span></p><p class="MsoNormal"><o:p> </o:p></p><div><p class="MsoNormal"><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"><span lang="EN">Thanks</span><o:p></o:p></p></div></div><br>
</blockquote><br>