Development Log Current Edition 2024 Q2

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 table includes general project information, such as development status and statistics related to the entire project. The Current Edition table lists all developments found in the last published edition of the Log, whose status range from In permitting to Complete in the then current calendar year. For projects completed in earlier calendar years see https://data.cambridgema.gov/Planning/Development-Log-Historical-Projects-Use-Data/r5mv-isth

Since a project may include more than one use, data on each specific use found within a project is found in the associated Development Log Project Use table. Found here: https://data.cambridgema.gov/Planning/Development-Log-Current-Edition-Project-Use-Data/5nqm-2ns2

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-current-edition-2024-q2-wjwg-93qh\".\"development_log_current_edition_2024_q2\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.