You'll need to take a look at the PostGIS JDBC plugin to get you started, you should be able to extend most of it and just need to work on the dialect to add in the changes you need.
Ian On Tue, 16 May 2023 at 12:05, WaZy <snaele...@gmail.com> wrote: > I forgot that there exists a MobilityDB-JDBC driver, can I use it to > implement those mapping in a simpler way ? > > Le mar. 16 mai 2023 à 11:23, WaZy <snaele...@gmail.com> a écrit : > >> I actually have a type implemented in MobilityDB known as tgeompoint, it >> is a type used to represent points moving in time( trips). For example this >> is what a tgeompoint looks like : >> >> tgeompoint '[Point(0 0)@2000-01-01, Point(100 100)@2000-01-02 >> >> For your 2 first questions I didn't understand what you were asking so >> maybe know that you see what it looks like we have a better idea than me. >> >> For your last question I have already taken a look at PostGISDialect but I >> don't know what I should do to have the same thing for mobilityDB and how >> would I test it? >> >> Do I have to extend this class since mobility+DB is built on top of PostGIS? >> Or is there a better way to do that? >> >> Wassim >> >> >> >> Le lun. 15 mai 2023 à 22:41, Jody Garnett <jody.garn...@gmail.com> a >> écrit : >> >>> There are a number of ways to model locations changing in time. Do you >>> have a series of time stamped records each Ruth’s location? If so the >>> existing temporal support should be fine? >>> >>> Or do you have a spatial temporal reference burst as some kind of XYZM >>> geometry with M being some kind of timestamp? If so you probably have >>> functions to work with your type? >>> >>> Have a look at PostGISDialect for type mapping; you can make something >>> similar for MobilityDB? >>> >>> Jody >>> >>> On Mon, May 15, 2023 at 6:59 AM WaZy <snaele...@gmail.com> wrote: >>> >>>> Hello I'm new here and I would like to know how I could add the mapping >>>> for a new type in GeoTool. I'm actually using MobilityDB which is an >>>> extension to the PostgreSQL database system and its spatial extension >>>> PostGIS. It allows temporal and spatio-temporal objects to be stored in the >>>> database, that is, objects whose attribute values and/or location evolves >>>> in time.I want to visualize data with Geoserver but it do not allow me to >>>> read the data because those types are unknown to Geotool if I understood >>>> correctly. >>>> >>>> The message I get in the logs is : No mapping found for "myAttribute" >>>> set to read only. >>>> >>>> >>>> This is why I want to know how I could do that and if it is a hard >>>> task. >>>> >>>> Best regards. >>>> _______________________________________________ >>>> GeoTools-Devel mailing list >>>> GeoTools-Devel@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/geotools-devel >>>> >>> -- >>> -- >>> Jody Garnett >>> >> _______________________________________________ > GeoTools-Devel mailing list > GeoTools-Devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel > -- Ian Turton
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
