Latest Contributions by BlakeTerhune

Additionally, field names cannot begin with a number. ... View more

So you've got what sounds like a Near Table (no matter how it was created) and want to just grab the nearest n destinations for each OID? See if something like this works. Feels a little clunky with the conditionals but it was the easiest solution that came to mind. num_results = 3  ## set to how many SID matches you want for each OID # Create output table with no rows arcpy.TableToTable_conversion(inTable, outLocation, outTable, "1=0") fields = ["OID","SID","Distance"] with arcpy.da.SearchCursor(inTable, fields, sql_clause=(None, 'ORDER BY OID, DISTANCE')) as s_cursor:     with arcpy.da.InsertCursor(outTable, fields) as i_cursor:         oid_track = None         oid_count = 1         for oid, sid, dist in s_cursor:             if oid == oid_track:                 if oid_count <= num_results:                     oid_count += 1                     # write to outTable                     i_cursor.insertRow((oid, sid, dist))             else:                 oid_count = 1                 oid_track = oid                 # write to outTable                 i_cursor.insertRow((oid, sid, dist))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ If that's still too slow, we can look at trying to improve performance with dictionaries. ... View more

Could you step back and clarify what the source tables look like? Ignore any intermediate table work your script is doing. ... View more

It means that the main goal of the PEP 468 "Preserving the order of **kwargs in a function" is now implemented in Python 3.6 Interesting... ... View more

Also, the sorted() method will sort dictionaries by their key value (unless otherwise specified with the key parameter). EDIT: I see you're using a dictionary but not actually assigning anything to the value. In other words, you just need a list. Or in this case, a tuple would work because it's immutable and preserves the order items were inserted. Try something like BIDList = tuple(BID for BID, SID, Dist in in cursor)‍ ... View more

As you found, dictionaries (and lists) do not preserve the order of items added. However, there is an OrderedDict in the collections module that will maintain the order of items. However, instead of trying to do the distance checking manually, Near or Generate Near Table might suit your needs better. ... View more

https://community.esri.com/docs/DOC-2159  ... View more

You posted in the GeoNet Help community but it should probably be in Managing Data‌ or https://community.esri.com/community/gis/analysis/spatial-analyst?sr=search&searchId=c6738220-e61e-4e3f-9c7e-502f2a96a3b1&searchIndex=3‌ ... View more

Since this discussion was created in 2011, ListDomains—Help | ArcGIS Desktop is probably the best way to get this information in 2017 using Python. ... View more

When using an if statement, you probably have to use the field calculator code block option. You also mixed up the field name syntax between VB and Python. code block: def compareCalc(col1, col3):     if col1 == col3:        return 'yes'     else:        return 'no'‍‍‍‍‍‍‍‍‍‍ expression: compareCalc(!column1!, !column3!)‍‍ ... View more

In the future, try Posting code with Syntax Highlighting on GeoNet. Makes code easier to read and copy. ... View more

In addition to the ArcREST scripts, I also found the ArcGIS Server Administration Toolkit - 10.1+ helpful; although the code on GitHub is probably more up to date. ... View more

Try https://community.esri.com/thread/78692  ... View more

We added some fancy formatting to the email sent out by all of our Python scripts running as scheduled tasks. # Opening lines of email message body msg = "{scriptName} ran on {hostComputer}".format(     scriptName = os.path.basename(__file__),     hostComputer = socket.gethostname() ) istring = " Started {} ".format(datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")) msg += "\n\n{:~^64}\n\n".format(istring)‍‍‍‍‍‍‍‍‍‍‍‍‍‍  This creates the msg string which becomes the email body. The first two lines of the email always looks like this... SomeScriptFileName.py ran on ServerName123 ~~~~~~~~~~~~~~~~~ Started 2017-06-19 04:30:03 ~~~~~~~~~~~~~~~~~~‍‍‍‍‍‍ There's a similar line at the end of the email too. ... View more

Yes, I see it now, thanks. I'll update my code. ... View more