I like to summarize of the ID-Field with the ModelBulider because in the end I have to build a tool. The problem I have is that the field “GRIDCODE” should get in the new table comma separate. So that it is possible to see the combinations, for example the ID-Field 244 has the GRIDCODE 7, 10, 10. The Field area should get added.

enter image description here

Background: The Field ID-Field is from a fishnet lying over a shape with a classification “GRIDCODE” and got intersect. Now I need just a table with the ID form the fishnetcell and the combinations of the classification-code and the area. Does anyone have an idea how to do this with the Modelbuilder? Thanks a lot.

Here is the last part of the Model so far.enter image description here

The final table should look like this; in the field area should be the sum area from the combination.

enter image description here

  • 1
    Try tabulate area tool in Spatial Analyst. Approximate solution baseb on cell size in environment setting – FelixIP Sep 5 '14 at 10:18
  • I’m trying the tabulate area but it doesn’t give the output I need. So I will try Hornbydd’s way… Thanks for answering – Nora Sep 5 '14 at 11:16
  • Could you please clarify this question? I am having a hard time understanding what your end-goal is. Could you provide an example of the specific output you would like to produce? – Aaron Sep 5 '14 at 14:24
  • 1
    Sorry, I have added a table-example for the output I wish to have in my question. – Nora Sep 5 '14 at 15:53
  • Yes I agreed I did this the same way but not similiar to yours. – PROBERT Sep 5 '14 at 20:41

If I have understood then it sounds like you want to run the summary statistics tool setting the case fields to be your ID field AND your GRIDCODE field whilst counting on GRIDCODE. This then feeds into the pivot table tool. The Pivot tool requires an ArcInfo(Advanced) license.

  • I tried it with the summary statistics tool, but I do not know what to do with the “GRIDCODE” because it shouldn’t get one of this statistics SUM_FIELD, MAX_FIELD, MIN_FIELD, RANGE_FIELD, STD_FIELD, FIRST_FIELD, LAST_FIELD, COUNT_FIELD. It should just be in a Field like 7,10,10 so that I get all the combinations. I guess this is the step where I need the pivot table tool. Mhh, I gonna try it again… there must be a solution I hope. But in the tool pivot table I can just add one table. – Nora Sep 5 '14 at 11:49
  • I have updated my answer to explain how to use the summary statistics tool correctly. – Hornbydd Sep 5 '14 at 14:00
  • Have you experiment with the summary statics with different fields ? – PROBERT Sep 5 '14 at 20:42
  • Have you tried Frequency tool first and then do the summary tool ? – PROBERT Sep 5 '14 at 20:49
  • 1
    I did it now with the pivot table in excel, not a nice solution but it is working. I still like to do all in ArcGIS. Having a few new problems I need to do this later. so long, thanks for your answers! – Nora Sep 8 '14 at 12:42

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.