INSERT into surveys values( 33, "CUCC_Balcony_HiltiAPlenty_Tiny_tube", "2022.07.30", "Frank Tully", 1000.0000, "small tube across pitch out of HiltiAPlenty", "1", 0, 0 );
INSERT into plots values( 33, 1, "1p", 1, 0, "3", "", -21.46, -309.49, 9.86, 0.00, 0.00, "", "" );
INSERT into plots values( 33, 2, "1s", 2, 0, "3", "", -70.00, -66.67, 18.00, 0.00, 0.00, "", "" );
INSERT into shots values( 33, 1, "102", "2", 2.56, 228.53, -29.87, 282.66, 24035.00 24062.00 -64.18, -1, 0, 0, 0, "102 pendant with existing pink dot, near end of sandy slide down to a pitch head. 2 Rd on pendant.", 0, 1647286631, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 2, "", "", 2.56, 228.47, -29.87, 283.11, 24031.00 24063.00 -64.13, 2, 0, 1, 0, "", 0, 1647286631, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 3, "", "", 2.55, 228.47, -29.79, 283.39, 24036.00 24060.00 -64.17, 2, 0, 1, 0, "", 0, 1647286632, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 4, "102", "", 1.35, 293.78, -15.25, 69.54, 24035.00 23965.00 -64.40, 2, 0, 0, 0, "", 0, 1647286831, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 5, "102", "", 0.50, 116.19, 1.91, 252.95, 24068.00 23998.00 -64.20, 2, 0, 0, 0, "", 0, 1647286832, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 6, "102", "", 3.26, 308.96, 86.36, 74.88, 23988.00 23972.00 -63.92, 2, 0, 0, 0, "", 0, 1647286832, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 7, "102", "", 0.53, 63.56, -83.09, 217.77, 24017.00 23968.00 -64.25, 2, 0, 0, 0, "", 0, 1647286832, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 8, "2", "", 2.02, 156.25, 7.49, 278.40, 24039.00 23966.00 -64.12, 2, 0, 0, 0, "First bolt of pitch, the one which is not on the survey", 0, 1647286981, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 9, "3", "2", 5.98, 61.11, -23.82, 63.18, 24019.00 24006.00 -64.07, -1, 0, 0, 0, "3 Rd in small passage at top of climb. ", 0, 1647287393, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 10, "", "", 5.98, 61.08, -23.71, 64.76, 24015.00 24009.00 -64.12, 2, 0, 1, 0, "", 0, 1647287393, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 11, "", "", 5.98, 61.09, -23.72, 65.58, 24020.00 24010.00 -64.11, 2, 0, 1, 0, "", 0, 1647287394, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 12, "3", "", 0.37, 133.53, -7.63, 67.36, 24054.00 24046.00 -64.08, 2, 0, 0, 0, "", 0, 1647287607, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 13, "3", "", 0.90, 197.58, 69.80, 12.17, 23968.00 23972.00 -64.24, 2, 0, 0, 0, "", 0, 1647287607, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 14, "3", "", 1.35, 161.70, -86.35, 98.37, 24026.00 23972.00 -63.97, 2, 0, 0, 0, "", 0, 1647287608, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 15, "3", "", 5.15, 64.55, -13.39, 67.64, 24049.00 24004.00 -64.01, 2, 0, 0, 0, "", 0, 1647287813, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 16, "3", "", 4.82, 39.05, -9.16, 77.43, 23967.00 23948.00 -64.07, 2, 0, 0, 0, "", 0, 1647287813, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 17, "3", "", 1.77, 32.04, -3.71, 97.15, 23993.00 23958.00 -64.03, 2, 0, 0, 0, "", 0, 1647287814, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 18, "3", "", 6.80, 91.85, -35.69, 48.73, 24001.00 24012.00 -63.98, 2, 0, 0, 0, "", 0, 1647287814, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 19, "3", "", 9.08, 105.01, -34.71, 52.75, 24004.00 24015.00 -64.02, 2, 0, 0, 0, "", 0, 1647287814, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 20, "4", "3", 1.80, 11.79, 13.74, 278.65, 24006.00 24025.00 -64.23, -1, 0, 0, 0, "4 Rd on wall", 0, 1647288311, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 21, "", "", 1.79, 11.77, 13.86, 279.14, 24009.00 24024.00 -64.23, 2, 0, 1, 0, "", 0, 1647288311, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 22, "", "", 1.79, 11.81, 13.85, 279.06, 24009.00 24023.00 -64.23, 2, 0, 1, 0, "", 0, 1647288312, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 23, "4", "", 0.48, 86.12, 3.19, 254.21, 24035.00 24015.00 -64.23, 2, 0, 0, 0, "", 0, 1647288312, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 24, "4", "", 0.60, 63.79, 64.31, 268.86, 23929.00 23968.00 -64.07, 2, 0, 0, 0, "", 0, 1647288312, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 25, "4", "", 1.52, 236.99, -89.47, 71.30, 24214.00 23963.00 -64.44, 2, 0, 0, 0, "", 0, 1647288313, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 26, "4", "5", 3.91, 167.04, -14.58, 168.17, 23979.00 23969.00 -64.14, 1, 0, 0, 0, "4 Rd on wall", 0, 1647288808, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 27, "", "", 3.91, 167.09, -14.25, 167.74, 23980.00 23981.00 -64.13, 2, 0, 1, 0, "", 0, 1647288809, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 28, "", "", 3.92, 167.27, -14.06, 167.75, 23980.00 23972.00 -64.13, 2, 0, 1, 0, "", 0, 1647288809, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 29, "5", "", 0.47, 299.99, 6.82, 287.56, 24018.00 24046.00 -64.07, 2, 0, 0, 0, "", 0, 1647288810, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 30, "5", "", 0.44, 234.14, 64.32, 326.17, 23953.00 23988.00 -64.08, 2, 0, 0, 0, "", 0, 1647288810, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 31, "5", "", 3.69, 318.78, -81.99, 303.26, 24025.00 23989.00 -64.02, 2, 0, 0, 0, "", 0, 1647288810, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 32, "5", "", 0.56, 0.14, -1.52, 50.36, 24034.00 23988.00 -64.18, 2, 0, 0, 0, "", 0, 1647288811, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 33, "5", "", 7.58, 210.26, -25.37, 277.35, 24008.00 24049.00 -64.12, 2, 0, 0, 0, "", 0, 1647288811, 0, 0.00, "00:13:43:39:E9:61" );
INSERT into shots values( 33, 34, "5", "", 2.47, 38.01, -16.96, 84.21, 24029.00 24012.00 -63.76, 2, 0, 0, 0, "", 0, 1647289308, 0, 0.00, "00:13:43:39:E9:61" );
