topic Re: Output Spatial Dataframe/Dataframe to Table on ArcGIS Online in ArcGIS API for Python Questions

Output Spatial Dataframe/Dataframe to Table on ArcGIS Online

ZacharyStanley — Wed, 21 Sep 2022 14:55:06 GMT

Hello,

I have a fairly simple notebook that takes a feature layer and converts it to an sdf and ultimately a df. I would simply like to output this as a table to ArcGIS online. I hope it's a simple path issue, but I'm not optimistic. The other options I've explored are the REST API 'export item' which I've had mixed results with and the idea of using the add() method. The last line in bold is where my question lies. Thanks in advance.

Code shared below:

from arcgis.gis import GIS
from IPython.display import display
import pandas as pd
from arcgis.features import GeoAccessor, GeoSeriesAccessor
from arcgis.features import FeatureLayer
import os
gis = GIS("home")
lyr_url = 'https://services6.arcgis.com/T8eS7sop5hLmgRRH/arcgis/rest/services/PublicProjectIdeas_ZS/FeatureServer'
layer = FeatureLayer(lyr_url)
layer
feature_layer = projIdeas
feature_layer
query = feature_layer.query()
projIdeasTable = query
sdf = projIdeasTable.sdf
sdf.head()
projectIdeasTable = sdf.spatial.to_table('ProjectIdeas.csv')

Re: Output Spatial Dataframe/Dataframe to Table on ArcGIS Online

EarlMedina — Wed, 21 Sep 2022 18:46:17 GMT

I'm going to assume from your usage of GIS("home") you are running this notebook in ArcGIS Pro?

I suspect the csv is being written, but perhaps not where you expect to find it. Add another cell and run this to see the current working directory:

!echo %cd%

Hope this helps!

Re: Output Spatial Dataframe/Dataframe to Table on ArcGIS Online

ZacharyStanley — Wed, 21 Sep 2022 19:41:13 GMT

Hi @EarlMedina

I'm running the notebook on AGOL and get the following results when running your command

```

/bin/bash: /opt/conda/lib/libtinfo.so.6: no version information available (required by /bin/bash)
%cd%

Re: Output Spatial Dataframe/Dataframe to Table on ArcGIS Online

ZacharyStanley — Wed, 21 Sep 2022 19:56:49 GMT

If I set the arguments to my AGOL org account i.e.

gis = GIS(url, username, password)

and use to_table method::

projectIdeasTable = sdf.spatial.to_table(name='ProjectIdeas.csv', location=gis)

I get this string error:

--------------------------------------------------------------------------- TypeError Traceback (most recent call last) Input In [73], in <cell line: 1>() ----> 1 projectIdeasTable = sdf.spatial.to_table(name='ProjectIdeas.csv', location=gis) File /opt/conda/lib/python3.9/site-packages/arcgis/features/geo/_accessor.py:2433, in GeoAccessor.to_table(self, location, overwrite, **kwargs) 2431 origin_columns = self._data.columns.tolist() 2432 origin_index = copy.deepcopy(self._data.index) -> 2433 location = os.path.abspath(location) 2434 table = run_and_hide( 2435 to_table, 2436 **{ (...) 2441 }, 2442 ) 2443 self._data.columns = origin_columns File /opt/conda/lib/python3.9/posixpath.py:375, in abspath(path) 373 def abspath(path): 374 """Return an absolute path.""" --> 375 path = os.fspath(path) 376 if not isabs(path): 377 if isinstance(path, bytes): TypeError: expected str, bytes or os.PathLike object, not GIS

Re: Output Spatial Dataframe/Dataframe to Table on ArcGIS Online

EarlMedina — Fri, 23 Sep 2022 16:04:05 GMT

Oh, I see. I didn't catch that you were running this online. I believe you want to use that method locally if you want to save to a file to disk.