[Qgis-user] Working with geopackages in Qgis

Thu Sep 28 04:56:42 PDT 2017

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?

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
> <javascript:_e(%7B%7D,'cvml','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 (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/20170928/5b444122/attachment.html>