id, time, nodeaddr, appeui, gwaddr, modulation, datarate, snr, rssi, freq, fcount, lat, lon, alt, accuracy, hdop, sats, provider, name, user_agent 1063327, 2017-06-20 21:22:41, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -15.00, -117.00, 868.500, null, 42.465875, 14.207489, 1.8, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063326, 2017-06-20 21:22:27, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -14.50, -119.00, 868.100, null, 42.465874, 14.207489, 1.9, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063325, 2017-06-20 21:22:13, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -14.50, -115.00, 868.300, null, 42.465862, 14.207451, 1.7, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063324, 2017-06-20 21:21:23, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -17.00, -117.00, 868.100, null, 42.465564, 14.206968, 0.5, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063323, 2017-06-20 21:19:24, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -14.50, -114.00, 868.300, null, 42.464974, 14.212171, -3.1, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063322, 2017-06-20 21:19:09, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -11.00, -115.00, 868.500, null, 42.464516, 14.212748, -2.2, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063321, 2017-06-20 21:13:31, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -15.00, -115.00, 868.300, null, 42.472157, 14.213403, -8.0, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063320, 2017-06-20 21:10:40, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -18.50, -113.00, 868.100, null, 42.473251, 14.211652, -5.9, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063319, 2017-06-20 21:03:03, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -15.20, -117.00, 868.300, null, 42.463596, 14.213970, -4.5, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063318, 2017-06-20 21:01:57, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -9.50, -117.00, 868.500, null, 42.463756, 14.213585, -3.8, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063317, 2017-06-20 21:00:53, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -15.20, -117.00, 868.500, null, 42.463729, 14.209110, -5.8, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063316, 2017-06-20 20:59:33, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -13.50, -117.00, 868.300, null, 42.466085, 14.206821, -4.0, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063315, 2017-06-20 20:59:20, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -7.80, -117.00, 868.100, null, 42.466551, 14.206995, -2.3, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063314, 2017-06-20 20:58:41, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -7.80, -114.00, 868.500, null, 42.468430, 14.205990, -1.4, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063313, 2017-06-20 20:58:28, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -7.80, -117.00, 868.300, null, 42.468918, 14.205563, -0.8, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063312, 2017-06-20 20:58:15, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -8.20, -114.00, 868.100, null, 42.469280, 14.205594, 1.7, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063311, 2017-06-20 20:57:35, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -12.20, -119.00, 868.100, null, 42.470460, 14.205502, 3.1, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063310, 2017-06-20 20:57:22, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -7.80, -115.00, 868.500, null, 42.471381, 14.204478, 3.2, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063309, 2017-06-20 20:57:09, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -13.00, -115.00, 868.300, null, 42.471959, 14.203495, 4.0, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063308, 2017-06-20 20:56:29, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -10.50, -115.00, 868.300, null, 42.473960, 14.201360, 3.7, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063307, 2017-06-20 20:56:24, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -8.80, -117.00, 868.100, null, 42.474203, 14.201078, 4.1, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063306, 2017-06-20 20:56:03, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -9.80, -117.00, 868.500, null, 42.475369, 14.199651, 4.8, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063305, 2017-06-20 20:55:26, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 1.20, -109.00, 868.300, null, 42.477539, 14.196995, 5.0, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063304, 2017-06-20 20:55:12, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 2.50, -108.00, 868.500, null, 42.478315, 14.196089, 3.9, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063303, 2017-06-20 20:54:58, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 1.80, -111.00, 868.100, null, 42.478703, 14.195630, 3.9, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063302, 2017-06-20 20:54:18, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 4.80, -99.00, 868.500, null, 42.481039, 14.192790, 5.6, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063301, 2017-06-20 20:54:07, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 6.00, -97.00, 868.300, null, 42.481619, 14.192096, 4.8, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063300, 2017-06-20 20:53:53, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 9.00, -99.00, 868.100, null, 42.481870, 14.191749, 3.7, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063299, 2017-06-20 20:53:15, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 8.00, -89.00, 868.300, null, 42.483294, 14.190094, 4.3, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063298, 2017-06-20 20:53:00, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 7.00, -96.00, 868.100, null, 42.484054, 14.189168, 3.2, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063297, 2017-06-20 20:52:47, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 5.20, -99.00, 868.500, null, 42.484829, 14.188235, 3.8, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063296, 2017-06-20 20:52:09, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 3.80, -115.00, 868.300, null, 42.487442, 14.185073, 3.3, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063295, 2017-06-20 20:51:56, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 2.80, -115.00, 868.500, null, 42.488222, 14.184112, 3.3, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063294, 2017-06-20 20:51:42, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 2.20, -113.00, 868.100, null, 42.489184, 14.182956, 4.0, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063293, 2017-06-20 20:51:04, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -5.80, -119.00, 868.100, null, 42.491883, 14.179681, 5.1, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063292, 2017-06-20 20:50:50, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -4.80, -114.00, 868.300, null, 42.492572, 14.178821, 3.8, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063291, 2017-06-20 20:50:37, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -7.20, -115.00, 868.500, null, 42.493481, 14.177756, 4.0, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063290, 2017-06-20 20:49:45, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -7.00, -114.00, 868.300, null, 42.495111, 14.175759, 1.6, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063289, 2017-06-20 20:48:52, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -7.00, -119.00, 868.100, null, 42.496369, 14.174289, 1.8, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063288, 2017-06-20 20:48:39, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -13.50, -115.00, 868.500, null, 42.496823, 14.174044, 1.3, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063287, 2017-06-20 20:47:48, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -10.20, -115.00, 868.100, null, 42.498790, 14.177030, 3.4, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063286, 2017-06-20 20:45:36, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -16.80, -117.00, 868.300, null, 42.496286, 14.182339, 5.0, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063285, 2017-06-20 20:45:23, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -13.00, -116.00, 868.100, null, 42.495506, 14.183137, 4.3, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063284, 2017-06-20 20:45:09, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -8.50, -114.00, 868.500, null, 42.494832, 14.183813, 4.3, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063283, 2017-06-20 20:44:17, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -6.80, -115.00, 868.300, null, 42.494375, 14.184450, 6.5, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063282, 2017-06-20 20:43:25, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -10.20, -117.00, 868.500, null, 42.492065, 14.186885, 5.7, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063281, 2017-06-20 20:43:12, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -7.20, -115.00, 868.300, null, 42.491268, 14.187748, 5.4, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063280, 2017-06-20 20:42:59, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -13.00, -118.00, 868.100, null, 42.490607, 14.188551, 4.8, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063279, 2017-06-20 20:42:20, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -10.20, -115.00, 868.300, null, 42.488426, 14.190870, 1.6, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063278, 2017-06-20 20:42:05, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -6.00, -117.00, 868.100, null, 42.488351, 14.190958, 1.1, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063277, 2017-06-20 20:41:54, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -11.00, -115.00, 868.500, null, 42.487885, 14.191429, 0.9, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063276, 2017-06-20 20:41:15, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -2.50, -117.00, 868.100, null, 42.486130, 14.193301, -0.9, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063275, 2017-06-20 20:41:02, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -1.50, -113.00, 868.500, null, 42.485624, 14.193838, -2.0, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063274, 2017-06-20 20:40:48, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 4.80, -108.00, 868.300, null, 42.485301, 14.194284, -3.3, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063273, 2017-06-20 20:40:08, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 4.00, -108.00, 868.100, null, 42.485315, 14.194285, -4.0, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063272, 2017-06-20 20:39:54, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 3.50, -107.00, 868.300, null, 42.485315, 14.194285, -4.2, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063271, 2017-06-20 20:39:42, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, 2.20, -111.00, 868.500, null, 42.485315, 14.194285, -4.5, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063270, 2017-06-20 20:12:12, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -14.50, -117.00, 868.500, null, 42.473933, 14.203107, 1.7, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063269, 2017-06-20 20:11:58, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -10.00, -116.00, 868.100, null, 42.472806, 14.203741, 3.2, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063268, 2017-06-20 20:11:44, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -12.80, -117.00, 868.300, null, 42.471674, 14.204223, 3.5, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up 1063267, 2017-06-20 20:10:38, sodaq_one_1, gps_apio_sodaq, B827EBFFFEAE1435, null, SF12BW125, -16.50, -115.00, 868.500, null, 42.470658, 14.202239, 6.5, 5.00, null, null, ios, apio-Tony-home-2, gps_apio_sodaq/devices/sodaq_one_1/up Number of rows dumped: 61