Re: [Qgis-user] error on make install

[Radim Blazek]

On Thu, Nov 12, 2015 at 6:13 PM, Eugenio Trumpy  wrote:
> Hi,
>
> after Qgis compilation (2.13.0 master) I have no error on make,
> but errors on make install:
>
> collect2: error: ld returned 1 exit status
> src/providers/grass/7/CMakeFiles/qgis.r.in7.dir/build.make:164: recipe for
> target 'src/providers/grass/7/CMakeFiles/CMakeRelink.dir/qgis.r.in7' failed
> make[2]: *** [src/providers/grass/7/CMakeFiles/CMakeRelink.dir/qgis.r.in7]
> Error 1
> CMakeFiles/Makefile2:2678: recipe for target
> 'src/providers/grass/7/CMakeFiles/qgis.r.in7.dir/preinstall' failed
> make[1]: *** [src/providers/grass/7/CMakeFiles/qgis.r.in7.dir/preinstall]
> Error 2
> Makefile:152: recipe for target 'preinstall' failed
> make: *** [preinstall] Error 2

It looks like if qgis.r.in7 was not compiled, try to go to
src/providers/grass/7 and run make there.

Radim


> any suggestions?
>
> E.
>
> ___
> 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
___
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

Re: [Qgis-user] coordinate conversion

[Nicolas Cadieux]

Hi, 
That all depends, I guess on what version of WGS 84  datum the software 
uses to calculate the conversion.   Most softwares don't  even 
make a difference between wgs 84 and NAD 83.  I would look at the 
conversion parameters carefully.  Generally speaking, I would go with the 
governmental product as they must have a better control over stuff like GPS 
time and Continental drift... 
Nicolas Cadieux M.Sc. 
Les Entreprises Archéotec inc.  
8548, rue Saint-Denis Montréal H2P 2H2 
Téléphone: 514.381.5112  Fax: 514.381.4995 
www.archeotec.ca 
On Nov 12, 2015 13:01, "francesco_lucca [via OSGeo.org]" 
 wrote: 

Hi,
I have a point in WGS84 UTM32 coordinate
E 589747.816
N 4871699.496
I saved in EPSG 3003 with the following coordinates:
E 1589776.553
N 4871716.117
A colleague made the same conversion using free software "traspunto" ( 
http://www.mondogis.com/traspunto.html ) developed by the Italian Enviromental 
Ministry. He got this result (EPSG 3003 coordinates):
E 1589776.054
N 4871716.382
I try another online tool ( 
http://www.sardegnageoportale.it/webgis/raswebconverter/index?stato_quale=punto
 ) and I found these EPSG3003 coordinates:
E 1589776.554
N 4871716.119
Summary: QGIS and sardegnageoportale seem to give the same results, traspunto 
is different (0.50 meter difference). Which is the correct result? Where can I 
found the calculation for the conversion from a system to another?
Thanks
Francesco 








If you reply to this email, your message will be added to the 
discussion below: 

http://osgeo-org.1560.x6.nabble.com/coordinate-conversion-tp5236051.html 


To start a new topic under Quantum GIS - User, email 
ml-node+s1560n4125267h38@n6.nabble.com 
To unsubscribe from Quantum GIS - User, click here . 
NAML 




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/coordinate-conversion-tp5236051p5236126.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.___
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

Re: [Qgis-user] columns in spatialite

[Matthias Kuhn]

On 11/12/2015 07:25 PM, Alex M wrote:
> SQLite stores the geometries differently than Spatialite.
> http://www.gdal.org/drv_sqlite.html
> FORMAT=WKB/WKT/SPATIALITE
>
> Biggest side effect I can think of is that you can't use the spatialite
> query mechanisms on WKB/WKT without converting. Which includes spatial
> indexes (not sure anything in QGIS utilizes these currently). I'm also
An index will make a difference when you make a select with a bounding
box like it's done with every repaint.

> not sure that SQLite files via OGR are even editable (never tried). If I
> recall QGIS has a spatialite driver built in and does not use the OGR
> one in order to access more of the features.
>
> I'm sure someone else will know more.
>
> -Alex
>
> On 11/12/2015 10:17 AM, Bernd Vogelgesang wrote:
>> Am 12.11.2015, 17:49 Uhr, schrieb Andrea Peri :
>>
>>> You need study better the spatialite formats.
>>> :)
>>>
>>> Also the shapefile format and also the geopackage format.
>>> So you will be able to understand why spatialite is 4mb and other not.
>>>
>>> :))
>>>
>>> A.
>>>
>> Well, this time I didn't refer to the difference between GeoPackage and
>> SpatiaLite, but between what is called "spatialite" and "sqlite" in the
>> Save as .. dialog in QGIS.
>>
>> The sqlite files are really small. For normal work where people do not
>> need to set up views or whatever db internal stuff,  but just want to
>> get intermediate results while working with data, and have long column
>> names and unrestricted field lengths, those sqlite files seem to be so
>> much better usable than standard ESRI shapes.
>>
>> So again, what would be the caveats using this small sqlite stuff as
>> default? (Besides the column resorting/renaming stuff for which
>> workarounds/fixes see to be available)?
>>
>> Cheers
>> Bernd
>>
>>
>>
>>> Example: a shapefile point layer with quite some attributes and 999
 features
 has 4.4 MB
 saving this as spatialiate: 4.6 MB
 saving as sqlite: 86 kB !

 The sqlite file is 5 times smaller than the ESRI shape file while the
 spatialite file is about the same as the shape.

 Here on 2.8.3 at the office I have no geopackage option to test with.

 So, whats the difference between sqlite and spatialite in detail?

 Cheers
 Bernd





>>
> ___
> 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

-- 
Matthias Kuhn
OPENGIS.ch - https://www.opengis.ch
Spatial • (Q)GIS • PostGIS • Open Source

___
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

Re: [Qgis-user] Action definition for features highlight in other layer.

[Fernando M. Roxo da Motta]

On Thu, 12 Nov 2015 18:56:28 -0200, "Fernando M. Roxo da Motta"
 wrote:

  Again answering myself hoping to be useful to someone.

  I was able to do what I wanted creating an action for the Src layer
with the code:


import processing
processing.runalg('qgis:selectbyexpression','RcvPoints','abs("XCoor"-[%"XCoor"%])<=3900
and abs("YCoor"-[%"YCoor"%] )<=3287',0)

  It can look confuse at first for newbies (like myself) the fact that
there are many "XCoor" and "YCoor" spread all along.  In this case both
layers have the same attributes, they are very similar.

The 'qgis:selectbyexpression' is a processing algorithm that have the
following description:


processing.runalg('qgis:selectbyexpression', layername,
expression,method)

  The layer name is the 'RcvPoints'.
  The method is : 0 (create a new selection)

  The expression is : abs("Xr"-"Xs")<=3900 and abs("Yr"-"Ys")<=3287

  Where appears "XCoor" above refers to layer 'RcvPoints'.
  Where appears [%"XCoor"%] refers to "XCoor" of current layer.


  One last info, I have tried this with the original SRC, tried using
EPSG:3857 (pseudo mercartor), and WGS84 (OTF on) without any problem.

  Worked like a charm.

  Hope this can be of use to someone.


  By the way, about that problem with the decimal point reported
before, I have tried to use it in the action expression and the same
error popped out, that is why there is no decimal point above.

  Sds.



> On Thu, 12 Nov 2015 14:11:19 -0200, "Fernando M. Roxo da Motta"
>  wrote:
> 
>   Once again I am answering myself.
> 
>   I played a little bit with the "select using an expression" on the
> Recs layer.  I used (just an example) :
> 
> abs(  "XCoor"  - 813040. ) <= 3900. and
> abs(  "YCoor"  - 8886265. ) <= 3287.
> 
> And I got an error :
> 
> Parser Error:
> syntax error, unexpected Unknown_CHARACTER, expecting COMMA or ')'
> 
> Eval Error:
> No root node! Parsing failed?
> 
> After a lot of editing and all kind of guesswork I found that the
> problem were with the decimal points!   In order to make the
> expression work I had to rewrite as:
> 
> abs(  "XCoor"  - 813040 ) <= 3900 and
> abs(  "YCoor"  - 8886265 ) <= 3287
> 
>   Both "XCoor" and "YCoor" are floating point coordinates.  I thought
> that it could be something related to the l11n and that I should use
> a decimal comma in place of decimal point.  No, the error kept popping
> out.   Finally to isolate the l11n I started Qgis as:
> 
> $  LC_ALL=C  qgis
> 
>   The error remained the same, the only way to use the expression was
> removing the decimal points.
> 
>   Is it a "undocumented feature" (aka bug) or can it be something in
> my configuration/installation?
> 
>   I am using Qgis 2.12.0-Lyon on Xubuntu 12.04 64 bits.
> 
> 
>   Sds.
> 
> > 
> > 
> >   Hi all,
> > 
> > 
> >   I am attaching a small jpeg image in the hope that the list allow
> > it.  All descriptions bellow are based on this image.
> > 
> >   As (hopefully) can be seen I have two point layers, the green ones
> > called Recs and the red ones called Src. 
> > 
> >   To each Src point there is a subset of the Recs related based on a
> > rectangle, that  is all Recs inside a rectangle centred at the Src
> > will be activated when that particular Src is activated.  This is
> > the only relation and, of course, the rectangle of a Src point will
> > share some Recs from other nearby Src, but it is not a problem as
> > each Src is activated separately.
> > 
> >   Hope this is not too confuse.
> > 
> >   Now my question, is there a way to define an action so that when I
> > click a Src point all related Recs be highlighted?   Can be a
> > selection or whatever other suitable method.
> > 
> >   Thanks in advance.
> > 
> > 
> >   Roxo
> > 
> 
> 
> 
> 
> 
> 
> 
> 
>   Roxo
> 








  Roxo

-- 
 Non luctari, ludare ---+ WYSIWYG
Fernando M. Roxo da Motta   | Editor?
Except where explicitly stated I speak on my own behalf.|  VI !!
  ( Usuário Linux registrado #39505 )   | I see text,
 Quis custodiet ipsos custodes?-+ I get text!
 
___
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

Re: [Qgis-user] Action definition for features highlight in other layer.

[Fernando M. Roxo da Motta]

On Thu, 12 Nov 2015 14:11:19 -0200, "Fernando M. Roxo da Motta"
 wrote:

  Once again I am answering myself.

  I played a little bit with the "select using an expression" on the
Recs layer.  I used (just an example) :

abs(  "XCoor"  - 813040. ) <= 3900. and
abs(  "YCoor"  - 8886265. ) <= 3287.

And I got an error :

Parser Error:
syntax error, unexpected Unknown_CHARACTER, expecting COMMA or ')'

Eval Error:
No root node! Parsing failed?

After a lot of editing and all kind of guesswork I found that the
problem were with the decimal points!   In order to make the expression
work I had to rewrite as:

abs(  "XCoor"  - 813040 ) <= 3900 and
abs(  "YCoor"  - 8886265 ) <= 3287

  Both "XCoor" and "YCoor" are floating point coordinates.  I thought
that it could be something related to the l11n and that I should use
a decimal comma in place of decimal point.  No, the error kept popping
out.   Finally to isolate the l11n I started Qgis as:

$  LC_ALL=C  qgis

  The error remained the same, the only way to use the expression was
removing the decimal points.

  Is it a "undocumented feature" (aka bug) or can it be something in my
configuration/installation?

  I am using Qgis 2.12.0-Lyon on Xubuntu 12.04 64 bits.


  Sds.

> 
> 
>   Hi all,
> 
> 
>   I am attaching a small jpeg image in the hope that the list allow
> it.  All descriptions bellow are based on this image.
> 
>   As (hopefully) can be seen I have two point layers, the green ones
> called Recs and the red ones called Src. 
> 
>   To each Src point there is a subset of the Recs related based on a
> rectangle, that  is all Recs inside a rectangle centred at the Src
> will be activated when that particular Src is activated.  This is the
> only relation and, of course, the rectangle of a Src point will share
> some Recs from other nearby Src, but it is not a problem as each Src
> is activated separately.
> 
>   Hope this is not too confuse.
> 
>   Now my question, is there a way to define an action so that when I
> click a Src point all related Recs be highlighted?   Can be a
> selection or whatever other suitable method.
> 
>   Thanks in advance.
> 
> 
>   Roxo
> 








  Roxo

-- 
 Non luctari, ludare ---+ WYSIWYG
Fernando M. Roxo da Motta   | Editor?
Except where explicitly stated I speak on my own behalf.|  VI !!
  ( Usuário Linux registrado #39505 )   | I see text,
 Quis custodiet ipsos custodes?-+ I get text!
 
___
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

Re: [Qgis-user] columns in spatialite

[Even Rouault]

Le jeudi 12 novembre 2015 19:25:20, Alex M a écrit :
> SQLite stores the geometries differently than Spatialite.
> http://www.gdal.org/drv_sqlite.html
> FORMAivT=WKB/WKT/SPATIALITE
> 
> Biggest side effect I can think of is that you can't use the spatialite
> query mechanisms on WKB/WKT without converting. Which includes spatial
> indexes (not sure anything in QGIS utilizes these currently). I'm also
> not sure that SQLite files via OGR are even editable (never tried). If I
> recall QGIS has a spatialite driver built in and does not use the OGR
> one in order to access more of the features.

The OGR spatialite driver has editing capabilities (when linked against 
libspatialite, otherwise read-only), as well as use of spatial indices. I'm 
not sure which capabilities the QGIS builtin spatialite driver would have in 
addition. I guess the existence of both is more due to historical reasons than 
technical ones.

> 
> I'm sure someone else will know more.
> 
> -Alex
> 
> On 11/12/2015 10:17 AM, Bernd Vogelgesang wrote:
> > Am 12.11.2015, 17:49 Uhr, schrieb Andrea Peri :
> >> You need study better the spatialite formats.
> >> 
> >> :)
> >> 
> >> Also the shapefile format and also the geopackage format.
> >> So you will be able to understand why spatialite is 4mb and other not.
> >> 
> >> :))
> >> 
> >> A.
> > 
> > Well, this time I didn't refer to the difference between GeoPackage and
> > SpatiaLite, but between what is called "spatialite" and "sqlite" in the
> > Save as .. dialog in QGIS.
> > 
> > The sqlite files are really small. For normal work where people do not
> > need to set up views or whatever db internal stuff,  but just want to
> > get intermediate results while working with data, and have long column
> > names and unrestricted field lengths, those sqlite files seem to be so
> > much better usable than standard ESRI shapes.
> > 
> > So again, what would be the caveats using this small sqlite stuff as
> > default? (Besides the column resorting/renaming stuff for which
> > workarounds/fixes see to be available)?
> > 
> > Cheers
> > Bernd
> > 
> >> Example: a shapefile point layer with quite some attributes and 999
> >> 
> >>> features
> >>> has 4.4 MB
> >>> saving this as spatialiate: 4.6 MB
> >>> saving as sqlite: 86 kB !
> >>> 
> >>> The sqlite file is 5 times smaller than the ESRI shape file while the
> >>> spatialite file is about the same as the shape.
> >>> 
> >>> Here on 2.8.3 at the office I have no geopackage option to test with.
> >>> 
> >>> So, whats the difference between sqlite and spatialite in detail?
> >>> 
> >>> Cheers
> >>> Bernd
> 
> ___
> 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

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com
___
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

Re: [Qgis-user] coordinate conversion

[Alex M]

Datum Transformation might be a reason. Different implementations of the
calculation could also account for it.
https://trac.osgeo.org/gdal/wiki/FAQCoordinateSystemsAndProjections#WhydoesntGDALautomaticallychoosethedatumtransformation
https://github.com/OSGeo/proj.4/wiki
https://github.com/OSGeo/proj.4/wiki/GenParms (Datum Transformations)

There is always some accuracy/precision loss reprojecting too.

Which UTM Zone 32 proj did you use?

If you really want to see the code, it's in the PROJ4 project.

Enjoy,
Alex

On 11/12/2015 10:01 AM, francesco_lucca wrote:
> Hi,
> I have a point in WGS84 UTM32 coordinate
> 
> E 589747.816
> N 4871699.496
> 
> I saved in EPSG 3003 with the following coordinates:
> 
> E 1589776.553
> N 4871716.117
> 
> A colleague made the same conversion using free software "traspunto"
> (http://www.mondogis.com/traspunto.html) developed by the Italian
> Enviromental Ministry. He got this result (EPSG 3003 coordinates):
> 
> E 1589776.054
> N 4871716.382
> 
> I try another online tool
> (http://www.sardegnageoportale.it/webgis/raswebconverter/index?stato_quale=punto)
> and I found these EPSG3003 coordinates:
> 
> E 1589776.554
> N 4871716.119
> 
> Summary: QGIS and sardegnageoportale seem to give the same results,
> traspunto is different (0.50 meter difference). Which is the correct result?
> Where can I found the calculation for the conversion from a system to
> another?
> 
> Thanks
> 
> Francesco 
> 
> 
> 
> --
> View this message in context: 
> http://osgeo-org.1560.x6.nabble.com/coordinate-conversion-tp5236051.html
> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
> ___
> 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
> 

___
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

Re: [Qgis-user] columns in spatialite

[Alex M]

SQLite stores the geometries differently than Spatialite.
http://www.gdal.org/drv_sqlite.html
FORMAT=WKB/WKT/SPATIALITE

Biggest side effect I can think of is that you can't use the spatialite
query mechanisms on WKB/WKT without converting. Which includes spatial
indexes (not sure anything in QGIS utilizes these currently). I'm also
not sure that SQLite files via OGR are even editable (never tried). If I
recall QGIS has a spatialite driver built in and does not use the OGR
one in order to access more of the features.

I'm sure someone else will know more.

-Alex

On 11/12/2015 10:17 AM, Bernd Vogelgesang wrote:
> Am 12.11.2015, 17:49 Uhr, schrieb Andrea Peri :
> 
>> You need study better the spatialite formats.
>> :)
>>
>> Also the shapefile format and also the geopackage format.
>> So you will be able to understand why spatialite is 4mb and other not.
>>
>> :))
>>
>> A.
>>
> 
> Well, this time I didn't refer to the difference between GeoPackage and
> SpatiaLite, but between what is called "spatialite" and "sqlite" in the
> Save as .. dialog in QGIS.
> 
> The sqlite files are really small. For normal work where people do not
> need to set up views or whatever db internal stuff,  but just want to
> get intermediate results while working with data, and have long column
> names and unrestricted field lengths, those sqlite files seem to be so
> much better usable than standard ESRI shapes.
> 
> So again, what would be the caveats using this small sqlite stuff as
> default? (Besides the column resorting/renaming stuff for which
> workarounds/fixes see to be available)?
> 
> Cheers
> Bernd
> 
> 
> 
>> Example: a shapefile point layer with quite some attributes and 999
>>> features
>>> has 4.4 MB
>>> saving this as spatialiate: 4.6 MB
>>> saving as sqlite: 86 kB !
>>>
>>> The sqlite file is 5 times smaller than the ESRI shape file while the
>>> spatialite file is about the same as the shape.
>>>
>>> Here on 2.8.3 at the office I have no geopackage option to test with.
>>>
>>> So, whats the difference between sqlite and spatialite in detail?
>>>
>>> Cheers
>>> Bernd
>>>
>>>
>>>
>>>
>>>
> 
> 

___
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

Re: [Qgis-user] columns in spatialite

[Bernd Vogelgesang]

Am 12.11.2015, 17:49 Uhr, schrieb Andrea Peri :


You need study better the spatialite formats.
:)

Also the shapefile format and also the geopackage format.
So you will be able to understand why spatialite is 4mb and other not.

:))

A.



Well, this time I didn't refer to the difference between GeoPackage and  
SpatiaLite, but between what is called "spatialite" and "sqlite" in the  
Save as .. dialog in QGIS.


The sqlite files are really small. For normal work where people do not  
need to set up views or whatever db internal stuff,  but just want to get  
intermediate results while working with data, and have long column names  
and unrestricted field lengths, those sqlite files seem to be so much  
better usable than standard ESRI shapes.


So again, what would be the caveats using this small sqlite stuff as  
default? (Besides the column resorting/renaming stuff for which  
workarounds/fixes see to be available)?


Cheers
Bernd




Example: a shapefile point layer with quite some attributes and 999

features
has 4.4 MB
saving this as spatialiate: 4.6 MB
saving as sqlite: 86 kB !

The sqlite file is 5 times smaller than the ESRI shape file while the
spatialite file is about the same as the shape.

Here on 2.8.3 at the office I have no geopackage option to test with.

So, whats the difference between sqlite and spatialite in detail?

Cheers
Bernd








--
Bernd Vogelgesang
Siedlerstraße 2
91083 Baiersdorf/Igelsdorf
Tel: 09133-825374
___
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

[Qgis-user] coordinate conversion

[francesco_lucca]

Hi,
I have a point in WGS84 UTM32 coordinate

E 589747.816
N 4871699.496

I saved in EPSG 3003 with the following coordinates:

E 1589776.553
N 4871716.117

A colleague made the same conversion using free software "traspunto"
(http://www.mondogis.com/traspunto.html) developed by the Italian
Enviromental Ministry. He got this result (EPSG 3003 coordinates):

E 1589776.054
N 4871716.382

I try another online tool
(http://www.sardegnageoportale.it/webgis/raswebconverter/index?stato_quale=punto)
and I found these EPSG3003 coordinates:

E 1589776.554
N 4871716.119

Summary: QGIS and sardegnageoportale seem to give the same results,
traspunto is different (0.50 meter difference). Which is the correct result?
Where can I found the calculation for the conversion from a system to
another?

Thanks

Francesco 



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/coordinate-conversion-tp5236051.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
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

Re: [Qgis-user] ArcGIS & QGIS (Nicolas Cadieux)

[Chris House]

Thanks Nicolas,

I am surprised that there isn't more work being done in this arena.  I am
in the U.S. and ESRI has vendor locked the federal, most state, and most
county governments.  There are FEW exceptions to this in the federal
level.  Unfortunately, my clients just don't deal in web based solutions
(in some cases impossible due to locale) but when you are talking about
printed publications (informational posters, pamphlets, etc ) the need to
share data and projects is a necessity.

--Chris

On Thu, Nov 12, 2015 at 10:47 AM,  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: columns in spatialite (Neumann, Andreas)
>2. Re: ArcGIS & QGIS (Nicolas Cadieux)
>3. Re: ArcGIS & QGIS (Neumann, Andreas)
>4. Re: ArcGIS & QGIS (Chris House)
>5. Re: columns in spatialite (Paulo van Breugel)
>6. Re: columns in spatialite (Neumann, Andreas)
>7. Re: columns in spatialite (Paulo van Breugel)
>8. Importing image to Print Composer (Simon Crombie)
>9. Re: Importing image to Print Composer (DelazJ)
>
>
> --
>
> Message: 1
> Date: Thu, 12 Nov 2015 14:51:28 +0100
> From: "Neumann, Andreas" 
> To: Matthias Kuhn 
> Cc: Paulo van Breugel , QGIS user email list
> 
> Subject: Re: [Qgis-user] columns in spatialite
> Message-ID: 
> Content-Type: text/plain; charset="utf-8"
>
>
>
> Hi,
>
> I would prefer if we could concentrate on Geopackage. Geopackage is now
> an OGC format and should be (at least in theory) better supported in
> other (proprietary) GIS than SpatiaLite.
>
> Andreas
>
> On 2015-11-12 13:30, Matthias Kuhn wrote:
>
> > The main issues with spatialite are IMO: It's based on sqlite so
> > deleting columns and renaming columns is not supported by design. We
> > could offer some hacks to bypass this (annoying restriction) from the UI
> > - there is a risk of side effects though. Another property of it is,
> > that it's already 4-5MB big, even when empty. I consider this a major
> > limiting factor as well. Other issues which we were not yet able to
> > solve are its management of the information scheme which keep duplicate
> > entries of tables and columns which need to be properly updated which we
> > apparently do not manage (yet).
> >
> > Geopackage is also based on sqlite, so the column delete/rename
> > restrictions apply as well (with the same workaround possibilities). I
> > haven't checked the file size, but if that's smaller, that would be
> > quite nice (does somebody know?).
> >
> > All the best
> > Matthias
> > ___
> > 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/20151112/7143c49e/attachment-0001.html
> >
>
> --
>
> Message: 2
> Date: Thu, 12 Nov 2015 05:52:16 -0800 (PST)
> From: Nicolas Cadieux 
> To: qgis-user@lists.osgeo.org
> Subject: Re: [Qgis-user] ArcGIS & QGIS
> Message-ID: 
> Content-Type: text/plain; charset="utf-8"
>
> Yup,
> It's a problem and companies like ,Autodesk, MS and Esri make some money
> on their software and have no real short term insensitive to liberate file
> formats and program code. 
> I know there is some work being done on a plugin with MapInfo workspaces
> but I am still looking for something for the Esri symbology.  I guess
> these things are more complicated as they are protected by copyright and
> need to be reversed engineered which is not legal if there's a copyright in
> place (to my knowledge).
> Your best bet could be to look at the QGIS web server.  This way,
> your client have a web page with your QGIS project but don't need to
> install QGIS.  I guess that could bridge some of the gap as everybody
> has a we

Re: [Qgis-user] columns in spatialite

[Micha Silver]

  
  


On 11/12/2015 07:13 PM, Alex M wrote:


  Yes we should implement a cheat in QGIS (core) to handle this issue.
Other SQLite GUIs do this. Spatialite GUI and SQLite Manager (Firefox
plugin).

The basic process:
1. Make a new table the way you actually want it.
2. SQL INSERT records from Old to New (Mapping old columns to new if
name changed).
3. Remove old table
4. Rename new table to old name
5. Vacuum to recover extra pages allocated in the shuffle.

Nothing else should be needed, since you use the same name, spatial
indexes and geometry_column records should stay the same unless the
Geometry column is renamed.

This method will apply to both GeoPackage (If editing is allowed),
Spatialite tables, and any non-spatial sqlite tables.

-Alex


One caveat: if foreign keys, or views are defined (the reasons for
using a spatialDB in the first place) pointing to a column in the
table to be reshuffled, this process fails. Since sqlite does not
have any "DROP CONSTRAINT" then you have to start renaming the other
dependent tables also...




  

On 11/12/2015 04:30 AM, Matthias Kuhn wrote:

  
The main issues with spatialite are IMO: It's based on sqlite so
deleting columns and renaming columns is not supported by design. We
could offer some hacks to bypass this (annoying restriction) from the UI
- there is a risk of side effects though. Another property of it is,
that it's already 4-5MB big, even when empty. I consider this a major
limiting factor as well. Other issues which we were not yet able to
solve are its management of the information scheme which keep duplicate
entries of tables and columns which need to be properly updated which we
apparently do not manage (yet).

Geopackage is also based on sqlite, so the column delete/rename
restrictions apply as well (with the same workaround possibilities). I
haven't checked the file size, but if that's smaller, that would be
quite nice (does somebody know?).

All the best
Matthias
___
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


  
  

This mail was received via Mail-SeCure System.





-- 
  
Micha Silver
Arava Drainage Authority
+972-523-665918
  

  

___
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

Re: [Qgis-user] columns in spatialite

[Even Rouault]

Le jeudi 12 novembre 2015 18:02:59, Alex M a écrit :
> The spatialite db contains spatial reference tables of projections.
> Thats where those MB come from.

I confirm. Spatialite by defaults populates the spatial_ref_sys table with all 
the EPSG catalog (but you can actually remove all the ones you don't use and 
do a VACUUM to shrink the file. And through the InitSpatialMetaData() SQL 
function you can also decide to have an empty table or just with EPSG:4326), 
whereas in GeoPackage you only have 3 mantatory SRS (undefined geographic, 
undefined projected and EPSG:4326) + the other ones you actually used. 
Spatialite has also a few extra metadata tables, but their inpact on the file 
size should be neglectable.

> As Andrea pointed out the full answer of
> what else is in those MB would be on the Spatialite mailing list.
> 
> -Alex
> 
> On 11/12/2015 08:49 AM, Andrea Peri wrote:
> > You need study better the spatialite formats.
> > 
> > :)
> > 
> > Also the shapefile format and also the geopackage format.
> > So you will be able to understand why spatialite is 4mb and other not.
> > 
> > :))
> > 
> > A.
> > 
> > 2015-11-12 17:34 GMT+01:00 Bernd Vogelgesang :
> >> Am 12.11.2015, 16:17 Uhr, schrieb Paulo van Breugel
> >> :
> >> 
> >> 
> >> 
> >> On Thu, Nov 12, 2015 at 3:48 PM, Neumann, Andreas 
> >> 
> >> wrote:
> >>> I believe the main difference between SpatiaLite and Geopackage is that
> >>> a SpatiaLite database contains a lot of query functionality and
> >>> additional data (e.g. a big list of CRS) - while Geopackage does not
> >> 
> >> That would be a very big list of CRS, or does the query functionality
> >> take that much space? I often used spatialite, but given that I
> >> normally use it to store many layers, I had actually never noticed the
> >> large initial size. This is imho indeed a clear disadvantage when used
> >> for data sharing.
> >> 
> >>> When you checked filesizes for shp: did you only look at the shp, or
> >>> also include dbf, shx, prj, etc.? Otherwise you comparing a complete
> >>> dataset with attributes and metadata against just geometry.
> >> 
> >> All files, not only the *.shp file. I just created a simple vector layer
> >> in QGIS and saved it as shapefile, geopackage and spatialite file.
> >> 
> >> 
> >> Seems I'm a bit confused by the differences between spatialite and
> >> sqlite.
> >> 
> >> A spatialite db is always 4 MB + x which makes a huge difference for
> >> small layers, but I guess the differences become closer when having
> >> "normal" sized layers.
> >> 
> >> What is irritating me is, when I use a small layer and perform some
> >> processing function and then save it as .sqlite to a file, the result is
> >> only a few kb and not 4 MB.
> >> 
> >> So, having sqlite as default temporary output in processing would not
> >> make any difference to ESRI shape sizewise!
> >> 
> >> Example: a shapefile point layer with quite some attributes and 999
> >> features has 4.4 MB
> >> saving this as spatialiate: 4.6 MB
> >> saving as sqlite: 86 kB !
> >> 
> >> The sqlite file is 5 times smaller than the ESRI shape file while the
> >> spatialite file is about the same as the shape.
> >> 
> >> Here on 2.8.3 at the office I have no geopackage option to test with.
> >> 
> >> So, whats the difference between sqlite and spatialite in detail?
> >> 
> >> Cheers
> >> Bernd
> >> 
> >>> Andreas
> >>> 
> >>> On 2015-11-12 15:36, Paulo van Breugel wrote:
> >>> 
> >>> 
> >>> 
> >>> On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn 
> >>> 
> >>> wrote:
>  The main issues with spatialite are IMO: It's based on sqlite so
>  deleting columns and renaming columns is not supported by design. We
>  could offer some hacks to bypass this (annoying restriction) from the
>  UI - there is a risk of side effects though. Another property of it
>  is, that it's already 4-5MB big, even when empty. I consider this a
>  major limiting factor as well. Other issues which we were not yet
>  able to solve are its management of the information scheme which keep
>  duplicate entries of tables and columns which need to be properly
>  updated which we apparently do not manage (yet).
>  
>  Geopackage is also based on sqlite, so the column delete/rename
>  restrictions apply as well (with the same workaround possibilities). I
>  haven't checked the file size, but if that's smaller, that would be
>  quite nice (does somebody know?).
> >>> 
> >>> Just checked saving a shapefile of 941 bytes as Spatialite and
> >>> Geopackage file. The first is indeed 4.4MB. The Geopackage is 12.3kB,
> >>> i.e., larger then the shapefile, but the increase is small compared to
> >>> the spatialite file. I am not familiar with the differences, but this
> >>> makes the Geopackage a better candidate imho.
> >>> 
>  All the best
>  Matthias
> >>> 
> >>> ___
> >>> Qgis-user mailing list
> >>> Qgis-user@lists.osgeo.org
> >>> List info: htt

Re: [Qgis-user] GRASS Plugin ready

[Radim Blazek]

Another bug you should know about: http://hub.qgis.org/issues/13815 -
attributes of a vector imported in browser may be messed up. Fixed in
master and 2.12 branch (will be in 2.12.1).

Radim


On Sun, Nov 1, 2015 at 10:09 PM, Radim Blazek  wrote:
> Hi all,
>
> I would like to formally conclude the upgrade of the GRASS Plugin in
> QGIS. Everything specified in the crowdfunding campaign is implemented
> in recently released QGIS 2.12. The source code supports both GRASS 6
> and 7. Version(s) supported in binary distributions may vary and
> depend on packagers' decision.
>
> screenshots: 
> http://www.gissula.eu/qgis-grass-plugin-crowdfunding/screenshots.html
> videos: http://www.gissula.eu/qgis-grass-plugin-crowdfunding/videos.html
> summary: http://www.gissula.eu/qgis-grass-plugin-crowdfunding/progress.html
> documentation: 
> http://docs.qgis.org/testing/en/docs/user_manual/grass_integration/grass_integration.html
>
> Thanks to Pedro Venâncio, Stefan Blumentrath and Andrew McAninch who
> helped with upgrade of modules' configuration. Especially Pedro also
> did great work doing extensive testing. Thanks to Jürgen Fischer for
> patient fixing of Windows builds, Paolo Cavallini for documentation
> review and to everybody who contributed to the campaign.
>
> If you find a problem, please create a new issue:
> https://hub.qgis.org/issues/, set Category to GRASS and assign it to
> me (Radim Blazek). Unfortunately I have found  already two issues:
> https://hub.qgis.org/issues/13725,  https://hub.qgis.org/issues/13726,
> both are fixed in master and backported to 2.12 (will be in 2.12.1 if
> it'll ever be released).
>
> Radim
___
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

Re: [Qgis-user] columns in spatialite

[Alex M]

Yes we should implement a cheat in QGIS (core) to handle this issue.
Other SQLite GUIs do this. Spatialite GUI and SQLite Manager (Firefox
plugin).

The basic process:
1. Make a new table the way you actually want it.
2. SQL INSERT records from Old to New (Mapping old columns to new if
name changed).
3. Remove old table
4. Rename new table to old name
5. Vacuum to recover extra pages allocated in the shuffle.

Nothing else should be needed, since you use the same name, spatial
indexes and geometry_column records should stay the same unless the
Geometry column is renamed.

This method will apply to both GeoPackage (If editing is allowed),
Spatialite tables, and any non-spatial sqlite tables.

-Alex

On 11/12/2015 04:30 AM, Matthias Kuhn wrote:
> The main issues with spatialite are IMO: It's based on sqlite so
> deleting columns and renaming columns is not supported by design. We
> could offer some hacks to bypass this (annoying restriction) from the UI
> - there is a risk of side effects though. Another property of it is,
> that it's already 4-5MB big, even when empty. I consider this a major
> limiting factor as well. Other issues which we were not yet able to
> solve are its management of the information scheme which keep duplicate
> entries of tables and columns which need to be properly updated which we
> apparently do not manage (yet).
> 
> Geopackage is also based on sqlite, so the column delete/rename
> restrictions apply as well (with the same workaround possibilities). I
> haven't checked the file size, but if that's smaller, that would be
> quite nice (does somebody know?).
> 
> All the best
> Matthias
> ___
> 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
> 

___
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

Re: [Qgis-user] columns in spatialite

[aperi2007]

I understand that the real spatialite format is not really knowed.

The test you report is a read only test on the spatialite-gui.
But the spatialite-gui is a all-version readable software.
This mean that it is capable to read and understand EVERY VERSION of the 
spatialite format.

Also the oldest one.

For the write test the report has used the QGIS 1.9.0 that is an old 
version

using the old driver spatialite 2.x

This mean that the arcgis is capable to read/write only the spatialite 
versione 2.x ? version.


Whoa ! This mean it is a very old format of spatialite.

After the format spatialite 2.x
there was the
spatialite 3.1 and the
spatialite 4.0 format.
And at now the spatialite 4.1, 4.2 and 4.3

But at binary level the major difference isbetween

the spatialite 2.x, 3.x and 4.0

You should ask to the ML spatialite to have more details.

A.



Il 12/11/2015 18:01, Alex M ha scritto:

Sure you can clarify there.

I have tested spatialite in ArcGIS 10.2+

http://blog.geomusings.com/2013/08/07/spatialite-and-arcgis-10-dot-2/
http://www.northrivergeographic.com/archives/spatialite-arcgis-qgis

Enjoy,
Alex

On 11/12/2015 08:57 AM, Andrea Peri wrote:

As the better ML for ask for any differnce between the spatialite and
geopackage is the ML Spatialite.
Also for ask if the Arcgis is really capable to read a true spatialite
or instead is reading someone surely is not the QGIS ML,
perhaps the Spatialite ML could know something, but perhaps no.

A.


2015-11-12 17:54 GMT+01:00 Alex M :

On 11/12/2015 04:12 AM, Micha Silver wrote:

On 12/11/2015 14:10, Paulo van Breugel wrote:


On Thu, Nov 12, 2015 at 1:05 PM, Bernd Vogelgesang
<bernd.vogelges...@gmx.de> wrote:

 Am 12.11.2015, 08:01 Uhr, schrieb Paolo Cavallini
 <cavall...@faunalia.it>:

 Il 12/11/2015 00:31, Bernd Vogelgesang ha scritto:




 I repeatedly ask for this, and do not receive much positive echo. What are
 the reasons for people to prefer ESRI shapes over sqlite files? Are they
 not aware of the benefits or do I just miss sth completely obvious that is
 an argument against sqlite?


Well there's still the problem of exchanging data with users of the other
proprietary GIS software. Spatialite is still, unfortunately, not that popular.

FYI, ArcGIS as of 10.2 can read Spatialite files. Even more recent
ArcGIS can read GeoPackage.

-Alex
___
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





___
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

Re: [Qgis-user] columns in spatialite

[Alex M]

The spatialite db contains spatial reference tables of projections.
Thats where those MB come from. As Andrea pointed out the full answer of
what else is in those MB would be on the Spatialite mailing list.

-Alex

On 11/12/2015 08:49 AM, Andrea Peri wrote:
> You need study better the spatialite formats.
> :)
> 
> Also the shapefile format and also the geopackage format.
> So you will be able to understand why spatialite is 4mb and other not.
> 
> :))
> 
> A.
> 
> 
> 2015-11-12 17:34 GMT+01:00 Bernd Vogelgesang :
>> Am 12.11.2015, 16:17 Uhr, schrieb Paulo van Breugel
>> :
>>
>>
>>
>> On Thu, Nov 12, 2015 at 3:48 PM, Neumann, Andreas 
>> wrote:
>>>
>>> I believe the main difference between SpatiaLite and Geopackage is that a
>>> SpatiaLite database contains a lot of query functionality and additional
>>> data (e.g. a big list of CRS) - while Geopackage does not
>>
>> That would be a very big list of CRS, or does the query functionality take
>> that much space? I often used spatialite, but given that I normally use it
>> to store many layers, I had actually never noticed the large initial size.
>> This is imho indeed a clear disadvantage when used for data sharing.
>>>
>>> When you checked filesizes for shp: did you only look at the shp, or also
>>> include dbf, shx, prj, etc.? Otherwise you comparing a complete dataset with
>>> attributes and metadata against just geometry.
>>
>>
>> All files, not only the *.shp file. I just created a simple vector layer in
>> QGIS and saved it as shapefile, geopackage and spatialite file.
>>
>>
>> Seems I'm a bit confused by the differences between spatialite and sqlite.
>>
>> A spatialite db is always 4 MB + x which makes a huge difference for small
>> layers, but I guess the differences become closer when having "normal" sized
>> layers.
>>
>> What is irritating me is, when I use a small layer and perform some
>> processing function and then save it as .sqlite to a file, the result is
>> only a few kb and not 4 MB.
>>
>> So, having sqlite as default temporary output in processing would not make
>> any difference to ESRI shape sizewise!
>>
>> Example: a shapefile point layer with quite some attributes and 999 features
>> has 4.4 MB
>> saving this as spatialiate: 4.6 MB
>> saving as sqlite: 86 kB !
>>
>> The sqlite file is 5 times smaller than the ESRI shape file while the
>> spatialite file is about the same as the shape.
>>
>> Here on 2.8.3 at the office I have no geopackage option to test with.
>>
>> So, whats the difference between sqlite and spatialite in detail?
>>
>> Cheers
>> Bernd
>>
>>
>>
>>
>>
>>> Andreas
>>>
>>> On 2015-11-12 15:36, Paulo van Breugel wrote:
>>>
>>>
>>>
>>> On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn 
>>> wrote:

 The main issues with spatialite are IMO: It's based on sqlite so
 deleting columns and renaming columns is not supported by design. We
 could offer some hacks to bypass this (annoying restriction) from the UI
 - there is a risk of side effects though. Another property of it is,
 that it's already 4-5MB big, even when empty. I consider this a major
 limiting factor as well. Other issues which we were not yet able to
 solve are its management of the information scheme which keep duplicate
 entries of tables and columns which need to be properly updated which we
 apparently do not manage (yet).

 Geopackage is also based on sqlite, so the column delete/rename
 restrictions apply as well (with the same workaround possibilities). I
 haven't checked the file size, but if that's smaller, that would be
 quite nice (does somebody know?).
>>>
>>>
>>>
>>> Just checked saving a shapefile of 941 bytes as Spatialite and Geopackage
>>> file. The first is indeed 4.4MB. The Geopackage is 12.3kB, i.e., larger then
>>> the shapefile, but the increase is small compared to the spatialite file. I
>>> am not familiar with the differences, but this makes the Geopackage a better
>>> candidate imho.
>>>

 All the best
 Matthias
>>>
>>>
>>> ___
>>> 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
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>> --
>> Erstellt mit Operas E-Mail-Modul: http://www.opera.com/mail/
>>
>> ___
>> 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
> 
> 
> 

___
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

Re: [Qgis-user] columns in spatialite

[Randal Hale]

It works - mostly. I've had a few problems reading spatialite in ArcGIS 
10.2.2 as of late - which may be to the fact I'm still on 10.2.2. My 
last attempt at moving a database from PostGIS to Spatialite and into 
ArcGIS ended up with ArcGIS crashing a lot - BUT - it could read the data.


Randy


On 11/12/2015 12:01 PM, Alex M wrote:

Sure you can clarify there.

I have tested spatialite in ArcGIS 10.2+

http://blog.geomusings.com/2013/08/07/spatialite-and-arcgis-10-dot-2/
http://www.northrivergeographic.com/archives/spatialite-arcgis-qgis

Enjoy,
Alex

On 11/12/2015 08:57 AM, Andrea Peri wrote:

As the better ML for ask for any differnce between the spatialite and
geopackage is the ML Spatialite.
Also for ask if the Arcgis is really capable to read a true spatialite
or instead is reading someone surely is not the QGIS ML,
perhaps the Spatialite ML could know something, but perhaps no.

A.


2015-11-12 17:54 GMT+01:00 Alex M :

On 11/12/2015 04:12 AM, Micha Silver wrote:

On 12/11/2015 14:10, Paulo van Breugel wrote:


On Thu, Nov 12, 2015 at 1:05 PM, Bernd Vogelgesang
<bernd.vogelges...@gmx.de> wrote:

 Am 12.11.2015, 08:01 Uhr, schrieb Paolo Cavallini
 <cavall...@faunalia.it>:

 Il 12/11/2015 00:31, Bernd Vogelgesang ha scritto:




 I repeatedly ask for this, and do not receive much positive echo. What are
 the reasons for people to prefer ESRI shapes over sqlite files? Are they
 not aware of the benefits or do I just miss sth completely obvious that is
 an argument against sqlite?


Well there's still the problem of exchanging data with users of the other
proprietary GIS software. Spatialite is still, unfortunately, not that popular.

FYI, ArcGIS as of 10.2 can read Spatialite files. Even more recent
ArcGIS can read GeoPackage.

-Alex
___
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




___
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


--
-
Randal Hale
North River Geographic Systems, Inc
http://www.northrivergeographic.com
423.653.3611 rjh...@northrivergeographic.com
twitter:rjhale http://about.me/rjhale
http://www.northrivergeographic.com/introduction-to-quantum-gis
Southeast OSGEO: http://wiki.osgeo.org/wiki/Southeast_US

___
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

Re: [Qgis-user] columns in spatialite

[Andrea Peri]

As the better ML for ask for any differnce between the spatialite and
geopackage is the ML Spatialite.
Also for ask if the Arcgis is really capable to read a true spatialite
or instead is reading someone surely is not the QGIS ML,
perhaps the Spatialite ML could know something, but perhaps no.

A.


2015-11-12 17:54 GMT+01:00 Alex M :
> On 11/12/2015 04:12 AM, Micha Silver wrote:
>> On 12/11/2015 14:10, Paulo van Breugel wrote:
>>>
>>>
>>> On Thu, Nov 12, 2015 at 1:05 PM, Bernd Vogelgesang
>>> <bernd.vogelges...@gmx.de> wrote:
>>>
>>> Am 12.11.2015, 08:01 Uhr, schrieb Paolo Cavallini
>>> <cavall...@faunalia.it>:
>>>
>>> Il 12/11/2015 00:31, Bernd Vogelgesang ha scritto:
>>>
>>>
>>>
>>>
>>> I repeatedly ask for this, and do not receive much positive echo. What 
>>> are
>>> the reasons for people to prefer ESRI shapes over sqlite files? Are they
>>> not aware of the benefits or do I just miss sth completely obvious that 
>>> is
>>> an argument against sqlite?
>>>
>>
>> Well there's still the problem of exchanging data with users of the other
>> proprietary GIS software. Spatialite is still, unfortunately, not that 
>> popular.
>
> FYI, ArcGIS as of 10.2 can read Spatialite files. Even more recent
> ArcGIS can read GeoPackage.
>
> -Alex
> ___
> 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



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
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

Re: [Qgis-user] columns in spatialite

[Alex M]

Sure you can clarify there.

I have tested spatialite in ArcGIS 10.2+

http://blog.geomusings.com/2013/08/07/spatialite-and-arcgis-10-dot-2/
http://www.northrivergeographic.com/archives/spatialite-arcgis-qgis

Enjoy,
Alex

On 11/12/2015 08:57 AM, Andrea Peri wrote:
> As the better ML for ask for any differnce between the spatialite and
> geopackage is the ML Spatialite.
> Also for ask if the Arcgis is really capable to read a true spatialite
> or instead is reading someone surely is not the QGIS ML,
> perhaps the Spatialite ML could know something, but perhaps no.
> 
> A.
> 
> 
> 2015-11-12 17:54 GMT+01:00 Alex M :
>> On 11/12/2015 04:12 AM, Micha Silver wrote:
>>> On 12/11/2015 14:10, Paulo van Breugel wrote:


 On Thu, Nov 12, 2015 at 1:05 PM, Bernd Vogelgesang
 <bernd.vogelges...@gmx.de> wrote:

 Am 12.11.2015, 08:01 Uhr, schrieb Paolo Cavallini
 <cavall...@faunalia.it>:

 Il 12/11/2015 00:31, Bernd Vogelgesang ha scritto:




 I repeatedly ask for this, and do not receive much positive echo. What 
 are
 the reasons for people to prefer ESRI shapes over sqlite files? Are 
 they
 not aware of the benefits or do I just miss sth completely obvious 
 that is
 an argument against sqlite?

>>>
>>> Well there's still the problem of exchanging data with users of the other
>>> proprietary GIS software. Spatialite is still, unfortunately, not that 
>>> popular.
>>
>> FYI, ArcGIS as of 10.2 can read Spatialite files. Even more recent
>> ArcGIS can read GeoPackage.
>>
>> -Alex
>> ___
>> 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
> 
> 
> 

___
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

Re: [Qgis-user] columns in spatialite

[Alex M]

You are correct. In my mind the workflow is get GeoPackage -> up convert
to Spatialite -> do work -> Convert to GeoPackage to give to other people.

This is actually the same workflow that's been pushed in other software
too. Get exchange format, import to internal best database format, do
work, export to exchange format.

The export to exchange of whole projects/databases needs to be made
super simple (1-2 clicks) for it to become common.

-Alex

On 11/12/2015 06:48 AM, Neumann, Andreas wrote:
>  
> 
> I believe the main difference between SpatiaLite and Geopackage is that
> a SpatiaLite database contains a lot of query functionality and
> additional data (e.g. a big list of CRS) - while Geopackage does not 
> 
> When you checked filesizes for shp: did you only look at the shp, or
> also include dbf, shx, prj, etc.? Otherwise you comparing a complete
> dataset with attributes and metadata against just geometry. 
> 
> Andreas 
> 
> On 2015-11-12 15:36, Paulo van Breugel wrote: 
> 
>> On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn  wrote:
>>
>>> The main issues with spatialite are IMO: It's based on sqlite so
>>> deleting columns and renaming columns is not supported by design. We
>>> could offer some hacks to bypass this (annoying restriction) from the UI
>>> - there is a risk of side effects though. Another property of it is,
>>> that it's already 4-5MB big, even when empty. I consider this a major
>>> limiting factor as well. Other issues which we were not yet able to
>>> solve are its management of the information scheme which keep duplicate
>>> entries of tables and columns which need to be properly updated which we
>>> apparently do not manage (yet).
>>>
>>> Geopackage is also based on sqlite, so the column delete/rename
>>> restrictions apply as well (with the same workaround possibilities). I
>>> haven't checked the file size, but if that's smaller, that would be
>>> quite nice (does somebody know?).
>>
>> Just checked saving a shapefile of 941 bytes as Spatialite and Geopackage 
>> file. The first is indeed 4.4MB. The Geopackage is 12.3kB, i.e., larger then 
>> the shapefile, but the increase is small compared to the spatialite file. I 
>> am not familiar with the differences, but this makes the Geopackage a better 
>> candidate imho.
>>
>>> All the best
>>> Matthias
>>
>> ___
>> 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
> 
>   
> 
> 
> 
> ___
> 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
> 

___
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

Re: [Qgis-user] columns in spatialite

[Andrea Peri]

The better ML where ask for any difference between the spatialite and
the geopackega is the spatialite ML,
where there are user skilled on spatialite use.rather than the QGIS ML
where there are few user skilled in the spatialite use.

So you could ask to them.

Regards,

A.


2015-11-12 17:49 GMT+01:00 Andrea Peri :
> You need study better the spatialite formats.
> :)
>
> Also the shapefile format and also the geopackage format.
> So you will be able to understand why spatialite is 4mb and other not.
>
> :))
>
> A.
>
>
> 2015-11-12 17:34 GMT+01:00 Bernd Vogelgesang :
>> Am 12.11.2015, 16:17 Uhr, schrieb Paulo van Breugel
>> :
>>
>>
>>
>> On Thu, Nov 12, 2015 at 3:48 PM, Neumann, Andreas 
>> wrote:
>>>
>>> I believe the main difference between SpatiaLite and Geopackage is that a
>>> SpatiaLite database contains a lot of query functionality and additional
>>> data (e.g. a big list of CRS) - while Geopackage does not
>>
>> That would be a very big list of CRS, or does the query functionality take
>> that much space? I often used spatialite, but given that I normally use it
>> to store many layers, I had actually never noticed the large initial size.
>> This is imho indeed a clear disadvantage when used for data sharing.
>>>
>>> When you checked filesizes for shp: did you only look at the shp, or also
>>> include dbf, shx, prj, etc.? Otherwise you comparing a complete dataset with
>>> attributes and metadata against just geometry.
>>
>>
>> All files, not only the *.shp file. I just created a simple vector layer in
>> QGIS and saved it as shapefile, geopackage and spatialite file.
>>
>>
>> Seems I'm a bit confused by the differences between spatialite and sqlite.
>>
>> A spatialite db is always 4 MB + x which makes a huge difference for small
>> layers, but I guess the differences become closer when having "normal" sized
>> layers.
>>
>> What is irritating me is, when I use a small layer and perform some
>> processing function and then save it as .sqlite to a file, the result is
>> only a few kb and not 4 MB.
>>
>> So, having sqlite as default temporary output in processing would not make
>> any difference to ESRI shape sizewise!
>>
>> Example: a shapefile point layer with quite some attributes and 999 features
>> has 4.4 MB
>> saving this as spatialiate: 4.6 MB
>> saving as sqlite: 86 kB !
>>
>> The sqlite file is 5 times smaller than the ESRI shape file while the
>> spatialite file is about the same as the shape.
>>
>> Here on 2.8.3 at the office I have no geopackage option to test with.
>>
>> So, whats the difference between sqlite and spatialite in detail?
>>
>> Cheers
>> Bernd
>>
>>
>>
>>
>>
>>> Andreas
>>>
>>> On 2015-11-12 15:36, Paulo van Breugel wrote:
>>>
>>>
>>>
>>> On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn 
>>> wrote:

 The main issues with spatialite are IMO: It's based on sqlite so
 deleting columns and renaming columns is not supported by design. We
 could offer some hacks to bypass this (annoying restriction) from the UI
 - there is a risk of side effects though. Another property of it is,
 that it's already 4-5MB big, even when empty. I consider this a major
 limiting factor as well. Other issues which we were not yet able to
 solve are its management of the information scheme which keep duplicate
 entries of tables and columns which need to be properly updated which we
 apparently do not manage (yet).

 Geopackage is also based on sqlite, so the column delete/rename
 restrictions apply as well (with the same workaround possibilities). I
 haven't checked the file size, but if that's smaller, that would be
 quite nice (does somebody know?).
>>>
>>>
>>>
>>> Just checked saving a shapefile of 941 bytes as Spatialite and Geopackage
>>> file. The first is indeed 4.4MB. The Geopackage is 12.3kB, i.e., larger then
>>> the shapefile, but the increase is small compared to the spatialite file. I
>>> am not familiar with the differences, but this makes the Geopackage a better
>>> candidate imho.
>>>

 All the best
 Matthias
>>>
>>>
>>> ___
>>> 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
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>> --
>> Erstellt mit Operas E-Mail-Modul: http://www.opera.com/mail/
>>
>> ___
>> 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
>
>
>
> --
> -
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/

Re: [Qgis-user] columns in spatialite

[Alex M]

On 11/12/2015 04:12 AM, Micha Silver wrote:
> On 12/11/2015 14:10, Paulo van Breugel wrote:
>>
>>
>> On Thu, Nov 12, 2015 at 1:05 PM, Bernd Vogelgesang 
>> <bernd.vogelges...@gmx.de> wrote:
>>
>> Am 12.11.2015, 08:01 Uhr, schrieb Paolo Cavallini
>> <cavall...@faunalia.it>:
>>
>> Il 12/11/2015 00:31, Bernd Vogelgesang ha scritto:
>>
>>
>>
>>
>> I repeatedly ask for this, and do not receive much positive echo. What 
>> are
>> the reasons for people to prefer ESRI shapes over sqlite files? Are they
>> not aware of the benefits or do I just miss sth completely obvious that 
>> is
>> an argument against sqlite?
>>
> 
> Well there's still the problem of exchanging data with users of the other 
> proprietary GIS software. Spatialite is still, unfortunately, not that 
> popular.

FYI, ArcGIS as of 10.2 can read Spatialite files. Even more recent
ArcGIS can read GeoPackage.

-Alex
___
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

[Qgis-user] Conferência Geomundus dia 20 e 21 de Novembro - NOVA EMS

[Alexandre Neto]

Nos dias 20 e 21 de Novembro, irá realizar-se em Lisboa a Conferência
Internacional GeoMundus.

A organização da mesma ainda está a aceitar submissões para apresentações
de 15 minutos, e tem em particular interesse casos de estudo e experiências
na utilização de Software Open Source no âmbito das Smart Cities (mas não é
exclusivo).

Para mais informações:

http://geomundus.org/submissions.html

Dada a urgência do pedido, os interessados podem contactar directamente o
responsável Alexander Tedeschi através do endereço de email
sasha.tedes...@gmail.com

Cumprimentos,

Alexandre Neto
___
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

Re: [Qgis-user] columns in spatialite

[Andrea Peri]

You need study better the spatialite formats.
:)

Also the shapefile format and also the geopackage format.
So you will be able to understand why spatialite is 4mb and other not.

:))

A.


2015-11-12 17:34 GMT+01:00 Bernd Vogelgesang :
> Am 12.11.2015, 16:17 Uhr, schrieb Paulo van Breugel
> :
>
>
>
> On Thu, Nov 12, 2015 at 3:48 PM, Neumann, Andreas 
> wrote:
>>
>> I believe the main difference between SpatiaLite and Geopackage is that a
>> SpatiaLite database contains a lot of query functionality and additional
>> data (e.g. a big list of CRS) - while Geopackage does not
>
> That would be a very big list of CRS, or does the query functionality take
> that much space? I often used spatialite, but given that I normally use it
> to store many layers, I had actually never noticed the large initial size.
> This is imho indeed a clear disadvantage when used for data sharing.
>>
>> When you checked filesizes for shp: did you only look at the shp, or also
>> include dbf, shx, prj, etc.? Otherwise you comparing a complete dataset with
>> attributes and metadata against just geometry.
>
>
> All files, not only the *.shp file. I just created a simple vector layer in
> QGIS and saved it as shapefile, geopackage and spatialite file.
>
>
> Seems I'm a bit confused by the differences between spatialite and sqlite.
>
> A spatialite db is always 4 MB + x which makes a huge difference for small
> layers, but I guess the differences become closer when having "normal" sized
> layers.
>
> What is irritating me is, when I use a small layer and perform some
> processing function and then save it as .sqlite to a file, the result is
> only a few kb and not 4 MB.
>
> So, having sqlite as default temporary output in processing would not make
> any difference to ESRI shape sizewise!
>
> Example: a shapefile point layer with quite some attributes and 999 features
> has 4.4 MB
> saving this as spatialiate: 4.6 MB
> saving as sqlite: 86 kB !
>
> The sqlite file is 5 times smaller than the ESRI shape file while the
> spatialite file is about the same as the shape.
>
> Here on 2.8.3 at the office I have no geopackage option to test with.
>
> So, whats the difference between sqlite and spatialite in detail?
>
> Cheers
> Bernd
>
>
>
>
>
>> Andreas
>>
>> On 2015-11-12 15:36, Paulo van Breugel wrote:
>>
>>
>>
>> On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn 
>> wrote:
>>>
>>> The main issues with spatialite are IMO: It's based on sqlite so
>>> deleting columns and renaming columns is not supported by design. We
>>> could offer some hacks to bypass this (annoying restriction) from the UI
>>> - there is a risk of side effects though. Another property of it is,
>>> that it's already 4-5MB big, even when empty. I consider this a major
>>> limiting factor as well. Other issues which we were not yet able to
>>> solve are its management of the information scheme which keep duplicate
>>> entries of tables and columns which need to be properly updated which we
>>> apparently do not manage (yet).
>>>
>>> Geopackage is also based on sqlite, so the column delete/rename
>>> restrictions apply as well (with the same workaround possibilities). I
>>> haven't checked the file size, but if that's smaller, that would be
>>> quite nice (does somebody know?).
>>
>>
>>
>> Just checked saving a shapefile of 941 bytes as Spatialite and Geopackage
>> file. The first is indeed 4.4MB. The Geopackage is 12.3kB, i.e., larger then
>> the shapefile, but the increase is small compared to the spatialite file. I
>> am not familiar with the differences, but this makes the Geopackage a better
>> candidate imho.
>>
>>>
>>> All the best
>>> Matthias
>>
>>
>> ___
>> 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
>>
>>
>>
>>
>
>
>
>
>
> --
> Erstellt mit Operas E-Mail-Modul: http://www.opera.com/mail/
>
> ___
> 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



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
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

Re: [Qgis-user] Importing image to Print Composer

[Neumann, Andreas]

 

Hi, 

You can use visibility presets (bookmarks of layer visibilities) and
activate "Lock layer" checkbox with a visibility preset combination.
Each map can have a different layer combination. 

See manual for more instructions. 

Andreas 

On 2015-11-12 17:28, simonc8 wrote: 

> Hi
> 
> Thanks for pointing me at this. I've managed to create an index map within
> the same project and create the overview outline of the main map.
> 
> However, the index map has a completely different set of layers to the main
> map. Is there a way of organising the layers into groups so I could quickly
> turn off all the main map layers and turn on all the index map layers (and
> vice versa)?
> 
> Thanks
> 
> --
> View this message in context: 
> http://osgeo-org.1560.x6.nabble.com/Importing-image-to-Print-Composer-tp5235991p5236019.html
> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
> ___
> 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

  ___
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

Re: [Qgis-user] Importing image to Print Composer

[simonc8]

Hi

Thanks for pointing me at this. I've managed to create an index map within
the same project and create the overview outline of the main map.

However, the index map has a completely different set of layers to the main
map. Is there a way of organising the layers into groups so I could quickly
turn off all the main map layers and turn on all the index map layers (and
vice versa)?

Thanks



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Importing-image-to-Print-Composer-tp5235991p5236019.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
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

Re: [Qgis-user] columns in spatialite

[Bernd Vogelgesang]

Am 12.11.2015, 16:17 Uhr, schrieb Paulo van Breugel  
:





On Thu, Nov 12, 2015 at 3:48 PM, Neumann, Andreas   
wrote:


I believe the main difference between SpatiaLite and Geopackage is that  
a SpatiaLite database contains a lot of query functionality >>and  
additional data (e.g. a big list of CRS) - while Geopackage does not
That would be a very big list of CRS, or does the query functionality  
take that much space? I often used spatialite, but given >that I  
normally use it to store many layers, I had actually never noticed the  
large initial size. This is imho indeed a clear >disadvantage when used  
for data sharing.


When you checked filesizes for shp: did you only look at the shp, or  
also include dbf, shx, prj, etc.? Otherwise you comparing a >>complete  
dataset with attributes and metadata against just geometry.


All files, not only the *.shp file. I just created a simple vector layer  
in QGIS and saved it as shapefile, geopackage and >spatialite file.


Seems I'm a bit confused by the differences between spatialite and sqlite.

A spatialite db is always 4 MB + x which makes a huge difference for small  
layers, but I guess the differences become closer when having "normal"  
sized layers.


What is irritating me is, when I use a small layer and perform some  
processing function and then save it as .sqlite to a file, the result is  
only a few kb and not 4 MB.


So, having sqlite as default temporary output in processing would not make  
any difference to ESRI shape sizewise!


Example: a shapefile point layer with quite some attributes and 999  
features has 4.4 MB

saving this as spatialiate: 4.6 MB
saving as sqlite: 86 kB !

The sqlite file is 5 times smaller than the ESRI shape file while the  
spatialite file is about the same as the shape.


Here on 2.8.3 at the office I have no geopackage option to test with.

So, whats the difference between sqlite and spatialite in detail?

Cheers
Bernd








Andreas


On 2015-11-12 15:36, Paulo van Breugel wrote:



On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn   
wrote:

The main issues with spatialite are IMO: It's based on sqlite so
deleting columns and renaming columns is not supported by design. We
could offer some hacks to bypass this (annoying restriction) from the  
UI

- there is a risk of side effects though. Another property of it is,
that it's already 4-5MB big, even when empty. I consider this a major
limiting factor as well. Other issues which we were not yet able to
solve are its management of the information scheme which keep  
duplicate
entries of tables and columns which need to be properly updated which  
we

apparently do not manage (yet).

Geopackage is also based on sqlite, so the column delete/rename
restrictions apply as well (with the same workaround possibilities). I
haven't checked the file size, but if that's smaller, that would be
quite nice (does somebody know?).
Just checked saving a shapefile of 941 bytes as Spatialite and  
Geopackage file. The first is indeed 4.4MB. The Geopackage is  
>>>12.3kB, i.e., larger then the shapefile, but the increase is small  
compared to the spatialite file. I am not familiar with the  
>>>differences, but this makes the Geopackage a better candidate imho.




All the best
Matthias



___

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









--
Erstellt mit Operas E-Mail-Modul: http://www.opera.com/mail/___
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

[Qgis-user] Action definition for features highlight in other layer.

[Fernando M. Roxo da Motta]

  Hi all,


  I am attaching a small jpeg image in the hope that the list allow
it.  All descriptions bellow are based on this image.

  As (hopefully) can be seen I have two point layers, the green ones
called Recs and the red ones called Src. 

  To each Src point there is a subset of the Recs related based on a
rectangle, that  is all Recs inside a rectangle centred at the Src will
be activated when that particular Src is activated.  This is the only
relation and, of course, the rectangle of a Src point will share some
Recs from other nearby Src, but it is not a problem as each Src is
activated separately.

  Hope this is not too confuse.

  Now my question, is there a way to define an action so that when I
click a Src point all related Recs be highlighted?   Can be a selection
or whatever other suitable method.

  Thanks in advance.


  Roxo

-- 
 Non luctari, ludare ---+ WYSIWYG
Fernando M. Roxo da Motta   | Editor?
Except where explicitly stated I speak on my own behalf.|  VI !!
  ( Usuário Linux registrado #39505 )   | I see text,
 Quis custodiet ipsos custodes?-+ I get text!
 
___
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

Re: [Qgis-user] ArcGIS & QGIS

[Basques, Bob (CI-StPaul)]

We have the same sorts of problems in our office.

One (stupid IMO) approach, might be to use raster icons for symbols.  Just 
convert all symbols to some raster format and use that as a transfer method.

Based on a quick scan of this page, it looks doable:

http://blogs.esri.com/esri/arcgis/2012/04/26/pictures-in-arcgis-symbols/

To tell the truth, I’ve not really needed to pursue this is any great detail to 
date because just about every single application (and user) has their own 
methods and preferences for symbology.  We have a very large AutoCAD user base 
for example, and even using the ARC add-on, doesn’t solve the problem of 
changing the symbology between applications.  It seems that most applications 
are ok with exporting their symbols in some sort of generic format, but it’s 
not always something that can be manipulated downstream on the receiving end.

bobb



On Nov 12, 2015, at 7:20 AM, Chris House 
mailto:house...@gmail.com>> wrote:

Hi All,

I've touched on this before in a previous email but I want to get more feedback 
from this group.  In my work my deliverables will sometimes include project 
files and data.  The data sharing is easy.  However, if the client uses ArcGIS 
how can I share things like symbology and project files?  I know this is a 
loaded question but I am running into some road blocks where my clients will 
have to duplicate everything in ArcGIS.  For many private and government 
organizations simply installing QGIS is not an option for them.  So far the cop 
out answer of is well that's their problem for vendor lock.  That isn't fair to 
a lot of my clients who don't get a choice in what software they use.  Most of 
the time these decisions are made at corporate level or at the highest 
governmental level.  I want to be able to produce quality work (which I can in 
QGIS) but I have to be able to share it when I need to without the duplication 
of work.

I understand that ArcGIS does not play ball and so the burden to share is all 
on QGIS.  This is a problem that needs to be overcome by the QGIS community if 
they want to expand and become an equal in places where corporations and 
government agencies make the software choices at the highest levels.

If somehow sharing projects and symbology (especially symbologyy) is already 
possible I would love to know how to do it.

V/R
Chris
___
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

___
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

Re: [Qgis-user] Importing image to Print Composer

[DelazJ]

Hi,
Simon, does the map item "overviews" option (
http://docs.qgis.org/2.8/en/docs/user_manual/print_composer/print_composer.html#overviews)
answer your initial need for index?

2015-11-12 16:13 GMT+01:00 Simon Crombie :

> I have set up a print page consisting of map, scale bar, legend and I want
> to add an index map showing where my map is located within a regional
> context. I have generated the index map in a different QGIS project.
>
> Firstly is there any way I can put a map from a different project into the
> Print Composer?
>
> So far I have created an image file from the other project then imported
> this image into the Print Composer, but noticed that the resolution is very
> adversely affected when I do this. So secondly, is there a way of improving
> the quality of an image file imported into Print Composer?
>
> If I generate an image file from Print Composer then paste in my index map
> using a graphics programme (Irfanview) the index map quality is far
> superior
> to that when I try and import it into Print Composer.
>
> Grateful for advice.
>
> ___
> 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
___
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

[Qgis-user] Importing image to Print Composer

[Simon Crombie]

I have set up a print page consisting of map, scale bar, legend and I want
to add an index map showing where my map is located within a regional
context. I have generated the index map in a different QGIS project.

Firstly is there any way I can put a map from a different project into the
Print Composer?

So far I have created an image file from the other project then imported
this image into the Print Composer, but noticed that the resolution is very
adversely affected when I do this. So secondly, is there a way of improving
the quality of an image file imported into Print Composer?

If I generate an image file from Print Composer then paste in my index map
using a graphics programme (Irfanview) the index map quality is far superior
to that when I try and import it into Print Composer.

Grateful for advice.

___
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

Re: [Qgis-user] columns in spatialite

[Paulo van Breugel]

On Thu, Nov 12, 2015 at 3:48 PM, Neumann, Andreas 
wrote:

> I believe the main difference between SpatiaLite and Geopackage is that a
> SpatiaLite database contains a lot of query functionality and additional
> data (e.g. a big list of CRS) - while Geopackage does not
>
That would be a very big list of CRS, or does the query functionality take
that much space? I often used spatialite, but given that I normally use it
to store many layers, I had actually never noticed the large initial size.
This is imho indeed a clear disadvantage when used for data sharing.

> When you checked filesizes for shp: did you only look at the shp, or also
> include dbf, shx, prj, etc.? Otherwise you comparing a complete dataset
> with attributes and metadata against just geometry.
>

All files, not only the *.shp file. I just created a simple vector layer in
QGIS and saved it as shapefile, geopackage and spatialite file.

> Andreas
>
> On 2015-11-12 15:36, Paulo van Breugel wrote:
>
>
>
> On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn 
> wrote:
>
>> The main issues with spatialite are IMO: It's based on sqlite so
>> deleting columns and renaming columns is not supported by design. We
>> could offer some hacks to bypass this (annoying restriction) from the UI
>> - there is a risk of side effects though. Another property of it is,
>> that it's already 4-5MB big, even when empty. I consider this a major
>> limiting factor as well. Other issues which we were not yet able to
>> solve are its management of the information scheme which keep duplicate
>> entries of tables and columns which need to be properly updated which we
>> apparently do not manage (yet).
>>
>> Geopackage is also based on sqlite, so the column delete/rename
>> restrictions apply as well (with the same workaround possibilities). I
>> haven't checked the file size, but if that's smaller, that would be
>> quite nice (does somebody know?).
>
>
>
> Just checked saving a shapefile of 941 bytes as Spatialite and Geopackage
> file. The first is indeed 4.4MB. The Geopackage is 12.3kB, i.e., larger
> then the shapefile, but the increase is small compared to the spatialite
> file. I am not familiar with the differences, but this makes the Geopackage
> a better candidate imho.
>
>
>> All the best
>> Matthias
>>
>
> ___
> 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
>
>
>
>
___
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

Re: [Qgis-user] columns in spatialite

[Neumann, Andreas]

 

I believe the main difference between SpatiaLite and Geopackage is that
a SpatiaLite database contains a lot of query functionality and
additional data (e.g. a big list of CRS) - while Geopackage does not 

When you checked filesizes for shp: did you only look at the shp, or
also include dbf, shx, prj, etc.? Otherwise you comparing a complete
dataset with attributes and metadata against just geometry. 

Andreas 

On 2015-11-12 15:36, Paulo van Breugel wrote: 

> On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn  wrote:
> 
>> The main issues with spatialite are IMO: It's based on sqlite so
>> deleting columns and renaming columns is not supported by design. We
>> could offer some hacks to bypass this (annoying restriction) from the UI
>> - there is a risk of side effects though. Another property of it is,
>> that it's already 4-5MB big, even when empty. I consider this a major
>> limiting factor as well. Other issues which we were not yet able to
>> solve are its management of the information scheme which keep duplicate
>> entries of tables and columns which need to be properly updated which we
>> apparently do not manage (yet).
>> 
>> Geopackage is also based on sqlite, so the column delete/rename
>> restrictions apply as well (with the same workaround possibilities). I
>> haven't checked the file size, but if that's smaller, that would be
>> quite nice (does somebody know?).
> 
> Just checked saving a shapefile of 941 bytes as Spatialite and Geopackage 
> file. The first is indeed 4.4MB. The Geopackage is 12.3kB, i.e., larger then 
> the shapefile, but the increase is small compared to the spatialite file. I 
> am not familiar with the differences, but this makes the Geopackage a better 
> candidate imho.
> 
>> All the best
>> Matthias
> 
> ___
> 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

  ___
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

Re: [Qgis-user] columns in spatialite

[Paulo van Breugel]

On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn  wrote:

> The main issues with spatialite are IMO: It's based on sqlite so
> deleting columns and renaming columns is not supported by design. We
> could offer some hacks to bypass this (annoying restriction) from the UI
> - there is a risk of side effects though. Another property of it is,
> that it's already 4-5MB big, even when empty. I consider this a major
> limiting factor as well. Other issues which we were not yet able to
> solve are its management of the information scheme which keep duplicate
> entries of tables and columns which need to be properly updated which we
> apparently do not manage (yet).
>
> Geopackage is also based on sqlite, so the column delete/rename
> restrictions apply as well (with the same workaround possibilities). I
> haven't checked the file size, but if that's smaller, that would be
> quite nice (does somebody know?).
>


Just checked saving a shapefile of 941 bytes as Spatialite and Geopackage
file. The first is indeed 4.4MB. The Geopackage is 12.3kB, i.e., larger
then the shapefile, but the increase is small compared to the spatialite
file. I am not familiar with the differences, but this makes the Geopackage
a better candidate imho.


> All the best
> Matthias
>
___
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

Re: [Qgis-user] ArcGIS & QGIS

[Chris House]

Thanks Holger,

While symbolgoy from ArcGIS to QGIS is also an issue the main question is
how do i get the symbology to my clients from QGIS.  It has to be a simple
method.  While a direct import and read in ArcGIS may not be possible, it
has to be easy that clients don't see it as an issue.

Andreas,

I'm looking into ArcGIS and SLD now that's always been my suspicion if this
is possible it will be there.  However, there is no documentation for
ArcGIS desktop application reading SLD (only WMS) also no tool box tools
that I could find to convert SLD to layer.  I have seen a (i believe German
made) tool that would convert lyr to sld but I could not get it to work in
the short time i worked with it.

I want to note that I am very familiar with ArcGIS up to version 10.2.2
I've only recently been exposed to 10.3.  That being said in my business I
do not have ArcGIS.



v/r
Chris

On Thu, Nov 12, 2015 at 8:47 AM, Holger Naumann 
wrote:

> Hi Chris,
> I print the legend with the symbols and signatures I need into a SVG
> file (from ArcMap). From this file, I create my set of symbols (svg)
> with inkscape.
>
> regards
> Holger
>
> Am 12.11.2015 um 14:20 schrieb Chris House:
> > Hi All,
> >
> > I've touched on this before in a previous email but I want to get more
> > feedback from this group.  In my work my deliverables will sometimes
> > include project files and data.  The data sharing is easy.  However, if
> > the client uses ArcGIS how can I share things like symbology and project
> > files?  I know this is a loaded question but I am running into some road
> > blocks where my clients will have to duplicate everything in ArcGIS.
> > For many private and government organizations simply installing QGIS is
> > not an option for them.  So far the cop out answer of is well that's
> > their problem for vendor lock.  That isn't fair to a lot of my clients
> > who don't get a choice in what software they use.  Most of the time
> > these decisions are made at corporate level or at the highest
> > governmental level.  I want to be able to produce quality work (which I
> > can in QGIS) but I have to be able to share it when I need to without
> > the duplication of work.
> >
> > I understand that ArcGIS does not play ball and so the burden to share
> > is all on QGIS.  This is a problem that needs to be overcome by the QGIS
> > community if they want to expand and become an equal in places where
> > corporations and government agencies make the software choices at the
> > highest levels.
> >
> > If somehow sharing projects and symbology (especially symbologyy) is
> > already possible I would love to know how to do it.
> >
> > V/R
> > Chris
> >
> >
> > ___
> > 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
> >
>
>
___
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

Re: [Qgis-user] ArcGIS & QGIS

[Neumann, Andreas]

 

Hi Chris, 

Do you know what styling formats ArcGIS supports? Do they import and
export SLD? 

According to
http://www.esri.com/library/whitepapers/pdfs/supported-ogc-iso-standards.pdf
they support SLD in server and Desktop. 

If they support SLD - there would be neutral grounds for both - I see a
chance to also exchange symbology. Otherwise not. ESRI symbology files
are binary and I don't if they are documented and published (I assume
not). Even if they were - it would be a lot of effort to export ArcGIS
symbology from QGIS. 

SLD support is not too good in QGIS, but if ESRI ArcGIS would support
import of SLD - there would be motivation to improve the SLD support. 

Andreas 

On 2015-11-12 14:20, Chris House wrote: 

> Hi All,
> 
> I've touched on this before in a previous email but I want to get more 
> feedback from this group.  In my work my deliverables will sometimes include 
> project files and data.  The data sharing is easy.  However, if the client 
> uses ArcGIS how can I share things like symbology and project files?  I know 
> this is a loaded question but I am running into some road blocks where my 
> clients will have to duplicate everything in ArcGIS.  For many private and 
> government organizations simply installing QGIS is not an option for them.  
> So far the cop out answer of is well that's their problem for vendor lock.  
> That isn't fair to a lot of my clients who don't get a choice in what 
> software they use.  Most of the time these decisions are made at corporate 
> level or at the highest governmental level.  I want to be able to produce 
> quality work (which I can in QGIS) but I have to be able to share it when I 
> need to without the duplication of work.
> 
> I understand that ArcGIS does not play ball and so the burden to share is all 
> on QGIS.  This is a problem that needs to be overcome by the QGIS community 
> if they want to expand and become an equal in places where corporations and 
> government agencies make the software choices at the highest levels.
> 
> If somehow sharing projects and symbology (especially symbologyy) is already 
> possible I would love to know how to do it.
> 
> V/R Chris 
> 
> ___
> 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

  ___
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

Re: [Qgis-user] ArcGIS & QGIS

[Nicolas Cadieux]

Yup, 
It's a problem and companies like ,Autodesk, MS and Esri make some money on 
their software and have no real short term insensitive to liberate file formats 
and program code.  
I know there is some work being done on a plugin with MapInfo workspaces but I 
am still looking for something for the Esri symbology.  I guess these 
things are more complicated as they are protected by copyright and need to be 
reversed engineered which is not legal if there's a copyright in place (to my 
knowledge). 
Your best bet could be to look at the QGIS web server.  This way, your 
client have a web page with your QGIS project but don't need to install 
QGIS.  I guess that could bridge some of the gap as everybody has a web 
browser on their computer. 
Nicolas Cadieux M.Sc. 
Les Entreprises Archéotec inc.  
8548, rue Saint-Denis Montréal H2P 2H2 
Téléphone: 514.381.5112  Fax: 514.381.4995 
www.archeotec.ca 
On Nov 12, 2015 8:12 AM, "Chris House [via OSGeo.org]" 
 wrote: 

Hi All, I've touched on this before in a previous email but I want 
to get more feedback from this group.  In my work my deliverables will 
sometimes include project files and data.  The data sharing is easy.  However, 
if the client uses ArcGIS how can I share things like symbology and project 
files?  I know this is a loaded question but I am running into some road blocks 
where my clients will have to duplicate everything in ArcGIS.  For many private 
and government organizations simply installing QGIS is not an option for them.  
So far the cop out answer of is well that's their problem for vendor lock.  
That isn't fair to a lot of my clients who don't get a choice in what 
software they use.  Most of the time these decisions are made at corporate 
level or at the highest governmental level.  I want to be able to produce 
quality work (which I can in QGIS) but I have to be able to share it when I 
need to without the duplication of work. I understand that ArcGIS does not play 
ball and so the burden to share is all on QGIS.  This is a problem that needs 
to be overcome by the QGIS community if they want to expand and become an equal 
in places where corporations and government agencies make the software choices 
at the highest levels. If somehow sharing projects and symbology (especially 
symbologyy) is already possible I would love to know how to do it. V/R Chris 
___
Qgis-user mailing list
[hidden email] 
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: 
http://lists.osgeo.org/mailman/listinfo/qgis-user 








If you reply to this email, your message will be added to the 
discussion below: 
http://osgeo-org.1560.x6.nabble.com/ArcGIS-QGIS-tp5235956.html 


To start a new topic under Quantum GIS - User, email 
ml-node+s1560n4125267h38@n6.nabble.com 
To unsubscribe from Quantum GIS - User, click here . 
NAML 




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/ArcGIS-QGIS-tp5235956p5235967.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.___
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

Re: [Qgis-user] columns in spatialite

[Neumann, Andreas]

 

Hi, 

I would prefer if we could concentrate on Geopackage. Geopackage is now
an OGC format and should be (at least in theory) better supported in
other (proprietary) GIS than SpatiaLite. 

Andreas 

On 2015-11-12 13:30, Matthias Kuhn wrote: 

> The main issues with spatialite are IMO: It's based on sqlite so
> deleting columns and renaming columns is not supported by design. We
> could offer some hacks to bypass this (annoying restriction) from the UI
> - there is a risk of side effects though. Another property of it is,
> that it's already 4-5MB big, even when empty. I consider this a major
> limiting factor as well. Other issues which we were not yet able to
> solve are its management of the information scheme which keep duplicate
> entries of tables and columns which need to be properly updated which we
> apparently do not manage (yet).
> 
> Geopackage is also based on sqlite, so the column delete/rename
> restrictions apply as well (with the same workaround possibilities). I
> haven't checked the file size, but if that's smaller, that would be
> quite nice (does somebody know?).
> 
> All the best
> Matthias
> ___
> 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

  ___
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

[Qgis-user] ArcGIS & QGIS

[Chris House]

Hi All,

I've touched on this before in a previous email but I want to get more
feedback from this group.  In my work my deliverables will sometimes
include project files and data.  The data sharing is easy.  However, if the
client uses ArcGIS how can I share things like symbology and project
files?  I know this is a loaded question but I am running into some road
blocks where my clients will have to duplicate everything in ArcGIS.  For
many private and government organizations simply installing QGIS is not an
option for them.  So far the cop out answer of is well that's their problem
for vendor lock.  That isn't fair to a lot of my clients who don't get a
choice in what software they use.  Most of the time these decisions are
made at corporate level or at the highest governmental level.  I want to be
able to produce quality work (which I can in QGIS) but I have to be able to
share it when I need to without the duplication of work.

I understand that ArcGIS does not play ball and so the burden to share is
all on QGIS.  This is a problem that needs to be overcome by the QGIS
community if they want to expand and become an equal in places where
corporations and government agencies make the software choices at the
highest levels.

If somehow sharing projects and symbology (especially symbologyy) is
already possible I would love to know how to do it.

V/R
Chris
___
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

[Qgis-user] Select features from thematic legend entry

[Amedeo Fadini]

Hi everybody,

When I use a vector layer thematized with categorized style ruled by
my field of interests or my favorite expression, it's quite useful
enable the "show feature count" option in the right-click menu.

Working on a land-cover map it results that very few polygons do have
a specific value in land use change (categorized by expression): what
is the quickest way to select that polygons and check them one by one
with "item browser" plugin?
Right now I think that I need open attribute table, click on "select
by expression" tool, provide the same expression used in
categorization style with the desired results..
Is there a better way?
It would be nice to  have a contextual menu for each thematic entry
in the legend (zoom to legend entry /select by legend entry) but I
think it's too difficult for a feature request.

Thanks

Amedeo Fadini
___
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

Re: [Qgis-user] columns in spatialite

[Matthias Kuhn]

The main issues with spatialite are IMO: It's based on sqlite so
deleting columns and renaming columns is not supported by design. We
could offer some hacks to bypass this (annoying restriction) from the UI
- there is a risk of side effects though. Another property of it is,
that it's already 4-5MB big, even when empty. I consider this a major
limiting factor as well. Other issues which we were not yet able to
solve are its management of the information scheme which keep duplicate
entries of tables and columns which need to be properly updated which we
apparently do not manage (yet).

Geopackage is also based on sqlite, so the column delete/rename
restrictions apply as well (with the same workaround possibilities). I
haven't checked the file size, but if that's smaller, that would be
quite nice (does somebody know?).

All the best
Matthias
___
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

Re: [Qgis-user] columns in spatialite

[Micha Silver]

  
  
On 12/11/2015 14:10, Paulo van Breugel
  wrote:


  

  On Thu, Nov 12, 2015 at 1:05 PM,
Bernd Vogelgesang 
wrote:
Am
  12.11.2015, 08:01 Uhr, schrieb Paolo Cavallini :
  
  
Il 12/11/2015 00:31, Bernd Vogelgesang ha scritto:


  
  
  
  I repeatedly ask for this, and do not receive much
  positive echo. What are the reasons for people to prefer
  ESRI shapes over sqlite files? Are they not aware of the
  benefits or do I just miss sth completely obvious that is
  an argument against sqlite?
  

  

  


Well there's still the problem of exchanging data with users of the
other proprietary GIS software. Spatialite is still, unfortunately,
not that popular.



  

  

  The only reason for me not to use sqlite in QGIS is, that
  it is not well integrated into the workflows (and ftools,
  which I do not use at all since there is Processing), but
  that seems not to be the fault of sqlite but of user and
  developer habits (?)
  
  At least an option in Processing settings for choosing the
  default file type for temporary layers would meet my needs
  to 80% I guess.



+1 No idea either how difficult that would be to
  implement, but it would be a great improvement

 


  
  Thanks for your attention
  Bernd
  
  
  
  -- 
  Bernd Vogelgesang
  Siedlerstraße 2
  91083 Baiersdorf/Igelsdorf
  Tel: 09133-825374
  ___
  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
  
  

  
  
  This mail was received via Mail-SeCure System.
  
  
  
  ___
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
This mail was received via Mail-SeCure System.





-- 
  
Micha Silver
Arava Drainage Authority
cell: +972-523-665918
  

  

___
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

Re: [Qgis-user] columns in spatialite

[Paulo van Breugel]

On Thu, Nov 12, 2015 at 1:05 PM, Bernd Vogelgesang  wrote:

> Am 12.11.2015, 08:01 Uhr, schrieb Paolo Cavallini :
>
> Il 12/11/2015 00:31, Bernd Vogelgesang ha scritto:
>>
>> So, to answer to Paolo's question about what is missing in DBManager:
>>> Actually nothing in my case, cause I really do not want to use it at
>>> all. I just would like to be able to act with spatialite layers as I am
>>> able to do with ESRI shapefile layers.
>>>
>>
>> Geopackage might be more in line with what you are looking for (still a
>> lengthy way to go, anyway).
>> All the best.
>>
>
> Hi Paolo,
>
> as far as I understand, Geopackage is going to be more or less sth like a
> File-Geodatabase, so a container for all kinds of data which can be easily
> shipped.
> The "lengthy" way to Geopackage seems to be already long, and in the
> meanwhile, ESRI shape will stay the unquestioned standard?
>
> I really have no clue of the interiors of the technology, but would it be
> really this hard to streamline QGIS functions in a way, that sqlite files
> are the default output of all functions, so also as temporary files from
> Processing?
>
> I repeatedly ask for this, and do not receive much positive echo. What are
> the reasons for people to prefer ESRI shapes over sqlite files? Are they
> not aware of the benefits or do I just miss sth completely obvious that is
> an argument against sqlite?
>
> The only reason for me not to use sqlite in QGIS is, that it is not well
> integrated into the workflows (and ftools, which I do not use at all since
> there is Processing), but that seems not to be the fault of sqlite but of
> user and developer habits (?)
>
> At least an option in Processing settings for choosing the default file
> type for temporary layers would meet my needs to 80% I guess.
>

+1 No idea either how difficult that would be to implement, but it would be
a great improvement


>
> Thanks for your attention
> Bernd
>
>
>
> --
> Bernd Vogelgesang
> Siedlerstraße 2
> 91083 Baiersdorf/Igelsdorf
> Tel: 09133-825374
> ___
> 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
___
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

Re: [Qgis-user] columns in spatialite

[Bernd Vogelgesang]

Am 12.11.2015, 08:01 Uhr, schrieb Paolo Cavallini :


Il 12/11/2015 00:31, Bernd Vogelgesang ha scritto:


So, to answer to Paolo's question about what is missing in DBManager:
Actually nothing in my case, cause I really do not want to use it at
all. I just would like to be able to act with spatialite layers as I am
able to do with ESRI shapefile layers.


Geopackage might be more in line with what you are looking for (still a
lengthy way to go, anyway).
All the best.


Hi Paolo,

as far as I understand, Geopackage is going to be more or less sth like a  
File-Geodatabase, so a container for all kinds of data which can be easily  
shipped.
The "lengthy" way to Geopackage seems to be already long, and in the  
meanwhile, ESRI shape will stay the unquestioned standard?


I really have no clue of the interiors of the technology, but would it be  
really this hard to streamline QGIS functions in a way, that sqlite files  
are the default output of all functions, so also as temporary files from  
Processing?


I repeatedly ask for this, and do not receive much positive echo. What are  
the reasons for people to prefer ESRI shapes over sqlite files? Are they  
not aware of the benefits or do I just miss sth completely obvious that is  
an argument against sqlite?


The only reason for me not to use sqlite in QGIS is, that it is not well  
integrated into the workflows (and ftools, which I do not use at all since  
there is Processing), but that seems not to be the fault of sqlite but of  
user and developer habits (?)


At least an option in Processing settings for choosing the default file  
type for temporary layers would meet my needs to 80% I guess.


Thanks for your attention
Bernd



--
Bernd Vogelgesang
Siedlerstraße 2
91083 Baiersdorf/Igelsdorf
Tel: 09133-825374
___
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

Re: [Qgis-user] Can the point displacement center symbol be scaled based on number of corresponding points?

[kimaidou]

Hi all

Since PostGIS 2.2, you can now do the clustering server-side. See [1]
It is not as simple as using a QGIS code feature, and it is only available
for PostGIS layers, but it could do the job. You will probably need to play
with other methods such as ST_Centroid for getting a point and other
aggregates function to count the features involved.

[1] http://postgis.net/docs/manual-2.2/ST_ClusterWithin.html

Cheers,
Michaël

2015-11-12 10:30 GMT+01:00 Neumann, Andreas :

> Hi,
>
> On 2015-11-12 10:22, Anita Graser wrote:
>
>
> On Nov 12, 2015 9:11 AM, "Neumann, Andreas"  wrote:
> >
> > I also think that - what Anita wants - is a special case of a cluster
> renderer (one that actually does not cluster, but only count how many
> features are at the same geometry). To have this as a special option of the
> displacement renderer would be a quite misleading ...
> >
> > But the cluster renderer also allows for a search radius (similar to the
> heatmap) - while the displacement renderer only looks at features at the
> exact same location (I know there is now a tolerance, but this was only
> added later).
>
> Exactly this tolerance makes the renderer much more interesting to me.
> Never had a use case for the original displacement renderer.
>
> but still we shouldn't misuse terms. Displacement is the opposite of
> clustering. What you want is clustering, not displacement.
>
> Andreas
>
>
>
>
> ___
> 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
>
___
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

Re: [Qgis-user] Can the point displacement center symbol be scaled based on number of corresponding points?

[Neumann, Andreas]

 

Hi, 

On 2015-11-12 10:22, Anita Graser wrote: 

> On Nov 12, 2015 9:11 AM, "Neumann, Andreas"  wrote:
>> 
>> I also think that - what Anita wants - is a special case of a cluster 
>> renderer (one that actually does not cluster, but only count how many 
>> features are at the same geometry). To have this as a special option of the 
>> displacement renderer would be a quite misleading ...
>> 
>> But the cluster renderer also allows for a search radius (similar to the 
>> heatmap) - while the displacement renderer only looks at features at the 
>> exact same location (I know there is now a tolerance, but this was only 
>> added later). 
> 
> Exactly this tolerance makes the renderer much more interesting to me. Never 
> had a use case for the original displacement renderer.

but still we shouldn't misuse terms. Displacement is the opposite of
clustering. What you want is clustering, not displacement. 

Andreas 

  ___
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

Re: [Qgis-user] Can the point displacement center symbol be scaled based on number of corresponding points?

[Anita Graser]

On Nov 12, 2015 9:11 AM, "Neumann, Andreas"  wrote:
>
> I also think that - what Anita wants - is a special case of a cluster
renderer (one that actually does not cluster, but only count how many
features are at the same geometry). To have this as a special option of the
displacement renderer would be a quite misleading ...
>
> But the cluster renderer also allows for a search radius (similar to the
heatmap) - while the displacement renderer only looks at features at the
exact same location (I know there is now a tolerance, but this was only
added later).

Exactly this tolerance makes the renderer much more interesting to me.
Never had a use case for the original displacement renderer.

Best wishes
Anita



The displacement renderer was originally designed to show people who live
at the very same address.
>
> I'd also be interested to see such a cluster renderer - actually since a
couple of years - but it was never that important to my employer that we
invested in it.
>
> Andreas
>
> On 2015-11-11 22:03, Anita Graser wrote:
>>
>>
>>
>> On Wed, Nov 11, 2015 at 9:46 PM, Nyall Dawson 
wrote:
>>>
>>>
>>> On 12 Nov 2015 7:30 AM, "Anita Graser"  wrote:
>>> >
>>> >
>>> >
>>> > On Wed, Nov 11, 2015 at 9:09 PM, Nyall Dawson 
wrote:
>>> >>
>>> >>
>>> >> On 12 Nov 2015 6:51 AM, "Anita Graser"  wrote:
>>> >> >
>>> >> > Hi,
>>> >> >
>>> >> > Is there a way, maybe a function for expression based styles,
which makes it possible to scale the center symbol of the point
displacement style based on the number of corresponding points?
>>> >> >
>>> >> > So if 5 points are summarized with one center symbol, make it 5
big and/or label it with "5".
>>> >>
>>> >> Do you also want the ring sizes to change? Or are they constant?
>>> >
>>> > ​Actually, I don't want the ring at all. I'm just looking to
reproduce
http://suite.opengeo.org/opengeo-docs/cartography/rt/pointstacker.html
>>>
>>> Ah, now I understand. Not possible at the moment, but the displacement
renderer could be extended to allow this style (and be renamed
"displacement/stacker"). Let me think on this - I might launch a crowdfund
to add this feature.
>>
>> ​Great, looking forward to seeing what you come up with :)
>>
>> Best wishes,
>> ​Anita
>>
>> ​
>>
>> ___
>> 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
>
>
>
>
___
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

Re: [Qgis-user] Can the point displacement center symbol be scaled based on number of corresponding points?

[Neumann, Andreas]

 

I also think that - what Anita wants - is a special case of a cluster
renderer (one that actually does not cluster, but only count how many
features are at the same geometry). To have this as a special option of
the displacement renderer would be a quite misleading ... 

But the cluster renderer also allows for a search radius (similar to the
heatmap) - while the displacement renderer only looks at features at the
exact same location (I know there is now a tolerance, but this was only
added later). The displacement renderer was originally designed to show
people who live at the very same address. 

I'd also be interested to see such a cluster renderer - actually since a
couple of years - but it was never that important to my employer that we
invested in it. 

Andreas 

On 2015-11-11 22:03, Anita Graser wrote: 

> On Wed, Nov 11, 2015 at 9:46 PM, Nyall Dawson  wrote:
> 
>> On 12 Nov 2015 7:30 AM, "Anita Graser"  wrote:
>>> 
>>> 
>>> 
>>> On Wed, Nov 11, 2015 at 9:09 PM, Nyall Dawson  
>>> wrote:
 
 
 On 12 Nov 2015 6:51 AM, "Anita Graser"  wrote:
> 
> Hi,
> 
> Is there a way, maybe a function for expression based styles, which makes 
> it possible to scale the center symbol of the point displacement style 
> based on the number of corresponding points?
> 
> So if 5 points are summarized with one center symbol, make it 5 big 
> and/or label it with "5".
 
 Do you also want the ring sizes to change? Or are they constant?
>>> 
>>> ​Actually, I don't want the ring at all. I'm just looking to reproduce 
>>> http://suite.opengeo.org/opengeo-docs/cartography/rt/pointstacker.html 
>> 
>> Ah, now I understand. Not possible at the moment, but the displacement 
>> renderer could be extended to allow this style (and be renamed 
>> "displacement/stacker"). Let me think on this - I might launch a crowdfund 
>> to add this feature.
> 
> ​Great, looking forward to seeing what you come up with :) 
> 
> Best wishes, 
> 
> ​Anita 
> 
> ​ 
> 
> ___
> 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

  ___
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