Hi, Why not to offer a really cutting edge Spatialite support with OpenJUMP? Dowload sizes are not at all huge
- jts 1.4 snapshot - no extra - sqlite-jdbc-3.8.0-20130827.035027-1.jar - 3.5 MB - spatialite-4.2.0-test-win-x86 (native Spatialite dlls for Win-32) 2.5 MB zipped - spatialite-4.2.0-test-win-amd64 (native Spatialite dlls for Win-32) 2.6 MB zipped All these are not offially available with any other GIS program so we could stand on a peak for a while. Packages take only 9 MB extra space when zipped and under 40 MB after unzipping the dll files. I have made tests with 32-bit and 64-bit Windows. Both the pure java blob reading and advanced Spatialite stuff seems to work OK. For testing with spatialite dlls I placed the all the dll files into lib\ext and added the following string into spatialite connection ?spatialite=spatialite.dll Ede may know how to install the native 32/64 bit stuff so that right version will be selected and that the spatialite.dll finds right versions of the dependencies. About real spatialite support for Linux and Mac, I have no idea about how to do that. It looks like 80% of OJ downloads are for Windows so perhaps it would be acceptable to support only Windows at first. The download links for the Windows binaries can be found from document http://www.gaia-gis.it/gaia-sins/spatialite-cookbook/html/java.html I guess that there will be stable packages soon but today the download links are http://www.gaia-gis.it/gaia-sins/spatialite-4.2.0-test-win-x86.7z http://www.gaia-gis.it/gaia-sins/spatialite-4.2.0-test-win-amd64.7z The speed is really good. On a 64-bit laptop the direct blob reader gets 500000 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.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 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 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.jar > > SQlite 3.7.x will work fine for direct reading of Spatialite blobs but 3.8.x > version is needed for loading the next version of Spatialite as an extension. > http://www.gaia-gis.it/gaia-sins/spatialite-cookbook/html/java.html > > -Jukka Rahkonen- > ________________________________________ > edgar soldin wrote: > >> 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, >> >> 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 drivers >> to the OpenJump package, you can download them here: >> https://bitbucket.org/xerial/sqlite-jdbc/downloads. Alternatively, the >> maven pom dependency entry is: >> >> <dependencies> >> <dependency> >> <groupId>org.xerial</groupId> >> <artifactId>sqlite-jdbc</artifactId> >> <version>3.7.2</version> >> </dependency> >> </dependencies> >> >> >> >> I tested on Linux with both sqlite-jdbc-3.7.2.jar and the more recent >> sqlite-jdbc-3.7.15-M1.jar. >> >> I think we discussed this previously, but theSQLite jars are Apache 2.0 >> licensed, so should be suitable for repackaging with OpenJump. >> >> Thanks........... lreeder >> >> >> On Tue, Dec 24, 2013 at 3:23 AM, <edgar.sol...@web.de >> <mailto:edgar.sol...@web.de>> wrote: >> >> 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 <tel:23.12.2013%2004>:40, Martin Davis wrote: >> > Thanks, Larry. Patch is commited. >> > >> > Martin >> > >> > >> > On Sun, Dec 22, 2013 at 9:22 AM, Larry Reeder <lnree...@gmail.com >> <mailto:lnree...@gmail.com> <mailto:lnree...@gmail.com >> <mailto:lnree...@gmail.com>>> wrote: >> > >> > 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 internal BLOB format. >> > >> > The patch was made against a recent checkout of JTS 1.14 from the >> Sourceforge SVN. Can you apply to the JTS trunk? Let me know if you'd like >> me to submit it in some other way. >> > >> > Thanks........... lreeder >> > >> > >> > >> > >> > On Mon, Dec 2, 2013 at 4:12 PM, Martin Davis <mtncl...@gmail.com >> <mailto:mtncl...@gmail.com> <mailto:mtncl...@gmail.com >> <mailto:mtncl...@gmail.com>>> wrote: >> > >> > That strategy still makes sense to me. >> > >> > M >> > >> > >> > On Mon, Dec 2, 2013 at 2:51 PM, Larry Reeder >> <lnree...@gmail.com <mailto:lnree...@gmail.com> <mailto:lnree...@gmail.com >> <mailto:lnree...@gmail.com>>> wrote: >> > >> > 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 endianess >> when >> > the code is one of the two specified in the standard (0 = >> BigEndian, 1 = >> > LittleEndian). If any other code is read then the >> endianess will be left >> > unchanged. That should handle the SpatialLite BLOB >> format, right? And >> > it avoids any explicit dependency on magic numbers from >> SpatialLite. >> > And it still allows switching endianness mid-WKB, as per >> the standard, >> > should anyone be so perverse as to do that." >> > >> > Let me know if you see any problems there. >> > >> > Thanks........... lreeder >> > >> > >> > On Mon, Dec 2, 2013 at 3:39 PM, Martin Davis >> <mtncl...@gmail.com <mailto:mtncl...@gmail.com> <mailto:mtncl...@gmail.com >> <mailto:mtncl...@gmail.com>>> wrote: >> > >> > I have very little time to look at this by year-end, >> I'm afraid. >> > >> > Did someone have code to commit for fixing this? >> (with sample data for unit tests) ? >> > >> > >> > >> > >> > On Mon, Dec 2, 2013 at 1:30 PM, <edgar.sol...@web.de >> <mailto:edgar.sol...@web.de> <mailto:edgar.sol...@web.de >> <mailto:edgar.sol...@web.de>>> wrote: >> > >> > 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 multigeometries remains [1]. Martin >> almost promised to make a fix into JTS [2] but I do not see such a commit >> in the JTS code [3]. The best I can hope to happen is to get the fix into >> the new BSD/EPL licensed JTS release [4] but perhaps Martin is busy with >> other things and that will not happen. >> > > >> > > Do we have other alternatives for making the DB >> Query plugin to work well with Spatialite on current OJ than flipping in the >> old JTS version when Spatialite support is on a wishlist? Taking an old >> jts-1.12.jar and renaming it into jts-1.13.jar makes the plugin happy but >> probably breaks some cool new stuff and is thus a poor workaround. >> > > >> > > [1] >> http://sourceforge.net/p/jts-topo-suite/bugs/36/ >> > > [2] >> http://sourceforge.net/p/jts-topo-suite/mailman/message/31118630/ >> > > [3] >> http://sourceforge.net/p/jts-topo-suite/code/commit_browser >> > > [4] >> http://sourceforge.net/p/jts-topo-suite/mailman/message/31422827/ >> > > >> > >> > i already proposed an alternative, >> > >> http://comments.gmane.org/gmane.comp.java.jts.topo-suite.user/6 >> > >> > but Larry wanted to wait for Martin.. >> > @Larry, Martin: what's your take on this nearing >> the end of this year? >> > >> > ..ede >> > >> > >> > >> > >> > >> > >> >> >> ------------------------------------------------------------------------------ >> Rapidly troubleshoot problems before they affect your business. Most IT >> organizations don't have a clear picture of how application performance >> affects their revenue. With AppDynamics, you get 100% visibility into >> your >> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of >> AppDynamics Pro! >> >> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk >> _______________________________________________ >> 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 >> >> >> >> >> ------------------------------------------------------------------------------ >> Rapidly troubleshoot problems before they affect your business. Most IT >> organizations don't have a clear picture of how application performance >> affects their revenue. With AppDynamics, you get 100% visibility into your >> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics >> Pro! >> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk >> >> >> >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> > > ------------------------------------------------------------------------------ > Rapidly troubleshoot problems before they affect your business. Most IT > organizations don't have a clear picture of how application performance > affects their revenue. With AppDynamics, you get 100% visibility into your > Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ > Rapidly troubleshoot problems before they affect your business. Most IT > organizations don't have a clear picture of how application performance > affects their revenue. With AppDynamics, you get 100% visibility into your > Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
