[Qgis-user] Working with geopackages in Qgis

Thu Sep 28 05:07:07 PDT 2017

On Thu, Sep 28, 2017 at 1:56 PM, Stéphane Henriod <s at henriod.info> wrote:

> Hi again Alessandro
>
> One short feedback already (2.99): when I *right-click - Create new
> database* in the browser, I still need to specify a new layer as well.
> Would be great to be able to create an empty database as well
>
> I don't see this as a bug, so not sure if opening a ticket is necessary?
>

No, it's not a bug: I just recycled the pre-existing dialog to create
geopackages (with at least one layer), my changes were limited to pre-fill
the path to the existing DB when opened from an existing connection.

You can fill a ticket as an enhancement, I agree that it would be
desireable to be able to create an empty gpkg, BTW the easy workaround here
is to create a single layer and immediately delete id with a right-click
from the browser.

Cheers

> Cheers
>
> Stéphane
>
>
> Le jeudi 28 septembre 2017, Stéphane Henriod <s at henriod.info> a écrit :
>
>> Wow, that sounds great! Thanks a lot for your efforts here!
>>
>> I added a sentence in the Gdoc, to make sure that we check what is in 3.0
>> before requesting a new feature. I will myself test there and adapt the
>> Gdoc accordingly, where needed
>>
>> Cheers
>> Stéphane
>>
>>
>> Le jeudi 28 septembre 2017, Alessandro Pasotti <apasotti at gmail.com> a
>> écrit :
>>
>>> Hi,
>>>
>>> The following features are now implemented in QGIS3:
>>>
>>> - browse geopackage contents from the browser
>>> - drag and drop layers from any vector and raster layer source into a
>>> geopackage from the browser
>>> - save/store geopackage connections in the browser
>>> - connections can also be created/removed from a contextual menu
>>> (right-click) from the filesystem browser items and are synchronized with
>>> DB-manager)
>>> - deletion of vectors and raster layers from an existing geopackage
>>> - synchronization from the DB-manager to the browser (the other way is
>>> not currently implemented)
>>>
>>> I probably forget some other minor improvements.
>>>
>>> All this development is rather recent and any help with testing would be
>>> much appreciated.
>>>
>>> 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.
>>>
>>> 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.
>>>
>>> Cheers
>>>
>>>
>>> On Thu, Sep 28, 2017 at 8:45 AM, Stéphane Henriod <s at henriod.info>
>>> wrote:
>>>
>>>> Hi Andreas
>>>>
>>>> Thanks for your comments!
>>>>
>>>> Here the Gdoc with my first ideas: https://docs.google.com
>>>> /document/d/1xp36eR0DYThpTCNsWUam5JhFKVjOVpmRObwWSPjkrbc/edi
>>>> t?usp=sharing
>>>>
>>>> Cheers
>>>> Stéphane
>>>>
>>>>
>>>> Stéphane Henriod
>>>> CIM-Expert for GIS and Green Economy Statistics
>>>>
>>>> Национальный статистический комитет Кыргызской Республики
>>>> Кыргыз Республикасынын Улуттук статистика комитети
>>>> National Statistical Committee of the Kyrgyz Republic
>>>>
>>>> 374 Фрунзе ул. / Frunze str.
>>>> 720033 Бишкек / Bishkek
>>>>
>>>> T   +996 778 46 99 02 (KG)
>>>> T   +49 176 280 11 050 <+49%20176%2028011050> (DE)
>>>> E    s at henriod.info
>>>> W   http://www.stat.kg
>>>> W3W: nightfall.into.bucket
>>>> <https://map.what3words.com/nightfall.into.bucket>  //
>>>> запас.союз.дружный <https://map.what3words.com/запас.союз.дружный>
>>>>
>>>> 2017-09-28 12:23 GMT+06:00 Andreas Neumann <a.neumann at carto.net>:
>>>>
>>>>> Hi Stéphane,
>>>>>
>>>>> 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.
>>>>>
>>>>> 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.
>>>>>
>>>>> 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.
>>>>>
>>>>> 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 QGIS.ORG could help
>>>>> with the financing aspect.
>>>>>
>>>>> Some feedback to your 3 issues:
>>>>>
>>>>> ad 1): you are right - it is not possible to easily create an empty
>>>>> geopackage. One always starts with a vector layer.
>>>>>
>>>>> ad 2): this should be fixed in QGIS master (QGIS 3). Just tested,
>>>>> works fine
>>>>>
>>>>> ad 3): yes, would be useful
>>>>>
>>>>> I am sure there are more issues. Would be useful to collect them for
>>>>> further improvements.
>>>>>
>>>>> Do you want to start a document? I would be glad to assist you.
>>>>>
>>>>> 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.
>>>>>
>>>>> Greetings,
>>>>>
>>>>> Andreas
>>>>>
>>>>> On 2017-09-28 06:47, Stéphane Henriod wrote:
>>>>>
>>>>> Dear all
>>>>>
>>>>> 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 :-)
>>>>>
>>>>> [currently testing on 2.18.11]
>>>>>
>>>>> 1) Creating a Geopackage DB
>>>>>
>>>>> 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.
>>>>>
>>>>> Of course, I can create a geopackage layer and delete it later, but
>>>>> this is not super intuitive for the users
>>>>>
>>>>> 2) Qgis browser
>>>>>
>>>>> 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
>>>>>
>>>>> 3) Multi-export to Geopackage
>>>>>
>>>>> 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 *Save all layers as...* in
>>>>> the contextual menu, when I select more than 1 layer)
>>>>>
>>>>>
>>>>> Just curious if those needs / ideas resonate and / or if there are
>>>>> already plans in these directions
>>>>>
>>>>> Thanks and cheers
>>>>> Stéphane
>>>>>
>>>>> _______________________________________________
>>>>> Qgis-user mailing list
>>>>> Qgis-user at lists.osgeo.org
>>>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>>
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> Qgis-user mailing list
>>>> Qgis-user at lists.osgeo.org
>>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>
>>>
>>>
>>>
>>> --
>>> Alessandro Pasotti
>>> w3:   www.itopen.it
>>>
>>
>>
>> --
>> Stéphane Henriod
>> CIM-Expert for GIS and Green Economy Statistics
>>
>> Национальный статистический комитет Кыргызской Республики
>> Кыргыз Республикасынын Улуттук статистика комитети
>> National Statistical Committee of the Kyrgyz Republic
>>
>> 374 Фрунзе ул. / Frunze str.
>> 720033 Бишкек / Bishkek
>>
>> T   +996 778 46 99 02 (KG)
>> T   +49 176 280 11 050 <+49%20176%2028011050> (DE)
>> E    s at henriod.info
>> W   http://www.stat.kg
>> W3W: nightfall.into.bucket
>> <https://map.what3words.com/nightfall.into.bucket>  //
>> запас.союз.дружный <https://map.what3words.com/запас.союз.дружный>
>>
>>
>
> --
> Stéphane Henriod
> CIM-Expert for GIS and Green Economy Statistics
>
> Национальный статистический комитет Кыргызской Республики
> Кыргыз Республикасынын Улуттук статистика комитети
> National Statistical Committee of the Kyrgyz Republic
>
> 374 Фрунзе ул. / Frunze str.
> 720033 Бишкек / Bishkek
>
> T   +996 778 46 99 02 (KG)
> T   +49 176 280 11 050 <+49%20176%2028011050> (DE)
> E    s at henriod.info
> W   http://www.stat.kg
> W3W: nightfall.into.bucket
> <https://map.what3words.com/nightfall.into.bucket>  //  запас.союз.дружный
> <https://map.what3words.com/запас.союз.дружный>
>
>

-- 
Alessandro Pasotti
w3:   www.itopen.it
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170928/8c59635a/attachment.html>