[Qgis-user] Working with geopackages in Qgis

Thu Sep 28 03:16:46 PDT 2017

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
> <javascript:_e(%7B%7D,'cvml','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/edit?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 <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/запас.союз.дружный>
>>
>> 2017-09-28 12:23 GMT+06:00 Andreas Neumann <a.neumann at carto.net
>> <javascript:_e(%7B%7D,'cvml','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
>>> <javascript:_e(%7B%7D,'cvml','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
>> <javascript:_e(%7B%7D,'cvml','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
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/b261fc1a/attachment.html>