Latest Contributions by BenVan_Kesteren1

ANSWER: I was missing the 'feature_dataset=' from line 14 of my test code. Credit goes to Xander Bakker for the sample code that pointed this out arcpy.ListFeatureClasses(feature_dataset=test_dataset) Hey All,  I have ArcMap installed at version 10.3.1 and I have several automation scripts, and I have recently noticed all my scripts that use arcpy.ListFeatureClasses() fatally error out at that tool.  Is someone else able to confirm they are able to run this without any critical errors? I have just used the below code to test it bare basics, if someone else could please assist by changing the three variables to suit, does it run successfully? import arcpy connection = r"Database Connections\GISADMIN@[email protected]" arcpy.env.workspace = connection test_dataset = r'Database Connections\GISADMIN@[email protected]\SDE_SPATIAL.GISADMIN.Airport' test_feature_within_dataset = r'Database Connections\GISADMIN@[email protected]\SDE_SPATIAL.GISADMIN.Airport\SDE_SPATIAL.GISADMIN.Airport_Lighting_Zones' print arcpy.Exists(test_dataset) print arcpy.Exists(test_feature_within_dataset) print 'It will fail at the next line of code' print arcpy.ListFeatureClasses(test_dataset) print '\n\nTEST COMPLETE'‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I am considering updating my machine to the latest version, but before I take this step I am hoping someone can confirm it doesn't work at this version? Thanks very much for your time. Cheers ... View more

Hey All,  I have a feature class that resides within my SDE, I have added this to an ArcMap document, and created a join to a SQL Query Layer, the Table view looks good, showing field names, not alias. So I then run the Feature Class to Feature Class tool to convert it to a shapefile. I then take a look at the resultant shapefile, and I note that the field names have been exported, not retaining the Alias as viewed within the MXD. What I am wanting is to retain the field alias (or as much as possible with the naming constraints of a shapefile). Any ideas on how I can achieve this? Here is the original Feature Class properties: I think create a join to my SQL Query Layer: I then run Feature Class to Feature Class tool, and this is the name of the output fields: ... View more

Hi All,  Just wondering if there is an easy way in the Query Builder to create a definition Query where the attributes first character starts with X?? Just for an example, in the below screenshot how would one create a query to return all features where the Feature_Type starts with the letter 'Y'?? At this stage it would only show YARRAMBA CRES. and YARRUNGA. I was thinking something like using LEFT(FEATURE_TYPE,1) = 'Y' but this is invalid, I am assuming there is some other easy way that I cannot think of at 5pm in the afternoon! #sql‌ #definition query.‌ Any suggestions?   ... View more

Hey All,  I have an Enterprise GDB that has a feature class of our Road network (polylines). One of the fields within this Feature Class is 'Road Name', this has a domain applied to it so as end users cannot misspell road names when entering them. The bottleneck with this setup is that each time a new road is constructed in our Local Government Area the end users has to email me the road name, then I manually enter it into the domain myself. This can be a delay for the end user and is not ideal.  My ideal scenario would be a toolbox tool that I can create so the end user can open it, and simply enter a road name and click run, and the road name will be added to the domain for them to use.  I have no idea how to even start something like this, has anyone else got a similar setup with a solution I could apply? Cheers ... View more

Hi All,  I am employed as GIS Administrator here in our Local Government office. Recently our permissions within the server have been reviewed and due to company policy the "Processadmin" role and the "CREATE FUNCTION", "CREATE PROCEDURE", "CREATE TABLE", and "CREATE VIEW" permissions also removed as it is a company security risk. I have been asked to provide reasoning as to why I should have these permissions.  The only thing I can think of is for disconnecting users, are there other reasons I am not thinking of?   The majority of my work is being done as the Data Owner, this has been unaffected and still works fine. Any suggestions or comments are greatly appreciated. Cheers ... View more

Hi All,  I have three different levels of database connection in ArcCatalog on my PC which I use to connect to our Enterprise GDB for various reasons. I have my user level connection for data editing. I have one called GISADMIN which is the Data Owner.  And another with is called SDE which is the Geodatabase Admin User. I have no access to the Database Admin User, this is managed by our in house I.T Dept. I am trying to use the arcpy.DisconnectUser function in a python script, but no matter which of the connections mentioned above I use, I get the following error: >>> arcpy.DisconnectUser(r'Database Connections\SDE@[email protected]',123494) Runtime error Traceback (most recent call last):   File "<string>", line 1, in <module>   File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\__init__.py", line 1086, in DisconnectUser     return gp.disconnectUser(sde_workspace, users)   File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\geoprocessing\_base.py", line 504, in <lambda>     return lambda *args: val(*gp_fixargs(args, True)) RuntimeError: Unable to disconnect: The connection ID provided is for the current administrator connection >>> ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I have confirmed this by trying to use all three connections, also trying to disconnect several different connections from my Enterprise GDB. Something strange is that if I put a completely random session ID in my python snippet, the exact same error is returned.... I am perplexed as to why this is happening to me, and I am unable to track down why this seems to have started happening all of a sudden.  Anyone have any troubleshooting ideas for me?   Nathan Duncan‌ Cheers -Ben ... View more