[Qgis-user] Create Geometry for virtual layer

[Richard McDonnell]

Hi Roland,
I know it’s not strictly what you are looking to do, but the simplest way to do it, is to export the new table as a CSV and then import that back in using Delimited Text, specifying your new X and Y values.
Kind Regards,

Richard.



——
Richard McDonnell MSc GIS, FME Certified Professional
Flood Risk Management - Data Management

——
Oifig na nOibreacha Poiblí
Office of Public Works

Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
Jonathan Swift Street, Trim, Co Meath, C15 NX36
——
M +353 87 688 5964 T +353 46 942 2409
https://gov.ie/opw

——
To send me files larger than 30MB, please use the link below https://filetransfer.opw.ie/filedrop/richard.mcdonnell@opw.ie

Email Disclaimer: https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/
From: QGIS-User <qgis-user-bounces at lists.osgeo.org> On Behalf Of Roland Spielhofer via QGIS-User
Sent: 30 September 2024 13:45
To: QGIS User <qgis-user at lists.osgeo.org>
Subject: [Qgis-user] Create Geometry for virtual layer

Hi,
I have a query like this

SELECT avg(_gfsGEO_RECHTSWERT) as x, avg(_gfsGEO_HOCHWERT) as y, Filename, _gfsfid, _gfsKURZNAME, avg(T_C) FROM Temp_near_GFS group by Filename, _gfsfid

to average some values accoring to their attributes.
I get a new virtual layer and the attribute table content looks fine, x and y are populated as well with reasonable values.

What I am struggling is to create the actual points / geometries to make the locations visible.
How do I modify the statement so that I can specify a "geometry column" as expected by the Creat/Modify Virtual layer GUI in the bottom of the form?

TIA Roland
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240930/3990ed29/attachment.htm>