<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17023" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText92919>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, Luca</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>If you have issues with JNI when using Sqlite/Spatialite, you can start with this pure-Java version of the Sqlite library:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A href="http://www.zentus.com/sqlitejdbc/">http://www.zentus.com/sqlitejdbc/</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>You can download a very simple example here:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A href="http://www.prodevelop.es/files/fm/public/downloads/sqlitetest.zip">http://www.prodevelop.es/files/fm/public/downloads/sqlitetest.zip</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>It creates a hard-coded Sqlite DB with one table where one of the columns is a WKT geometry, then uses JTS to handle it. The program takes two parameters (longitude and latitude) and tells you if the coordinates are inside Liguria or not:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3><A href="http://www.prodevelop.es/files/fm/public/downloads/sqlite_screen.png">http://www.prodevelop.es/files/fm/public/downloads/sqlite_screen.png</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Once you have a simple provider (for example, read-only) in gvSIG that uses that pure-Java library, you can improve and enhance it: add writing capabilities, replace the Sqlite library with a Spatialite JNI library (this would allow you to include geometric queries (intersects, etc) inside the SQL), etc.</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Regards,</FONT></DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV></DIV>
<DIV id=idSignature54154>
<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 luca bianconi<BR><B>Enviado el:</B> lun 17/05/2010 10:11<BR><B>Para:</B> Users and Developers mailing list<BR><B>Asunto:</B> Re: [Gvsig_english] New Student for GVSIG within Google SummerOfCode2010: quick introduction<BR></FONT><BR></DIV>
<DIV>Hi Ben, <BR><BR>I like your idea frankly.<BR>Starting with a simpler but working solution and only after looking for something more complex.<BR><BR>I agree the idea of avoiding "JNI pains".<BR><BR>Ciao and thanks a lot,<BR>Luca<BR><BR><BR>
<DIV class=gmail_quote>2010/5/17 Benjamin Ducke <SPAN><<A href="mailto:benjamin.ducke@oxfordarch.co.uk">benjamin.ducke@oxfordarch.co.uk</A>></SPAN><BR>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV class=im>><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></DIV>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>
<DIV>
<DIV></DIV>
<DIV class=h5><BR>> [1]<A href="http://www.iosa.it/blogs/luca">http://www.iosa.it/blogs/luca</A><BR>> 2010/5/14 Benjamin Ducke <<A href="mailto:benjamin.ducke@oxfordarch.co.uk">benjamin.ducke@oxfordarch.co.uk</A>><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" <<A href="mailto:jldominguez@prodevelop.es">jldominguez@prodevelop.es</A>><BR>> To: "Users and Developers mailing list"<BR>> <<A href="mailto:gvsig_internacional@listserv.gva.es">gvsig_internacional@listserv.gva.es</A>>, "Gvsig internacional"<BR>> <<A href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</A>><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: <A href="mailto:gvsig_internacional-bounces@listserv.gva.es">gvsig_internacional-bounces@listserv.gva.es</A> en nombre de luca<BR>> bianconi<BR>> Enviado el: jue 06/05/2010 15:17<BR>> Para: <A href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</A><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>> <A href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</A><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>> <A href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</A><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>> <A href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</A><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><A href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</A><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></DIV></DIV></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>