AnsweredAssumed Answered

Help with Raster Calculator - data field selection

Question asked by Cursus on Jun 9, 2017
Latest reply on Jun 9, 2017 by xander_bakker

I have a Weighted Overlay raster which contains surface friction values in the VALUE field.  I want to apply a formula to convert friction value to speed.  How do I select a field in the layer so it will do it for all 45 values in the layer?

Raster Layer Name:  WO_equal_2

Field in layer to use:   VALUE

Data range in Value  is from: 150 to 1000

Formula used in Raster Calculator:  Speed - ((Value/1000)*40)   (equation works in Excel)

 

WO_equal_2 has an attribute table with three fields: OBJECTID*, Value, Count 

 

Result is a new Raster layer with only two values.  Seems to only read first row and applies formula to both Value and Count field.

 

Going back to olden days (Pre ArcGIS 10) we had dot command to do this in Raster Calculator.

I have tried this in three versions of ArcGIS desktop (10.1, 10.3, and 10.5)

 

Any and all suggestions  to an easy solution welcome.

Outcomes