Public
Edited
Nov 14, 2022
1 fork
Importers
Insert cell
Insert cell
Insert cell
workbook = FileAttachment("MaineCTE.xlsx").xlsx()
Insert cell
companies = workbook.sheet("Companies", {headers: true})
Insert cell
Inputs.table(companies, {layout: "auto"})
Insert cell
countyData = workbook.sheet("Sheet3").splice(3,13)
Insert cell
Inputs.table(workbook.sheet("Sheet3", {headers: true}), {layout: "auto"})
Insert cell
counties = countyData.map(d=> ({
County: d.A
})).concat({County: "All"})
Insert cell
viewof countyList = Inputs.select(counties, {label: "Counties", format: d => d.County})
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
companiesGeoJson = {
return {
type: "FeatureCollection",
features: companies.map((d) => {
return {
type: "Feature",
geometry: { type: "Point", coordinates: [d.Longitude, d.Latitude] },
properties: d
}
})
}
}
Insert cell

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.
Learn more