Latest Contributions by LarryAdgate

‎05-23-2019

Thank You, Larry Adgate

‎05-23-2019

I am running Pro Version 2.3.1 and I am trying to set up a Utility Network: I have Installed the ArcGIS Solutions Deployment Tool, Cloned Environments and deployed the Utility Network. Everything seemed to work except the untools will not load. I searched and found it but the install tab will not highlight. See attached Thank you for your help. Larry Adgate Golden State Water Company

‎03-08-2019

Thank You so much, this worked perfectly Larry Adgate

‎03-07-2019

#For arcpy.RebuildIndexes_management, below is a script I copied directly off the ESRI help, and when running it, it errors out. #When researching the error, the folloing tech memo appeared: #https://support.esri.com/en/technical-article/000011553 #Below is my error message: #RebuildIndexes raise e ExecuteError: ERROR 000087: Could not open table Southwest.GSW_SDE.Southwest_Net Failed to execute (RebuildIndexes). #If I use the RebuildIndexes_management tool(red toolbox) in ArcMap it works, but not in a script form..... #I am unclear how to apply the workaround described in the tech memo and I was hopeful someone could help...... #Once again, thank you for you assistance, #Larry Adgate #Golden State Water Company #------------------------------------------------------------------------------------------------------------------------------- import arcpy, os workspace = "Database Connections\\SanDimas@gsw_sde.sde" arcpy.env.workspace = workspace dataList = arcpy.ListTables() + arcpy.ListFeatureClasses() for dataset in arcpy.ListDatasets("", "Feature"): arcpy.env.workspace = os.path.join(workspace,dataset) dataList += arcpy.ListFeatureClasses() + arcpy.ListDatasets() arcpy.env.workspace = workspace userName = arcpy.Describe(workspace).connectionProperties.user.lower() userDataList = [ds for ds in dataList if ds.lower().find(".%s." % userName) > -1] print userDataList arcpy.RebuildIndexes_management(workspace, "NO_SYSTEM", userDataList, "ALL") print('Rebuild Complete')‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎02-19-2019

Robert, This worked great......Thank You Larry

‎02-15-2019

Under management, I have an Enterprise Server with over thirty eight Geodatabases and contained within them, I have over 266 datasets. Reviewing them all manually to determine there status is labor intensive. Is there a method or script available to determine if they are all Register as version or not. A read out of True or False would be perfect. Thank you for your help, Larry Adgate

‎02-13-2019

ArcPro is typically licensed through ArcGisonline. If you do this you will not have problems with the other. Larry

‎02-13-2019

For Census information, try www.census.com Tiger Shape files are also a great resource. Larry

‎11-27-2018

The Maps and Apps Gallery is and continues to be a good application but it has been replaced with Minimal Gallery. ESRI is now replacing good apps this a poor apps. The app thumbnails are way to big in the Minimal Galley but they are perfect in the Map and App Gallery....Please bring back the Maps and Apps Gallery.

‎07-03-2018

I apologize, here is my revised code with corrected indentations.......This script works except when I get to my conditional statement........My goal.....If a featureclass is already unregistered or is not versioned, the script needs to continue to the next featureclass w/o an error import arcpy editDB = "Database Connections\\Arden@gsw_sde.sde" workspace = editDB arcpy.env.workspace = workspace datasets = arcpy.ListDatasets("*", "Feature") print datasets for dataset in datasets: fcList = arcpy.ListFeatureClasses("*","",dataset) for fc in fcList: #My error begins below... if fc == 'Versioned': continue print fc arcpy.UnregisterAsVersioned_management(fc,"NO_KEEP_EDIT","COMPRESS_DEFAULT") arcpy.Compress_management(editDB) Runtime error Traceback (most recent call last): File "<string>", line 16, in <module> File "d:\program files (x86)\arcgis\desktop10.4\arcpy\arcpy\management.py", line 16702, in UnregisterAsVersioned raise e ExecuteError: ERROR 000131: The dataset is not versioned. >>>

‎07-02-2018

I need assistance writing a conditional statement that says if the dataset is already Unregistered to skip the balance and go directly to comp = arcpy.Compress_management(editDB) Thank You in advance........Larry Adgate import arcpy editDB = "Database Connections\\Arden@gsw_sde.sde" workspace = editDB arcpy.env.workspace = workspace #Need a conditonal Statment: if dataset is already UnregisterAsVersioned to go directly to comp datasets = arcpy.ListDatasets("*", "Feature") print datasets for dataset in datasets: fcList = arcpy.ListFeatureClasses("*","",dataset) for fc in fcList: print fc arcpy.UnregisterAsVersioned_management(fc,"NO_KEEP_EDIT","COMPRESS_DEFAULT") #if already Unregistered, skip the balance and go to below: comp = arcpy.Compress_management(editDB) datasets = arcpy.ListDatasets("*", "Feature") for dataset in datasets: fcList = arcpy.ListFeatureClasses("*","",dataset) for fc in fcList: arcpy.RegisterAsVersioned_management(fc, "NO_EDITS_TO_BASE")

‎04-17-2018

Thank You James for your help..............After correcting my workspace using your arcpy.Description() method, the script seemed have issues opening one of the datasets. But after removing the pipeline geometric network, the script worked fine.....Once again thank You

‎04-16-2018

I pulled this script directly off the help section of my ArcGis Desktop software and I'm surprised its giving me problems. For my SQL Server, my objective is to analyze all my feature classes contained in my five datasets but I am getting an error as follows: 'NoneType' object is not iterable Thank You for your assistance...Larry Adgate # Name: AnalyzeDatasets.py # Description: analyzes all datasets in an enterprise geodatabase # for a given user. # Import system modules import arcpy, os # set workspace # the user in this workspace must be the owner of the data to analyze. workspace = "Database Connections\\ArdenArden_gsw_sde_sde" # set the workspace environment arcpy.env.workspace = workspace # NOTE: Analyze Datasets can accept a Python list of datasets. # Get a list of all the datasets the user has access to. dataList = arcpy.ListFeatureClasses() # Next, for feature datasets get all of the datasets and featureclasses # from the list and add them to the master list. #MY Error message is below: TypeError: 'NoneType' object is not iterable for dataset in arcpy.ListDatasets("*", "Feature"): arcpy.env.workspace = os.path.join(workspace,dataset) dataList += arcpy.ListFeatureClasses() + arcpy.ListDatasets() # reset the workspace arcpy.env.workspace = workspace # Get the user name for the workspace userName = arcpy.Describe(workspace).connectionProperties.user.lower() # remove any datasets that are not owned by the connected user. userDataList = [ds for ds in dataList if ds.lower().find(".%s." % userName) > -1] # Execute analyze datasets # Note: to use the "SYSTEM" option the workspace user must be an administrator. arcpy.AnalyzeDatasets_management(workspace, "NO_SYSTEM", userDataList, "ANALYZE_BASE","ANALYZE_DELTA","ANALYZE_ARCHIVE") print "Analyze Complete"

‎04-04-2018

Except for some of the workaround scripting provided to me by ESRI, this script works great on my desktop but not on my SQL Server. From talking with ESRI about this, they are reporting that I am hitting a bug (BUG-000094056). The ESRI quote is as follows: The arcpy.da.Editor class does not properly utilize an edit session to edit feature classes participating in a composite relationship class when the 'with' statement is used. As follows is their suggested workaround: (Unfortunately, I cannot get the work around to work: My ERROR: RuntimeError: cannot open workspace) Explicitly open an edit session and operation: # Start an edit session. Must provide the workspace. edit = arcpy.da.Editor(arcpy.env.workspace) # Start an edit session. edit.startEditing(False,False) # Start an edit operation. edit.startOperation() # Edit the data. (This would be where your update script would go) # Stop the edit operation. edit.stopOperation() # Stop the edit session and save the changes. edit.stopEditing(True) Is there a way to get the workaround to work? Thank You, Larry Adgate import arcpy # Start an edit session. Must provide the workspace. workspace = "arcpy.env.workspace.Database Connections\\TaskmasterServer.sde" edit = arcpy.da.Editor(workspace) # Start an edit session. edit.startEditing(False,False) # Start an edit operation. edit.startOperation() # above is some of the work around stuff and below is my script. newfc = "sde_gsw.GSW_SDE.CCB_Data\\sde_gsw.GSW_SDE.Master_CCB_Points" basefc = "sde_gsw.GSW_SDE.CCB_Data\\sde_gsw.GSW_SDE.CCB_ServiceLines" # empty dictionary dict = {} # read PREM_ID as key and coordinates with arcpy.da.SearchCursor(newfc,['PREM_ID','SHAPE@X','SHAPE@Y']) as cur: for row in cur: dict[row[0]]= {'x':row[1],'y':row[2] } # update old feature with arcpy.da.UpdateCursor(basefc,['PREM_ID','SHAPE@X','SHAPE@Y']) as upCur: for row in upCur: # if PREM_ID is in dictionary, update x,y else skip update if row[0] in dict: row[1] = dict[row[0]]['x'] row[2] = dict[row[0]]['y'] upCur.updateRow(row) print "Updated {}".format(row[0]) #Below is more workaround stuff #Stop the edit operation. edit.stopOperation() #Stop the edit session and save the changes. edit.stopEditing(True)

‎04-02-2018

Hi James thank you for your assistance, If a duplicate PREM_ID is found which is also a duplicate address, it should also go to the same XY as the other duplicate/s. The points will probably stack up in same spot or same xy position.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by LarryAdgate

Re: ArcPro: untools will nor load

ArcPro: untools will nor load

Re: RebuildIndexes_management Error

RebuildIndexes_management Error

Re: Register as versioned-True False

Register as versioned-True False

Re: ArcGIS Desktop not authorized

Re: California Population by ZIP code 2016, 2017, and 2018

Map and Apps Gallery please bring it back

Re: Conditional Statement UnregisterAsVersioned

Conditional Statement UnregisterAsVersioned

Re: AnalyzeDatasets error

AnalyzeDatasets error

Help with BUG-000094056 Workaround

Re: I need to move a set of point features based on the XY values from another feature class

Re: Register as versioned-True False

Map and Apps Gallery please bring it back

Enterprise Server Versioning interfering with Web ...

Re: Referencing a Table to populate a field with m...

Re: Referencing a Table to populate a field with m...