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 that you used in JTS bug #3610843, that is
"0106000000020000000103000000020000000400000000000000000000000000000000000000000000000000244000000000000034400000000000003e4000000000000044400000000000000000000000000000000004000000000000000000f03f000000000000f03f0000000000000040000000000000004000000000000008400000000000000840000000000000f03f000000000000f03f01030000000100000004000000000000000000594000000000000059400000000000805b400000000000805b400000000000005e400000000000005e4000000000000059400000000000005940"
2) With Spatialite
select
GeomFromWKB(x'0106000000020000006903000000020000000400000000000000000000000000000000000000000000000000244000000000000034400000000000003E4000000000000044400000000000000000000000000000000004000000000000000000F03F000000000000F03F0000000000000040000000000000004000000000000008400000000000000840000000000000F03F000000000000F03F69030000000100000004000000000000000000594000000000000059400000000000805B400000000000805B400000000000005E400000000000005E4000000000000059400000000000005940')
Query creates a multipolygon geometry.
Therefore it looks like the WKB is ok. But I do not understand that if PostGIS
gives exactly the same WKB, how it is possible that OpenJUMP works with PostGIS
but not with Spatialite through DB Query plugin?
-Jukka Rahkonen-
________________________________
Larry Reeder wrote:
> Appears to be a problem with JTS 1.13, unless the WKB is not conformant to
> the spec, and JTS 1.12 was > ignoring any problems. I opened bug # 3610843
> against JTS.
-lreeder
On Wed, Apr 10, 2013 at 2:58 PM, Michaël Michaud
<michael.mich...@free.fr<mailto:michael.mich...@free.fr>> wrote:
Le 10/04/2013 11:12, edgar.sol...@web.de<mailto:edgar.sol...@web.de> a écrit :
> 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 troubles at all with these geometries. For example OJ r3131 from
>> 2012-12-12 works fine for me.
>> The error with recent OJ versions is "Unknown WKB type 0".
>
> Michael: didn't you fix this for the postgis plugin?
Not that I remember. I went through the log file and saw a few changes,
but not in the reading of geometries.
The change to JTS 1.13 happened a few days after r3131, would it be
possible to test with a recent OJ + JTS 1.12 version ?
Or to have a more precise idea about the revision from which it sis broken
Michaël
>
> ..ede
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> 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
>
>
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
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
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
