POST
|
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
... View more
05-23-2019
01:11 PM
|
0
|
2
|
573
|
POST
|
Thank You so much, this worked perfectly Larry Adgate
... View more
03-08-2019
01:55 PM
|
0
|
0
|
1032
|
POST
|
#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')
... View more
03-07-2019
11:13 AM
|
0
|
2
|
1166
|
POST
|
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
... View more
02-15-2019
03:22 PM
|
0
|
2
|
598
|
POST
|
ArcPro is typically licensed through ArcGisonline. If you do this you will not have problems with the other. Larry
... View more
02-13-2019
12:38 PM
|
0
|
0
|
603
|
POST
|
For Census information, try www.census.com Tiger Shape files are also a great resource. Larry
... View more
02-13-2019
12:20 PM
|
0
|
0
|
318
|
IDEA
|
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.
... View more
11-27-2018
10:53 AM
|
2
|
0
|
232
|
POST
|
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. >>>
... View more
07-03-2018
08:55 AM
|
0
|
1
|
995
|
POST
|
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")
... View more
07-02-2018
01:59 PM
|
0
|
4
|
1112
|
POST
|
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
... View more
04-17-2018
07:56 AM
|
0
|
0
|
799
|
POST
|
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"
... View more
04-16-2018
02:37 PM
|
0
|
2
|
1219
|
POST
|
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)
... View more
04-04-2018
02:43 PM
|
0
|
1
|
451
|
POST
|
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.
... View more
04-02-2018
02:50 PM
|
0
|
0
|
526
|
Title | Kudos | Posted |
---|---|---|
1 | 02-19-2019 09:17 AM | |
2 | 11-27-2018 10:53 AM | |
1 | 06-16-2017 10:48 AM | |
1 | 06-06-2017 11:26 AM | |
1 | 06-05-2017 02:03 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|