How do I retrieve data from an orphaned survey?

AndyZeigert

What happened:

1. We've been developing several surveys on Survey123 and testing with beta users.

2. One of our users downloaded a "beta" survey to their device.

3. We then deleted that "beta" survey from arcgis online.

4. The user then (mistakenly) collected a bunch of data using the downloaded "beta" survey, which is now orphaned. "It says invalid URL when I try to sync."

Is there any way to retrieve that data from the device?

AndyZeigert

Thanks, I was able to retrieve the .sqlite file. I attempted to run your python script to convert to .csv, but have run into another issue. It prints the first couple rows:

<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Wetland_Arid'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'"[{\\"attachments\\":[[{\\"editMode\\":0,\\"fieldName\\":\\"Photo_1\\",\\"fileName\\":\\"Photo_1-20180321-204554.jpg\\"},{\\"editMode\\":0,\\"fieldName\\":\\"Photo_2\\",\\"fileName\\":\\"Photo_2-20180321-204609.jpg\\"},{\\"editMode\\":0,\\"fieldName\\":\\"Photo_3\\",\\"fileName\\":\\"Photo_3-20180321-204620.jpg\\"},{\\"editMode\\":0,\\"fieldName\\":\\"Photo_4\\",\\"fileName\\":\\"Photo_4-20180321-204814.jpg\\"}]],\\"id\\":\\"%myform\\",\\"adds\\":[{\\"attributes\\":{\\"Veg_Tree_Repeat_count\\":\\"4\\",\\"Veg_Sapling_Repeat_count\\":\\"5\\",\\"Veg_Herb_Repeat_count\\":\\"10\\",\\"Veg_Woody_Repeat_count\\":\\"2\\",\\"Soil_Profile_Description_count\\":\\"8\\",\\"Sample_Date\\":1521615600000,\\"sample_type\\":\\"Sample_Point\\",\\"Sample_Point\\":\\"SP-5\\",\\"Investigators\\":\\"Other\\",\\"Other_Investigator\\":\\"R. Tobias\\",\\"Landform\\":\\"Depression\\",\\"Local_Relief\\":\\"Concave\\",\\"Slope_Class\\":\\"0-5\\",\\"Bare_Ground\\":\\"20\\",\\"Hydric_Soil_Ind\\":\\"Thick_Dark_Surface\\",\\"Restrictive_Layer\\":\\"No\\",\\"Hydric_Soil_Present\\":\\"Yes\\",\\"Remaks_soils\\":\\"Saturation at 6 inches\\",\\"Hydro_Indicator\\":\\"Surface_Water,High_Water_Table,Saturation,Water-Stained_Leaves\\",\\"Hydro_SW_Present\\":\\"Yes\\",\\"Hydro_WT_Present\\":\\"Yes\\",\\"Hydro_WT_Depth\\":6,\\"Hydro_Wet_Present\\":\\"Yes\\",\\"Hydro_Remarks\\":\\"Wetland B\\",\\">Veg_Tree_Repeat\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\",\\">Veg_Sapling_Repeat\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\",\\">Veg_Herb_Repeat\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\",\\">Veg_Woody_Repeat\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\",\\">Soil_Profile_Description\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"},\\"geometry\\":{\\"spatialReference\\":{\\"wkid\\":4326},\\"x\\":-117.60430254451438,\\"y\\":47.64294090447325,\\"z\\":730.9949951171875}}]},{\\"attachments\\":[null,null,null,null],\\"id\\":\\"$Veg_Tree_Repeat\\",\\"adds\\":[{\\"attributes\\":{\\"Tree_Stratum_Plot\\":\\"Shrub_15\\",\\"Tree_Stratum_1\\":null,\\"A_Per_Cover_Tree\\":null,\\"Dom_Species_Tree\\":\\"Yes\\",\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Tree_Stratum_Plot\\":null,\\"Tree_Stratum_1\\":null,\\"A_Per_Cover_Tree\\":null,\\"Dom_Species_Tree\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Tree_Stratum_Plot\\":null,\\"Tree_Stratum_1\\":null,\\"A_Per_Cover_Tree\\":null,\\"Dom_Species_Tree\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Tree_Stratum_Plot\\":null,\\"Tree_Stratum_1\\":null,\\"A_Per_Cover_Tree\\":null,\\"Dom_Species_Tree\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}}]},{\\"attachments\\":[null,null,null,null,null],\\"id\\":\\"$Veg_Sapling_Repeat\\",\\"adds\\":[{\\"attributes\\":{\\"Sap_Stratum_Plot\\":null,\\"Sap_Stratum\\":null,\\"A_Per_Cover_Sap\\":\\"70\\",\\"Dom_Species_Sap\\":\\"Yes\\",\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Sap_Stratum_Plot\\":\\"Shrub_15\\",\\"Sap_Stratum\\":\\"Black_cottonwood\\",\\"A_Per_Cover_Sap\\":null,\\"Dom_Species_Sap\\":\\"Yes\\",\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Sap_Stratum_Plot\\":null,\\"Sap_Stratum\\":null,\\"A_Per_Cover_Sap\\":null,\\"Dom_Species_Sap\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Sap_Stratum_Plot\\":null,\\"Sap_Stratum\\":null,\\"A_Per_Cover_Sap\\":null,\\"Dom_Species_Sap\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Sap_Stratum_Plot\\":null,\\"Sap_Stratum\\":null,\\"A_Per_Cover_Sap\\":null,\\"Dom_Species_Sap\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}}]},{\\"attachments\\":[null,null,null,null,null,null,null,null,null,null],\\"id\\":\\"$Veg_Herb_Repeat\\",\\"adds\\":[{\\"attributes\\":{\\"Herb_Stratum_Plot\\":\\"Herb_5\\",\\"Herb_Stratum\\":\\"Reed_Canarygrass_\\",\\"A_Per_Cover_Herb\\":\\"50\\",\\"Dom_Species_Herb\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Herb_Stratum_Plot\\":\\"Herb_5\\",\\"Herb_Stratum\\":null,\\"A_Per_Cover_Herb\\":null,\\"Dom_Species_Herb\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Herb_Stratum_Plot\\":null,\\"Herb_Stratum\\":null,\\"A_Per_Cover_Herb\\":null,\\"Dom_Species_Herb\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Herb_Stratum_Plot\\":null,\\"Herb_Stratum\\":null,\\"A_Per_Cover_Herb\\":null,\\"Dom_Species_Herb\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Herb_Stratum_Plot\\":null,\\"Herb_Stratum\\":null,\\"A_Per_Cover_Herb\\":null,\\"Dom_Species_Herb\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Herb_Stratum_Plot\\":null,\\"Herb_Stratum\\":null,\\"A_Per_Cover_Herb\\":null,\\"Dom_Species_Herb\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Herb_Stratum_Plot\\":null,\\"Herb_Stratum\\":null,\\"A_Per_Cover_Herb\\":null,\\"Dom_Species_Herb\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Herb_Stratum_Plot\\":null,\\"Herb_Stratum\\":null,\\"A_Per_Cover_Herb\\":null,\\"Dom_Species_Herb\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Herb_Stratum_Plot\\":null,\\"Herb_Stratum\\":null,\\"A_Per_Cover_Herb\\":null,\\"Dom_Species_Herb\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Herb_Stratum_Plot\\":null,\\"Herb_Stratum\\":null,\\"A_Per_Cover_Herb\\":null,\\"Dom_Species_Herb\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}}]},{\\"attachments\\":[null,null],\\"id\\":\\"$Veg_Woody_Repeat\\",\\"adds\\":[{\\"attributes\\":{\\"Woody_Stratum_Plot\\":null,\\"Woody_Stratum\\":null,\\"A_Per_Cover_Woody\\":null,\\"Dom_Species_Woody\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Woody_Stratum_Plot\\":null,\\"Woody_Stratum\\":null,\\"A_Per_Cover_Woody\\":null,\\"Dom_Species_Woody\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}}]},{\\"attachments\\":[null,null,null,null,null,null,null,null],\\"id\\":\\"$Soil_Profile_Description\\",\\"adds\\":[{\\"attributes\\":{\\"Soil_Matrix_Depth\\":\\"6\\",\\"Soil_Matrix_Color\\":\\"10Y/R 2/1\\",\\"Soil_Matrix_Percent\\":\\"100\\",\\"Soil_Redox_Color\\":null,\\"Soil_Redox_Percent\\":null,\\"Redox_Type\\":null,\\"Redox_Loc\\":null,\\"Soil_Texture\\":\\"Coarse_Sand\\",\\"Soil_Remarks\\":\\"Silty fine to coarse sand, dark brown\\",\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Soil_Matrix_Depth\\":null,\\"Soil_Matrix_Color\\":null,\\"Soil_Matrix_Percent\\":null,\\"Soil_Redox_Color\\":null,\\"Soil_Redox_Percent\\":null,\\"Redox_Type\\":null,\\"Redox_Loc\\":null,\\"Soil_Texture\\":null,\\"Soil_Remarks\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Soil_Matrix_Depth\\":null,\\"Soil_Matrix_Color\\":null,\\"Soil_Matrix_Percent\\":null,\\"Soil_Redox_Color\\":null,\\"Soil_Redox_Percent\\":null,\\"Redox_Type\\":null,\\"Redox_Loc\\":null,\\"Soil_Texture\\":null,\\"Soil_Remarks\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Soil_Matrix_Depth\\":null,\\"Soil_Matrix_Color\\":null,\\"Soil_Matrix_Percent\\":null,\\"Soil_Redox_Color\\":null,\\"Soil_Redox_Percent\\":null,\\"Redox_Type\\":null,\\"Redox_Loc\\":null,\\"Soil_Texture\\":null,\\"Soil_Remarks\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Soil_Matrix_Depth\\":null,\\"Soil_Matrix_Color\\":null,\\"Soil_Matrix_Percent\\":null,\\"Soil_Redox_Color\\":null,\\"Soil_Redox_Percent\\":null,\\"Redox_Type\\":null,\\"Redox_Loc\\":null,\\"Soil_Texture\\":null,\\"Soil_Remarks\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Soil_Matrix_Depth\\":null,\\"Soil_Matrix_Color\\":null,\\"Soil_Matrix_Percent\\":null,\\"Soil_Redox_Color\\":null,\\"Soil_Redox_Percent\\":null,\\"Redox_Type\\":null,\\"Redox_Loc\\":null,\\"Soil_Texture\\":null,\\"Soil_Remarks\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Soil_Matrix_Depth\\":null,\\"Soil_Matrix_Color\\":null,\\"Soil_Matrix_Percent\\":null,\\"Soil_Redox_Color\\":null,\\"Soil_Redox_Percent\\":null,\\"Redox_Type\\":null,\\"Redox_Loc\\":null,\\"Soil_Texture\\":null,\\"Soil_Remarks\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}},{\\"attributes\\":{\\"Soil_Matrix_Depth\\":null,\\"Soil_Matrix_Color\\":null,\\"Soil_Matrix_Percent\\":null,\\"Soil_Redox_Color\\":null,\\"Soil_Redox_Percent\\":null,\\"Redox_Type\\":null,\\"Redox_Loc\\":null,\\"Soil_Texture\\":null,\\"Soil_Remarks\\":null,\\"<myform\\":\\"{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}\\"}}]}]"'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN>
<SPAN class="punctuation token">{</SPAN><SPAN class="string token">'attachments'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">'editMode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fieldName'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Photo_1'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fileName'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Photo_1-20180321-204554.jpg'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'editMode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fieldName'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Photo_2'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fileName'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Photo_2-20180321-204609.jpg'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'editMode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fieldName'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Photo_3'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fileName'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Photo_3-20180321-204620.jpg'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'editMode'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fieldName'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Photo_4'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fileName'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Photo_4-20180321-204814.jpg'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'id'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'%myform'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'adds'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">'attributes'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'Veg_Tree_Repeat_count'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'4'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Veg_Sapling_Repeat_count'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'5'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Veg_Herb_Repeat_count'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'10'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Veg_Woody_Repeat_count'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'2'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Soil_Profile_Description_count'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'8'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Sample_Date'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1521615600000</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'sample_type'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Sample_Point'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Sample_Point'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'SP-5'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Investigators'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Other'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Other_Investigator'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'R. Tobias'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Landform'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Depression'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Local_Relief'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Concave'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Slope_Class'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'0-5'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Bare_Ground'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'20'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hydric_Soil_Ind'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Thick_Dark_Surface'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Restrictive_Layer'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'No'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hydric_Soil_Present'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Yes'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Remaks_soils'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Saturation at 6 inches'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hydro_Indicator'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Surface_Water,High_Water_Table,Saturation,Water-Stained_Leaves'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hydro_SW_Present'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Yes'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hydro_WT_Present'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Yes'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hydro_WT_Depth'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hydro_Wet_Present'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Yes'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Hydro_Remarks'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Wetland B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'>Veg_Tree_Repeat'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'>Veg_Sapling_Repeat'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'>Veg_Herb_Repeat'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'>Veg_Woody_Repeat'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'>Soil_Profile_Description'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'{ca4b964a-0bf4-4004-a4f0-180e1375c3bf}'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'geometry'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'spatialReference'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'wkid'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">4326</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'x'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">117.60430254451438</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'y'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">47.64294090447325</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'z'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="number token">730.9949951171875</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Wetland Determination Beta'</SPAN><SPAN class="punctuation token">,</SPAN> None<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

But then returns this error:

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; File <SPAN class="string token">"readDb.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">102</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>&nbsp;&nbsp;&nbsp; surveys <SPAN class="operator token">=</SPAN> readS123db<SPAN class="punctuation token">(</SPAN>inDB<SPAN class="punctuation token">)</SPAN>&nbsp; File <SPAN class="string token">"readDb.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">24</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> readS123db&nbsp;&nbsp;&nbsp; jTransaction <SPAN class="operator token">=</SPAN> json<SPAN class="punctuation token">.</SPAN>loads<SPAN class="punctuation token">(</SPAN>json<SPAN class="punctuation token">.</SPAN>loads<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp; File <SPAN class="string token">"/Users/zeigert/miniconda3/lib/python3.6/json/__init__.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">348</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> loads&nbsp;&nbsp;&nbsp; <SPAN class="string token">'not {!r}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>s<SPAN class="punctuation token">.</SPAN>__class__<SPAN class="punctuation token">.</SPAN>__name__<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>TypeError<SPAN class="punctuation token">:</SPAN> the JSON object must be str<SPAN class="punctuation token">,</SPAN> bytes <SPAN class="operator token">or</SPAN> bytearray<SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="string token">'NoneType'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

My python knowledge is meager at best. Any ideas?