[Qgis-user] Working with geopackages in Qgis

Fri Sep 29 04:19:49 PDT 2017

Another bug report (or feature request?) here:
https://issues.qgis.org/issues/17220

When I create metadata for a Geopackage layer, they are apparently not saved


Le jeudi 28 septembre 2017, Stéphane Henriod <s at henriod.info> a écrit :

> Feature request here: https://issues.qgis.org/issues/17217
>
> Cheers
> Stéphane
>
>
> Le jeudi 28 septembre 2017, Alessandro Pasotti <apasotti at gmail.com
> <javascript:_e(%7B%7D,'cvml','apasotti at gmail.com');>> a écrit :
>
>>
>> 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
>>
>
>
> --
> 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 (DE)
> E    s at henriod.info <javascript:_e(%7B%7D,'cvml','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 (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/запас.союз.дружный>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170929/d660dd48/attachment.html>