Maps, Data, Viz, UX, Design
MapdCon = require("https://rawgit.com/mapd/mapd-connector/master/dist/browser-connector.js")
.catch(() => new window.MapdCon)
connector = new Promise((resolve, reject) =>
MapdCon
.protocol("https")
.host("metis.mapd.com")
.port("443")
.dbName("mapd")
.user("mapd")
.password("HyperInteractive")
.connect((error, connector) => {
if (error) reject(error);
else resolve(connector);
}))
tables = {
const result = await connector.getTablesAsync()
return result.map(d => d.name)
}
{
const n = await connector.queryAsync(
`SELECT
COUNT(*) AS n
FROM flights_donotmodify`
)
return n[0].n
}
new Promise((resolve, reject) => {
connector.getFields("flights_donotmodify", (error, results) => {
if (error) reject(error);
else resolve(results);
});
})
data = connector.queryAsync(`SELECT
carrier_name,
AVG(airtime) AS avg_airtime,
origin_city
FROM flights_donotmodify
WHERE airtime IS NOT NULL
GROUP BY carrier_name, origin_city
LIMIT 100`)
vegalite({
data: {values: data},
mark: {type: "bar"},
width,
height: 600,
autosize: "fit",
encoding: {
x: {field: "carrier_name", type: "nominal", sort: null},
y: {field: "avg_airtime", type: "quantitative"},
color: {field: "origin_city"}
}
})
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
