Wednesday, December 3, 2014

Free Stuff in Dallas (OpenLayers and PostGIS in QGIS)

Choropleth of Dallas Neighborhoods: A Generosity Index
The numbers are the raw counts of posts by neighbors giving away things for free.

NYC Nextdoor Membership Snapshot (PostGIS, QGIS and Sketch)


I would do this very differently if I had to do it again. Staten Island and The Bronx exist, I swear!
Big shout out to Ryan Sims who helped polish this.

Torque in CartoDB

Goofy test showing the growth of Nextdoor in Houston (made with CartoDB). Not a winner.


Fun with TileMill


A colorful sample of New Orleans neighborhoods made with TileMill and Nextdoor neighborhood boundaries. All on a custom basemap driven by Natural Earth data by yours truly.

Static and Thematic (Cougar and Coyote Icons Designed in Sketch)


Cougar and Coyote Mentions in LA on Nextdoor
This is based on pure mentions. Parsing text with SQL is easy, measuring sentiment is still tough.