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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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