Re: [JPP-Devel] final touches to db datastores

2015-12-29 Thread Nicolas Ribot
Thanks for the info, Larry :) I will use the DB types. Nicolas On 28 December 2015 at 17:10, Larry Reeder wrote: > > >> 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: >> >>

Re: [JPP-Devel] final touches to db datastores

2015-12-28 Thread Larry Reeder
> > 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: > > Thanks for the info, Nicolas. I couldn't find any docs for the MySQL binary format at the time I was writing the plugin, a

Re: [JPP-Devel] final touches to db datastores

2015-12-28 Thread edgar . soldin
your extension, your decision. thanks.. ede On 28.12.2015 14:59, Larry Reeder wrote: > I'd prefer #2. Because DBQuery is small and self-contained, it's much > easier to maintain if it stays out of the OJ baseline. > > -lreeder > > On Sun, Dec 27, 2015 at 10:58 AM, wrote: > >> On 27.12.2015

Re: [JPP-Devel] final touches to db datastores

2015-12-28 Thread Larry Reeder
I'd prefer #2. Because DBQuery is small and self-contained, it's much easier to maintain if it stays out of the OJ baseline. -lreeder On Sun, Dec 27, 2015 at 10:58 AM, wrote: > On 27.12.2015 18:42, Nicolas Ribot wrote: > > I used some DB Query methods to convert blobs into geometry objects.

Re: [JPP-Devel] final touches to db datastores

2015-12-27 Thread Michaël Michaud
Hi Nicolas, For date parsing, you can also have a look at com.vividsolutions.jump.util.FlexibleDateParser which is used at several places in OpenJUMP code. Michaël Le 27/12/2015 19:00, Nicolas Ribot a écrit : Hi Mickael, Ok, I will have a look at JTS. Joda seems to be able perform a smart pa

Re: [JPP-Devel] final touches to db datastores

2015-12-27 Thread edgar . soldin
On 27.12.2015 19:01, Nicolas Ribot wrote: >> >> >> i suggest that either >> >> 1. larry moves his extension into CORE, depending what his plans are with >> it, so more people can work on it >> >> 2. you work your generalized routines into a jdbc/WKBUtil class or >> similar, so Larry can reuse them

Re: [JPP-Devel] final touches to db datastores

2015-12-27 Thread Nicolas Ribot
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 wrote: > Hi Nicolas, > > JTS WKBReader should be able to read 3D geometries. > > Why do you ne

Re: [JPP-Devel] final touches to db datastores

2015-12-27 Thread edgar . soldin
On 27.12.2015 18:42, Nicolas Ribot wrote: > 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, whi

Re: [JPP-Devel] final touches to db datastores

2015-12-27 Thread Michaël Michaud
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 gp

Re: [JPP-Devel] final touches to db datastores

2015-12-27 Thread Nicolas Ribot
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

Re: [JPP-Devel] final touches to db datastores

2015-12-27 Thread Nicolas Ribot
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

Re: [JPP-Devel] final touches to db datastores

2015-12-23 Thread Nicolas Ribot
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 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

Re: [JPP-Devel] final touches to db datastores

2015-12-23 Thread Nicolas Ribot
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, wrote: > hey Jukka, Nico, > > there are now two MySQL datastores utilizing either the mysql or

[JPP-Devel] final touches to db datastores

2015-12-23 Thread edgar . soldin
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 -