SQLLite to geodatabase?

679
1
10-14-2019 11:08 AM
AndrewSouthern
Occasional Contributor

A coworker recently deleted roughly 100 features from a feature service and I am attempting to recover them by copying the SQLLite database from the device and transferring it to my PC.  I copied the SQLLite database and MyAttachments to the correct folder on my machine and am able to see the submitted surveys in Survey123 field app.  However, it seems my only option is to copy data from submitted survey and resubmit as a new survey.  This is problematic because the attachments are not maintained.  If I attempt to edit and submit the original survey I am given an error that the feature does not exist (because it has been deleted.)

Is there a way that I can export the data from SQLLite to a geodatabase so that I can append the missing/deleted features to the original feature service?

Any other suggestions are welcomed.

I have attached the SQLLite database.

Thank you.

0 Kudos
1 Reply
JamesTedrick
Esri Esteemed Contributor

Hi Andrew,

Take a look at GitHub - tedrick/ReadS123DB: Convert the survey data stored in the Survey123 Field App into a set of...  - that should make it easier to migrate the data.

0 Kudos