1

Trying to

  1. select all points by location that fall within a polygon
  2. select by attribute from the selected by location using an expression. so far it works fine ..
  3. I have a list of values - I need to change the expression every time the model run and write the results to Excel or Text File as table as follows.

    call_type    -   Count
    

I know that can be accomplished using the iteration but I couldn't figure it out. enter image description here

5
  • I updated the model.. Only need to export the get count to text File Commented Mar 14, 2017 at 17:10
  • You can't write the count unless you use a bit of python. An alternative way that may work and keeps it entirely within model builder is after your selections you update a field with the value, then run a summary table tool after the model has run?
    – Hornbydd
    Commented Mar 14, 2017 at 17:14
  • Thanks, how can I update the field... do you have any python snipped to accomplish the task. Regards Commented Mar 14, 2017 at 17:17
  • this thread gis.stackexchange.com/questions/97930/… is similar but I could not manage to add the script Commented Mar 14, 2017 at 17:19
  • Update a field is nothing more than running the field calculate tool on your table with the selection. Simply attach it to your model.
    – Hornbydd
    Commented Mar 14, 2017 at 20:00

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.