GeoDataFrame generated in a Python Tool cannot be output to Alteryx

moemily

I am creating polygons in the Python Tool and want to output the GeoDataFrame to Alteryx to continue the analysis.  The GeoDataFrame is created, but got an error in Alteryx.  In Python Tool, the last few lines are :

gdf_5mw_df = pd.DataFrame(gdf_5mw)
gdf_5mw_df =gdf_5mw_df.astype({'the_geom': 'object'})
Alteryx.write(gdf_5mw_df, 1, {"the_geom": {"type": "SpatialObj"}})

There's no error when running Python Tool, but the Alteryx is unable to output the data :

Appreciate any help.

TravisR

Hi @moemily 

My information may be inaccurate these days - as it's been a while since I've worked with spatial data in the python tool - but to my knowledge the Python Tool cannot read/write Alteryx spatial object data.

However - there is a work around! Spatial Data in Alteryx is merely geojson. So to read Alteryx spatial data into Python Tool - you can simply use a select tool and covert the type into a string, read the data into the python tool as a string, then convert that string data back to geojson or your spatial data type of choice in python and proceed with your script. To write spatial data out of the Python Tool is the same process. Convert your spatial data to a geojson string, then write that string from the Python Tool, and then use a select tool to convert that string back to the Alteryx Spatial Object format.

Hope that helps!