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

[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 that already)...
This would for example also work for a dbf containg x,y values

@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 in styles.. but with a
table the styles is ... empty :-(

Tried to make a geometry using vectorcalc, but it will not 'morph' the
layer from a table (icon) in a geometry/point icon and the points (I
tried: make_point)

I am aware that this is probably readonly, but that is ok I think.

Regards,

Richard

On 09-07-16 11:44, Matthias Kuhn wrote:
> 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
> 
> On 07/09/2016 11:34 AM, Raymond Nijssen wrote:
>> 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 layer from it. But we would loose the quick
>> "Add delimited text layer" functionality.
>>
>> Any ideas?
>>
>> @Paolo, which plugin can do this? XyTools?
>>
>> Regards,
>> Raymond
>>
>>
>>
>>
>> On 09-07-16 11:14, Paolo Cavallini wrote:
>>> 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
>>> <rdmailings at duif.net> ha scritto:
>>>
>>>     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 use the delimited-text-provider for all tables that
>>>     are open in QGIS immediately?
>>>
>>>     Had a look into the code
>>>
>>>     https://github.com/qgis/QGIS/blob/master/src/providers/delimitedtext/qgsdelimitedtextfile.cpp#L583
>>>
>>>     which 'just' looks like a QTextStream:
>>>
>>>     https://github.com/qgis/QGIS/blob/master/src/providers/delimitedtext/qgsdelimitedtextfile.h#L352
>>>
>>>     And
>>>     according to this:
>>>     https://forum.qt.io/topic/63310/how-to-save-a-treeview-as-csv-file-in-qt
>>>
>>>     It is easy to create a textstream from QModel (in which we have the data
>>>     I think???)...
>>>
>>>     So Question:
>>>     - (to devs): would this indeed be doable/easy?
>>>     - (to UI's): should the Delimited Text File dialog be updated then (or
>>>     only with a 'open excisting table button'?
>>>     - should we rename the provider to 'table' provider.
>>>
>>>     Comments/Opinions?
>>>
>>>     Regards,
>>>
>>>     Richard Duivenvoorde
>>>     ------------------------------------------------------------------------
>>>
>>>     Qgis-developer mailing list
>>>     Qgis-developer at lists.osgeo.org
>>>     List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>     Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>
>>>
>>> -- 
>>> Paolo Cavallini
>>> www.faunalia.eu <http://www.faunalia.eu>
>>>
>>>
>>> _______________________________________________
>>> Qgis-developer mailing list
>>> Qgis-developer at lists.osgeo.org
>>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
> 
> -- 
> Matthias Kuhn
> OPENGIS.ch - https://www.opengis.ch
> Spatial • (Q)GIS • PostGIS • Open Source
> 
> 
> 
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
>