Hi @Jay_Gregory
The script I've written reads a GDB feature class and updates a web feature layer i.e. appends new data to it.
You just need to change/update the fields of attribute table.
from arcgis import GIS
import pandas as pd
from arcgis.features import GeoAccessor, GeoSeriesAccessor
from arcgis import geometry
from copy import deepcopy
gis = GIS('url', 'username', 'password')
sdf_to_append = pd.DataFrame.spatial.from_featureclass(r"path to gdb feature class")
#search for the hosted feature layer/service
featureLayer_item = gis.content.search('type: "Feature Service" AND title:"xxxxx"')
#access the item's feature layers
feature_layers = featureLayer_item[0].layers
#query all the features
fset = feature_layers[0].query()
features_to_be_added = []
template_hostedFeature = deepcopy(fset.features[0])
for index, row in sdf_to_append.iterrows():
x = sdf_to_append.loc[index]['SHAPE']['x']
y = sdf_to_append.loc[index]['SHAPE']['y']
new_feature = deepcopy(template_hostedFeature)
input_geometry = {'y':float(y), 'x':float(x)}
output_geometry = geometry.project(geometries = [input_geometry],
in_sr = 3857,
out_sr = 3857,
gis = gis)
# assign the updated values
new_feature.geometry = output_geometry[0]
new_feature.attributes['HoleID'] = row['HoleID']
new_feature.attributes['Project'] = row['Project']
new_feature.attributes['InterFrom'] = row['InterFrom']
new_feature.attributes['InterTo'] = row['InterTo']
new_feature.attributes['Grade'] = row['Grade']
new_feature.attributes['GramMetre'] = row['GramMetre']
new_feature.attributes['RegoProf'] = row['RegoProf']
new_feature.attributes['MidPoint'] = row['MidPoint']
new_feature.attributes['IntercptNo'] = row['IntercptNo']
new_feature.attributes['Overlap'] = row['Overlap']
new_feature.attributes['EndDate'] = row['EndDate']
new_feature.attributes['EAST'] = row['EAST']
new_feature.attributes['NORTH'] = row['NORTH']
new_feature.attributes['RL'] = row['RL']
new_feature.attributes['Width'] = row['Width']
features_to_be_added.append(new_feature)
feature_layers[0].edit_features(adds = features_to_be_added)
print("Hosted feature layer is updated with gdb feature class!")
However if you want to overwrite a feature layer, it's recommended to truncate it first then do an overwrite:
from arcgis.gis import GIS
from arcgis.features import FeatureLayerCollection
gis = GIS("url", "username", "password")
# get the feature layer
flc_item = gis.content.get("item_id")
fLyr = flc_item.layers[0]
fLyr.manager.truncate()
# get the gdb item
gdb_item = gis.content.get("gdb_item_id")
feature_layer_collection = FeatureLayerCollection.fromitem(flc_item)
feature_layer_collection.manager.overwrite(gdb_item)
I hope that's helpful.
Cheers
Mehdi
