<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 OSGeo.org] " <<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=node&node=5232185&i=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=unsubscribe_by_code&node&%2361;4125267&code&%2361;bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg&%2361;&%2361" target="_blank">http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==</a>;">click here.<br>
<a href="<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id&%2361;instant_html%21nabble%3Aemail.naml&base&%2361;nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&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=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=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 Nabble.com.<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"><div><img src="http://vlsigma.alwaysdata.net/images/Villierme%20Lewi.jpg" width="96" height="96"><br></div></div></div>
</div>