[Kexi] Re: Kexi selected for Google Summer of Code!

[Noli Sicad]

Hi Jaroslaw,

Reading this note[1], it seems that you want to use OSM for Kexi
marble widget you can use OSM sqlite3 database file and MBTiles

[1] http://community.kde.org/Kexi/Junior_Jobs/Map_Browser_Form_Widget/Log-2011-04-08

Sqlite3 database for offline:

a) OSM sqlite3 - OSM Tiles (i,e, map2sqlite)
http://www.gisnotes.com/wordpress/2010/08/iphone-dev-note-21-route-me-offline-mapping-from-database/

b) MapBoxTiles (MBTiles)
https://github.com/mapbox/mbtiles-spec

See sample project of MBTiles in https://github.com/mapbox/route-me

Importer and Exporter of MBTiles
https://github.com/mapbox/mbutil

You can easily make Mapbox Maps  using TileMill
http://mapbox.com/#/

BTW, Spatialite has support for projection and GEOS. Supporting
spatialite / sqlite3 database in Kexi will make things easier to
implement more sensible marble widget in Kexi.

Here's the changelog of spatialite RC-4.
http://www.gaia-gis.it/spatialite-2.4.0-4/changelog.html
RC-4 [2010-11-14]

    * libspatialite
          o completely refactored CSV/TXT reader
          o now supporting KML and GML geometry output [AsKML(), AsGml()]
          o introduced a new SQL function supporting easy WGS84 POINTs
filtering: PtDistWithin()
          o fixed several memory leaks (mainly related with the new
WKT parser introduced in RC-3)
          o fixed some bugs
          o major updates to the build scripts
          o update: SQLite v.3.7.3 [introducing Geometry Callbacks
support: RTreeIntersects(), RTreeWithin(), RTreeContains(),
RTreeDistWithin()]

http://www.gaia-gis.it/spatialite-2.4.0-4/index.html

Thanks.

Regards, Noli

On 5/2/11, Jaroslaw Staniek <staniek at kde.org> wrote:
> On 2 May 2011 06:59, Noli Sicad <nsicad at gmail.com> wrote:
>> Hi Jaroslaw,
>>
>> Congratulations!
>>
>> I hope Kexi Marble widget [1] can read render spatialite database
>> query (i.e Vector Polylines) thru KML.
>
> Noli,
> Good suggestions. Added to notes. Looking forward to cooperate/hear
> opinions from you during this development, so we won't miss core
> features.
>
> --
> regards / pozdrawiam, Jaroslaw Staniek
>  http://www.linkedin.com/in/jstaniek
>  Kexi & Calligra (kexi-project.org, identi.ca/kexi, calligra-suite.org)
>  KDE Software Development Platform on MS Windows (windows.kde.org)
>