Re: [Kexi] [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?
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 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 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) >> > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?
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 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) > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?
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) ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
On 28 November 2011 00:45, Noli Sicad wrote: >> I feel no surprise MS Access is somewhat 'aside' of such developments: >> it allows either for embedding ActiveX elements or binding to custom >> data via degraded ODBC interface. So few points where >> integration/extensibility is possible... > > Here are some thoughts about MS Access and QGIS. > http://gis.stackexchange.com/questions/9462/can-qgis-read-an-odbc-connection > > Things being discussed above also applies to Kexi usability outside Kexi GUI. Hmm, adding linked tables to a project with data source in CSV format. Yes, a TODO for Kexi... :) -- 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) ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
> I feel no surprise MS Access is somewhat 'aside' of such developments: > it allows either for embedding ActiveX elements or binding to custom > data via degraded ODBC interface. So few points where > integration/extensibility is possible... Here are some thoughts about MS Access and QGIS. http://gis.stackexchange.com/questions/9462/can-qgis-read-an-odbc-connection Things being discussed above also applies to Kexi usability outside Kexi GUI. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
On 27 November 2011 12:28, Noli Sicad wrote: > This is QGIS user post regarding Spatialite and MS Access. > > http://groups.google.com/group/spatialite-users/browse_thread/thread/6418b8b04e0c3bf0?pli=1 > > BTW, MS Access don't not work with QGIS. Thanks for the link. Such discussions are always like a source of use cases and then possible requirements. I feel no surprise MS Access is somewhat 'aside' of such developments: it allows either for embedding ActiveX elements or binding to custom data via degraded ODBC interface. So few points where integration/extensibility is possible... -- 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) ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
On 27 November 2011 11:57, Noli Sicad wrote: >>> QGIS can read and write PosgreSQL (i.e. PostGIS) and sqlite (i.e >>> spatialite files) and QGIS has a python bindiings (i.e. PyQGIS) and >>> soon probably a javascript bindings as well in QGIS version 2 (plan). >>> >>> http://linfiniti.com/2011/11/more-on-qgis-desktop-web-fusion/ >> >> This is all very interesting. It would be possible to have proper >> integration if we have any contributor in this area. >> Even starting with small thing would make a difference. The one who is >> interested would decide on the future shape of Kexi :) > > You might be interested to read the first part, (if you have not seen > this already). > > http://linfiniti.com/2011/11/fusing-web-technologies-with-qgis/ > > I believe a lot of QGIS users will be using Kexi if there is read and > write for sqlite3 files. Right now, they are looking for MS Access > alternative that would with QGIS. Here are my thoughts: - we encouraged developers to start blending Kexi with maps [1], that would be a starting point to the GIS world - similarly to what has been mentioned in the context of QGIS, we want to see good scripting features as a foundation 100s of plugins for specialized use cases - in the context of maps drawing custom overlays/layers is exactly such application of script - Qt allows to use javascript programming (build on familiar web developer story) without a need for using WebKit browser even as a component: the canvases (graphics contexts) can be entirely custom - finally, if you wish to see non-trivial features for GIS in Kexi Project, let's spread the word and we can organize the development in 2012 after Kexi 2.4 release; we clearly need you, with budget and time since GIS, while interesting, is one of many areas in Kexi that need investments. Joining forces can make a difference. [1] http://community.kde.org/Kexi/Junior_Jobs/Map_Browser_Form_Widget -- 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) ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
This is QGIS user post regarding Spatialite and MS Access. http://groups.google.com/group/spatialite-users/browse_thread/thread/6418b8b04e0c3bf0?pli=1 BTW, MS Access don't not work with QGIS. Noli On 11/27/11, Noli Sicad wrote: >>> QGIS can read and write PosgreSQL (i.e. PostGIS) and sqlite (i.e >>> spatialite files) and QGIS has a python bindiings (i.e. PyQGIS) and >>> soon probably a javascript bindings as well in QGIS version 2 (plan). >>> >>> http://linfiniti.com/2011/11/more-on-qgis-desktop-web-fusion/ >> >> This is all very interesting. It would be possible to have proper >> integration if we have any contributor in this area. >> Even starting with small thing would make a difference. The one who is >> interested would decide on the future shape of Kexi :) > > You might be interested to read the first part, (if you have not seen > this already). > > http://linfiniti.com/2011/11/fusing-web-technologies-with-qgis/ > > I believe a lot of QGIS users will be using Kexi if there is read and > write for sqlite3 files. Right now, they are looking for MS Access > alternative that would with QGIS. > > Noli > ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
>> QGIS can read and write PosgreSQL (i.e. PostGIS) and sqlite (i.e >> spatialite files) and QGIS has a python bindiings (i.e. PyQGIS) and >> soon probably a javascript bindings as well in QGIS version 2 (plan). >> >> http://linfiniti.com/2011/11/more-on-qgis-desktop-web-fusion/ > > This is all very interesting. It would be possible to have proper > integration if we have any contributor in this area. > Even starting with small thing would make a difference. The one who is > interested would decide on the future shape of Kexi :) You might be interested to read the first part, (if you have not seen this already). http://linfiniti.com/2011/11/fusing-web-technologies-with-qgis/ I believe a lot of QGIS users will be using Kexi if there is read and write for sqlite3 files. Right now, they are looking for MS Access alternative that would with QGIS. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] [ideas] Google Fusion Tables - storage for Kexi?
On 27 November 2011 04:46, Noli Sicad wrote: >> The goal is to make Kexi able to open sqlite3 files directly. >> This is a higher-priority plan for the next version after Kexi 2.4. > > Read and write sqlite3 files directly? > > I hope it is not a year or 2 from now but sooner. > I hope so :) > Any programs / apps that can read and write .kexi files at the moment? For example: http://sqliteman.com The rule is that if you only change data and not adding tables or columns, kexi can see the changes. > Any python, javascript bindings that can read and write .kexi files at > the moment? Yes we have experimental python or javascript bindings visible as Script objects in Kexi. http://www.kexi-project.org/wiki/wikiview/index@scripting.html Ruby could work too. What is depends on distribution you use. We're aiming to switch to solid, stable (as in API) javascript scripting with complete object model. This is going to use QtScript with webkit javascriptcore or with google v8 engine. > > Kexi would be good data input for QGIS, if it can read and write > sqlite (i.e. spatailite files) even just non spatial. > > http://www.qgis.org/ > > QGIS can read and write PosgreSQL (i.e. PostGIS) and sqlite (i.e > spatialite files) and QGIS has a python bindiings (i.e. PyQGIS) and > soon probably a javascript bindings as well in QGIS version 2 (plan). > > http://linfiniti.com/2011/11/more-on-qgis-desktop-web-fusion/ This is all very interesting. It would be possible to have proper integration if we have any contributor in this area. Even starting with small thing would make a difference. The one who is interested would decide on the future shape of Kexi :) -- 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) ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi