Hi Mickael, Ok, I will have a look at JTS.
Joda seems to be able perform a smart parsing of textual dates, trying a list of patterns (ISO, etc.) Nicolas On 27 December 2015 at 18:56, Michaël Michaud <m.michael.mich...@orange.fr> wrote: > Hi Nicolas, > > JTS WKBReader should be able to read 3D geometries. > > Why do you need Joda to parse dates ? Isn't SimpleDateParser good enough > to do the job ? > > Michaël > > Le 27/12/2015 18:42, Nicolas Ribot a écrit : > > Hi, > > I commited support for SQLite GeoPackage specifications. > 2D objects stored in gpkg formats are available as Datasources. (3D > objects are not yet supported by JTS WKBReader, AFAIU) > > Date and Datetime SQLite database types are forced to String types in OJ > (same behaviour as DB Query) > After some readings, Joda (http://www.joda.org/joda-time/) could be a > solution to try a date parsing instead of forcing a String Java type. > > I used some DB Query methods to convert blobs into geometry objects. Now > DBQuery is integrated to OJ Plus, could it be possible to expose needed > methods from DBQuery and use them directly in SpatialDatabases code ? > Currently, code is duplicated, which is not very clean. > > Nicolas > > > > On 27 December 2015 at 14:14, Nicolas Ribot <nicolas.ri...@gmail.com> > wrote: > >> Hi, I commited some corrections for MySQL/MariaDB: >> >> • OGC geometry_columns table is now used if available (OGR, for instance, >> creates OGC metadata tables when loading into MySQL) >> >> • ResultSetConverter was changed to cope with MySQL binary format, that >> stores SRID information in the first 4 bytes of the blob. It rises a >> problem: how to correctly detect OGC WKB format from native MySQL format ? >> >> Larry, DBQuery assumes the MySQL binary format stores 4 "0" bytes at the >> beginning, which is the case only when a geometry is built with no SRID or >> SRID set to 0: >> >> select st_geomfromtext('POINT(0 0)'); >> -- 00 00 00 00 01 01 ... >> >> select st_geomfromtext('POINT(0 0)', 1); >> -- 01 00 00 00 01 01 ... >> >> select st_geomfromtext('POINT(0 0)', 12345); >> -- 39 30 00 00 01 01 ... >> >> >> Nicolas >> >> >> On 23 December 2015 at 16:34, Nicolas Ribot < <nicolas.ri...@gmail.com> >> nicolas.ri...@gmail.com> wrote: >> >>> Hi, >>> >>> There are some problems with mariaDB and MySQL spatial types: I'm having >>> a look at them. >>> >>> Nicolas >>> >>> On 23 December 2015 at 11:43, Nicolas Ribot < <nicolas.ri...@gmail.com> >>> nicolas.ri...@gmail.com> wrote: >>> >>>> Hi, >>>> >>>> Sorry, was not available for some days. >>>> Great devs on Spatial DB ! >>>> >>>> I will have some tests with both db's, now I have MySQL on OSX and >>>> MariaDB on Windows VM. >>>> >>>> Nicolas >>>> >>>> On 23 December 2015 at 10:48, < <edgar.sol...@web.de> >>>> edgar.sol...@web.de> wrote: >>>> >>>>> hey Jukka, Nico, >>>>> >>>>> there are now two MySQL datastores utilizing either the mysql or the >>>>> mariadb driver. can one of you check quickly if that still works out. been >>>>> careful, but who knows. >>>>> >>>>> PLUS contains all uptodate jdbc's now except oracle. >>>>> >>>>> thx.. ede >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> _______________________________________________ >>>>> Jump-pilot-devel mailing list >>>>> Jump-pilot-devel@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>> >>>> >>>> >>> >> > > > ------------------------------------------------------------------------------ > > > > _______________________________________________ > Jump-pilot-devel mailing > listJump-pilot-devel@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > >
------------------------------------------------------------------------------
_______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
