Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About LarryAdgate
LarryAdgate
Occasional Contributor
since
07-04-2014
11-11-2020
88
Posts created
24
Kudos given
1
Solutions
7
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(1 Idea Submissions)Latest Contributions by LarryAdgate
|
POST
|
We are a large Water Utility Company with 38 Enterprise Geodatabases and most of them employ a versioning setup. As A workflow, I am considering the use of a Python Script to automate the Reconcile and posting process. Can someone share with me there experience using this kind of workflow and is there a down side.
... View more
05-11-2017
04:29 PM
|
0
|
24
|
6165
|
|
POST
|
Hi Joshua, Thank You for your help on this issue, but this project has evolved into something much bigger. We are a water utility Company with hundreds of miles of pipeline, valves and various equipment. For water quality purposes, I have been asked to provide a total inventory of everything and that includes pipeline sizes & lengths and the various types of valves and equipment. Unfortunately not all our GIS fields are numeric but are text. As a solution, I could merge similar feature classes into one big feature class but this could be labor intensive. Your thoughts Please. Larry
... View more
04-27-2017
08:03 AM
|
0
|
1
|
1268
|
|
POST
|
Thanks You, I getting a lot of very good Ideas how to make this happen, Larry Adgate
... View more
04-25-2017
02:42 PM
|
0
|
0
|
1268
|
|
POST
|
I have 38 line Feature Classes located on my Enterprise Server. Without merging the files into one Feature Class, is there a way to discover the grand total of all line lengths in all 38 Feature Classes.
... View more
04-25-2017
12:52 PM
|
0
|
7
|
2355
|
|
POST
|
The following script is giving me an error message. Any ideas how to make it work and what questions I should I ask myself in the future to remedy the error. import arcpy fc="C:/Projects/PythonTesting/GoingPlaces.dbf" with arcpy.da.SearchCursor(fc, ["STREETNAME"]) as Cursor: for row in cursor: print "STREETNAME = {0}".formate(row[0]) Runtime error Traceback (most recent call last): File "<string>", line 7, in <module> NameError: name 'cursor' is not defined
... View more
04-17-2017
10:23 AM
|
0
|
3
|
13509
|
|
POST
|
I have 38 Published Web applications and they all have very active Redline Edit Widgets. When a user of the Widget makes an edit, how can I be notified an edit has been made. Monitoring 38 redline features classes for edits is no fun. Any Ideas how to make this better. Thank You, Larry Adgate
... View more
03-28-2017
07:41 AM
|
0
|
1
|
828
|
|
POST
|
I need to run a batch script during the night when no one is in the office-What is the best method to do this
... View more
03-24-2017
09:17 AM
|
0
|
2
|
1911
|
|
POST
|
Thanks Christain, this is what I finally ended up with and it worked. Can you please tell me about the Forward slash in the workspace and what this operator is doing? its not division Thanks Once again, Larry workspaces = ["Database Connections/Arden@gsw_sde.sde", "Database Connections/BayPoint@gws_.sde.sde"] for sde in workspaces: arcpy.env.workspace = sde userList = arcpy.ListUsers(sde) for user in userList: print("Username: {0}, Connected at: {1}".format(user.Name, user.ConnectionTime))
... View more
06-09-2016
03:40 PM
|
0
|
1
|
513
|
|
POST
|
Hi Christian-Thanks for you help on this. I'm getting a very Strange Syntax Error just below the print Command. Any thoughts? workspaces = ["Arden.sde", "BayPoint.sde"] for sde in workspaces: arcpy.env.workspace = sde userList = arcpy.ListUsers(sde) for user in userList: print("Username: {0}, Connected at: {1}".format(user.Name, user.ConnectionTime)
... View more
06-09-2016
11:26 AM
|
0
|
3
|
513
|
|
POST
|
For our Enterprise Server Geodatabases, the ListUser function works well when using only one Geodatabase, but when looping through two or more Geodatabases is where I need some assistance. My Script Error: ValueError: Not a valid SDE workspace. import arcpy #Local Variables: I need to loop through two or More Enterprise Server Geodatabases fc="Arden@gsw_sde.sde", "CowanHeights@gsw_sde.sde" arcpy.env.workspace = "Database Connections/fc" workspace = arcpy.env.workspace # get a list of connected users. userList = arcpy.ListUsers("Database Connections/fc") for user in users: print("Username: {0}, Connected at: {1}".format(user.Name, user.ConnectionTime))
... View more
06-09-2016
09:54 AM
|
0
|
5
|
3007
|
|
POST
|
For our water Company, we have a number of consultants working a long side us on our Enterprise Server. We have aprox. forty five Geodatabases and too often I have Schema lock on two to three of them and my python Scripts error out. Is there a Python Script that I can run to determine what Geodatabases are Locked?
... View more
06-02-2016
11:25 AM
|
0
|
0
|
1377
|
|
POST
|
This label expression below works along with a relationship class attachment linked to a line feature class. It only works great when the Domain setup for the Field "DIAMETER" does not include an inch the character. My domain for "DIAMETER" currently reads: 2,3,4&6 but it needs to be corrected to read 2",3"4" & 6". When applying the inch character(") to the domain the script errors. Can someone help me with this? Thanks, Larry Function FindLabel ( [DIAMETER] , [LINETYPE] ) FindLabel = "" if [DIAMETER] AND [LINETYPE] = "Fire Service" then FindLabel = [DIAMETER] & "" & "FS" end if if [DIAMETER] AND [LINETYPE] = "Domestic" then if FindLabel = "" then FindLabel = [DIAMETER] & "" & "DS" end if end if if [DIAMETER] AND [LINETYPE] = "Irrigation" then if FindLabel = "" then FindLabel = [DIAMETER] & "" & "IRR" end if end if if [DIAMETER] AND [LINETYPE] = "Air Valve" then if FindLabel = "" then FindLabel = [DIAMETER] & "" & "AV" end if end if if [DIAMETER] AND [LINETYPE] = "Sampling Station" then if FindLabel = "" then FindLabel = [DIAMETER] & "" & "SS" end if end if End Function
... View more
11-24-2015
11:29 AM
|
0
|
1
|
2848
|
My kudoed posts
| 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 |
Activity Feed
- Posted Re: ArcPro: untools will nor load on Python Questions. 05-23-2019 02:23 PM
- Posted ArcPro: untools will nor load on Python Questions. 05-23-2019 01:11 PM
- Posted Re: RebuildIndexes_management Error on Python Questions. 03-08-2019 01:55 PM
- Kudoed Re: RebuildIndexes_management Error for RhettZufelt. 03-08-2019 01:55 PM
- Posted RebuildIndexes_management Error on Python Questions. 03-07-2019 11:13 AM
- Got a Kudo for Re: Register as versioned-True False. 02-19-2019 09:29 AM
- Kudoed Re: Register as versioned-True False for Robert_LeClair. 02-19-2019 09:18 AM
- Posted Re: Register as versioned-True False on Python Questions. 02-19-2019 09:17 AM
- Posted Register as versioned-True False on Python Questions. 02-15-2019 03:22 PM
- Posted Re: ArcGIS Desktop not authorized on ArcMap Questions. 02-13-2019 12:38 PM
- Posted Re: California Population by ZIP code 2016, 2017, and 2018 on Addressing Questions. 02-13-2019 12:20 PM
- Got a Kudo for Map and Apps Gallery please bring it back. 11-28-2018 07:13 AM
- Kudoed Map and Apps Gallery please bring it back for LarryAdgate. 11-27-2018 03:26 PM
- Got a Kudo for Map and Apps Gallery please bring it back. 11-27-2018 03:26 PM
- Posted Map and Apps Gallery please bring it back on ArcGIS Online Ideas. 11-27-2018 10:53 AM
- Kudoed Re: Conditional Statement UnregisterAsVersioned for JoeBorgione. 07-03-2018 11:38 AM
- Posted Re: Conditional Statement UnregisterAsVersioned on Python Questions. 07-03-2018 08:55 AM
- Posted Conditional Statement UnregisterAsVersioned on Python Questions. 07-02-2018 01:59 PM
- Kudoed Re: AnalyzeDatasets error for JamesMacKay3. 04-17-2018 07:57 AM
- Posted Re: AnalyzeDatasets error on Python Questions. 04-17-2018 07:56 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:23 AM
|