Append to hosted Feature layer from local gdb, Python

BenjaminMittler

Hi All, 

I spent pretty much all day today trying to figure out how to append date to a hosted feature layer from a feature class in a gdb. The documentation found from ESRI makes it seem that i first need to upload my gdb to ArcGIS Online in order to give it an ID, is this true. Is there no simple way to append data to a hosted feature service from a gdb feature layer if they both have the same schema?

MehdiPira1

Hi Benjamin Mittler‌,

Here's the code you can use to append to a hosted feature layer from a gdb feature class.

You just need to change/update, add/delete the attributes based on your hosted feature layer and your gdb feature class attributes and change other variables too.

<SPAN class="keyword token">from</SPAN> arcgis <SPAN class="keyword token">import</SPAN> GIS
<SPAN class="keyword token">import</SPAN> pandas <SPAN class="keyword token">as</SPAN> pd
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>features <SPAN class="keyword token">import</SPAN> GeoAccessor<SPAN class="punctuation token">,</SPAN> GeoSeriesAccessor
<SPAN class="keyword token">from</SPAN> arcgis <SPAN class="keyword token">import</SPAN> geometry
<SPAN class="keyword token">from</SPAN> copy <SPAN class="keyword token">import</SPAN> deepcopy

gis <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'url'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'username'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'password'</SPAN><SPAN class="punctuation token">)</SPAN>

sdf_to_append <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">.</SPAN>spatial<SPAN class="punctuation token">.</SPAN>from_featureclass<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"path to gdb feature class"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#search for the hosted feature layer/service</SPAN>
featureLayer_item <SPAN class="operator token">=</SPAN> gis<SPAN class="punctuation token">.</SPAN>content<SPAN class="punctuation token">.</SPAN>search<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'type: "Feature Service" AND title:"xyz"'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#access the item's feature layers</SPAN>
feature_layers <SPAN class="operator token">=</SPAN> featureLayer_item<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>layers

<SPAN class="comment token">#query all the features</SPAN>
fset <SPAN class="operator token">=</SPAN> feature_layers<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>query<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

features_to_be_added <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
template_hostedFeature <SPAN class="operator token">=</SPAN> deepcopy<SPAN class="punctuation token">(</SPAN>fset<SPAN class="punctuation token">.</SPAN>features<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> index<SPAN class="punctuation token">,</SPAN> row <SPAN class="keyword token">in</SPAN> sdf_to_append<SPAN class="punctuation token">.</SPAN>iterrows<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    x <SPAN class="operator token">=</SPAN> sdf_to_append<SPAN class="punctuation token">.</SPAN>loc<SPAN class="punctuation token">[</SPAN>index<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SHAPE'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'x'</SPAN><SPAN class="punctuation token">]</SPAN>
    y <SPAN class="operator token">=</SPAN> sdf_to_append<SPAN class="punctuation token">.</SPAN>loc<SPAN class="punctuation token">[</SPAN>index<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SHAPE'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'y'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature <SPAN class="operator token">=</SPAN> deepcopy<SPAN class="punctuation token">(</SPAN>template_hostedFeature<SPAN class="punctuation token">)</SPAN>
    input_geometry <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'y'</SPAN><SPAN class="punctuation token">:</SPAN>float<SPAN class="punctuation token">(</SPAN>y<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'x'</SPAN><SPAN class="punctuation token">:</SPAN>float<SPAN class="punctuation token">(</SPAN>x<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>
    output_geometry <SPAN class="operator token">=</SPAN> geometry<SPAN class="punctuation token">.</SPAN>project<SPAN class="punctuation token">(</SPAN>geometries <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>input_geometry<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
                                       in_sr <SPAN class="operator token">=</SPAN> <SPAN class="number token">3857</SPAN><SPAN class="punctuation token">,</SPAN> 
                                       out_sr <SPAN class="operator token">=</SPAN> <SPAN class="number token">3857</SPAN><SPAN class="punctuation token">,</SPAN>
                                       gis <SPAN class="operator token">=</SPAN> gis<SPAN class="punctuation token">)</SPAN>

    <SPAN class="comment token"># assign the updated values</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>geometry <SPAN class="operator token">=</SPAN> output_geometry<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'HoleID'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'HoleID'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Project'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Project'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'InterFrom'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'InterFrom'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'InterTo'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'InterTo'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Grade'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Grade'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GramMetre'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GramMetre'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'RegoProf'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'RegoProf'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'MidPoint'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'MidPoint'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'IntercptNo'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'IntercptNo'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Overlap'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Overlap'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'EndDate'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'EndDate'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'EAST'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'EAST'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'NORTH'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'NORTH'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'RL'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'RL'</SPAN><SPAN class="punctuation token">]</SPAN>
    new_feature<SPAN class="punctuation token">.</SPAN>attributes<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Width'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Width'</SPAN><SPAN class="punctuation token">]</SPAN>  
    
    features_to_be_added<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>new_feature<SPAN class="punctuation token">)</SPAN>

feature_layers<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>edit_features<SPAN class="punctuation token">(</SPAN>adds <SPAN class="operator token">=</SPAN> features_to_be_added<SPAN class="punctuation token">)</SPAN> 
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Hosted feature layer is updated with gdb feature class!"</SPAN><SPAN class="punctuation token">)</SPAN>

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I hope that's helpful.