I‘m trying to export maize yield data from a raster to some sort of text file in order to analyze the data statistically. So far I‘ve managed to do so for an entire country (France), so that I ended up with a table containing the coordinates of about 8000 10x10km squares with the corresponding yield data (see pictures)
Now, data on country level is not precise enough for my purpose, I need to know for each square at least the region (department) it is located in. Extracting each department individually is way too tedious, especially considering that I will have to do the same for multiple other European countries.
Is there a way to easily extract the yield data from the raster so that I know in which department each square is located?