nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Extraction all values from attribute table

DitlevReventlow

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

Najděte více příspěvků označených jako

Accepted answers

All comments

DitlevReventlow

Thank you, I just thought this was general help.

XanderBakker

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.

curtvprice

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

DanPatterson_Retired

Ditlev...

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

DitlevReventlow

Thanks Dan, I will look into that!

DitlevReventlow

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?

DanPatterson_Retired

You should also learn to use NumPy as in this example

XanderBakker

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)

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.