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. 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 [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
