Latest Contributions by EddyClark

‎01-14-2020

Currently going through the Mapping Workbooks storymap. I've noticed domains in my AssetPackage titled Electric_Light_Watts and Electric_Low_Voltage_Street_Bulb_Type but I don't see which tables/fields these domains are assigned. I'm guessing I'm supposed to add fields to the ElectricDevice feature class and assign these domains. Is that right?

‎12-18-2019

Using Model Builder because tracing a geometric network in python is a pain. I have three feature classes (Switch, Fuse, Breaker) that all contain the field name [FacilityID]. None of the rows contain duplicate FacilityID values throughout all three feature classes. I want users to be able to enter a parameter value (i.e. S1234) and have model builder check if the row exists before going through the rest of the model. If the [FacilityID] = 'S1234' does not exist in the Fuse feature class, do nothing. If [FacilityID] = 'S1234' exists in the Switch feature class, proceed with the rest of the model.

‎12-10-2019

I'm using model builder because tracing a geometric network on python is a pain. In my last Tool (Copy Features) the original model copies the Input data to SDE. However when used in a Geoprocessing Service it processes the Copy into the Scratch.gdb. How do I get it to Copy Features to SDE like the original model? Here is the message.xml from the server <MessageDesc>Executing (Copy Features (2)): CopyFeatures c:\arcgisserver\directories\arcgisjobs\outage\traceswitchoutage_gpserver\j920ae311f6df4a89a8f4fcca52ce96a4\scratch\GDBO_Buffer_Dissolve.shp c:\arcgisserver\directories\arcgisjobs\outage\traceswitchoutage_gpserver\j920ae311f6df4a89a8f4fcca52ce96a4\scratch\scratch.gdb\PubPow.GDBO.SwitchOutage # 0 0 0</MessageDesc></GPMessage>‍‍ Here is a snapshot of the model, with the last tool (Copy Features (2)) open.

‎09-18-2019

Also, can you tell me if there is any sample data I can study?

‎09-17-2019

Thanks John. Can you point me to the other migration tools and methods?

‎09-17-2019

I found this text in the UN Migration Tools Documentation: "Related records should be consistently managed; for example, if a fuse point on an electric network is protecting all three phases, the related record should have three-unit records, one for each phase. It should not be also represented as one-unit record with all three phases." Is there an easy way to triple the amount of related records that I already have? Should the FuseUnit table specify which phase each unit is protecting? i.e. [Phase] = B

‎05-24-2019

‎05-24-2019

iPad Air 2 & iPhone X

‎05-23-2019

Does the barcode scanner have a character limit? I have two barcodes, both Code_39, one with eight characters (plus * on both sides), and one with 22 characters (plus *). The 22 character code won't scan.

‎12-11-2018

OK - sorry to be such a pest. Your code as written is gold. I got this to work by adding a [FourthFailure] field. There was ONE inspection that failed four inspections. Thanks again Joshua Bixby‌ and Randy Burton‌ for so much help.

‎12-11-2018

Thanks to both of you. When I do change that line to == "FAIL", I get the error: Traceback (most recent call last): File "C:\....py", line XX, in <module> row[len(flds) + 1 + i] = v IndexError: list assignment index out of range‍‍‍‍‍‍‍‍‍‍‍‍

‎12-10-2018

Thanks again Bixby. I'm already indebted to you and can hardly imagine you take this another step further. That being said, I'll share that the script completed without error but the results are not as desired.

‎12-10-2018

Thanks Bix. I wish I knew enough to debug why this isn't working for me. Does this pass through if a cmmon_fld doesn't exist? For example if "UGI_BarrierNeeded" didn't exist in the Capacitor feature class, would it just go on to the next or fail? I cannot get past line 32 in your example. I'm getting error: "A column was specified that does not exist." I put some print statements to help me get down to the bottom but I'm still clueless. print("begin meat") for fc in fc_list: for fld in new_flds: arcpy.AddField_management(fc, **fld) with arcpy.da.UpdateCursor(fc,common_flds + [fld["field_name"] for fld in new_flds]) as cur: print ("cur defined") print (str(fld)) print (str(new_flds)) for row in cur: print("begin row in cur")‍‍‍‍‍‍‍‍‍‍‍‍ Here are the print results: begin meat cur defined {'field_type': 'TEXT', 'field_name': 'ThirdFailure', 'field_length': 40} [{'field_type': 'TEXT', 'field_name': 'From_FC_Name', 'field_length': 20}, {'field_type': 'TEXT', 'field_name': 'FirstFailure', 'field_length': 40}, {'field_type': 'TEXT', 'field_name': 'SecondFailure', 'field_length': 40}, {'field_type': 'TEXT', 'field_name': 'ThirdFailure', 'field_length': 40}] Traceback (most recent call last): File "C:\Users\..........py", line XX, in <module> for row in cur: RuntimeError: A column was specified that does not exist.

‎12-08-2018

Thanks for your reply and sorry for the confusion. I'm new to python and scripting in general. Line #25 I did butcher for this post. Yes, my screenshot is showing common columns in the 16 feature classes. All 16 feature classes get inspected for all the same things - we just keep them separated because they're different features (Poles vs. Transformers vs. Capacitors, etc). My thought is that the "MergedFeatureClass" will have an additional 3-4 fields, on top of [From_FC_Name]. Those 3-4 additional fields would be named [FirstFailure], [SecondFailure], [ThirdFailure], etc. Rarely does an inspection have more than one fail. So if CapacitorFeatureClass fails in the [UGI_GraffitiRemoval] column then I want the row under MergedFeatureClass' [FirstFailure] column to contain the attribute of "UGI_GraffitiRemoval". If Capacitor fails UGI_GraffitiRemoval and UGI_BarrierNeeded, then [FirstFailure] and [SecondFailure] would get populated with the respective column name.

‎12-07-2018

I have sixteen different feature classes that mostly have the same fields that share the same domain (Pass/Fail). I want to create a script that (1) creates a new FC bringing these all together, New_Feature_Class field examples: [FirstFailure], [SecondFailure], and [ThirdFailure]. then (2) populates rows with Field Name IF [Field] = Fail. If a row from one of the original 16 feature classes have no fields with a 'Fail', then none of the new [Failure] fields would get populated. I've created the first part (below), I just can't even imagine how the second part happens. import arcpy from arcpy import * import os arcpy.env.overwriteOutput = True database = "C:\\etc" arcpy.env.workspace = database fc_list = arcpy.ListFeatureClasses() for fc in fc_list: fieldname = "From_FC_Name" arcpy.AddField_management(fc, fieldname, "TEXT", field_length = 20) with arcpy.da.UpdateCursor(fc, fieldname) as cursor: for row in cursor: if row[0] == None: row[0] = str(fc) cursor.updateRow(row) arcpy.ClearEnvironment("workspace") final_fc = "path" arcpy.CreateFeatureclass_management(final_fc) arcpy.Append_management(fclist2, final_fc) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Online Status	Offline
Date Last Visited	‎10-29-2025 08:39 AM

My Ideas

Latest Contributions by EddyClark

Electric Utility Network - Streetlight Domains

If Exists in Model Builder

Geoprocessing Service Scratch.gdb to SDE

Re: Handling Related Records for UN Migration

Re: Handling Related Records for UN Migration

Handling Related Records for UN Migration

Re: Understanding Barcode Questions in Survey123 for ArcGIS

Re: Understanding Barcode Questions in Survey123 for ArcGIS

Re: Understanding Barcode Questions in Survey123 for ArcGIS

Re: Arcpy Update Rows with Field Name

Re: Arcpy Update Rows with Field Name

Re: Arcpy Update Rows with Field Name

Re: Arcpy Update Rows with Field Name

Re: Arcpy Update Rows with Field Name

Arcpy Update Rows with Field Name

Pulldata value disappears after a few seconds

Ability to add report template before data is subm...

Can't sign out completely

Unable to Submit Token Required

Re: Getting live data from ArcGIS Online to Power ...