We're looking at using GeoServer with data stored in Oracle 12c modelled
using its new valid time capability [1]. (Actually the data is modelled
using the Flashback Archive support for transaction time as well, making it
bitemporal. But the valid time dimension is of most interesting for
mapping).
Has anyone had experience of using 12c valid time queries through GeoServer?
It would be great if the WMS TIME dimension worked with 12c, but that seems
like it might require some enhancements. (Any estimate of level of
difficulty for this?)
The use of SQLViews also comes to mind, but this seems to have two issues:
- it would be necessary to supply a fairly complex substitution parameter
value (e.g. "AS OF PERIOD FOR etc"
- this would have to be supplied for each temporal layer in a WMS query
But possibly this is doable, via some smarts in the client (or even a proxy
which adds the time filter to the request)
In the bigger picture, with SQL:2011 temporal features [2] slowly making
their way into database implementations, this kind of capability might be
worth addressing in GeoServer at a deeper level.
[1]
http://docs.oracle.com/cd/E16655_01/appdev.121/e17620/adfns_design.htm#ADFNS967
[2] http://en.wikipedia.org/wiki/SQL:2011#Temporal_support
------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
