Recover Survey123 Data from SQLITE DB

0

Hello Experts

I had an issue with my surveyor collected ..

Survey123 Data was not sending and it crashed , So , whatever he as done its stored in his mobile and i have taken a copy of the database and try to open in DB broswer and i see information stored in JSON as

{
“XYZProject”: {
“AddBird”: [
{
“Biotope_Fauna”: “”,
“Bon_Con”: “Appendix II”,
“Common_Bir”: “Blackstart”,
“Count_”: 2,
“CoverPerc_Fauna”: “3”,
“FamilyName”: “Muscicapidae”,
“Genus”: “Oenanthe”,
“HCP_SR_20”: “101”,
“IUCN_BBird”: “LC”,
“IUCN_GL”: “LC”,
“IUCN_RE”: “LC”,
“PhotoCount”: 0,
“Sight_Det”: “Adult”,
“SpeciesB”: “Oenanthe melanura”,
“globalid”: “{FE655F9D-4F21-4109-912E-82D5A8865498}”,
“__meta__”: {
“globalIdField”: “globalid”,
“objectIdField”: “objectid”,
“editMode”: 1
},
“objectid”: 101,
“parentglobalid”: “{1A1AA6EC-B8F6-48B0-A6B0-2EFAE9ABFE6D}”
},
{
“Biotope_Fauna”: “Wadis with sandy or gravelly floors, and channelised drainage channels_6230”,
“Common_Bir”: “Laughing Dove”,
“Count_”: 2,
“CoverPerc_Fauna”: “3”,
“FamilyName”: “Columbidae”,
“Genus”: “Spilopelia”,
“IUCN_BBird”: “LC”,
“IUCN_GL”: “LC”,
“IUCN_RE”: “LC”,
“PhotoCount”: 0,
“Sight_Det”: “Adult”,
“SpeciesB”: “Spilopelia senegalensis”,
“globalid”: “{4B0AC616-1638-4A43-9EA3-DC9D45C70D68}”,
“__meta__”: {
“globalIdField”: “globalid”,
“objectIdField”: “objectid”,
“editMode”: 1
},
“objectid”: 102,
“parentglobalid”: “{1A1AA6EC-B8F6-48B0-A6B0-2EFAE9ABFE6D}”
}
],
“AddMammal”: [],
“AddReptile”: [],
“Biotope”: “Wadis with sandy or gravelly floors, and channelised drainage channels_6230”,
“Birds”: “Sighting”,
“Coordinate”: {
“direction”: 147.5477752685547,
“horizontalAccuracy”: 6.481075286865234,
“positionSourceInfo”: {
“altitudeType”: 0,
“antennaHeight”: null,
“confidenceLevelType”: 0,
“connectionMode”: 2,
“geoidSeparationCustom”: null,
“pluginName”: “AppStudio-AndroidLocation”
},
“positionSourceType”: 2,
“satellitesInUse”: 46,
“spatialReference”: {
“wkid”: 4326
},
“speed”: 0.4365275204181671,
“type”: “point”,
“verticalAccuracy”: 6.481075286865234,
“x”: 36.145749111928474,
“y”: 27.349412069620605,
“z”: 221.48619645740837
},
“CoverPerc”: “3”,
“DAFOR”: “Not_Applicable”,
“Date_”: 1679302800000,
“FloraInfo”: [
{
“Biotope_Flora”: “Wadis with sandy or gravelly floors, and channelised drainage channels_6230”,
“ComName”: “Rimth Saltbush, Hammada Elegance”,
“CoverPerc_Flora”: “3”,
“Lat1”: 27.349412069620605,
“Long1”: 36.145749111928474,
“PhotoCount”: 0,
“SampleID_Flora”: “438”,
“SpeciesFlor”: “Haloxylon salicornicum”,
“globalid”: “{C9DEF049-5E43-489A-AEBE-E8106E93DC2E}”,
“__meta__”: {
“globalIdField”: “globalid”,
“objectIdField”: “objectid”,
“editMode”: 1
},
“objectid”: 570,
“parentglobalid”: “{1A1AA6EC-B8F6-48B0-A6B0-2EFAE9ABFE6D}”
},
{
“Biotope_Flora”: “Wadis with sandy or gravelly floors, and channelised drainage channels_6230”,
“ComName”: “Taily Weed”,
“CoverPerc_Flora”: “3”,
“Lat1”: 27.349412069620605,
“Long1”: 36.145749111928474,
“PhotoCount”: 0,
“SampleID_Flora”: “438”,
“SpeciesFlor”: “Ochradenus baccatus”,
“globalid”: “{B75DA97F-E973-45DA-B582-CAD3AAB72750}”,
“__meta__”: {
“globalIdField”: “globalid”,
“objectIdField”: “objectid”,
“editMode”: 1
},
“objectid”: 571,
“parentglobalid”: “{1A1AA6EC-B8F6-48B0-A6B0-2EFAE9ABFE6D}”
},
{
“Biotope_Flora”: “Wadis with sandy or gravelly floors, and channelised drainage channels_6230”,
“ComName”: “Umbrella Thorn Acacia”,
“CoverPerc_Flora”: “3”,
“Lat1”: 27.349412069620605,
“Long1”: 36.145749111928474,
“PhotoCount”: 0,
“SampleID_Flora”: “438”,
“SpeciesFlor”: “Vachellia tortilis”,
“globalid”: “{75C807E2-4765-48BE-BBA9-0B1D769F704F}”,
“__meta__”: {
“globalIdField”: “globalid”,
“objectIdField”: “objectid”,
“editMode”: 1
},
“objectid”: 572,
“parentglobalid”: “{1A1AA6EC-B8F6-48B0-A6B0-2EFAE9ABFE6D}”
},
{
“Biotope_Flora”: “Wadis with sandy or gravelly floors, and channelised drainage channels_6230”,
“ComName”: “Desert Broomrape”,
“CoverPerc_Flora”: “3”,
“FieldPhotoFL”: “FieldPhotoFL-20230320-102625.jpg”,
“Lat1”: 27.349412069620605,
“Long1”: 36.145749111928474,
“PhotoCount”: 1,
“PhotoName”: “FieldPhotoFL-20230320-102625.jpg”,
“SampleID_Flora”: “438”,
“SpeciesFlor”: “Cistanche tubulosa”,
“globalid”: “{53868E5E-31F6-486A-8966-030DBD19174D}”,
“__meta__”: {
“globalIdField”: “globalid”,
“objectIdField”: “objectid”,
“editMode”: 1
},
“objectid”: 573,
“parentglobalid”: “{1A1AA6EC-B8F6-48B0-A6B0-2EFAE9ABFE6D}”
},
{
“Biotope_Flora”: “Wadis with sandy or gravelly floors, and channelised drainage channels_6230”,
“ComName”: “Desert Squash, Bitter Apple”,
“CoverPerc_Flora”: “3”,
“FieldPhotoFL”: “FieldPhotoFL-20230320-102839.jpg,FieldPhotoFL-20230320-102848.jpg”,
“Lat1”: 27.349412069620605,
“Long1”: 36.145749111928474,
“PhotoCount”: 2,
“PhotoName”: “FieldPhotoFL-20230320-102839.jpg,FieldPhotoFL-20230320-102848.jpg”,
“SampleID_Flora”: “438”,
“SpeciesFlor”: “Citrullus colocynthis”,
“globalid”: “{BE330A62-CFF5-46C2-8EBB-CF825806A379}”,
“__meta__”: {
“globalIdField”: “globalid”,
“objectIdField”: “objectid”,
“editMode”: 1
},
“objectid”: 574,
“parentglobalid”: “{1A1AA6EC-B8F6-48B0-A6B0-2EFAE9ABFE6D}”
}
],
“FloraObserved”: “Yes”,
“Horz_Acc”: 6.481075286865234,
“Lat”: 27.349412069620605,
“Long_”: 36.145749111928474,
“Mammals”: “None”,
“ObsDate”: 1679302800000,
“ObsTime”: 1679307360000,
“OtherInfo”: [
{
“Biotope_Other”: “Wadis with sandy or gravelly floors, and channelised drainage channels_6230”,
“Comments”: “Large sandy wadi\nSigns of historical flooding\nOld tar road\nFenced off farm with crops and reservoirs, probably has access to aquifer”,
“CoverPerc_Other”: “3”,
“FieldPhotoOt”: “FieldPhotoOt-20230320-101753.jpg,FieldPhotoOt-20230320-101758.jpg,FieldPhotoOt-20230320-101806.jpg,FieldPhotoOt-20230320-101813.jpg,FieldPhotoOt-20230320-101829.jpg,FieldPhotoOt-20230320-101835.jpg,FieldPhotoOt-20230320-101852.jpg,FieldPhotoOt-20230320-102505.jpg,FieldPhotoOt-20230320-102515.jpg,FieldPhotoOt-20230320-102936.jpg,FieldPhotoOt-20230320-102946.jpg”,
“Lat1”: 27.349412069620605,
“Long1”: 36.145749111928474,
“ObsType”: “Key Landscape Features”,
“PhotoCount”: 11,
“PhotoEx”: “100-4686 – 100-4696”,
“PhotoName”: “FieldPhotoOt-20230320-101753.jpg,FieldPhotoOt-20230320-101758.jpg,FieldPhotoOt-20230320-101806.jpg,FieldPhotoOt-20230320-101813.jpg,FieldPhotoOt-20230320-101829.jpg,FieldPhotoOt-20230320-101835.jpg,FieldPhotoOt-20230320-101852.jpg,FieldPhotoOt-20230320-10”,
“SampleID_Other”: “438”,
“globalid”: “{1E490282-7902-4AA0-BEE2-41B7B44D5164}”,
“__meta__”: {
“globalIdField”: “globalid”,
“objectIdField”: “objectid”,
“editMode”: 1
},
“objectid”: 31,
“parentglobalid”: “{1A1AA6EC-B8F6-48B0-A6B0-2EFAE9ABFE6D}”
}
],
“OthersObserved”: “Yes”,
“PhotoCount”: 0,
“Reptiles”: “None”,
“SampleID”: “438”,
“Time_”: 1679307360000,
“globalid”: “{1A1AA6EC-B8F6-48B0-A6B0-2EFAE9ABFE6D}”,
“__meta__”: {
“globalIdField”: “globalid”,
“objectIdField”: “objectid”,
“editMode”: 1
},
“objectid”: 78
}
}

How can i fix the Data

Kindly Guide

abnan0001 Asked question April 5, 2023

Stats for this question

  • Active
  • Views1060 times
  • Answers0 answers

Help categories

Search questions