topic Re: How to use Python API to export Online Feature Class as CSV? in ArcGIS API for Python Questions

How to use Python API to export Online Feature Class as CSV?

GeorgeClutterbuck — Fri, 20 Apr 2018 13:22:13 GMT

Hi,

I'm currently using the ArcREST API to download a feature class stored online as a CSV but I know that this is deprecated and the Python API is supposed to replace it. Can anyone offer any solutions for how to use the new API to download the attributes of a feature class in CSV format?

I have attempted this (How To: Create and download a file geodatabase replica from a hosted feature service using Python ) but it doesn't seem to work and also it seems to only offer gdb as the output whereas I need CSV.

Hope someone can help!

Thanks

Re: How to use Python API to export Online Feature Class as CSV?

MattiasWallin — Fri, 20 Apr 2018 16:07:43 GMT

Not sure if I understand the problem correct but have you tried using the Spatial DataFrame?

This works for me:

Re: How to use Python API to export Online Feature Class as CSV?

GeorgeClutterbuck — Fri, 29 Jun 2018 11:45:16 GMT

Hi Mattias,

I'm not sure if can help but since the update to ArcGIS Pro 2.2 and the latest Python 3, your method is now broken for me... the line:

sdf = ethosequip.layers[0].query().df

produces:

ValueError: Invalid geometry type for method

The method still works on a pc that I haven't updated to the latest python... bit concerning that a minor python update seems to have broken it. I have been trying to figure out why but am drawing a blank. Any help would be great. I am also trying to use the export function but having no joy (arcgis.gis module — arcgis 1.4.2 documentation )

Thanks,

Luke

Re: How to use Python API to export Online Feature Class as CSV?

MattiasWallin — Fri, 29 Jun 2018 16:57:41 GMT

Hi Luke,

I just installed Pro 2.2 and the code still works for me. It looks like 2.2 comes with the 1.4.1 API version- did you upgrade to 1.4.2?

Mattias.

Re: How to use Python API to export Online Feature Class as CSV?

GeorgeClutterbuck — Mon, 23 Jul 2018 15:08:16 GMT

Hi Mattias,

That's odd, it doesn't work on any of our computers running 2.2... I was running api version 1.4.1, i upgraded it to 1.4.2 today and it still creates the same error. It's very frustrating error and all the more if the script is working fine on your 2.2!

Luke