Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

ok, #3 it is then.. (re)projection is a hot topic. implemented only in part it should be added fully first as layer and project SRID. later on with the possibility t5o reproject. copy'n'paste via keyboard is the , right. the inventor of strg+c/v should get a nobel prize, if you'd ask me.

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

I'd opt for #3, with these items being my personal favorites: * Increased use of layer or project SRID throughout OJ so that measurements are in proper values. * Continuation of the UI enhancements you (Ede) and others made in 1.6. I'm LOVING the standard ctrl-c, ctrl-v, ctrl-z, ctrl-a shortcu

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

Hi, > On 09.04.2013 16:01, Rahkonen Jukka wrote: >> edgar soldin wrote: >>> On 09.04.2013 15:33, Rahkonen Jukka wrote: >> Finally, the main purpose of the DBQuery plugin is to provide a >> bridge between OJ and spatial databases that it might not support (if any now), as w

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

On 09.04.2013 16:01, Rahkonen Jukka wrote: > edgar soldin wrote: >> >> On 09.04.2013 15:33, Rahkonen Jukka wrote: > Finally, the main purpose of the DBQuery plugin is to provide a > bridge >>> between OJ and spatial databases that it might not support (if >>> any now), as well as pr

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

edgar soldin wrote: > > On 09.04.2013 15:33, Rahkonen Jukka wrote: > >>> Finally, the main purpose of the DBQuery plugin is to provide a > >>> bridge > >>> >> between OJ and spatial databases that it might not support (if > >>> >> any now), as well as provide a way to submit ad-hoc queries that >

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

On 09.04.2013 15:33, Rahkonen Jukka wrote: >>> Finally, the main purpose of the DBQuery plugin is to provide a bridge >>> >> between OJ and spatial databases that it might not support (if any now), >>> >> as >>> >> well as provide a way to submit ad-hoc queries that don't have or need >>> >> backi

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

edgar soldin wrote: > On 09.04.2013 05:32, Larry Reeder wrote: > > One clarification: my plugin doesn't directly load native libraries. It > > uses >> the sqlite JDBC libraries, which handle the loading spatialite and other >> sqllite >> extensions. > > what about the mysql, oracle, p

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

On 09.04.2013 05:32, Larry Reeder wrote: > > > > On Mon, Apr 8, 2013 at 1:03 PM, > wrote: > > On 08.04.2013 20:48, Michaël Michaud wrote: > > Just wanted to share this thought, but I admit that Spatialite is > > a mature project which can add nice capabi

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

Larry Reeder wrote: > On Mon, Apr 8, 2013 at 1:03 PM, wrote: > On 08.04.2013 20:48, Michaël Michaud wrote: >> > Just wanted to share this thought, but I admit that Spatialite is > > a mature project which can add nice capabilities with a smaller >> > effort. >> ok, as far as i understand for no

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

figuration relational database http://sqlite.org/zeroconf.html > > -Jukka. > ____________ > Lähettäjä: edgar.sol...@web.de [edgar.sol...@web.de] > Lähetetty: 8. huhtikuuta 2013 17:59 > Vastaanottaja: OpenJump develop and use > Aihe: Re: [JPP-Devel] En

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

On Mon, Apr 8, 2013 at 1:03 PM, wrote: > On 08.04.2013 20:48, Michaël Michaud wrote: > > Just wanted to share this thought, but I admit that Spatialite is > > a mature project which can add nice capabilities with a smaller > > effort. > > ok, as far as i understand for now. DBQuery is working and

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

On 08.04.2013 20:48, Michaël Michaud wrote: > Just wanted to share this thought, but I admit that Spatialite is > a mature project which can add nice capabilities with a smaller > effort. ok, as far as i understand for now. DBQuery is working and in use. it uses native libs, but on the other hand

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

2013 17:59 Vastaanottaja: OpenJump develop and use Aihe: Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions. well, done.. thanks. will definitely put that into my queue! one question still: do i understand correctly that spatiallite extensions will pretty much work with any d

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

; interesting things to do with plain SQL by considering Spatialite just as a > zero-configuration relational database http://sqlite.org/zeroconf.html > > -Jukka. > > Lähettäjä: edgar.sol...@web.de [edgar.sol...@web.de] > Lähetetty: 8. h

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

: 8. huhtikuuta 2013 17:59 Vastaanottaja: OpenJump develop and use Aihe: Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions. well, done.. thanks. will definitely put that into my queue! one question still: do i understand correctly that spatiallite extensions will pretty much work wi

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

well, done.. thanks. will definitely put that into my queue! one question still: do i understand correctly that spatiallite extensions will pretty much work with any database connection? e.g. postgis, mysql as well? ..ede On 08.04.2013 16:38, Rahkonen Jukka wrote: > Hi, > > Well, I made a test

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

Hi, Well, I made a test database from Hamburg and wrote a short manual about installing and testing http://latuviitta.org/documents/OpenJUMP_Spatialite_test_manual.pdf -Jukka- Jukka Rahkonen wrote: > edgar Soldin wrote: > > > ok, this sounds too difficult for a last minute inclusion. but w

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

edgar Soldin wrote: > ok, this sounds too difficult for a last minute inclusion. but we can start on > integrating over the course of the next months. > can you give me a data test set and/or step by step instructions how it is > supposed to work? spatiallite input and spatiallite functions, whic

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

On 08.04.2013 07:07, Rahkonen Jukka wrote: > > edgar soldin wrote: > > On 07.04.2013 22:34, Rahkonen Jukka wrote: >> SNIP >>> >>> I did my test with this package I gathered a few weeks ago >>> http://latuviitta.org/documents/Spatialite_4.0_test_with_jre_1.6.zip >>> This version is very feature r

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

edgar soldin wrote: On 07.04.2013 22:34, Rahkonen Jukka wrote: > SNIP >> >> I did my test with this package I gathered a few weeks ago >> http://latuviitta.org/documents/Spatialite_4.0_test_with_jre_1.6.zip >> This version is very feature rich and it has lots of dependies and therefore >> the z

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

Hi > This plugin in so good that maybe we should really add it into OpenJUMP 1.6 > Plus. But perhaps we are too late for that. I think this is possible, information needed are - how / where to install dll exactly - which jdbc drivers have to be included : * MySQL : I think it is OK to include

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

On 07.04.2013 22:34, Rahkonen Jukka wrote: SNIP > > I did my test with this package I gathered a few weeks ago > http://latuviitta.org/documents/Spatialite_4.0_test_with_jre_1.6.zip > This version is very feature rich and it has lots of dependies and therefore > the zip contains 10 dll files. >

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

Hi, I made a test with Spatialite-4 dll files and everything seems to work. Thank you very much for the great job. Two usage example for those who are not familiar with Spatialite yet: 1) Read data as reprojected into any coordinate system supported by Spatialite, which means support for 4223 d

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

It's not that automated :-). You have to follow the instructions for installing Spatialite (including SQLite) here http://www.gaia-gis.it/spatialite-2.3.1/binaries.html, and then define the path to the Spatialite DLL (or just give the DLL name if it's in your library search path) in the JDBC URL.

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

sweet. how do you manage the native libs? are they installed automatically to somewhere appropriate by some installer and found by the jre? ..ede On 07.04.2013 19:22, Larry Reeder wrote: > I added the ability to load spatialite DLLs, and thus use Spatialite > functions, to the Jump DB Query plu

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

I added the ability to load spatialite DLLs, and thus use Spatialite functions, to the Jump DB Query plugin . Instead of calling SELECT load_extension('path_to\ spatialite-4.dll'), you need to append "?spatialite=/path/to/spatialite.dll" to the JDBC URL path in the dbquery properties file.Its

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

Hi, Whatever you do, as a user I would absolutely like to keep also the current mode which is perhaps limited but robust. The libspatialite-4.dll seems to be dependent on 9 other dlls and from my experience it feels sure that some day there will be some odd dll version missmatch in the system.

Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions.

Great research, Jukka. Looks like you are almost ready to submit a patch :-) . Reading the link you sent, the SQLiteConfig must be used at the time the connection is first set up, so it will require a bit more setup in the plugin, but it doesn't look too bad. My time to work on OJ is limited,