Re: [Qgis-user] Update Null Geometry
Beautiful, thank you both! On Thu, Jan 20, 2022 at 11:14 AM Richard McDonnell wrote: > Hi Hugh, > > 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), *Merge Features*, by selecting > the new geometry and the table row without geometry, then selecting *Merge > Features* The popup will then allow you to merge the two, you can select > the row without geometry and select “*Take attributes from selected > feature*” this should merge your new geometry with the attribute. > > Regards, > > > > Richard > > > > —— > Richard McDonnell MSc GIS, FME Certified Professional > *FRM 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.mcdonn...@opw.ie > > Email Disclaimer: > https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/ > > *From:* Qgis-user *On Behalf Of *Hugh > Kelley > *Sent:* 20 January 2022 16:01 > *To:* qgis-user > *Subject:* [Qgis-user] Update Null Geometry > > > > Hi all, > > I have a points dataset with a few null geometries in it. > > > > Is there a tool that can update these in place? > > > > It seems that the point editing tool must add a new row instead of > updating an existing row. > > > > The vertex editing tool seems unable to update a null geom since there's > nothing to initially click on. > > > > Maybe I'm missing a tool or way of using the vertex editing tool? > > > > 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. > > > > Thanks for any suggestions. > > -- > > Hugh Kelley > > > -- Hugh Kelley ___ 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
Re: [Qgis-user] Update Null Geometry
Hi Hugh, 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), Merge Features, by selecting the new geometry and the table row without geometry, then selecting Merge Features[cid:image001.png@01D80E18.C81AC070] The popup will then allow you to merge the two, you can select the row without geometry and select “Take attributes from selected feature” this should merge your new geometry with the attribute. Regards, Richard —— Richard McDonnell MSc GIS, FME Certified Professional FRM 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.mcdonn...@opw.ie Email Disclaimer: https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/ From: Qgis-user On Behalf Of Hugh Kelley Sent: 20 January 2022 16:01 To: qgis-user Subject: [Qgis-user] Update Null Geometry Hi all, I have a points dataset with a few null geometries in it. Is there a tool that can update these in place? It seems that the point editing tool must add a new row instead of updating an existing row. The vertex editing tool seems unable to update a null geom since there's nothing to initially click on. Maybe I'm missing a tool or way of using the vertex editing tool? 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. Thanks for any suggestions. -- Hugh Kelley ___ 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
Re: [Qgis-user] Update Null Geometry
Hi Hugh, Use the "Add part" tool: https://docs.qgis.org/3.16/en/docs/user_manual/working_with_vector/editing_geometry_attributes.html#add-part Regards, Harrissou Le jeu. 20 janv. 2022 à 17:02, Hugh Kelley a écrit : > Hi all, > I have a points dataset with a few null geometries in it. > > Is there a tool that can update these in place? > > It seems that the point editing tool must add a new row instead of > updating an existing row. > > The vertex editing tool seems unable to update a null geom since there's > nothing to initially click on. > > Maybe I'm missing a tool or way of using the vertex editing tool? > > 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. > > Thanks for any suggestions. > -- > Hugh Kelley > > ___ > 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 > ___ 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
[Qgis-user] Update Null Geometry
Hi all, I have a points dataset with a few null geometries in it. Is there a tool that can update these in place? It seems that the point editing tool must add a new row instead of updating an existing row. The vertex editing tool seems unable to update a null geom since there's nothing to initially click on. Maybe I'm missing a tool or way of using the vertex editing tool? 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. Thanks for any suggestions. -- Hugh Kelley ___ 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