Adding x,y coordinates to Attribute table in QGIS

Question

If I use the 'Add coordinates to point' it adds the coordinates to in the file, however splits the data into the amount of objects in the original file. If I try to add separate columns in the attribute file calling them 'Coordinate X' or 'Y', then using the $x or $y expression, the output is just NULL. I need to coordinates but all in one file.

Please state which CRS your using, which feature type you have and which field type your coordinate fields have when you try to create them. — Erik, Apr 29 '20 at 10:54
If you were using field calculator or created a new field in qgis make sure the length of the field is greater than 0 — she_weeds, Apr 30 '20 at 22:57
Please, do not forget about "What should I do when someone answers my question?" — Taras, Mar 21 '22 at 15:23

score 12 · Answer 1 · edited Aug 08 '21 at 16:22

12

Use a built-in tool "Add X/Y fields to layer"

There you can choose a coordinate system in which you want your coordinates and add an optional field prefix.

edited Aug 08 '21 at 16:22

Taras

32,823
4
66
137

answered Aug 08 '21 at 12:12

Trnovstyle

436
3
3

score 10 · Answer 2 · answered Apr 29 '20 at 11:54

Under assumption that you have some kind of a vector layer (such as GeoJSON or something similar) I provide an explanation on the example of a GeoJSON file that contains point features. You didn't provide information how did you calculate fields X and Y. You should use Field calculator. See hovered icon in the first figure.

First, right click on the vector layer and "Open attribute table" and it will open like this.

After you click on Field calculator icon another window will appear. I've put all parameters that you would need to create a new field with X coordinate (Note I named my field E -> easting instead of X). You can also edit existing attribute by ticking "Create new field" checkbox. This will enable the listbox on the right side of the form "Update existing field".

After you repeat the procedure for Y, you get attribute table with updated set of attributes as you can see in an image below.

Don't forget to save your edits. These edits will remain permanent in your file.

Taras · Answer 3 · 2023-12-22T21:16:54.937

A possible solution using PyQGIS.

Let's assume there is a point layer called 'points' with its attribute table, see image below.

Proceed with Plugins > Python Console > Show Editor (Ctrl+Alt+P) and paste the script below

# imports
from qgis.core import QgsProject, QgsField
from PyQt5.QtCore import QVariant
getting point layer by its name
layer = QgsProject.instance().mapLayersByName('test')[0]
accessing point layer's provider
layer_provider = layer.dataProvider()
adding new fields
for attr in ["X_Coord", "Y_Coord"]:
    layer_provider.addAttributes([QgsField(attr, QVariant.Double)])
layer.updateFields()
layer.startEditing()
looping over each feature
for feature in layer.getFeatures():
    # accessing layer fields
    fields = layer.fields()
# accessing geometry as a point
geom_pt = feature.geometry().asPoint()

attrs = {
    fields.indexFromName(&quot;X_Coord&quot;): geom_pt[0],
    fields.indexFromName(&quot;Y_Coord&quot;): geom_pt[1]
}

# changing attribute records
layer_provider.changeAttributeValues({feature.id(): attrs})


layer.commitChanges()

Press Run script and get the output that will look like

References:

Adding x,y coordinates to Attribute table in QGIS

3 Answers3

getting point layer by its name

accessing point layer's provider

adding new fields

looping over each feature

Linked