Triggers sound like a good idea. As for the geometry objects, I think the spec
has changed.
https://github.com/opengeospatial/geopackage/blob/master/spec/2a_features.adoc#core-types
The geometry encoding is the same, but the column type should be POINT,
LINESTRING, POLYGON ect.. instead of blob. The genomes_belgium.gpkg [1]
example data set and GDAL both encode the geometry columns as POINT et al.
Do you think it would be ok to set the default extent in gpkg_contents to be
0,0,1,1 or the extent of the projection? GDAL can’t open geopackage databases
without some value for min_x, min_y, max_x, max_y. ogrinfo 1.11.0 errors out
with a segmentation fault and QGIS 2.6 crashes.
Thanks,
Jared
[1] http://www.geopackage.org/data/geonames_belgium.gpkg
On Dec 28, 2014, at 10:10 AM, Justin Deoliveira <[email protected]> wrote:
> Hey Jared,
>
> Perhaps I haven't looked a the spec recently but I thought with geopackage
> geometry objects were supposed to be represented as blobs so that it could be
> used without the need for any other libraries like spatialite. Unless there
> is some sort of type aliasing going on?
>
> As for updating bounds in gpkg_contents automatically I am thinking that the
> driver should put some triggers in place to do this. We could re-use the
> functions that Niels implemented for spatial indexing capabilities to pull
> out the min/max x/y from geometry blobs for this.
>
> -Justin
>
>
>
> On Fri, Dec 26, 2014 at 4:24 PM, jerickson <[email protected]> wrote:
> Hi all!
>
> One of my holiday vacation projects is to get a Geotools generated
> GeoPackage vector database working with QGIS and GDAL. The first issue I
> ran into was that QGIS and GDAL don't recognize the geometry column because
> it's type is BLOB. GDAL creates geometry columns with a type like GEOMETRY,
> POINT, MULTIPOLYGON ect... I have a fix for this. The second issue is that
> QGIS and GDAL expect the gpkg_contents entry to have valid min_x, min_y,
> max_x, and max_y values. Is there some way to have GeoTools update this
> bounds after every write?
>
> Thanks,
> Jared
>
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/GeoPackage-and-QGIS-GDAL-Compatibility-tp5179287.html
> Sent from the geotools-devel mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming! The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net
> _______________________________________________
> GeoTools-Devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>
------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
