Airline on Globe
CSV(file("https://docs.machbase.com/assets/example/flights.csv"))
DROP(1) // skip header
// | 0 1 2 3 4 5 6
// +-> flights name1 lon1 lat1 name2 lon2 lat2
// |
MAPVALUE(0, latlon( parseFloat(value(2)), parseFloat(value(3))))
MAPVALUE(1, latlon( parseFloat(value(5)), parseFloat(value(6))))
// | 0 1 2 3 4 5 6
// +-> loc1 loc2 lon1 lat1 name2 lon2 lat2
// |
MAPVALUE(0, list(value(0), value(1)))
// | 0 1 2 3 4 5 6
// +-> [loc1,loc2] (lat,lon) lon1 lat1 name2 lon2 lat2
// |
POPVALUE(1, 2, 3, 4, 5, 6)
// | 0
// +-> [loc1,loc2]
// |
CHART(
plugins("gl"),
chartOption({
backgroundColor: "#000",
globe: {
baseTexture: "https://docs.machbase.com/assets/example/world.topo.bathy.200401.jpg",
heightTexture: "https://docs.machbase.com/assets/example/bathymetry_bw_composite_4k.jpg",
shading: "lambert",
light: {
ambient: {
intensity: 0.4
},
main: {
intensity: 0.4
}
},
viewControl: {
autoRotate: false
}
},
series: {
type: "lines3D",
coordinateSystem: "globe",
blendMode: "lighter",
lineStyle: {
width: 0.5,
color: "rgb(50, 50, 150)",
opacity: 0.1
},
data: column(0)
}
})
)
![](../../img/airline.jpg)
Last updated on