Is there anyway to get Arcmap to show all pixel values in a attribute table. Basically so that instead of having a attribute table like this:
Rowid Count Value_1 Value_2
1 4 2 1
2 3 2 3
, data is instead presented like below
Rowid Value_1 Value_3
1 2 1
2 2 1
3 2 1
4 2 1
5 2 3
6 2 3
7 2 3
It is because for me it is much easier to work with the data if it is in the this format (Especially if you import the data into excel, since I would like to create a scatter plot here with Value_1 and Value_2)
Alternatively is there anyway to get Arcmap to plot values, find regression equation and R^2 values?
There are many thousand rows in the attribute table so manual alteration is not an option.
To convert a raster to a table and create a row for each pixel, you could use the Raster to Points conversion tool and then export the featureclass to Excel. Is this thread related to: only extract some rows from an raster attribute table ?
Alternatively, you might be interested in this video: http://video.esri.com/watch/1949/performing-regression-analysis-using-raster-data
And the Help topics:
Yes the threads are somewhat related to each other, two aspects of a problem that I encountered in getting the results into excel in the best way.
Thank you for the tip about raster to point conversion. It seems like it is only possible to convert it one column at a time and I have 3 columns that I need to have in the attribute table.
Therefore, If I use join on this "pointid" column that is generate from "the raster to point" 3 times (one for each newly derived feature) then the data of the columns should be fitted to the right points, right?
Yes, that would do it. The Join Field tool will work. Of course if you have millions of cells in your raster you may start running into trouble with the size of your dataset...
The alternative could be to convert 1 raster to points and use that point featureclass in the Extract Multi Values to Points tool. This will add the values of a number of raster as attributes to the point featureclass and there will be no need to join the results.