Published
Edited
Apr 23, 2019
3 forks
Importers
md`# OPT MSAs`
vegalite = require("@observablehq/vega-lite@0.1")
z = require('https://bundle.run/zebras@0.0.11')
d3 = require("d3@5")
opt = d3.csv("https://gist.githubusercontent.com/apaarty/45aef751a3124c57e23ca971f67916b8/raw/d4827970c216a5ee8e49b449d454e18a1ad8ca8c/gistfile1.txt")
+"8700"
z.head(5,opt)
vegalite({
data: {values: opt},
mark: "circle",
encoding: {
x: {field: "Lon", type: "quantitative",scale: {domain:[-170,-50]}},
y: {field: "Lat", type: "quantitative",scale: {domain:[20,50]}}
}
})
topojson = require("topojson-client@3")
us = d3.json("https://unpkg.com/us-atlas@1/us/10m.json")
msa = d3.json('https://gist.githubusercontent.com/apaarty/70843364dbbb62b751e66cec56b73ad5/raw/ca77ba829fd05fef636fd1288c6a1bbe6d9e347d/cb_2013_us_cbsa_5m.geojson')
us.objects["msa"]=msa
usa = d3.json("https://gist.githubusercontent.com/nbailey/5a4d2fcb6d344a31b017dd98822e0ce1/raw/7a042b265e32c48f96254d6c4802f4e306b6e4bc/usa_states.geojson")
optmsachart = {
let width = 960;
let height = 600;
// Create SVG
let svg = d3.select(DOM.svg(width, height));
let g = svg.append("g");
// Create empty object for holding dataset
const OPTbyMSA = {};
// Create property for each ID, give it value from rate
opt.forEach(d => (OPTbyMSA[d["Metro area"]] = +d["Total number who worked in area following school"]));
const retentionbyMSA = {};
opt.forEach(d => (retentionbyMSA[d["Metro area"]] = Math.round(100*+d["Number who left area for work"]/+d["Number who attended school in area"])));
let projPath = d3.geoPath().projection(projection);
//let path = d3.geoPath();
// Bind TopoJSON data
g.selectAll("path")
.data(usa.features) // Bind TopoJSON data elements
.enter().append("path")
.attr("d", projPath)
.style("fill", "none") // get rate value for property matching data ID
// pass rate value to color function, return color based on domain and range
.style("stroke", "black")
//let path = d3.geoPath();
// Bind TopoJSON data
g.selectAll("path")
.data(msa.features) // Bind TopoJSON data elements
.enter().append("path")
.attr("d", projPath)
.style("fill", d => colorScale(OPTbyMSA[d.properties.name])) // get rate value for property matching data ID
// pass rate value to color function, return color based on domain and range
.style("stroke", d => strokeScale(OPTbyMSA[d.properties.name]))
// .style("stroke", "none")
.on("mouseover", d => tooltip.style("visibility", "visible").html(d.properties.name + "<br/>" + "OPTs in Area: " + OPTbyMSA[d.properties.name] + "<br/>" + "Retention Rate: " + retentionbyMSA[d.properties.name] + "%"))
.on("mousemove", d => tooltip.style("top", (d3.event.pageY-10)+"px").style("left",(d3.event.pageX+10)+"px").html(d.properties.name + "<br/>" + "OPTs in Area: " + OPTbyMSA[d.properties.name] + "<br/>" + "Retention Rate: " + retentionbyMSA[d.properties.name] + "%"))
.on("mouseout", d => tooltip.style("visibility", "hidden"));
return svg.node();
}
g.append("path")
.datum(topojson.mesh(us, us.objects.states, (a, b) => a !== b))
.attr("fill", "none")
.attr("stroke", "black")
.attr("d", path);
colorScale = function(value) {
if (value == undefined) {
return "none";
} else {
return color(Math.log(value));
}
}
color = d3.scaleQuantize()
.domain([0, Math.log(d3.max(Object.values(OPTbyMSA)))])
.range(d3.schemePurples[5]);
OPTbyMSA = {
const OPTbyMSA = {};
// Create property for each ID, give it value from rate
opt.forEach(d => (OPTbyMSA[d["Metro area"]] = +d["Total number who worked in area following school"]));
return OPTbyMSA
}
tooltip = d3.select("body")
.append("div")
.style("position", "absolute")
.style("font-family", "'Open Sans', sans-serif")
.style("font-size", "12px")
.style("background","white")
.style("padding", "5px")
.style("opacity", "1")
.style("z-index", "10")
.style("visibility", "hidden");
projection = d3.geoAlbers()
path = d3.geoPath().projection(projection)
{
let width = 960;
let height = 600;
// Create SVG
let svg = d3.select(DOM.svg(width, height));
let g = svg.append("g");
// Bind TopoJSON data
g.selectAll("path")
.data(msa.features) // Bind TopoJSON data elements
.enter().append("path")
.attr("d", path)
.style("fill", "white")
.style("stroke", "black");
return svg.node();
}
topojson.feature(msa, msa)
strokeScale = function(value) {
if (value == undefined) {
return "none";
} else {
return "white";
}
}
One platform to build and deploy the best data apps
Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.