Skip to content

Instantly share code, notes, and snippets.

@elipousson

elipousson/README.md

Last active November 10, 2015 16:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save elipousson/805c2f1150928174ac8e to your computer and use it in GitHub Desktop.
Save elipousson/805c2f1150928174ac8e to your computer and use it in GitHub Desktop.
Download ZIP
Baltimore's Problem with Vacant Houses: A Workshop
Raw
README.md

Baltimore's Problem with Vacant Houses

What do you know about vacant houses? Baltimore City has over 16,000 vacant homes that contribute to a wide range of challenges for Baltimore residents and neighborhoods. Are they "eyesores" that all need to be torn down? Or historic buildings with potential for reuse? Bring your questions and ideas to a free workshop on vacant housing in Baltimore dedicated to exploring this important issue facing Baltimore's historic neighborhoods.

This gist is a place to share data we are gathering for the workshop and experiment with visualizations using bl.ocks.org, D3 and related tools.

Data

Here are the tables I have transcribed and am using for visualizations/analysis:

Sources

Raw
index.html
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Baltimore's Problem with Vacant Houses</title>
<meta name="description" content="A collection of resources related to the November 21 workshop on Baltimore's Vacant Houses">
<meta name="author" content="Eli Pousson">
<link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/pure/0.6.0/pure-min.css">
<!--[if lt IE 9]>
<script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
</head>
<body>
<div id="layout" class="pure-g">
<div class="content pure-u-1 pure-u-md-1-4">
<h2 class="post-title">Manufacturing Firm Moves Within the Baltimore SMSA, 1955-1965</h2>
<div class="post-description">
<svg width="800" height="420" xmlns="http://www.w3.org/2000/svg"><g transform="translate(0,10)"><g><path class="link" d="M12,175.88541666666669C400,175.88541666666669 400,218.69791666666666 788,218.69791666666666" style="stroke-width: 236.979px; fill: none; stroke: rgb(239, 223, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,37.34375C400,37.34375 400,20.052083333333307 788,20.052083333333307" style="stroke-width: 40.1042px; fill: none; stroke: rgb(239, 223, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,337.18750000000006C400,337.18750000000006 400,64.68749999999997 788,64.68749999999997" style="stroke-width: 21.875px; fill: none; stroke: rgb(105, 191, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,367.23958333333337C400,367.23958333333337 400,81.09374999999997 788,81.09374999999997" style="stroke-width: 10.9375px; fill: none; stroke: rgb(105, 191, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,310.78125000000006C400,310.78125000000006 400,390.88541666666663 788,390.88541666666663" style="stroke-width: 10.9375px; fill: none; stroke: rgb(239, 223, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,298.02083333333337C400,298.02083333333337 400,354.47916666666663 788,354.47916666666663" style="stroke-width: 7.29167px; fill: none; stroke: rgb(239, 223, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,374.53125000000006C400,374.53125000000006 400,339.0104166666667 788,339.0104166666667" style="stroke-width: 3.64583px; fill: none; stroke: rgb(105, 191, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,1.8229166666666667C400,1.8229166666666667 400,51.92708333333331 788,51.92708333333331" style="stroke-width: 3.64583px; fill: none; stroke: rgb(191, 105, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,5.46875C400,5.46875 400,383.59375 788,383.59375" style="stroke-width: 3.64583px; fill: none; stroke: rgb(191, 105, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,303.4895833333334C400,303.4895833333334 400,369.9479166666667 788,369.9479166666667" style="stroke-width: 3.64583px; fill: none; stroke: rgb(239, 223, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,349.94791666666674C400,349.94791666666674 400,398.1770833333333 788,398.1770833333333" style="stroke-width: 3.64583px; fill: none; stroke: rgb(105, 191, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,398.17708333333337C400,398.17708333333337 400,88.38541666666664 788,88.38541666666664" style="stroke-width: 3.64583px; fill: none; stroke: rgb(191, 105, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,386.3541666666667C400,386.3541666666667 400,340.83333333333337 788,340.83333333333337" style="stroke-width: 1px; fill: none; stroke: rgb(105, 105, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,348.12500000000006C400,348.12500000000006 400,358.125 788,358.125" style="stroke-width: 1px; fill: none; stroke: rgb(105, 191, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,348.12500000000006C400,348.12500000000006 400,371.7708333333333 788,371.7708333333333" style="stroke-width: 1px; fill: none; stroke: rgb(105, 191, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,3.6458333333333335C400,3.6458333333333335 400,368.125 788,368.125" style="stroke-width: 1px; fill: none; stroke: rgb(191, 105, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,376.3541666666667C400,376.3541666666667 400,400 788,400" style="stroke-width: 1px; fill: none; stroke: rgb(105, 191, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,361.77083333333337C400,361.77083333333337 400,40.10416666666664 788,40.10416666666664" style="stroke-width: 1px; fill: none; stroke: rgb(105, 191, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,3.6458333333333335C400,3.6458333333333335 400,100.20833333333331 788,100.20833333333331" style="stroke-width: 1px; fill: none; stroke: rgb(191, 105, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,376.3541666666667C400,376.3541666666667 400,371.7708333333333 788,371.7708333333333" style="stroke-width: 1px; fill: none; stroke: rgb(105, 191, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,386.3541666666667C400,386.3541666666667 400,40.10416666666664 788,40.10416666666664" style="stroke-width: 1px; fill: none; stroke: rgb(105, 105, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,326.25000000000006C400,326.25000000000006 400,40.10416666666664 788,40.10416666666664" style="stroke-width: 1px; fill: none; stroke: rgb(105, 191, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,386.3541666666667C400,386.3541666666667 400,358.125 788,358.125" style="stroke-width: 1px; fill: none; stroke: rgb(105, 105, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,386.3541666666667C400,386.3541666666667 400,400 788,400" style="stroke-width: 1px; fill: none; stroke: rgb(105, 105, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,386.3541666666667C400,386.3541666666667 400,86.56249999999997 788,86.56249999999997" style="stroke-width: 1px; fill: none; stroke: rgb(105, 105, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,400C400,400 400,371.7708333333333 788,371.7708333333333" style="stroke-width: 1px; fill: none; stroke: rgb(191, 105, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,3.6458333333333335C400,3.6458333333333335 400,350.8333333333333 788,350.8333333333333" style="stroke-width: 1px; fill: none; stroke: rgb(191, 105, 105); stroke-opacity: 0.4;"></path><path class="link" d="M12,400C400,400 400,358.125 788,358.125" style="stroke-width: 1px; fill: none; stroke: rgb(191, 105, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,400C400,400 400,340.83333333333337 788,340.83333333333337" style="stroke-width: 1px; fill: none; stroke: rgb(191, 105, 191); stroke-opacity: 0.4;"></path><path class="link" d="M12,396.3541666666667C400,396.3541666666667 400,40.10416666666664 788,40.10416666666664" style="stroke-width: 1px; fill: none; stroke: rgb(191, 105, 191); stroke-opacity: 0.4;"></path></g><g><g class="node" transform="translate(788,-2.842170943040401e-14)"><rect height="40.10416666666667" width="12" style="fill: rgb(102, 102, 102);"><title>Anne Arundel
11</title></rect><text x="-6" y="20.052083333333336" dy=".35em" text-anchor="end" style="font-size: 11px; font-family: Arial, Helvetica; pointer-events: none;">Anne Arundel</text></g><g class="node" transform="translate(788,50.10416666666664)"><rect height="40.10416666666667" width="12" style="fill: rgb(102, 102, 102);"><title>Baltimore City
11</title></rect><text x="-6" y="20.052083333333336" dy=".35em" text-anchor="end" style="font-size: 11px; font-family: Arial, Helvetica; pointer-events: none;">Baltimore City</text></g><g class="node" transform="translate(788,100.20833333333331)"><rect height="240.625" width="12" style="fill: rgb(102, 102, 102);"><title>Baltimore County
66</title></rect><text x="-6" y="120.3125" dy=".35em" text-anchor="end" style="font-size: 11px; font-family: Arial, Helvetica; pointer-events: none;">Baltimore County</text></g><g class="node" transform="translate(788,350.8333333333333)"><rect height="7.291666666666667" width="12" style="fill: rgb(102, 102, 102);"><title>Carroll County
2</title></rect><text x="-6" y="3.6458333333333335" dy=".35em" text-anchor="end" style="font-size: 11px; font-family: Arial, Helvetica; pointer-events: none;">Carroll County</text></g><g class="node" transform="translate(788,368.125)"><rect height="3.6458333333333335" width="12" style="fill: rgb(102, 102, 102);"><title>Harford County
1</title></rect><text x="-6" y="1.8229166666666667" dy=".35em" text-anchor="end" style="font-size: 11px; font-family: Arial, Helvetica; pointer-events: none;">Harford County</text></g><g class="node" transform="translate(788,381.7708333333333)"><rect height="18.229166666666668" width="12" style="fill: rgb(102, 102, 102);"><title>Howard County
5</title></rect><text x="-6" y="9.114583333333334" dy=".35em" text-anchor="end" style="font-size: 11px; font-family: Arial, Helvetica; pointer-events: none;">Howard County</text></g><g class="node" transform="translate(0,0)"><rect height="7.291666666666667" width="12"><title>Anne Arundel
2</title></rect><text x="18" y="3.6458333333333335" dy=".35em" text-anchor="start" style="font-size: 11px; font-family: Arial, Helvetica; pointer-events: none;">Anne Arundel</text></g><g class="node" transform="translate(0,17.291666666666668)"><rect height="298.95833333333337" width="12"><title>Baltimore City
82</title></rect><text x="18" y="149.47916666666669" dy=".35em" text-anchor="start" style="font-size: 11px; font-family: Arial, Helvetica; pointer-events: none;">Baltimore City</text></g><g class="node" transform="translate(0,326.25000000000006)"><rect height="25.520833333333336" width="12"><title>Baltimore County
7</title></rect><text x="18" y="12.760416666666668" dy=".35em" text-anchor="start" style="font-size: 11px; font-family: Arial, Helvetica; pointer-events: none;">Baltimore County</text></g><g class="node" transform="translate(0,361.77083333333337)"><rect height="14.583333333333334" width="12"><title>Carroll County
4</title></rect><text x="18" y="7.291666666666667" dy=".35em" text-anchor="start" style="font-size: 11px; font-family: Arial, Helvetica; pointer-events: none;">Carroll County</text></g><g class="node" transform="translate(0,386.3541666666667)"><rect height="0" width="12"><title>Harford County
0</title></rect><text x="18" y="0" dy=".35em" text-anchor="start" style="font-size: 11px; font-family: Arial, Helvetica; pointer-events: none;">Harford County</text></g><g class="node" transform="translate(0,396.3541666666667)"><rect height="3.6458333333333335" width="12"><title>Howard County
1</title></rect><text x="18" y="1.8229166666666667" dy=".35em" text-anchor="start" style="font-size: 11px; font-family: Arial, Helvetica; pointer-events: none;">Howard County</text></g></g></g></svg></body>
</div>
</div>
</div>
</html>
Raw
manufacturing-firm-births-deaths-moves.csv
Year Baltimore Region Baltimore City Anne Arundel County Baltimore County Carroll County Harford County Howard County
1955 (Total Number of Firms) 2777 2249 99 242 100 65 22
Births 817 476 83 154 48 34 22
(Deaths) -949 -743 -41 -88 -41 -25 -11
Moves To 619 502 16 87 4 4 6
(Moves From) -619 -573 -7 -38 -6 -3 -2
1965 (Total Number of Firms) 2645 1911 150 367 105 75 37
Raw
manufacturing-firm-moves-1955-1965.csv
Source County Number of Firms Destination County
Anne Arundel 1 Baltimore City
Baltimore County 6 Baltimore City
Carroll County 3 Baltimore City
Harford County 0 Baltimore City
Howard County 1 Baltimore City
Baltimore City 11 Anne Arundel
Baltimore County 0 Anne Arundel
Carroll County 0 Anne Arundel
Harford County 0 Anne Arundel
Howard County 0 Anne Arundel
Baltimore City 65 Baltimore County
Anne Arundel 0 Baltimore County
Carroll County 1 Baltimore County
Harford County 0 Baltimore County
Howard County 0 Baltimore County
Baltimore City 2 Carroll County
Anne Arundel 0 Carroll County
Baltimore County 0 Carroll County
Harford County 0 Carroll County
Howard County 0 Carroll County
Baltimore City 1 Harford County
Anne Arundel 0 Harford County
Baltimore County 0 Harford County
Carroll County 0 Harford County
Howard County 0 Harford County
Baltimore City 3 Howard County
Anne Arundel 1 Howard County
Baltimore County 1 Howard County
Carroll County 0 Howard County
Harford County 0 Howard County
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment