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/[email protected] Email Disclaimer: https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/ From: QGIS-User <[email protected]> On Behalf Of Roland Spielhofer via QGIS-User Sent: 30 September 2024 13:45 To: QGIS User <[email protected]> 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
_______________________________________________ QGIS-User mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
