Skip to content

Instantly share code, notes, and snippets.

@fitnr
fitnr / README.md
Last active November 8, 2016 16:20 — forked from stuartlynn/query.sql

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:

Custom Twitter Stylesheet

Craig Mod does a bigger overhaul with Twitter for Minimalists, but this will only do the following:

  • Hides promoted tweets and trends
  • Hides the useless “Expand” link that appears under every tweet
  • Tones down the blue conversation line to a barely-visible gray

You can add this CSS in Safari with this extension. The URL to target is twitter.com/*.