Skip to content

Instantly share code, notes, and snippets.

@wvpv

wvpv/zip_xyz_axis_calc.sql

Last active September 24, 2018 23:49
Show Gist options
  • Save wvpv/8fe35d69e7acd8174550f3c23ad64c37 to your computer and use it in GitHub Desktop.
Save wvpv/8fe35d69e7acd8174550f3c23ad64c37 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
zip_xyz_axis_calc.sql
select
zip
, cos(radians(latitude)) * cos(radians(longitude)) xaxis
, cos(radians(latitude)) * sin(radians(longitude)) yaxis
, sin(radians(latitude)) zaxis
from zip_axis
/* credit https://stackoverflow.com/a/2233208/812377 */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment