[Qgis-developer] Add virtual layer equivalent in Processing
Anita Graser
anitagraser at gmx.at
Tue Dec 13 13:08:01 PST 2016
Hi Victor,
On Mon, Dec 5, 2016 at 6:16 PM, Anita Graser <anitagraser at gmx.at> wrote:
> Thanks Victor!
>
> On Mon, Dec 5, 2016 at 1:54 PM, Victor Olaya <volayaf at gmail.com> wrote:
>
>> Anita, Mathieu
>>
>> I added both of your requests and it should be possible now to use
>> tables on both "execute SQL" and "build virtual vector" algorithms
>>
>> Let me know if you try it (it is on master)
>
>
> The SQL statement I want to execute (and which runs well in Layer | Add
> Layer | Add Virtual Layer) is:
>
> select s_out.y1_statefips, s_out.y2_statefips,
> st_centroid(f.geometry)
> from fips as f
> join stateoutflow1415 as s_out
> on f.fips = s_out.y1_statefips
>
Which Processing tool should I use to create a layer from the above
statement?
Thank you and best wishes,
Anita
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20161213/4e24167e/attachment.html>
More information about the Qgis-developer
mailing list