CELL_TOWERS

Cell tower reference data.

Data Freshness

Updated periodically.

Columns

Column	Type	Description
RADIO	TEXT	Radio technology.
MCC	NUMBER	Mobile Country Code.
NET	NUMBER	Mobile Network Code.
AREA	NUMBER	Location Area Code or Tracking Area Code.
CELL	NUMBER	Cell identifier.
UNIT	NUMBER	Unit identifier.
LON	NUMBER	Cell tower longitude.
LAT	NUMBER	Cell tower latitude.
RANGE	NUMBER	Estimated coverage range in meters.
SAMPLES	NUMBER	Number of measurements used for the position.
EXACT	NUMBER	Exact location indicator.
CREATED	NUMBER	Creation time as a Unix timestamp.
UPDATED	NUMBER	Last update time as a Unix timestamp.
AVG_STRENGTH	NUMBER	Average signal strength.

Common Queries

Look up approximate tower coordinates for current SIM session cells:

SELECT
  ss.SIM_ID,
  ss.SESSION_STATUS:cell:mcc::NUMBER AS mcc,
  ss.SESSION_STATUS:cell:mnc::NUMBER AS net,
  ss.SESSION_STATUS:cell:tac::NUMBER AS area,
  ANY_VALUE(ct.LAT) AS lat,
  ANY_VALUE(ct.LON) AS lon
FROM SIM_SNAPSHOTS ss
JOIN CELL_TOWERS ct
  ON ss.SESSION_STATUS:cell:mcc::NUMBER = ct.MCC
  AND ss.SESSION_STATUS:cell:mnc::NUMBER = ct.NET
WHERE ss.SESSION_STATUS IS NOT NULL
GROUP BY
  ss.SIM_ID,
  ss.SESSION_STATUS:cell:mcc::NUMBER,
  ss.SESSION_STATUS:cell:mnc::NUMBER,
  ss.SESSION_STATUS:cell:tac::NUMBER;