Changes between Version 1 and Version 2 of OpenCellID

Timestamp:

04/06/25 23:24:19 (3 months ago)

Author:

krit

Comment:

--

OpenCellID

@@ -14 +14 @@
 ~]$ cat import.sql | sqlite3 cells.sqlite
 }}}
+
+After update the sqlite3 DB file (cells.sqlite), we can query the lat,lon by passing MCC/MNC/LAC/CellID as following
+{{{
+#!sh
+~]$ cat exSql.sh 
+#SELECT * FROM cell WHERE mcc='520' AND mnc='3' AND lac='842' AND cellid='164612740';
+sqlite3 cells.sqlite 'SELECT * FROM cell WHERE mcc='520' AND mnc='3' AND lac='842' AND cellid='164612740''
+~]$ ./exSql.sh 
+LTE|520|3|842|164612740|-1|100.6512|13.7159|1000|6|1|1739503195|1743847142|0
+~]$ 
+}}}