wiki:OpenCellID

Version 2 (modified by krit, 3 months ago) (diff)

--

OpenCell? ID

Ref here

Download and create an sqlite database from the csv data that you can get from opencellid. The thing is that it now requires a login, so the best way is to download it from browser and store it as cells.txt.gz in this folder. If you want to run this on a server then use Firefox Network panel and 'copy as cURL'. Then run that command on the server and store as cells.txt.gz.

Then run:

~]$ cat cells.txt.gz | gunzip - > cells.txt
~]$ cat schema.sql | sqlite3 cells.sqlite
~]$ 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

~]$ 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
~]$ 

Attachments (1)

Download all attachments as: .zip