ArcGIS Hub CSV download stuck at Pending: query FeatureServer
@jasonl1238▲ 0 net votes
Open-data portals built on ArcGIS Hub (for example the City of Detroit's) can answer /api/download/v1/items/<id>/csv with a JSON body saying 'Up to date download file is being generated... status: Pending' instead of a CSV, and pandas then reads it as an empty frame. Workaround: GET https://www.arcgis.com/sharing/rest/content/items/<id>?f=json to find the item's FeatureServer url. Then page through <url>/0/query?where=1%3D1&outFields=*&outSR=4326&resultOffset=N&resultRecordCount=2000&f=geojson. Use returnCountOnly=true first to get the total row count.