Re: [Kexi] [ideas] GIS in Kexi; was: Google Fusion Tables - storage for Kexi?
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 nsi...@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 nsi...@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 nsi...@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 stan...@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) ___ 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?
Hi Jaroslaw, Would Kexi now imports sqlite3 files (e.g. db and sqlite)? Noli On 11/24/11, Jaroslaw Staniek stan...@kde.org wrote: On 24 November 2011 08:59, Noli Sicad nsi...@gmail.com wrote: My alternative for Google Fusion Tables is GeoJSON. http://geojson.org Nice! (Noli, yes I still remember about your needs regarding spatial databases :) I would add there are two things: 1. Services that users can plug into to have free storage (pros: freeloading, cons: lock-in, 'different' approach to security) 2. Free/libre implementations (pros: more control, cons: you're on your own hosting) -- 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] Re: [news] Web Browser widget at its full speed
Jaroslaw, I hope I can use OpenLayers with new web page in Kexi. http://www.openlayers.org/ Then Kexi with Spatialite library (SQLite extension) geometry to render to OpenLayers. http://www.gaia-gis.it/spatialite-2.4.0-4/spatialite-cookbook/index.html Noli On 6/30/11, Jaroslaw Staniek stan...@kde.org wrote: Hello, With new developer on board, Season of KDE brings fruits for Kexi. Web Browser widget at its full speed: http://blogs.kde.org/node/4448 -- 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 mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: Season of Kexi status
Hi Jaroslaw, Where you do keep their weekly reports for SofC, Week 1 and Week 2? I did not see any entries in their blogs. Noli On 6/21/11, Jaroslaw Staniek stan...@kde.org wrote: Hi, For your information, if you find yourself interested in tracking Kexi development closer (or also participate in any way) -- two projects within the Kexi project are going forward, with contributions from new Kexi developers: 1. Summer of Code (maps elements): http://community.kde.org/GSoC/2011/StatusReports#Radek_Wicik 2. Season of KDE (web elements): http://community.kde.org/GSoC/2011/StatusReports#Shreya_Pandit Special group dedicated to such development has been created, can be read by anyone: https://groups.google.com/forum/#!forum/season-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 ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: Kexi selected for Google Summer of Code!
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 stan...@kde.org wrote: On 2 May 2011 06:59, Noli Sicad nsi...@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) ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: Kexi selected for Google Summer of Code!
Hi Jaroslaw, Congratulations! I hope Kexi Marble widget [1] can read render spatialite database query (i.e Vector Polylines) thru KML. [1] http://community.kde.org/Kexi/Junior_Jobs/Map_Browser_Form_Widget#TODOs Spatialite has support for KML (i.e. output SQL query as AsKML). Mable[2] has already support for vector render thru KML and GPX. [2] http://edu.kde.org/marble/ Marble has got support for several 3rd party data sources like OpenStreetMap, Wikipedia, KML, GPX etc. Noli On 4/29/11, Jaroslaw Staniek stan...@kde.org wrote: Hello, It is nice to inform you that Kexi has been selected as a project for Google Summer of Code! Kexi code is also developed under the Season of KDE umbrella. More information at http://www.kdedevelopers.org/node/4419 -- 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 mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Re: [calligra/kexi-maps-wicik] /: FEATURE: Initial version of Map widget in kexi forms
On 4/7/11, Jaroslaw Staniek stan...@kde.org wrote: On 6 April 2011 23:10, Radosław Wicik rados...@wicik.pl wrote: Coming next maps in reports, then connect it to DB for setting and displaying data with/on maps. If that will be ready then I'll try flake shapes. After that I'll go deeper, define new data types: - points - lines - polygons thanks to it it will be possible to add some zones on maps, What do you think about this plan? What do you think about me blogging my way of the Calligra developer? This would be technical, high level view about the source, and thinks that I found hard to understand or interesting, maybe this would be helpful for somebody? Hi Radek, No doubt it will be helpful! Just make sure your blog is syndicated at http://planetkde.org/ before you blog. Regarding the data types, it's hard to add it in current kexi, since kexidb is feature-frozen. Predicate is not but it's in heavy development (refactoring) and I wouldn't like to destabilize it. I am not 100% sure about the use case. If you mean adding lines, points and polygons to the map (by the user), I would recommend using some predefined XML (first define it on a wiki page). In any kexi database there's kexi__objectdata table where you can save extra data string related to any object (here: form and report). Query objects use that to store SQL statements and forms use it to store QtDesigner-like XML for UIs. Spatialite, Sqlite GIS extension can do this. http://www.gaia-gis.it/spatialite/spatialite-tutorial-2.3.1.html Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Koffice Kexi and Calligra Kexi - Was and Now.
Hi, Just for the record to explain what is going on, why Koffice Kexi becomes Calligra Kexi. Read - Behind the KOffice split http://lwn.net/SubscriberLink/419822/7c50edb32265e3ed/ Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Kexi 2.2 PostgreSql driver not deciphering money type
Hi, It seems that the kexi postgresql driver could not deciphering / understand / encode money. In this case this table tblData. CREATE TABLE tblData ( Croptypevarchar (32), Age int, Areafloat, TRV int, SCOST money, PCOST money, P1P2float, SLOGfloat, PULPfloat, CFREV money, LCOST money, TCOST money, SACOST money, RCOST money ); Thanks, Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Geting Kexi2.2 SVN source only for patching purposes
Hi, I would like to patch my ubunutu 10.04 Kexi2.2 to fix for stability issue of SQLite driver and for memo fields in MS Access released for Kexi 2.2 as mentioned in the site. http://www.kexi-project.org/ I am not using any KDE at the moment except Kexi2.2. I don't want to download the whole Koffice 2.2.1 tarball source. Any instruction how to get Kexi2.2.1 source in SVN and patch it. BTW, I just like to verify as well if the SQLite driver fix can actually open sqlite3 database now. Thanks. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Geting Kexi2.2 SVN source only for patching purposes
Hi, It seems that this instruction is just patching, http://kexi-project.org/wiki/wikiview/index@kexi2.2_patches.html#msaccess_large_memo I think a lot of problem getting this done. I don't have even Qt build system. Any compiled binary that we can download just to use the new feature / fixes. Thanks Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Postgresql and Kexi 2.2 import database working?
Hi, I am moving away from Sqlite3 still there is no support at this moment. I am migrating to postgresql / PostGIS and trying to import the data in Kexi2.2 I am trying to import database from postgresql to Kexi 2.2 now. It is connecting to the postgresql database but in the last stage of import the database. It is stuck in Importing Form, the last stage next to Finish. Now, is the Postgresql and Kexi 2,2 import database working? Thanks. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
Re: [Kexi] Postgresql and Kexi 2.2 import database working?
I think there is problem with reading the data, when the record has this entry, Mr. Bill O'Neilly WARNING: nonstandard use of \' in a string literal LINE 1: INSERT INTO customer VALUES (14,'Mr ','Bill','O\''Neill','2... ^ HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...'). Noli ` transactionREAD COMMITTED committed more than once kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor-moveFirst() || cursor-eof() || cursor-storeCurrentRow(data) m_sql= SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='barcode' AND o_type=1 LIMIT 1 NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index barcode_pkey for table barcode kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor-moveFirst() || cursor-eof() SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='barcode' LIMIT 1 kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor-moveFirst() || cursor-eof() || cursor-storeCurrentRow(data) m_sql= SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='customer' AND o_type=1 LIMIT 1 NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index customer_pkey for table customer kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor-moveFirst() || cursor-eof() SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='customer' LIMIT 1 kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor-moveFirst() || cursor-eof() || cursor-storeCurrentRow(data) m_sql= SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='item' AND o_type=1 LIMIT 1 NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index item_pkey for table item kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor-moveFirst() || cursor-eof() SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='item' LIMIT 1 kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor-moveFirst() || cursor-eof() || cursor-storeCurrentRow(data) m_sql= SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='orderinfo' AND o_type=1 LIMIT 1 NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index orderinfo_pkey for table orderinfo kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor-moveFirst() || cursor-eof() SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='orderinfo' LIMIT 1 kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor-moveFirst() || cursor-eof() || cursor-storeCurrentRow(data) m_sql= SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='orderline' AND o_type=1 LIMIT 1 kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor-moveFirst() || cursor-eof() SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='orderline' LIMIT 1 kexi(7247)/KexiDB KexiDB::Connection::querySingleRecordInternal: Connection::querySingleRecord(): !cursor-moveFirst() || cursor-eof() || cursor-storeCurrentRow(data) m_sql= SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects WHERE lower(o_name)='stock' AND o_type=1 LIMIT 1 NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index stock_pkey for table stock kexi(7247)/KexiDB KexiDB::Connection::querySingleString: Connection::querySingleRecord(): !cursor-moveFirst() || cursor-eof() SELECT o_id FROM kexi__objects WHERE o_type=1 AND lower(o_name)='stock' LIMIT 1 transactionREAD COMMITTED committed more than once WARNING: nonstandard use of \' in a string literal LINE 1: INSERT INTO customer VALUES (14,'Mr ','Bill','O\''Neill','2... ^ HINT: Use '' to write quotes in strings, or use the escape string syntax (E'...'). ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Simple Kexi2.2 Example Database with Python Script
Hi, I am trying to use Kexi2.2 as data input and result reporting for my linear programming model. I use glpk/mathprog that uses odbc to reading data as input and writing data for results. My linear programming model uses sqlite/spatialite database / file. I manage to import my mdb database to Kexi and I can open it sqlite and spatialite. Hopefully, I can data - tables / spatial data thru linear programming model - scripting language -mathprog and still be able to read back in Kexi. I am looking for a simple kexi2.2 database example that uses python script. To see how python script works in Kexi. Where can I get the kexi database that is mentioned here? http://www.kdedevelopers.org/node/3933 It seems that there are very few documentation on Kexi2.2. Thanks in advance. Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi
[Kexi] Python Script and Kexi2.2
Hi, I am searching the net for Python and Kexi2.2. It seems no entry. Is python script working in Kexi2.2? Noli ___ Kexi mailing list Kexi@kde.org https://mail.kde.org/mailman/listinfo/kexi