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 ?
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 .
Thanks.
I am not well skilled in python...it would be best to it in modelbuilder if possible..Thanks
Filter—ArcPy classes | ArcGIS Desktop
if i understand your question...Yes
A value list filter for the parameter?
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.
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
<SPAN style="border: 0px; color: #000000; background: rgba(255, 255, 255, 0.5); font-weight: inherit; font-size: 14px; ">MONTH </SPAN><SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit; font-size: 14px;">>=</SPAN><SPAN style="background-color: #f5f2f0;"><SPAN style="color: #000000;"> </SPAN><SPAN style="color: #990000;">JANUARY</SPAN></SPAN><SPAN style="background-color: #f5f2f0; color: #000000; "> </SPAN><SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit; font-size: 14px;">AND</SPAN><SPAN style="background-color: #f5f2f0; color: #000000; "> MONTH </SPAN><SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit; font-size: 14px;"><=</SPAN><SPAN style="background-color: #f5f2f0;"><SPAN style="color: #000000;"> </SPAN><SPAN style="color: #990000;">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?</SPAN></SPAN>
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:
<SPAN class="string token">"YEAR >= {} AND YEAR <= {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"%Year Range%"</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"%Year Range%"</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN></SPAN>
The above expression would yield for your first choice "1967-1971":
YEAR <SPAN class="operator token">>=</SPAN> <SPAN class="number token">1967</SPAN> <SPAN class="operator token">AND</SPAN> YEAR <SPAN class="operator token"><=</SPAN> <SPAN class="number token">1971</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN></SPAN>
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
