Using Cascalog to build an app with City of Palo Alto Open Data

Paco Nathan (Databricks)
Location: Portland 255

As new data sets become available through municipal Open Data initiatives, how can these be leveraged to reveal insights and build services for communities? This talk shows an open source project based on the City of Palo Alto “Open Data Platform”, demonstrating how to work with public GIS data available there for parks, roads, trees, etc.

Starting from the raw data, we review simple techniques for discovery and modeling, then use Cascalog, Hadoop, and R to structure the GIS export into data products and accompanying visualizations. The end result creates a data service for a mobile app: “Find a shady spot on a summer day in which to walk near downtown Palo Alto. While on a long conference call. Sipping a latte or enjoying some fro-yo.” Extensions to the app incorporate other data sources to provide insights for the community: for example, monitoring invasive vs. endangered species, or the proximity of toxin-producing species near day-care centers.

Cascalog is an open source project from Twitter authored by Nathan Marz, Sam Ritchie, et al., which integrates the Cascading open source API into the Clojure language. Contributions, sample apps, and case studies have been published by a number of organizations including Climate Corp, REDD Metrics, YieldBot, Nokia Maps, Factual, Harvard School of Public Health, etc. This talk includes code and data, but also explores the process of approaching Open Data from the perspective of developing a data product—from start to finish. Cascalog functions are typically only a few lines long, so the code involved is brief and simple to grasp.

The talk also explores simple practices for test-driven development with large-scale data workflows based on unique features in Cascalog. We also touch on CS theory, going all the way back to the original “relational model” paper by Edgar Codd to discuss some of the unique properties of Cascalog. These aspects are useful for a wide range of data-driven apps.

This example app project began as a seminar at CMU West, showing students examples of how to work with the Palo Alto Open Data initiative, plus how to leverage open source tools for Big Data. The intended audience needs some exposure to programming, but the focus is mostly on process: understanding how to approach large-scale data. This project is also used as a case study in “Enterprise Data Workflows with Cascading”, an upcoming O’Reilly book.

GitHub repo for the open source project (code + wiki):

City of Palo Alto Open Data portal based on Junar (open data):

Slides from Open Data Bay Area meetup (also 40 minute format):

Cascalog project:

Photo of Paco Nathan

Paco Nathan


Director of Data Science at Concurrent in SF, and a committer on the Cascading open source project. 10+ years leading innovative Data teams, 25+ yrs in tech industry overall. Background in math/stats and distributed computing. Expertise in Hadoop, R, AWS, predictive analytics, machine learning, and NLP. O’Reilly author: “Enterprise Data Workflows with Cascading”.


Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at (707) 827-7065 or

Contact Us

View a complete list of OSCON contacts