[Geoserver-devel] GeoPackage core support

GeoServer GeoServer Developer
1

Hi,
I’ve prepared a pull request for GeoPackage core support here:

https://github.com/geoserver/geoserver/pull/2499

The store panels are not limited to any particular extension, while it seems most use gpkg as
the extension, I’ve also seen .db files around. Can anyone share experiences?

In terms of functionality, the vector part seems to work fine, but as Jukka reported its really
slow when extracting a small portion out of a large vector data set, since the spatial index
is not used (however, seems to be simple enough to add support for it, I might look at it
during the long flight to Seul, next week).

The raster part however just does not work, from what it looks by browsing around a
official sample image, it might well be that it’s assuming a flipped y axis (panning east-west
works fine, panning north/south makes the map jump in the opposite direction).
Anyone has time for a quick fix there?

Pull request here:
https://github.com/geoserver/geoserver/pull/2499

Cheers
Andrea

···

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

AVVERTENZE AI SENSI DEL D.Lgs. 196/2003

Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy’s New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.

2

Thanks for doing this.

As noted on the PR, we're getting some failure on a couple of extension
modules, probably for a missing dependency in gs-main (not transient from the
parent pom for reasons I don't understand). After adding that as a dependency,
I get failures in WCS 1.0 and OWS (probably more modules after that - I
stopped commenting them out at this point).
The problem is that we're putting "GeoPackage (mosaic)" in as a format name,
which is causing validation problems. That can be fixed on the GeoTools side
by updating the name (I suggest GeoPackageMosaic - will put up a PR so people
can comment).

The store panels are not limited to any particular extension, while it seems
most use gpkg as
the extension, I've also seen .db files around. Can anyone share
experiences?

The spec says .gpkg - we'll likely get random stuff if we look for .db

Brad

3

Hi Brad,
I spent all the time I had today fixing several errors in the geopackage raster reader, while
there are still some issues, this pull request makes the sample geopackages as well as some
I’ve created with GDAL displayable (before it was a mix of exceptions and wrong outputs):

https://github.com/geotools/geotools/pull/1690

I am now looking at your proposed change, and I’ve merged it in the above pull request.

Now… my next spare time window is going to be Thursday while I’m flying to Seul…
which is too late for the beta release.

Can anybody follow up with these two pull requests and merge them? :slight_smile:

Cheers
Andrea

···

On Sun, Aug 27, 2017 at 11:49 AM, Brad Hards <bradh@anonymised.com1…> wrote:

Thanks for doing this.

As noted on the PR, we’re getting some failure on a couple of extension
modules, probably for a missing dependency in gs-main (not transient from the
parent pom for reasons I don’t understand). After adding that as a dependency,
I get failures in WCS 1.0 and OWS (probably more modules after that - I
stopped commenting them out at this point).
The problem is that we’re putting “GeoPackage (mosaic)” in as a format name,
which is causing validation problems. That can be fixed on the GeoTools side
by updating the name (I suggest GeoPackageMosaic - will put up a PR so people
can comment).

The store panels are not limited to any particular extension, while it seems
most use gpkg as
the extension, I’ve also seen .db files around. Can anyone share
experiences?
The spec says .gpkg - we’ll likely get random stuff if we look for .db

Brad

–

Regards,

Andrea Aime

==
GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

AVVERTENZE AI SENSI DEL D.Lgs. 196/2003

Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.

The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy’s New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.