Latest Contributions by BlakeTerhune

There's some good advice in this poll. ... View more

At first you mentioned you want the results in a shapefile but now you're saying you want a "list." If some kind of printed report is really what you're after, you could try this: import arcpy inputTable = r"C:\temp\myworking.gdb\mytablename" fields = ["ID","OWNER"] uniqueID = {} with arcpy.da.SearchCursor(inputTable, fields) as s_cursor:     for row in s_cursor:         # Underscore in front of variable names only because "id" is a Python reserved word         _id = row[0]         _owner = row[1]         uniqueID.setdefault(_id, []).append(_owner) for _id, _owners in uniqueID.items():     print _id, _owners It uses an arcpy data access search cursor to read through your data table one row at a time. With each row, it loads the ID and owner into a dictionary (like Geoff Olson mentioned below). However, as each row is loaded, the dictionary setdefault method checks to see if that ID has already been loaded. If it has not, it will create a new dictionary key for that ID and an empty list for the dictionary value. The list append method is the one that actually adds the owner to the list. You're left with a dictionary that has keys of only unique IDs and values as a list of owners. It just prints the results to the Python interpreter window. You could also write the data to a CSV or a new feature class or shapefile. Here's the credit for the logic I used to populate the dictionary. ... View more

So what would happen if the same ID had five different owners? Or ten different owners? You'll just have to keep increasing the number of columns to accommodate the most duplicated ID. Sounds like these are not duplicates but rather you have two key fields. I wouldn't try making extra columns for the additional owners because it will get messy. Is there some kind of dependency requiring you to format your data like this? In your example, do each of the three objects also have different geometry/location? If the geometry is the same, maybe you could consider using a related table so you can have one object with one ID related to an owner table that has three records with the same ID and each different owner. ... View more

You may be right, possibly something with my version of Python and the place I'm running it from. I'm not sure how to run it from Windows Command Prompt so I just tried it in IDLE and still get the same error. Here's how I'm running it import arcpy try:     sdeconn = r"C:\GISConnections\SDE@GTEST.sde"     sql = "SELECT * FROM INVALID_TABLE"     cnxn = arcpy.ArcSDESQLExecute(sdeconn)     sqlresult = cnxn.execute(sql)     for i in sqlresult:         print i except Exception as err:     print unicode(err.message).encode("utf-8")  ## Successfully prints Esri error message     print err  ## Throws Python error finally:     # Cleanup     if 'cnxn' in locals():         del cnxn Thanks for your persistence, Joshua. At least I know how to handle the error for now. I'll just hope it will go away after the next ArcGIS upgrade we do. ... View more

I did some quick testing here and I confirmed what Luke found: running the with statement in a function removes the locks while running it alone (outside a function) leaves the locks. However, if you run the with statement outside of a function, the locks only remain until you close the IDE (I was using PyScripter). Same thing if you just run the .py file with python.exe, the locks are removed when the script has finished running. ... View more

UPDATE: I am on Win7 64-bit with ArcGIS 10.2.2 using PyScripter for Python 2.7. I can confirm that running the with statement inside of a function like this will remove the locks in a file geodatabase when done (did not test shapefile). import arcpy def main():     fc = r"C:\TestData\TEMP.gdb\TEMP_FC"     fields = ["*"]     with arcpy.da.SearchCursor(fc, fields) as cursor:         for row in cursor:             print(row) if __name__ == '__main__':     main() If you run the with statement outside of a function, the locks remain after the script has completed. I even tried using arcpy.ClearWorkspaceCache_management() import arcpy fc = r"C:\TestData\TEMP.gdb\TEMP_FC"  fields = ["*"]  with arcpy.da.SearchCursor(fc, fields) as cursor:      for row in cursor:          print(row) However, I also noticed that the locks go away once you close PyScripter! Same thing happens if you just run the .py file with python.exe, the locks go away when the script is finished running. So this is really only an issue when running code inside if the IDE. Either way, it's probably good practice to have your code in a function anyway. ... View more

I was intrigued by your post and stumbled across this thread. In it, Lucas Danzinger of Esri found that if the with statement was run inside a function that the locks were released correctly. He also logged this under Bug NIM-089529. Re: Python WITH statement does not release da cursor schema locks I have not tested this yet. ... View more

This Python document mentions the issue of printing Exceptions with unicode characters but it's just generically directed at Python 2.x ... View more

I'm using PyScripter for Python 2.7 with ArcGIS 10.2.2 (which I believe ships with Python 2.7.5). ... View more

Thank you Joshua, I appreciate your reply. I'll try running SDEMON from the Windows Server like you suggested. We will continue testing and I'll post back if there are any significant developments. ... View more

It installs with a different shortcut for each Python version. Do we need to make sure we are running the PyScripter for Python 2.7 so it's "compatible" with ArcGIS? I seem to remember something about this being the case. ... View more

When working with dictionaries, I found it helpful to iterate the items rather than the generic dictionary so you can name the key and value to be more readable. import arcpy import os  # Environment variables sourceGDB = r"C:\temp\source\source.gdb" outputGDB = r"C:\temp\output\output.gdb"  # Feature classes dictionary ## Key is destination feature class name (out_lyr) ## Value is source feature class name (in_lyr) layers = {     'myOutputPoints': 'sourcePoints',     'myOutputLines': 'sourceLines',     'myOutputPolys': 'sourcePolys', }  ## End layers  # Export feature classes in dictionary for out_lyr, in_lyr in layers.items():     arcpy.CopyFeatures_management(         os.path.join(sourceGDB, in_lyr),         os.path.join(outputGDB, out_lyr)     )     print "{} copied".format(out_yr)     # write geoprocessing warning messages     if arcpy.GetMessages(1):         print arcpy.GetMessages(1)  I also like to use arcpy.ClearWorkspaceCache_management() to cleanup all my scripts with that connect to SDE. ... View more