Export data from rasters into csv

Question

Hello all,

I have 16 years of data in raster (one raster for every day) and I want to extract them into csv file. Is there a way which I can export them all based on their date while the date is part of the name of every raster?

The name of files are like this:  "SMD_HIST_200001310000.d01.grb.tif.tif"

Thank you in advance.

CodyBinkelheim · Answer

Okay - I have never tried this but based on a quick search I assume this tool would work

Raster to ASCII—Help | ArcGIS Desktop

you would likely then have to process in some other software to convert to *.csv format

Cody B.

AmenehTavakol · Answer

Dear Cody,

I have different data sets all in raster (observed and model-based data), I want to calculate the correlation coefficient between them and graph data, .... I need to have CSV files no need to have raster at the end. I need to extract data from rasters and continue my work on different data sets (for example soil moisture data from observed and model-based data sets). I need to work with numbers not with rasters.

Ameneh

CodyBinkelheim · Answer

Ameneh

I believe there must be a way to do what you are asking (if not more than one way), but I will be honest that I don't know the best approach.  I can ask others within Esri, but my concern is that exporting to CSV (presumably to do the statistical calculations in some other software) will be slow and difficult, and that there are better ways to do this immediately within ArcGIS (especially if you want to import the results back into ArcGIS when you are done).

There have been times in my life I have used a wrench to pound on a nail, but only because I did NOT have a proper hammer.  You have a powerful tool box and I want to guide you to use the best tools.

I assume you are seeking to calculate statistics at every pixel.  I don't know if you will then aggregate statistics of neighboring pixels together, or display the results as a raster, etc. but if you can describe your data and your end goals more completely, we can advise you more easily.

I will ask Esri colleagues for the best way to do these statistical calculations.  Have you looked at the Mosaic Dataset as a structure to compile all of your rasters into one single data structure?

What is a mosaic dataset?—Help | ArcGIS Desktop

Cody