Create the necessary functions in PostGIS

geoinquietosvlc / antipodes-map

Repository with the data and code for the antipodes school map

Creative Commons Zero v1.0 Universal

2 stars 1 forks source link

Closed vehrka closed 9 years ago

vehrka commented 10 years ago

Lets make this run over CartoDB with some functions

vehrka commented 10 years ago

Hmmm asking myself which is the best approach:

Function to calculate the antipodal point
- Get a point, returns a point in the antipodes
Function to search the nearest school in BOTH datasets
- Gets a point returns the code of BOTH Schools
Function to get the distance along the surface and through the Earth
- Gets two points and returns both distances

vehrka commented 10 years ago

Function to calculate the antipodal point made!

Holy cow! my pgpsql-fu is RUSTED!!!

(1h) commit bcc27d3

vehrka commented 10 years ago

Function to search the nearest school in BOTH datasets

(1h) commit 53a3eef

vehrka commented 10 years ago

Function to get the distance along the surface and through the Earth made and integrated everything in just one function to make one API call

(1h) commit cb464d0