<div dir="ltr"><div><div><div><div><div><div><div><div><div><div>Hi,<br><br></div>The following features are now implemented in QGIS3:<br></div><div><br></div><div>- browse geopackage contents from the browser<br></div>- drag and drop layers from any vector and raster layer source into a geopackage from the browser<br></div>- save/store geopackage connections in the browser <br></div><div>- connections can also be created/removed from a contextual menu (right-click) from the filesystem browser items and are synchronized with DB-manager)<br></div>- deletion of vectors and raster layers from an existing geopackage<br></div>- synchronization from the DB-manager to the browser (the other way is not currently implemented)<br></div><br></div>I probably forget some other minor improvements.<br><br></div></div>All this development is rather recent and any help with testing would be much appreciated.<br><br></div>Please keep in mind that you need at least GDAL 2.2.2 to overcome some bugs on Windows, Linux works fine with 2.2.1.<br><div><div><div><div><div><div><br></div><div>Many thanks to Boundless Spatial Inc. for funding this development and to
Even Roualt and Nyall Dawson for all the assistance they gave me during
the development.</div><div><br><div>Cheers<br></div><div><div><br></div></div></div></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Sep 28, 2017 at 8:45 AM, Stéphane Henriod <span dir="ltr"><<a href="mailto:s@henriod.info" target="_blank">s@henriod.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Andreas<div><br></div><div>Thanks for your comments!</div><div><br></div><div>Here the Gdoc with my first ideas: <a href="https://docs.google.com/document/d/1xp36eR0DYThpTCNsWUam5JhFKVjOVpmRObwWSPjkrbc/edit?usp=sharing" target="_blank">https://docs.google.<wbr>com/document/d/<wbr>1xp36eR0DYThpTCNsWUam5JhFKVjOV<wbr>pmRObwWSPjkrbc/edit?usp=<wbr>sharing</a></div><div><br></div><div>Cheers</div><div>Stéphane</div><div><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="m_251554960124127405gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><font size="2" face="arial, helvetica, sans-serif">Stéphane Henriod</font></div><div><font size="2" face="arial, helvetica, sans-serif">CIM-Expert for GIS and Green Economy Statistics</font></div><div><font size="2" face="arial, helvetica, sans-serif"><br></font></div><div><font size="2" face="arial, helvetica, sans-serif">Национальный статистический комитет Кыргызской Республики</font></div><div><font size="2" face="arial, helvetica, sans-serif">Кыргыз Республикасынын Улуттук статистика комитети</font></div><div><font size="2" face="arial, helvetica, sans-serif">National Statistical Committee of the Kyrgyz Republic</font></div><div><font size="2" face="arial, helvetica, sans-serif"><br></font></div><div><font size="2" face="arial, helvetica, sans-serif">374 Фрунзе ул. / Frunze str.</font></div><div><font size="2" face="arial, helvetica, sans-serif">720033 Бишкек / Bishkek</font></div><div><font size="2" face="arial, helvetica, sans-serif"><br></font></div><div><font size="2" face="arial, helvetica, sans-serif">T +996 778 46 99 02 (KG)</font></div><div><font size="2" face="arial, helvetica, sans-serif">T <a href="tel:+49%20176%2028011050" value="+4917628011050" target="_blank">+49 176 280 11 050</a> (DE)</font></div><div><font size="2" face="arial, helvetica, sans-serif">E <a href="mailto:s@henriod.info" target="_blank">s@henriod.info</a></font></div><div><font size="2" face="arial, helvetica, sans-serif">W <a href="http://www.stat.kg" target="_blank">http://www.stat.kg</a></font></div><div><font size="2" face="arial, helvetica, sans-serif">W3W: <a href="https://map.what3words.com/nightfall.into.bucket" target="_blank">nightfall.into.bucket</a> // <a href="https://map.what3words.com/запас.союз.дружный" target="_blank">запас.союз.дружный</a></font></div></div></div></div><div><div class="h5">
<br><div class="gmail_quote">2017-09-28 12:23 GMT+06:00 Andreas Neumann <span dir="ltr"><<a href="mailto:a.neumann@carto.net" target="_blank">a.neumann@carto.net</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="font-size:10pt;font-family:Verdana,Geneva,sans-serif">
<p>Hi Stéphane,</p>
<p>Thanks for your ideas. It is my personal goal (and the goal of the Swiss QGIS user group) to make Geopackage the number 1 file-based format in QGIS and put Shapefiles in the graveyard.</p>
<p>Therefore we paid Even Rouault in the past for some geopackage improvements. Swiss provinces also invested into a tool name ili2gpkg - a tool that can read official swiss data models in Interlis format and generate the data structure in a geopackage - incl. import of data, if it already exists. This is in parallel with a similar tool called ili2pg that does the same for Postgis.</p>
<p>As you discovered there are more issues around Geopackages to make them as hassle-free as possible. I also think the raster part of geopackages did not get too much attention so far.</p>
<p>Since you have been so successful with your campaign around improving discrete/paletted rasters - may I suggest the same for Geopackage improvements? You can start a list of useful improvements in a Google Docs document or on Github as a QEP. Other people can contribute and we can find a way to fund the improvements. Both QGIS-CH and <a href="http://QGIS.ORG" target="_blank">QGIS.ORG</a> could help with the financing aspect.</p>
<p>Some feedback to your 3 issues:</p>
<p>ad 1): you are right - it is not possible to easily create an empty geopackage. One always starts with a vector layer.</p>
<p>ad 2): this should be fixed in QGIS master (QGIS 3). Just tested, works fine</p>
<p>ad 3): yes, would be useful</p>
<p>I am sure there are more issues. Would be useful to collect them for further improvements.</p>
<p>Do you want to start a document? I would be glad to assist you.</p>
<p>Let's also think about rasters. E.g. saving to a Geopackage should be as easy as saving to a TIFF-file. Also in Processing. But I have to admit I haven't really tested the raster part of Geopackage a lot. Maybe some things are already possible.</p>
<p>Greetings,</p>
<p>Andreas</p><div><div class="m_251554960124127405h5">
<p>On 2017-09-28 06:47, Stéphane Henriod wrote:</p>
</div></div><blockquote type="cite" style="padding:0 0.4em;border-left:#1010ff 2px solid;margin:0"><div><div class="m_251554960124127405h5">
<div dir="ltr">Dear all
<div> </div>
<div>I am making a few tests with Geopackages and I have a short list of behaviors or features that, IMO, would be quite nice to have in Qgis. But I'd like to have feedback from some of you before moving ahead. Maybe the majority disagrees with my opinion or maybe I have overlooked some already existing features :-)</div>
<div> </div>
<div>[currently testing on 2.18.11]</div>
<div> </div>
<div>1) Creating a Geopackage DB</div>
<div> </div>
<div>As far as I see, the only way to create a Geopackage DB in Qgis is to create a new Geopackage layer. But there are cases where I don't want to create a new layer. I only want to create an empty Geopackage, so that I can later, e.g. import a bunch of shapefiles into it.</div>
<div> </div>
<div>Of course, I can create a geopackage layer and delete it later, but this is not super intuitive for the users</div>
<div> </div>
<div>2) Qgis browser</div>
<div> </div>
<div>It would also be very handy to be able to browse the content of a Geopackage within the Qgis browser, so that we can drag-and-drop layers directly to the project</div>
<div> </div>
<div>3) Multi-export to Geopackage</div>
<div> </div>
<div>If I want to migrate a whole project from Shapefiles and Tiff files to a single Geopackage DB, I would like to multi-select them and drag-and-drop them into an existing Geopackage DB (or a <em>Save all layers as...</em> in the contextual menu, when I select more than 1 layer)</div>
<div> </div>
<div> </div>
<div>Just curious if those needs / ideas resonate and / or if there are already plans in these directions</div>
<div> </div>
<div>Thanks and cheers</div>
<div>Stéphane</div>
</div>
<br>
</div></div><div class="m_251554960124127405m_3356294234435607090pre" style="margin:0;padding:0;font-family:monospace">______________________________<wbr>_________________<br> Qgis-user mailing list<br> <a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br> List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noopener noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/qgis-user</a><br> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noopener noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/qgis-user</a></div>
</blockquote>
<p><br></p>
</div>
</blockquote></div><br></div></div></div>
<br>______________________________<wbr>_________________<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="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/qgis-user</a><br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Alessandro Pasotti<br>w3: <a href="http://www.itopen.it" target="_blank">www.itopen.it</a></div>
</div>