Congressional Districts in Full JSON Format

The challenge is how to get ERSI shapefiles into a full json format.

I had MATLAB fired up and was going to generate this originally. It turns out a lot of the data are already there. Experience matters *a lot*. It took me two weeks to do this before. This time it took about 5 hours.

I still have all the MATLAB code, along with my custom gis calculations, but this puts everything into the database and is much cleaner.

Active and Reserve Mix for USAF Space Command

10:24 AM

google.load(‘visualization’, ‘1’, {packages: [‘geomap’]});
google.load(‘visualization’, ‘1’, {packages: [‘geomap’]});
function drawVisualization() {
var data = new google.visualization.DataTable();
data.addRows(51);
data.addColumn(‘string’, ‘State’);
data.addColumn(‘number’, ‘Military’);
data.setValue(0,0,’US-AK’);
data.setValue(0,1,108);
data.setValue(1,0,’US-AL’);
data.setValue(1,1,172);
data.setValue(2,0,’US-CA’);
data.setValue(2,1,639);
data.setValue(3,0,’US-CO’);
data.setValue(3,1,384);
data.setValue(4,0,’US-DE’);
data.setValue(4,1,66);
data.setValue(5,0,’US-FL’);
data.setValue(5,1,322);
data.setValue(6,0,’US-GA’);
data.setValue(6,1,441);
data.setValue(7,0,’US-HI’);
data.setValue(7,1,434);
data.setValue(8,0,’US-ID’);
data.setValue(8,1,48);
data.setValue(9,0,’US-IL’);
data.setValue(9,1,248);
data.setValue(10,0,’US-KS’);
data.setValue(10,1,218);
data.setValue(11,0,’US-LA’);
data.setValue(11,1,243);
data.setValue(12,0,’US-MA’);
data.setValue(12,1,306);
data.setValue(13,0,’US-MD’);
data.setValue(13,1,59);
data.setValue(14,0,’US-ME’);
data.setValue(14,1,242);
data.setValue(15,0,’US-MN’);
data.setValue(15,1,118);
data.setValue(16,0,’US-MO’);
data.setValue(16,1,123);
data.setValue(17,0,’US-NC’);
data.setValue(17,1,206);
data.setValue(18,0,’US-NY’);
data.setValue(18,1,199);
data.setValue(19,0,’US-OH’);
data.setValue(19,1,295);
data.setValue(20,0,’US-OK’);
data.setValue(20,1,240);
data.setValue(21,0,’US-PA’);
data.setValue(21,1,374);
data.setValue(22,0,’US-RI’);
data.setValue(22,1,310);
data.setValue(23,0,’US-TN’);
data.setValue(23,1,437);
data.setValue(24,0,’US-TX’);
data.setValue(24,1,348);
data.setValue(25,0,’US-UT’);
data.setValue(25,1,119);
data.setValue(26,0,’US-VT’);
data.setValue(26,1,35);
data.setValue(27,0,’US-WA’);
data.setValue(27,1,645);
data.setValue(28,0,’US-WY’);
data.setValue(28,1,170);
var options = {};
options[‘width’] = 800;
options[‘height’] = 500;
options[‘showLegend’] = false;
options[‘region’] = ‘US’;
options[‘dataMode’] = ‘regions’;
var geomap = new google.visualization.GeoMap(
document.getElementById(‘guard_visualization’));
geomap.draw(data, options);
}
google.setOnLoadCallback(drawVisualization);
google.setOnLoadCallback(drawVisualization);

Guard Only

google.load(‘visualization’, ‘1’, {packages: [‘geomap’]});
google.load(‘visualization’, ‘1’, {packages: [‘geomap’]});
function drawVisualization() {
var data = new google.visualization.DataTable();
data.addRows(51);
data.addColumn(‘string’, ‘State’);
data.addColumn(‘number’, ‘Military’);
data.setValue(0,0,’US-CA’);
data.setValue(0,1,404);
data.setValue(1,0,’US-CO’);
data.setValue(1,1,1109);
data.setValue(2,0,’US-FL’);
data.setValue(2,1,99);
data.setValue(3,0,’US-GA’);
data.setValue(3,1,112);
data.setValue(4,0,’US-IL’);
data.setValue(4,1,2);
data.setValue(5,0,’US-MA’);
data.setValue(5,1,4);
data.setValue(6,0,’US-MD’);
data.setValue(6,1,1);
data.setValue(7,0,’US-NE’);
data.setValue(7,1,37);
data.setValue(8,0,’US-NH’);
data.setValue(8,1,1);
data.setValue(9,0,’US-NJ’);
data.setValue(9,1,103);
data.setValue(10,0,’US-NM’);
data.setValue(10,1,17);
data.setValue(11,0,’US-OK’);
data.setValue(11,1,92);
data.setValue(12,0,’US-TX’);
data.setValue(12,1,78);
data.setValue(13,0,’US-VA’);
data.setValue(13,1,78);
var options = {};
options[‘width’] = 800;
options[‘height’] = 500;
options[‘showLegend’] = false;
options[‘region’] = ‘US’;
options[‘dataMode’] = ‘regions’;
var geomap = new google.visualization.GeoMap(
document.getElementById(‘reserve_visualization’));
geomap.draw(data, options);
}
google.setOnLoadCallback(drawVisualization);
google.setOnLoadCallback(drawVisualization);

Reserve Only

google.load(‘visualization’, ‘1’, {packages: [‘geomap’]});
google.load(‘visualization’, ‘1’, {packages: [‘geomap’]});
function drawVisualization() {
var data = new google.visualization.DataTable();
data.addRows(51);
data.addColumn(‘string’, ‘State’);
data.addColumn(‘number’, ‘Military’);
data.setValue(0,0,’US-AK’);
data.setValue(0,1,242);
data.setValue(1,0,’US-AL’);
data.setValue(1,1,436);
data.setValue(2,0,’US-AZ’);
data.setValue(2,1,1);
data.setValue(3,0,’US-CA’);
data.setValue(3,1,7545);
data.setValue(4,0,’US-CO’);
data.setValue(4,1,10077);
data.setValue(5,0,’US-DC’);
data.setValue(5,1,84);
data.setValue(6,0,’US-DE’);
data.setValue(6,1,1);
data.setValue(7,0,’US-FL’);
data.setValue(7,1,3988);
data.setValue(8,0,’US-GA’);
data.setValue(8,1,760);
data.setValue(9,0,’US-HI’);
data.setValue(9,1,345);
data.setValue(10,0,’US-IL’);
data.setValue(10,1,883);
data.setValue(11,0,’US-MA’);
data.setValue(11,1,103);
data.setValue(12,0,’US-MD’);
data.setValue(12,1,128);
data.setValue(13,0,’US-MS’);
data.setValue(13,1,177);
data.setValue(14,0,’US-MT’);
data.setValue(14,1,14);
data.setValue(15,0,’US-NC’);
data.setValue(15,1,9);
data.setValue(16,0,’US-ND’);
data.setValue(16,1,118);
data.setValue(17,0,’US-NE’);
data.setValue(17,1,5);
data.setValue(18,0,’US-NH’);
data.setValue(18,1,129);
data.setValue(19,0,’US-NM’);
data.setValue(19,1,351);
data.setValue(20,0,’US-NV’);
data.setValue(20,1,17);
data.setValue(21,0,’US-NY’);
data.setValue(21,1,1);
data.setValue(22,0,’US-OH’);
data.setValue(22,1,114);
data.setValue(23,0,’US-OK’);
data.setValue(23,1,1086);
data.setValue(24,0,’US-TX’);
data.setValue(24,1,1724);
data.setValue(25,0,’US-UK’);
data.setValue(25,1,34);
data.setValue(26,0,’US-UT’);
data.setValue(26,1,16);
data.setValue(27,0,’US-VA’);
data.setValue(27,1,1405);
var options = {};
options[‘width’] = 800;
options[‘height’] = 500;
options[‘showLegend’] = false;
options[‘region’] = ‘US’;
options[‘dataMode’] = ‘regions’;
var geomap = new google.visualization.GeoMap(
document.getElementById(‘active_visualization’));
geomap.draw(data, options);
}
google.setOnLoadCallback(drawVisualization);
google.setOnLoadCallback(drawVisualization);

Active Only