[gdal-dev] SQL script for creating a test GeoPackage

[Even Rouault]

Le jeudi 23 avril 2015 18:54:14, Jukka Rahkonen a écrit :
> Hi,
> 
> Inspired by this Spatialite forum thread
> https://groups.google.com/d/msg/spatialite-users/rBKeuXLpQv8/THStsQdQXI0J I
> started to write a SQL script that creates a GeoPackage database with all
> the metadata tables, triggers etc. and also data tables for every possible
> geometry type, each with one column for every possible data type, populated
> with some data that suits the type.
> 
> However, I started to think that this is so obvious that someone must have
> done that already and that could save me a few hours. Even, Pepijn, where
> do you have your SQL? This Python in autotest directory probably has it
> all http://trac.osgeo.org/gdal/browser/trunk/autotest/ogr/ogr_gpkg.py.

Jukka,

some time ago, I had shared something like this with the geopackage community 
( http://www.geopackage.org/#implementations ), generated by OGR and provided 
the Python script to do it ( 
http://www.geopackage.org/data/generate_sample_gpkg.py ).

It probably lacks a few data types (boolean, tinyint, integer should now be 
reachable with the latest additions in OGR) and the curve geometries.

Even

> 
> The ultimate GeoPackage experts could then inspect the resulting GPKG
> database byte by byte and once it is perfect it could be shared to
> everybody and used in the conformance tests.
> 
> If I copy and paste right the columns will be:
> 
> BOOLEAN
> TINYINT
> SMALLINT
> MEDIUMINT
> INTEGER
> INT
> FLOAT
> DOUBLE
> TEXT
> BLOB
> GEOMETRY
> DATE
> DATETIME
> 
> And the basic geometry types:
> GEOMETRY
> POINT
> LINESTRING
> POLYGON
> MULTIPOLYGON
> MULTILINESTRING
> MULTIPOLYGON
> GEOMETRYCOLLECTION
> 
> And the extented geometry types:
> CIRCULARSTRING
> COMPOUNDCURVE
> CURVEPOLYGON
> MULTICURVE
> MULTISURFACE
> CURVE
> SURFACE
> 
> I have no idea about how I could insert contents to these but I think they
> should be put into their own database anyways.
> 
> -Jukka Rahkonen-
> 
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com