<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">there is a plugin in Qgis todo the geolocalization:<div>it is mmqgis </div><div>i use it and it is good</div><div> <br><div><div>Le 23 oct. 2015 à 06:11, Lewis Villierme <<a href="mailto:lewisvillierme@gmail.com">lewisvillierme@gmail.com</a>> a écrit :</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr"><div class="gmail_default" style="font-family:'arial narrow',sans-serif;font-size:large">​There is a main step beetwen ​an zip adress and a point on a map, it's the geocoding. The principle is mainly taking your adress and find the lat/long or X/Y conrresponding. After that you take those information and put them on a map following the Nicolas's steps. </div></div><div class="gmail_extra"><br><div class="gmail_quote">2015-10-23 14:51 GMT+02:00 Nicolas Cadieux <span dir="ltr"><<a href="mailto:nicolas.cadieux@archeotec.ca" target="_blank">nicolas.cadieux@archeotec.ca</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">Hi,<br>
You can easily match a zip code from the excel sheet with a zip code in a point file.  Governments usually zip code files.  Go to layer/property/joins.</p><p dir="ltr">Nicolas Cadieux M.Sc.<br>
Les Entreprises Archéotec inc. <br>
8548, rue Saint-Denis Montréal H2P 2H2<br>
Téléphone: <a href="tel:514.381.5112" value="+15143815112" target="_blank">514.381.5112</a>  Fax: <a href="tel:514.381.4995" value="+15143814995" target="_blank">514.381.4995</a><br>
<a href="http://www.archeotec.ca/" target="_blank">www.archeotec.ca</a></p>
<div class="gmail_quote">On Oct 23, 2015 08:39, "<a href="http:/user/SendEmail.jtp?type=node&node=5232188&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a> [via <a href="http://OSGeo.org">OSGeo.org</a>]  " <<a href="http:/user/SendEmail.jtp?type=node&node=5232188&i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a>> wrote:<br type="attribution"><blockquote style="border-left:2px solid #cccccc;padding:0 1em">

        <div></div><div>Dear All,</div><div>I have a question.</div><div>I have a spreadsheet (excel) with 70,000 rows where there are firms and their addresses and I'd like to geolocalize them.</div><div>Is there a plugin or way to do their geolocalisation automatically?</div><div>Thanks a lot</div><div>Marilena</div><br>_______________________________________________
<br>Qgis-user mailing list
<br><a href="/user/SendEmail.jtp?type&#61;node&amp;node&#61;5232185&amp;i&#61;0">[hidden email]
<br><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>

        
        
        
        <br>
        <br>
        <hr noshade="" size="1">
        <div style="color:#444;font:12px 'tahoma','geneva','helvetica','arial',sans-serif">
                <div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
                <a href="http://osgeo-org.1560.x6.nabble.com/Geolocalisation-automatically-of-about-70-000-items-tp5232185.html" rel="nofollow" link="external" target="_blank">http://osgeo-org.1560.x6.nabble.com/Geolocalisation-automatically-of-about-70-000-items-tp5232185.html</a>
        </div>
        <div style="color:#666;font:11px 'tahoma','geneva','helvetica','arial',sans-serif;margin-top:0.4em;line-height:1.5em">
                To start a new topic under Quantum GIS - User, email <a href="mailto:ml-node%2Bs1560n4125267h38@n6.nabble.com" target="_blank">ml-node+s1560n4125267h38@n6.nabble.com</a> <br>
                To unsubscribe from Quantum GIS - User, <a href="<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro&#61;unsubscribe_by_code&amp;node&%2361;4125267&amp;code&%2361;bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg&%2361;&%2361" target="_blank">http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro&#61;unsubscribe_by_code&amp;node&#61;4125267&amp;code&#61;bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg&#61;&#61</a>;">click here.<br>
                <a href="<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro&#61;macro_viewer&amp;id&%2361;instant_html%21nabble%3Aemail.naml&amp;base&%2361;nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&amp;breadcrumbs&%2361;notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" target="_blank">http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro&#61;macro_viewer&amp;id&#61;instant_html%21nabble%3Aemail.naml&amp;base&#61;nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&amp;breadcrumbs&#61;notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml</a>" style="font:9px serif">NAML
        </div></blockquote></div>

        
        
        
<br><hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Geolocalisation-automatically-of-about-70-000-items-tp5232185p5232188.html" target="_blank">Re: Geolocalisation automatically of about 70,000 items</a><br>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html" target="_blank">Quantum GIS - User mailing list archive</a> at <a href="http://Nabble.com">Nabble.com</a>.<br><br>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><img src="http://vlsigma.alwaysdata.net/images/Villierme%20Lewi.jpg" width="96" height="96"><br></div></div>
</div>
_______________________________________________<br>Qgis-user mailing list<br><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>http://lists.osgeo.org/mailman/listinfo/qgis-user</blockquote></div><br></div></body></html>