topic ArcGIS API for Python - Spatially Enabled DataFrame from WKT Geometry in ArcGIS API for Python Questions https://community.esri.com/t5/arcgis-api-for-python-questions/arcgis-api-for-python-spatially-enabled-dataframe/m-p/763091#M410 <HTML><HEAD></HEAD><BODY><P>I am working in a jupyter notebook, trying to query a SQL database via pyodbc and turn the output data into a spatially enabled dataframe. I can successfully read my SQL query as a regular pandas dataframe, including a column with the geometry as WKT.&nbsp;</P><P></P><P>Can one manually add a SHAPE column (of properly converted geometry WKT into Geometry objects) to an existing pandas dataframe to create a spatially enabled dataframe?</P><P></P><P>Another way to phrase this would be, can one create a spatially enabled dataframe starting with geometry as WKT? I'm working with polygon data, so from_xy() would not work. <A _jive_internal="true" href="https://community.esri.com/thread/223454-arcgis-python-api-set-geometry-column-of-spatially-enabled-data-frame">A similar question posed in 2018</A> suggests not without some clunky workarounds via outside libraries (shapely, geojson).</P></BODY></HTML> Wed, 26 Aug 2020 15:57:28 GMT TracyWhelen 2020-08-26T15:57:28Z ArcGIS API for Python - Spatially Enabled DataFrame from WKT Geometry https://community.esri.com/t5/arcgis-api-for-python-questions/arcgis-api-for-python-spatially-enabled-dataframe/m-p/763091#M410 <HTML><HEAD></HEAD><BODY><P>I am working in a jupyter notebook, trying to query a SQL database via pyodbc and turn the output data into a spatially enabled dataframe. I can successfully read my SQL query as a regular pandas dataframe, including a column with the geometry as WKT.&nbsp;</P><P></P><P>Can one manually add a SHAPE column (of properly converted geometry WKT into Geometry objects) to an existing pandas dataframe to create a spatially enabled dataframe?</P><P></P><P>Another way to phrase this would be, can one create a spatially enabled dataframe starting with geometry as WKT? I'm working with polygon data, so from_xy() would not work. <A _jive_internal="true" href="https://community.esri.com/thread/223454-arcgis-python-api-set-geometry-column-of-spatially-enabled-data-frame">A similar question posed in 2018</A> suggests not without some clunky workarounds via outside libraries (shapely, geojson).</P></BODY></HTML> Wed, 26 Aug 2020 15:57:28 GMT https://community.esri.com/t5/arcgis-api-for-python-questions/arcgis-api-for-python-spatially-enabled-dataframe/m-p/763091#M410 TracyWhelen 2020-08-26T15:57:28Z