Latest Contributions by BlakeTerhune

You'll have to post a snippet of your code so we can see it in context. ... View more

Although I've not tested it, I heard Compact might clear out erroneous locks. ... View more

Agreed. Or better yet, use it in a with statement so it gets cleaned up even if there's an error before it can del. with arcpy.SearchCursor("roads", '"TYPE" <> 4') as cursor: for row in cursor: print("Name: {0}, CFCC code: {1}".format(row.NAME, row.CFCC)) ... View more

That's a vague question, but generally, Yes. Check out Data-driven styles. Here's a tutorial. If you want to style based on something else, you could look into making a Graphics Layer and applying the symbology however you want. ... View more

What is gp.create_connectionfile()? ... View more

To refresh the data, try switching the table of contents to list by data source, right click on the geodatabase, choose refresh. ... View more

Try configuring the task action where the program/script is your Python env exe "C:\Users\?????\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone1\python.exe" and the optional argument is the path to your Python script file. "C:\Scripts\ProjectName\ScriptName.py" ... View more

Could you confirm what you have in the "Action" tab of the task? Also, is the task running as the same user you're testing with? Here's a reference to check regarding how to set up the task in Windows Task Scheduler. Schedule a Python script or model to run at a prescribed time: 2019 update (esri.com) ... View more

Since there's not really a true boolean value in SQL, people use 1=0 or 1=1. You would use 1=0 in some geoprocessing tools (like feature class to feature class) to copy the table structure without the data. Although you can do the same thing using the template parameter with Create Table or Create Feature Class. In the context of a JS web app, I'm not really sure why you would query where 1=0. I'd have to see it in context. Using 1=1 will return all rows and is common in web apps when querying a feature layer in order to work with all the data. ... View more

@Anonymous User is correct. You need a way to group the points so you can run Near on each group separately. I would suggest a spatial join between the points and polygons so you can get the ObjectID (or some other unique identifier) of the polygon each point belongs to. Then run Near for each group or do Generate Near Table on everything and find the closest in each polygon group. ... View more

Pandas might be an option if you want to work with tabular data without arcpy. Could you tell us all the arcpy functions that are used and maybe we could suggest some alternatives. ... View more

Esri has quite a few sample apps showcasing various parts of the ArcGIS API for Javascript. You don't need NodeJS natively so none of the samples use it. You might be interested in Basic Querying in FeatureLayer.  You'll want to use the "intersects" spatialRelationship property when you query. Here's an example of getting URL parameters to query a feature layer. ... View more

You'd be surprised how many times another person has a similar problem. You just need to know how to search for it. In this case, think of your numbers as strings because each character in a strings are iterable. I wasn't sure if you'll ever have values that are different lengths so I assumed yes. To handle this case, I had to lean on a function in itertools I'd never heard of called zip_longest and applied it to this solution to sum the occurrences where the positional characters are different.   def compare_positional_chars(val1, val2): # Import the required library from itertools import zip_longest # Force the value to string. val1 = str(val1) val2 = str(val2) # Create key/value pairs of positional characters from each input. zip_result = zip_longest(val1, val2) # Count the number of pairs that don't have the same key and value. return sum(1 for x,y in zip_result if x != y) # Call the function in calculate field with your field names to be compared. compare_positional_chars(!Field1!, !Field2!)   ... View more