[Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-09 Thread Richard Duivenvoorde
Hi Devs, Raymond Nijssen had an (I think) intriguing idea: QGIS can open different types of table-data: dbf, excel etc etc But if the excel contains an x,y,wkt column, you have to save it to csv/tsv first, to be able to use the delimited-text-provider to open it as a layer. His idea: can't we u

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-09 Thread Paolo Cavallini
Agreed. There is a plugin doing this, but of course having it as a standard function is desirable. Thanks for raising this. Il 9 luglio 2016 12:00:38 EEST, Richard Duivenvoorde ha scritto: >Hi Devs, > >Raymond Nijssen had an (I think) intriguing idea: > >QGIS can open different types of table-d

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-09 Thread Raymond Nijssen
Great idea! ;) Question is where to implement it in the GUI. It overlaps the functionality in the delimited text reader. Like pointing to the x and y columns or choosing a column containing wkt. Maybe it could be a 2 steps process? Step 1 is importing any table and step 2 is creating a spatial la

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-09 Thread Matthias Kuhn
Hi, I think there are already 2 possibilities to show x,y /wkt or other geometries for any kind of layers * Geometry generators * Virtual layers (no expert, but I guess that's possible) So at least read-only this should be straightforward, read-write maybe with virtual layers (?). Matthias

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-09 Thread Paolo Cavallini
Il 09/07/2016 11:34, Raymond Nijssen ha scritto: > Great idea! ;) > > Question is where to implement it in the GUI. It overlaps the > functionality in the delimited text reader. Like pointing to the x and y > columns or choosing a column containing wkt. > > Maybe it could be a 2 steps process? St

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-10 Thread Richard Duivenvoorde
@paolo: which plugin are you thinking of? Because for exampe xytools can open odt and excel, but via python, while the idea here is to be able to load whatever (table) format ogr is able to load. And not only given and x,y field but also a column containing wkt polygons (as the csv-provider does t

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-10 Thread Alexandre Neto
This might be the plugin you are talking about: https://plugins.qgis.org/plugins/SpreadsheetLayers/ A dom, 10/07/2016, 13:16, Richard Duivenvoorde escreveu: > > @paolo: which plugin are you thinking of? > Because for exampe xytools can open odt and excel, but via python, while > the idea here i

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-10 Thread Neumann, Andreas
Hi, I would welcome an "easier" way to open Point or WKT data from formats that do not store geometries natively, as you propose. Thanks for bringing it to the table, Raymond and Richard! My suggestion would be to enhance the existing OGR "Add vector layer" dialog with an option to choose colum

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-11 Thread Chris Crook
et Cc: qgis-developer Subject: Re: [Qgis-developer] morph delimited-text-provider to generic table-provider? Hi, I would welcome an "easier" way to open Point or WKT data from formats that do not store geometries natively, as you propose. Thanks for bringing it to the table, Raymond a

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-11 Thread Matthias Kuhn
On 07/10/2016 02:16 PM, Richard Duivenvoorde wrote: > > > @mattias: mm, if I load a strict csv table (be it csv or excel), > containing an x and y column, according to this blogpost: > http://www.opengis.ch/2015/12/10/geometry-generator-symbology/ > I should be able to select a geometry generator

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-11 Thread Raymond Nijssen
Hi Andreas, I'd just like to see a way to create a new layer from any (attribute) table in QGIS. So, even a point shapefile containing a wkt column with polygons or a database table containing x and y field or an opened xls sheet containing json somewhere. My suggestion: - To strip the geometry

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-11 Thread Chris Crook
From: Qgis-developer [qgis-developer-boun...@lists.osgeo.org] On Behalf Of Matthias Kuhn [matth...@opengis.ch] Sent: 11 July 2016 19:09 To: rich...@duif.net; qgis-developer@lists.osgeo.org Subject: Re: [Qgis-developer] morph delimited-text-provider to generic table-provider? On 07/10/2016 02

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-11 Thread Matthias Kuhn
On 07/11/2016 10:10 AM, Richard Duivenvoorde wrote: > The virtual layer and Generator stuff I think is gui-wise is harder for > beginners than (though crowded) Delimited Text layer dialog. It's probably easier to fix that with a shortcut / setup wizard... than creating the code to loop everything

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-11 Thread Nyall Dawson
On 11 Jul 2016 18:34, "Matthias Kuhn" wrote: > > On 07/11/2016 10:10 AM, Richard Duivenvoorde wrote: > > > The virtual layer and Generator stuff I think is gui-wise is harder for > > beginners than (though crowded) Delimited Text layer dialog. > > It's probably easier to fix that with a shortcut /

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-11 Thread Richard Duivenvoorde
On 2016-07-11 10:43, Nyall Dawson wrote: I still wonder if (in the ideal world) the delimited text provider be retired and all the extra features it has (wkt, regex, etc) ported over to OGRs csv reader. Then the provider would become just a user friendly front end for configuring the OGR data sou

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-11 Thread Neumann, Andreas
Hi, There are probably two different issues/use cases here: 1. Enabling geometries for already loaded layers (what Richard and Raymond initially suggested) 2. Loading geometryless layers through OGR (or other providers) with the option to define geometry columns. Ideally this could all be don

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-11 Thread Paolo Cavallini
Il 11/07/2016 11:32, Neumann, Andreas ha scritto: > Hi, > > There are probably two different issues/use cases here: > > 1. Enabling geometries for already loaded layers (what Richard and > Raymond initially suggested) That is, found it at last: https://plugins.qgis.org/plugins/xyToPoint/ All the

Re: [Qgis-developer] morph delimited-text-provider to generic table-provider?

2016-07-15 Thread RĂ©gis Haubourg
Hi, I have had that in mind for quite a while now: - non spatial datasources that can be spatialized with XY / WKT or adress geocoding. - Those non spatial datasources are most of the time untyped datasources. Some try to autotype like Excel, some not like CSV. Delimited text provider handles the