Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-27 Thread edgar . soldin
On 27.12.2013 16:22, Rahkonen Jukka wrote: > However, I am not sure what dlls are compulsory for making GDAL to work for > each formats. There may be some hidden dependencies. that's the reason i kept it as is.. also - for extra packages my tolerance wrt. download size is much higher. some tenth

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-27 Thread Rahkonen Jukka
Hi, I think that it is the right thing to do and with 3.8.x snaphot version because we know that 3.7.x will make trouble with the next to come Spatialite native binaries. OJ+ would then have a fast pure java spatialite blob reader out-of-the box. We could prepare a separate download for spatia

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-27 Thread Larry Reeder
lite-4.2.0-test-win-amd64.7z > >> > >> The speed is really good. On a 64-bit laptop the direct blob reader > gets 50 OpenStreetMap multipolygons in 4 seconds, and reading the same > polygons reprojected to other SRS with Spatialite binaries takes 34 seconds. &

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-27 Thread Larry Reeder
> Larry: will you integrate the sqlite-jdbc-*.jar into your extensions > distro? > Sure. I'll also add the MySQL JDBC drivers for symmetry. I'll consider adding Oracle, but the requirement to accept Oracle's export licenses makes it tricky. -lreeder

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-25 Thread edgar . soldin
OpenStreetMap multipolygons in 4 seconds, and reading the same >> polygons reprojected to other SRS with Spatialite binaries takes 34 seconds. >> >> -Jukka- >> >> >> Lähettäjä: edgar.sol...@web.de [edgar.sol...@web.d

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-25 Thread Rahkonen Jukka
äjä: edgar.sol...@web.de [edgar.sol...@web.de] > Lähetetty: 25. joulukuuta 2013 12:25 > Vastaanottaja: OpenJump develop and use > Aihe: Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS > > Jukka & all, > > would you like to see the SQLite jdbc driver part of DBQuery extensi

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-25 Thread edgar . soldin
inaries takes 34 seconds. > > -Jukka- > > > Lähettäjä: edgar.sol...@web.de [edgar.sol...@web.de] > Lähetetty: 25. joulukuuta 2013 12:25 > Vastaanottaja: OpenJump develop and use > Aihe: Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-25 Thread Rahkonen Jukka
binaries takes 34 seconds. -Jukka- Lähettäjä: edgar.sol...@web.de [edgar.sol...@web.de] Lähetetty: 25. joulukuuta 2013 12:25 Vastaanottaja: OpenJump develop and use Aihe: Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS Jukka & all, would you like to

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-25 Thread edgar . soldin
Jukka & all, would you like to see the SQLite jdbc driver part of DBQuery extension or rather download it separately for sake of small distro size? ..ede On 24.12.2013 23:37, Rahkonen Jukka wrote: > Hi, > > To be best compatible with the next version of Spatialite native binaries it > would b

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-24 Thread Rahkonen Jukka
Hi, To be best compatible with the next version of Spatialite native binaries it would be good to use a jdbc driver for SQLite version 3.8. A snapshot is available at https://oss.sonatype.org/content/repositories/snapshots/org/xerial/sqlite-jdbc/3.8.0-SNAPSHOT/sqlite-jdbc-3.8.0-20130827.035027-1

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-24 Thread edgar . soldin
i would make including sqlite jar depending on how your extension handles it. meaning, we actually package your extension, so if it is included in there it'll end up in OJ, if not you hopefully have it documented in a readme or such ;) ..ede On 24.12.2013 16:33, Larry Reeder wrote: > Hey Ede,

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-24 Thread Larry Reeder
Hey Ede, I tested with OpenJUMP-20131224-r3854-PLUS (jar installer, installing on Linux), and it didn't work initially due to missing sqlite JDBC jars. I added the jdbc jar to the classpath (put it in lib/ext/jumpdbquery-0.9.0) and multigeometries worked great. If you want to add SQLite JDBC d

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-24 Thread edgar . soldin
Larry, Jukka, i just committed jts 1.14 snapshot to OJ trunk. could one of you please check if the spatialite multigeometry bug has vanished finally? happy holidays.. ede On 23.12.2013 04:40, Martin Davis wrote: > Thanks, Larry. Patch is commited. > > Martin > > > On Sun, Dec 22, 2013 at 9

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-23 Thread edgar . soldin
please do so :) Martin just committed a fix that we'd (OpenJUMP) very much like to have. could you please just ping if it is up and we'll integrate and mirror it. ..thanks ede On 23.12.2013 23:50, Michael Bedward wrote: > Hi Martin, Edgar, > > Yep - I could do a snapshot release to the Sonatyp

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-23 Thread edgar . soldin
Martin, is there a (maven) snapshot we can include? ..ede On 23.12.2013 04:40, Martin Davis wrote: > Thanks, Larry. Patch is commited. > > Martin > > > On Sun, Dec 22, 2013 at 9:22 AM, Larry Reeder > wrote: > > Martin, I've attached a patch for WKBReader th

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-22 Thread Larry Reeder
Martin, I've attached a patch for WKBReader that uses the initial endian flag for multigeometries and ignores the flag for contained geometries if the endianness flag is something besides the XDR/NDR flags. The patch also includes a test case that use multigeometries exported from the Spatialite

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-02 Thread Larry Reeder
Now that cold is here, I've got more time to stay indoors and code. I'm willing to submit a JTS patch with sample data and unit tests. Martin, in implementing the patch, I will be following the guidance in your suggestion on April 21, 2013: " The WKBReader can be changed to only switch endianes

Re: [JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-02 Thread edgar . soldin
On 02.12.2013 22:11, Rahkonen Jukka wrote: > Hi, > > We have many exciting new features and I suppose we will have a great new > OpenJUMP 1.7 rather soon. It would be excellent to have a well working > Spatialite support in OJ 1.7 Plus through DB Query plugin, but the issue with > reading multi

[JPP-Devel] OJ 1.7, DB Query, Spatialite and JTS

2013-12-02 Thread Rahkonen Jukka
Hi, We have many exciting new features and I suppose we will have a great new OpenJUMP 1.7 rather soon. It would be excellent to have a well working Spatialite support in OJ 1.7 Plus through DB Query plugin, but the issue with reading multigeometries remains [1]. Martin almost promised to make