Nobody? Trying to use Geopackage with datetime columns?
I tried to edit a gpkg in QGIS with DB Manager to change the column to a
DATETIME. Which seems
Opening that gpkg in Sqlitebrowser revealed the columns as:
CREATE TABLE "foo"
("fid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"geom" MULTIPOLYGON,
"cell" REAL,
"value" REAL,
"datumtijd" DATETIME NOT NULL)
But still GeoServer does not offer me a TimeDimension..
Anybody?
Regards,
Richard Duivenvoorde
On 29/10/2019 20.44, Richard Duivenvoorde wrote:
> Hi,
>
> I'm trying to get a Geopackage working in latest (2.16) Geoserver as
> WMS-T (WMS with a Time Dimension).
> The data has a geom table with a polygon-"grid" column, a dataset with
> several time-based values per 'cell', AND a view which joins them together.
> The 'Time'-column is a seconds since epoch column.
>
> I found that Sqlite does not have a real datetime format, but does have
> several options to produce Datetime's based on text or integer columns [0].
> But I failed to create a view which could be understand by Geoserver
> that the column created was an actual 'datetime'
> Anybody experience with this, or maybe have some more info?
>
> I also found that the geopackage spec defines a DATE and DATETIME type
> [1] Requirement 5, but saves it as an sort of iso-string. Creating such
> a column did not work either.
> With Geoserver I had the same issue: geoserver did not recognize the
> column as a DateTime.
>
> So I wonder: should I be able to use a Geopackage as a DataStore for a
> layer, to serve as a WMS-T with a TIME dimension?
> Did I miss something?
> Maybe do some remapping of types?
>
> Any hints/tips would be appreciated.
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
