Latest Contributions by curtvprice

Chris is right, your syntax is messing things up. The error message is because python is not recognizing your variables as raster layers but just as garden-variety strings. To get this to work, you must rename your model element names to remove the percent symbols (right click / rename). They were automatically named that way as you were creating them, I know, but ModelBuilder gets very confused  when percents are used in the model element names, since model variables are used as model element names surrounded by percent symbols. Then, in Raster Calculator, you can make a more sane expression using the raster layers listed in the upper left corner -- something like: Con( (("value_be2" == 0) & ("value_hh" == 0) & ("value_no" == 1)) |     (("value_no" == 1) & ("value_be" == 1) & ("value_hh" == 1)), 1, 0) I can simplify your expression, too: Con( "value_no" == 1 &      ((("value_be2" == 0) & ("value_hh" == 0)) |     (("value_be" == 1) & ("value_hh" == 1))), 1, 0) ... View more

For performance reasons, it would make more sense to tag the places with the County beforehand, you don't want to do significant geoprocessing while a user is staring at the dialog box -- a delay of even a second is a long time in that situation. Here's an example of how this would work. The code below assumes: Parameter 0 is the county polygon with fields CNAME and CCODE Parameter 1 is the place points with fields PNAME and CCODE Parameter 2 is the county name (picklist) Parameter 3 is the place name (picklist) This code is untested! For guidance, see the help article "Programming a Tool Validator Class". def updateParameters():   if self.params[0].value:     # get dict of county names and codes     counties = {}     rows = arcpy.SearchCursor(self.params[0].value,"","","CNAME;CCODE")     for row in rows:       nm = row.getValue("CNAME")       cd = row.getValue("CCODE")           counties[nm] = cd     del row, rows     # set up picklist (filter) of county names     cnames = counties.keys()     self.param[2].filter.list = sorted(cnames)   # set up picklist of place names for this county   if self.params[1].value and self.params[2].value:     county_code = counties[self.params[2].value]     where = "CCODE = {0}".format(county_code)     rows = arcpy.SearchCursor(self.params[1].value,"",where,"PNAME;CCODE")     pnames = []     for row in rows:       pnames.append(row.getValue("PNAME"))     del row, rows     pnames = sorted(set(pnames)) # uniqueize and sort     self.params[3].filter.list = pnames ... View more

what if you want to do it without an sde database connection? say I am setting this up to be activated from arcpad instead I think what Emad was getting at is if you drag and drop, the proper syntax will appear in your code. You can then use that code in your ArcPad app, or use that code as a template to build an appropriate connection string for a different user/database etc. Another approach that I have found handy with difficult syntaxes is to do the operation using a tool interactively in ArcGIS Desktop (for example, run the Create Database Connection tool, taking advantage of the help and validation [parameter checks] in the tool interactive interface), and then copy python snippets from the Results window (right click > Copy Python Snippet). This approach can save you hours of frustration! ... View more