[Geoserver-users] Support for SQL 'Interval' type in GeoServer

Hello All,

I have a table with int,timestamp,string and an interval.

But it seems like GeoServer does not support the ‘interval’ type.

Is it likely to be supported? or is my best bet to just have an additional field that takes the interval type and converts it to string?.

Thanks.

On Mon, Nov 4, 2013 at 1:27 AM, snuffy <snuffy22@anonymised.com> wrote:

Hello All,

I have a table with int,timestamp,string and an interval.

But it seems like GeoServer does not support the 'interval' type.

Is it likely to be supported? or is my best bet to just have an additional
field that takes the interval type and converts it to string?.

It will get supported the first time someone needs it badly enough to
implement themselves, or sponsor someone to
do that for them (which involves dealing with the new type at the data
level, encoding filters involving it, encoding and parsing
it in GML2/3/3.2,GeoJSON, decide what to do with zipped shapefiles, how to
use it in WMS, and so on), all in all it's a sizeable
amount of work.

You decide which is the best route for you. :slight_smile:

Cheers
Andrea

--

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

Thanks Andrea,

Sorry for the late reply.

Thought that might have been the case, although I doubt i’ll take it on could you give example of what java files etc need to be created/edited to support the additional type? (rather new to the codebase)

I did try mapping my duration to a string (sql side) which GeoServer did read, then hoped when it tried to encode the output xml it would just use a regex from xsd to determine if the duration was valid but alas still empty field ;).

···

On 4 November 2013 17:56, Andrea Aime <andrea.aime@anonymised.com> wrote:

On Mon, Nov 4, 2013 at 1:27 AM, snuffy <snuffy22@anonymised.com> wrote:

Hello All,

I have a table with int,timestamp,string and an interval.

But it seems like GeoServer does not support the ‘interval’ type.

Is it likely to be supported? or is my best bet to just have an additional field that takes the interval type and converts it to string?.

It will get supported the first time someone needs it badly enough to implement themselves, or sponsor someone to
do that for them (which involves dealing with the new type at the data level, encoding filters involving it, encoding and parsing
it in GML2/3/3.2,GeoJSON, decide what to do with zipped shapefiles, how to use it in WMS, and so on), all in all it’s a sizeable
amount of work.

You decide which is the best route for you. :slight_smile:

Cheers
Andrea

==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

Ing. Andrea Aime

@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it