Skip to content

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

Jump to bottom
Brian Osborn edited this page Sep 19, 2023 · 20 revisions

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>

DGIWG Example GeoPackage

Screenshot 2023-09-19 at 6 41 38 AM

Screenshot 2023-09-19 at 6 50 28 AM

Screenshot 2023-09-19 at 6 50 35 AM

Table Data

Screenshot 2023-09-19 at 6 16 34 AM

Screenshot 2023-09-19 at 6 17 39 AM

Screenshot 2023-09-19 at 6 17 57 AM

Screenshot 2023-09-19 at 6 18 25 AM

Screenshot 2023-09-19 at 6 19 14 AM

Screenshot 2023-09-19 at 6 19 43 AM

Screenshot 2023-09-19 at 6 19 59 AM

Screenshot 2023-09-19 at 6 21 00 AM

Screenshot 2023-09-19 at 6 22 00 AM

Screenshot 2023-09-19 at 6 22 25 AM

Screenshot 2023-09-19 at 6 56 31 AM

Screenshot 2023-09-19 at 6 57 23 AM

Screenshot 2023-09-19 at 6 58 12 AM

Screenshot 2023-09-19 at 6 58 53 AM

Screenshot 2023-09-19 at 7 00 00 AM

Screenshot 2023-09-19 at 7 00 51 AM

Screenshot 2023-09-19 at 7 03 38 AM

Screenshot 2023-09-19 at 7 04 14 AM

Screenshot 2023-09-19 at 7 04 48 AM

Clone this wiki locally