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 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 <mailto: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 <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
<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
<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
