Latest Contributions by NathanielEvatt

I am trying to update / overwrite a Feature Layer using the ArcGIS API for Python.  I am currently loading and manipulating the data in a SpatialDataFrame and I have published the data using `sdf.spatial.to_featurelayer()`.  This function creates a shapefile and the resulting Feature Layer.  However, the data is going to be updating and changing on maybe a weekly basis.  I could delete the layer and simply recreate it, but there is a good chance that the layer will be part of a StoryMap or some other AGOL web map, so that is not an option. There is a good tutorial on how to overwrite a Feature Layer using pandas and a CSV here: overwriting_feature_layers | ArcGIS for Developers , but this depends on having the data in CSV format and utilizes the pandas `read_csv()` method, which does not have read_shapefile() equivalent.   The `manager.overwrite()` method does not accept SDF format (though that would be super cool), so I think the best way to do it is probably updating the underlying shapefile and then overwriting from there.  Any ideas on how to do that or any other ideas? ... View more

Currently in the ArcGIS Python API (from what I can tell) there is no geometry function which loads text from WKT format into ESRI geometry format.  The closest thing that I can find is loads_xy method which handles point x, y data.  But there is nothing for lines, polygons or multipolygons.   As a work around I am currently using the shapely function loads and then converting back to ESRI format as I have documented in this geonet thread ... View more

I am trying to 1. connect to a PostGIS database 2. Create a Spatially Enabled Data Frame 3. Export out to a feature layer 4. Push to AGOL.   Of those steps, I have succeeded at number one, but I am getting a error in the process of setting a geometry column in the DataFrame. I have the function `set_geomerty()` does not like the format of the data that i am putting in, which has been text and shapely format.  Is there an ESRI specific format that i should be using or a function that can put the geometry into that format? IDE: Jupyter Notebook python: 3.6 ArcGIS Python Api: 1.5.0 import pandas as pd from shapely.wkt import loads conn = config.conn df = pd.read_sql("select id, ST_AsText(geom) AS geometry from table where group_id = 63 limit 1", con=conn) df['geometry'] = df['geometry'].apply(lambda x: loads(x)) sdf = df.set_geometry('geometry') bmp_id geometry 0 Lot_5_78 POINT (-121.799248349 36.6987788232) ~/.virtualenv/esri/lib/python3.6/site-packages/arcgis/features/_data/geodataset/geodataframe.py in set_geometry(self, col, drop, inplace, sr) 1799 # Check that we are using a listlike of geometries 1800 if not all(isinstance(item, GEOM_TYPES) or not item for item in level): -> 1801 raise TypeError("Input geometry column must contain valid geometry objects.") 1802 #if isinstance(frame[geo_column_name], pd.Series): 1803 # frame[geo_column_name] = GeoSeries(frame[geo_column_name]) TypeError: Input geometry column must contain valid geometry objects. Gracias ... View more