id, time, nodeaddr, appeui, gwaddr, modulation, datarate, snr, rssi, freq, fcount, lat, lon, alt, accuracy, hdop, sats, provider, name, user_agent 3691479, 2018-11-15 10:58:54, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -5.50, -119.00, 922.600, null, -27.430433, 153.036167, null, null, 3.0, 9, sats, abbabb, null 3691477, 2018-11-15 10:58:48, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -6.20, -118.00, 922.600, null, -27.430433, 153.036167, null, null, 3.0, 9, sats, abbabb, null 3691476, 2018-11-15 10:58:46, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -7.50, -120.00, 922.400, null, -27.430433, 153.036167, null, null, 3.0, 9, sats, abbabb, null 3691353, 2018-11-15 10:48:57, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -7.20, -120.00, 922.600, null, -27.430417, 153.036167, null, null, 1.0, 5, sats, abbabb, null 3691350, 2018-11-15 10:48:46, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -11.50, -120.00, 922.200, null, -27.430417, 153.036167, null, null, 1.0, 5, sats, abbabb, null 3689196, 2018-11-15 08:36:41, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -14.80, -121.00, 923.000, null, -27.430450, 153.036167, null, null, 3.0, 7, sats, abbabb, null 3689150, 2018-11-15 08:33:39, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, -13.00, -127.00, 922.400, null, -27.430400, 153.036167, null, null, 3.0, 8, sats, abbabb, null 3689067, 2018-11-15 08:27:06, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -7.20, -121.00, 923.200, null, -27.430433, 153.036167, null, null, 3.0, 8, sats, abbabb, null 3689066, 2018-11-15 08:27:01, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -4.20, -112.00, 922.400, null, -27.430433, 153.036167, null, null, 3.0, 8, sats, abbabb, null 3688823, 2018-11-15 08:07:39, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -9.20, -112.00, 923.400, null, -27.430433, 153.036167, null, null, 3.0, 8, sats, abbabb, null 3688797, 2018-11-15 08:05:41, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, -12.20, 0.00, 923.200, null, -27.430417, 153.036167, null, null, 3.0, 8, sats, abbabb, null 3688795, 2018-11-15 08:05:32, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -10.50, -121.00, 923.200, null, -27.430417, 153.036167, null, null, 3.0, 8, sats, abbabb, null 3688707, 2018-11-15 07:58:42, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -8.20, -120.00, 923.200, null, -27.436367, 153.036333, null, null, 3.0, 8, sats, abbabb, null 3688693, 2018-11-15 07:57:36, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -14.00, -118.00, 923.200, null, -27.439667, 153.035167, null, null, 3.0, 9, sats, abbabb, null 3688659, 2018-11-15 07:54:52, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -15.20, -121.00, 923.400, null, -27.442300, 153.032500, null, null, 3.0, 7, sats, abbabb, null 3688610, 2018-11-15 07:51:07, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -9.50, -111.00, 923.200, null, -27.448217, 153.030167, null, null, 3.0, 8, sats, abbabb, null 3688573, 2018-11-15 07:48:14, bcc-field-test-device-01, bcc-lorawan-trial, 00800000A000284E, LORA, SF10BW125, -9.00, -120.00, 923.200, null, -27.450983, 153.024000, null, null, 3.0, 9, sats, abbabb, null 3687785, 2018-11-15 06:47:46, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, -6.00, -116.00, 923.200, null, -27.470233, 153.022833, null, null, 2.0, 5, sats, abbabb, null 3169346, 2018-09-21 01:06:47, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 14.00, -49.00, 923.200, null, -27.468850, 153.020167, null, null, 1.0, 2, sats, abbabb, null 3169342, 2018-09-21 01:00:45, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 14.00, -49.00, 923.200, null, -27.468550, 153.021167, null, null, 1.0, 5, sats, abbabb, null 3169341, 2018-09-21 01:00:39, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 14.00, -49.00, 923.400, null, -27.468550, 153.021167, null, null, 1.0, 5, sats, abbabb, null 3169332, 2018-09-21 00:50:31, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 14.00, -49.00, 923.200, null, -27.469017, 153.021500, null, null, 1.0, 4, sats, abbabb, null 3169307, 2018-09-21 00:20:17, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 14.00, -49.00, 923.400, null, -27.470033, 153.022333, null, null, 1.0, 5, sats, abbabb, null 3169298, 2018-09-21 00:10:27, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 14.00, -49.00, 923.400, null, -27.470167, 153.022000, null, null, 1.0, 3, sats, abbabb, null 3169291, 2018-09-21 00:00:22, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 14.00, -49.00, 923.400, null, -27.469633, 153.021333, null, null, 1.0, 5, sats, abbabb, null 3169284, 2018-09-20 23:50:40, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 14.00, -49.00, 923.200, null, -27.470150, 153.022167, null, null, 1.0, 6, sats, abbabb, null 3169273, 2018-09-20 23:40:17, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 14.00, -49.00, 923.400, null, -27.470083, 153.021833, null, null, 1.0, 4, sats, abbabb, null 3169264, 2018-09-20 23:30:17, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 14.00, -49.00, 923.400, null, -27.469467, 153.022167, null, null, 1.0, 4, sats, abbabb, null 3169256, 2018-09-20 23:20:47, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 14.00, -49.00, 923.400, null, -27.469517, 153.022000, null, null, 3.0, 6, sats, abbabb, null 3169249, 2018-09-20 23:12:59, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 3.00, -107.00, 923.400, null, -27.471550, 153.023167, null, null, 1.0, 1, sats, abbabb, null 3169248, 2018-09-20 23:12:43, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 1.00, -109.00, 923.200, null, -27.471617, 153.023500, null, null, 1.0, 5, sats, abbabb, null 3169247, 2018-09-20 23:12:25, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 15.00, -91.00, 923.200, null, -27.471567, 153.023500, null, null, 1.0, 2, sats, abbabb, null 3169244, 2018-09-20 23:11:31, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 15.00, -93.00, 923.400, null, -27.471650, 153.023500, null, null, 1.0, 1, sats, abbabb, null 3169242, 2018-09-20 23:11:06, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 12.00, -97.00, 923.200, null, -27.471717, 153.023500, null, null, 1.0, 2, sats, abbabb, null 3169241, 2018-09-20 23:10:16, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 9.00, -101.00, 923.400, null, -27.471250, 153.024167, null, null, 1.0, 1, sats, abbabb, null 3169240, 2018-09-20 23:09:02, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, -12.00, -124.00, 923.200, null, -27.470833, 153.024500, null, null, 1.0, 2, sats, abbabb, null 3169238, 2018-09-20 23:08:37, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 0.00, -112.00, 923.400, null, -27.470783, 153.024000, null, null, 1.0, 2, sats, abbabb, null 3169237, 2018-09-20 23:08:16, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 4.00, -107.00, 923.200, null, -27.471633, 153.023833, null, null, 2.0, 0, sats, abbabb, null 3169233, 2018-09-20 23:05:40, bcc-field-test-device-01, bcc-lorawan-trial, ABB0ABB000000001, LORA, SF10BW125, 15.00, -90.00, 923.200, null, -27.472217, 153.022833, null, null, 1.0, 0, sats, abbabb, null Number of rows dumped: 39