Unsubscribe me from qgis On Sep 30, 2016 1:10 PM, <qgis-user-requ...@lists.osgeo.org> wrote:
> Send Qgis-user mailing list submissions to > qgis-user@lists.osgeo.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.osgeo.org/mailman/listinfo/qgis-user > or, via email, send a message with subject or body 'help' to > qgis-user-requ...@lists.osgeo.org > > You can reach the person managing the list at > qgis-user-ow...@lists.osgeo.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Qgis-user digest..." > > > Today's Topics: > > 1. Re: QGIS 2.16 DB Manager and spatialite view > (Carlo A. Bertelli (Charta s.r.l.)) > 2. R: Re: QGIS 2.16 DB Manager and spatialite view (Enrico Fiore) > 3. Last day for voting on grant proposals! Please head over and > vote! (Tim Sutton) > 4. DB Manager SQL window does not open (Julie Pierson) > 5. Re: Problem with properityes (Alejandro Martorell Reig) > 6. Re: Problem with properityes (Luigi Pirelli) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 29 Sep 2016 23:30:20 +0200 > From: "Carlo A. Bertelli (Charta s.r.l.)" <carlo.berte...@gmail.com> > To: qgis-user@lists.osgeo.org > Subject: Re: [Qgis-user] QGIS 2.16 DB Manager and spatialite view > Message-ID: > <CALc8-V+2-pQM+r7Vham0M7JfWiQQqS0gaig4LycDbtP > jgjy...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Hello Enrico, > QGIS implements an older arrangement from the first version of Spatialite. > The views share metadata with tables in geometry_columns. > I think that QGIS should use the proper metadata table as well. It's time > to do it as Spatialite is at version 4 and the views_geometry_columns comes > from version 2.4 or so. Probably it could handle both metadata for > compatibility, after enforcing the wrong arrangement for years. > Anyhow, to solve your problem, just add an entry in geometry_columns. > c > > On Thu, Sep 29, 2016 at 9:00 PM, Enrico Fiore wrote: > > > Date: Thu, 29 Sep 2016 16:07:25 +0200 (CEST) > > From: Enrico Fiore <enricofi...@libero.it> > > To: QGIS User List <qgis-user@lists.osgeo.org> > > Subject: [Qgis-user] QGIS 2.16 DB Manager and spatialite view > > Message-ID: > > <360816939.108261475158045364.JavaMail.defaultUser@defaultHost> > > Content-Type: text/plain; charset="utf-8" > > > > Hi, > > > > I have created a database with spatialite_gui tool, the database has some > > spatial views created with a code like this > > > > CREATE VIEW comunitorino AS > > SELECT c.ROWID as rowid, c.cod_com, c.geometry > > from comuni c; > > > > INSERT INTO views_geometry_columns > > (view_name, view_geometry, view_rowid, f_table_name, > > f_geometry_column,read_only) > > VALUES ('comunitorino', 'geometry', 'rowid', 'comuni', 'geometry',1) > > > > The view can be load in QGIS by 'add spatialite layer' button > > > > The problem is that if I use DB Manager and open the DB the view will not > > be seen as spatial view. > > > > If I create the view in DB Manger with the "Create a view" button the > view > > will be seen as spatial view. > > > > Where is the mistake? > > > > Thanks > > > > Enrico > > > > -- > -------------------------------------------------------------------------- > Carlo A. Bertelli > Charta servizi e sistemi per il territorio e la storia ambientale srl > Dipendenze del palazzo Doria, > vc. alla Chiesa della Maddalena 9/2 16124 Genova (Italy) > tel./fax +39(0)10 2475439 +39 0108566195 gsm:+39 393 1590711 > e-mail: berte...@chartasrl.eu http://www.chartasrl.eu > -------------------------------------------------------------------------- > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.osgeo.org/pipermail/qgis-user/ > attachments/20160929/eaf51fc6/attachment-0001.html> > > ------------------------------ > > Message: 2 > Date: Fri, 30 Sep 2016 09:42:01 +0200 (CEST) > From: Enrico Fiore <enricofi...@libero.it> > To: <carlo.berte...@gmail.com>, <qgis-user@lists.osgeo.org> > Subject: [Qgis-user] R: Re: QGIS 2.16 DB Manager and spatialite view > Message-ID: > <1788602857.264051475221321249.JavaMail.defaultUser@defaultHost> > Content-Type: text/plain; charset="utf-8" > > Hi, > > thanks for the answer, now all work fine > > Enrico > > > > > > ----Messaggio originale---- > > Da: "Carlo A. Bertelli (Charta s.r.l.)" <carlo.berte...@gmail.com> > > Data: 29/09/2016 23.30 > > A: <qgis-user@lists.osgeo.org> > > Ogg: Re: [Qgis-user] QGIS 2.16 DB Manager and spatialite view > > > > Hello Enrico,QGIS implements an older arrangement from the first version > of Spatialite. The views share metadata with tables in geometry_columns.I > think that QGIS should use the proper metadata table as well. It's time to > do it as Spatialite is at version 4 and the views_geometry_columns comes > from version 2.4 or so. Probably it could handle both metadata for > compatibility, after enforcing the wrong arrangement for years.Anyhow, to > solve your problem, just add an entry in geometry_columns.c > > On Thu, Sep 29, 2016 at 9:00 PM, Enrico Fiore wrote: > Date: Thu, 29 Sep 2016 16:07:25 +0200 (CEST) > > From: Enrico Fiore <enricofi...@libero.it> > > To: QGIS User List <qgis-user@lists.osgeo.org> > > Subject: [Qgis-user] QGIS 2.16 DB Manager and spatialite view > > Message-ID: > > <360816939.108261475158045364.JavaMail.defaultUser@defaultHost> > > Content-Type: text/plain; charset="utf-8" > > > > Hi, > > > > I have created a database with spatialite_gui tool, the database has some > spatial views created with a code like this > > > > CREATE VIEW comunitorino AS > > SELECT c.ROWID as rowid, c.cod_com, c.geometry > > from comuni c; > > > > INSERT INTO views_geometry_columns > > (view_name, view_geometry, view_rowid, f_table_name, > f_geometry_column,read_only) > > VALUES ('comunitorino', 'geometry', 'rowid', 'comuni', 'geometry',1) > > > > The view can be load in QGIS by 'add spatialite layer' button > > > > The problem is that if I use DB Manager and open the DB the view will not > be seen as spatial view. > > > > If I create the view in DB Manger with the "Create a view" button the view > will be seen as spatial view. > > > > Where is the mistake? > > > > Thanks > > > > Enrico > > -- > -------------------------------------------------------------------------- > Carlo A. Bertelli > Charta servizi e sistemi per il territorio e la storia ambientale srl > Dipendenze del palazzo Doria, > vc. alla Chiesa della Maddalena 9/2 16124 Genova (Italy) > tel./fax +39(0)10 2475439 +39 0108566195 gsm:+39 393 1590711 > e-mail: berte...@chartasrl.eu http://www.chartasrl.eu > -------------------------------------------------------------------------- > > > > > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.osgeo.org/pipermail/qgis-user/ > attachments/20160930/0f1baa3e/attachment-0001.html> > > ------------------------------ > > Message: 3 > Date: Fri, 30 Sep 2016 11:27:17 +0200 > From: Tim Sutton <t...@qgis.org> > To: QGIS Developer Mailing List <qgis-develo...@lists.osgeo.org>, QGIS > Users <qgis-user@lists.osgeo.org> > Subject: [Qgis-user] Last day for voting on grant proposals! Please > head over and vote! > Message-ID: <fcae038d-eebc-4117-ae76-96539ffd8...@qgis.org> > Content-Type: text/plain; charset="utf-8" > > Hi All > > Just a reminder to all QGIS Voting Members (see full list below) to please > cast your votes for the 2016 Grant proposals. If your name is on this list, > you should have cast a vote but have not done so yet: > > The following have NOT YET voted: > > Nathan Woodrow > Larry Shaffer > Alexander Bruy > Regis Haubourg > Lene Fischer > Anibal Alarcon > Ross Bredie > Simon Miles > João Gaspar > Kevin Williams > Thomas Schüttenberg > > > The following have voted: > > Nyall Dawson > Brent Wood > Paolo Cavallini > Denis Rouzaud > Andreas Neumann > Matthias Kuhn > Jacolin > Giovanni Manghi > Werner Macho > Vincent Picavet > QGISBrasil community > Martin Dobias > Michael Smith > Kosuke ASAHI > Even Rouault > Milena Nowotarska > > If your name is on the 'NOT YET' list, please take a minute to cast your > vote! > > > > > --- > > Tim Sutton > QGIS Project Steering Committee Chair > t...@qgis.org > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.osgeo.org/pipermail/qgis-user/ > attachments/20160930/3422daef/attachment-0001.html> > -------------- next part -------------- > A non-text attachment was scrubbed... > Name: qgis_icon.jpg > Type: image/jpeg > Size: 4642 bytes > Desc: not available > URL: <http://lists.osgeo.org/pipermail/qgis-user/ > attachments/20160930/3422daef/attachment-0001.jpg> > > ------------------------------ > > Message: 4 > Date: Fri, 30 Sep 2016 11:36:20 +0200 > From: Julie Pierson <julie.pier...@cnrs.fr> > To: <qgis-user@lists.osgeo.org> > Subject: [Qgis-user] DB Manager SQL window does not open > Message-ID: <68383a0c-f8fa-2d1e-fef3-dc7732ea7...@cnrs.fr> > Content-Type: text/plain; charset="utf-8"; format=flowed > > Hi all, > > When I try to open the SQL window in DB Manager, I get this error : > AttributeError: 'SqlEdit' object has no attribute 'setMarginVisible' > I'm using Ubuntu 14.04. > > Here's the complete error message : > AttributeError: 'SqlEdit' object has no attribute 'setMarginVisible' > Traceback (most recent call last): > File "/usr/share/qgis/python/plugins/db_manager/db_manager.py", line > 194, in runSqlWindow > query = DlgSqlWindow(self.iface, db, self) > File "/usr/share/qgis/python/plugins/db_manager/dlg_sql_window.py", > line 73, in __init__ > self.editSql.setMarginVisible(True) > AttributeError: 'SqlEdit' object has no attribute 'setMarginVisible' > > Version de Python : 2.7.6 (default, Jun 22 2015, 18:01:27) [GCC 4.8.2] > Version de QGIS : 2.14.7-Essen Essen, exported > > Does anyone have the same problem ? Is it a known issue, or should I > open one ? > > Thanks ! > > Julie. > > > ------------------------------ > > Message: 5 > Date: Fri, 30 Sep 2016 11:52:25 +0200 > From: Alejandro Martorell Reig <martorell3...@gmail.com> > To: Luigi Pirelli <lui...@gmail.com> > Cc: qgis-user ML <qgis-user@lists.osgeo.org> > Subject: Re: [Qgis-user] Problem with properityes > Message-ID: <a4c15296-c730-ba15-4367-12b9f37f4...@gmail.com> > Content-Type: text/plain; charset="utf-8"; Format="flowed" > > Any idea?? Any solutions please? I need work with QGIS, but now Its > imposible. > > Thank you for all > > El 27/9/16 a las 9:42, Alejandro Martorell escribió: > > I installed new OSX Sierra 10.12, I can open properities now, but > > QGis is more unestable. For exemple, a lot of times I cant open old > > proyects or shapes, Qgis locked more times. > > > > What do you thing about this?? > > > > Alejandro Martorell > > > > > > > > > > On Mon, Sep 26, 2016 at 4:16 PM +0200, "Alejandro Martorell Reig" > > <martorell3...@gmail.com <mailto:martorell3...@gmail.com>> wrote: > > > > Versión de QGIS > > > > > > > > 2.16.2 > > > > > > > > Rama del código de QGIS > > > > > > > > Release 2.16 <https://github.com/qgis/QGIS/tree/release-2_16> > > > > Compilado contra Qt > > > > > > > > 4.8.6 > > > > > > > > Ejecutándose contra Qt > > > > > > > > 4.8.6 > > > > Compilado contra GDAL/OGR > > > > > > > > 2.1.1 > > > > > > > > Ejecutándose contra GDAL/OGR > > > > > > > > 2.1.1 > > > > Compilado contra GEOS > > > > > > > > 3.5.0-CAPI-1.9.0 > > > > > > > > Ejecutándose contra GEOS > > > > > > > > 3.5.0-CAPI-1.9.0 r0 > > > > Versión del cliente PostgreSQL > > > > > > > > 9.4.4 > > > > > > > > Versión de SpatiaLite > > > > > > > > 4.3.0a > > > > Versión de QWT > > > > > > > > 6.1.3 > > > > > > > > Versión de PROJ.4 > > > > > > > > 492 > > > > Versión de QScintilla2 > > > > > > > > 2.9.3 > > > > > > > > El 26/9/16 a las 15:02, Luigi Pirelli escribió: > >> cut& paste the content of qgis->help>about > >> Luigi Pirelli > >> > >> ************************************************************ > ************************************** > >> * Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT > com > >> * LinkedIn:https://www.linkedin.com/in/luigipirelli > >> * Stackexchange:http://gis.stackexchange.com/users/19667/ > luigi-pirelli > >> * GitHub:https://github.com/luipir > >> * Mastering QGIS: > >> https://www.packtpub.com/application-development/mastering-qgis > >> ************************************************************ > ************************************** > >> > >> > >> On 26 September 2016 at 14:22, Alejandro Martorell Reig > >> <martorell3...@gmail.com> wrote: > >>> Attache file wiht the error. > >>> > >>> Need more?? > >>> > >>> > >>> El 26/9/16 a las 13:35, Luigi Pirelli escribió: > >>> > >>> what OSX and share qgis->help->about list of loaded libs > >>> > >>> regards > >>> Luigi Pirelli > >>> > >>> ************************************************************ > ************************************** > >>> * Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT > com > >>> * LinkedIn:https://www.linkedin.com/in/luigipirelli > >>> * Stackexchange:http://gis.stackexchange.com/users/19667/ > luigi-pirelli > >>> * GitHub:https://github.com/luipir > >>> * Mastering QGIS: > >>> https://www.packtpub.com/application-development/mastering-qgis > >>> ************************************************************ > ************************************** > >>> > >>> > >>> On 26 September 2016 at 12:26, Alejandro Martorell Reig > >>> <martorell3...@gmail.com> wrote: > >>> > >>> Good Morning, > >>> > >>> I have a problem with QGIS long. Use mac. I have a lot of time and > I worked > >>> perfectly, from one day to another every time you try to open the > properties > >>> of a layer hangs and I have to close it, I can not change the > properties of > >>> the layers. It's annoying. I happened with the old version 2.14 and > >>> yesterday install the new version 2.16 and I still have the same > problem. > >>> The problem is something that I have in the pc that causes a > problem > >>> generated in the installation. I have installed the kingchaos > version and > >>> another. I do not know what to do. > >>> > >>> Como puedo entrar a lo que es el foro. No encuentro la dirección? > >>> > >>> Un saludo y gracias > >>> > >>> _______________________________________________ > >>> Qgis-user mailing list > >>> Qgis-user@lists.osgeo.org > >>> List info:http://lists.osgeo.org/mailman/listinfo/qgis-user > >>> Unsubscribe:http://lists.osgeo.org/mailman/listinfo/qgis-user > >>> > >>> > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.osgeo.org/pipermail/qgis-user/ > attachments/20160930/ef3f4576/attachment-0001.html> > > ------------------------------ > > Message: 6 > Date: Fri, 30 Sep 2016 12:09:25 +0200 > From: Luigi Pirelli <lui...@gmail.com> > To: Alejandro Martorell Reig <martorell3...@gmail.com> > Cc: qgis-user ML <qgis-user@lists.osgeo.org> > Subject: Re: [Qgis-user] Problem with properityes > Message-ID: > <CAFO80_qQF9HEPytznk1v-jAA7XD1KcVrkyf=FJ9wKUVjOHGRgg@ > mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > hard to say without sample data that create you the problem... to try to > fix, you should allow others to repeat the issue with replicable steps on > sample data. > > so your first step would be: > 1) create a reproducible set of steps that create the problem against > shareble data > 2) share you detailed configuration (OS data, how did you installed QGIS > and related packages... please add all details) > 3) ask if other in similar condition can replicate the problem > 4) try to do the same steps on another OSX laptop (or virtual machine) to > see if the problem can be replicated in a CLEAN install > > Luigi Pirelli > > ************************************************************ > ************************************** > * Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com > * LinkedIn: https://www.linkedin.com/in/luigipirelli > * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli > * GitHub: https://github.com/luipir > * Mastering QGIS: > https://www.packtpub.com/application-development/mastering-qgis > ************************************************************ > ************************************** > > On 30 September 2016 at 11:52, Alejandro Martorell Reig < > martorell3...@gmail.com> wrote: > > > Any idea?? Any solutions please? I need work with QGIS, but now Its > > imposible. > > > > Thank you for all > > El 27/9/16 a las 9:42, Alejandro Martorell escribió: > > > > I installed new OSX Sierra 10.12, I can open properities now, but QGis > is > > more unestable. For exemple, a lot of times I cant open old proyects or > > shapes, Qgis locked more times. > > > > What do you thing about this?? > > > > Alejandro Martorell > > > > > > > > > > On Mon, Sep 26, 2016 at 4:16 PM +0200, "Alejandro Martorell Reig" < > > martorell3...@gmail.com> wrote: > > > > Versión de QGIS > >> > >> 2.16.2 > >> > >> Rama del código de QGIS > >> > >> Release 2.16 <https://github.com/qgis/QGIS/tree/release-2_16> > >> > >> Compilado contra Qt > >> > >> 4.8.6 > >> > >> Ejecutándose contra Qt > >> > >> 4.8.6 > >> > >> Compilado contra GDAL/OGR > >> > >> 2.1.1 > >> > >> Ejecutándose contra GDAL/OGR > >> > >> 2.1.1 > >> > >> Compilado contra GEOS > >> > >> 3.5.0-CAPI-1.9.0 > >> > >> Ejecutándose contra GEOS > >> > >> 3.5.0-CAPI-1.9.0 r0 > >> > >> Versión del cliente PostgreSQL > >> > >> 9.4.4 > >> > >> Versión de SpatiaLite > >> > >> 4.3.0a > >> > >> Versión de QWT > >> > >> 6.1.3 > >> > >> Versión de PROJ.4 > >> > >> 492 > >> > >> Versión de QScintilla2 > >> > >> 2.9.3 > >> El 26/9/16 a las 15:02, Luigi Pirelli escribió: > >> > >> cut& paste the content of qgis->help>about > >> Luigi Pirelli > >> > >> ************************************************************ > ************************************** > >> * Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com > >> * LinkedIn: https://www.linkedin.com/in/luigipirelli > >> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli > >> * GitHub: https://github.com/luipir > >> * Mastering QGIS:https://www.packtpub.com/application-development/ > mastering-qgis > >> ************************************************************ > ************************************** > >> > >> > >> On 26 September 2016 at 14:22, Alejandro Martorell Reig< > martorell3...@gmail.com> <martorell3...@gmail.com> wrote: > >> > >> Attache file wiht the error. > >> > >> Need more?? > >> > >> > >> El 26/9/16 a las 13:35, Luigi Pirelli escribió: > >> > >> what OSX and share qgis->help->about list of loaded libs > >> > >> regards > >> Luigi Pirelli > >> > >> ************************************************************ > ************************************** > >> * Boundless QGIS Support/Development: lpirelli AT boundlessgeo DOT com > >> * LinkedIn: https://www.linkedin.com/in/luigipirelli > >> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli > >> * GitHub: https://github.com/luipir > >> * Mastering QGIS:https://www.packtpub.com/application-development/ > mastering-qgis > >> ************************************************************ > ************************************** > >> > >> > >> On 26 September 2016 at 12:26, Alejandro Martorell Reig< > martorell3...@gmail.com> <martorell3...@gmail.com> wrote: > >> > >> Good Morning, > >> > >> I have a problem with QGIS long. Use mac. I have a lot of time and I > worked > >> perfectly, from one day to another every time you try to open the > properties > >> of a layer hangs and I have to close it, I can not change the > properties of > >> the layers. It's annoying. I happened with the old version 2.14 and > >> yesterday install the new version 2.16 and I still have the same > problem. > >> The problem is something that I have in the pc that causes a problem > >> generated in the installation. I have installed the kingchaos version > and > >> another. I do not know what to do. > >> > >> Como puedo entrar a lo que es el foro. No encuentro la dirección? > >> > >> Un saludo y gracias > >> > >> _______________________________________________ > >> Qgis-user mailing listqgis-u...@lists.osgeo.org > >> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > >> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user > >> > >> > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <http://lists.osgeo.org/pipermail/qgis-user/ > attachments/20160930/fa11c568/attachment.html> > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user > > ------------------------------ > > End of Qgis-user Digest, Vol 127, Issue 72 > ****************************************** >
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
