Re: [Qgis-developer] Spatialite ’select’ stateme nt as vector layer in QGIS
Hi Ivan. On Sun, Dec 12, 2010 at 11:28 PM, Ivan Mincikivan.min...@gmail.com wrote: For me the best feature is that it is possible to load and visualize every PostGIS query, not only queries based on real tables (this is what I miss in perfect 'RT_' plugins). What did you mean? The RT_Sql_Layer permits to load every PostGIS query, not table based only. So I cannot understand, what do you miss in RT_Sql_Layer? Hi Giuseppe, when I pressed 'send' button in my email client I realized, that I need to provide some example. In general, I was failing to load the result generated by PLPgSQL function which had no relation to any existing layer. I can provide some usefull examples by time. Thanks a lot for Your plugins. -- Ivan Mincik, Gista s.r.o. ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Spatialite ’select’ stateme nt as vector layer in QGIS
Hi all I've added a new version of this plugin (v 0.2). It is now possible to query spatialite and postgis layers. The results are displayed on the map canvas or as a table. I added a small help page to the plugin as well. I started writing some documentation on how to use it, but it is still unfinished. A small gotcha: if you decide to test it with postgis layers, don't forget to include the schema name when you reference a table. Please let me have some feedback, if you have the time to test it out. Thanks On Thu, Dec 9, 2010 at 10:40 AM, Ricardo Filipe Soares Garcia da ricardo.garcia.si...@gmail.com wrote: Sorry, forgot to add this: I will add a small help page explaining the functionality later. Probably tomorrow. Cheers On Thu, Dec 9, 2010 at 10:38 AM, Ricardo Filipe Soares Garcia da ricardo.garcia.si...@gmail.com wrote: Hello I have uploaded my plugin to the contributed repository. I marked it as experimental. It is called 'Custom DB query'. I did a bit of cleaning up and even managed to get the 'normal query' feature to work. So, by now you can: - run an SQL query and choose to view the result in the map canvas or in a table format. This is only working for spatialite layers. Postgis will come later. Beware that I am not parsing the SQL in any way! So please be careful about what SQL queries you write, that can potentially damage your database. If you stick to SELECT statements it is OK. I didn't mean to bring one more spatial db plugin to the table, when there are currently so many ;) I will retire this one in due time. -- ___ ___ __ Ricardo Garcia Silva -- ___ ___ __ Ricardo Garcia Silva -- ___ ___ __ Ricardo Garcia Silva ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Spatialite ’select’ stateme nt as vector layer in QGIS
Sorry, forgot to add this: I will add a small help page explaining the functionality later. Probably tomorrow. Cheers On Thu, Dec 9, 2010 at 10:38 AM, Ricardo Filipe Soares Garcia da ricardo.garcia.si...@gmail.com wrote: Hello I have uploaded my plugin to the contributed repository. I marked it as experimental. It is called 'Custom DB query'. I did a bit of cleaning up and even managed to get the 'normal query' feature to work. So, by now you can: - run an SQL query and choose to view the result in the map canvas or in a table format. This is only working for spatialite layers. Postgis will come later. Beware that I am not parsing the SQL in any way! So please be careful about what SQL queries you write, that can potentially damage your database. If you stick to SELECT statements it is OK. I didn't mean to bring one more spatial db plugin to the table, when there are currently so many ;) I will retire this one in due time. -- ___ ___ __ Ricardo Garcia Silva -- ___ ___ __ Ricardo Garcia Silva ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Spatialite ’select’ stateme nt as vector layer in QGIS
Hi all In fact, I have a plugin that allows to load custom spatialite queries to the map canvas. I started it as a pet project, to see if I could improve my Qt skills ;) Currently it is really crude. I can make it available at the experimental repository if you are interested. My initial goal was to make something that could be made to work for spatialite and postgis alike. Currently, only the spatialite part works (and just barely). I was trying to make a more stripped plugin, that I could just use to write some SQL and see the results in 3 ways: - directly over the map canvas, creating a temporary layer (that cannot be edited), a la RT SQL style - this already works and it seems to be what you want; - saving a new layer to the database, based on the query, and immediately loading it to the canvas - not implemented (yet); - just making a normal query, without visualizing the results in the map canvas - not implemented (yet). On Wed, Dec 8, 2010 at 4:27 PM, Giuseppe Sucameli sucam...@faunalia.it wrote: Hi Noli, On Wed, Dec 8, 2010 at 11:00 AM, Noli Sicad nsi...@gmail.com wrote: Would be possible to be implemented for Spatialite Manager so it can do the same thing for Spatialite (i.e. Spatialite ’select’ statement as vector layer in QGIS)? in this moment the SL_manager doesn't allow to do this, but the spatialite provider supports it yet (see [1]). Or is this already implemented in Spatialite Manager plugin? No, I'm sorry. BTW you can use the python console and the code snippet you find at the previous link, obviously after adapting it to your needs. SL_manager needs some work, it exports very few functionalities compared to PG_manager... But in this moment we've no time to improve it. If anyone want help us in developing it, i.e. providing patches, they're welcome. Cheers. [1] http://www.mail-archive.com/qgis-developer@lists.osgeo.org/msg00878.html Thanks. Regards, Noli ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer -- Giuseppe Sucameli ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer -- ___ ___ __ Ricardo Garcia Silva ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Spatialite ’select’ stateme nt as vector layer in QGIS
Hi Giuseppe, In PG manager / RT SQL layer, can you do PosGIS ’select’ statement as vector layer in QGIS now? Noli On 12/9/10, Giuseppe Sucameli sucam...@faunalia.it wrote: Hi Noli, On Wed, Dec 8, 2010 at 11:00 AM, Noli Sicad nsi...@gmail.com wrote: Would be possible to be implemented for Spatialite Manager so it can do the same thing for Spatialite (i.e. Spatialite ’select’ statement as vector layer in QGIS)? in this moment the SL_manager doesn't allow to do this, but the spatialite provider supports it yet (see [1]). Or is this already implemented in Spatialite Manager plugin? No, I'm sorry. BTW you can use the python console and the code snippet you find at the previous link, obviously after adapting it to your needs. SL_manager needs some work, it exports very few functionalities compared to PG_manager... But in this moment we've no time to improve it. If anyone want help us in developing it, i.e. providing patches, they're welcome. Cheers. [1] http://www.mail-archive.com/qgis-developer@lists.osgeo.org/msg00878.html Thanks. Regards, Noli ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer -- Giuseppe Sucameli ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer