Latest Contributions by MattTarkington1

Hello all, I'm attempting to automatically compile an array of domain codes for comparison when deciding how to visualize a layer.  So this is what I've got so far:   var codearray = Array(1) var domain = Domain($feature, "Status") var index = 0 var codedValues = domain.codedValues[index].code for(var att in codedValues){ Insert(codearray, 0, codedValues) index + 1 } return codearray  Results: array(4) 0: null 1: "Run" 2: "Run" 3: "Run" Input Data (results of Domain function) dictionary codedValues: array(2) 0: dictionary code: "Run" name: "Run" 1: dictionary code: "Standby" name: "Standby" dataType: "esriFieldTypeString" name: "HydrantLoc_111319_Status_f1dd7c78-d63c-4b23-8d0d-a5f5c916c584" type: "codedValue"   The Results I'm looking for: array(2) 0: "Run" 1: "Standby"   Then to take this a step further I'm looking to do this for multiple fields and then combine them into another array that contains every combination of value from each array. But maybe that's a problem for a different post.   Thanks In Advance Yall! ... View more

Hi everyone, I'm trying to take some models in ArcPro that I've built, and translate them into a AGOL Advanced notebook. (It'd be a lot easier to just leave this in models, but IT issues cause periodic disconnect from portal mid processes and it corrupts the data) Originally I was building the notebook in pro for testing. However I just tried it in the online environment and am not having any success.  Here's the code (works in an ArcPro Notebook.) from arcgis.gis import GIS gis = GIS("home") import arcpy line_url = ("https://services8.arcgis.com/kiN57DOJrIhpvBby/arcgis/rest/services/<LineLayer>/FeatureServer/98") table_url = ("https://services8.arcgis.com/kiN57DOJrIhpvBby/arcgis/rest/services/<TableForJoin>/FeatureServer/0") arcpy.management.DeleteField(in_table=line_url, drop_field=["Freight", "Price_Per_Foot", "Price_Per_Unit", "Type", "Description" ])[0] arcpy.management.JoinField( in_data=line_url, in_field="Lock", join_table=table_url, join_field="Key_", fields="Description;Price_Per_Foot;Price_Per_Unit;Freight", fm_option="NOT_USE_FM", field_mapping=None )   And the error (returned in AGOL Notebook, no errors in pro): ExecuteError Traceback (most recent call last) Input In [110], in <cell line: 2>() 1 #Drop Fields ----> 2 arcpy.management.DeleteField( 3 in_table=line_url, 4 drop_field="Lock;Description;Price_Per_Foot;Price_Per_Unit;Freight", 5 method="DELETE_FIELDS" 6 ) 8 arcpy.management.JoinField( 9 in_data=line_url, 10 in_field="Lock", (...) 15 field_mapping=None 16 ) File /opt/conda/lib/python3.9/site-packages/arcpy/management.py:6025, in DeleteField(in_table, drop_field, method) 6023 return retval 6024 except Exception as e: -> 6025 raise e File /opt/conda/lib/python3.9/site-packages/arcpy/management.py:6022, in DeleteField(in_table, drop_field, method) 6020 from arcpy.arcobjects.arcobjectconversion import convertArcObjectToPythonObject 6021 try: -> 6022 retval = convertArcObjectToPythonObject(gp.DeleteField_management(*gp_fixargs((in_table, drop_field, method), True))) 6023 return retval 6024 except Exception as e: File /opt/conda/lib/python3.9/site-packages/arcpy/geoprocessing/_base.py:512, in Geoprocessor.__getattr__.<locals>.<lambda>(*args) 510 val = getattr(self._gp, attr) 511 if callable(val): --> 512 return lambda *args: val(*gp_fixargs(args, True)) 513 else: 514 return convertArcObjectToPythonObject(val) ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Input Table: Dataset https://services8.arcgis.com/kiN57DOJrIhpvBby/arcgis/rest/services/<LineLayer>/FeatureServer/98 does not exist or is not supported Failed to execute (DeleteField). So my end goal here is to have a table hosted in AGOL that when updated, will update prices in hosted Feature Layers. Then on to field calculates to get price of line based on (feet*price per foot).  I'm deleting fields before joining because if I don't delete, the join just continually adds more sequential fields that do not fit in with the field calculation done later in the script (at least that's how it worked in model builder).  I've also tried gis.content.get, and converting to the FeatureLayer module in this script, and get a different error: RuntimeError Traceback (most recent call last) Input In [111], in <cell line: 2>() 1 #arcpy.management.DeleteField(in_table=lineFeature, drop_field=["Freight", "Price_Per_Foot", "Price_Per_Unit", "Type", "Description"])[0] ----> 2 arcpy.management.DeleteField( 3 in_table=FuturePipe, 4 drop_field="Lock;Description;Price_Per_Foot;Price_Per_Unit;Freight", 5 method="DELETE_FIELDS" 6 ) 8 arcpy.management.JoinField( 9 in_data=lineFeature, 10 in_field="Lock", (...) 15 field_mapping=None 16 ) File /opt/conda/lib/python3.9/site-packages/arcpy/management.py:6025, in DeleteField(in_table, drop_field, method) 6023 return retval 6024 except Exception as e: -> 6025 raise e File /opt/conda/lib/python3.9/site-packages/arcpy/management.py:6022, in DeleteField(in_table, drop_field, method) 6020 from arcpy.arcobjects.arcobjectconversion import convertArcObjectToPythonObject 6021 try: -> 6022 retval = convertArcObjectToPythonObject(gp.DeleteField_management(*gp_fixargs((in_table, drop_field, method), True))) 6023 return retval 6024 except Exception as e: File /opt/conda/lib/python3.9/site-packages/arcpy/geoprocessing/_base.py:512, in Geoprocessor.__getattr__.<locals>.<lambda>(*args) 510 val = getattr(self._gp, attr) 511 if callable(val): --> 512 return lambda *args: val(*gp_fixargs(args, True)) 513 else: 514 return convertArcObjectToPythonObject(val) RuntimeError: Object: Error in executing tool If anyone knows of a better way to do this or how to get the delete then join function working correctly, I very much appreciate the help. Cheers, Matt ... View more

Hi yall, I'm just starting to learn about python and notebooks and I'm attempting to use a series of arcpy tools to  create a price calculation tool for some line layers. I won't go to far into the full details, but at the moment I'm having issue's with arcpy.management.CalculateField. So we'll get to it. Here's my code (specifics removed to protect the innocent): from arcgis.gis import GIS gis = GIS("home") from arcgis.features import FeatureLayer import arcpy #next cell line_url = ("https://services8.arcgis.com/desired/line/layer/etc") Line = FeatureLayer(line_url) #next cell arcpy.management.CalculateField(in_table=Line, field="$feature.Key", expression="$feature.Value1 + $feature.Value2", expression_type="ARCADE")[0] And here is the error. --------------------------------------------------------------------------- RuntimeError Traceback (most recent call last) Input In [56], in <cell line: 9>() ----> 9 arcpy.management.CalculateField(in_table=Line, field="$feature.Key", expression="$feature.Value1 + $feature.Value2", expression_type="ARCADE")[0] File /opt/conda/lib/python3.9/site-packages/arcpy/management.py:5788, in CalculateField(in_table, field, expression, expression_type, code_block, field_type, enforce_domains) 5786 return retval 5787 except Exception as e: -> 5788 raise e File /opt/conda/lib/python3.9/site-packages/arcpy/management.py:5785, in CalculateField(in_table, field, expression, expression_type, code_block, field_type, enforce_domains) 5783 from arcpy.arcobjects.arcobjectconversion import convertArcObjectToPythonObject 5784 try: -> 5785 retval = convertArcObjectToPythonObject(gp.CalculateField_management(*gp_fixargs((in_table, field, expression, expression_type, code_block, field_type, enforce_domains), True))) 5786 return retval 5787 except Exception as e: File /opt/conda/lib/python3.9/site-packages/arcpy/geoprocessing/_base.py:512, in Geoprocessor.__getattr__.<locals>.<lambda>(*args) 510 val = getattr(self._gp, attr) 511 if callable(val): --> 512 return lambda *args: val(*gp_fixargs(args, True)) 513 else: 514 return convertArcObjectToPythonObject(val) RuntimeError: Object: Error in executing tool  I'm thinking that it's an issue with how I pull the layer into the notebook, but have no idea what is actually happening.   Thanks in advance for your help! ... View more