CWIX feedback: provide verbose report of SQLite Exec test failure #64
jamesresslernga
started this conversation in
Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
From the multi-national CWIX24 nations used SQLite Exec to verify GeoPackage data against the GeoPackage profile. The users requested a more verbose reporting of SQLite Exec tests that fail. For example, it failed a GeoPacakge using EPSG 3395 and EPSG 4326, both of whichare a required CRS required in DGIWG profile. Alos failed EPSG 3857, which is permitted CRS, but not required. The test output did not state why this CRS failed the test. This coud be a bug in SQLite Exec or a non-conformant definiton of ESPG 3395.
The output from SQLite Exec. below.
GeoPackage successfully uploaded to the GeoMetOc Portal.
Table: gpkg_spatial_ref_sys, Column: srs_name, Value:
WGS_1984_World_Mercator, PK: srs_id, Value: 3395, Constraint:
http://www.opengis.net/def/crs/EPSG/0/3395, Requirement: 11, Name: 'Well Known
Text for CRS', Identifier: /req/crs/wkt
GeoPackage successfully uploaded to the GeoMetOc portal.
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: 'WGS 84 /
Pseudo-Mercator', PK: srs_id, Value: 3857, Constraint:
http://www.opengis.net/def/crs/EPSG/0/3857, Requirement: 11, Name: 'Well Known
Text for CRS', Identifier: /req/crs/wkt
Jim Ressler is the POC with NGA standards (TAES) who shared SQLite Exec with DGIWG members forthe CWIX GeoMetoc test objective for GeoPackage.
GeoPackage successfully uploaded to the GeoMetOc Portal. Searchable with TC
number.
Table: gpkg_spatial_ref_sys, Column: srs_name, Value: GCS_WGS_1984, PK:
srs_id, Value: 4326, Constraint: http://www.opengis.net/def/crs/EPSG/0/4326,
Requirement: 11, Name: 'Well Known Text for CRS', Identifier: /req/crs/wkt
Overall, the test failure reports are too cryptic to help the users determine the reason for the failure.
Beta Was this translation helpful? Give feedback.
All reactions