<div dir="ltr"><div><div>Thanks Nicolas,<br><br></div>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.<br><br></div>--Chris<br><div><div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Nov 12, 2015 at 10:47 AM, <span dir="ltr"><<a href="mailto:qgis-user-request@lists.osgeo.org" target="_blank">qgis-user-request@lists.osgeo.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send Qgis-user mailing list submissions to<br>
<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:qgis-user-request@lists.osgeo.org">qgis-user-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:qgis-user-owner@lists.osgeo.org">qgis-user-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of Qgis-user digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: columns in spatialite (Neumann, Andreas)<br>
2. Re: ArcGIS & QGIS (Nicolas Cadieux)<br>
3. Re: ArcGIS & QGIS (Neumann, Andreas)<br>
4. Re: ArcGIS & QGIS (Chris House)<br>
5. Re: columns in spatialite (Paulo van Breugel)<br>
6. Re: columns in spatialite (Neumann, Andreas)<br>
7. Re: columns in spatialite (Paulo van Breugel)<br>
8. Importing image to Print Composer (Simon Crombie)<br>
9. Re: Importing image to Print Composer (DelazJ)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Thu, 12 Nov 2015 14:51:28 +0100<br>
From: "Neumann, Andreas" <<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>><br>
To: Matthias Kuhn <<a href="mailto:matthias@opengis.ch">matthias@opengis.ch</a>><br>
Cc: Paulo van Breugel <<a href="mailto:p.vanbreugel@gmail.com">p.vanbreugel@gmail.com</a>>, QGIS user email list<br>
<<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>><br>
Subject: Re: [Qgis-user] columns in spatialite<br>
Message-ID: <<a href="mailto:ee2d08cb6f3e4616da73579d7245cffb@carto.net">ee2d08cb6f3e4616da73579d7245cffb@carto.net</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
<br>
<br>
Hi,<br>
<br>
I would prefer if we could concentrate on Geopackage. Geopackage is now<br>
an OGC format and should be (at least in theory) better supported in<br>
other (proprietary) GIS than SpatiaLite.<br>
<br>
Andreas<br>
<br>
On 2015-11-12 13:30, Matthias Kuhn wrote:<br>
<br>
> The main issues with spatialite are IMO: It's based on sqlite so<br>
> deleting columns and renaming columns is not supported by design. We<br>
> could offer some hacks to bypass this (annoying restriction) from the UI<br>
> - there is a risk of side effects though. Another property of it is,<br>
> that it's already 4-5MB big, even when empty. I consider this a major<br>
> limiting factor as well. Other issues which we were not yet able to<br>
> solve are its management of the information scheme which keep duplicate<br>
> entries of tables and columns which need to be properly updated which we<br>
> apparently do not manage (yet).<br>
><br>
> Geopackage is also based on sqlite, so the column delete/rename<br>
> restrictions apply as well (with the same workaround possibilities). I<br>
> haven't checked the file size, but if that's smaller, that would be<br>
> quite nice (does somebody know?).<br>
><br>
> All the best<br>
> Matthias<br>
> _______________________________________________<br>
> Qgis-user mailing list<br>
> <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/7143c49e/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/7143c49e/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Thu, 12 Nov 2015 05:52:16 -0800 (PST)<br>
From: Nicolas Cadieux <<a href="mailto:nicolas.cadieux@archeotec.ca">nicolas.cadieux@archeotec.ca</a>><br>
To: <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] ArcGIS & QGIS<br>
Message-ID: <<a href="mailto:e0fa9bc2-6156-4100-998e-76b2ad9a7ab8@email.android.com">e0fa9bc2-6156-4100-998e-76b2ad9a7ab8@email.android.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Yup,<br>
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. <br>
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).<br>
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.<br>
Nicolas Cadieux M.Sc.<br>
Les Entreprises Archéotec inc. <br>
8548, rue Saint-Denis Montréal H2P 2H2<br>
Téléphone: 514.381.5112  Fax: 514.381.4995<br>
<a href="http://www.archeotec.ca" rel="noreferrer" target="_blank">www.archeotec.ca</a><br>
On Nov 12, 2015 8:12 AM, "Chris House [via OSGeo.org]" &<a href="mailto:lt%3Bml-node%2Bs1560n5235956h97@n6.nabble.com">lt;ml-node+s1560n5235956h97@n6.nabble.com</a>> wrote:<br>
<br>
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<br>
_______________________________________________<br>
Qgis-user mailing list<br>
[hidden email]<br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
If you reply to this email, your message will be added to the discussion below:<br>
<a href="http://osgeo-org.1560.x6.nabble.com/ArcGIS-QGIS-tp5235956.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/ArcGIS-QGIS-tp5235956.html</a><br>
<br>
<br>
To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@<a href="http://n6.nabble.com" rel="noreferrer" target="_blank">n6.nabble.com</a><br>
To unsubscribe from Quantum GIS - User, click here .<br>
NAML<br>
<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/ArcGIS-QGIS-tp5235956p5235967.html" rel="noreferrer" target="_blank">http://osgeo-org.1560.x6.nabble.com/ArcGIS-QGIS-tp5235956p5235967.html</a><br>
Sent from the Quantum GIS - User mailing list archive at Nabble.com.<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/6e4d88be/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/6e4d88be/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Thu, 12 Nov 2015 15:05:00 +0100<br>
From: "Neumann, Andreas" <<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>><br>
To: Chris House <<a href="mailto:housec01@gmail.com">housec01@gmail.com</a>><br>
Cc: <a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] ArcGIS & QGIS<br>
Message-ID: <<a href="mailto:5582cb80168a6b9b2869c2450e811e3b@carto.net">5582cb80168a6b9b2869c2450e811e3b@carto.net</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
<br>
<br>
Hi Chris,<br>
<br>
Do you know what styling formats ArcGIS supports? Do they import and<br>
export SLD?<br>
<br>
According to<br>
<a href="http://www.esri.com/library/whitepapers/pdfs/supported-ogc-iso-standards.pdf" rel="noreferrer" target="_blank">http://www.esri.com/library/whitepapers/pdfs/supported-ogc-iso-standards.pdf</a><br>
they support SLD in server and Desktop.<br>
<br>
If they support SLD - there would be neutral grounds for both - I see a<br>
chance to also exchange symbology. Otherwise not. ESRI symbology files<br>
are binary and I don't if they are documented and published (I assume<br>
not). Even if they were - it would be a lot of effort to export ArcGIS<br>
symbology from QGIS.<br>
<br>
SLD support is not too good in QGIS, but if ESRI ArcGIS would support<br>
import of SLD - there would be motivation to improve the SLD support.<br>
<br>
Andreas<br>
<br>
On 2015-11-12 14:20, Chris House wrote:<br>
<br>
> Hi All,<br>
><br>
> 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.<br>
><br>
> 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.<br>
><br>
> If somehow sharing projects and symbology (especially symbologyy) is already possible I would love to know how to do it.<br>
><br>
> V/R Chris<br>
><br>
> _______________________________________________<br>
> Qgis-user mailing list<br>
> <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/2dc9d2c1/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/2dc9d2c1/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Thu, 12 Nov 2015 09:09:18 -0500<br>
From: Chris House <<a href="mailto:housec01@gmail.com">housec01@gmail.com</a>><br>
To: Holger Naumann <<a href="mailto:holger.naumann@gmail.com">holger.naumann@gmail.com</a>>,<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
Subject: Re: [Qgis-user] ArcGIS & QGIS<br>
Message-ID:<br>
<<a href="mailto:CAKbExzg2xs5sp-aQhtLj-uasN1K6ka8k6NtTP8AL6tpP%2B6u5eA@mail.gmail.com">CAKbExzg2xs5sp-aQhtLj-uasN1K6ka8k6NtTP8AL6tpP+6u5eA@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Thanks Holger,<br>
<br>
While symbolgoy from ArcGIS to QGIS is also an issue the main question is<br>
how do i get the symbology to my clients from QGIS. It has to be a simple<br>
method. While a direct import and read in ArcGIS may not be possible, it<br>
has to be easy that clients don't see it as an issue.<br>
<br>
Andreas,<br>
<br>
I'm looking into ArcGIS and SLD now that's always been my suspicion if this<br>
is possible it will be there. However, there is no documentation for<br>
ArcGIS desktop application reading SLD (only WMS) also no tool box tools<br>
that I could find to convert SLD to layer. I have seen a (i believe German<br>
made) tool that would convert lyr to sld but I could not get it to work in<br>
the short time i worked with it.<br>
<br>
I want to note that I am very familiar with ArcGIS up to version 10.2.2<br>
I've only recently been exposed to 10.3. That being said in my business I<br>
do not have ArcGIS.<br>
<br>
<br>
<br>
v/r<br>
Chris<br>
<br>
On Thu, Nov 12, 2015 at 8:47 AM, Holger Naumann <<a href="mailto:holger.naumann@gmail.com">holger.naumann@gmail.com</a>><br>
wrote:<br>
<br>
> Hi Chris,<br>
> I print the legend with the symbols and signatures I need into a SVG<br>
> file (from ArcMap). From this file, I create my set of symbols (svg)<br>
> with inkscape.<br>
><br>
> regards<br>
> Holger<br>
><br>
> Am 12.11.2015 um 14:20 schrieb Chris House:<br>
> > Hi All,<br>
> ><br>
> > I've touched on this before in a previous email but I want to get more<br>
> > feedback from this group. In my work my deliverables will sometimes<br>
> > include project files and data. The data sharing is easy. However, if<br>
> > the client uses ArcGIS how can I share things like symbology and project<br>
> > files? I know this is a loaded question but I am running into some road<br>
> > blocks where my clients will have to duplicate everything in ArcGIS.<br>
> > For many private and government organizations simply installing QGIS is<br>
> > not an option for them. So far the cop out answer of is well that's<br>
> > their problem for vendor lock. That isn't fair to a lot of my clients<br>
> > who don't get a choice in what software they use. Most of the time<br>
> > these decisions are made at corporate level or at the highest<br>
> > governmental level. I want to be able to produce quality work (which I<br>
> > can in QGIS) but I have to be able to share it when I need to without<br>
> > the duplication of work.<br>
> ><br>
> > I understand that ArcGIS does not play ball and so the burden to share<br>
> > is all on QGIS. This is a problem that needs to be overcome by the QGIS<br>
> > community if they want to expand and become an equal in places where<br>
> > corporations and government agencies make the software choices at the<br>
> > highest levels.<br>
> ><br>
> > If somehow sharing projects and symbology (especially symbologyy) is<br>
> > already possible I would love to know how to do it.<br>
> ><br>
> > V/R<br>
> > Chris<br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > Qgis-user mailing list<br>
> > <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
> > List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> > Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> ><br>
><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/742774bb/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/742774bb/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 5<br>
Date: Thu, 12 Nov 2015 15:36:44 +0100<br>
From: Paulo van Breugel <<a href="mailto:p.vanbreugel@gmail.com">p.vanbreugel@gmail.com</a>><br>
To: Matthias Kuhn <<a href="mailto:matthias@opengis.ch">matthias@opengis.ch</a>><br>
Cc: QGIS user email list <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>><br>
Subject: Re: [Qgis-user] columns in spatialite<br>
Message-ID:<br>
<<a href="mailto:CAGrkfcLxB4wt6wUagj36BcUNvO9DVeW71_Knv0iYjFvb3jp91w@mail.gmail.com">CAGrkfcLxB4wt6wUagj36BcUNvO9DVeW71_Knv0iYjFvb3jp91w@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn <<a href="mailto:matthias@opengis.ch">matthias@opengis.ch</a>> wrote:<br>
<br>
> The main issues with spatialite are IMO: It's based on sqlite so<br>
> deleting columns and renaming columns is not supported by design. We<br>
> could offer some hacks to bypass this (annoying restriction) from the UI<br>
> - there is a risk of side effects though. Another property of it is,<br>
> that it's already 4-5MB big, even when empty. I consider this a major<br>
> limiting factor as well. Other issues which we were not yet able to<br>
> solve are its management of the information scheme which keep duplicate<br>
> entries of tables and columns which need to be properly updated which we<br>
> apparently do not manage (yet).<br>
><br>
> Geopackage is also based on sqlite, so the column delete/rename<br>
> restrictions apply as well (with the same workaround possibilities). I<br>
> haven't checked the file size, but if that's smaller, that would be<br>
> quite nice (does somebody know?).<br>
><br>
<br>
<br>
Just checked saving a shapefile of 941 bytes as Spatialite and Geopackage<br>
file. The first is indeed 4.4MB. The Geopackage is 12.3kB, i.e., larger<br>
then the shapefile, but the increase is small compared to the spatialite<br>
file. I am not familiar with the differences, but this makes the Geopackage<br>
a better candidate imho.<br>
<br>
<br>
> All the best<br>
> Matthias<br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/130d2e14/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/130d2e14/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 6<br>
Date: Thu, 12 Nov 2015 15:48:36 +0100<br>
From: "Neumann, Andreas" <<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>><br>
To: Paulo van Breugel <<a href="mailto:p.vanbreugel@gmail.com">p.vanbreugel@gmail.com</a>><br>
Cc: QGIS user email list <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>><br>
Subject: Re: [Qgis-user] columns in spatialite<br>
Message-ID: <<a href="mailto:ed24cd4c89bfa958d7d901e33b2ae092@carto.net">ed24cd4c89bfa958d7d901e33b2ae092@carto.net</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
<br>
<br>
I believe the main difference between SpatiaLite and Geopackage is that<br>
a SpatiaLite database contains a lot of query functionality and<br>
additional data (e.g. a big list of CRS) - while Geopackage does not<br>
<br>
When you checked filesizes for shp: did you only look at the shp, or<br>
also include dbf, shx, prj, etc.? Otherwise you comparing a complete<br>
dataset with attributes and metadata against just geometry.<br>
<br>
Andreas<br>
<br>
On 2015-11-12 15:36, Paulo van Breugel wrote:<br>
<br>
> On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn <<a href="mailto:matthias@opengis.ch">matthias@opengis.ch</a>> wrote:<br>
><br>
>> The main issues with spatialite are IMO: It's based on sqlite so<br>
>> deleting columns and renaming columns is not supported by design. We<br>
>> could offer some hacks to bypass this (annoying restriction) from the UI<br>
>> - there is a risk of side effects though. Another property of it is,<br>
>> that it's already 4-5MB big, even when empty. I consider this a major<br>
>> limiting factor as well. Other issues which we were not yet able to<br>
>> solve are its management of the information scheme which keep duplicate<br>
>> entries of tables and columns which need to be properly updated which we<br>
>> apparently do not manage (yet).<br>
>><br>
>> Geopackage is also based on sqlite, so the column delete/rename<br>
>> restrictions apply as well (with the same workaround possibilities). I<br>
>> haven't checked the file size, but if that's smaller, that would be<br>
>> quite nice (does somebody know?).<br>
><br>
> 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.<br>
><br>
>> All the best<br>
>> Matthias<br>
><br>
> _______________________________________________<br>
> Qgis-user mailing list<br>
> <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/08cb8df2/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/08cb8df2/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 7<br>
Date: Thu, 12 Nov 2015 16:17:11 +0100<br>
From: Paulo van Breugel <<a href="mailto:p.vanbreugel@gmail.com">p.vanbreugel@gmail.com</a>><br>
To: "Neumann, Andreas" <<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>><br>
Cc: QGIS user email list <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>><br>
Subject: Re: [Qgis-user] columns in spatialite<br>
Message-ID:<br>
<CAGrkfc+Wu=<a href="mailto:trb9JERW6KUbgQykKH4gQBBWtHUc0u61JBG45kNQ@mail.gmail.com">trb9JERW6KUbgQykKH4gQBBWtHUc0u61JBG45kNQ@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
On Thu, Nov 12, 2015 at 3:48 PM, Neumann, Andreas <<a href="mailto:a.neumann@carto.net">a.neumann@carto.net</a>><br>
wrote:<br>
<br>
> I believe the main difference between SpatiaLite and Geopackage is that a<br>
> SpatiaLite database contains a lot of query functionality and additional<br>
> data (e.g. a big list of CRS) - while Geopackage does not<br>
><br>
That would be a very big list of CRS, or does the query functionality take<br>
that much space? I often used spatialite, but given that I normally use it<br>
to store many layers, I had actually never noticed the large initial size.<br>
This is imho indeed a clear disadvantage when used for data sharing.<br>
<br>
> When you checked filesizes for shp: did you only look at the shp, or also<br>
> include dbf, shx, prj, etc.? Otherwise you comparing a complete dataset<br>
> with attributes and metadata against just geometry.<br>
><br>
<br>
All files, not only the *.shp file. I just created a simple vector layer in<br>
QGIS and saved it as shapefile, geopackage and spatialite file.<br>
<br>
> Andreas<br>
><br>
> On 2015-11-12 15:36, Paulo van Breugel wrote:<br>
><br>
><br>
><br>
> On Thu, Nov 12, 2015 at 1:30 PM, Matthias Kuhn <<a href="mailto:matthias@opengis.ch">matthias@opengis.ch</a>><br>
> wrote:<br>
><br>
>> The main issues with spatialite are IMO: It's based on sqlite so<br>
>> deleting columns and renaming columns is not supported by design. We<br>
>> could offer some hacks to bypass this (annoying restriction) from the UI<br>
>> - there is a risk of side effects though. Another property of it is,<br>
>> that it's already 4-5MB big, even when empty. I consider this a major<br>
>> limiting factor as well. Other issues which we were not yet able to<br>
>> solve are its management of the information scheme which keep duplicate<br>
>> entries of tables and columns which need to be properly updated which we<br>
>> apparently do not manage (yet).<br>
>><br>
>> Geopackage is also based on sqlite, so the column delete/rename<br>
>> restrictions apply as well (with the same workaround possibilities). I<br>
>> haven't checked the file size, but if that's smaller, that would be<br>
>> quite nice (does somebody know?).<br>
><br>
><br>
><br>
> Just checked saving a shapefile of 941 bytes as Spatialite and Geopackage<br>
> file. The first is indeed 4.4MB. The Geopackage is 12.3kB, i.e., larger<br>
> then the shapefile, but the increase is small compared to the spatialite<br>
> file. I am not familiar with the differences, but this makes the Geopackage<br>
> a better candidate imho.<br>
><br>
><br>
>> All the best<br>
>> Matthias<br>
>><br>
><br>
> _______________________________________________<br>
> Qgis-user mailing list<br>
> <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
><br>
><br>
><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/ed072e8d/attachment-0001.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/ed072e8d/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 8<br>
Date: Thu, 12 Nov 2015 15:13:11 -0000<br>
From: "Simon Crombie" <<a href="mailto:simoncrombie@onetel.com">simoncrombie@onetel.com</a>><br>
To: <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>><br>
Subject: [Qgis-user] Importing image to Print Composer<br>
Message-ID: <000601d11d5c$a75cd250$f61676f0$@<a href="http://onetel.com" rel="noreferrer" target="_blank">onetel.com</a>><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
I have set up a print page consisting of map, scale bar, legend and I want<br>
to add an index map showing where my map is located within a regional<br>
context. I have generated the index map in a different QGIS project.<br>
<br>
Firstly is there any way I can put a map from a different project into the<br>
Print Composer?<br>
<br>
So far I have created an image file from the other project then imported<br>
this image into the Print Composer, but noticed that the resolution is very<br>
adversely affected when I do this. So secondly, is there a way of improving<br>
the quality of an image file imported into Print Composer?<br>
<br>
If I generate an image file from Print Composer then paste in my index map<br>
using a graphics programme (Irfanview) the index map quality is far superior<br>
to that when I try and import it into Print Composer.<br>
<br>
Grateful for advice.<br>
<br>
<br>
<br>
------------------------------<br>
<br>
Message: 9<br>
Date: Thu, 12 Nov 2015 16:47:42 +0100<br>
From: DelazJ <<a href="mailto:delazj@gmail.com">delazj@gmail.com</a>><br>
To: Simon Crombie <<a href="mailto:simoncrombie@onetel.com">simoncrombie@onetel.com</a>><br>
Cc: "<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>" <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>><br>
Subject: Re: [Qgis-user] Importing image to Print Composer<br>
Message-ID:<br>
<<a href="mailto:CAECJsSpmsaX%2BFQr12Gmtmf_y-HyPY0ZEks1DYOD2M8TwK0%2BTOw@mail.gmail.com">CAECJsSpmsaX+FQr12Gmtmf_y-HyPY0ZEks1DYOD2M8TwK0+TOw@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi,<br>
Simon, does the map item "overviews" option (<br>
<a href="http://docs.qgis.org/2.8/en/docs/user_manual/print_composer/print_composer.html#overviews" rel="noreferrer" target="_blank">http://docs.qgis.org/2.8/en/docs/user_manual/print_composer/print_composer.html#overviews</a>)<br>
answer your initial need for index?<br>
<br>
2015-11-12 16:13 GMT+01:00 Simon Crombie <<a href="mailto:simoncrombie@onetel.com">simoncrombie@onetel.com</a>>:<br>
<br>
> I have set up a print page consisting of map, scale bar, legend and I want<br>
> to add an index map showing where my map is located within a regional<br>
> context. I have generated the index map in a different QGIS project.<br>
><br>
> Firstly is there any way I can put a map from a different project into the<br>
> Print Composer?<br>
><br>
> So far I have created an image file from the other project then imported<br>
> this image into the Print Composer, but noticed that the resolution is very<br>
> adversely affected when I do this. So secondly, is there a way of improving<br>
> the quality of an image file imported into Print Composer?<br>
><br>
> If I generate an image file from Print Composer then paste in my index map<br>
> using a graphics programme (Irfanview) the index map quality is far<br>
> superior<br>
> to that when I try and import it into Print Composer.<br>
><br>
> Grateful for advice.<br>
><br>
> _______________________________________________<br>
> Qgis-user mailing list<br>
> <a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
> List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/0cc2ea2f/attachment.html" rel="noreferrer" target="_blank">http://lists.osgeo.org/pipermail/qgis-user/attachments/20151112/0cc2ea2f/attachment.html</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br>
------------------------------<br>
<br>
End of Qgis-user Digest, Vol 117, Issue 26<br>
******************************************<br>
</blockquote></div><br></div></div></div></div></div></div>