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 <jukka.rahko...@mmmtike.fi>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
> 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".
>
> running query: select * from multipolygons
> Warning: Unable to find FDO-OGR metadata: [SQLITE_ERROR] SQL error or
> missing database (no such col
> umn: geometry_format). I'll take this as an indication that this database
> doesn't conform to FDO RF
> C 16, but is just a regular spatialite (or sqlite) database
> java.sql.SQLException: Unknown WKB type 0
> at
> org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialiteDbQuery.getAttributeValueFrom
> Results(JumpSpatialiteDbQuery.java:455)
> at
> org.freevoice.jumpdbqueryextension.AbstractJumpDbQuery.addFeatureToCollection(AbstractJum
> pDbQuery.java:132)
> at
> org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialiteDbQuery.getCollection(JumpSpa
> tialiteDbQuery.java:404)
> at
> org.freevoice.jumpdbqueryextension.JumpDbQueryPlugin.run(JumpDbQueryPlugin.java:169)
> at java.lang.Thread.run(Unknown Source)
>
> I made a little test Spatialite v.3 database which contains points,
> linestrings, multilinestrings, polygons, multipolygons and geometry
> collections with 10 features on each layer to test with
> http://latuviitta.org/documents/Geometry_type_test.sqlite
>
> If I could I would have a look at changeset 3137: update jts library to
> 1.13
>
> -Jukka Rahkonen
>
>
> ------------------------------------------------------------------------------
> Minimize network downtime and maximize team effectiveness.
> Reduce network management and security costs.Learn how to hire
> the most talented Cisco Certified professionals. Visit the
> Employer Resources Portal
> http://www.cisco.com/web/learning/employer_resources/index.html
> _______________________________________________
> Jump-pilot-devel mailing list
> 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
