Development Log Historical Projects 1997 - 2022

The Development Log provides an record of large-scale development projects occurring in the City of Cambridge. The Log, updated on a quarterly basis, is distributed to City departments and the public to keep them posted about development progress, from permitting through construction to completion. The Historical Projects table include information about projects completed prior to 2023. The table includes general project information, such as development status and statistics related to the entire project. Limited information is available projects completed prior to 2011.

Since a project may include more than one use, data on each specific use found within a project is found in the associated Project Use table found here: https://data.cambridgema.gov/Planning/Development-Log-Historical-Projects-Use-Data/r5mv-isth.

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/development-log-historical-projects-1997-2022-a5ud-8kjv\".\"development_log_historical_projects_1997_2022\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.