Extracting Coordinates of a 1x1 GRID in a gpkg file using QGIS

Question

I have a gpkg file where I have the coordinates of the 1x1 km grid. See the below sample picture.

I am trying to extract the coordinates (latitude & longitude) of all the 1x1 grid cells from my gpkg file.

Any hints here?

Answer 1

It depends on what you are trying to achieve. If you are looking for the coordinates of each corner of every cell, that is different than looking for the central coordinate of each cell.

I am going to assume you meant the central coordinate of each cell. In which case, one possible solution is as follows:

1. Run the 'Centroids' tool on the layer of cells. This will produce a layer of single points representing the center of each cell.
2. Then run the 'Add geometry attributes' tool on the resulting centroids layer, which will produce a new layer where each cell centroid has two additional columns added to the attribute table: the x-coordinate (longitude) and y-coordinate (latitude).
3. Assuming you want this information in a table you can then play around with in Excel, export the resulting layer to a CSV file.

Important point to remember, the gpkg layer must be in a geographic CRS (in degrees), not projected, or your resulting x and y coordinates will not be lat/lon but Northings and Eastings.