DGIWG Web Services Technical Panel (WSTP) Meeting ‐ September 20, 2023

NGA GeoPackage Libraries

DGIWG Support

Core Java - Used by Java and Android libraries

Java

GeoPackage Example Generation

Android

GeoPackage Example Generation

iOS

GeoPackage Example Generation

JavaScript

Currently no explicit DGIWG support

SQLite Exec

SQL utility with additional built in GeoPackage functionality and DGIWG validation support.

Requires Java 11 or above
Run as the script, the JAR, or as an alias (the method used in examples below)
Run on a GeoPackage as single operation or as an interactive session

Single Operation

DGIWG GeoPackage Example

$ sql -dgiwg NGA_DGIWG-Example_Ft-Belvoir_15-16_v1-0_19SEP2023.gpkg 

GeoPackage: NGA_DGIWG-Example_Ft-Belvoir_15-16_v1-0_19SEP2023.gpkg
Path: /Users/osbornb/DGIWG/GeoPackages/NGA_DGIWG-Example_Ft-Belvoir_15-16_v1-0_19SEP2023.gpkg
Size: 456 KB (466944 bytes)
Application ID: 1196444487, 0x47504b47, GPKG
User Version: 10301
Max Rows: 100
Max Column Width: 120
Max Lines Per Row: 0 = none

DGIWG GeoPackage
Producer: NGA
Data Product: DGIWG Example
Geographic Coverage Area: Ft Belvoir
Zoom Levels: 15-16
Version: 1.0
Creation Date: 19SEP2023

Passed DGIWG validation

Non DGIWG GeoPackage Example

$ sql -dgiwg example.gpkg 

GeoPackage: example.gpkg
Path: /Users/osbornb/DGIWG/GeoPackages/example.gpkg
Size: 2.56 MB (2682880 bytes)
Application ID: 1196444487, 0x47504b47, GPKG
User Version: 10301
Max Rows: 100
Max Column Width: 120
Max Lines Per Row: 0 = none

DGIWG GeoPackage
File Name: example

DGIWG Validation Errors:
Table: gpkg_metadata, Column: md_standard_uri, Value: https://dgiwg.org/std/dmf/, Key Column: reference_scope, Value: geopackage, Constraint: 'No required metadata with DMF base URI and metadata reference 'geopackage' scope', Requirement: [Number: 14, Name: 'GeoPackage Metadata DMF', Identifier: /req/metadata/dmf]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 / Pseudo-Mercator', Key Column: srs_id, Value: 3857, Constraint: http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 7, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 7, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 8, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 8, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 9, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 9, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 10, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 10, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point1_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 / Pseudo-Mercator', Key Column: srs_id, Value: 3857, Constraint: http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 7, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 7, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 8, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 8, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 9, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 9, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 10, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 10, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line1_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 / Pseudo-Mercator', Key Column: srs_id, Value: 3857, Constraint: http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 18, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon1_tiles, Key Column: zoom_level, Value: 18, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 / Pseudo-Mercator', Key Column: srs_id, Value: 3857, Constraint: http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 6, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 6, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 7, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 7, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 8, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 8, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 9, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 9, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 10, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 10, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry1_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 / Pseudo-Mercator', Key Column: srs_id, Value: 3857, Constraint: http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 18, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 18, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 19, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 19, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 20, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 20, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 21, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: point2_tiles, Key Column: zoom_level, Value: 21, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 / Pseudo-Mercator', Key Column: srs_id, Value: 3857, Constraint: http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 9, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 9, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 10, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 10, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 18, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 18, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 19, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: line2_tiles, Key Column: zoom_level, Value: 19, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 / Pseudo-Mercator', Key Column: srs_id, Value: 3857, Constraint: http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 18, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 18, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 19, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 19, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 20, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 20, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 21, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: polygon2_tiles, Key Column: zoom_level, Value: 21, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 / Pseudo-Mercator', Key Column: srs_id, Value: 3857, Constraint: http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 8, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 8, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 9, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 9, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 10, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 10, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 11, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 12, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 13, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 14, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 15, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 16, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 17, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_width, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 18, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_tile_matrix, Column: tile_height, Value: 512, Key Column: table_name, Value: geometry2_tiles, Key Column: zoom_level, Value: 18, Constraint: 256, Requirement: [Number: 21, Name: 'Tile Matrix Width Height', Identifier: /req/tile/size-matrix]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 / Pseudo-Mercator', Key Column: srs_id, Value: 3857, Constraint: http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 / Pseudo-Mercator', Key Column: srs_id, Value: 3857, Constraint: http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 geodetic', Key Column: srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 geodetic', Key Column: srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 / Pseudo-Mercator', Key Column: srs_id, Value: 3857, Constraint: http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 geodetic', Key Column: srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 / Pseudo-Mercator', Key Column: srs_id, Value: 3857, Constraint: http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_extensions, Column: extension_name, Value: gpkg_webp, Key Column: table_name, Value: webp_tiles, Key Column: column_name, Value: tile_data, Constraint: 'WebP encoding not allowed', Requirement: [Number: 5, Name: 'Extensions Not Allowed', Identifier: /req/extensions/not-allowed]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 geodetic', Key Column: srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 geodetic', Key Column: srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 geodetic', Key Column: srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 geodetic', Key Column: srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 geodetic', Key Column: srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 geodetic', Key Column: srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 geodetic', Key Column: srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 geodetic', Key Column: srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 geodetic', Key Column: srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326, Requirement: [Number: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt]
Table: gpkg_extensions, Column: extension_name, Value: gpkg_geom_CIRCULARSTRING, Key Column: table_name, Value: non_linear_geometries, Key Column: column_name, Value: geometry, Constraint: 'Nonlinear geometry type not allowed', Requirement: [Number: 5, Name: 'Extensions Not Allowed', Identifier: /req/extensions/not-allowed]
Table: gpkg_extensions, Column: extension_name, Value: gpkg_geom_COMPOUNDCURVE, Key Column: table_name, Value: non_linear_geometries, Key Column: column_name, Value: geometry, Constraint: 'Nonlinear geometry type not allowed', Requirement: [Number: 5, Name: 'Extensions Not Allowed', Identifier: /req/extensions/not-allowed]
Table: gpkg_extensions, Column: extension_name, Value: gpkg_geom_CURVEPOLYGON, Key Column: table_name, Value: non_linear_geometries, Key Column: column_name, Value: geometry, Constraint: 'Nonlinear geometry type not allowed', Requirement: [Number: 5, Name: 'Extensions Not Allowed', Identifier: /req/extensions/not-allowed]
Table: gpkg_extensions, Column: extension_name, Value: gpkg_geom_MULTICURVE, Key Column: table_name, Value: non_linear_geometries, Key Column: column_name, Value: geometry, Constraint: 'Nonlinear geometry type not allowed', Requirement: [Number: 5, Name: 'Extensions Not Allowed', Identifier: /req/extensions/not-allowed]
Table: gpkg_extensions, Column: extension_name, Value: gpkg_geom_MULTISURFACE, Key Column: table_name, Value: non_linear_geometries, Key Column: column_name, Value: geometry, Constraint: 'Nonlinear geometry type not allowed', Requirement: [Number: 5, Name: 'Extensions Not Allowed', Identifier: /req/extensions/not-allowed]
Table: gpkg_extensions, Column: extension_name, Value: gpkg_geom_CURVE, Key Column: table_name, Value: non_linear_geometries, Key Column: column_name, Value: geometry, Constraint: 'Nonlinear geometry type not allowed', Requirement: [Number: 5, Name: 'Extensions Not Allowed', Identifier: /req/extensions/not-allowed]
Table: gpkg_extensions, Column: extension_name, Value: gpkg_geom_SURFACE, Key Column: table_name, Value: non_linear_geometries, Key Column: column_name, Value: geometry, Constraint: 'Nonlinear geometry type not allowed', Requirement: [Number: 5, Name: 'Extensions Not Allowed', Identifier: /req/extensions/not-allowed]

Interactive Session

$ sql NGA_DGIWG-Example_Ft-Belvoir_15-16_v1-0_19SEP2023.gpkg 

GeoPackage: NGA_DGIWG-Example_Ft-Belvoir_15-16_v1-0_19SEP2023.gpkg
Path: /Users/osbornb/DGIWG/GeoPackages/NGA_DGIWG-Example_Ft-Belvoir_15-16_v1-0_19SEP2023.gpkg
Size: 456 KB (466944 bytes)
Application ID: 1196444487, 0x47504b47, GPKG
User Version: 10301
Max Rows: 100
Max Column Width: 120
Max Lines Per Row: 0 = none

- Supports most SQLite statements including:
	SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, PRAGMA, VACUUM, etc
- Terminate SQL statements with a ;
- Exit with a single empty line

Commands:

	info              - GeoPackage information
	help              - print this help information
	count             - count database tables
	tables [name]     - list database tables (all or LIKE table name)
	indexes [name]    - list database indexes (all or LIKE index name)
	views [name]      - list database views (all or LIKE view name)
	triggers [name]   - list database triggers (all or LIKE trigger name)
	rows [n]          - display or set the max rows per query
	width [n]         - display or set the max width (in characters) per column
	lines [n]         - display or set the max lines per row
	history           - list successfully executed sql commands
	!!                - re-execute the previous successful sql command
	!n                - re-execute a sql statement by history id n
	!-n               - re-execute a sql statement n commands back in history
	blobs [-e file_extension] [-d directory] [-p pattern]
	                  - write blobs from the previous successful sql command to the file system
	                        ([directory]|blobs)/table_name/column_name/(pk_values|result_index|[pattern])[.file_extension]
	                     file_extension - file extension added to each saved blob file
	                     directory      - base directory to save table_name/column_name/blobs (default is ./blobs)
	                     pattern        - file directory and/or name pattern consisting of column names in parentheses
	                                       (column_name)-(column_name2)
	                                       (column_name)/(column_name2)
	info <name>       - PRAGMA table_info(<name>); SELECT COUNT(*) FROM <name>;
	count <name>      - SELECT COUNT(*) FROM <name>;
	sqlite_master     - SELECT * FROM sqlite_master;
	<name>            - SELECT * FROM <name>;
	vacuum            - VACUUM [INTO 'filename'];
	fk                - PRAGMA foreign_keys [= boolean];
	fkc               - PRAGMA foreign_key_check[(<table-name>)];
	integrity         - PRAGMA integrity_check[(N)];
	quick             - PRAGMA quick_check[(N)];
	contents [name]   - List GeoPackage contents (all or LIKE table name)
	attributes [name] - List GeoPackage attributes tables (all or LIKE table name)
	features [name]   - List GeoPackage feature tables (all or LIKE table name)
	tiles [name]      - List GeoPackage tile tables (all or LIKE table name)
	ginfo <name>      - Query GeoPackage metadata for the table name
	cbounds [-p projection] [name]
	                  - Determine the bounds (using only the contents) of the entire GeoPackage or single table name
	                     projection     - desired projection as 'authority:code' or 'epsg_code'
	bounds [-p projection] [-m] [name]
	                  - Determine the bounds of the entire GeoPackage or single table name
	                     projection     - desired projection as 'authority:code' or 'epsg_code'
	                     m              - manually query unindexed tables
	tbounds [-p projection] [-m] [name]
	                  - Determine the bounds (using only table metadata) of the entire GeoPackage or single table name
	                     projection     - desired projection as 'authority:code' or 'epsg_code'
	                     m              - manually query unindexed tables
	extensions [name] - List GeoPackage extensions (all or LIKE table name)
	geometry <name> [-p projection] [ids]
	                  - Display feature table geometries as Well-Known Text
	                     projection     - desired display projection as 'authority:code' or 'epsg_code'
	                     ids            - single or comma delimited feature table row ids
	geometry <name> [-p projection] <id> <wkt>
	                  - Update or insert a feature table geometry with Well-Known Text
	                     projection     - Well-Known Text projection as 'authority:code' or 'epsg_code'
	                     id             - single feature table row id to update or -1 to insert a new row
	                     wkt            - Well-Known Text
	reproject <name> <projection|optimization> [-z zoom_levels] [reproject_name]
	                  - Reproject tile table tiles to a different projection or optimization
	                     projection     - Projection as 'authority:code' or 'epsg_code'
	                     optimization   - wm, pc, wmw, or pcw
	                        wm             - Web Mercator optimization, minimally tile bounded
	                        pc             - Platte Carre (WGS84) optimization, minimally tile bounded
	                        wmw            - Web Mercator optimization, world bounded with XYZ tile coordinates
	                        pcw            - Platte Carre (WGS84) optimization, world bounded with XYZ tile coordinates
	                     zoom_levels    - Zoom level(s) specified as 'z', 'zmin-zmax', or 'z1,z2,...', (default is all levels)
	                     reproject_name - Reprojection table name (default is <name>)
	dgiwg             - DGIWG GeoPackage Profile validation

Special Supported Cases:

	Drop Column  - Not natively supported in SQLite
	                  * ALTER TABLE table_name DROP column_name
	                  * ALTER TABLE table_name DROP COLUMN column_name
	Copy Table   - Not a traditional SQL statment
	                  * ALTER TABLE table_name COPY TO new_table_name
	Rename Table - User tables are updated throughout the GeoPackage
	                  * ALTER TABLE table_name RENAME TO new_table_name
	Drop Table   - User tables are dropped throughout the GeoPackage
	                  * DROP TABLE table_name

sql> contents

Table: gpkg_contents
-------------------------------------------
| table_name        | data_type           |
-------------------------------------------
| media             | attributes          |
| nga_coverage_data | 2d-gridded-coverage |
| nga_features      | features            |
| nga_tiles         | tiles               |
-------------------------------------------
Rows: 4

sql> ginfo nga_features

Table: gpkg_contents
-----------------------------------------------------------------------------------------------------------------------------------------
| table_name   | data_type | identifier   | description            | last_change              | min_x  | min_y | max_x | max_y | srs_id |
-----------------------------------------------------------------------------------------------------------------------------------------
| nga_features | features  | NGA Features | DGIWG Features example | 2023-09-19T11:23:59.880Z | -180.0 | -90.0 | 180.0 | 90.0  | 4326   |
-----------------------------------------------------------------------------------------------------------------------------------------
Rows: 1

Authority: EPSG
Code: 4326

GEOCCS["WGS 84",
    DATUM["WGS_1984",
        SPHEROID["WGS84",6378137,298.257223563]],
    PRIMEM["Greenwich",0],
    UNIT["degree",0.0174532925199433]]

PROJ: +proj=longlat +datum=WGS84 +no_defs

Table: gpkg_geometry_columns
--------------------------------------------------------------------
| table_name   | column_name | geometry_type_name | srs_id | z | m |
--------------------------------------------------------------------
| nga_features | geometry    | GEOMETRY           | 4326   | 0 | 0 |
--------------------------------------------------------------------
Rows: 1

Table Info: nga_features
---------------------------------------------------------
| cid | name     | type     | notnull | dflt_value | pk |
---------------------------------------------------------
| 0   | id       | INTEGER  | 1       |            | 1  |
| 1   | geometry | GEOMETRY | 0       |            | 0  |
| 2   | name     | TEXT     | 0       |            | 0  |
| 3   | number   | INTEGER  | 0       |            | 0  |
---------------------------------------------------------
Rows: 4

Table: nga_features
------------
| COUNT(*) |
------------
| 3        |
------------
Rows: 1

sql> nga_features

Table: nga_features
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
| id | geometry                                                                                                                 | name                    | number |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 1  | POINT (-77.196736 38.75337)                                                                                              | NGA                     | 1      |
| 2  | LINESTRING (-77.19665 38.756501, -77.196414 38.755979, -77.195518 38.755208, -77.195303 38.755272, -77.195351 38.755459, | NGA Visitor Center Road | 2      |
|    |  -77.195863 38.755697, -77.196328 38.756069, -77.196568 38.756526)                                                       |                         |        |
| 3  | POLYGON ((-77.195299 38.755159, -77.195203 38.75508, -77.19541 38.75493, -77.19535 38.754884, -77.195228 38.754966, -77. | NGA Visitor Center      | 3      |
|    | 195135 38.754889, -77.195048 38.754956, -77.194986 38.754906, -77.194897 38.754976, -77.194953 38.755025, -77.194763 38. |                         |        |
|    | 755173, -77.194827 38.755224, -77.195012 38.755082, -77.195041 38.755104, -77.195028 38.755116, -77.19509 38.755167, -77 |                         |        |
|    | .195106 38.755154, -77.195205 38.755233, -77.195299 38.755159))                                                          |                         |        |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
Rows: 3

sql> ginfo nga_tiles

Table: gpkg_contents
---------------------------------------------------------------------------------------------------------------------------------------------------
| table_name | data_type | identifier | description         | last_change              | min_x      | min_y     | max_x      | max_y     | srs_id |
---------------------------------------------------------------------------------------------------------------------------------------------------
| nga_tiles  | tiles     | NGA Tiles  | DGIWG Tiles example | 2023-09-19T11:23:59.880Z | -8593967.0 | 4685285.0 | -8592745.0 | 4687730.0 | 3857   |
---------------------------------------------------------------------------------------------------------------------------------------------------
Rows: 1

Authority: EPSG
Code: 3857

PROJCS["WGS 84 / Pseudo-Mercator",
    GEOGCS["WGS 84",
        DATUM["WGS_1984",
            SPHEROID["WGS 84",6378137,298.257223563,
                ID["EPSG","7030"]],
            ID["EPSG","6326"]],
        PRIMEM["Greenwich",0,
            ID["EPSG","8901"]],
        UNIT["degree",0.0174532925199433,
            ID["EPSG","9122"]],
        ID["EPSG","4326"]],
    PROJECTION["Mercator_1SP"],
    PARAMETER["central_meridian",0],
    PARAMETER["scale_factor",1],
    PARAMETER["false_easting",0],
    PARAMETER["false_northing",0],
    UNIT["metre",1,
        ID["EPSG","9001"]],
    AXIS["X",EAST],
    AXIS["Y",NORTH],
    ID["EPSG","3857"]]

PROJ: +proj=merc +lon_0=0 +k_0=1 +x_0=0 +y_0=0 +a=6378137 +b=6378137 +units=m +no_defs

Table: gpkg_tile_matrix_set
---------------------------------------------------------------------------------------------------------
| table_name | srs_id | min_x              | min_y             | max_x              | max_y             |
---------------------------------------------------------------------------------------------------------
| nga_tiles  | 3857   | -8593967.964158937 | 4685284.085768163 | -8592744.971706374 | 4687730.070673289 |
---------------------------------------------------------------------------------------------------------
Rows: 1

Table: gpkg_tile_matrix
------------------------------------------------------------------------------------------------------------------------------------------------
| table_name | zoom_level | map_zoom_level | matrix_width | matrix_height | tile_width | tile_height | pixel_x_size       | pixel_y_size       |
------------------------------------------------------------------------------------------------------------------------------------------------
| nga_tiles  | 15         | 15             | 1            | 2             | 256        | 256         | 4.777314267827023  | 4.777314267823385  |
| nga_tiles  | 16         | 16             | 2            | 4             | 256        | 256         | 2.3886571339135116 | 2.3886571339116927 |
------------------------------------------------------------------------------------------------------------------------------------------------
Rows: 2

Table Info: nga_tiles
-----------------------------------------------------------
| cid | name        | type    | notnull | dflt_value | pk |
-----------------------------------------------------------
| 0   | id          | INTEGER | 0       |            | 1  |
| 1   | zoom_level  | INTEGER | 1       |            | 0  |
| 2   | tile_column | INTEGER | 1       |            | 0  |
| 3   | tile_row    | INTEGER | 1       |            | 0  |
| 4   | tile_data   | BLOB    | 1       |            | 0  |
-----------------------------------------------------------
Rows: 5

Table: nga_tiles
------------
| COUNT(*) |
------------
| 6        |
------------
Rows: 1

sql> nga_tiles

Table: nga_tiles
--------------------------------------------------------
| id | zoom_level | tile_column | tile_row | tile_data |
--------------------------------------------------------
| 1  | 15         | 0           | 0        | BLOB      |
| 2  | 15         | 0           | 1        | BLOB      |
| 3  | 16         | 0           | 1        | BLOB      |
| 4  | 16         | 0           | 2        | BLOB      |
| 5  | 16         | 1           | 1        | BLOB      |
| 6  | 16         | 1           | 2        | BLOB      |
--------------------------------------------------------
Rows: 6

sql> extensions

Table: gpkg_extensions
------------------------------------------------------------------------------------------------------------------------------------------------
| table_name                         | column_name       | extension_name           | definition                                               |
------------------------------------------------------------------------------------------------------------------------------------------------
| gpkg_spatial_ref_sys               | definition_12_063 | gpkg_crs_wkt             | http://www.geopackage.org/spec/#extension_crs_wkt        |
| gpkg_metadata                      |                   | gpkg_metadata            | http://www.geopackage.org/spec/#extension_metadata       |
| gpkg_metadata_reference            |                   | gpkg_metadata            | http://www.geopackage.org/spec/#extension_metadata       |
| nga_features                       | geometry          | gpkg_rtree_index         | http://www.geopackage.org/spec/#extension_rtree          |
| gpkg_data_columns                  |                   | gpkg_schema              | http://www.geopackage.org/spec/#extension_schema         |
| gpkg_data_column_constraints       |                   | gpkg_schema              | http://www.geopackage.org/spec/#extension_schema         |
| gpkgext_relations                  |                   | gpkg_related_tables      | http://www.geopackage.org/18-000.html                    |
| nga_features_media                 |                   | gpkg_related_tables      | http://www.geopackage.org/18-000.html                    |
| gpkg_2d_gridded_coverage_ancillary |                   | gpkg_2d_gridded_coverage | http://docs.opengeospatial.org/is/17-066r1/17-066r1.html |
| gpkg_2d_gridded_tile_ancillary     |                   | gpkg_2d_gridded_coverage | http://docs.opengeospatial.org/is/17-066r1/17-066r1.html |
| nga_coverage_data                  | tile_data         | gpkg_2d_gridded_coverage | http://docs.opengeospatial.org/is/17-066r1/17-066r1.html |
| nga_features_tiles                 |                   | gpkg_related_tables      | http://www.geopackage.org/18-000.html                    |
------------------------------------------------------------------------------------------------------------------------------------------------
Rows: 12

sql> dgiwg

DGIWG GeoPackage
Producer: NGA
Data Product: DGIWG Example
Geographic Coverage Area: Ft Belvoir
Zoom Levels: 15-16
Version: 1.0
Creation Date: 19SEP2023

Passed DGIWG validation

sql>