[JPP-Devel] Spatialite multigeometry trouble and JTS v. 1.13

2013-04-08 Thread Rahkonen Jukka
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 Spatialite. Further research revealed that with a bit older OpenJUMP versions there are no troubles at all with these geometries. For example OJ r3131

Re: [JPP-Devel] Colourtheming problems / svg export

2013-04-08 Thread Geoffrey Roy
Dear Michael I think all that can be reasonably done is to provide the SVG with as many decimal places as practical so that any viewer-scaling does not lose resolution. Then, for the user, it will be necessary to figure out the appropriate image size to produce a required scale. Geoff.

[JPP-Devel] The new geometry is invalid. Cancelled.

2013-04-08 Thread Uwe Dalluege
Hi, I get the error: The new geometry is invalid. Cancelled. and I am not shure whether this error is correct. 1. Switch Snap to vertices option. 2. Draw a rectangle. 3. Draw a second rectangle with two identical vertices from the first rectangle (with snap). 4. Select the two rectangles and

Re: [JPP-Devel] The new geometry is invalid. Cancelled.

2013-04-08 Thread Rahkonen Jukka
Hi, I followed the steps and after the Combine selected features I had this multipolygon MULTIPOLYGON ((( 80 125, 80 241, 175 241, 175 125, 80 125 )), (( 175 125, 175 241, 263 241,

Re: [JPP-Devel] The new geometry is invalid. Cancelled.

2013-04-08 Thread Uwe Dalluege
Hi, if you put a third geometrie to the two polygons, for instance a linestring, and combine them you will receive a geometrycollection and not a multipolygon. The geometrycollection causes *no* errors but the multipolygon. Uwe Am 08.04.2013 12:05, schrieb Uwe Dalluege: Hi, I get the

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

2013-04-08 Thread edgar . soldin
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 rich and it has

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

2013-04-08 Thread Rahkonen Jukka
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, which

Re: [JPP-Devel] The new geometry is invalid. Cancelled.

2013-04-08 Thread Stefan Steiniger
Hi, so - well the situation is not so nice, as it should be valid. However, the JTS TestBuilder says the Multi-Polgyon is invalid because of Self-intersection at or near point (175.0, 125.0, NaN) Same message appears when you try to add it as a new feature. maybe you can make it valid before

Re: [JPP-Devel] The new geometry is invalid. Cancelled.

2013-04-08 Thread Uwe Dalluege
Hi Stefan, I am afraid I do not understand :-( Do you think this is a bug in OJ? The multipolygon causes an error the geometrycollection not. Is this behaviour OGC-conform (simpel features...)? What do you think? uwe Am 08.04.2013 16:36, schrieb Stefan Steiniger: Hi, so - well the situation

Re: [JPP-Devel] The new geometry is invalid. Cancelled.

2013-04-08 Thread Stefan Steiniger
Hi Uwe, I am not sure I would call it a bug. OJ, should (try to) create data that are OGC conform, but in this case it doesn't. Which means, the case needs special treatment, but this is not implemented. That the multi-polygon causes an error is with the OGS SF specification = correct.

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

2013-04-08 Thread Rahkonen Jukka
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 we

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

2013-04-08 Thread edgar . soldin
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.

2013-04-08 Thread Rahkonen Jukka
Hi, Not really, Spatialite is a spatial extension for SQLite database engine and it does not work with other databases. However, this is not the whole truth and it is indeed possible to use SQLite and Spatialite functions for handling external data that is not stored into the SQLite data file

Re: [JPP-Devel] The new geometry is invalid. Cancelled.

2013-04-08 Thread Michaël Michaud
Hi Uwe, Stefan, OpenJUMP (JTS) is right, this MultiPolygon is not OGC conform Here is the citation : Multipolygon 2. The Boundaries of any 2 Polygons that are elements of a MultiPolygon may not ‘cross’ and may touch at only a finite number of points. (Note that crossing is prevented by

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

2013-04-08 Thread Michaël Michaud
Hi, Just a side note about OpenJUMP + personnal database : I'm sure that SQLite database has great qualities and can add great capabilities to OpenJUMP, but I've always been reluctant to introduce dll into OpenJUMP distribution (difficulty to keep it multiplatform, lack of visibility on C code

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

2013-04-08 Thread Rahkonen Jukka
Hmm, after re-thinking, the GDAL version 1.10 can also be loaded as SQLite extension http://www.gdal.org/ogr/drv_sqlite.html It means that Spatialite can be made to read anything that GDAL/OGR can read, and if OpenJUMP can read Spatialite then it can read all the GDAL/OGR formats at the same

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

2013-04-08 Thread edgar . soldin
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] The new geometry is invalid. Cancelled.

2013-04-08 Thread Martin Davis
As Michael and Stefan point out, Polygons in a MultiPolygon must be edge-disjoint (which another way of stating the formal definition must only touch at a finite number of points. If they touched along an edge, that would cause an infinite number of points to be coincident). Another way of

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

2013-04-08 Thread Larry Reeder
On Mon, Apr 8, 2013 at 1:03 PM, edgar.sol...@web.de 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

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

2013-04-08 Thread Rahkonen Jukka
Hi, I understand the problems with dlls. However, DB Query Plugin in the basic SQLite mode does not need them. All it needs is the JDBC driver (sqlite-jdbc-3.7.15-SNAPSHOT.jar) which does contain native code but it is all packed inside the jar. Perhaps that would suit better for the OJ Plus