cambridgema-gov/development-log-historical-projects-1997-2021-a5ud-8kjv
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 3 months ago
Indexed 1 hour ago

Development Log Historical Projects 1997 - 2021

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 2022. 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-2021-a5ud-8kjv\".\"development_log_historical_projects_1997_2021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • development_log_historical_projects_1997_2021
     
     
     
     
     
Upstream Metadata