Skip to content

Instantly share code, notes, and snippets.

@soupslurpr

soupslurpr/query.txt

Last active April 19, 2025 04:10
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save soupslurpr/bd0f56bc1f7a531874075e9db0658257 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save soupslurpr/bd0f56bc1f7a531874075e9db0658257 to your computer and use it in GitHub Desktop.
Download ZIP
SQL query to get data for coarse network location provider
Raw
query.txt
SELECT
AVG(ST_Y(geom::geometry)) AS avg_latitude,
AVG(ST_X(geom::geometry)) AS avg_longitude,
STDDEV(ST_Y(geom::geometry)) AS lat_accuracy_radius,
STDDEV(ST_X(geom::geometry)) AS lon_accuracy_radius
FROM
cell
WHERE
mcc = number AND mnc = number AND tac_id = number;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment