[Qgis-user] Qgis-user Digest, Vol 127, Issue 72

Sat Oct 1 03:59:02 PDT 2016

Unsubscribe me from qgis
On Sep 30, 2016 1:10 PM, <qgis-user-request at lists.osgeo.org> wrote:

> Send Qgis-user mailing list submissions to
>         qgis-user at 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-request at lists.osgeo.org
>
> You can reach the person managing the list at
>         qgis-user-owner at 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.bertelli at gmail.com>
> To: qgis-user at lists.osgeo.org
> Subject: Re: [Qgis-user] QGIS 2.16 DB Manager and spatialite view
> Message-ID:
>         <CALc8-V+2-pQM+r7Vham0M7JfWiQQqS0gaig4LycDbtP
> jGJyqOw at 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 <enricofiore at libero.it>
> > To: QGIS User List <qgis-user at lists.osgeo.org>
> > Subject: [Qgis-user] QGIS 2.16 DB Manager and spatialite view
> > Message-ID:
> >         <360816939.108261475158045364.JavaMail.defaultUser at 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: bertelli at 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 <enricofiore at libero.it>
> To: <carlo.bertelli at gmail.com>,  <qgis-user at lists.osgeo.org>
> Subject: [Qgis-user] R: Re:  QGIS 2.16 DB Manager and spatialite view
> Message-ID:
>         <1788602857.264051475221321249.JavaMail.defaultUser at 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.bertelli at gmail.com>
>
> Data: 29/09/2016 23.30
>
> A: <qgis-user at 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 <enricofiore at libero.it>
>
> To: QGIS User List <qgis-user at lists.osgeo.org>
>
> Subject: [Qgis-user] QGIS 2.16 DB Manager and spatialite view
>
> Message-ID:
>
>         <360816939.108261475158045364.JavaMail.defaultUser at 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: bertelli at 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 <tim at qgis.org>
> To: QGIS Developer Mailing List <qgis-developer at lists.osgeo.org>, QGIS
>         Users <qgis-user at lists.osgeo.org>
> Subject: [Qgis-user] Last day for voting on grant proposals! Please
>         head    over and vote!
> Message-ID: <FCAE038D-EEBC-4117-AE76-96539FFD8224 at 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
> tim at 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.pierson at cnrs.fr>
> To: <qgis-user at lists.osgeo.org>
> Subject: [Qgis-user] DB Manager SQL window does not open
> Message-ID: <68383a0c-f8fa-2d1e-fef3-dc7732ea71b1 at 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 <martorell3588 at gmail.com>
> To: Luigi Pirelli <luipir at gmail.com>
> Cc: qgis-user ML <qgis-user at lists.osgeo.org>
> Subject: Re: [Qgis-user] Problem with properityes
> Message-ID: <a4c15296-c730-ba15-4367-12b9f37f4348 at 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"
> > <martorell3588 at gmail.com <mailto:martorell3588 at 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
> >>     <martorell3588 at 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
> >>>     <martorell3588 at 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 at 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 <luipir at gmail.com>
> To: Alejandro Martorell Reig <martorell3588 at gmail.com>
> Cc: qgis-user ML <qgis-user at 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 <
> martorell3588 at 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" <
> > martorell3588 at 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<
> martorell3588 at gmail.com> <martorell3588 at 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<
> martorell3588 at gmail.com> <martorell3588 at 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-user at 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 at 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
> ******************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20161001/98128259/attachment.html>