Development Log MapLots 2011 to Present

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. A separate Development Log table includes general project information, such as development status and statistics related to the entire project.

The MapLot Table provides location information used by the Cambridge Assessing Department for all developments found in the last published edition of the Log, whose status range from In Permitting to Complete in the current calendar year, as well as any completed since 2011.

For more information concerning current projects see https://data.cambridgema.gov/Planning/Development-Log-Current-Edition/wjwg-93qh For completed projects found here see https://data.cambridgema.gov/Planning/Development-Log-Historical-Projects-Additional-Det/5432-hmix

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-maplots-2011-to-present-p7te-amec\".\"development_log_maplots_2011_to_present\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.