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
<mailto: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 <mailto: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 <mailto: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
<mailto: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
<mailto: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
------------------------------------------------------------------------------
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
