topic Re: How to set range in arcgis model builder in ModelBuilder Questions

How to set range in arcgis model builder

AyokunleAdebisi1 — Thu, 16 Jan 2020 18:18:33 GMT

I am builder model that users will be able to select values of year in range i.e 5 or 10years interval. The Year picklist will look like this in the tool. How can I do this in ArcGIS model builder ?

Re: How to set range in arcgis model builder

curtvprice — Fri, 17 Jan 2020 13:24:15 GMT

You could create a text string variable, set it as a parameter, and in the Model Options parameters, use a filter to create the list of choices.

Then use the Calculate Value tool to convert that string to a SQL expression, like this:

"YEAR >= {} AND YEAR <= {}".format("%Year Range%"[0:4], "%Year Range%"[5:])‍‍

The above expression would yield for your first choice "1967-1971":

YEAR >= 1967 AND YEAR <= 1971‍‍

Re: How to set range in arcgis model builder

AyokunleAdebisi1 — Sun, 12 Dec 2021 10:32:22 GMT

Thanks for your reply @Curtis Price I did as you instructed and it worked, but however i did same for Months in the year i.e instead of using YEAR, I use MONTH

MONTH >= JANUARY AND MONTH <= APRIL

But it shows empty output, what could be wrong? or it can only be used for numeric but not text or what could be the issue?

Re: How to set range in arcgis model builder

AyokunleAdebisi — Sun, 02 Feb 2020 20:53:48 GMT

I think it is working but it selects alphabetically i.e if I select from April it will select all values of month from A-S, but if I select from January to April, it returns null because J does come before A.. how can i solve this to make it select January to April or September to December to return a value.

Re: How to set range in arcgis model builder

DavidPike — Sun, 02 Feb 2020 21:01:46 GMT

A value list filter for the parameter?

Re: How to set range in arcgis model builder

AyokunleAdebisi — Sun, 02 Feb 2020 21:12:17 GMT

if i understand your question...Yes

Re: How to set range in arcgis model builder

DavidPike — Sun, 02 Feb 2020 21:35:17 GMT

Filter—ArcPy classes | ArcGIS Desktop

Re: How to set range in arcgis model builder

AyokunleAdebisi — Sun, 02 Feb 2020 21:57:35 GMT

I am not well skilled in python...it would be best to it in modelbuilder if possible..Thanks

Re: How to set range in arcgis model builder

AyokunleAdebisi — Mon, 03 Feb 2020 08:14:45 GMT

Thanks.

Re: How to set range in arcgis model builder

AyokunleAdebisi — Mon, 03 Feb 2020 11:23:36 GMT

I think it is working but it selects alphabetically i.e if I select from April it will select all values of month from A-S, but if I select from January to April, it returns null because J does not come before A.. how can i solve this to make it select January to April or September to December to return a value.@Curtis Price .