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. Regards, Richard Duivenvoorde [0] https://www.sqlite.org/draft/lang_datefunc.html [1] http://www.geopackage.org/spec/ _______________________________________________ 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
