Development Log Historical Projects Additional Details 2011 - 2022
The Development Log provides a 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 Detailed Historical Projects table include information about projects completed from 2011 to 2022. In addition to the general project information found in the Historical Projects table, more detailed data is available such as the number of affordable housing units and parking spaces.
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-additional-5432-hmix\".\"development_log_historical_projects_additional\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.