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 > >>> >> don't have or need backing tables to return features. While I'm > >>> >> glad my recent changes make it more useful for spatialite users, > adding all the native libs to support spatialite > >>> >> would weigh it very heavily toward the spatialite side. If the main > goal is to > >>> >> improve spatialite, perhaps a better approach is to build up the > >>> >> current sqlite/spatialite plugin to do so? > >>> >> > >>> >> i am no user, so i'd ask jukka. what do you think is the better > >>> >> starting point here? > > Myself I will for sure use Spatialite extension with Larry's plugin but I > consider that the plugin is pretty good as it is and I would not like to > pollute it > much with extra decorations. > > Jukka: did you ever use the mentioned sqlite/spatialite plugin? is there such > a thing?
I suppose it is this one; I have been reading about it ;) http://sourceforge.net/apps/mediawiki/jump-pilot/index.php?title=OpenJUMP_with_SpatialLite#Using_SpatiaLite_with_Spatialite_Reader_Plugin Michaël has touched the plugin code a bit lately and it is almost working again. It has some nice features like the possibility to test the query in a table view and function list and syntax help. On my computer it is suffering from the same "Unknown WKB type 0" problem with multigeometries. The plugin looks nice but is not as robust as DB Query plugin and it does not handle empty geometries and sometimes it is very slow. It is a good model for another approach. -Jukka- ------------------------------------------------------------------------------ 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
