[Qgis-user] Working with geopackages in Qgis

Thu Sep 28 08:38:00 PDT 2017

Feature request here: https://issues.qgis.org/issues/17217

Cheers
Stéphane

Le jeudi 28 septembre 2017, Alessandro Pasotti <apasotti at gmail.com> a
écrit :

>
> On Thu, Sep 28, 2017 at 1:56 PM, Stéphane Henriod <s at henriod.info
> <javascript:_e(%7B%7D,'cvml','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
>> <javascript:_e(%7B%7D,'cvml','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 <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/запас.союз.дружный>
>>
>>
>
>
> --
> 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
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/20170928/167fa9fe/attachment.html>