<HTML><HEAD><TITLE>Re: [Gvsig_english] New Student for GVSIG within Google Summer OfCode2010: quick introduction</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17023" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText35295>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, Ben & Luca:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>I was talking about the pure-Java SQLite driver as a platform-independent solution for mobile devices, not for the desktop plugin. I only wanted to point out that SQLite/Spatialite are not so easy to handle from a mobile Java application, so it would be nice if Luca's gvSIG plugin was able to accept also simple SQLite databases and open them as vector layers in gvSIG. The format described in the OGR website is very interesting, thanks.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>As for Luca's project, I think JNI (on top of OGR or SQLite/Spatialite) is unavoidable, no? OpenJUMP's plugin might be a reference, as somebody said. They are using a JAR that includes a native library (.dll, .so) in it:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A href="https://sourceforge.net/apps/mediawiki/jump-pilot/index.php?title=OpenJUMP_with_SpatialLite">https://sourceforge.net/apps/mediawiki/jump-pilot/index.php?title=OpenJUMP_with_SpatialLite</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Nacho's work sounds very interesting too.</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV>Regards,</DIV>
<DIV> </DIV></DIV>
<DIV id=idSignature90156>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de Benjamin Ducke<BR><B>Enviado el:</B> lun 17/05/2010 9:28<BR><B>Para:</B> Users and Developers mailing list<BR><B>Asunto:</B> Re: [Gvsig_english] New Student for GVSIG within Google Summer OfCode2010: quick introduction<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>><BR>> Ben,<BR>><BR>> you know for sure much better than me what would mean having problems<BR>> with wrapping of C API so if we will have too much pain with<BR>> SpatiaLite it could be perfect use the plain WKT/WKB. I've given a<BR>> glance to the link you've suggested but I should read it better for<BR>> understanding what it means on the development point of view.<BR>><BR>> Ciao,<BR>> Luca<BR>><BR><BR>I think for a first stage implementation, the simple WKB/WKT<BR>storage model is probably best. Others can always be added later<BR>using the new GDAL 1.7 java bindings. That way, you shouldn't<BR>have to worry about maintaining your own JNI stuff (which can<BR>be a real pain).<BR><BR>Give users the choice to use WKB (more compact) or WKT (more<BR>easy to parse) when storing geometries. When reading, the<BR>format should be auto-detected.<BR><BR>Let me know if you have any problems understanding anything.<BR>I can send you a little sample SQLite3 database with some WKB/WKT<BR>tables for illustration. I produced them in GRASS GIS using the<BR>GDAL/OGR drivers.<BR><BR>But maybe start by adding plain SQLite3 non-spatial tables as<BR>a new project document type first. And then work towards spatial<BR>tables from there -- to keep things a little more simple for you<BR>at the start!<BR><BR>Best,<BR><BR>Ben<BR><BR>> [1]<A href="http://www.iosa.it/blogs/luca">http://www.iosa.it/blogs/luca</A><BR>> 2010/5/14 Benjamin Ducke <benjamin.ducke@oxfordarch.co.uk><BR>> Hi Juan, Luca<BR>><BR>> That question is not so rhetorical, actually!<BR>> There are several ways of storing spatial data in an SQLite3<BR>> database, that are all in use by some software:<BR>><BR>> <A href="http://www.gdal.org/ogr/drv_sqlite.html">http://www.gdal.org/ogr/drv_sqlite.html</A><BR>><BR>> One of them is a simple WKT/WKB storage model that is also nicely<BR>> documented (see link above).<BR>><BR>> So if SpatiaLite is too much pain, because of the need to wrap the<BR>> C API, then we can just use the plain WKT/WKB storage for our<BR>> purposes.<BR>> It's supported by GDAL/OGR, so we lose only the special SpatiaLite<BR>> functionality.<BR>><BR>> Cheers,<BR>><BR>> Ben<BR>><BR>> ----- Original Message -----<BR>> From: "Juan Lucas Dominguez Rubio" <jldominguez@prodevelop.es><BR>> To: "Users and Developers mailing list"<BR>> <gvsig_internacional@listserv.gva.es>, "Gvsig internacional"<BR>> <Gvsig_internacional@listserv.gva.es><BR>> Sent: Friday, May 14, 2010 2:38:44 PM GMT +01:00 Amsterdam / Berlin /<BR>> Bern / Rome / Stockholm / Vienna<BR>> Subject: Re: [Gvsig_english] New Student for GVSIG within Google<BR>> Summer Of Code2010: quick introduction<BR>><BR>><BR>><BR>><BR>> Ciao, Luca.<BR>><BR>> I too think Spatialite is a very interesting way to store and share<BR>> GIS data, especially because its simplicity fits mobile devices very<BR>> well.<BR>><BR>> I know a pure-Java version of SQLite (not Spatialite) which will<BR>> probably work on a wide range of Java-enabled mobile devices (Android<BR>> supports SQlite too).<BR>><BR>> I was wondering: what is the simplest Sqlite database that can be read<BR>> and processed from Spatialite? Let's suppose I have a Sqlite database<BR>> file with only one table and one of the columns of that table is of<BR>> binary type (BLOB or similar), and that column contains some WKB<BR>> describing a geometry. Would this be enough to open it from a<BR>> Spatialite-enabled application (for example gvSIG in the future)? This<BR>> is rather a rhetorical question... I need to look into it myself :)<BR>><BR>> Can we see your progresses online? blog? SVN?<BR>><BR>> Regards,<BR>><BR>><BR>> Juan Lucas Domínguez Rubio<BR>> ---<BR>> Prodevelop SL, Valencia (España)<BR>><BR>> Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR>> <A href="http://www.prodevelop.es/">http://www.prodevelop.es</A><BR>> ---<BR>><BR>><BR>> De: gvsig_internacional-bounces@listserv.gva.es en nombre de luca<BR>> bianconi<BR>> Enviado el: jue 06/05/2010 15:17<BR>> Para: Gvsig_internacional@listserv.gva.es<BR>> Asunto: [Gvsig_english] New Student for GVSIG within Google Summer Of<BR>> Code2010: quick introduction<BR>><BR>><BR>> Hello gvsig-international mailing list,<BR>><BR>> sorry for sending this email as a kind of spamming, I'd like just to<BR>> introduce myself quickly to the whole list.<BR>><BR>> My name is Luca Bianconi and I'm the "student" working with the gvSig<BR>> team for the Google Summer of Code 2010.<BR>> Our task is implementing the gvSig support for SQlite and SpatiaLite<BR>> and I'll do my best for doing it.<BR>><BR>> I'd like to say my "Hello" to everybody and I thank you all for the<BR>> help you will be able to provide when we will be up to the<BR>> implementation phase both in comments and suggestions!<BR>><BR>> Nice to meet you all,<BR>> Cheers,<BR>> Luca<BR>> _______________________________________________<BR>> Gvsig_internacional mailing list<BR>> Gvsig_internacional@listserv.gva.es<BR>> <A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR>><BR>> ------<BR>> Files attached to this email may be in ISO 26300 format (OASIS Open<BR>> Document Format). If you have difficulty opening them, please visit<BR>> <A href="http://iso26300.info/">http://iso26300.info</A> for more information.<BR>><BR>> _______________________________________________<BR>> Gvsig_internacional mailing list<BR>> Gvsig_internacional@listserv.gva.es<BR>> <A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR>><BR>> _______________________________________________<BR>> Gvsig_internacional mailing list<BR>> Gvsig_internacional@listserv.gva.es<BR>> <A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR><BR><BR>------<BR>Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit <A href="http://iso26300.info/">http://iso26300.info</A> for more information.<BR><BR>_______________________________________________<BR>Gvsig_internacional mailing list<BR>Gvsig_internacional@listserv.gva.es<BR><A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR></FONT></P></DIV></BODY></HTML>