|
|
Richard Duivenvoorde created an issue |
|
In vector GPKG with DateTime field Geoserver sees it as a String field |
|
Issue Type: |
|
|---|---|
|
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: |
|
|
Reporter: |
|
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. 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). |
|
|
|
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) |
|
|
|