Package org.opengis.cite.gpkg12.tiles

Class TileTests

java.lang.Object

org.opengis.cite.gpkg12.CommonFixture

org.opengis.cite.gpkg12.TileFixture

org.opengis.cite.gpkg12.tiles.TileTests

public class TileTests
extends TileFixture

Defines test methods that apply to descriptive information about a GeoPackage's content as it pertains to tiles.

Sources

• GeoPackage Encoding Standard - 2.2. Tiles (OGC 12-128r12)

Author:

Luke Lambert, Jeff Yutzler

Field Summary

Fields inherited from class org.opengis.cite.gpkg12.TileFixture

jpegImageReaders, pngImageReaders, TileTableExpectedColumns, tileTableNames

Fields inherited from class org.opengis.cite.gpkg12.CommonFixture

databaseConnection, dataSource, geopackageVersion, gpkgFile, ROOT_PKG_PATH

Constructor Summary

Constructors

Constructor	Description
TileTests()

Method Summary

Modifier and Type	Method	Description
void	imageFormat()	In a GeoPackage that contains a tile pyramid user data table that contains tile data that is not MIME type image/jpeg, by default SHALL store that tile data in MIME type image/png.
void	imageFormatJpg()	In a GeoPackage that contains a tile pyramid user data table that contains tile data that is not MIME type image/png, by default SHALL store that tile data in MIME type image/jpeg.
void	matrixHeightGreaterThanZero()	matrix_height column value in a gpkg_tile_matrix table row SHALL be greater than 0.
void	matrixSetNameForEachTilesTable()	The gpkg_tile_matrix_set table or view SHALL contain one row record for each tile pyramid user data table.
void	matrixSetNamesReferenceTiles()	Values of the gpkg_tile_matrix_set table_name column SHALL reference values in the gpkg_contents table_name column for rows with a data type of "tiles".
void	matrixSetSrsIdReferencesGoodId()	Values of the gpkg_tile_matrix_set srs_id column SHALL reference values in the gpkg_spatial_ref_sys srs_id
void	matrixWidthGreaterThanZero()	matrix_width column value in a gpkg_tile_matrix table row SHALL be greater than 0.
void	pixelXSizeGreaterThanZero()	pixel_x_size column value in a gpkg_tile_matrix table row SHALL be greater than 0.
void	pixelYSizeGreaterThanZero()	pixel_y_size column value in a gpkg_tile_matrix table row SHALL be greater than 0.
void	sortedPixelSizes()	The pixel_x_size and pixel_y_size column values for zoom_level column values in a gpkg_tile_matrix table sorted in ascending order SHALL be sorted in descending order.
void	tileColumnRange()	For each distinct table_name from the gpkg_tile_matrix (tm) table, the tile pyramid (tp) user data table tile_column column value in a GeoPackage SHALL be in the range <= tp.tile_column <= tm.matrix_width - 1 where the tm and tp zoom_level column values are equal.
void	tileHeightGreaterThanZero()	tile_height column value in a gpkg_tile_matrix table row SHALL be greater than 0.
void	tileMatrixDimensionAgreement()	The width of a tile matrix (the difference between min_x and max_x in gpkg_tile_matrix_set) SHALL equal the product of matrix_width, tile_width, and pixel_x_size for that zoom level.
void	tileMatrixPerZoomLevel()	The gpkg_tile_matrix table or view SHALL contain one row record for each zoom level that contains one or more tiles in each tile pyramid user data table or view.
void	tileMatrixSetDataValuesSrsId()	Test case /opt/tiles/gpkg_tile_matrix_set/data/data_values_srs_id_match
void	tileMatrixSetTable()	A GeoPackage that contains a tile pyramid user data table SHALL contain gpkg_tile_matrix_set table or view per Table Definition, Tile Matrix Set Table or View Definition and gpkg_tile_matrix_set Table Creation SQL.
void	tileMatrixTableContentsReferences()	Values of the gpkg_tile_matrix table_name column SHALL reference values in the gpkg_contents table_name column for rows with a data_type of 'tiles'.
void	tileMatrixTableDefinition()	A GeoPackage that contains a tile pyramid user data table SHALL contain a gpkg_tile_matrix table or view per clause 2.2.7.1.1 Table Definition, Table Tile Matrix Metadata Table or View Definition and Table gpkg_tile_matrix Table Creation SQL.
void	tileRowRange()	For each distinct table_name from the gpkg_tile_matrix (tm) table, the tile pyramid (tp) user data table tile_row column value in a GeoPackage SHALL be in the range 0 <= tp.tile_row <= tm.matrix_height - 1 where the tm and tp zoom_level column values are equal.
void	tilesTableDefinitions()	Each tile matrix set in a GeoPackage SHALL be stored in a different tile pyramid user data table or updateable view with a unique name that SHALL have a column named "id" with column type INTEGER and PRIMARY KEY AUTOINCREMENT column constraints per Clause 2.2.8.1.1 Table Definition, Tiles Table or View Definition and EXAMPLE: tiles table Insert Statement (Informative).
void	tileWidthGreaterThanZero()	tile_width column value in a gpkg_tile_matrix table row SHALL be greater than 0.
void	zoomLevelNotNegative()	The zoom_level column value in a gpkg_tile_matrix table row SHALL not be negative.
void	zoomLevelRange()	For each distinct table_name from the gpkg_tile_matrix (tm) table, the tile pyramid (tp) user data table zoom_level column value in a GeoPackage SHALL be in the range min(tm.zoom_level) <= tp.zoom_level <= max(tm.zoom_level).
void	zoomTimesTwo()	In a GeoPackage that contains a tile pyramid user data table that contains tile data, by default, zoom level pixel sizes for that table SHALL vary by a factor of 2 between adjacent zoom levels in the tile matrix metadata table.

Methods inherited from class org.opengis.cite.gpkg12.TileFixture

canReadImage, isAcceptedImageFormat, isEqual, setDataType, setUp

Methods inherited from class org.opengis.cite.gpkg12.CommonFixture

checkPrimaryKey, close, getGeopackageVersion, getPrimaryKeyColumn, getTestName, initCommonFixture, isExtendedType, setTestName, validateClassEnabled

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

TileTests

public TileTests()

Method Details

zoomTimesTwo

public void zoomTimesTwo()
                  throws SQLException

In a GeoPackage that contains a tile pyramid user data table that contains tile data, by default, zoom level pixel sizes for that table SHALL vary by a factor of 2 between adjacent zoom levels in the tile matrix metadata table.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Zoom Times Two - Requirement 35

imageFormat

public void imageFormat()
                 throws SQLException,
IOException

In a GeoPackage that contains a tile pyramid user data table that contains tile data that is not MIME type image/jpeg, by default SHALL store that tile data in MIME type image/png.

Throws:

SQLException - If an SQL query causes an error

IOException - If the bytes of an image cause an error when read

See Also:

• MIME Type PNG - Requirement 36

imageFormatJpg

public void imageFormatJpg()

In a GeoPackage that contains a tile pyramid user data table that contains tile data that is not MIME type image/png, by default SHALL store that tile data in MIME type image/jpeg.

See Also:

• MIME Type JPEG - Requirement 37

tileMatrixSetTable

public void tileMatrixSetTable()
                        throws SQLException

A GeoPackage that contains a tile pyramid user data table SHALL contain gpkg_tile_matrix_set table or view per Table Definition, Tile Matrix Set Table or View Definition and gpkg_tile_matrix_set Table Creation SQL.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix Set - Table Definition - Requirement 38

matrixSetNamesReferenceTiles

public void matrixSetNamesReferenceTiles()
                                  throws SQLException

Values of the gpkg_tile_matrix_set table_name column SHALL reference values in the gpkg_contents table_name column for rows with a data type of "tiles".

Throws:

SQLException - If an SQL query causes an error

See Also:

• Table Data Values - Requirement 39

matrixSetNameForEachTilesTable

public void matrixSetNameForEachTilesTable()
                                    throws SQLException

The gpkg_tile_matrix_set table or view SHALL contain one row record for each tile pyramid user data table.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Table Data Values - Requirement 40

matrixSetSrsIdReferencesGoodId

public void matrixSetSrsIdReferencesGoodId()
                                    throws SQLException

Values of the gpkg_tile_matrix_set srs_id column SHALL reference values in the gpkg_spatial_ref_sys srs_id

Throws:

SQLException - If an SQL query causes an error

See Also:

• Table Data Values - Requirement 41

tileMatrixSetDataValuesSrsId

public void tileMatrixSetDataValuesSrsId()
                                  throws SQLException

Test case /opt/tiles/gpkg_tile_matrix_set/data/data_values_srs_id_match

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix Set SRS ID Column - Requirement 147

tileMatrixTableDefinition

public void tileMatrixTableDefinition()
                               throws SQLException

A GeoPackage that contains a tile pyramid user data table SHALL contain a gpkg_tile_matrix table or view per clause 2.2.7.1.1 Table Definition, Table Tile Matrix Metadata Table or View Definition and Table gpkg_tile_matrix Table Creation SQL.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix - Table Definition - Requirement 42

tileMatrixTableContentsReferences

public void tileMatrixTableContentsReferences()
                                       throws SQLException

Values of the gpkg_tile_matrix table_name column SHALL reference values in the gpkg_contents table_name column for rows with a data_type of 'tiles'.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix - Table Data Values - Requirement 43

tileMatrixPerZoomLevel

public void tileMatrixPerZoomLevel()
                            throws SQLException

The gpkg_tile_matrix table or view SHALL contain one row record for each zoom level that contains one or more tiles in each tile pyramid user data table or view.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix - Table Data Values - Requirement 44

tileMatrixDimensionAgreement

public void tileMatrixDimensionAgreement()
                                  throws SQLException

The width of a tile matrix (the difference between min_x and max_x in gpkg_tile_matrix_set) SHALL equal the product of matrix_width, tile_width, and pixel_x_size for that zoom level. Similarly, height of a tile matrix (the difference between min_y and max_y in gpkg_tile_matrix_set) SHALL equal the product of matrix_height, tile_height, and pixel_y_size for that zoom level.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix - Table Data Values - Requirement 45

zoomLevelNotNegative

public void zoomLevelNotNegative()
                          throws SQLException

The zoom_level column value in a gpkg_tile_matrix table row SHALL not be negative.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix - Table Data Values - Requirement 46

matrixWidthGreaterThanZero

public void matrixWidthGreaterThanZero()
                                throws SQLException

matrix_width column value in a gpkg_tile_matrix table row SHALL be greater than 0.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix - Table Data Values - Requirement 47

matrixHeightGreaterThanZero

public void matrixHeightGreaterThanZero()
                                 throws SQLException

matrix_height column value in a gpkg_tile_matrix table row SHALL be greater than 0.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix - Table Data Values - Requirement 48

tileWidthGreaterThanZero

public void tileWidthGreaterThanZero()
                              throws SQLException

tile_width column value in a gpkg_tile_matrix table row SHALL be greater than 0.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix - Table Data Values - Requirement 49

tileHeightGreaterThanZero

public void tileHeightGreaterThanZero()
                               throws SQLException

tile_height column value in a gpkg_tile_matrix table row SHALL be greater than 0.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix - Table Data Values - Requirement 50

pixelXSizeGreaterThanZero

public void pixelXSizeGreaterThanZero()
                               throws SQLException

pixel_x_size column value in a gpkg_tile_matrix table row SHALL be greater than 0.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix - Table Data Values - Requirement 51

pixelYSizeGreaterThanZero

public void pixelYSizeGreaterThanZero()
                               throws SQLException

pixel_y_size column value in a gpkg_tile_matrix table row SHALL be greater than 0.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix - Table Data Values - Requirement 52

sortedPixelSizes

public void sortedPixelSizes()
                      throws SQLException

The pixel_x_size and pixel_y_size column values for zoom_level column values in a gpkg_tile_matrix table sorted in ascending order SHALL be sorted in descending order.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Matrix - Table Data Values - Requirement 53

tilesTableDefinitions

public void tilesTableDefinitions()
                           throws SQLException

Each tile matrix set in a GeoPackage SHALL be stored in a different tile pyramid user data table or updateable view with a unique name that SHALL have a column named "id" with column type INTEGER and PRIMARY KEY AUTOINCREMENT column constraints per Clause 2.2.8.1.1 Table Definition, Tiles Table or View Definition and EXAMPLE: tiles table Insert Statement (Informative).

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Pyramid User Data Tables - Table Definition - Requirement 54

zoomLevelRange

public void zoomLevelRange()
                    throws SQLException

For each distinct table_name from the gpkg_tile_matrix (tm) table, the tile pyramid (tp) user data table zoom_level column value in a GeoPackage SHALL be in the range min(tm.zoom_level) <= tp.zoom_level <= max(tm.zoom_level).

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Pyramid User Data Tables - Table Data Values - Requirement 55

tileColumnRange

public void tileColumnRange()
                     throws SQLException

For each distinct table_name from the gpkg_tile_matrix (tm) table, the tile pyramid (tp) user data table tile_column column value in a GeoPackage SHALL be in the range <= tp.tile_column <= tm.matrix_width - 1 where the tm and tp zoom_level column values are equal.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Pyramid User Data Tables - Table Data Values - Requirement 56

tileRowRange

public void tileRowRange()
                  throws SQLException

For each distinct table_name from the gpkg_tile_matrix (tm) table, the tile pyramid (tp) user data table tile_row column value in a GeoPackage SHALL be in the range 0 <= tp.tile_row <= tm.matrix_height - 1 where the tm and tp zoom_level column values are equal.

Throws:

SQLException - If an SQL query causes an error

See Also:

• Tile Pyramid User Data Tables - Table Data Values - Requirement 57