Latest Contributions by LindsayRaabe_FPCWA

I'm trying to update fields in a feature service from a table stored in a gdb. I've done a join using arcpys AddJoin (GlobalID fields), and then want to use Make Feature Layer to filter data by features where features in field source.A don't match join.A field.  But, when I do the MakeFeature Layer step, all the join fields disappear. Why? How can I preserve the join fields, filter my data and calculate values across? ... # Update feature service # Join Table2 to fs2 feature service using GlobalID field joined_table = arcpy.management.AddJoin(fs2, "GlobalID", Table2, "GlobalID") # Print all field names after the join fields = arcpy.ListFields(joined_table) print("Fields after join:") for field in fields: print(field.name) # Iterate through each field in the lookup_list for field in lookup_list: source_field = lookup_dict[field] join_field = f"PostPlantingInspectionTracking_TargetTable.{source_field}" fs2_field = f"L0Post_Planting_Inspection_Tracking___TEST.{source_field}" # Create a feature layer with mismatched features where_clause = ( f"({fs2_field} IS NULL AND {join_field} IS NOT NULL) OR " f"({fs2_field} <> {join_field})" ) print(where_clause) mismatched_features = arcpy.management.MakeFeatureLayer( joined_table, "mismatched_features", where_clause=where_clause ) # Print all field names in the feature layer layer_fields = arcpy.ListFields("mismatched_features") print("Fields of feature layer:") for field in layer_fields: print(field.name) # Update the features in the feature service with values from the join table with arcpy.da.UpdateCursor("mismatched_features", [fs2_field, join_field]) as cursor: for row in cursor: row[0] = row[1] cursor.updateRow(row) print("Features updated successfully.")   Print statements showing fields from Line 11 (after join) and again at Line 35 (after Make Feature Layer using joined data).  Fields after join: L0Post_Planting_Inspection_Tracking___TEST.OBJECTID L0Post_Planting_Inspection_Tracking___TEST.Plantation L0Post_Planting_Inspection_Tracking___TEST.Forest L0Post_Planting_Inspection_Tracking___TEST.Species L0Post_Planting_Inspection_Tracking___TEST.PlantingYear L0Post_Planting_Inspection_Tracking___TEST.RENDER_LABEL L0Post_Planting_Inspection_Tracking___TEST.insp_2_weeks L0Post_Planting_Inspection_Tracking___TEST.insp_4_weeks L0Post_Planting_Inspection_Tracking___TEST.insp_6_weeks L0Post_Planting_Inspection_Tracking___TEST.insp_8_weeks L0Post_Planting_Inspection_Tracking___TEST.insp_10_weeks L0Post_Planting_Inspection_Tracking___TEST.insp_12_weeks L0Post_Planting_Inspection_Tracking___TEST.insp_4_months L0Post_Planting_Inspection_Tracking___TEST.insp_5_months L0Post_Planting_Inspection_Tracking___TEST.insp_6_months L0Post_Planting_Inspection_Tracking___TEST.insp_9_months L0Post_Planting_Inspection_Tracking___TEST.insp_12_months L0Post_Planting_Inspection_Tracking___TEST.insp_15_months L0Post_Planting_Inspection_Tracking___TEST.insp_18_months L0Post_Planting_Inspection_Tracking___TEST.insp_21_months L0Post_Planting_Inspection_Tracking___TEST.insp_24_months L0Post_Planting_Inspection_Tracking___TEST.GlobalID L0Post_Planting_Inspection_Tracking___TEST.PlantingFinished L0Post_Planting_Inspection_Tracking___TEST.Creator L0Post_Planting_Inspection_Tracking___TEST.CreationDate L0Post_Planting_Inspection_Tracking___TEST.Editor L0Post_Planting_Inspection_Tracking___TEST.EditDate L0Post_Planting_Inspection_Tracking___TEST.Shape__Area L0Post_Planting_Inspection_Tracking___TEST.Shape__Length L0Post_Planting_Inspection_Tracking___TEST.Shape PostPlantingInspectionTracking_TargetTable.OBJECTID PostPlantingInspectionTracking_TargetTable.Plantation PostPlantingInspectionTracking_TargetTable.Forest PostPlantingInspectionTracking_TargetTable.Species PostPlantingInspectionTracking_TargetTable.PlantingYear PostPlantingInspectionTracking_TargetTable.RENDER_LABEL PostPlantingInspectionTracking_TargetTable.insp_2_weeks PostPlantingInspectionTracking_TargetTable.insp_4_weeks PostPlantingInspectionTracking_TargetTable.insp_6_weeks PostPlantingInspectionTracking_TargetTable.insp_8_weeks PostPlantingInspectionTracking_TargetTable.insp_10_weeks PostPlantingInspectionTracking_TargetTable.insp_12_weeks PostPlantingInspectionTracking_TargetTable.insp_4_months PostPlantingInspectionTracking_TargetTable.insp_5_months PostPlantingInspectionTracking_TargetTable.insp_6_months PostPlantingInspectionTracking_TargetTable.insp_9_months PostPlantingInspectionTracking_TargetTable.insp_12_months PostPlantingInspectionTracking_TargetTable.insp_15_months PostPlantingInspectionTracking_TargetTable.insp_18_months PostPlantingInspectionTracking_TargetTable.insp_21_months PostPlantingInspectionTracking_TargetTable.insp_24_months PostPlantingInspectionTracking_TargetTable.GlobalID PostPlantingInspectionTracking_TargetTable.PlantingFinished PostPlantingInspectionTracking_TargetTable.Creator PostPlantingInspectionTracking_TargetTable.CreationDate PostPlantingInspectionTracking_TargetTable.Editor PostPlantingInspectionTracking_TargetTable.EditDate PostPlantingInspectionTracking_TargetTable.Shape__Area PostPlantingInspectionTracking_TargetTable.Shape__Length PostPlantingInspectionTracking_TargetTable.join_field where_clause: (L0Post_Planting_Inspection_Tracking___TEST.insp_2_weeks IS NULL AND PostPlantingInspectionTracking_TargetTable.insp_2_weeks IS NOT NULL) OR (L0Post_Planting_Inspection_Tracking___TEST.insp_2_weeks <> PostPlantingInspectionTracking_TargetTable.insp_2_weeks) Fields of feature layer: OBJECTID Plantation Forest Species PlantingYear RENDER_LABEL insp_2_weeks insp_4_weeks insp_6_weeks insp_8_weeks insp_10_weeks insp_12_weeks insp_4_months insp_5_months insp_6_months insp_9_months insp_12_months insp_15_months insp_18_months insp_21_months insp_24_months GlobalID PlantingFinished Creator CreationDate Editor EditDate Shape__Area Shape__Length Shape Traceback (most recent call last): File "C:\Temp\development.py", line 238, in <module> for row in cursor: RuntimeError: Cannot find field 'L0Post_Planting_Inspection_Tracking___TEST.insp_2_weeks'   ... View more

Here's what I'm trying to do. I have a feature service (FS1) which contains inspections. These inspections can be identified by values in the following fields: plantation, years_planted, date_of_inspection & inspection_number.  Feature service 2 (FS2) contains 1 row per plantation and planting year (e.g. Ferndale:2024, Ferndale:2025, etc.) and a number of fields to record if an inspection has been completed or not based on a regular cycle.  Below is a list of values from FS1's inspection_number field and their corresponding field name from FS2.  '2 weeks': 'insp_2_weeks' '4 weeks': 'insp_4_weeks' '6 weeks': 'insp_6_weeks' '8 weeks': 'insp_8_weeks' When an inspection is done in FS1, the corresponding row in FS2 should be updated to record that it has happened by updating the corresponding inspection_number field with "username on inspection_date".  Below is the code I have so far. I know it works up to Line 80 based on print statements returned. I can't seem to get it to match up the features from FS1 (lots of inspections) with FS2 (inspection tracking) though, and once matched, update the corresponding inspection_number field.    # URLs of the feature services fs1_url = "https://services-ap1.arcgis.com/xyzxyzxyzxyzx/arcgis/rest/services/featureservice1/FeatureServer/0" fs2_url = "https://services-ap1.arcgis.com/xyzxyzxyzxyzx/arcgis/rest/services/featureservice2/FeatureServer/0" import datetime from arcgis.gis import GIS from arcgis.features import FeatureLayer import certifi import urllib3 import ssl import warnings from urllib3.exceptions import InsecureRequestWarning # Create a default SSL context with certificate verification ssl_context = ssl.create_default_context(cafile=certifi.where()) http = urllib3.PoolManager(ssl_context=ssl_context) # Make a request to verify the setup response = http.request('GET', 'https://myorg.arcgis.com') print("http response: " + str(response.status)) # Suppress only the single InsecureRequestWarning from urllib3 if necessary warnings.simplefilter('ignore', InsecureRequestWarning) # Create GIS object print("Connecting to AGOL") client_id = 'xyzxyzxyzxyzx' client_secret = 'xyzxyzxyzxyzx' gis = GIS("https://myorg.arcgis.com", client_id=client_id, client_secret=client_secret) print("Logged in as: " + gis.properties.user.username) # Access the feature layers fs1_layer = FeatureLayer(fs1_url) print(fs1_layer) fs2_layer = FeatureLayer(fs2_url) print(fs2_layer) #def update_feature_services(fs1_layer, fs2_layer): # Mapping of inspection_number values to field names in fs2 inspection_mapping = { '2 weeks': 'insp_2_weeks', '4 weeks': 'insp_4_weeks', '6 weeks': 'insp_6_weeks', '8 weeks': 'insp_8_weeks', '10 weeks': 'insp_10_weeks', '12 weeks': 'insp_12_weeks', '4 months': 'insp_4_months', '5 months': 'insp_5_months', '6 months': 'insp_6_months', '9 months': 'insp_9_months', '12 months': 'insp_12_months', '15 months': 'insp_15_months', '18 months': 'insp_18_months', '21 months': 'insp_21_months', '24 months': 'insp_24_months' } # Query to get all features from fs1 without geometry fs1_features = fs1_layer.query(where="inspection_number <> 'Ad-hoc Inspection'", out_fields=['objectid', 'globalid', 'date_of_inspection', 'plantation', 'years_planted', 'username', 'inspection_number'], return_geometry=False).features print(f"Input features found") # Query to get all features from fs2 without geometry fs2_features = fs2_layer.query(out_fields="*", return_geometry=False).features print(f"Target features found") # Iterate over each feature in fs1 for fs1_feature in fs1_features: attributes = fs1_feature.attributes plantation = attributes['plantation'] years_planted = attributes['years_planted'] inspection_number = attributes['inspection_number'] username = attributes['username'] print(f"\nPlantation: {plantation}, PYear: {years_planted}, Inspection: {inspection_number}, User: {username}") # Convert date_of_inspection to string and extract the date part if attributes['date_of_inspection']: inspection_date = datetime.datetime.fromtimestamp(attributes['date_of_inspection'] / 1000).strftime("%Y/%m/%d") print(f"Checking {username} on {inspection_date}") # Find the corresponding feature in fs2 for fs2_feature in fs2_features: fs2_attributes = fs2_feature.attributes if fs2_attributes['Plantation'] == plantation and fs2_attributes['PlantingYear'] == years_planted: # Get the corresponding field name in fs2 field_name = inspection_mapping.get(inspection_number) print(f"Inspection: {field_name}") if field_name and not fs2_attributes[field_name]: # Update the matching field with 'username on date' text fs2_attributes[field_name] = f"{username} on {inspection_date}" fs2_layer.edit_features(updates=[fs2_feature]) print(f"Updated {username} on {inspection_date}")    I feel like maybe this would be better done using arcpy.da.searchcursor or something like that, but I'm not proficient in wielding that code yet.  Visual representation of the data below (the dates don't align, but you should get the idea). Repeated inspections should trigger updates to a series of fields in a row.    ... View more