Hi all,<br><br>I'm solving several problems I have with the compilation of gvsig at the moment on Lucid Lynx and, while I'm doing it, I've thought it could be interesting for other people reading my thoughts about it so I will put them on my blog.<br>
<br>As far as many documents are in Spanish and for this reason accessible just by some people (I have no problems for reading th acutally), I want to take my notes about this experience in English on my blog [1] .<br><br>
Those will be just some notes and thoughts, not a precise documentation anyway.<br><br>Ben,<br><br>you know for sure much better than me what would mean having problems with wrapping of C API so if we will have too much pain with SpatiaLite it could be perfect use the plain WKT/WKB. I've given a glance to the link you've suggested but I should read it better for understanding what it means on the development point of view.<br>
<br>Ciao,<br>Luca<br><br>[1]<a href="http://forge.osor.eu/projects/gvsig-sandbox/" target="_blank">http://www.iosa.it/blogs/luca</a><br><br><div class="gmail_quote">2010/5/14 Benjamin Ducke <span dir="ltr"><<a href="mailto:benjamin.ducke@oxfordarch.co.uk">benjamin.ducke@oxfordarch.co.uk</a>></span><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">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" target="_blank">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 purposes.<br>
It's supported by GDAL/OGR, so we lose only the special SpatiaLite functionality.<br>
<br>
Cheers,<br>
<br>
Ben<br>
<div><div></div><div class="h5"><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" <<a href="mailto:gvsig_internacional@listserv.gva.es">gvsig_internacional@listserv.gva.es</a>>, "Gvsig internacional" <<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 / Bern / Rome / Stockholm / Vienna<br>
Subject: Re: [Gvsig_english] New Student for GVSIG within Google 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 GIS data, especially because its simplicity fits mobile devices very well.<br>
<br>
I know a pure-Java version of SQLite (not Spatialite) which will probably work on a wide range of Java-enabled mobile devices (Android supports SQlite too).<br>
<br>
I was wondering: what is the simplest Sqlite database that can be read and processed from Spatialite? Let's suppose I have a Sqlite database file with only one table and one of the columns of that table is of binary type (BLOB or similar), and that column contains some WKB describing a geometry. Would this be enough to open it from a Spatialite-enabled application (for example gvSIG in the future)? This 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" target="_blank">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 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 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 introduce myself quickly to the whole list.<br>
<br>
My name is Luca Bianconi and I'm the "student" working with the gvSig team for the Google Summer of Code 2010.<br>
Our task is implementing the gvSig support for SQlite and SpatiaLite 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 help you will be able to provide when we will be up to the implementation phase both in comments and suggestions!<br>
<br>
Nice to meet you all,<br>
Cheers,<br>
Luca<br>
<br>
</div></div>_______________________________________________<br>
Gvsig_internacional mailing list<br>
<div class="im"><a href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</a><br>
</div><div class="im"><a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_blank">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
<br>
<br>
</div>------<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" target="_blank">http://iso26300.info</a> for more information.<br>
<br>
_______________________________________________<br>
Gvsig_internacional mailing list<br>
<div class="im"><a href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</a><br>
</div><div><div></div><div class="h5"><a href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional" target="_blank">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</a><br>
</div></div></blockquote></div><br>