Steven Ottens stvno
stvno
/ pointToTileFraction.sql
Last active
September 25, 2015 18:05
SQL version of pointToTileFraction from https://github.com/mapbox/tilebelt/blob/master/index.js#L155
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create or replace function pointToTileFraction(float, float, integer) returns int[3] as $$ | |
| declare | |
| lon ALIAS FOR $1; | |
| lat ALIAS FOR $2; | |
| z ALIAS FOR $3; | |
| result int[]; | |
| BEGIN | |
| result := array_append(result, floor(pow(2,z) * (lon / 360 + 0.5))::int); | |
| result := array_append(result, floor(pow(2,z) * (0.5-0.25 *(log((1 + sin(lat*pi()/180))/(1 - sin(lat*pi()/180)))/pi())))::int); |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| NEDERLAND | |
| CARLISLE BAY BARBADOS | |
| THE DOWNS | |
| BARBADOS | |
| SPITHEAD | |
| PLYMOUTH | |
| NOVA SCOTIA | |
| CRUISING OFF GRAND BANKS | |
| SPITHEAD (VIA FYAL) | |
| ST JOHNS NEWFOUNDLAND |
stvno
/ gist:65419080b4274010f1d43fac408144a7
Created
October 7, 2018 16:21
VoyageFrom of the CLIWOC dataset
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| BATAVIA | |
| CORK | |
| ROAD TORN TORTOLA | |
| MADEIRA | |
| JAMAICA | |
| BOSTON | |
| NEW YORK | |
| JERSEY | |
| ST JOHNS | |
| ST JOHNS, NEWFOUNDLAND |