topic Using model builder for summary statistics and setting ranges to group by in ModelBuilder Questions

Using model builder for summary statistics and setting ranges to group by

CiaranHiggins1 — Sat, 23 Mar 2019 11:50:51 GMT

I am trying to perform a summary on a poly line dataset. This data contains an attribute for the year the section was laid and the diameter of the section. I want to sum the length of these sections group them by both year and band. However I want to group the bands and years e.g year laid 2000-2010 and diameter 150-300 mm. I have created a model which does what I want but I was wondering if there was an easier way to carry out this task. I was also wondering if there was a way to modify the model so that the user could can the year bands and diameters in a table of spreadsheet. I am new to the model builder. Maybe there is a better way to do what I am trying to do. See attached images.

Thanks

Ciaran

Re: Using model builder for summary statistics and setting ranges to group by

curtvprice — Sun, 12 Dec 2021 10:19:37 GMT

You can make an model input variable a multi value list, one variable for each of your classify variables.

Then you can use that multi value list in Calculate Field, inside the code block splitting it into a Python list with “;”.split().

Here is a Calculate Field expression I came up with that seems to do what you want. Dan Patterson‌ numpy is pretty handy!

# Calculate Field expression, specifying to update field "class"
# Source field is the name of the field we want to classify
classify(!%Source field%!)

# Code block 
# breaks is a multivalue model variable I created of type Double
import numpy as np
breaks = sorted([float(k) for k in "%breaks%".split(";")])
breaklab = ["<{}".format(breaks[0])]
breaklab += ["{} up to {}".format(breaks[k], breaks[k+1]) for k in range(len(breaks)-1)]
breaklab += [">={}".format(breaks[-1])]
breaks = np.array(breaks)
def classify(vv):
    p = np.searchsorted(breaks, vv, 'right')
    return breaklab[p]‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Using model builder for summary statistics and setting ranges to group by

CiaranHiggins1 — Mon, 25 Mar 2019 10:17:29 GMT

Curtis,

Thanks for the information but i must be doing something stupid. I have tried to simplify this to test. So i created a new feature class with the same structure as your example and with the same names. When i try to run the model i get an error about value type. I have set the to type double. See attached images which will hopefulyl help.

Regards

Ciaran

Re: Using model builder for summary statistics and setting ranges to group by

CiaranHiggins1 — Mon, 25 Mar 2019 11:28:32 GMT

I have got this working now thanks.

I didn't realise the coulmn that is being updated has to be of datatype text/string.

Thanks again

Re: Using model builder for summary statistics and setting ranges to group by

HussainMalik1 — Mon, 01 Feb 2021 18:41:26 GMT

Hi @curtvprice

i know this is an old post but i am doing something similar, but instead of multivalue variable i am using Table of Values variable. and i need to split the variables so that i could use in them for field calculation.

I have posted a question here in communities would love to pick your brains on the topic

Thanks

Hussain