#!/bin/bash
# Create CellTower database

# obtain the input file
towerfile="cell_towers.csv"
apikey="<your_OpenCellID_ApiKey_here>"
wget -O "${towerfile}.gz" "http://downloads.opencellid.org/downloads/?apiKey=${apikey}&filename=cell_towers.csv.gz"
gunzip "${towerfile}.gz"
rm lacells.db
sqlite3 lacells.db <lacells.sql

adb push lacells.db /sdcard/.nogapps/lacells.db
