cobergmd/manhattan.sql

Last active May 15, 2018 13:40

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/cobergmd/b908f4daaea2f9f4c25c2038a7dd233c.js"></script>
Save cobergmd/b908f4daaea2f9f4c25c2038a7dd233c to your computer and use it in GitHub Desktop.

Download ZIP

SQL Manhattan Distance

Raw

manhattan.sql

	-- Manhattan Distance
	-- \|a - c\| + \|b - d\|

	select
	format(abs((min(lat_n) - max(lat_n))) + abs((min(long_w) - max(long_w))),'F4')
	from latlongs

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment