<div dir="ltr">Beautiful, thank you both!<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jan 20, 2022 at 11:14 AM Richard McDonnell <<a href="mailto:richard.mcdonnell@opw.ie">richard.mcdonnell@opw.ie</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-IE">
<div class="gmail-m_-7592253871090511854WordSection1">
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">Hi Hugh,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">Are you working with a CSV file? Or is it a shapefile?? Im not sure if this will work, but create a new point for a null geomety, you
can then, using the Attribute table (in edit mode), <b>Merge Features</b>, by selecting the new geometry and the table row without geometry, then selecting
<b>Merge Features</b></span><b><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><img style="width: 0.2291in; height: 0.2083in;" id="gmail-m_-7592253871090511854Picture_x0020_2" src="cid:17e7846e9c74cff311" width="22" height="20"></span></b><b><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">
</span></b><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">The popup will then allow you to merge the two, you can select the row without geometry and select “<b>Take attributes from selected feature</b>”
this should merge your new geometry with the attribute. <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">Regards,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">Richard<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<table style="font-size:9pt;height:321px;font-family:Arial,sans-serif;width:500px;line-height:15px" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="font-size:9pt;font-family:Arial,sans-serif;width:500px;color:rgb(0,77,68);padding-bottom:6px">
<span style="font-family:Arial,sans-serif;font-weight:bold;color:rgb(0,77,68)"><br>
——</span><br>
<span style="font-family:Arial,sans-serif;font-weight:bold;color:rgb(0,77,68)">Richard McDonnell MSc GIS, FME Certified Professional</span><br>
<span style="font-family:Arial,sans-serif;color:rgb(0,77,68)"><i>FRM Data Management</i></span><br>
<br>
<span style="font-family:Arial,sans-serif;color:rgb(0,77,68)">——</span><br>
<span style="font-family:Arial,sans-serif;font-weight:bold;color:rgb(0,77,68)">Oifig na nOibreacha Poiblí</span><br>
<span style="font-family:Arial,sans-serif;color:rgb(0,77,68)">Office of Public Works</span><br>
<br>
<span style="font-family:Arial,sans-serif;font-weight:bold;color:rgb(86,81,72)">Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
</span><br>
<span style="font-family:Arial,sans-serif;color:rgb(86,81,72)">Jonathan Swift Street, Trim, Co Meath, C15 NX36</span><br>
<span style="font-family:Arial,sans-serif;color:rgb(86,81,72)">——</span><br>
<span style="font-family:Arial,sans-serif;color:rgb(86,81,72)">M +353 87 688 5964 T +353 46 942 2409</span><br>
<a href="https://gov.ie/opw" target="_blank">https://gov.ie/opw</a><br>
<br>
<span style="font-family:Arial,sans-serif;color:rgb(0,77,68)">——<br>
To send me files larger than 30MB, please use the link below <a href="https://filetransfer.opw.ie/filedrop/richard.mcdonnell@opw.ie" target="_blank">https://filetransfer.opw.ie/filedrop/richard.mcdonnell@opw.ie</a><br>
</span><br>
<span style="font-family:Arial,sans-serif;color:rgb(0,77,68)">Email Disclaimer: <a href="https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/" target="_blank">https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/</a>
</span></td>
</tr>
</tbody>
</table>
<div style="border-color:currentcolor currentcolor currentcolor blue;border-style:none none none solid;border-width:medium medium medium 1.5pt;padding:0cm 0cm 0cm 4pt">
<div>
<div style="border-color:rgb(225,225,225) currentcolor currentcolor;border-style:solid none none;border-width:1pt medium medium;padding:3pt 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">From:</span></b><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"> Qgis-user <<a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@lists.osgeo.org</a>>
<b>On Behalf Of </b>Hugh Kelley<br>
<b>Sent:</b> 20 January 2022 16:01<br>
<b>To:</b> qgis-user <<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a>><br>
<b>Subject:</b> [Qgis-user] Update Null Geometry<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">Hi all, <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I have a points dataset with a few null geometries in it. <u></u>
<u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Is there a tool that can update these in place? <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">It seems that the point editing tool must add a new row instead of updating an existing row.
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">The vertex editing tool seems unable to update a null geom since there's nothing to initially click on.
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Maybe I'm missing a tool or way of using the vertex editing tool?
<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">A less preferred workflow would be to create a separate file and manually add the points with the primary key as an attribute to later update on in postgres but it would be much cleaner to edit the table in place I think and I am curious
if there is a solution since I'm not thinking anything up myself. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks for any suggestions. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">-- <u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Hugh Kelley <u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr">Hugh Kelley <br><div><br></div></div></div></div></div></div></div></div>