Resident Workforce Commuting Mode Split by Place of Residence: 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 Resident Workforce in the City of Cambridge. 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 recent versions of the CTPP compiled from the American Community Survey. The Cambridge resident workforce are those people who both live and work in Cambridge. The figures reported here are based on the home locations of these workers, not their work locations.

For more information on Journey to Work data in Cambridge, please see the full 2015 report: (https://www.cambridgema.gov/~/media/Files/CDD/FactsandMaps/profiles/moving_forward_20150930.ashx?la=en).

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/resident-workforce-commuting-mode-split-by-place-4wd7-ic9p\".\"resident_workforce_commuting_mode_split_by_place\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.