topic Re: Extraction all values from attribute table in Data Management Questions

Extraction all values from attribute table

DitlevReventlow — Sun, 14 Jun 2015 13:55:15 GMT

Hey Everyone.

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.

Thank you!

Best regards

Ditlev Reventlow

Re: Extraction all values from attribute table

XanderBakker — Sun, 14 Jun 2015 16:49:54 GMT

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:

ArcGIS Help (10.2, 10.2.1, and 10.2.2) and ArcGIS Help (10.2, 10.2.1, and 10.2.2)

Re: Extraction all values from attribute table

DanPatterson_Retired — Sun, 14 Jun 2015 17:10:53 GMT

You should also learn to use NumPy as in this example

Re: Extraction all values from attribute table

DitlevReventlow — Sun, 14 Jun 2015 19:30:34 GMT

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?

Re: Extraction all values from attribute table

DitlevReventlow — Sun, 14 Jun 2015 19:31:27 GMT

Thanks Dan, I will look into that!

Re: Extraction all values from attribute table

DanPatterson_Retired — Sun, 14 Jun 2015 23:56:42 GMT

Ditlev...

I have moved this to Managing Data since it has nothing to do with help on GeoNet (ie the GeoNet Help place

Re: Extraction all values from attribute table

curtvprice — Mon, 15 Jun 2015 02:18:13 GMT

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...

Re: Extraction all values from attribute table

XanderBakker — Mon, 15 Jun 2015 03:17:33 GMT

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.

Re: Extraction all values from attribute table

DitlevReventlow — Mon, 15 Jun 2015 12:26:06 GMT

Thank you, I just thought this was general help.