Exporting Surveys from sqlite

340
3
09-19-2018 10:01 AM
Highlighted
New Contributor

I extracted surveys from an iphone and now need to export them to a gdb or shapefile. I have the sqlite file but cant figure out how to get them in GIS.  

Tags (1)
Reply
0 Kudos
3 Replies
Highlighted
Occasional Contributor II

Hi Paul,

You can try the following workflow in order to access the survey submissions from the sqlite database.

1. Open the sqlite file in DB Browser for SQLite

2. Inside of this database is a single table called "Surveys"

User-added image

3. If you select the browse data tab, you can see that all submission data is stored in the "data" field as JSON.

User-added image

4. You can export the survey table as a CSV file by selecting File > Export > Table(s) as CSV File...

5. This CSV will require cleaning up - the most important thing here is the data column which will need to be parsed and cleaned up to match your survey's schema.  You can use the following json to csv converter to clean up the data field.

https://konklone.io/json/ 

6.Once the schema of the CSV matches the Survey's hosted feature layer you can append the CSV to the survey .

Best,

Marisa

Highlighted
Occasional Contributor III

Marisa,

What about attachments that are part of the survey?

Thanks,

--gary

Reply
0 Kudos
Highlighted
New Contributor

Thanks Marissa! This worked perfectly!!! 

Reply
0 Kudos