fitnr

javascript:%28function%28%29%7Bvar%20n,walk=document.createTreeWalker%28document.body,NodeFilter.SHOW_TEXT,null,0%29%3Bwhile%28n=walk.nextNode%28%29%29%7Bif(n.textContent.trim%28%29.length>0)n.textContent=window.getComputedStyle(n.parentNode).fontSize%3B%7D%7D%29%28%29

fitnr

states = fl la nc ok va \
al ga ma nd or vt \
ar hi md ne pa wa \
az ia me nh ri wi \
ca id mi nj sc wv \
co il mn nm sd wy \
ct in mo nv tn \
dc ks ms ny tx \
de ky mt oh ut 

fitnr

Dasymetric Dot Density Mapping for MCNY

All of the code you need to reproduce it is in this gist. You will need to create both the weighted_dot_density.sql and select_random_weights.sql functions in your Carto account (just copy and past them in to the SQL terminal) 

Then you run the query once for each ethnicity which gives you 4 tables with dot density in each for each ethnicity. Oh and after you run the create table queries you need to run 

select cdb_cartodbfytable('account_name', 'table_name') to have it show up in your datasts

You can then ether union them together to make one table or just create 4 layers on the map. You will want to do this through the batch API, I can help you write some scripts to do that if you like. Also the batch API docs are here:

fitnr

fitnr

curl http://api.census.gov/data/2014/acs5/variables.json |
  jq -r '[ .variables | to_entries[] | .value.concept ] | unique[]'
  > tables.txt

fitnr

First, install svgis and breaks. They require some hefty prerequisites. sorry. The last step requires ImageMagick.

brew install gdal numpy scipy # os x
apt-get install python-numpy python-scipy gdal-bin # linux
pip install svgis breaks

Download get-tiger. Optional: edit it to include the Census data fields you desire.

fitnr

fitnr

# make it easier to log in later
ssh-keygen -t rsa -b 4096 -C ec2-user
cat ~/.ssh/id_rsa.pub

# install useful stuff
sudo yum -qy update
sudo yum -qy install git gcc-c++ make mutt zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gdbm-devel db4-devel libpcap-devel xz-devel libjpeg-devel

# install node
curl -s -O https://nodejs.org/dist/v4.2.3/node-v4.2.3.tar.gz

fitnr

# git-ics
# Place in your $PATH (e.g. ~/bin)
# Accepts any options that can be passed to git log
# usage: git ics [opts] > cal.ics

echo BEGIN:VCALENDAR
echo METHOD:PUBLISH
echo VERSION:2.0
echo PRODID:-//git-ics//git-ics//EN
echo CALSCALE:GREGORIAN

fitnr