Didn't :-)
Next try: not attached but downloadable: https://duif.net/dt.zip
In the meantime I also created an issue:
https://osgeo-org.atlassian.net/browse/GEOS-9392
Follow up (well I hope this attachment makes it through spamfilters...).
Attached a minimal gpkg created with QGIS with a dt column being type
DATETIME. Both in QGIS and in sqlitebrowser the type of the column is
shown as DATETIME, attached also a screenie of sqlitebrowser.
But registring this gpkg in Geoserver, the dt column is determined as a
String column (also screenie attached).
Maybe I'll create an issue for this with same files attached.
Regards,
Richard Duivenvoorde
On 04/11/2019 09.37, Richard Duivenvoorde wrote:
> 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
>
_______________________________________________
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
