<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">https://docs.google.com/document/d/1xp36eR0DYThpTCNsWUam5JhFKVjOVpmRObwWSPjkrbc/edit?usp=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="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><font face="arial, helvetica, sans-serif" size="2">Stéphane Henriod</font></div><div><font face="arial, helvetica, sans-serif" size="2">CIM-Expert for GIS and Green Economy Statistics</font></div><div><font face="arial, helvetica, sans-serif" size="2"><br></font></div><div><font face="arial, helvetica, sans-serif" size="2">Национальный статистический комитет Кыргызской Республики</font></div><div><font face="arial, helvetica, sans-serif" size="2">Кыргыз Республикасынын Улуттук статистика комитети</font></div><div><font face="arial, helvetica, sans-serif" size="2">National Statistical Committee of the Kyrgyz Republic</font></div><div><font face="arial, helvetica, sans-serif" size="2"><br></font></div><div><font face="arial, helvetica, sans-serif" size="2">374 Фрунзе ул. / Frunze str.</font></div><div><font face="arial, helvetica, sans-serif" size="2">720033 Бишкек / Bishkek</font></div><div><font face="arial, helvetica, sans-serif" size="2"><br></font></div><div><font face="arial, helvetica, sans-serif" size="2">T +996 778 46 99 02 (KG)</font></div><div><font face="arial, helvetica, sans-serif" size="2">T +49 176 280 11 050 (DE)</font></div><div><font face="arial, helvetica, sans-serif" size="2">E <a href="mailto:s@henriod.info" target="_blank">s@henriod.info</a></font></div><div><font face="arial, helvetica, sans-serif" size="2">W <a href="http://www.stat.kg" target="_blank">http://www.stat.kg</a></font></div><div><font face="arial, helvetica, sans-serif" size="2">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>
<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="h5">
<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="h5">
<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_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/<wbr>mailman/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/<wbr>mailman/listinfo/qgis-user</a></div>
</blockquote>
<p><br></p>
</div>
</blockquote></div><br></div>