= OpenCell ID

Ref [https://github.com/janjongboom/opencellid/blob/master/README.md here]

Download and create an sqlite database from the csv data that you can get from [http://opencellid.org/downloads/ 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:


{{{
#!sh
~]$ 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
{{{
#!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
~]$ 
}}}