Create great circles in postgis / cartodb.
|The examples given, and the previous answer all depend on taking the line into a planar projection and then segmentizing. As of PostGIS 2.1 (which I think CartoDB is on) you can do a general-purpose job of it using ST_Segmentize(geography), so like this:|
|make a central point in SRS 4326|
|make a line between that point and each point in the table|
|convert that line into the geography type|
|segmentize in geography space (along the great circle route)|
|convert that detailed geography back into geometry|