topic Re: Creating / updating feature layer in ArcGIS Online from geopandas GeoDataFrame? in ArcGIS API for Python Questions

Creating / updating feature layer in ArcGIS Online from geopandas GeoDataFrame?

HugoBouckaert1 — Thu, 14 Feb 2019 07:21:03 GMT

Is it at all possible to create a feature layer in ArcGIS Online from a GeoDataFrame? If you cannot create a feature layer directly from a GeoDataFrame, is it possible to populate an existing feature layer from a GeoDataFrame (provided the fields match of course).

I tried all sorts of methods to create a feature layer directly using GeoJSON as the intermediary - no luck. So then I tried to insert values (attributes and geometry) from a GeoDataFrame into an existing feature layer in AGOL, using GeoDataFrame.to_dict and then trying to add that dictionary to the feature layer using edit_features(adds=<my dictionary created from the GeoDataFrame>). No luck there either.

Anyone knows how this can be done?

Thanks

Hugo

Re: Creating / updating feature layer in ArcGIS Online from geopandas GeoDataFrame?

Anonymous User — Mon, 23 Sep 2019 14:36:56 GMT

Yep you can using this method:

Updating features in a feature layer | ArcGIS for Developers

Re: Creating / updating feature layer in ArcGIS Online from geopandas GeoDataFrame?

J_R_Matchett — Sun, 12 Dec 2021 09:03:55 GMT

Here's a method I wrote for GeoDataFrame to return an arcgis spatially-enabled dataframe (SEDF):

import warnings
from arcgis.geometry import Geometry
from arcgis.features import GeoAccessor, GeoSeriesAccessor
from pandas import DataFrame
from geopandas import GeoDataFrame

def to_SpatialDataFrame(self, spatial_reference=None):
    """Returns an arcgis spatially-enabled data frame.

    Arguments:
    spatial_reference  Either None or a spatial reference integer code.
                       If None, the spatial reference will be extracted
                       from the GeoDataFrame if it is defined using an
                       EPSG code.
    """
    if not spatial_reference:
        crs = self.crs
        epsg_code = crs.to_epsg()
        if epsg_code:
            spatial_reference = {'wkid': epsg_code}
        else:
            spatial_reference = {'wkid': 4326}
            warnings.warn('Unable to extract a spatial reference, assuming latitude/longitude (EPSG 4326).')
    else:
        spatial_reference = {'wkid': spatial_reference}

    sdf = DataFrame(data=self.drop(self.geometry.name, axis=1))
    sdf['SHAPE'] = [Geometry.from_shapely(g, spatial_reference) for g in self.geometry.tolist()]
    sdf.spatial.set_geometry('SHAPE')

    return sdf

GeoDataFrame.to_SpatialDataFrame = to_SpatialDataFrame
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The resulting SEDF can then be published or used to update an existing feature layer.

Re: Creating / updating feature layer in ArcGIS Online from geopandas GeoDataFrame?

HugoBouckaert1 — Thu, 09 Jul 2020 01:13:48 GMT

That's very interesting, thanks!

Re: Creating / updating feature layer in ArcGIS Online from geopandas GeoDataFrame?

ErickFox — Sun, 03 Jan 2021 15:58:32 GMT

There is a method using the arcgis api:

GeoAccessor.from_geodataframe(geo_df, inplace=False, column_name='SHAPE')