Workforce Commuting Mode Split: 1990, 2000, 2006 - 2010, and 2012 - 2016
This data set compares 1990, 2000, 2006 - 2010, and 2012 - 2016 Journey to Work data, outlining the modes of commuting for the Workforce in the City of Cambridge, regardless of home location. The data set originates from three sources: 1990 Journey to Work data supplied to the Massachusetts Central Transportation Planning Staff by the Census Bureau, a special tabulation of 2000 Decennial Census data - the 2000 Census Transportation Planning Products (CTPP), and the most recent versions of the CTPP compiled from the American Community Survey. The Cambridge Workforce consists of all persons who work in Cambridge, regardless of place of residence.
For more information on Journey to Work data in Cambridge, please see the report Moving Forward: 2020 - https://www.cambridgema.gov/-/media/Files/CDD/FactsandMaps/profiles/demo_moving_forward_2020.pdf
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"cambridgema-gov/workforce-commuting-mode-split-1990-2000-2006-2010-eae8-5e88\".\"workforce_commuting_mode_split_1990_2000_2006_2010\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.