<div dir="ltr">I'm trying to remove gaps and run the polygon dissolve by attribute plug-ins and receive the following error messages:<br><span style="font-family:arial,helvetica,sans-serif"><font size="2"><br></font></span><p style="margin:0px;text-indent:0px"><span style="font-family:arial,helvetica,sans-serif"><font size="2"><span style="color:rgb(169,169,169)">ERROR 1: Can't load requested DLL: C:\PROGRA~1\QGISPI~1\apps\saga\dll\gdal_MrSID.dll</span></font></span></p><span style="font-family:arial,helvetica,sans-serif"><font size="2">
</font></span><p style="margin:0px;text-indent:0px"><span style="font-family:arial,helvetica,sans-serif"><font size="2"><span style="color:rgb(169,169,169)">127: The specified procedure could not be found.</span></font></span></p><p style="margin:0px;text-indent:0px"><br><span style="font-family:"Courier New,courier";color:rgb(169,169,169)"></span></p>What's up?<br><div><div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><br><br></div></div></div>
<br><div class="gmail_quote">On Fri, Oct 23, 2015 at 9:54 AM, <span dir="ltr"><<a href="mailto:qgis-user-request@lists.osgeo.org" target="_blank">qgis-user-request@lists.osgeo.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send Qgis-user mailing list submissions to<br>
<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<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>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:qgis-user-request@lists.osgeo.org">qgis-user-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:qgis-user-owner@lists.osgeo.org">qgis-user-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Qgis-user digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Where is streets.shp? (Richard Duivenvoorde)<br>
2. Re: Where is streets.shp? (Randal Hale)<br>
3. Re: QGIS plugin with python (Richard Duivenvoorde)<br>
4. Re: Where is streets.shp? (Richard Duivenvoorde)<br>
5. Re: Where is streets.shp? (thuyphi)<br>
6. Retrieve the field "alias" from python api (Andrea Peri)<br>
7. Re: Retrieve the field "alias" from python api (Matthias Kuhn)<br>
8. Re: Geolocalisation automatically of about 70, 000 items (Tijan49)<br>
9. R: Re: Geolocalisation automatically of about 70, 000 items<br>
(<a href="mailto:labiancamarilena@libero.it">labiancamarilena@libero.it</a>)<br>
10. Re: QGIS plugin with python (Emilio S)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Fri, 23 Oct 2015 15:34:09 +0200<br>
From: Richard Duivenvoorde <<a href="mailto:rdmailings@duif.net">rdmailings@duif.net</a>><br>
To: thuyphi <<a href="mailto:thuy.phi@tceq.texas.gov">thuy.phi@tceq.texas.gov</a>>, <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] Where is streets.shp?<br>
Message-ID: <<a href="mailto:562A3751.9080101@duif.net">562A3751.9080101@duif.net</a>><br>
Content-Type: text/plain; charset=utf-8<br>
<br>
On 23-10-15 14:58, thuyphi wrote:<br>
> Nobody knows?<br>
> Thanks!<br>
<br>
Hi the course that you are pointing to was first hosted by Linfiniti/Tim<br>
but is now part of the official QGIS docs as 'QGIS Training Manual'.<br>
<br>
So please go to<br>
<br>
<a href="http://docs.qgis.org/2.8/en/docs/" rel="noreferrer" target="_blank">http://docs.qgis.org/2.8/en/docs/</a><br>
and<br>
<a href="http://docs.qgis.org/2.8/en/docs/training_manual/" rel="noreferrer" target="_blank">http://docs.qgis.org/2.8/en/docs/training_manual/</a><br>
<br>
and download the exercise data<br>
<br>
<a href="http://qgis.org/downloads/data/training_manual_exercise_data.zip" rel="noreferrer" target="_blank">http://qgis.org/downloads/data/training_manual_exercise_data.zip</a><br>
<br>
as stated here:<br>
<br>
<a href="http://docs.qgis.org/2.8/en/docs/training_manual/foreword/preparing_data.html#preparing-exercise-data" rel="noreferrer" target="_blank">http://docs.qgis.org/2.8/en/docs/training_manual/foreword/preparing_data.html#preparing-exercise-data</a><br>
<br>
I think it is renamed 'roads.shp' now.... so please follow the new<br>
updated training.<br>
<br>
Regards,<br>
<br>
Richard Duivenvoorde<br>
<br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Fri, 23 Oct 2015 09:35:33 -0400<br>
From: Randal Hale <<a href="mailto:rjhale@northrivergeographic.com">rjhale@northrivergeographic.com</a>><br>
To: <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] Where is streets.shp?<br>
Message-ID: <<a href="mailto:562A37A5.901@northrivergeographic.com">562A37A5.901@northrivergeographic.com</a>><br>
Content-Type: text/plain; charset=utf-8; format=flowed<br>
<br>
So I've never run through it - but if you grab the<br>
training_manual_exercise_data.zip there is a roads.shp under the<br>
epsg4326 directory.<br>
<br>
If you're on this training manual (there may be another) -<br>
<a href="http://docs.qgis.org/testing/en/docs/training_manual/introduction/preparation.html" rel="noreferrer" target="_blank">http://docs.qgis.org/testing/en/docs/training_manual/introduction/preparation.html</a><br>
- it references the roads in the previous sentence.<br>
<br>
I don't think your other email made it through the listserv - it happens<br>
upon occasion.<br>
<br>
Good luck - You can do it! I would encourage you though to grab the 2.10<br>
version - it's going to work infinitely better than the 1.8 version<br>
<br>
Randy<br>
<br>
<br>
<br>
<br>
<br>
On 10/23/2015 08:58 AM, thuyphi wrote:<br>
> Nobody knows?<br>
> Thanks!<br>
><br>
><br>
><br>
> --<br>
> View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Where-is-streets-shp-tp5231785p5232192.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/Where-is-streets-shp-tp5231785p5232192.html</a><br>
> Sent from the Quantum GIS - User mailing list archive at Nabble.com.<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>
<br>
--<br>
-----------------<br>
Randal Hale<br>
North River Geographic Systems, Inc<br>
<a href="http://www.northrivergeographic.com" rel="noreferrer" target="_blank">http://www.northrivergeographic.com</a><br>
<a href="tel:423.653.3611" value="+14236533611">423.653.3611</a> <a href="mailto:rjhale@northrivergeographic.com">rjhale@northrivergeographic.com</a><br>
twitter:rjhale <a href="http://about.me/rjhale" rel="noreferrer" target="_blank">http://about.me/rjhale</a><br>
<a href="http://www.northrivergeographic.com/introduction-to-quantum-gis" rel="noreferrer" target="_blank">http://www.northrivergeographic.com/introduction-to-quantum-gis</a><br>
Southeast OSGEO: <a href="http://wiki.osgeo.org/wiki/Southeast_US" rel="noreferrer" target="_blank">http://wiki.osgeo.org/wiki/Southeast_US</a><br>
<br>
<br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Fri, 23 Oct 2015 15:38:58 +0200<br>
From: Richard Duivenvoorde <<a href="mailto:rdmailings@duif.net">rdmailings@duif.net</a>><br>
To: Emilio S <<a href="mailto:emiliosjlc@hotmail.com">emiliosjlc@hotmail.com</a>>, <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] QGIS plugin with python<br>
Message-ID: <<a href="mailto:562A3872.4010704@duif.net">562A3872.4010704@duif.net</a>><br>
Content-Type: text/plain; charset=utf-8<br>
<br>
On 23-10-15 15:29, Worth Lutz wrote:<br>
> Google has been my friend. :)<br>
><br>
> Here are a few links to get you started.<br>
><br>
> <a href="http://doc.qt.io/qt-4.8/sql-connecting.html" rel="noreferrer" target="_blank">http://doc.qt.io/qt-4.8/sql-connecting.html</a><br>
> <a href="http://pyqt.sourceforge.net/Docs/PyQt4/index.html" rel="noreferrer" target="_blank">http://pyqt.sourceforge.net/Docs/PyQt4/index.html</a><br>
> <a href="http://pyqt.sourceforge.net/Docs/PyQt4/qsqldatabase.html" rel="noreferrer" target="_blank">http://pyqt.sourceforge.net/Docs/PyQt4/qsqldatabase.html</a><br>
> <a href="http://stackoverflow.com/questions/7669987/what-is-the-correct-way-of-qsqldatabase-qsqlquery" rel="noreferrer" target="_blank">http://stackoverflow.com/questions/7669987/what-is-the-correct-way-of-qsqldatabase-qsqlquery</a><br>
<br>
And as an addition: try to install some plugins which use spatialite<br>
too. Filter in the python plugin manager on 'spatialite'. All code is on<br>
you disk when you installed those, free to look and learn from it :-)<br>
<br>
Regards,<br>
<br>
Richard Duivenvoorde<br>
<br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Fri, 23 Oct 2015 15:40:22 +0200<br>
From: Richard Duivenvoorde <<a href="mailto:rdmailings@duif.net">rdmailings@duif.net</a>><br>
To: <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] Where is streets.shp?<br>
Message-ID: <<a href="mailto:562A38C6.4030302@duif.net">562A38C6.4030302@duif.net</a>><br>
Content-Type: text/plain; charset=utf-8<br>
<br>
On 23-10-15 15:35, Randal Hale wrote:<br>
> I don't think your other email made it through the listserv - it happens<br>
> upon occasion.<br>
<br>
Nope, indeed. I had to follow the Nabble link to find the initial post<br>
there :-)<br>
<br>
Richard<br>
<br>
<br>
------------------------------<br>
<br>
Message: 5<br>
Date: Fri, 23 Oct 2015 06:33:26 -0700 (PDT)<br>
From: thuyphi <<a href="mailto:thuy.phi@tceq.texas.gov">thuy.phi@tceq.texas.gov</a>><br>
To: <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] Where is streets.shp?<br>
Message-ID: <<a href="mailto:1445607206105-5232205.post@n6.nabble.com">1445607206105-5232205.post@n6.nabble.com</a>><br>
Content-Type: text/plain; charset=us-ascii<br>
<br>
Oh, so it's changed to roads.shp; though "roads" means the same as "streets,"<br>
why would it be changed? :-( Anyway, I found it! Thank you so much for<br>
your help!<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Where-is-streets-shp-tp5231785p5232205.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/Where-is-streets-shp-tp5231785p5232205.html</a><br>
Sent from the Quantum GIS - User mailing list archive at Nabble.com.<br>
<br>
<br>
------------------------------<br>
<br>
Message: 6<br>
Date: Fri, 23 Oct 2015 16:09:41 +0200<br>
From: Andrea Peri <<a href="mailto:aperi2007@gmail.com">aperi2007@gmail.com</a>><br>
To: qgis-user <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>><br>
Subject: [Qgis-user] Retrieve the field "alias" from python api<br>
Message-ID:<br>
<CABqTJk85UxEgyj3m7=<a href="mailto:2JgL_DJw2kOVX3rvvcegneAuV9JWB--Q@mail.gmail.com">2JgL_DJw2kOVX3rvvcegneAuV9JWB--Q@mail.gmail.com</a>><br>
Content-Type: text/plain; charset=UTF-8<br>
<br>
Hi,<br>
<br>
There is a property to retrieve the field Alias using python ?<br>
<br>
Thx.<br>
<br>
--<br>
-----------------<br>
Andrea Peri<br>
. . . . . . . . .<br>
qwerty àèìòù<br>
-----------------<br>
<br>
<br>
------------------------------<br>
<br>
Message: 7<br>
Date: Fri, 23 Oct 2015 16:17:32 +0200<br>
From: Matthias Kuhn <<a href="mailto:matthias@opengis.ch">matthias@opengis.ch</a>><br>
To: <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] Retrieve the field "alias" from python api<br>
Message-ID: <<a href="mailto:562A417C.3000106@opengis.ch">562A417C.3000106@opengis.ch</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
layer.attributeAlias(attriubteindex)<br>
<br>
Cheers<br>
<br>
On 10/23/2015 04:09 PM, Andrea Peri wrote:<br>
> Hi,<br>
><br>
> There is a property to retrieve the field Alias using python ?<br>
><br>
> Thx.<br>
><br>
<br>
<br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: signature.asc<br>
Type: application/pgp-signature<br>
Size: 819 bytes<br>
Desc: OpenPGP digital signature<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20151023/c503b745/attachment-0001.sig" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20151023/c503b745/attachment-0001.sig</a>><br>
<br>
------------------------------<br>
<br>
Message: 8<br>
Date: Fri, 23 Oct 2015 16:39:14 +0200<br>
From: Tijan49 <<a href="mailto:tijan49@yahoo.fr">tijan49@yahoo.fr</a>><br>
To: Maher GMAIL <<a href="mailto:geography1980@gmail.com">geography1980@gmail.com</a>>, Lewis Villierme<br>
<<a href="mailto:lewisvillierme@gmail.com">lewisvillierme@gmail.com</a>><br>
Cc: <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>, Nicolas Cadieux<br>
<<a href="mailto:nicolas.cadieux@archeotec.ca">nicolas.cadieux@archeotec.ca</a>><br>
Subject: Re: [Qgis-user] Geolocalisation automatically of about 70,<br>
000 items<br>
Message-ID: <<a href="mailto:562A4692.1060408@yahoo.fr">562A4692.1060408@yahoo.fr</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20151023/f91daf46/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20151023/f91daf46/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 9<br>
Date: Fri, 23 Oct 2015 18:07:53 +0200 (CEST)<br>
From: "<a href="mailto:labiancamarilena@libero.it">labiancamarilena@libero.it</a>" <<a href="mailto:labiancamarilena@libero.it">labiancamarilena@libero.it</a>><br>
To: <<a href="mailto:tijan49@yahoo.fr">tijan49@yahoo.fr</a>>, Maher GMAIL <<a href="mailto:geography1980@gmail.com">geography1980@gmail.com</a>>, Lewis<br>
Villierme <<a href="mailto:lewisvillierme@gmail.com">lewisvillierme@gmail.com</a>><br>
Cc: <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>, Nicolas Cadieux<br>
<<a href="mailto:nicolas.cadieux@archeotec.ca">nicolas.cadieux@archeotec.ca</a>><br>
Subject: [Qgis-user] R: Re: Geolocalisation automatically of about<br>
70, 000 items<br>
Message-ID:<br>
<2040477095.3266351445616473561.JavaMail.httpd@webmail-20.iol.local><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
<br>
Dear All,thanks a lot.I hope it will work!Thanks!<br>
<br>
<br>
<br>
<br>
----Messaggio originale----<br>
<br>
Da: <a href="mailto:tijan49@yahoo.fr">tijan49@yahoo.fr</a><br>
<br>
Data: 23/10/2015 16.39<br>
<br>
A: "Maher GMAIL"<<a href="mailto:geography1980@gmail.com">geography1980@gmail.com</a>>, "Lewis Villierme"<<a href="mailto:lewisvillierme@gmail.com">lewisvillierme@gmail.com</a>><br>
<br>
Cc: <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>>, "Nicolas Cadieux"<<a href="mailto:nicolas.cadieux@archeotec.ca">nicolas.cadieux@archeotec.ca</a>><br>
<br>
Ogg: Re: [Qgis-user] Geolocalisation automatically of about 70, 000 items<br>
<br>
<br>
<br>
<br>
<br>
<br>
Hi,<br>
<br>
if you are interested, i explained on my blog some time ago how<br>
to use the mmqgis geolocalisation tool ...<br>
<br>
<a href="http://insitusig.blogspot.fr/2013/11/essai-blog-pour-publication-des-astuces.html" rel="noreferrer" target="_blank">http://insitusig.blogspot.fr/2013/11/essai-blog-pour-publication-des-astuces.html</a><br>
<br>
<br>
<br>
It's in french, hope you can manage with it ...<br>
<br>
<br>
<br>
Jean<br>
<br>
<br>
<br>
Le 24/10/2015 00:29, Maher GMAIL a écrit :<br>
<br>
<br>
<br>
<br>
there is a plugin in Qgis todo the geolocalization:<br>
it is mmqgis<br>
i use it and it is good<br>
<br>
<br>
<br>
Le 23 oct. 2015 à 06:11, Lewis Villierme <<a href="mailto:lewisvillierme@gmail.com">lewisvillierme@gmail.com</a>><br>
a écrit :<br>
<br>
<br>
<br>
There is a main<br>
step beetwen an zip adress and a point on a map, it's<br>
the geocoding. The principle is mainly taking your<br>
adress and find the lat/long or X/Y conrresponding.<br>
After that you take those information and put them on a<br>
map following the Nicolas's steps.<br>
<br>
<br>
<br>
2015-10-23 14:51 GMT+02:00<br>
Nicolas Cadieux <<a href="mailto:nicolas.cadieux@archeotec.ca">nicolas.cadieux@archeotec.ca</a>>:<br>
<br>
<br>
Hi,<br>
<br>
You can easily match a zip code from the excel sheet<br>
with a zip code in a point file. Governments<br>
usually zip code files. Go to layer/property/joins.<br>
Nicolas Cadieux M.Sc.<br>
<br>
Les Entreprises Archéotec inc.<br>
<br>
8548, rue Saint-Denis Montréal H2P 2H2<br>
<br>
Téléphone: <a href="tel:514.381.5112" value="+15143815112">514.381.5112</a> Fax: <a href="tel:514.381.4995" value="+15143814995">514.381.4995</a><br>
<br>
<a href="http://www.archeotec.ca" rel="noreferrer" target="_blank">www.archeotec.ca</a><br>
On Oct 23, 2015 08:39, "[hidden<br>
email] [via OSGeo.org] " <[hidden<br>
email]> wrote:<br>
<br>
Dear All,<br>
I have a question.<br>
I have a spreadsheet (excel) with 70,000 rows<br>
where there are firms and their addresses and<br>
I'd like to geolocalize them.<br>
Is there a plugin or way to do their<br>
geolocalisation automatically?<br>
Thanks a lot<br>
Marilena<br>
<br>
<br>
_______________________________________________<br>
<br>
<br>
Qgis-user mailing list<br>
<br>
<br>
<a<br>
href="/user/SendEmail.jtp?type&#61;node&amp;node&#61;5232185&amp;i&#61;0">[hidden<br>
email]<br>
<br>
<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>
<br>
<br>
<br>
<br>
<br>
<br>
If you reply to<br>
this email, your message will be added to the<br>
discussion below:<br>
<a href="http://osgeo-org.1560.x6.nabble.com/Geolocalisation-automatically-of-about-70-000-items-tp5232185.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/Geolocalisation-automatically-of-about-70-000-items-tp5232185.html</a><br>
<br>
<br>
To start a new topic under Quantum GIS - User,<br>
email <a href="mailto:ml-node%2Bs1560n4125267h38@n6.nabble.com">ml-node+s1560n4125267h38@n6.nabble.com</a><br>
<br>
<br>
To unsubscribe from Quantum GIS - User, <a<br>
href="<a href="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" rel="noreferrer" 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<br>
here.<br>
<br>
<a href="<a href="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" rel="noreferrer" 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>"<br>
style="font:9px serif">NAML<br>
<br>
<br>
<br>
<br>
<br>
View this message in context: Re: Geolocalisation automatically of<br>
about 70,000 items<br>
<br>
Sent from the Quantum GIS - User mailing list<br>
archive at Nabble.com.<br>
<br>
<br>
<br>
_______________________________________________<br>
<br>
Qgis-user mailing list<br>
<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<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>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
--<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
<br>
Qgis-user mailing list<br>
<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<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>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<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>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20151023/c23a5f07/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20151023/c23a5f07/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 10<br>
Date: Fri, 23 Oct 2015 18:54:00 +0200<br>
From: Emilio S <<a href="mailto:emiliosjlc@hotmail.com">emiliosjlc@hotmail.com</a>><br>
To: "<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>" <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>><br>
Subject: Re: [Qgis-user] QGIS plugin with python<br>
Message-ID: <DUB130-W1703FC27C507B6B2E543B0D2260@phx.gbl><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Thank you and sorry.I have tried to connect to spatialite with this code, but this doesn´t add anything. Could you know why?<br>
<br>
from PyQt4.QtCore import *from PyQt4.QtGui import *uri=QgsDataSourceURI()uri.setDatabase('C:\Users\pr\Desktop\GIS.sqlite')schema=' 'table ='ambi'geom_column= 'geom'uri.setDataSource(schema, table, geom_column)display_name=('prueba')vlayer=QgsVectorLayer(uri.uri(), display_name, 'spatialite')<br>
<br>
Thanks<br>
<br>
Subject: Re: QGIS plugin with python<br>
To: <a href="mailto:emiliosjlc@hotmail.com">emiliosjlc@hotmail.com</a>; <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
From: <a href="mailto:wal3@mindspring.com">wal3@mindspring.com</a><br>
Date: Fri, 23 Oct 2015 09:29:13 -0400<br>
<br>
<br>
<br>
<br>
<br>
<br>
Emilio,<br>
<br>
<br>
<br>
Please reply to the QGIS users list so others will benefit from the<br>
discussion. :)<br>
<br>
<br>
<br>
Your next reading would probably be the QT4 and PyQt4 documentation<br>
for the SQL database classes.<br>
<br>
QT4 is the c++ version of the code.<br>
<br>
<br>
<br>
PyQt4 is the python wrappers around QT4.<br>
<br>
<br>
<br>
While you will be coding in python, the c++ documentation may be<br>
helpful and clearer to read.<br>
<br>
<br>
<br>
Google has been my friend. :)<br>
<br>
<br>
<br>
Here are a few links to get you started.<br>
<br>
<br>
<br>
<a href="http://doc.qt.io/qt-4.8/sql-connecting.html" rel="noreferrer" target="_blank">http://doc.qt.io/qt-4.8/sql-connecting.html</a><br>
<br>
<a href="http://pyqt.sourceforge.net/Docs/PyQt4/index.html" rel="noreferrer" target="_blank">http://pyqt.sourceforge.net/Docs/PyQt4/index.html</a><br>
<br>
<a href="http://pyqt.sourceforge.net/Docs/PyQt4/qsqldatabase.html" rel="noreferrer" target="_blank">http://pyqt.sourceforge.net/Docs/PyQt4/qsqldatabase.html</a><br>
<br>
<a href="http://stackoverflow.com/questions/7669987/what-is-the-correct-way-of-qsqldatabase-qsqlquery" rel="noreferrer" target="_blank">http://stackoverflow.com/questions/7669987/what-is-the-correct-way-of-qsqldatabase-qsqlquery</a><br>
<br>
<br>
<br>
I'm sorry don't have an example available at the moment. I cannot<br>
promise I'll find the time to put one together.<br>
<br>
<br>
<br>
Worth Lutz<br>
<br>
<br>
<br>
<br>
<br>
<br>
On 10/23/2015 8:47 AM, Emilio S wrote:<br>
<br>
<br>
<br>
<br>
Thank you Worth Luz for your explanation. I have<br>
started with this and I have read a lot, but do you know any<br>
example to conect python with spatialite and do a SQL query?<br>
<br>
<br>
<br>
Thank you again<br>
<br>
<br>
<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20151023/da57b943/attachment.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20151023/da57b943/attachment.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<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>
<br>
------------------------------<br>
<br>
End of Qgis-user Digest, Vol 116, Issue 41<br>
******************************************<br>
</blockquote></div><br></div></div></div></div>