GeoPackage NSG test "match Annex Table Test" fails due to errors in GeoPackage files "GeoPackage_Vector_Orion" and "GeoPackage-Raster_Orion"

Test suite used for testing: Current master branch (0.4-SNAPSHOT) of https://github.com/opengeospatial/ets-gpkg12-nsg.

Error reported by test suite:

The gpkg_tile_matrix table contains invalid Pixels Size or Matrix Size values for tables: Imagery (4326, Zoom Level: 0): Pixel Size X: 0.03125; but expected 0.703125, Imagery (4326, Zoom Level: 1): Pixel Size X: 0.015625; but expected 0.3515625, Imagery (4326, Zoom Level: 2): Pixel Size X: 0.0078125; but expected 0.17578125, Imagery (4326, Zoom Level: 3): Pixel Size X: 0.00390625; but expected 0.087890625, Imagery (4326, Zoom Level: 4): Pixel Size X: 0.001953125; but expected 0.0439453125, Imagery (4326, Zoom Level: 5): Pixel Size X: 9.765625E-4; but expected 0.0219726563, Imagery (4326, Zoom Level: 6): Pixel Size X: 4.8828125E-4; but expected 0.0109863281, Imagery (4326, Zoom Level: 7): Pixel Size X: 2.44140625E-4; but expected 0.0054931641, Imagery (4326, Zoom Level: 8): Pixel Size X: 1.220703125E-4; but expected 0.002746582, Imagery (4326, Zoom Level: 9): Pixel Size X: 6.103515625E-5; but expected 0.001373291

Requirements:


NSG Req 4: World Mercator (EPSG::3395) and UPS North/South (EPSG::5041/5042) raster 
tile pyramid GeoPackages SHALL follow the technical guidance provided in Annex C: 
Implementation Guide for EPSG::3395 Tiles or Annex D: Implementation Guide for UPS Tiles.

NSG Req 5: WGS 84 Geographic 2D (EPSG::4326) raster tile pyramid GeoPackages SHALL follow the technical guidance in Annex E: Implementation Guide for 4326 Tiles


* Executed SQL-Statement:

SELECT tm.table_name AS tabName, sel.data_type AS dataTyp, sel.crs_id AS crsID, tm.zoom_level AS zoomLvl, tm.matrix_width AS matrixW, tm.matrix_height AS matrixH, tm.tile_width AS tileW, tm.tile_height AS tileH, tm.pixel_x_size AS pixelSzX, tm.pixel_y_size AS pixelSzY FROM gpkg_tile_matrix tm INNER JOIN ( SELECT gc.table_name, gc.data_type, gs.organization_coordsys_id as crs_id
from gpkg_contents gc inner join gpkg_spatial_ref_sys gs where gc.srs_id=gs.srs_id) AS sel ON tm.table_name=sel.table_name WHERE crsID IN (3395, 4326) ORDER BY zoomLvl;

* returns:

tabName,dataTyp,crsID,zoomLvl,matrixW,matrixH,tileW,tileH,pixelSzX,pixelSzY Imagery,tiles,4326,0,1,1,256,256,0.031250,0.031250 Imagery,tiles,4326,1,1,1,256,256,0.015625,0.015625 Imagery,tiles,4326,2,2,2,256,256,0.007812,0.007812 Imagery,tiles,4326,3,4,4,256,256,0.003906,0.003906 Imagery,tiles,4326,4,8,8,256,256,0.001953,0.001953 Imagery,tiles,4326,5,16,16,256,256,0.000977,0.000977 Imagery,tiles,4326,6,32,32,256,256,0.000488,0.000488 Imagery,tiles,4326,7,64,64,256,256,0.000244,0.000244 Imagery,tiles,4326,8,128,128,256,256,0.000122,0.000122 Imagery,tiles,4326,9,256,256,256,256,0.000061,0.000061


* this does not match the values from Annex E
=> Test failure is correct.

opengeospatial / geoedge-plugfest

GeoPackage NSG test "match Annex Table Test" fails due to errors in GeoPackage files "GeoPackage_Vector_Orion" and "GeoPackage-Raster_Orion" #62