I am using an online cartodb account to try and create a shapefile based on flight routes between one airport and another.
So far, I have uploaded my Lat/Long points for each connected airport, and used st_makeline to create a line string between them in geometry data type.
However, this outputs a direct straight line, whereas it should really follow a geographic projection and output as a curved line.
Does anyone have any advice on how to do this? Bearing in mind I am using cartodb online so am restricted to the custom SQL query it provides.
Current query is as follows:
ST_Makeline(the_geom) as the_geom