Building Permits: Commercial and Multi-Family Buildings - DEPRECATED

This dataset has been deprecated and replaced by two new building permit datasets:

Building Permits: Addition/Alteration

https://data.cambridgema.gov/Inspectional-Services/Building-Permits-Addition-Alteration/qu2z-8suj/data

New Building Permits

https://data.cambridgema.gov/Inspectional-Services/New-Building-Permits/9qm7-wbdc/data

Description for Deprecated Dataset:

Approved building permits for commercial buildings and multifamily homes. The PLANNUMBER column uses "BLDC" to indicate commercial buildings and "BLDM" to indicate multifamily homes. Building permits are issued to licensed construction supervisors and enable recipients to construct, alter, or demolish a structure or install a sign. The building permit must be obtained from Cambridge's Inspectional Services Department before the start of any work and must be prominently posted at the job site. This dataset includes building permits for the construction of renovation of commercial buildings.

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/building-permits-commercial-and-multifamily-24a8-ex6a\".\"building_permits_commercial_and_multifamily\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.