Skip to content

Instantly share code, notes, and snippets.

@chribsen

chribsen/rf-square-km.sql

Last active May 3, 2016 10:23
Show Gist options
  • Save chribsen/d296d11594be7500f4deff5b1a3f4dc7 to your computer and use it in GitHub Desktop.
Save chribsen/d296d11594be7500f4deff5b1a3f4dc7 to your computer and use it in GitHub Desktop.
Download ZIP
Roskilde Festival size
Raw
rf-square-km.sql
-- The size Roskilde Festival in Square Kilometers
-- The points used are taken from the max points received in the dataset from IBM / CBS dataset.
SELECT (st_distance_sphere(st_makepoint(12.106277, 55.627567), st_makepoint(12.058901,55.627567) ) /1000) *
(st_distance_sphere(st_makepoint(12.058901,55.627567), st_makepoint(12.058901, 55.609975) )/1000)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment