topic Re: Spatially Enabled DataFrames Returns SHAPE Eeven When Using Fields Filter in ArcGIS API for Python Questions

Spatially Enabled DataFrames Returns SHAPE Eeven When Using Fields Filter

geoca — Wed, 23 Nov 2022 05:50:31 GMT

Using ArcGIS Python API and Spatially Enabled DataFrames

import arcpy import pandas as pd from arcgis.gis import GIS fc = "City.gdb\\fire_stations" sdf3 = pd.DataFrame.spatial.from_featureclass(fc, fields=["ADDRESS","MUN_NAME"]) sdf3.head()

I am still getting the SHAPE even though I am passing `fields=["ADDRESS","MUN_NAME"]` in the argument to get only ["ADDRESS","MUN_NAME"] in the df

Can you please let me know how I can get rid of the SHAPE column?

Re: Spatially Enabled DataFrames Returns SHAPE Eeven When Using Fields Filter

DanPatterson — Wed, 23 Nov 2022 09:30:25 GMT

arcgis.features module | ArcGIS API for Python

perhaps then you don't need a Spatially Enabled DataFrames

Re: Spatially Enabled DataFrames Returns SHAPE Eeven When Using Fields Filter

BHeist — Wed, 23 Nov 2022 14:03:10 GMT

Agreed! You’re seeing that because you’re using a SEDF

Re: Spatially Enabled DataFrames Returns SHAPE Eeven When Using Fields Filter

RogerDunnGIS — Thu, 01 Dec 2022 20:18:58 GMT

If you don't want the shape column, you can call this after it's created:

sdf3.drop("SHAPE", axis=1, inplace=True)

Re: Spatially Enabled DataFrames Returns SHAPE Eeven When Using Fields Filter

DarrenConly — Thu, 03 Aug 2023 15:30:59 GMT

Adding to this thread, it's worth noting that if you explicitly include the SHAPE field in the list of fields you specify, it cause a TypeError. So if you're specifying a subset of fields, make sure you do not include SHAPE in that subset:

emp_fields = ['SHAPE', 'SECTOR', 'COUNT'] df_i = pd.DataFrame.spatial.from_featureclass(Path(gdb_empinv).joinpath(fc), where_clause=wherecl_emp, sr=sref_sacog, fields=emp_fields) # Returns TypeError: Expected String or Unicode