0

I have a GeoTIFF with daily average discharge data over 10 years (3652 bands per grid cell, each band representing one day). I would like to export this discharge data to a CSV file to work with it in Excel. Normally I would use the 'raster pixels to points' and subsequently save as CSV, but I need the data from every band. How should I go about getting this data into a CSV file?

GeoTIFF of 10 years of daily average data, identifier showing the bands in one grid cell

Improve this question
1
  • 1
    Best to take the Tour (gis.stackexchange.com/tour) to avoid your post getting closed for including multiple questions. This post has a Python solution for extracting out all of the bands to new raster files. Once you have sorted out the extraction post again for batch conversion of those bands: gis.stackexchange.com/questions/357129/…
    – GBG
    Commented May 24 at 15:40

1 Answer 1

Reset to default
0

You can create a multiband csv file with a Python utility gdal2xyz https://gdal.org/programs/gdal2xyz.html. Use the -allbands option https://gdal.org/programs/gdal2xyz.html#cmdoption-gdal2xyz-allbands.

Unfortunately you cannot read that data back with the GDAL XYZ driver https://gdal.org/drivers/raster/xyz.html because it supports only one band. See this (closed) question How to convert multi-band CSV file generated from gdal2xyz to multi-band raster file.

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.