Try: select avg(_gfsGEO_RECHTSWERT) as x, avg(_gfsGEO_HOCHWERT) as y, Filename, _gfsfid, _gfsKURZNAME, avg(T_C) st_point(x, y) as geom from Temp_near_GFS group by Filename, _gfsfid
If that doesn’t work, you may need to replace x, y in the st_point call with the full calculations e.g. st_point( avg(_gfsGEO_RECHTSWERT), avg(_gfsGEO_HOCHWERT) ) Cheers John From: QGIS-User <qgis-user-boun...@lists.osgeo.org> On Behalf Of Roland Spielhofer via QGIS-User Sent: 30 September 2024 13:45 To: QGIS User <qgis-user@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 This email and any attachments are intended solely for the use of the named recipients. If you are not the intended recipient you must not use, disclose, copy or distribute this email or any of its attachments and should notify the sender immediately and delete this email from your system. UK Research and Innovation (UKRI) has taken every reasonable precaution to minimise risk of this email or any attachments containing viruses or malware but the recipient should carry out its own virus and malware checks before opening the attachments. UKRI does not accept any liability for any losses or damages which the recipient may sustain due to presence of any viruses.
_______________________________________________ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
