2 Download csv for your carrier and your area from https://opencellid.org/
3 $ sqlite3 <cell-database-file>
4 sqlite> create table if not exists cells (
21 sqlite> .import <downloaded-file.csv> cells
22 sqlite> create index if not exists cell_idx on cells (mcc, area, cell);
25 from datetime import datetime, timezone
26 from pprint import pprint
27 from sqlite3 import connect
30 from .GT06mod import *
32 db = connect(sys.argv[1])
33 ldb = connect(sys.argv[2])
37 """select timestamp, imei, clntaddr, length, proto, payload from events
38 where proto in (?, ?)""",
39 (WIFI_POSITIONING.PROTO, WIFI_OFFLINE_POSITIONING.PROTO),
41 for timestamp, imei, clntaddr, length, proto, payload in c:
42 obj = make_object(length, proto, payload)
43 qry = """select lat, lon from cells
44 where mcc = {} and (area, cell) in ({})""".format(
48 "({}, {})".format(locac, cellid)
49 for locac, cellid, _ in obj.gsm_cells