0

I am running a summary statistic on a clip to get acre counts by area type. I want to then add a second field that has the acre count from the total area. A third field be added so that it shows as the percentage of each acre type as compared to the whole area.

First field = Summary Statistics of area type by acre count

Second field = Total acres of project area <--- This is where I am having trouble

Third field = (([first field]/[second field]) * 100)

The problem is, I am trying to get the value from the initial project area using the Get Field Value tool. I am able to do this but when using the Calculate Field tool to calculate the third field, I do not know how to get this option.

Can I set the value from the Get Field Value to a variable then in the Field Calculator use Python to call the variable? Will it recognize the variable?

  • Can you clarify where it is that you are trying to do this? (in a python script, in model builder or just using field calculator) – DMusketeer Oct 27 '15 at 11:55
  • Sorry, I am doing this in model builder. I can do all of this in the field calculator but I want to make a model builder tool to do everything at once much more quickly. – giscard78 Oct 27 '15 at 12:03
  • "get value from the initial project area", are these values stored in a different table or is all of this info in one table? – artwork21 Oct 27 '15 at 12:05
  • That value is coming from another separate feature class. – giscard78 Oct 27 '15 at 12:10
  • Can you join the two layers spatially or non-spatially, if so you could use python within field calculator? – artwork21 Oct 27 '15 at 12:19
1

You can do this in ModelBuilder using Get Field Value on your project layer (against pre-calculated area or acre field), and using in-line variable substitution within a Row Selection iterator, and calculating using field calculation on the sum stat table.

See graphics below:

enter image description here

enter image description here

  • Get field value doesn't seem to exist in arc 10.2... any work around? – mmann1123 Mar 2 '16 at 1:16
  • Never mind. Get field values is part of the model builder only toolkit. "The only way you can gain access to the tools within the ModelBuilder toolbox is from the Insert menu in the ModelBuilder window." – mmann1123 Mar 2 '16 at 1:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.