Skip to content

Instantly share code, notes, and snippets.

@wvpv wvpv/zip_xyz_axis_calc.sql
Last active Sep 24, 2018

Embed
What would you like to do?
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
You can’t perform that action at this time.