Platform
Resources
Pricing
Sign in
Get started
cs7290
Workspace
Fork
Public
By
rodroadl
Edited
Nov 14, 2022
1 fork
Importers
1
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.
Try it for free
Learn more
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
workbook
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
companies
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
countyData
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
counties
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
countyList
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
_
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
json2csv
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
d3
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
xlsx
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
geocoder
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
auth
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
companiesGeoJson
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML