Ede, no I don't need postgis-stubs.
Thanks..lreeder
On Mon, Dec 28, 2015 at 9:57 AM, wrote:
> On 28.12.2015 16:07, Larry Reeder wrote:
> > DBQuery uses PGGeometry from the PostGIS package to parse the PostGIS
> > geometries, and so does require postgis jars.
>
> 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:
>
>
Thanks for the info, Nicolas. I couldn't find any docs for the MySQL
binary format at the time I was writing the plugin, a
DBQuery uses PGGeometry from the PostGIS package to parse the PostGIS
geometries, and so does require postgis jars. However, removing postgis
JAR dependencies from OJ makes sense if OJ isn't using it, and I can just
repackage it in the DbQuery plugin. Since PG is so well supported in the
baseli
I'd prefer #2. Because DBQuery is small and self-contained, it's much
easier to maintain if it stays out of the OJ baseline.
-lreeder
On Sun, Dec 27, 2015 at 10:58 AM, wrote:
> On 27.12.2015 18:42, Nicolas Ribot wrote:
> > I used some DB Query methods to convert blobs into geometry objects.
Forgot the link:
https://sourceforge.net/projects/jumpdbqplugin/files/jumpdbqplugin/jumpdbqplugin-1.1.1/
-lreeder
On Thu, Dec 24, 2015 at 8:44 AM, Larry Reeder wrote:
> Ede and other OJ'ers,
>
> An early Merry Christmas to you! I've released a new version of the
&g
t patching the
Xerial SQLite JDBC libraries to do a better job of handling the various
timestamp formats supported by SQLite.
-lreeder
On Wed, Dec 16, 2015 at 9:56 PM, Larry Reeder wrote:
> Yes, that's a good idea, Ede. I'll try out the newer SQLite jars.
>
> -lreeder
>
&
Yes, that's a good idea, Ede. I'll try out the newer SQLite jars.
-lreeder
On Wed, Dec 16, 2015 at 4:28 AM, wrote:
> hey Larry,
>
> when you fix up DBQuery would it make sense to update the libs? i see
> there is at least a new
>
> sqlite-jdbc-3.8.11.2.jar
>
> out there.
>
> ..ede
>
>
---
I think you guys have figured this out, more details if not:
DBQuery requires "spatialite=mod_spatialite" because this tells the SQLite
drivers to load the spatialite extensions. I didn't want to hardcode the
string "mod_spatialite" in case the Spatialite author changed the name of
the shared lib
Thanks for the bug report, Ede. Sounds easy enough to correct. I will
check in a fix sometime this week.
-lreeder
On Sun, Dec 13, 2015 at 10:51 AM, wrote:
> Hey Larry,
>
> DBQuery dies when OJ is started with a locale that you do not have
> translated it into. there is no fallback property
Yeah! Congrats on a successful patch, Jukka!
-lreeder
On Mon, May 4, 2015 at 1:01 PM, wrote:
> go Jukka go :)).. ede
>
> On 04.05.2015 18:36, Rahkonen Jukka (MML) wrote:
> > Hi,
> >
> >
> >
> > I have packed a new version of the SpatiaLite plugin from OpenJUMP SVN
> rev.4415. The files can be
Jukka, can you send me the exception stack you are seeing, or even better,
a small example SpatialLite DB file that contains the data causing the
error, along with an example of the query you are using that causes the
error?The SQLite and/or SpatiaLite JDBC drivers are responsible for
providing
/jumpdbqplugin/jumpdbqplugin-1.1.0
-lreeder
On Sat, Nov 1, 2014 at 9:57 PM, Larry Reeder wrote:
> Thanks for the heads-up on the new SQLite JDBC driver version, Jukka.
> I'll pull it, run some tests, and if all goes well, I'll build another
> release of the DB Query Pl
Thanks for the heads-up on the new SQLite JDBC driver version, Jukka.
I'll pull it, run some tests, and if all goes well, I'll build another
release of the DB Query Plugin.
-lreeder
On Wed, Oct 29, 2014 at 2:32 AM, Rahkonen Jukka (Tike) <
jukka.rahko...@mmmtike.fi> wrote:
> Hi,
>
> There is now
ps it is still not worth changing the
> packaging or installation instructions.
>
>
>
> -Jukka Rahkonen-
>
>
>
>
>
> Larry Reeder wrote:
>
>
>
> Well, no matter how many times you slice it, a pizza is always (mostly)
> planar :-). The problem with map co
Thanks Michaël. I'm using "FF2F01212" for polygons, which seems to work
well, and doesn't break the line or point cases. Calculating the
intersection matrix with relate was slower than just doing intersects, but
I was able to look at my algorithm and add some adjacency caching which
made the who
ose
> http://www.mathpages.com/home/kmath266/kmath266.htm.
>
>
>
>
>
> -Jukka-
>
>
>
>
>
> Larry Reeder wrote:
>
>
>
> Hey Jukka,
>
>
>
> Just got a chance to look at this. The region that is not coloring is
> interesting.
>
>
>
&
Hey Michaël,
I was using "intersect", and I tried "crosses", but that didn't work. I'm
taking a look at relate now, although I'm having a hard time deciphering
DE-9IM.
-lreeder
On Sat, Sep 20, 2014 at 1:38 PM, Michael Michaud <
m.michael.mich...@orange.fr> wrote:
> Hi Larry,
>
> Do you compu
Hey Jukka,
Just got a chance to look at this. The region that is not coloring is
interesting.
It's like a pizza sliced into six pieces, each touching at the point.
You can't color this portion of the map with only five colors without two
adjacent (maybe just adjacent at one point in the en
I'd like to let the plugin live on it's own for now and gather user
feedback. Hopefully it will be stable enough for the inclusion into the
next OJ Plus release.
-lreeder
On Tue, May 27, 2014 at 2:12 AM, wrote:
> On 27.05.2014 05:41, Larry Reeder wrote:
> > As is, I
Devel] OJ Map Coloring Plugin v0.4
> >
> > and dies with heap size error ;).. ede
> >
> > On 26.05.2014 22:47, edgar.sol...@web.de wrote:
> >> just tried it with linestrings (from the frida dataset) and it seems to
> hang in an endless loop
> >>
> >&
on to) setting -Xmx, you should set
-Xss. A setting of -Xss512k allowed me to process a 6000 feature layer in
a 32 bit JVM.
-lreeder
On Wed, May 21, 2014 at 9:59 PM, Larry Reeder wrote:
> Jukka, are you talking about my new mapcolor plugin? If so, I've tested
> with 6000 polygons
Version 0.4 of the OpenJump Map Coloring plugin is ready for download at
https://sourceforge.net/projects/ojmapcoloring/files/.
Updates in this version include:
* Created layer is automatically colored using the generated autoclr
attribute for color theming.
* Internationalization for DE, EN,
Stefan, I went with "Karte einfärben", which Google tells me means
"colorize map" in English, and that's a good description for what this
plugin does.. Let me know if you think of a better term.
Thanks. lreeder
On Tue, May 20, 2014 at 12:33 PM, Stefan Steiniger wrote:
> mh
Jukka, are you talking about my new mapcolor plugin? If so, I've tested
with 6000 polygons on a 64-bit JRE without problems (just slow), but
haven't tested on a 32-bit JRE. I'll give that a try.
-lreeder
On Tue, May 20, 2014 at 4:02 AM, Rahkonen Jukka (Tike) <
jukka.rahko...@mmmtike.fi>
That's right, Jukka. This is not thematic map coloring based on feature
attributes, since OJ already does that very well. This plugin colors the
map so that no two adjacent features have the same color.
-lreeder
On Tue, May 20, 2014 at 12:46 PM, Rahkonen Jukka (Tike) <
jukka.rahko...@mmmtike
Thanks for the translation, Jukka. I haven't built a release of the
plugin with internationalization yet. I hope to do so sometime this
weekend.
-lreeder
On Tue, May 20, 2014 at 1:00 AM, Rahkonen Jukka (Tike) <
jukka.rahko...@mmmtike.fi> wrote:
> Hi Larry,
>
>
>
> I tried to test m
ft that untranslated. i guess german geo-buffs know what it means
> or Stefan?
>
> ..ede
>
> On 17.05.2014 17:34, Larry Reeder wrote:
> > All,
> >
> > Can you give me help translating the strings for my map coloring plugin (
> http://sourceforge.net/projects/ojmapc
Thanks for the translation, Michaël. I was trying to pull JGraphT from a
Maven repo called jgrapht-jdk1.5, and the only version available in Maven
central is 0.7.3. (See
http://mvnrepository.com/artifact/org.jgrapht/jgrapht-jdk1.5). Until 0.9
is available, I'll just include the jgrapht-jdk1.5.ja
All,
Can you give me help translating the strings for my map coloring plugin (
http://sourceforge.net/projects/ojmapcoloring/). I've attached properties
files for German, Spanish, Finnish, French and Italian, and took a shot at
translating some of the strings. Please correct them if they're wro
have the same
> color. It still needs work, but it should be complete enough for some of
> you to find it useful.
>
> It's hosted on Sourcforge at
> https://sourceforge.net/projects/ojmapcoloring/
>
> Documentation here: https://sourceforge.net/p/ojmapcoloring/wiki/Home/
>
d, Apr 16, 2014 at 8:31 PM, Larry Reeder wrote:
> All,
>
> I created an OJ plugin for map coloring, which uses the Five Color
> algorithm to color a map with 5 colors such that no adjacent boundaries
> have the same color.
>
> https://sourceforge.net/projects/ojm
All,
I created an OJ plugin for map coloring, which uses the Five Color
algorithm to color a map with 5 colors such that no adjacent boundaries
have the same color.
https://sourceforge.net/projects/ojmapcoloring/
Documentation here:
--
Can you use Edit-->Selection--Select by Geometry type, select all empty
geometries, and delete them, then save the layer?
-lreeder
On Thu, Mar 13, 2014 at 3:04 PM, Rahkonen Jukka (Tike) <
jukka.rahko...@mmmtike.fi> wrote:
> Hi,
>
> OpenJUMP creates in some circumstances GEOMETRYCOLLECTION EM
Thanks guys. I've got some graph-coloring code - I'll see if I can turn
that into a plugin.
-lreeder
On Sun, Mar 9, 2014 at 5:23 PM, Rahkonen Jukka (Tike) <
jukka.rahko...@mmmtike.fi> wrote:
> Hi,
>
>
>
> There is a topocolour plugin for QGIS but it is not listed for the current
> QGIS ve
I know OJ has utilities for color theming based on feature attribute
values. Does it have a function to color maps so that adjacent features
don't have the same color? I didn't see anything in the main or Sextante
menus.
Thanks... lreeder
--
Thanks Ede! The Linux startup script update works fine on my Ubuntu
machine.
-lreeder
On Sun, Mar 2, 2014 at 11:07 AM, wrote:
> fixed some more bugs, please try 3887 instead.
> currently sf.net seems to be slow on updating the download page, so
> please be patient in case they have something
>>
>>
>> I ask because it is not possible to load libgpkg.dll
>> https://bitbucket.org/luciad/libgpkg/overview and recent spatialite.dll
>> as extensions (?spatialite=...) with the included driver version. I can write
>> into the blog how users can update the jdbc d
n. I can write
> into the blog how users can update the jdbc driver but it would be better
> if it was not necessary.
>
>
>
> -Jukka-
>
>
>
> *Lähettäjä:* Larry Reeder [mailto:lnree...@gmail.com]
> *Lähetetty:* 21. helmikuuta 2014 3:59
> *Vastaanottaja:* OpenJu
Nice blog post, Jukka.
-lreeder
On Wed, Feb 19, 2014 at 8:47 AM, Rahkonen Jukka (Tike) <
jukka.rahko...@mmmtike.fi> wrote:
>
> http://openjump.blogspot.fi/2014/02/openjump-plus-reads-ogc-geopackages.html
>
> -Jukka-
>
>
>
> wrt. your patch. i am not really satisfied with the shell coding style,
> but the approach seems sound to me. major issue to me is that 80% of e.g.
> 16Gb leaves 3.2GB unused. as XMX only defines a soft limit i'd tend to make
> all RAM available to java, like i did it for windows.
> probably most
Hey Ede,
I updated oj_linux.sh so that it uses up to 80% of available RAM on Linux
instead of defaulting to 512M.
Tested with 32 and 64 bit JVM (only allows max 3GB on 32 bit JVM).
Tested on Mac OSX - doesn't do anything, but doesn't break the script
either.
Patch is attached. I don't have wri
s data from GPKG fast!
>
> Read 30 points: 1 second
>
> Read 53 linestrings: 5 seconds
>
> Read 55 polygons: 8 seconds
>
>
>
> All geometrytypes seem to work perfectly. Congratulations!
>
>
>
> -Jukka-
>
>
>
> Larry Reeder wrote:
>
e, listing the licenses
> of all files you ship now...
>
> ..ede
>
> On 06.02.2014 05:50, Larry Reeder wrote:
> > All,
> >
> > I've posted new versions of the JUMP Database Query Plugin on
> SourceForge at
> https://sourceforge.net/projects/jumpdbqplugin/file
All,
I've posted new versions of the JUMP Database Query Plugin on SourceForge
at https://sourceforge.net/projects/jumpdbqplugin/files/jumpdbqplugin/.
The main features in this release are basic Geopackage support, as well as
inclusion of some JDBC drivers so that users don't have to download them
it.
> But first I need to get that patch for the JTS WKBReader
>
>-lreeder
>
>
> On Tue, Dec 3, 2013 at 1:56 AM, Rahkonen Jukka <mailto:jukka.rahko...@mmmtike.fi>> wrote:
> Hi,
>
> I started a new thread because Larry Reeder wrote " Now that cold is her
gt;
> 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
> 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
itted 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
> >
>
vis wrote:
> That strategy still makes sense to me.
>
> M
>
>
> On Mon, Dec 2, 2013 at 2:51 PM, Larry Reeder 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 t
Happy holidays to you too, Uwe!
-lreeder
On Fri, Dec 20, 2013 at 5:37 AM, Uwe Dalluege
wrote:
> Hi, folks!
>
> I wish you all a happy Christmas and a happy new year!
> Thank you for your help and your good work!
>
> Regards
>
> Uwe
>
>
>
>
> --
d probably be fun to work on,
and I'll put that on my todo list unless someone else wants to take it.
But first I need to get that patch for the JTS WKBReader
-lreeder
On Tue, Dec 3, 2013 at 1:56 AM, Rahkonen Jukka wrote:
> Hi,
>
> I started a new thread because Larry Reede
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
ailto:edgar.sol...@web.de>
> > Reply-To: OpenJump develop and use <
> jump-pilot-devel@lists.sourceforge.net jump-pilot-devel@lists.sourceforge.net>>
> > To: OpenJump develop and use
> > jump-pilot-devel@lists.sourceforge.net>>, mtncl...@telus.net
I wonder that if Martin Davis will not make a fix into JTS, would it make
> DBQuery plugin too complex if if could optionally requests geometries from
> Spatialite with "select asbinary" or "aswkt" if Spatialite extension is
> loaded.
>
Hey Jukka,
Like Ede said, Martin did agree to make the fix.
OK, I think I've got all the DBQuery plugin changes needed to integrate it
into OJ PLUS. Let me know if I missed something.
On Mon, Apr 15, 2013 at 4:02 AM, wrote:
>
> 1. implement I18N support for language support?
>
Done.
> 2. send the language properties file to the developer list for tr
Thanks Ede, and thanks also for the info on hot keys.
-lreeder
On Thu, May 16, 2013 at 11:51 AM, wrote:
> On 11.05.2013 17:33, Larry Reeder wrote:
> > All, I need help translating the strings in the Jump DB Query Plugin.
> I've got English covered :-), but if you spe
not have ;)
>
> do want me to finish the translation disregardless ?
>
> ..ede
>
>
> but you should use java to tell you which string (Alt vs. Cmd) to show, as
> windows users might get confused over the key not existing on their
> keyboard.
>
> On 14.05.2013 05:20
fresh.layer=Refresh the layer created by the current
>>> query (cmd+r in query editor)
>>>
>>> ..ede
>>>
>>> On 11.05.2013 17:33, Larry Reeder wrote:
>>> > All, I need help translating the strings in the Jump DB Query Plugin.
>>> I
ed by the current
>>> query (cmd+r in query editor)
>>>
>>> ..ede
>>>
>>> On 11.05.2013 17:33, Larry Reeder wrote:
>>> > All, I need help translating the strings in the Jump DB Query Plugin.
>>> I've got English c
Great! Thanks Jukka.
-Larry
On Sat, May 11, 2013 at 12:55 PM, Rahkonen Jukka
wrote:
> Hi,
>
> Finnish translation attached. It may need some fine tuning once I will see
> it in the real UI.
>
> -Jukka Rahkonen-
>
> ________
> Larry Reeder wro
nce I will see
> it in the real UI.
>
> -Jukka Rahkonen-
>
>
> Larry Reeder wrote:
>
> > All, I need help translating the strings in the Jump DB Query Plugin.
> I've got English covered :-), but if you speak something else, please
&g
All, I need help translating the strings in the Jump DB Query Plugin.
I've got English covered :-), but if you speak something else, please
provide a translation for the strings in the attached file. Note that one
of the values is parameterized:
dbquery.query.info=Query returned {0,number,integer
Martin, I agree that the JTS WKBReader shouldn't be hacked to support the
SpatialLite BLOB format or whatever else come along with a slightly
different interpretation of the standard, and this is a great compromise
solution. Is this change something we can expect in JTS 1.14?
Thanks
> @Larry:
> could you please change
> JumpSpatialiteDbQuery.java
> so that in line 455 the new error is based on the old one
> 'SQLException(Throwable cause)', so the error stack to the root issue stays
> intact?
>
Good suggestion, Ede. Done and also part of the 0.8.2 re-release.
-lreeder
Jukka,
This is probably a problem because I built 0.8.2 with JDK 1.7 and you're
using JRE 1.6 or older. I've lost track of supported JRE versions for
OpenJump. Is it 1.6 now? Anyway, I've rebuilt to be backward compatible
with JRE 1.6, and redeployed 0.8.2 to sourceforge. Give it another tr
it'd be nice if you could use the OpenWizard framework. not
> sure it that makes sense though.
>
> ..ede
>
>
> On 14.04.2013 15:59, Larry Reeder wrote:
> > Right, completely switched. I updated the license and readme to
> indicate the plugin is now licensed as GPLv
Great analysis, Michaël. Looks like the spatialite component of plugin
will need to do it's own WKB decoding instead of relying on the JTS
WkbReader, at least in part.
-lreeder
On Mon, Apr 15, 2013 at 12:44 AM, Michaël Michaud
wrote:
> Hi,
>
> Just compared both strings to the spec,
>
> Fir
On Sun, Apr 14, 2013 at 3:39 PM, Rahkonen Jukka
wrote:
> Hi,
>
> I made two tests:
> 1) With PostGIS 2.1
> select encode(ST_AsBinary(ST_GeomFromText('MULTIPOLYGON(((0 0, 10 20, 30
> 40, 0 0), (1 1, 2 2, 3 3, 1 1)),
> ((100 100, 110 110, 120 120, 100 100)))')), 'hex')
> Query gives the same WKB th
; > On 10.04.2013 04:51, Larry Reeder wrote:
> >> While testing the new 0.8.1 version of DB Query Plugin I noticed that I
> could not read any multigeometries nor geometry collections from
> Spatialite. Further research revealed that with a bit older OpenJUMP
> versions there are no
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
06:00, Larry Reeder wrote:
> > On Thu, Apr 11, 2013 at 4:33 AM, edgar.sol...@web.de>> wrote:
> >
> > just checked the latest DBQuery plugin and found the following
> issues:
> >
> > 1. wrong licensing under LGPL3 (see other mail)
> >
>
On Thu, Apr 11, 2013 at 5:04 AM, wrote:
> The current "Plugins" main menu item is "Tools" from my point of view. if
> AggregationTool is doing it differently we should think about streamlining
> it.
>
I don't have a strong opinion about where this goes, but I don't see the
problem with putting i
On Thu, Apr 11, 2013 at 4:33 AM, wrote:
> just checked the latest DBQuery plugin and found the following issues:
>
> 1. wrong licensing under LGPL3 (see other mail)
>
Addressed this- the plugin can switch to GPL3
> 2. menu item should be under "File", and not under a not translated
> "Tools" m
Hey Ede,
Too late for the 1.6 release, but, sure, I am fine to relicense as GPL3.
I'll create a new version of the plugin this weekend with a new license.
-lreeder
On Thu, Apr 11, 2013 at 4:01 AM, wrote:
> Larry,
>
> i see you licensed your extension under LGPL3. unfortunately it is base
Thanks for the sample DB, Jukka. I will try to take a look this weekend.
-lreeder
On Mon, Apr 8, 2013 at 2:01 AM, Rahkonen Jukka wrote:
> Hi,
>
> While testing the new 0.8.1 version of DB Query Plugin I noticed that I
> could not read any multigeometries nor geometry collections from
> Spatia
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
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 plugin . Instead of calling SELECT
> load_extension('path_to\
> > spatialite-
e odd dll version missmatch in the system.
>
> -Jukka-
>
> Larry Reeder wrote:
>
> > Great research, Jukka. Looks like you are almost ready to submit a
> > patch :-) . Reading the link you sent, the SQLiteConfig must be used
&
Michaël, my spatialite test dataset contains a mulitpolygon, and that
loads without problems. Can you share your problematic DB file with
me?
Thanks.. lreeder
On Sun, Mar 17, 2013 at 6:00 AM, Michaël Michaud
wrote:
> Hi Larry Reeder, Jukka,
>
> Just started to test
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,
> OK, thanks for explanation.
> By the way, I use Run Datastore Query nearly every day, and
> the improvement which makes the use of ST_AsBinary optional
> was a great one for OpenJUMP :-)
Thanks Michaël - I'm glad you're finding it helpful.
-lreeder
--
On Wed, Mar 13, 2013 at 3:21 AM, wrote:
> On 13.03.2013 09:25, Rahkonen Jukka wrote:
>> How about adding DB Query plugin to the OJ Plus version? The plugin itself
>> is only 520 kB. Spatialite jdbc file makes additional 3 MB and Oracle jdbc
>> file 1.5 MB. With 5 MB extra load we could offer a
On Tue, Mar 12, 2013 at 1:46 AM, Michaël Michaud
wrote:
> Hi,
>
> In this case, it could be related to the folowing change :
>
> 2011-04-01 lreeder
> * Updated WKBGeometryValueConverter to handle geometry types
> represented
>by WKB hex string so that ST_AsBinary is optional
This ch
You're right, guys. As Jukka says, since spatialite and sqllite
clients do all the work, without the typical database backend, you
need to load the spatialite libraries to get spatialite functions.
The Jump DB Query plugin doesn't load those libraries, and functions
don't work. The plugin just
>
>
>
> I believe that the Zerial JDBC driver
> http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC could be used instead but
> I have not verified it. Anyway, if the Zentus driver has gone forever then
> something should be done. The manual should be updated to point to Xerial
> driver if it works
Hey Jukka,
Thanks for testing the new version of the plugin. Some comments below:
>I have the previous version installed on top of OJ 1.3 and using jre 1.5. I
>could not use that installation by slipping the new plugin in. I did not get
>errors but the Database Query tool just did not appea
ded your lreeder sf.net
> account to the svn. if anybody does not agree to give larry svn acces, please
> speak up now.
>
> @larry & all: could somebody please also verify the nightly build for the
> correctness of that change?
>
> thanks alot... ede
>
>
> On 30.03.2
t's going to be useful. How does it handle two geom fields ?
>
> Etienne
>
> On Wed, Mar 30, 2011 at 12:19 AM, Larry Reeder wrote:
>>
>> I've got a patch that allows direct selection of a PostGis geometry
>> column without needing to use ST_AsBinary() to get past th
I've got a patch that allows direct selection of a PostGis geometry
column without needing to use ST_AsBinary() to get past that "unknown
WKB type 48" error. The patch also supports continued use of
ST_AsBinary. Can someone commit the patch for me or give me write
access to the repository?
Than
I'm in agreement. Sourceforge does have its problems, but I'd rather
see resources devoted to fixing bugs and adding features instead of
migrating the code to a new SCM system. -1 on Trac.
-lreeder
2011/2/4 Michaël Michaud :
> Hi Mohammed,
>
> Currently, there is a very low activity on O
Will do. Thanks!
-lreeder
On Sun, Oct 10, 2010 at 8:11 AM, wrote:
> Done ..
> http://sourceforge.net/projects/jump-pilot/files/p_GPS%2CCTS%20Extensions/cs.conf/download
>
> could you link it on the wiki?
>
> thanks ede
>
> On 10.10.2010 15:58, Larry Reeder wrote:
I just sent it to the list in an email.
Thanks lreeder
On Sun, Oct 10, 2010 at 7:55 AM, wrote:
> I'll put it on sourceforge file space for you. Where can I find your file?
>
> ..ede
>
> On 10.10.2010 15:41, Larry Reeder wrote:
>> I've cre
I've create a cs.conf file for the CTS extension that has about 3000
projection definitions. I put it in a zip file, and I'd like to
upload it to the wiki, but the wiki only allows upload of image files
(jpg, png, svg, etc), not zip files. It looks like the current
sample cs.conf is hosted at
Hey Larry,
If I create a new layer and add points and a polygon, and right-click
the layer name and select "Save Selected Datasets", I get the error
"Use *** Save Dataset As *** to save layer:New". Then of course when
I try "Save Dataset As" to save as a shapefile, I get the "mixed
geometries er
Yes, I think that's right. I'm the author of the Jump DB Query
Plugin, and I built the last release of that plugin with JDK 6. I
wonder if cbertelli can upgrade his or her JRE?
-lreeder
On Fri, Jun 18, 2010 at 2:51 PM, Larry Becker wrote:
> Hi Stefan,
>
> You are probably right.
>
> L
>
> What did you use as a Spatialite JDBC connection? Is this pure Java, or
> JNI?
>
I think there are at least two JDBC drivers for SQLite/Spatialite. I
use the Zentus driver with the Jump DB Query Plugin, but I think Jukka
has had success with the Xerial drivers. The Zentus documentation is
> I could not reproduce the problem with mixed geometry, but found a bug
> (NPE) for null non-numeric attributes.
> I think the NPE you get is due to this bug (null attributes) and not due
> to empty geometry collections.
> I committed the change.
> When you'll have time, please, can you tell me it
s what to do if geometry field is NULL. It is
>>>>> not so uncommon situation with databases, and the aim of many GIS
>>>>> projects is just to add spatial data for existing objects with already
>>>>> known attribute data by locating them on map.
m of many GIS projects
>>> is just to add spatial data for existing objects with already known
>>> attribute data by locating them on map.
>>>
>>> At present if the result of a PostGIS query contains only NULL geometries
>>> OpenJUMP throws a Null Pointer
Hey all,
I wanted to let the group know that the Jump DB Query Plugin now
supports Spatialite databases and SQLite databases that follow the FDO
RFC 16 specification. GDAL/OGR and other open source tools use FDO
RFC 16 to store spatial data in plain SQLite. Thanks to Jukka
Rahkonen for the idea
1 - 100 of 102 matches
Mail list logo
