Latest Contributions by AndrewWalker1

This warning does not necessarily mean anything is wrong with the model -- it just means certain tools did not run, which is expected in some cases (for example, if you have a selection query for when the user chooses "All locations", and another query for when they choose another value, only one query should run, not both).  ... View more

The "Values" variable contains the value to test against to see if the condition is true or false. You can test against multiple values, but in this case, we just care if the user chose the "ALL COUNTRIES" value or not.  So the string that you type in to this variable should be exactly the same as the one you type in to the parameter properties when you are specifying the values that will appear in the drop-down. You can type your value (for example, "ALL COUNTRIES") directly into the "If Value Is" tool, and it will create this "Values" variable for you (at least it did in my case). ... View more

Hi Chris, Have you looked into a workgroup geodatabase? It sounds like it may be a good fit for your needs. Workgroup geodatabases—Manage data | ArcGIS Enterprise  It relies on an instance of SQL Server Express, which is free. These are the steps for getting that up and running: Set up a database server—Help | ArcGIS Desktop  ... View more

Sure, here is another example that I think is a bit closer to your situation. This model simply selects a country from a polygon layer and calculates summary statistics using the selection: I added a "Country" variable and made it a model parameter. The key thing is then to go into the model properties (right-click the model in the toolbox and click Properties) and enter the values that you want to appear in the pick list. I entered in some country names as well as "ALL COUNTRIES": This creates the pick list when the tool is opened in the Geoprocessing pane: In the model, we can then test whether the user has selected ALL COUNTRIES from the pick list: If True, that means that the user selected "ALL COUNTRIES", and we use the Select by Attribute tool to select all polygons: If False, that means that they selected a country name, and then we use the name of the country in the SQL expression, using the Country variable: Preconditions are used in the model to determine which Select by Attribute tool gets executed. I attached the example toolbox here, hopefully it will be useful. ... View more

If you are manually supplying the values for the pick list using the parameter properties, then you can add a value such as "ALL", for example: and then if the user chooses that option, use a branch of the model to execute a SQL statement that selects all records. For example, this expression would select all sites: You can test whether the user chooses that option with a logical operator, which I see you already have in your model. If you are familiar with Python, you might consider that as another option. Typically I find Python easier to work with when a model starts using lots of conditional logic. ... View more

A little more detail about what your model is doing could be helpful, but one way you could go about this is using a "Logical" operator: to test the input value. If the value equals a value of your choice, representing 'all' (for example "All Sites"), then that branch would use a selection expression that selects all sites.  If not, the expression will select whatever site is selected from the pick list. Here is a very quick example: and then the expression would use the variable if the user selected something other than the "all" value, for example: ... View more

Hi Samantha, This is a little old, but is a good approach to shift features using python: https://arcpy.wordpress.com/2012/11/15/shifting-features/ ... View more