[Kexi] [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?

[Noli Sicad]

I like to put these things into perspective. This is the hierarchy:

- GIS
- Spatial
- Map

I think Spatial in Kexi can be easily done using Spatialite. It is

- Sqlite3 + the geom (geometry column added in Sqlite3 file).

Once Kexi can accept (write and read) raw Sqlite3 files (i.e. .db and
.sqlite), it just adding the geometry column (e.g. geom or geometry)
in the table.

GEOS, Proj4 are dependent libraries for Spatialite.

Jaroslaw, I think can we probably propose a GSOC for SQLite3 for Kexi.
It seems that since 2007 Kexi users need read and write access for
SQLite3 in Kexi.

Any comments?

Thanks.

Noli









On 11/29/11, Noli Sicad <nsicad at gmail.com> wrote:
> I forgot to mention, projection library is also needed, aside from GEOS.
>
> PROJ.4 - Cartographic Projections Library
> http://trac.osgeo.org/proj/
>
> Noli
>
>
>
> On 11/28/11, Noli Sicad <nsicad at gmail.com> wrote:
>> I think GIS in Kexi probably heavy to do in one go. Why just a
>> Spatialite in Kexi - a support for spatialite in Kexi.
>>
>> https://www.gaia-gis.it/fossil/spatialite_gui/index
>>
>> Although, if we can display spatialite geometries in Kexi Map canvas
>> that would be very good.
>>
>> GEOS is the engine for displaying the spatial geometries.
>> http://strk.keybit.net/projects/geos/
>>
>> Noli
>>
>> On 11/28/11, Noli Sicad <nsicad at gmail.com> wrote:
>>> I think this is very good idea - GIS in Kexi.
>>>
>>> Requirements for Kexi (Top of mind right now :-) ).
>>>
>>> - Map canvas to display vectors - (I think some parts are already done
>>> - Maps in Kexi)
>>> - read and write SQlite3 files
>>> - data source spatialite file (.db or .sqlite).
>>>
>>> Spatialite and GEOS libraries needed are here.
>>> http://www.gaia-gis.it/gaia-sins/
>>> http://strk.keybit.net/blog/2011/09/27/geos-3-3-1-released/
>>>
>>> What can Maps in Kexi do right now? Can it display vector and raster?
>>>
>>> Noli
>>>
>>> On 11/28/11, Jaroslaw Staniek <staniek at kde.org> wrote:
>>>> Kind of constructive idea, how about you and/or other GIS people help
>>>> in specifying detailed requirements and development plan for 'GIS in
>>>> Kexi' feature and that can be proposed as a Google Summer of Code 2012
>>>> project?
>>>> So the feature can be implemented earlier...
>>>>
>>>> We have received funds from Google for Maps in Kexi project this year
>>>> and it was positive.
>>>>
>>>> --
>>>> 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)
>>>>
>>>
>>
>