Latest Contributions by BlakeTerhune

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

Either run the split tool manually in ArcGIS Pro or output the result to a file geodatabase so you can see what it looks like. Compare the fields yourself and see if anything changes and make the field mappings accordingly. Alternatively, use the "NO_TEST" schema_type option for Append: Fields from the input dataset do not need to match the fields of the target dataset. Any fields from the input datasets that do not match the fields of the target dataset will not be mapped to the target dataset unless the mapping is explicitly set in the Field Map parameter. ... View more