Version 2 (modified by 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)
- exSql2.sh (322 bytes) - added by 3 months ago.
Download all attachments as: .zip