[Geoserver-devel] [JIRA] (GEOS-9392) In vector GPKG with DateTime field Geoserver sees it as a String field

[Richard Duivenvoorde (JIRA)]

Title: Message Title

Richard Duivenvoorde created an issue   GeoServer / GEOS-9392 In vector GPKG with DateTime field Geoserver sees it as a String field Issue Type: Bug Affects Versions: 2.16.0 Assignee: Unassigned Attachments: datetimetest.gpkg, geoserver.png, sqlitebrowser.png Components: geopackage, WMS Created: 04/Nov/19 10:26 AM Environment: Running Platform Independent Binary on Debian 64bits using OpenJDK Priority: Medium Reporter: Richard Duivenvoorde We try to create a WMS-T (timebased wms) with GeoPackages (Vector) as datastores (actual data are model runs). But whatever I try, Geoserver never recognizes the DateTime column in the Geopackage as a DateTime column. So when publishing it as a (WMS) layer I'm not able to add a Time-based Dimension to it. Making it impossible to create a WMS-T from it. To make this reproducible, I created a minimal gpkg in QGIS, setting the datatype of the 'dt' column as DateTime. Both QGIS and SqliteBrowser show the type as DateTime (see screendump sqlitebrowser.png). But registring this as datetimetest.gpkg as store and registring it as a layer, you will see geoserver.png showing you dt is a String. In the real data, the gpkg consists of 2 tables (one with a polygon-grid, and one with time-value data 50 records per grid-cell) and one view which joins these together to a view of 3000000 records). Add Comment   Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100114-sha1:56bac0f)

_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel