https://community.esri.com/thread/183922-download-survey-from-device-after-upload-failed
Has anyone developed a python script to extract the feature class data from the sqlite database? We had a schema change in a survey which overwrote the data on the hosted layer in ArcGIS Online and we would like to recover the data from the device and append this to the new survey layer.
Thanks for any help,
Cheers,
Simon
Hi Seth,
Thank you for writing this script!
You mentioned that this script needs to be run from an Arc Toolbox. Do you mean a python toolbox or a normal ArcToolbox? I don’t have much experience creating my own script tools and was having some difficulty getting the toolbox to fetch the input and output parameters.
Also, what version of ArcGIS/ArcGIS Pro have you tested this script in?
Any chance you could set this up in an ArcToolbox and package it up in a .zip file?
Cheers,
Simon Allard
GIS Analyst
Bay of Plenty Regional Council Toi Moana
Hi Simon,
I am running the tool in ArcMap 10.6.1 but the version shouldn’t have too much impact unless its really old.
Try copying the file and folder in this zip to the same location and adding to ArcMap. The script may need editing if your .sqlite file format is substantially different than mine.
Cheers,
Seth
Seth Paine
Geographic Information Systems Specialist
Office of Spill Prevention and Response
California Department of Fish and Wildlife
1700 K Street, Suite 250
Sacramento, CA 95811
Office Phone: (916)324-9817
Seth.Paine@Wildlife.ca.gov<mailto:Seth.Paine@Wildlife.ca.gov>
http://www.wildlife.ca.gov/OSPR
Thank you for your reply Seth. There was no .zip file attached in response. Perhaps you could email me directly at simon.allard@boprc.govt.nz<mailto:simon.allard@boprc.govt.nz>
Here is the error I was getting….
My tool looks like this
What are your input and output data types?
Cheers,
Simon Allard
GIS Analyst
Bay of Plenty Regional Council Toi Moana